General Ledger Movements Report

16/07/2025
Knowledge

How To

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

Purpose: List of journals transferred to QuickBooks or Xero showing amounts entered on General Ledger Codes. It provides either a summary or detailed view of journal entries generated within LEAP and dated within 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.

It serves as an effective tool for monitoring the flow of financial transactions over a specified accounting period. You can also utilize the Export Status filter to cross-reference journal entries or amounts within the report with the data exported to the accounting platform (QuickBooks or Xero), thereby verifying the completeness of journal export.

Useful Resources: When a journal is created in LEAP, it will be displayed in the General Ledger Link window. Depending on the accounting basis, you may find journals created for various transactions and their reversals, including Invoices, Adjustment Notes, General Payment Received, and General Expense Paid, among other transactions. For the impact of accounting basis on journal creation, please refer to this article.

Click to edit heading

NOTE: 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.

Filters:

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

Report Fields:

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 (grouped by Accounts) or under each Tax code (grouped by Tax Codes):

Journal No: The General Ledger journal number.
Date: The date of the journal.
Journal Memo: Depending on the type of the underlying transaction, this column may display details such as the transaction number, date, amount, payment type, parties involved, memo, and more.
Debit: Debit amount of the entry, exclusive of tax.
Credit: Credit amount of the entry, exclusive of tax.

Last Modified Date

16/07/2025 1:07 am

Title

General Ledger Movements Report

URL Name

General-Ledger-Movements-Report-CA

Resolution