General Ledger Movements Report

27/06/2025
Knowledge

How To

Location: LEAP Menu > Reports > Office > General Ledger Movements

Purpose: Downloads a summary or detailed list of general ledger journals exported to accounting software for a specified period. The report offers options to refine results according to Export Status, General Ledger Account or Tax Code, while also providing the flexibility to group results by either Accounts or Tax Codes.

The report serves as an effective tool for monitoring the flow of financial transactions over a specified accounting period. You can utilise the Export Status filter to cross-reference journal entries or amounts within the report against those exported to Xero or MYOB, helping verify the completeness of journal export.

Click to edit heading

The figures within this report are derived from records in the General Ledger Link window. Therefore, any manual adjustments made to journal figures from the General Ledger Link may impact the results of this report.
Depending on your firm's accounting basis, you may find journals created for various transactions and their reversals, including Invoices, Adjustment Notes, Office Receipts and Office Payments, among other transactions. For the impact of accounting basis on journal creation, please refer to this article.

Filter:

Date Range	Displays all journals dated within the selected period. NOTE: The date of a journal entry is the date of the underlying transaction for which the journal entry is generated. It may not always align with the date of the journal entry's creation, especially in the case of a backdated transaction.
Exports Status (Detail Only)	Exported: Displays journals that have been successfully exported to the third-party accounting application. Hold: Displays journals currently marked with a status of 'Hold'. All: Displays journals of all statuses. NOTE: This filter is only applied when Display Summary is set to No. If Display Summary is set to Yes, the report shows a summary based on all journals, regardless of status.
Accounts	Refines results based on General Ledger Account.
Tax Codes	Refines results based on Tax Code.
Display	Includes two display options: Display Summary: No – Provides details by listing all relevant journal entries, for each General Ledger Code or each Tax Code, depending on whether you choose to group results by Accounts or Tax Codes. Yes – Provides only a summary showing the total Debit and Credit amounts, either for each General Ledger Code or for each Tax code, depending on whether you choose to group results by Accounts or Tax Codes. This option does not list individual journal entries. Group By: Groups the journals by: Accounts Tax Codes

Downloaded Report:

Summary

GL Code: Displays either General Ledger Account Code (grouped by Accounts) or Tax Code (grouped by Tax Codes).
Description: General Ledger Account Name.
Debit: The total Debit amount of all journals dated within the selected period, exclusive of tax.
Credit: The total Credit amount of all journals dated within the selected period, exclusive of tax.
Net Activity: Credit less Debit.

Detailed

Under each General Ledger Code (if grouped by Accounts) or under each Tax code (if grouped by Tax Codes):

Journal No: The General Ledger journal number.
Date: The date of the journal.
Journal Memo: Indicates the underlying transaction's type and reference number, such as 'LEAP receipt no 1', 'LEAP payment no. 3' and 'LEAP reversal receipt no. 4'.
Debit: Debit amount of the entry, exclusive of tax.
Credit: Credit amount of the entry, exclusive of tax.

Last Modified Date

27/06/2025 4:21 pm

Title

General Ledger Movements Report

URL Name

General-Ledger-Movements-Report-NZ

Resolution