Bank statement vs general ledger

Compare a bank statement to your general ledger

Match a bank statement (PDF, CSV, Excel or OFX) against a general ledger or cash account export, and see every transaction that doesn't match and why. Free summary, no sign-up.

Free summary, no sign-upPDF, CSV, Excel or OFXFiles deleted after 1 hour
Processed in memory, never stored
No files handy? Run it on a fictional bank statement and QuickBooks export:

Sample files to test with: bank statement CSV · QuickBooks export CSV · bank statement PDF

1. Upload two files

The bank statement (PDF, CSV, Excel or OFX) and an export of the same account from QuickBooks, Xero or any ledger.

2. We match every line

Exact amounts within a date window, the closest date and most similar description first, checks by number, and ledger debit/credit signs handled.

3. See what's off

Missing from the books, not cleared at the bank, amounts that differ, reversed signs and duplicates, adding up to the whole difference. Download CSV or PDF.

Why compare the statement to the ledger line by line

A bank reconciliation proves that the cash account in your general ledger agrees with the bank, after timing differences. When the balances don't agree, the answer is in the detail: a transaction on one side and not the other, or the same transaction recorded differently. Ticking a statement against a ledger printout by hand takes an hour for a busy month; matching the two exports takes seconds and leaves only the lines worth looking at.

How to do it

  1. Export the cash account only from your general ledger, for the statement's dates. A whole-ledger export mixes in other accounts, which would all show up as items not on the bank statement.
  2. Upload the statement and the export above.
  3. Work through the groups. Bank fees, interest and unrecorded payments need journal entries. Outstanding checks and deposits in transit go on the reconciliation as timing differences. Amount differences, reversed signs and duplicates are errors to correct in the ledger.

How the results map to a classic reconciliation

Reconciliation lineWhere it comes from in the report
Deposits in transit (add to bank balance)In your books, not on the bank statement: positive amounts.
Outstanding checks (subtract from bank balance)In your books, not on the bank statement: negative amounts, often with a check number.
Bank charges and interest (adjust book balance)On the bank statement, not in your books.
Errors (adjust book balance)Amount differs, sign reversed and possible duplicates in your books.

The summary adds every item up, so you can see that together they account for the whole difference between the bank's net movement and the ledger's for the same dates.

Prefer to do it in a spreadsheet? Our guide to comparing a bank statement to the general ledger in Excel has the COUNTIFS and XLOOKUP formulas, and shows how to sum the unmatched rows to explain the gap.

What each result means

ResultWhat it usually means, and what to do
On the bank statement, not in your booksBank fees, interest, card payments or transfers nobody entered. Record them (or find them in another account).
In your books, not on the bank statementOutstanding checks and deposits in transit, which clear on a later statement, or entries that were never real: a deposit recorded twice, a voided check left in.
Amount differsThe same transaction keyed with a different amount. A difference that divides by 9 usually means transposed digits (189.34 entered as 198.34).
Sign reversedA payment entered as a deposit or the other way round. It throws the balance off by twice the amount.
Possible duplicateThe same amount and payee entered twice, often after a bank feed and a manual entry or an import overlapped.
Dated outside the statement periodBook entries before or after the statement's dates. Listed for reference, not counted as problems.

Statement not tying out to its own balances first? Run it through the free bank statement balance checker. Only have PDF statements and need them in your books? The PDF statement to QuickBooks and PDF to Xero converters check every statement against its closing balance.

Pricing

The summary is free: matched count, issues by type, how they add up to the difference, and the first 3 items of each type. The full list with CSV and PDF reports uses 1 credit from the same $9 pack of 5 as our statement converter, or is unlimited on Pro at $19/month.

FAQ

Questions

What do I need to upload?

Two files for the same account and period: the bank statement (a PDF downloaded from online banking, or a CSV, Excel, OFX, QFX or QBO download) and an export of the same account from your books (a QuickBooks or Xero report exported to CSV or Excel, or any register or ledger CSV). We find the date, description and amount, or debit and credit, columns automatically, and you can change them.

How are transactions matched?

On the exact amount, within a date window you choose (3 days by default), preferring the closest date and the most similar description. A check is matched by its number even if it cleared weeks after you wrote it. Then we look at what's left: the same transaction keyed with a different amount, the same amount with the sign reversed, and entries that appear twice.

What does the report show?

Every transaction in one of these groups: Matched; On the bank statement, not in your books (often bank fees, interest or a missed expense); In your books, not on the bank statement (outstanding checks, deposits in transit or entries that never happened); Amount differs, with a note when the difference divides by 9, the classic sign of transposed digits; Sign reversed; and Possible duplicates. The summary shows how the items add up to the whole difference between the two files.

My books export shows deposits as debits. Will that work?

Yes. In a ledger, money into a bank account is a debit, which is the opposite of a bank statement. We try your books both ways and keep the one that matches more transactions, and you can force either on the results page.

Is it free?

The summary is free: how many transactions match, how many issues of each kind and how they add up to the difference, with the first 3 items of each kind. The full list and the CSV and PDF report use 1 credit from the same $9 pack of 5 credits as our statement converter, or are unlimited on Pro at $19/month.

Are my files stored?

No. Both files are read in memory and never written to disk, and results are deleted after 1 hour. We never use your data for AI training, and transaction details are never sent to our analytics.

Does it connect to QuickBooks or Xero?

No, it works from exported files, so there's nothing to authorize and it works for any accounting software. It doesn't change your books: fix what it finds in QuickBooks or Xero yourself, then reconcile there.

Can I try it without my own files?

Yes. Click Try the sample under the upload boxes. It reconciles a fictional bank statement CSV against a fictional QuickBooks export with a few planted problems: a missing bank fee, an outstanding check, a doubled entry, a transposed amount and a reversed sign. Every download is free for the sample.

Can I use a general ledger export with every account in it?

Export only the bank or cash account you're reconciling, for example QuickBooks' Account QuickReport or Transaction Detail by Account filtered to that account, or Xero's Account Transactions report for the bank account. A whole-ledger export mixes in other accounts, which would show up as items not on the bank statement.

Related tools

Guides