Set up a view in the Trial Balance grid
Follow these steps to add a new trial balance view.
- SelectActions,Enter Trial Balance, thenView Maintenance.
- SelectAddto enable fields in the window to create a new trial balance view from scratch.
- By default, columns A through H have been defined. Select the row for Columns B through H to modify, as necessary.noteColumn A (Account Number) can't be changed.
- In the Column Type section, select 1 of the following types:
- Account Groupings
- Amount
- M-3 Tax Code
- Tax Code
- Tickmark
- The fields in the Column Definition section vary based on the Column Type that you selected. Select the appropriate definition settings for the Column Type. For example, when you selectAmountas the column type, you'll need to select anAmount type,Period,Year, and optionally choose to display debit/credit columns.
- When you're done assigning and modifying the columns that you want to appear in the trial balance view, selectEnter, thenDoneto return to theEnter Trial Balancescreen.note
- You can select an existing view from the available list and selectEditto modify it.
- You can transfer trial balance views between Accounting CS clients.
- TheEnter Trial Balancescreen displays the columns in the order listed in the grid in the Column Order section. You can add, delete, and change the order of the columns. If you make changes, you can selectResetto reset the view to the original default settings.
- TheEnter Trial Balancescreen opens with a tabbed view of all customized layouts for the client including the application's default layout. Select the tab of the trial balance that you want to display in theEnter Trial Balancescreen.
Tax view exampleThe following example is a popular tax view that you can set up in theEnter Trial Balancescreen.ColumnColumn Type/DefinitionAmount TypePeriodYearMark the Display separate debit/credit columns checkbox?A: Account Numbern/an/an/an/an/aB: Descriptionn/an/an/an/an/aC: Tax CodeMark the Include Unit Column checkboxn/an/an/an/aD: Amount(CY, Adjusted, C)AmountAdjustedCYCclearedE: Amount(CY, AdjustingJE, C)AmountAdjusted JECYCmarkedF: Amount(CY, Tax, C)AmountTaxCYCcleared