After you import a bank statement into AccountsPrep, you need to code your transactions to allocate them to the ledger accounts. You can access the entries from the Unposted tab.
How do I access un-coded statement entries?
There are many ways you can access the un-coded entries:
From Bank > Bank statements > [bank name] > Statement batches > Unposted or Draft tab
From Bank > Bank statements > [bank name] > button "lines waiting to be coded"
From Bank > Bank reconciliations > [bank name] > button "lines unposted"
Coding
Once you're in the Unposted tab, you can edit and code the transactions:
Review the existing details
The import will fill in the Date, Details, Payments or Receipts automatically.
You can amend those details if needed.
To edit any entry, double-click within the relevant column.
📌TIP: You can select multiple lines to fast-code the same details to all transactions at once.
Add the missing details
Reference - This field is optional
Account - Make sure to select a category to be able to post the entry. If necessary, you can split a transaction to assign it to different categories or tax codes
Tag - you can add an analysis tag to customise your reports further
Tax - Don't forget to select the tax rate as you’ll be able to post even if you don't enter any
📌TIP: If you set up default rates from your Chart of Accounts, the tax code will populate whenever you select the account category.
Line items actions
The Transfer option allows you to match transfer transactions with the other bank account statement and avoid duplication.
The Split option allows you to split a transaction across multiple nominal and VAT codes.
Select and Match
You can also match entries with the following methods:
Cheques
Cheques
The Cheques option allows you to match/reconcile transactions with Cheques that you've already imported using the cheque function.
Deposits
Deposits
The Deposits option allows you to match/reconcile transactions with Deposits.
Posting
Once you’ve coded the desired transactions, select them using the check boxes and click Post (x lines ready) at the bottom.
📎NOTE: Make sure to select an Account category to be able to post any entry.
Checking
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.