G/L Transactions Listing Report

To open this screen

Open General Ledger > G/L Reports > Transactions Listing.

Related tasks

Printing the 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 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. (Set posting consolidation on the G/L Accounts screen.)
• You can consolidate transactions after posting using the Consolidate Posted Transactions screen.

A consolidated transaction created during posting retains the posting sequence number on the G/L Transactions Listing, so the consolidated amount can be traced through the posting journal to the batch listings.

Transactions that are consolidated after posting are consolidated by fiscal period and source code, but not by posting sequence number. The description in this case is "Consolidated."

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 year and range of 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 periods.
• The period, source code, date, 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.

Related Topics