Salesforce

Trust Bank Reconciliation Report

« Go Back
Information
Click to edit heading

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

  • Reports (BETA)
  • Reports

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

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. 

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 DateFilter 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 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. 
3/2/2025 6:22 PM
Trust Bank Reconciliation Report
Trust-Bank-Reconciliation-Reprint-Report-US
Image Gallery

Powered by