Report: Trial Balance

The Trial Balance report lists any detail general ledger account that meets one or more of the following criteria:

The account had a balance on the selected report Begin Date.
Debit and/or credit activity occurred on the account during the selected time period.
The account had a balance on the selected report End Date.

This report is used most often to verify that total debits equal total credits in the accounting system (accounts are "In Balance"). It can also be used to help detect errors in the financial system and as a review prior to running the Balance Sheet and Income and Expense Reports.

Report Selections

What is this?

Reporting Period

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default option is Current Month to Date.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From List option.

Division

Choose One, Multiple or All (default) divisions.

The divisions appearing in the list are subject to division security. If All divisions are selected for printing, the report only includes reports belonging to divisions for which the user has security rights.

Division Consolidation Options

Group/Field	What is this?
Consolidated	Data for all divisions combined into one trial balance.
By Division	Data for each division reported separately.

Print Cover Page

Check this box to print a cover page with the report.

Description

Enter a description to print as part of the cover page.

Report Fields

Report Fields	What is this?
Division	Reports "All Divisions" in the report header when the consolidated option is selected, otherwise reports the individual division name.
Account #	General ledger account number.
Account Description	General ledger account number description (name).
Balance MM/DD/YYYY	The general ledger beginning balance before the report beginning date (total debit amounts - total credit amounts). MM/DD/YYYY represents the selected begin date of the report.
Total Debits	Sum of the total debit amounts for the general ledger number during the reporting period.
Total Credits	Sum of the total credit amounts for the general ledger number during the reporting period.
Net Activity	The general ledger total debit amounts - the total credit amounts during the reporting period.
Balance MM/DD/YYYY	The general ledger total debit amounts - the total credit amounts as of the report end date. MM/DD/YYYY represents the selected end date of the report.

CSV Columns

CSV Columns	Description
Division	Reports "All Divisions" when the consolidated option is selected, otherwise reports division name.
Account	General ledger account number.
Description	General ledger account number description (name).
BeginBalance	Sum (total debit amounts - total credit amounts) for the general ledger number before the report beginning date.
TotalDebits	Sum of the total debit amounts for the general ledger number during the reporting period.
TotalCredits	Sum of the total credit amounts for the general ledger number during the reporting period.
NetActivity	Sum (total debit amounts - total credit amounts) for the general ledger number during the reporting period.
EndingBalance	Sum (total debit amounts - total credit amounts) for the general ledger number at the report end date.