G/L Trial Balance Report

Sage 300 ERP

Home > Screen Guides > Reports > Trial Balance

G/L Trial Balance Report

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

Overview

The G/L Trial Balance report prints the balance for each account in the range of accounts, segments, account groups, account-sorted groups, or optional fields in the general ledger as of the fiscal period you specify.

Report Formats

You can print seven different trial balance report formats. More...

  • Report. Shows net total debits and credits (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.

The report format is a single-spaced listing of the accounts and their balances.

The worksheet format is a double-spaced listing of General Ledger accounts, including columns for you to make the adjusting entries.

Tip: The worksheet format is particularly useful at month end and year end.

You can also print a shorter version of the report or worksheet that omits accounts with no activity.

Note:
  • The Provisional formats are available only if the Allow Provisional Posting option is selected on the Posting tab of the G/L Options screen.
  • The Quantity Report format is only available if the Maintain Quantities option is selected on the Account tab of the G/L Options screen.
  • All reports except worksheets can be printed with balances as of year/period or net changes .

Information Printed on This Report

The following information is printed on the report:

  • The fiscal period and range of accounts, segments, account groups, or account sorted groups you chose to print.
  • The ordering of the report (either by account number, segment, account group, or account sorted groups).
  • Debit and credit account balances in separate columns.
  • Additional columns on the worksheet for manual adjustments when you are preparing financial statements.
  • The total debits and credits for all accounts listed on the report, and the amount by which the report is out of balance (if you printed a range of accounts).
  • The amounts and quantities (if applicable) of a rollup account and all of its rollup member accounts (at any level), rolled up into a single amount or quantity. (Rollup member account amounts are included only once in the rolled up amounts.)
  • The net balance of all revenue and expense accounts included on the report, stated as Net Income (Loss) For Accounts Listed. If you include all revenue and expense accounts, the figure will be the net income to date.
Related Topics