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
Banks > Bank accounts > Add Statement Data
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
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.