QuickBooks & Xero reconciliation

Find what's throwing off your QuickBooks or Xero reconciliation

Reconciliation off and you can't find why? Upload the bank statement and a QuickBooks or Xero export of the account. We pinpoint the missing, doubled, mis-keyed and sign-flipped transactions. Free summary.

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.

When to use it

  • QuickBooks shows a Difference that isn't 0.00 at the bottom of the Reconcile screen, and you can't see which line is causing it.
  • Xero's statement balance doesn't match the balance in Xero, or the Bank Reconciliation Summary shows unexplained items.
  • You're catching up months of bookkeeping and want to know what's missing before you start reconciling.

How to find the discrepancy

  1. Export the account from QuickBooks Online: Reports → Account QuickReport (or Transaction Detail by Account) for the bank account and the statement's dates → Export → Export to CSV or Excel. Xero: Accounting → Reports → Account Transactions, choose the bank account and dates, then export to Excel or CSV. QuickBooks Desktop: a Custom Transaction Detail report filtered to the account, exported to a CSV file.
  2. Upload it with the bank statement for the same period (PDF or CSV).
  3. Fix what the report finds in QuickBooks or Xero, then reconcile again: add the missing fee or interest, correct the mis-keyed amount, flip the reversed entry, delete or exclude the duplicate.

What usually throws a reconciliation off

CauseHow it shows up in the report
A bank fee, interest or card payment nobody enteredOn the bank statement, not in your books.
A transaction imported twice (bank feed plus a manual entry or file upload)Possible duplicate in your books.
Digits swapped when typing an amountAmount differs, with the divisible-by-9 note.
A payment recorded as a depositSign reversed, off by twice the amount.
A check written but not yet cashedIn your books, not on the bank statement: normal, it stays uncleared until a later statement.
Beginning balance changed by an edited or deleted reconciled transactionNot visible in one month's files. See QuickBooks reconciliation not matching for the Reconciliation Discrepancy Report and how to fix it.

Duplicates after an import? Our guide on duplicate transactions in QuickBooks after importing a bank statement covers finding and removing them safely.

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.

How do I export the account from QuickBooks Online?

Open Reports, run an Account QuickReport (or Transaction Detail by Account) for the bank account and the statement's dates, then use Export → Export to Excel or CSV. For Xero, run the Account Transactions report for the bank account and export it to Excel or CSV. In QuickBooks Desktop, run a Custom Transaction Detail report filtered to the account and export it to a CSV file.

Related tools

Guides