Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Reconcile the bank with a CSV statement

Import the bank statement, match each line to the ledger and book what is missing.

Last updated November 6, 20261 min read

Steps

  1. Open Accounting → Bank reconciliation and pick the Bank / cash account.
  2. Under Import statement upload the bank's CSV, map the Date, Description, Reference and Amount columns and the Date format.
  3. Click “Import … lines & auto-match”. Lines already imported are skipped.
  4. For Unmatched lines click Match against a ledger line, or Create entry with a Counter account (for example bank charges).
  5. Click Mark matched as reconciled.

Tips

  • No bank account in the list? Tick “Bank / cash account” on it in the Chart of accounts.
Was this helpful?

Next steps

Still need help?

Ask the assistant, or contact the team and we reply by e-mail.