G/L Transactions Listing Report

Overview

The G/L Transactions Listing report lists the net changes, balances, and transaction details for accounts in a range of fiscal years and periods you specify.

When to Print

Print this report before consolidating posted transactions and before printing financial statements. You can view the same details (ordered and extracted by different criteria) with the source journals. Because posted transactions can be consolidated, this listing may not show all the details that were entered in batches.

Transactions can be consolidated during posting. (You set posting consolidation options on the G/L Accounts screen.)

Information Printed on This Report

The following information is printed on the report:

• Whether you included accounts with no activity (and no opening balance).
• Whether you printed adjustment entries or closing entries. (You can print these entries only if you are printing data from period 12 or 13—whichever is the final period of the year.)
• The order of the report: either by account number, segment, account group or account sorted group.
• The ranges of account numbers, segments, and account groups, or account sorted groups.
• The range of years and fiscal periods.
• The last year closed.
• The last posting sequence used. The sequence number identifies all transactions posted together. Each time you post transaction batches, the posting sequence number increases by 1.
• Any optional fields that were used with the transactions, if you chose to print optional transaction fields.
• Balances and net changes for each account over the selected period.
• Posting sequence and batch-entry numbers.

For each account, the report lists:

• The account number, description, and opening balance.
• Details posted to the account in the specified years and periods.
• The period, source code, posting date or document date (you specify whether the report includes document dates or posting dates), reference, posting sequence, batch number, entry number, and debit or credit amount.
• The net change for the account, and the period closing balance.
• If you chose Use Rolled Up Amounts, the report lists the transactions of a rollup account and all of its rollup member accounts (at any level), rolled up into a single amount for each transaction.

If you use multicurrency accounting, you can print amounts in both source and functional currencies (on letter, legal, or A4 paper sizes). You can also print the report in functional currency only. The report includes:

• Source-currency opening balances. For multicurrency accounts, the report lists the opening account balance in each source currency.
• Functional-equivalent figures.
• Functional-currency opening balances.
• Consolidated details. When the account is consolidated, a separate transaction is created for each currency, as well as for the other consolidation options (source code, fiscal period).
• Change in balance by currency. The report shows the change in the account balance in the last period specified, by source currency.