Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Trial Balance screen

Set up a view in the Trial Balance grid

Follow these steps to add a new trial balance view.
  1. Select
    Actions
    ,
    Enter Trial Balance
    , then
    View Maintenance
    .
  2. Select
    Add
     to enable fields in the window to create a new trial balance view from scratch.
  3. By default, columns A through H have been defined. Select the row for Columns B through H to modify, as necessary.
  4. In the Column Type section, select 1 of the following types:
    • Account Groupings
    • Amount
    • M-3 Tax Code
    • Tax Code
    • Tickmark
  5. 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 select
    Amount
     as the column type, you'll need to select an
    Amount type
    ,
    Period
    ,
    Year
    , and optionally choose to display debit/credit columns.
  6. When you're done assigning and modifying the columns that you want to appear in the trial balance view, select
    Enter
    , then
    Done
     to return to the
    Enter Trial Balance
     screen.
    Tax view example
    The following example is a popular tax view that you can set up in the
    Enter Trial Balance
     screen.
    Column
    Column Type/Definition
    Amount Type
    Period
    Year
    Mark the Display separate debit/credit columns checkbox?
    A: Account Number
    n/a
    n/a
    n/a
    n/a
    n/a
    B: Description
    n/a
    n/a
    n/a
    n/a
    n/a
    C: Tax Code
    Mark the Include Unit Column checkbox
    n/a
    n/a
    n/a
    n/a
    D: Amount(CY, Adjusted, C)
    Amount
    Adjusted
    CY
    C
    cleared
    E: Amount(CY, AdjustingJE, C)
    Amount
    Adjusted JE
    CY
    C
    marked
    F: Amount(CY, Tax, C)
    Amount
    Tax
    CY
    C
    cleared

This article applies to:

  • Product: Accounting CS, Workpapers CS
  • Subject: Chart of Accounts, Journal entries