You use this program to print a report of ledger account balances and detailed account activity.
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Report sequence | Indicate the sequence in which to generate the report. | ||||||
| Reporting currency | Indicate the currency in which to generate the
report. This does not apply when generating the report for Statistical account types. |
||||||
| Report type |
|
||||||
| Year selection |
|
||||||
| Group selection | Indicate the ledger group(s) for which to include ledger codes in the report. | ||||||
| G/L code selection | Indicate the ledger codes for which to generate the report. | ||||||
| Account types |
Indicate the account types to include in the report. If you select the Statistical account type then all other account types are automatically excluded from the report. |
||||||
| GL analysis | |||||||
| Include analysis entries |
Prints analysis entries for the ledger codes against which GL analysis information was captured. Indicate the analysis entries to include in the report on the Analysis Options tab. |
| Field | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Period selection | The Period selection does not apply to
a Summary report.
|
||||||||
| Ledger period | Indicate the ledger period for which to generate the report. This option only applies when printing a Summary report. | ||||||||
| Print interim closing balances |
Prints the closing balance for each period within each ledger account. This does not apply for a Summary report or when printing the report in Detail for the Current period only. |
||||||||
| List inactive accounts |
Prints accounts where the opening and closing balance is zero for the periods selected. The detailed report also lists accounts that have no detail transactions in the period(s) selected. |
||||||||
| Print summary page for current period |
This only applies to the GL Trial Balance report. Prints an account type breakdown at the end of the report if you are generating the trial balance for the Current period or the current Year-to-date. The company totals printed on the summary page are always as at the current ledger period. The forced balance account is excluded from the totals printed on this report and if not zero is indicated on the summary page. |
||||||||
| Print report and group summary pages |
This only applies to the GL Trial Balance by Group report. Prints an account type breakdown at the end of each group if you are generating the trial balance for the Current period or the current Year-to-date. The company totals printed on the summary page are always as at the current ledger period. The forced balance account is excluded from the totals printed on this report and if not zero is indicated on the summary page. |
||||||||
| New page per ledger code | Prints each ledger code on a new page. This does not apply when printing a Summary report. |
| Field | Description |
|---|---|
| Analysis number |
Indicate the analysis number(s) for which to include entries on the report. This number is assigned to the GL analysis entries using the Capture GL Analysis Entries program. |
| Code 1 to 5 |
Indicate the analysis codes (within each of the five analysis types) to include in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
Template account types are excluded from this report.
Accounts Payable check numbers are printed in the Reference column if they have been allocated.
System check numbers are only allocated at the time of printing the checks. If you did not select the option: Force check no (General Ledger Integration) then the GL journal is created at the time of running the Execute Payment Run option (Payment Cycle Maintenance) which is before system check numbers are allocated. This means that these will not be printed on the report. Manual check numbers will, however, have been allocated and will therefore be printed on the report.
For entries posted from a sub-module, the date against the transaction is the date when the transaction was posted to the General Ledger. The sub module transaction date is indicated on the Journal report in the relative sub-module.
*On hold* - this is printed above the ledger code when the Account on hold option is enabled against the ledger code (General Ledger Codes).
We recommend that you use the GL Trial Balance for Excel program to export the report to Excel. This is because the standard GL Trial Balance report outputs alphanumeric strings (not numeric values) when exporting to Excel.