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 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.
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 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.
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.
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 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.