Printing the G/L Trial Balance Report

This report prints a trial balance report or worksheet that lists selected account balances for a specified fiscal period. Print it at the end of accounting periods, when you are ready to calculate adjusting entries.

  • Select printing destinations and, if necessary, turn on and connect the printer.
  • Update account information by entering, retrieving, and posting batches.
  • Decide whether to list accounts by account number, by segment, by account group, or by account and group (Account Sorted Group).
  • Decide whether to include accounts with no activity during the report period.
  • If you have provisionally posted batches, decide whether or how to include provisional data.
  • Decide whether to use rolled-up amounts.

    Note: If you include rolled-up amounts, the debits and credits on the report may not balance if any account is a member of more than one rollup group.

To print the Trial Balance report:

  1. Open General Ledger > G/L Reports >  Trial Balance.

  2. Select the report format. More...

    You can select:

    • Report. Shows the difference between the total debits and total credits for each or the accounts listed.
    • Worksheet. Trial balance report plus columns for manually entering income statement, balance sheet, and adjustment debits and credits.
    • Quantity Report. Trial balance report plus columns containing quantities and the unit of measure for each account listed.
    • Provisional Quantity. Trial balance report plus columns containing quantities and the unit of measure for each account listed. Figures include any provisionally posted amounts and quantities.
    • Provisional Included. Trial balance report where the amounts include any provisional postings.
    • Provisional Separate. Trial balance report plus separate columns showing provisionally posted amounts.
    • Provisional Worksheet. Trial balance report plus columns for manually entering income statement, balance sheet, and adjustment debits and credits. Figures include any provisionally posted amounts.
  3. In the Print field, select the type of report to print.

    You can select Balances as of Year/Period or Net Changes for the Period. If you selected Worksheet or Provisional Worksheet as the report format, you must print Balances as of Year/Period.

  4. In the For Year/Period field, select the period end for the report.

    Note: If you are printing a Net Changes report, you specify a range over which to compare balances.

  5. Use the Sort By fields to specify how to sort information on the report. More...

    You can select:

    • Account Number. Lists accounts, in order, by account number.
    • Segment. Lists accounts in order by the segment you specify. This is usually the best choice if printing reports by department or region.
    • Account Group. Lists accounts by the account groups to which they are assigned.
    • Account Sorted Group. Lists accounts by the account sorted group.

      Note: You must select the Select Account Groups by Sort Code Range option (below the Sort By options) before you can select the Account Sorted Group option.

  6. If you want to list accounts that have zero balances and no postings in the current year, select Include Accounts With No Activity.
  7. To print amounts and quantities for a rollup account, rolling up its member accounts into a single amount or quantity, select Use Rolled Up Amounts.

    Note: The debits and credits on the report may not balance if any account is a member of more than one rollup group.

  8. If you are printing net changes for the period and you do not want to include totals for net income or loss in your report, clear the Include Net Income (Loss) Total for Listed Accounts option.

    Note: Skip this step if you are printing a worksheet or a provisional worksheet.

  9. Specify whether to order the report by account number, segment, account group, or account sorted group, or optional field, and specify a range of accounts in that order.
  10. Specify the range of accounts, segment codes, account groups, account-sorted group, and optional fields you want to print.
  11. Click Print.