Reconcile the bank with a CSV statement
Import the bank statement, match each line to the ledger and book what is missing.
Lesson 10 of 10 · Step by step
Step by step
Open Accounting → Bank reconciliation Checking that the lines on your bank statement agree with the books. You import the statement, and each line is matched to a posting in the ledger. More words in the glossary and pick the Bank / cash account.
/admin/accounting/reconcileUnder Import statement upload the bank's CSV, map the Date, Description, Reference and Amount columns and the Date format.
Click “Import … lines & auto-match”. Lines already imported are skipped.
For Unmatched lines click Match against a ledger line, or Create entry with a Counter account (for example bank charges).
Click Mark matched as reconciled.
Where to find it
- Accounting → Bank reconciliation
/admin/accounting/reconcile
Checklist
Before you move on, check that you can:
- Open Accounting → Bank reconciliation
- Under Import statement upload the bank's CSV, map the Date, Description, Reference and Amount columns and…
- Click “Import … lines & auto-match”.
- For Unmatched lines click Match against a ledger line, or Create entry with a Counter account (for example…
- Click Mark matched as reconciled.
Tips and common mistakes
- No bank account in the list? Tick “Bank / cash account” on it in the Chart of accounts.