Reconcile your bank account
Bring in your bank transactions and tie each one to your books, so your bank balance and your ledger agree.
- What you'll achieve: Every bank transaction matched to a ledger entry or coded to an account, and a difference of zero.
- Who can do this: Accounting: Read and Update
- Time: about 5 minutes
Before you start
- Accounting is set up: see “Set up Accounting” (Accounting › Settings, /accounting/settings).
- A bank statement for the period, downloaded from your online banking as a CSV file, or a bank connected through Bank feed.
Steps
1. Open Reconciliation
In the sidebar, open Accounting and select Reconciliation. Compare Balance per bank statement with Balance in ledger.
Tip: When every line is reconciled, the Difference should be zero.

2. Import a bank statement
Select Import bank statement.
Tip: To sync transactions automatically instead, use Bank feed and select Connect a bank.
3. Drop in your CSV file
Drop the CSV file from your bank here, or select Choose File. If your bank's file won't import, select Download template and copy your transactions into it.
Tip: Each import is listed under Recent imports, where you can Undo it.

4. Match a transaction
Under Reconcile, select Find & Match on a transaction.
5. Pick the ledger entry
Search by entry number or memo, tick the matching entry, then select Reconcile. The Difference must be zero.
Tip: The usual reason a line won't match is a payment or receipt that was never recorded. Record it, or use Create.

6. Or code it to an account
If there's no matching entry, select Create.

7. Say who, what and why
Choose Who and What (the account), check Why and the Tax rate, then select OK.

8. Set up bank rules
Select Bank rules.
9. Add a rule
Select Add rule to code transactions that contain the same words to the same account every time.

10. Check the reconciliation report
Select Reconciliation report to see the difference and any lines still to reconcile.

Troubleshooting
My bank's CSV file won't import.
Select Download template, copy your transactions into it in the same columns, and import that file.
A transaction has no matching entry.
The payment or receipt hasn't been recorded. Record it against the invoice, or select Create to code it to an account.
I imported the wrong file.
Find it under Recent imports and select Undo.
