Bank reconciliation: how it works
Bank reconciliation compares your bank statement with the bank account in your books, line by line. You import the statement as a CSV file, the system pairs each line with a ledger line, and you book what the books do not know yet, such as bank charges.
Lesson 2 of 10 · How it works
How it works
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 choose the bank or cash account. Four figures show the «Ledger balance», the «Statement total (imported)», the «Unmatched statement lines» and how many lines are matched and reconciled.
Under «Import statement» upload the CSV file from your bank. You tell the system which columns hold the date, description, reference and amount, and which date format the bank uses. Comma, semicolon and tab files are recognized.
On import the system matches by itself: a statement line and a ledger line with the same amount and dates at most 3 days apart become a pair. Lines that were imported before (same date, amount and description) are skipped.
For a line that stays unmatched you either match it by hand against a ledger line, or create an entry with a counter account, for example bank charges or interest. The entry is posted and matched in one step.
When the pairs are right, click «Mark matched as reconciled». A line goes from Unmatched to Matched to Reconciled; a reconciled pair is locked until you un-match it. Lines left unreconciled for more than 30 days become a dashboard to-do.
Where to find it
- Accounting → Bank reconciliation
/admin/accounting/reconcile - Accounting → Chart of accounts
/admin/accounting/accounts
Settings that change it
- Accounting → Chart of accounts
/admin/accounting/accounts
Checklist
Before you move on, check that you can:
- Open Accounting → Bank reconciliation
- Open Accounting → Bank reconciliation and choose the bank or cash account.
- Under Import statement upload the CSV file from your bank.
- On import the system matches by itself: a statement line and a ledger line with the same amount and dates at…
- For a line that stays unmatched you either match it by hand against a ledger line, or create an entry with a…
Tips and common mistakes
- No account to choose? Tick «Bank / cash account» on the account in the chart of accounts first.
- Withdrawals arrive as positive numbers? Tick «Withdrawals are positive (flip sign)» in the import. If the first row is data, untick «First row is a header».
- Nothing matches automatically when the books are behind. Click «Post now» on the Accounting overview first, so the receipts and paid bills are in the ledger.