GL Transaction Report

You can use the General Ledger Transaction report to list the transactions posted to the accounting ledgers and to show the detail that consists the totals and balances in the selected accounting periods. You can generate this report in two formats depending on your need.

By default, all report formats include the actual financial ledger, but reporting can also be done on financial data from other accounting books, ledgers, and budgets. It is possible to report data from selected accounts.

You can generate the GL Transaction in base currency or reporting currency. A further format is designed to report user-defined analysis data.

Option Notes
Accounting Entity This field shows the accounting organization. The field is auto-populated according to the subscription or country selection.
Accounting Year Select the start/end dates for the accounting year to be reported.
Accounting Period Select the start/end dates for the accounting period to be reported.
Ledger Account Select specific ledger accounts (GL Nominal account), or select all ledger accounts by selecting the first (from) and last (to) reference from the list.
Transaction Type Select the journal or transaction type. Transaction types provide a way to categorize transactions within a Transaction Designator, allowing for the calculation of various sub-balances on the account. Every transaction in the system is identified with a transaction type.
Accounting Book Type Select Actual or Budget or other grouping of accounting information from the list.
Accounts with zero balances Select whether accounts with zero balances will be included or excluded from the list. If you select Include, accounts with a zero value in all six columns must be excluded from the report.
Currency Select Base or Reporting.

Only one currency value at a time may be selected. The Currency Value used must be printed at the top of the report.

The output is sent to your email once the report request is submitted.

For the multi-country version of this report, see GL Transaction Report.