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:

Unposted tab within Bank Statement Reconciliation report.

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

For each entry, you can Transfer, Split or Delete.

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:

Transfer

The Transfer option allows you to process bulk transfers between internal accounts.

Cheques

The Cheques option allows you to match/reconcile transactions with Cheques that you've already imported using the cheque function.

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.

Code and post bank transactions to ledger accounts