Bank Balance Control Report

In this article:

• Brief Description  
• Use Cases 
• Finding and Using the Report  
• Available Filters 
• Report Output 

Brief Description  

The Bank Balance Control Report compares a current, unreconciled, bank statement balance against the last reconciled balance plus subsequent deposits, less subsequent withdrawals.  

Use Cases 

This comparison can be useful to find any discrepancies between the bank statement and the items or amounts entered in Actionstep.    

Finding and Using the Report  

• In Actionstep, go to Reports > Accounting Reports > Banking. 

Then, refer to these articles for help generating and saving reports for future use:

• Reporting Overview
• Generating a Report
• Saving a Report Configuration

Available Filters 

• Account: This drop-down list displays all non-trust bank accounts in the system. The selected bank account is the account against which the report will be run.
• Bank Statement Date: The Bank Statement Date controls which items are factored into the report output. It is an "as-at" date. This means it filters out items that are dated after the designated date to provide information that would be valid on the Bank Statement Date.
• Bank Statement Balance: The Bank Statement balance is the comparison balance for the report. It is compared with the previous reconciled balance, taking subsequent deposits and withdrawals into account. This should be your bank statement balance as of the Bank Statement Date.

Report Output 

• Opening Balance from Previous Reconciliation: Shows the opening balance from the previous reconciliation. The ID of that reconciliation is shown to the right.
• Plus Deposits: Shows the deposit amount from the previous reconciliation. This includes firm receipts and client receipts.
• Less Withdrawals: Shows the withdrawal amount from the previous reconciliation. This includes firm withdrawals and payments to supplier invoices.
• Closing Balance from Previous Reconciliation: Shows the closing balance from the previous reconciliation, which is the opening balance plus deposits less withdrawals.
  NOTE:  This information can also be seen by accessing the previous bank reconciliation (go to Accounting > Banking > Reconciliations) in the Reconciliation Detail section.
• Subsequent Deposits: Shows deposits created after the previous reconciliation but before the bank statement date.
• Subsequent Withdrawals: Shows withdrawals created after the previous reconciliation but before the bank statement date.
• System Balance at Statement Date: Shows the balance of the selected bank account as of the bank statement date.
• Statement Balance: Shows the amount entered as the Bank Statement Balance in the configuration options.
• Out of Balance: Shows the difference between the System Balance at Statement Date and the Statement Balance.