Trust Bank Reconciliation Report

17/03/2025
Knowledge

How To

Purpose: Downloads previously finalised Trust Bank Reconciliations for a selected bank account, with the option of include or exclude presented items.

Select a Trust Bank Account and a Statement Date to download the relevant Trust Bank Reconciliation.

Reports (BETA)
Reports

Location: LEAP Menu > Reports (BETA) > Trust > Trust Bank Reconciliation

Filters:

Bank Account	Select one account from the list of General Trust 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 of the trust bank statement. Amount: The closing balance of the bank statement as of the selected date.
Add	Add Unbanked Receipts: Trust cheque or cash receipts that have not yet been deposited at the time the bank reconciliation was saved (e.g., unbanked cheques or cash receipts). Outstanding Deposits: Trust bank deposits that have not been marked as reconciled in the bank reconciliation. Unreconciled Electronic Receipt: Trust EFT receipts that have not been marked as reconciled in the bank reconciliation. Reconciliation Withdrawal Adjustments: Withdrawal adjustments recorded in the bank reconciliation due to a LEAP payment not being entered in LEAP on or before the bank statement date. Note: These transactions appear on the bank statement but were not recorded in LEAP on or before the bank statement date.
Less	Less Unpresented Cheques/Payments: Trust payments that have not been marked as reconciled in the bank reconciliation. Unreconciled Receipts Reversed After Banking: Trust receipts that were deposited but later reversed and have not been marked as reconciled in the bank reconciliation. Reconciliation Deposit Adjustment: Deposit adjustments recorded in the bank reconciliation due to a LEAP receipt not being entered in LEAP on or before the bank statement date. Note: These transactions appear on the bank statement but were not recorded in LEAP on or before the bank statement date.
Reconciled Cashbook Balance	Statement Balance: The bank statement balance after accounting for reconciled receipt transactions and deducting reconciled withdrawal transactions.
System Cashbook Balance	System Balance: The total transactions recorded in the system for the bank account as of the statement date.
Variance	Cashbook Variance: The difference between the Reconciled Cashbook Balance and the System Cashbook Balance. Note: This variance should always be 0.
Presented Items in Last Bank Rec	Presented items from the last bank reconciliation.

Location: LEAP Menu > Reports > Trust > Trust Bank Reconciliation

Filters:

Bank Account	Select the relevant account from the list of General Trust Accounts.
Inc. Presented Items?	Choose whether to include presented items in the download.
Statement of	Narrow down previously finalized 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.

Report Fields:

Statement Balance as per Bank Statement	Date: The date the Trust Account Bank Statement. Amount: The Statement Closing amount as at the selected date.
Add	Unbanked Payments Received: Trust Funds Check/Cash Payments Received that require banking (E.g. unbanked Checks or Cash payments received), at the time the Bank Reconciliation was saved. Outstanding Deposits Unreconciled Electronic Payments Received: Trust 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 figure but should be a positive figure.
Less	Unpresented Checks/ Payments: Trust Funds Payments that have not been marked as reconciled on the Bank Reconciliation. Unreconciled Receipts Reversed After Banking: Banked Trust 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.

Last Modified Date

17/03/2025 1:28 pm

Title

Trust Bank Reconciliation Report

URL Name

Trust-Bank-Reconciliation-Report-NZ

Resolution