One of your options to add bank statement data in AccountsPrep is to import a CSV file.
Click the Bank tab.
Either click Bank Accounts or Bank Statements.
Click Add Statement Data.
Select the relevant Bank Account from the drop-down menu.
Click Import data using a CSV file.
Click Continue.
Under the first step on this page, download and populate one of the two CSV file templates provided.
CSV Template 1
CSV Template 2
📌TIP: Underneath them are the rules for importing and tips for completing the templates.
Once complete, under the second step click Choose file to upload or drag into the box.
Click Import.
If there are errors, you'll receive a prompt on what the errors are.
Once imported, you’ll find all your unposted transactions (including those imported) waiting to be coded to the general ledger.
Additional Information
Key things to know for coding bank statement data:
If there's a payment to (or receipt from) another account which is set up as a bank account, then you need to transfer match them
If there are payments which need to be reconciled/matched with outstanding cheques you can match the bank statement with the cheques
If there are receipts which need to be reconciled/matched with outstanding deposits, follow the same method as matching cheques but for deposits instead.
Checking the accuracy of bank statement data
After posting bank statement batches, you should check the Bank Statement report to ensure it's consistent with the bank statement from the financial institution
View the Bank Reconciliation report to check the statement is reconciled properly with the ledger
If there are inconsistencies, make sure that the opening bank statement balance was entered correctly