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:
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