You are here: General Ledger > GL Reports & Prints > Trial Balance Detail Ledger (GLR770)

Trial Balance Detail Ledger (GLR770)

Using reports

Use the Trial Balance/Detail Ledger program to print a trial balance or detail ledger for prior periods and the current period in the same report. You can specify as many closed periods as are stored in the yearly journal file set in the General Ledger Static Control F/M.

Report information includes:

Trial Balance: GL account number, description, period, beginning balance, activity and the resulting ending balance.

Detail Ledger: same Trial Balance information, but breaks down the activity by journal entry. Additional information printed on the detail ledger includes date of entry, journal number, entry number and memo.

NOTE: This report is always out of balance by the amount of retained earnings for the 1st period of the year.

FACTS Report Formatter and Multiple Output options

This report has access to the FACTS Report Formatterand Multiple Output option. The Multiple Output option allows you to print to more than one output for each instance of a report. For example, a report can print to Excel, the viewer, and to a printer all in one print run. To access the multiple output feature simply choose the Multiple option from the Print Options screen. The FACTS Report Formatter allows you to expand your reporting capabilities beyond defining a printer (in Printer F/M). For the Trial Balance/Detail Ledger, you can select Template>Select from the menu bar to associate a system template with Excel^{^®} export capabilities. To access the FACTS Report Formatter, select Custom Report Layout>Customize Report from the menu bar.

The total number of account numbers listed is also included.

An asterisk (*) on the report indicates the journal activity does not equal the account activity.

Ending balance calculations

Ending balance calculation use this process:

The amount entered in Account FM (GLF910) is used as the past-period ending balance. The account activity is based on the ending balance of the period minus the ending balance of the previous period. The Trial Balance Detail Ledger processing reads through the journal entries to calculate the journal activity. If the calculated balance, based on journal activity (the beginning balance plus journal activity) does not match the account activity, the ending balance now has an asterisk to denote this.

For current period activity, the ending balance on the Trial Balance Detail Ledger is the calculated amount from the journal entries plus the last closed period-ending balance, since the current period does not have an official ending balance. If the ending balance in Account F/M does not match the calculated ending balance, an asterisk is shown beside the ending balance.

For next period activity, the ending balance is calculated by taking the last closed ending balance and adding the current-period journal entries plus the next-period journal entries.

To access this program, click General Ledger> Reports & Prints>Trial Balance Detail Ledger.