We moved!
Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!
Use the View Maintenance dialog to add, edit, or delete trial balance views.
Choose Actions > Enter Trial Balance, and click the View Maintenance link at the top of the screen.
Notes
- The Actions > Enter Trial Balance screen opens with a tabbed view of all customized layouts for the selected client, including the application's default layout. Click the tab of the trial balance that you want to display in the Actions > Enter Trial Balance screen.
- The default view and view maintenance options for consolidated master clients are different from those in a standard client.
Fields & buttons
Select a trial balance layout from the list to add, edit, or delete.
Enter up to 30 alphanumeric characters for name of the selected trial balance view.
The trial balance view is displayed based on the order that is selected in the grid. Highlight the column in the grid to modify, copy, or delete it.
Note: Column A: Account Number and Column B: Description are defined by default and cannot be deleted.
Use the below the Column grid to modify how the columns are displayed in the view.
Button |
Function |
|
Copy the attributes of the currently selected column to a new column in the grid. |
|
Remove the selected column from the grid. |
|
Move the selected column up in the list. |
|
Move the selected column down in the list. |
Filtering the definitions for the Account Number column
When Column A: Account Number is selected in the column grid, click one of the following account types to include in the view.
- All
- Core Only
- Segment Only
- Segments (click the Ellipsis button to filter for segments)
Note: If you want to apply segment filters for Account columns in the trial balance view, be sure to click the Core Only option.
The fields in the Column Definition section vary based on the selection in the Column Type section.
Column Type |
Column Definition |
Account Groupings |
Grouping type field. Select the applicable account grouping from the drop-down list. The list includes the Account Classification and Leadsheet Schedule groupings and any additional account groupings that have been set up for the client in the Setup > Account Groupings screen
Include subcode column checkbox. Mark to include a subcode column in the Trial Balance grid.
|
Amount |
Heading. Add an optional heading to apply to the amount columns in the trial balance view.
Select an .
Note: The period and year column options vary based on the client's processing frequency. For example, a monthly client will have period options through C11 / CP-11. The years available for selection depend on the number of prior years of data available for the client.
Amount type |
Period |
Year |
Adjusted
Adjusted Budget
Beginning Balance
Budget 3-5
Other
Other JE
Potential JE
Reclassifying JE
Report
Tax
Tax Adjustment JE
Transactions
Unadjusted
|
[CP] Current Period
[CY] Current YTD
[C1-C12] Period 1 - 12
[CP-1] 1 period ago
|
C Current Year
1P Prior Year
|
Mark the Display separate debit/credit columns checkbox if applicable. |
Segments. Click the Ellipsis button to open the Segment Selections dialog. Mark the checkbox next to segments that you want to appear in the trial balance view for the selected amount column.
Note: To apply segment filters to the Account columns in the trial balance view, be sure to click the Core Only option in the Column Definition section when Column A: Account Number is selected.
|
M-3 Tax Code |
Select this option to create an M-3 tax code column in the trial balance view. After you save the view and return to the Trial Balance grid, you can apply M-3 tax codes to individual or multiple accounts at the same time via the Assign Codes dialog dialog. To access this dialog, right-click in the Enter Trial Balance screen, choose Edit Multiple Accounts, select Assign codes in the Edit Multiple Accounts dialog, and then click Enter. |
Tax Code |
After you save the view and return to the Trial Balance grid, you can apply tax codes to individual or multiple accounts at the same time via the Assign Codes dialog. To access this dialog, right-click in the Enter Trial Balance screen, choose Edit Multiple Accounts, select Assign codes in the Edit Multiple Accounts dialog, and then click Enter.
Include Unit Column checkbox. This checkbox is used for exporting data to a tax application, such as UltraTax CS. If you for the client, you can mark this checkbox to add a Tax Unit column in trial balance view.
|
Tickmark |
Select the applicable .
Note: The period and year column options vary based on the client's processing frequency. For example, a monthly client will have period options through C11 / CP-11. The years available for selection depend on the number of prior years of data available for the client.
Period |
Year |
[CP] Current Period
[CY] Current YTD
[C1 - C12] Period 1 - Period 12
[CP-1] 1 period ago
|
C Current Year
1P Prior Year
|
|
Workpaper Reference |
Select the applicable .
Notes
- The period and year column options vary based on the client's processing frequency. For example, a monthly client will have period options through C11 / CP-11. The years available for selection depend on the number of prior years of data available for the client.
- When you add a Workpaper Reference in the Trial Balance view, you can click the Ellipsis button in the Workpaper Reference column to open the Insert Workpaper Link dialog and insert a link to an existing engagement document in Workpapers CS.
Period |
Year |
[CP] Current Period
[CY] Current YTD
[C1 - C12] Period 1 - Period 12
[CP-1] 1 period ago
|
C Current Year
1P Prior Year
|
|