Kayabyte

Why does QuickBooks Online reconcile show a difference after importing a converted statement?

By Kayabyte · Last updated 11 November 2026

Short answer: the Difference in QuickBooks Online is the gap between your books and the statement. After a PDF-to-CSV import it usually means a row is missing or duplicated, a sign is flipped, or the beginning balance, ending balance or ending date was entered wrong. Check the converted file against the statement’s opening and closing balance before you import, and use Edit info in the reconcile screen to confirm the three figures. This is a conversion and bookkeeping how-to, not accounting advice.

How QuickBooks Online reconcile works

From Intuit’s help page on reconciling an account (checked 11 November 2026): you choose the account, enter the Ending balance and Ending date from your statement, select Start reconciling, and tick each QuickBooks transaction that matches the statement until the Difference is zero. The statement should begin the day after the last statement ending date, and the beginning balance should match your statement. If it does not balance, Edit info lets you correct the ending balance or ending date. Menu names change, so follow Intuit’s current page.

Why a converted statement causes a difference

  1. A row was dropped. Transactions split across a page break are the usual culprit.
  2. A row was duplicated. Importing the same month twice, or two overlapping date ranges, doubles items.
  3. A sign was flipped. A credit card file shows purchases as positive; a bank file shows money out as negative. Intuit says to choose the card account when you upload a card file. A difference of exactly twice an amount points to a flipped sign.
  4. Wrong beginning balance. The books do not start where the statement starts, often because an earlier month was never imported.
  5. Wrong ending date. Transactions dated after the ending date are not counted.

Check before you import

Before the file goes into QuickBooks, do the check the statement allows: opening balance plus the transactions equals the closing balance. If your converter does not do this, do it in a spreadsheet by summing the signed amounts. If the sums do not agree, fix the file first. A difference found here is far easier to trace than one found in the reconcile screen. See why converted statements don’t add up.

If the Difference is not zero in QuickBooks

Intuit’s page lists what to review: confirm the beginning balance, ending balance and ending date with Edit info, review transactions entered manually for errors or duplicates, and select a transaction to see its details and edit it. It also says you can finish with a difference, in which case QuickBooks creates a journal entry for that amount, and that you should talk to your accountant before you do. Treat that as a last resort.

Where Balanced helps

Balanced is a Mac app we make. It reads a bank or card statement PDF (or a scan, or a CSV) on your Mac, with nothing uploaded and no AI, and checks that opening balance plus transactions equals the closing balance, and the running balance on each row if the statement has one. If it does not match, it shows which rows and what difference, and exporting needs an explicit “Export anyway”. It exports CSV, Excel, OFX, QFX, QBO and other import formats.

Limits: Balanced writes files that you import into QuickBooks; there is no direct sync. Results depend on the statement layout, so look at the preview. Password-protected PDFs must be unlocked first. The check proves the file matches the statement, not that your books are right.

Steps with Balanced

  1. Open the statement in Balanced and check the preview, date order and sign handling.
  2. Read the totals check against the opening and closing balance.
  3. Export QBO or CSV, then import it for the account in QuickBooks Online.
  4. Start the reconcile with the statement’s ending balance and ending date, and tick the transactions.

The free version reads and checks everything and exports the first 5 transactions per file. Balanced Pro is USD 59 per year or USD 7.99 per month, up to 3 Macs, cancel anytime. Download Balanced and check a statement for free. macOS 15 or later.

Questions

What does Difference mean in QuickBooks reconcile? The gap between QuickBooks and your statement. The goal is zero.

Should I press adjust and finish? Only after you have looked for the cause, and Intuit says to talk to your accountant first.

My import was fine but the reconcile is still off. Why? Check the beginning balance against the last reconciled statement, and the ending date.

QuickBooks and Intuit are trademarks of Intuit Inc. Balanced is made by Kayabyte and is not affiliated with or endorsed by Intuit.