Trial Balance
General Ledger Menu -> Reports -> 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Then when Trial Balance By Statement Layout is run with Layout M in the example above, the Trial Balance will print for these accounts only.
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