How to Perform the Bank Reconciliation Process in Acumatica

Bank Reconciliation in Acumatica

Bank reconciliation is the bread and butter of all accounting systems – one of the most basic functions that almost every business needs to perform. Businesses upgrade to an advanced ERP to streamline the accounts receivable and accounts payable processes as much as possible. If you’re new to Acumatica, or just want a refresher on reconciling bank transactions, we’ve detailed the process here:

First step: import the transactions

First, go to the Import Bank Transactions screen.

Bank Reconciliation Process

Click on the “+” sign.

Bank Reconciliation Process

Select the cash account you’d like to use (1 below).

Set the statement date (2).

Upload the file of the transaction (3).

Correct the ending balance, if it is not correct (4).

Bank Reconciliation Process

Click “Save & Close.”

Bank Reconciliation Process

Second step: process bank transactions

Next, go to Process Bank Transactions.

Select the same cash account.

Bank Reconciliation Process

Click Auto-Match (1) and review the transactions that the system auto-matched. Then, click Process (2) to process the transactions that are checked or check any that you have matched manually.

Go to Reconciliation Statements screen.

Bank Reconciliation Process

Click the “+” sign.

Select Cash Account.

Bank Reconciliation Process

Select the correct Reconciliation Date (1). Then, enter the bank statement ending balance (2).

Bank Reconciliation Process

Click Reconcile Processed. This will reconcile all the transactions that were auto-matched in the Process Bank Transactions screen.

If you still show a difference, you will then need to reconcile any transactions that were not auto-matched manually by clicking on the Reconciled checkbox as shown below until you come to a zero difference.

When you have completed your Reconciliation, you will uncheck the Hold check box (1) and click Release (2).

You have now completed your Bank Reconciliation in Acumatica. To help with all your AP and AR processes, Crestwood has created a slate of add-on products. Join us for a monthly quick demo of the various add-ons and how they can shave huge chunks of time off of your work load!


Leave a Reply