Trial Balance

General Ledger Menu -> Reports -> Trial Balance by Account -> Summary Report By 'Layout' -> Trial Balance

This report uses the same output format as the Trial Balance by Account except that the accounts selected to print are determined by preparing and choosing a Statement Layout.

A Trial Balance based on a layout can be useful to check the balance of several selected G/L Accounts at month end, such as Cash Clearing, Customer Deposits, Accounts Receivable, and Accounts Payable, by setting a layout with the account selection in Statement Layouts first as follows:

        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                                   THE RENTAL STORE
                                   STATEMENT LAYOUT REPORT

        LAYOUT#: M MONTH END ACCTS TO BE CHECKED

         SEQ#  ACCT#  DESCRIPTION                     SUB  PRINT  SKIP  +/-
         ----  -----  -----------                     ---  -----  ----  ---
         0001  1100   CASH - CLEARING                  1     P      1
         0002  1200   ACCOUNTS RECEIVABLE              1     P      1
         0003  2000   ACCOUNTS PAYABLE                 1     P      1
         0004  2050   CUSTOMER DEPOSITS                1     P      1

        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The prompts to generate a Trial Balance By Statement Layout are:

TRIAL BALANCE TYPE

Select one of the following format options to define the account selection:

• Click Account to generate the Trial Balance for all accounts in the range as outlined in Trial Balance by Account.
• Click Layout to generate the Trial Balance for the accounts defined in a selected Statement Layout.

The default displayed reflects the last type of Trial Balance that was run.

Statement Layout Trial Balance selection filters:

STATEMENT LAYOUT

Enter a code for a Statement Layout or select it from the drop-down list as setup in Statement Layouts.

FROM ACCOUNT NUMBER

Leave this field blank for the report to begin at the first account, or select a starting primary account from the G/L Account Search window.

This starting selection field always refers to the primary account number, and not the alternate account number.

TO ACCOUNT NUMBER

Leave this field blank for the report to end after the last account, or select an ending primary account from the window.

REPORT FORMAT

Select one of the following sort options:

• Select By Account box to sort the report by account number.
  e.g. Account# 4000 'Sales Revenue' will list 4000 Division 1 amount, followed by 4000 Division 2 amount, then 4000 Division 3 amount, before the next account number is listed.

• Select By Division to sort the report by division.
  e.g. All entries posted to Division 1 accounts will print first, then all entries posted to Division 2 accounts will print next.

• Select Consolidated to print only one total per account on the report.
  e.g. The amounts per division will be summed into one total per account.

DIVISION, "ALL" OR "SEL"

• To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
• Type ALL to include all divisions, in the report.
• Type SEL to select specific divisions or to select divisions by accounting region as outlined in Division Select By Region.

YEAR START DATE

Enter your firm's Fiscal Year Start Date.
This defaults from the Year Start Date used the last time the G/L was summarized in Summarize G/L for Financial Statements.

PERIOD START DATE

Enter the first day of the month or period.
This defaults from the Period Start Date used the last time the G/L was summarized in Summarize G/L for Financial Statements.

PERIOD END DATE

Enter the last day of the month or period.
This defaults from the Period End Date used the last time the G/L was summarized in Summarize G/L for Financial Statements.

REPORT TYPE

Select one of the following sort options:

• Select Summary to output the account information in a summarized format, providing only a total for each account/division.

• Select Detail to output the detailed account information listing each posted transaction in the period.

  SUBTOTALS BY DATE

  This prompt only applies to the detailed report.
  Uncheck this box to only print a subtotal at the end of each account.
  Check this box to also print a subtotal at the end of each date, for each account.

REPORT OPTIONS

This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

Finished?

Click ACCEPT to generate the report, or CANCEL to abort.

---

Topic Keyword: GLGL11