You use this program to print a report of ledger account balances and detailed account activity.
| Field | Description |
|---|---|
| Report sequence |
You can print the report in one of the following sequences:
|
| Reporting currency | Indicate the currency in which you want to generate the
report. This does not apply when you generate the report for Statistical account types. |
| Report type | |
| Detail | Prints a list of ledger account codes, balances and detailed entries against the account codes for the current year, or any prior year for which detail and summary history is held on file. |
| Summary |
Prints a list of ledger account codes and balances for any single period in the current year or prior year for which summary history is held on file. |
| Year selection | |
| Current year | Prints the trial balance for the period(s) you select for the current financial year. |
| Prior year | Prints the trial balance for the period(s) you select for a previous year. |
| Group selection | Indicate the ledger group(s) for which you want to generate the report. |
| G/L code selection | Indicate the ledger codes for which you want to generate the report. |
| Account types |
Indicate the account types you want 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. This option is only enabled if you are generating a detailed report. Select the analysis entries you want to include in the report from the Analysis Options tab. |
| Field | Description |
|---|---|
| Period selection | |
| Current period | Prints a trial balance for the current period only. |
| Year to date | Prints a trial balance for the current ledger year-to-date. |
| Range | Prints a trial balance for a range of periods (the default if printing a summary report, which cannot be changed). |
| Print interim closing balances |
Prints the closing balance for each period within each ledger account. This option cannot be selected if printing a summary report or if printing the report 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 |
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 balances 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, or when sequencing the report by group. |
| Field | Description |
|---|---|
| Analysis number |
Indicate the analysis number(s) for which you want to include entries on the report. This number is assigned to the GL analysis entries using the GL Analysis program. |
| Code 1 to 5 |
Indicate the analysis codes (within each of the five analysis types) you want 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 - General Ledger tab), 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 distribution report was generated in the sub-module (i.e. not the date on which the transaction was processed). The 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). This is not displayed when generating the report in Group sequence.
This error message is displayed if the e.net Browse does not exist for the table name displayed. Use the e.net Browse Setup program to add the browse for that specific table.