Skip to main content

Bank statement batches overview

An overview of Bank Statement Batches in AccountsPrep.

AutoEntry Support Team avatar
Written by AutoEntry Support Team
Updated over 2 weeks ago

Bank Statement Batches allow you to import/enter bank statement data.

See below how to add this data and process it in AccountsPrep.


Where to add Bank Statements data

There are many ways to access the Add Bank Statement Data page in AccountsPrep, but here are two ways from the Banks tab:

Banks > Bank Statements > Bank account > Add Bank Statement Data

Click -Add statement Data- from the Bank accounts section.

Banks > Bank accounts > Add Statement Data

Click -Add Statement Data- from the Bank statements section.


Add statement data options

The Add Bank Statement Data page offers three options to choose from.

  • Import scanned data previously uploaded to your AutoEntry account

  • Import directly from CSV

  • Enter data directly on-screen

You can select one of three options to add your statement data.


Processing

Whatever option you choose to add your data, you need to code and process your transactions before you can post them.

Fast coding: You can fast code your transactions to process them all at once if they have the same details.

Splitting transactions: If you need to split a payment/receipt amount between two or more accounts, visit our guide showing how to split transactions.

Cheques and deposits: If you also want to use the cheques and deposits feature, you need to upload your cheques before you post your bank statement batches. You’ll then be able to match your transactions with outstanding cheques while processing your bank statement. For more information, visit Matching Bank Statement Data with Cheques to Reconcile.

Transfers: If a transaction is going to or from another bank account in AccountsPrep, you’ll need to follow the bank transfer process. This will allow you to match the transactions and avoid duplication.


Checking the Accuracy of Bank Statement Data

After posting a bank statement batch, you can use the following reports to review your data:

Journal Summary Report

After you post an entry, it will create a journal in the background based on the tax code default ledgers.

Bank Statement report

You can check the Bank Statement report to ensure it's consistent with the actual bank statement.

Bank Reconciliation report

You can view the Bank Reconciliation report to check the statement balance.

📌TIP: If the balance is out, make sure the opening bank statement balance is correct.

Did this answer your question?