Client Accounts Bank Reconciliation Report

Apr 29, 2026
Knowledge

How To

Location: LEAP Menu > Accounting > 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 Statement	Date: The date the Client Account Bank Statement. Amount: The Statement Closing amount as at the selected date.
Add	Unbanked 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 Balance	Statement Balance: Add Reconciled Receipt Transactions, Less Reconciled Withdrawal Transaction.
System Cashbook Balance	System Balance: Total transactions entered onto the system for the Bank Account, as at Statement date.
Variance	Cashbook Variance: Reconciled Cashbook Balance Less System Cashbook Balance. Note: This should always be 0, otherwise there is a discrepancy.
Presented Items	Displays 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

29/04/2026 2:28 AM

Title

Client Accounts Bank Reconciliation Report

URL Name

Client-Accounts-Bank-Reconciliation-Report-IE

Resolution