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.
Sample files to test with: bank statement CSV · QuickBooks export CSV · bank statement PDF
The bank statement (PDF, CSV, Excel or OFX) and an export of the same account from QuickBooks, Xero or any ledger.
Exact amounts within a date window, the closest date and most similar description first, checks by number, and ledger debit/credit signs handled.
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.
| Cause | How it shows up in the report |
|---|---|
| A bank fee, interest or card payment nobody entered | On 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 amount | Amount differs, with the divisible-by-9 note. |
| A payment recorded as a deposit | Sign reversed, off by twice the amount. |
| A check written but not yet cashed | In your books, not on the bank statement: normal, it stays uncleared until a later statement. |
| Beginning balance changed by an edited or deleted reconciled transaction | Not 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.
| Result | What it usually means, and what to do |
|---|---|
| On the bank statement, not in your books | Bank fees, interest, card payments or transfers nobody entered. Record them (or find them in another account). |
| In your books, not on the bank statement | Outstanding 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 differs | The same transaction keyed with a different amount. A difference that divides by 9 usually means transposed digits (189.34 entered as 198.34). |
| Sign reversed | A payment entered as a deposit or the other way round. It throws the balance off by twice the amount. |
| Possible duplicate | The same amount and payee entered twice, often after a bank feed and a manual entry or an import overlapped. |
| Dated outside the statement period | Book 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.