Salesforce

General Ledger Movements Report

Printable View
« Go Back
Information
Click to edit heading

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

Purpose: 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'.

The report serves as an effective tool for monitoring the flow of financial transactions over a specified accounting period. Users 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, users may find journals created for Invoices, Adjustment Notes, Operating Payment Received, and Operating Expense Paid, among others. For the impact of accounting basis on journal creation, please refer to this article.

Filter:

Start Date and End Date

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) Display journals based on their status of exporting to the accouting platform:  
  • Exported: Journals successfully exported to the third party accounting application.
  • Hold: Journals that have a status of 'Hold'.
  • All: Journals with all statuses.
NOTE: The filter operates exclusively when the 'Display Summary' option is set to 'No'. When set to 'Yes', the report offers a summary derived from all journals.
AccountsRefines results based on General Ledger Account.
Tax CodesRefines results based on Tax Code. 
Display Summary 
  • 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. 
  • No – Further 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. 
Group ByGroups 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.
DetailedUnder 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: The General Ledger Memo. 
  • Debit: Debit amount of the entry, exclusive of tax.
  • Credit: Credit amount of the entry, exclusive of tax.
 
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 (before the journal's successful export) may impact the results of this report.

Report Example: 

User-added image

 

 
5/15/2024 10:21 PM
General Ledger Movements Report
General-Ledger-Movements-Report-US
Image Gallery
Powered by