Loading
Knowledge BaseClient Accounts Bank Reconciliation Report
Close
Search for help articles, community posts, ideas ...
End of Search Dialog

Client Accounts Bank Reconciliation Report

  • 24/08/2025
  • Knowledge

How To
Click to edit heading

Location: LEAP Menu > Reports > Client Funds > Client Accounts Bank Reconciliation

Purpose: Downloads previously finalised Client Account bank reconciliations for a selected bank account, with the option to include or exclude presented items.

Filters:

Bank Account Select one account from the list of Client Funds Bank Accounts.
Statement 
  • Statement of: Narrow down previously finalised reconciliations by choosing one of the following periods: 
    • Last 1 year
    • Last 2 years
    • All years
  • Statement Date: Filter the reconciliations by selecting a specific statement date. This list updates dynamically based on your 'Statement of' selection.
  • Include Presented Items?: Choose whether to include presented items in the download. 

Report Fields:

Statement Balance as per Bank StatementDate: The date the Client Account Bank Statement.
Amount: The Statement Closing amount as at the selected date.
AddUnbanked receipts:
  • Client Funds Cheque/Cash Receipts that require banking (E.g. unbanked Cheques or Cash receipts), at the time the Bank Reconciliation was saved.
Unreconciled Electronic Receipt:
  • Client Funds EFT Receipts that have not been marked as reconciled on the Bank Reconciliation.
Reconciliation Withdrawal Adjustments:
  • Withdrawal Adjustments recorded in the Bank Reconciliation, as the LEAP Payment was not recorded into LEAP on or prior to the Bank Statement date.

NOTE: In short, these transactions display on the Bank Statement and not in LEAP (on or before the Bank Statement date).

NOTE: The Adjustment currently displays as a Negative but should be a positive figure.
Less    Unpresented Cheques/ Payments:
  • Client Funds Payments that have not been marked as reconciled on the Bank Reconciliation.
Unreconciled Receipts Reversed After Banking:
  • Banked Client Funds Receipts that have been reversed and has not been marked as reconciled on the Bank Reconciliation.
Reconciliation Deposit Adjustment
  • Deposit Adjustments recorded in the Bank Reconciliation when the LEAP Receipt has not been recorded into LEAP on or prior to the Bank Statement date.

NOTE: In short, these transactions display on the Bank Statement and not in LEAP (on or before the Bank Statement date).
Reconciled Cashbook BalanceStatement Balance: 
  • Add Reconciled Receipt Transactions, Less Reconciled Withdrawal Transaction.
System Cashbook BalanceSystem Balance: 
  • Total transactions entered onto the system for the Bank Account, as at Statement date.
VarianceCashbook Variance: 
  • Reconciled Cashbook Balance Less System Cashbook Balance. 

Note: This should always be 0, otherwise there is a discrepancy. 
Presented ItemsDisplays Presented Receipts, Presented Cheques/Payments, Present Bank Deposits.
 
Click to edit heading

When reviewing the same bank account as of the same date, the reconciliation statement balance may not align with the Client Account Trial Balance.

    • This is because the Trial Balance report only includes transactions that have been entered in LEAP, whereas the reconciliation statement also accounts for unresolved items recorded in the reconciliation window as ‘Additions’ — transactions that appear on the bank statement but have not yet been entered in LEAP.
Last Modified Date
24/08/2025 9:59 pm
Title
Client Accounts Bank Reconciliation Report
URL Name
Client-Accounts-Bank-Reconciliation-Report-UK

Resolution
Reports
Loading
Client Accounts Bank Reconciliation Report