Bank Account Setup and Testing

Use controlled processes and sound testing techniques to ensure that your bank account functionality is operating correctly.

Table of Content

    Processing bank transactions is an important company activity, as businesses receive and disburse cash and checks daily.

    Accurate and controlled cash processing is valuable in determining the company’s open Accounts Receivable (AR) and expected cash receipts, Accounts Payable (AP) check processing and upcoming cash obligations and in forecasting its cash position. Accurate and timely transaction processing and reconciliation can also play a role in reducing cash loss risk.

    To learn more about cash transaction processing and bank reconciliation look at Bank Transaction Processing and Reconciliation.

    Setting up a new bank account should follow a controlled request and approval process. New bank account requests should be assigned to specific individuals, usually the Controller or the CFO. In smaller organizations, the request may come directly from the CEO.

    Business Leaders Guide to Dynamics 365Business Leaders Guide to Dynamics 365

    Formal documentation of the new account request should be required to provide an audit trail of the account request and the subsequent bank account document review and approval processes.

    While the initial review and editing of bank documents can be completed in the accounting department, the final document review and approval must be completed by an authorized signatory per the banking agreements.

    Today’s ERPs offer several functionalities related to cash processing. Cash processing functionalities include streamlined cash receipt and application, electronic transaction tracking and automated bank reconciliations.

    On the bank’s end, technologies such as ECS, improved lockbox functionality, positive pay and the uploading and downloading of bank account transactions between the bank systems and the customer’s ERP have improved cash transaction processing.

    At the same time though, this increased interaction makes the relationship between bank systems and the ERP more complicated.

    This level of complexity requires that bank account set up is supported with sound testing techniques and controlled procedures. Bank account functionality testing at the beginning of the set-up process should be completed and validated as correct before the associated bank account is set to an active status.

    Examples of bank testing processes include:

    • ACH transactions
    • Checks processed
    • Positive pay files
    • Automated transactions (e.g., daily account sweeps)
    • ECS and deposit processing
    • Upload and download of bank transactions to the ERP

    Banks are eager to work with their customers to ensure that all banking-related transactions are functioning properly. Use your bank relationship manager as a testing liaison resource to provide testing support as required.

    Functionality, Measures and Alerts

    Measures and alerts are meant to assist the user in keeping abreast of processing status, identifying anomalies, and ensuring that implemented process controls are effectively employed. The information below illustrates the interaction between bank setup and testing tasks, measures, and alerts.

    Functionality- ERP Cash module

    Measures and Alerts-

    New bank accounts set up.

    Whenever a new bank account is set up in the ERP, an alert should be sent to the Controller and CFO. An alert should also be sent to another executive team member as an additional control.

    New bank accounts not set to an active status in x days.

    In most ERP’s, bank accounts can be set to an inactive or active status. This functionality can be used when setting up a new bank account.

    The accountant sets up the bank account in the ERP then sets it to an inactive status while any “loose ends” are tied up and functionality testing is finalized. A bank account remaining inactive for a period of time can indicate an issue with the account and its associated functionalities. Choose a period of time that is appropriate for your company. I’d recommend 30 days as the basis of the alert.

    The Controller or CFO should review the alert. If there are testing issues unresolved at the 30-day mark, an explanation of the remaining issues should be requested from accounting, and some additional actions may need to be taken to resolve the issues.

    Functionality- ERP Cash sub-ledger

    Measures and Alerts-

    Transactions posted directly to cash GL accounts from outside the Cash sub-ledger.

    There should be very few transactions posted directly to the Cash GL account from sources outside of the cash module. Most cash transactions are auto posted to the GL from activities such as AP check processing, AR customer payments received and bank transaction entry or uploads.

    Sometimes, GL journal entries are made in the cash GL accounts to record some type of a correction (usually a function of the bank reconciliation process). In most cases, these entries are valid.

    Business Leaders Guide to the New Digital AgeBusiness Leaders Guide to the New Digital Age

    However, the transactions may also indicate an issue with the cash account functionality itself. For example, if the bank transaction upload files contain information issues (e.g., incorrect transaction codes) or are missing any information required by the ERP, the transactions are either rejected or posted incorrectly. In either case, corrections will need to be processed. These errors are usually detected in the bank reconciliation and corrected at that time via a journal entry.

    The Controller or CFO should review the alert. The reviewer in turn will ask accounting to provide an explanation of the issues identified including any transaction processing issues.

    Measures and Alerts-

    System bank reconciliations not completed “N” days past period end.

    Timely bank reconciliations are important in effectively controlling the cash handling process. Bank reconciliations should be completed within 30 days of the period close.

    Automated bank reconciliation is standard ERP functionality, so there really aren’t any excuses for reconciliations not being completed in a timely manner.

    In the case of a new bank account, delinquent bank reconciliations can be an indication of processing issues delaying the reconciliation process.

    Again, the alert should be reviewed by the Controller or CFO, who in turn will ask accounting to provide an explanation as to the delay and any issues identified, including any transaction processing issues.

    Process Implementation Best Practices

    Successfully implementing a new process is not always easy. Consider the best practices below to streamline and control bank set up and testing processes.

    Understand the Process

    • Be sure that all bank setup documentation is organized, properly completed, and approved.
    • Be sure that a formal bank account testing process is documented including both company and bank tasks to be completed.
    • Build a formal bank testing worksheet to document issues, resolutions and any process changes required.
    • Define responsibilities for completing testing tasks. Work with the bank’s testing liaison and review the test plans with them. Gain a consensus.
    • Review the bank testing process and testing documentation with those assigned to complete the testing. This includes both accounting and bank personnel.

    Align Resources

    • Assign the testing team members. Team members may not only be limited to accounting. IT may also need to get involved to resolve any technical issues.
    • Be sure that all company executives included in the testing, review and approval processes are aware of their responsibilities and tasks required.
    • Assign bank testing tasks focusing on internal controls when possible. Try to segregate duties or be sure to have a strong test review and approval process in place.

    Improve the Process

    • Bank testing is different than bank transaction processing. If possible, complete the testing process in a test system.
    • Upon successful testing be sure the bank account configuration in the test system is consistent with production system settings.
    • Note any bank testing issues then update the process and testing documentation, as necessary.

    Process Communication

    When using a new accountant to complete the testing, be sure to include test process training prior to commencing the test. Assign a mentor from accounting to ensure that training happens. Use the mentor to review the process as it is being completed and to function as an experienced resource as required.

    Common System Permissions

    System permissions and security functionality play a vital role in any ERP process including testing. Using these ERP tools allows the user to set up efficient and controlled processes.

    Common bank account testing permissions examples are displayed in the table below:

    Screen View New Edit Delete
    Accountant (Test system)
    Bank account set up screen X X X NA
    Bank account transaction processing and posting X X X NA
    ERP file upload and download X X X NA
    Reviewers (Controller, CFO)
    Bank transaction testing worksheet X NA NA NA
    Measures and Alerts
    Company Executives
    New bank accounts set up (production system). X NA NA NA
    Banks set up and not set to an active status in x days. X NA NA NA
    Transactions posted directly to cash GL accounts from outside the cash sub-ledger. X NA NA NA
    System bank reconciliations not completed “N” days past period end. X NA NA NA


    Processing bank transactions in a timely and accurate manner is critical in supporting cash handling internal controls and cash planning activities. Efficient and accurate processing not only supports transaction control and cash planning, but it can also be a factor in reducing cash loss.

    Enabling the Modern Worker with the Microsoft PlatformEnabling the Modern Worker with the Microsoft Platform

    Use the testing tools provided by the bank and your ERP to be sure that bank transactions are being processed correctly.

    Remember, the basis of efficient and accurate cash processing is a correctly functioning and well tested ERP.

    Bank Account Setup and Testing

    The Right Microsoft Partner Can Drive Business SuccessThe Right Microsoft Partner Can Drive Business Success