G/L Trial Balance Report

Overview

Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.

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.

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.