Bank statementreconciliation

Upload your bank statement PDF — extract every transaction as clean, structured data ready to reconcile in QuickBooks, Excel, or Xero.

CSV & Excel exportAI categorizationQuickBooks / Xero ready

Drop your bank statement hereTap to upload your statement

or click to browse — PDF, JPG or PNG · multiple files

Free·No signup·Deleted after analysis

... statements analyzed

See a live example →

Learn how it works

Definition

What is bank statement reconciliation?

Bank statement reconciliation is the process of comparing your bank statement against your internal accounting records to verify they match. When they don't match, you find and fix the differences.

It's done monthly by businesses and accountants to catch errors, spot fraud, track unrecorded fees, and ensure the books accurately reflect reality.

Catches errors

Finds mistakes in your records or unexpected bank charges before they compound.

Prevents fraud

Unrecognized transactions become visible when you compare statement vs. books.

Accurate books

Ensures your accounting records match actual cash on hand — critical for tax time.

Step by step

How to reconcile a bank statement

Get your bank statement

Download your bank statement PDF for the period you want to reconcile. Upload it here to extract all transactions into a clean, structured format automatically.

List all transactions

Export the extracted transactions to Excel or CSV. You now have every debit and credit in a spreadsheet — ready to compare against your accounting records.

Compare to your books

Match each bank transaction against your accounting records (QuickBooks, Xero, or your own ledger). Check off everything that matches.

Investigate differences

Any unmatched items need explanation: bank fees not recorded, timing differences, missing entries, or errors. Adjust your books accordingly.

Confirm the balance

Once all differences are explained, your adjusted book balance should equal the bank statement closing balance. Reconciliation complete.

Platforms

How to reconcile in QuickBooks, Excel & Xero

How to reconcile bank statement in QuickBooks

1Go to Accounting → Reconcile
2Select the bank account and period
3Enter the statement ending balance
4Check off each matching transaction
5Click Finish when difference = $0.00

Tip: Use our CSV export to cross-check QuickBooks entries against your actual bank statement before reconciling.

How to reconcile bank statement in Excel

1Export your bank transactions as CSV (use our tool)
2Paste into one column of your spreadsheet
3Paste your book entries in the next column
4Use VLOOKUP or conditional formatting to find matches
5Flag and investigate any unmatched rows

Tip: Our Excel export includes date, description, amount, and category — ready to paste directly into your reconciliation spreadsheet.

How to reconcile bank statement in Xero

1Go to Accounting → Bank Accounts
2Select your account and click Reconcile
3Xero suggests matches automatically
4Confirm correct matches or create new entries
5Resolve any items Xero couldn't match

Tip: Export our categorized CSV and import to Xero as a bank statement file for faster automatic matching.

Pricing

Simple, transparent pricing

Free

Try it out

3 PDF pages / month
AI transaction categorization
Sankey money-flow chart
AI insights & savings tips
Financial health score
Spending calendar
CSV export

Start Free

Bank statement reconciliation FAQ

What is bank statement reconciliation?+−

Bank statement reconciliation is the process of comparing your bank statement against your internal accounting records to make sure they match. Any differences (missing transactions, bank fees, timing differences) are identified and explained. It is typically done monthly.

How do you reconcile a bank statement?+−

The basic steps are: (1) Get your bank statement for the period. (2) Compare each transaction against your accounting records. (3) Mark off matching transactions. (4) Investigate any differences. (5) Adjust your records for bank fees, interest, or errors. (6) Confirm the closing balance matches.

How do I reconcile a bank statement in QuickBooks?+−

In QuickBooks Online: go to Accounting → Reconcile → select the account → enter the statement ending balance and date → check off each transaction that appears on your bank statement → click Finish when the difference is $0.00.

How do I reconcile a bank statement in Excel?+−

Download your bank statement as CSV or use our tool to extract transactions. Create two columns: bank transactions and book transactions. Use VLOOKUP or conditional formatting to match them. Flag any rows that don't match. Adjust for timing differences and bank charges.

How do I reconcile a bank statement in Xero?+−

In Xero: go to Accounting → Bank Accounts → select the account → click Reconcile. Xero automatically suggests matches between bank transactions and your records. Confirm matches or create new transactions for anything unmatched.

How often should you reconcile bank statements?+−

Monthly is standard for most businesses — reconcile at the end of each month using your monthly bank statement. High-volume businesses may reconcile weekly. For personal finances, monthly or quarterly is usually sufficient.

What is the difference between bank reconciliation and bank statement reconciliation?+−

They mean the same thing. Bank reconciliation (or bank statement reconciliation) is the process of matching your bank statement to your accounting records. Some people use "bank reconciliation" for the process and "bank statement reconciliation" when emphasizing the statement as the source document.

Reconcile faster — start with clean data.

Upload your bank statement PDF — get every transaction extracted, categorized, and exported to Excel or CSV in 30 seconds.

Extract My Bank Transactions Free →

✓ 3 pages free · ✓ No signup · ✓ QuickBooks & Xero ready