Salesforce

Trust Bank Reconciliation Report

« Go Back
Information
Click to edit heading

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

Purpose: Downloads previously finalized Bank Reconciliations, with the option of include or exclude presented items. 

Filters:

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


Report Fields:

Statement Balance as per Bank StatementDate: The date the Trust Account Bank Statement.
Amount: The Statement Closing amount as at the selected date.
AddUnbanked 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.
Outsanding 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 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. 
8/10/2025 7:55 PM
Trust Bank Reconciliation Report
Trust-Bank-Reconciliation-Reprint-Report-US
Image Gallery

Powered by