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.

Lesson 10 of 10 · Step by step

  • 3-minute lesson
  • Accounting → Bank reconciliation

Step by step

  1. 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/reconcile
  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.

Where to find it

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.