Bank Reconciliation Automation – How to Easily Reconcile Bank Deposits in Acumatica – Part 1

This is the first in our 2-part series on bank reconciliation automation. Our customers often wonder about the best way to record bank deposits that include multiple checks. When it comes time for reconciliation of cash accounts with bank statements, it can be difficult to match up the individual payments going into a cash account with the summary amounts of the deposits on a bank statement. In Acumatica ERP, the use of a clearing account solves this issue. Customer payments are temporarily recorded to a clearing account. Before you make a physical deposit to the bank, you create a bank deposit in Acumatica and list within it all the payments and cash that make up the physical deposit.  When the bank deposit is released in Acumatica, the system generates a batch of transactions to move the payment amounts from clearing accounts to the bank account and to record the charges incurred as expenses. This lays the groundwork for our Bank Reconciliation Automation.

Configuring a clearing account

The clearing account is created on the Cash Accounts screen and linked to a GL Account of type Asset. This cash account can be configured for use with one more payment methods. Entry Types are used to specify the GL accounts for bank fees or other charges.

Entering customer payments

When a customer payment is received, you enter it into Acumatica on the Payments and Applications form and specify the payment method. Because the payment method is associated with a clearing account, you can select the clearing account in the Cash Account box. When the clearing cash account is selected, the system displays the Deposit After box on the form. This lets you specify the starting date when the payment can be added to a deposit and is useful should you receive a post-dated check.

Preparing a Bank Deposit

You prepare a bank deposit by using the Bank Deposits form.  You add payments and cash transactions to the deposit from the clearing account associated with the bank account.

Releasing the deposit

If needed you can print the Deposit Slip report, which lists the payments and the total amount of cash to be deposited.
Once the deposit is released, the system generates a batch of deposit-related transactions to transfer the payment amounts from clearing accounts to the bank account and to post the bank charges incurred for the deposit as expenses.

Handling Mistakes

The system does not allow you to void a payment on an unrelease deposit. If you need to void such a payment you can either:
  1. Delete the payment from the deposit and then void the payment  OR
  2. Release the deposit and then void the payment
​If unrelated payments have been recorded to the clearing account by mistake, remove the payments from the clearing account by voiding them and creating new ones with the proper cash accounts specified. To make it easier to create deposits, you should only assign the clearing account to those payment methods whose payments should be deposited to the respective bank account.

Bank Reconciliation Wrap Up

With these procedures in place, bank reconciliation will be a breeze! In part two, I will discuss more tips for an easier bank reconciliation:
  • How to import bank transactions electronically
  • How to auto-match transactions
  • Use of rules to automate the creation of transactions such as bank fees.
Find more Acumatica tips and tricks on our blog. 

Ready to Experience the Parallel Solutions Difference?

Contact us today and learn how we can support your business and provide the solutions and services it needs to achieve your goals.