View Maintenance dialog

Show expandable text

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

Description list

Select a trial balance layout from the list to add, edit, or delete.

Description

Enter up to 30 alphanumeric characters for name of the selected trial balance view.

Column Order

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
TB view copy button Copy the attributes of the currently selected column to a new column in the grid.
Delete TB button Remove the selected column from the grid.
Up arrow button Move the selected column up in the list.
Down arrow button 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.

Column type / Column Definition

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 amount type, period, and year.

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 set up units for the client, you can mark this checkbox to add a Tax Unit column in trial balance view.

When transferring data to a tax application, you can use a unit to designate the input screen location for entities with multiple units. To see an example, refer to the Example: Using tax codes to import general ledger balances into multiple-unit input screens topic in the UltraTax CS help.
Tickmark

Select the applicable period and year.

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 period and year.

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 Ellipsis button 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

Was this article helpful?

Thank you for the feedback!