QuickBooks reconciliation not matching: beginning balance is off, or the difference isn't 0.00

QuickBooks blocks a reconciliation in two places. At the start, the beginning balance doesn't match the statement (QuickBooks Online says "Your account isn't ready to reconcile yet. Your beginning balance is off by…"). At the end, the difference won't reach 0.00. This guide covers both, in QuickBooks Online and QuickBooks Desktop, using Intuit's own reports and menu paths. It also covers the part Intuit's articles skip: in catch-up work, most of these problems start with an import that left a transaction out, brought one in twice, or flipped its sign. Tie out each statement before you import and most of them never happen.

Which problem do you have?

The two problems look alike, but they have different causes and different fixes. Work out which one you have first.

Why imports cause most catch-up discrepancies

Intuit's lists of causes are written for books kept up to date month by month: an edited reconciled transaction, a wrong ending balance typed in, a deposit entered before it cleared. Catch-up work is different. You're bringing in months or years of transactions at once, from bank downloads, CSVs, .QBO files, IIF files or PDF statements, and each import can go wrong in one of three ways:

• Missing. A month was skipped, or a download started a day late or stopped a day early. A file over QuickBooks Online's limits was cut short when you split it (Intuit's limits for a transaction list are 350 KB and 1,000 lines per upload). A PDF converter dropped a line that wrapped across a page break.
• Duplicated. Intuit's duplicates article names "import a file that overlaps with your bank feed" as a cause. The same month uploaded twice, once as a CSV and once as a PDF statement. A transfer between two of your own accounts recorded from both sides. In Xero, a transaction marked as reconciled by hand and then imported from the bank as well.
• Sign-flipped. A refund that went in as a charge, or a deposit as a withdrawal. Credit card files cause this most often: Intuit's CSV formatting article warns that card CSVs "may display transactions in reverse order. For example, deposits may appear as negative amounts because paying your credit card reduces your balance." Card statements also print credits with CR or as negatives, so the direction depends on who made the file.

The size of the difference usually tells you which one you're dealing with:

None of these show up in QuickBooks' discrepancy reports. Those reports list changes to transactions that were already reconciled. A transaction that was imported twice, or with the wrong sign, and never reconciled isn't a change, so the report doesn't list it. You find it by comparing the imported transactions with the statement, or better, before you import.

Tie out every statement before you import

Each statement has its own proof built in:

• Bank account: opening balance + deposits − withdrawals = closing balance.
• Credit card: previous balance − payments and credits + purchases, fees and interest = new balance.

If the transactions you're about to import don't produce the closing balance to the cent, something is already missing, doubled or reversed, and reconciling later will only show you the total. Check it now, while there's one statement to look through.

1. Check the chain first. Each statement's opening balance should equal the previous statement's closing balance. If it doesn't, a statement is missing or belongs to another account.
2. Tie out the file. Paste the transactions and the two balances into the free bank statement balance checker. It runs in your browser (nothing is uploaded), reads CR/DR and (parentheses) amounts and card sign conventions, and when the file doesn't tie out it suggests the likely line: a duplicate, a flipped sign, swapped digits or a reversed section. In Excel, with amounts in column C and the opening and closing balances in F1 and F2, =ROUND(F1+SUM(C:C)-F2,2) must return 0.
3. Check the date range. The first and last dates in the file should fall inside the statement period, and shouldn't overlap what's already in the account. Intuit's advice for duplicates is to "import files that start after the newest transaction that's already in QuickBooks."
4. Import only files that tie out. Note "tied out" against each month. Then if a month won't reconcile later, you know the problem is in the books (a transaction entered by hand, a deleted line, a bank feed duplicate), not in the import.

QuickBooks Online: beginning balance is off

Intuit: the beginning balance "should match the ending balance of your last reconciliation. If it doesn't, QuickBooks won't let you continue until you account for the difference." Intuit lists the common causes:

• An incorrect opening balance entered when the account was created.
• A reconciled transaction was edited, deleted, voided, moved or unreconciled.
• A categorized bank feed transaction that was undone and sent back to Pending.
• A transaction dated before your last reconciliation's ending date that was reconciled manually.

First reconciliation: fix the opening balance

If you've never reconciled the account, Intuit says the cause is usually the opening balance, not a changed transaction. Intuit's steps:

1. Go to All apps → Accounting → Chart of accounts, find the account and select View register.
2. Find the opening balance entry. It has Opening balance equity in the Account column. Note its date and amount.
3. Compare it with your bank's balance for the same day. If it doesn't match, select the entry, edit the amount (Intuit's steps use the Deposit column) and select Save.
4. Check the register's checkmark column. On a first reconciliation, the opening balance entry should be the only transaction marked R. Any other transaction should be blank or C. If another one shows R, select its checkmark box until it's blank, then Save.

Intuit recommends setting the opening balance at the start of a bank statement, which makes the first reconciliation much easier. In catch-up work, that's the first day of the oldest statement you're importing.

You added transactions older than the opening balance

This is the catch-up version of the problem. Intuit's explanation: the opening balance "summarizes all of your older transactions up to that point." If you then import those older transactions, they're counted twice. Intuit's fix is to edit the opening balance so its date and amount match your bank records for the new start date, which "resets the starting point for the account so QuickBooks doesn't count transactions twice." Intuit adds that it's much easier before the account's first reconciliation, and that you may need your accountant if it's been reconciled a few times already. In practice the new start date is the day before the oldest transaction you imported, and the amount is the bank's balance at the end of that day.

Reconciled before: use the Reconcile Discrepancy Report

1. Prepare first. Intuit says you need admin access. On Bank transactions, make sure every transaction from the period is matched, categorized, posted or excluded. Write down the exact amount the beginning balance is off by: the changes you find should add up to it.
2. Go to All apps → Accounting → Reconcile and pick the account from Which account do you want to reconcile? If you have more than one account at the same bank, or more than one of the same type, Intuit says to make sure you've picked the right one.
3. In the alert "Your account isn't ready to reconcile yet. Your beginning balance is off by…", select We can help you fix it. That opens the Reconcile Discrepancy Report.
4. Work down the report one row at a time. Each row is a reconciled transaction that changed. The What happened column says what changed, when and who changed it. Select Review in tray for details, or the dropdown next to it and View History for the full history.
5. Apply the suggested fix only if the change was a mistake. Intuit points out that some changes are intentional, and the suggested fix assumes an error. Depending on the change, the tray offers to save the original details, reverse a void, restore a deleted expense or send you to the register.
6. When the Total discrepancy difference shows $0.00, the beginning balance is fixed and you can reconcile.

If a fix tells you to reconcile one transaction, Intuit gives two options: mark it R in the register, or reconcile again with the same ending date and ending balance as your last reconciliation. Both fix the beginning balance, but only reconciling again records the change on a reconciliation report.

If the report is clear but the balance is still off, Intuit says two kinds of changes won't appear there:

• Deleted and voided transactions. Go to Settings → Audit log, filter to the account and the period since your last completed reconciliation, and look for deletes and voids.
• Transactions reconciled outside a reconciliation. Open the account's register and filter by Reconcile status. Look for transactions marked R and dated after your last completed reconciliation.

Duplicates you've already cleaned up can surface here too. Intuit's duplicates article notes that if a reconciled transaction was deleted, your beginning balance may be off. When you remove a duplicate, Intuit says to keep the reconciled copy (the one with C or R) and remove the other one. Step by step for QuickBooks Online and Desktop: duplicate transactions after an import.

QuickBooks Online: the difference isn't 0.00

In the Reconcile window, you tick each transaction that's on the statement. Intuit: "Continue matching until the Difference is $0.00." If it won't get there, Intuit lists three causes: someone entered the wrong ending balance at the start, someone entered transactions that haven't cleared the bank yet, or there are missing or duplicate transactions. Intuit's order of work, with what to look for after an import:

1. Check the beginning balance against the statement (if it's off, go back to the previous section).
2. Check the ending balance and date you typed. In the reconciliation window select Edit info, compare the Ending balance and Ending date with the statement, and Save.
3. Combine what the bank combined. If the bank shows several customer payments as one deposit, Intuit says to do the same in QuickBooks: put the payments in Undeposited Funds and record one bank deposit for them.
4. Rule out what matches. Tick everything that matches the statement exactly, so only the problems are left.
5. Enter what's missing. Categorize every downloaded or uploaded transaction first, because Intuit says you can't reconcile them until you do. Look for anything on the statement that's in QuickBooks but in the wrong account (check the Deposit to or Payment account), then enter what's truly missing. After an import, compare the file's first and last dates with the statement period.
6. Remove what isn't on the statement. For a transaction that's in QuickBooks but not on the statement, Intuit says to run a past reconciliation report for those dates. If it was on a past report, look for a duplicate and delete it only if you're certain, because Intuit warns: "Only delete transactions if you're absolutely certain they're a duplicate or error." An overlapping import is the usual reason in catch-up work.
7. Review transactions that are slightly off, such as a bank fee taken out of a deposit. Intuit's fix is to add the fee to the bank deposit (+ Create → Bank deposit) with a memo saying which transaction it belongs to. Sign-flipped imports show up at this step: the amount matches the statement but goes the wrong way, and the difference is twice the amount.

If you can't find the error, QuickBooks Online lets you finish anyway and accept the difference. Intuit says QuickBooks then "will create a journal entry that adjusts your books by the amount of the difference," and that you should talk to your accountant first: "Usually it's best to resolve any differences in the reconciliation and to not perform this task." In catch-up work an adjustment usually covers up a missing or duplicated import, which then comes back in a later month.

Some plans also have an AI-powered reconciliation, where you upload the statement and QuickBooks marks each transaction Cleared or For review. Intuit says the upload and check can take up to an hour, and its plans page says which plans include it. The fixes are the same.

QuickBooks Online: undo a reconciliation

Try the discrepancy report first. Undoing is the start-over option.

• One transaction: open the account's register, select the transaction and click the box in the checkmark column until it's blank (it cycles R → C → blank), then Save. Intuit notes that this changes the beginning balance for your next reconciliation, so reconcile again afterwards.
• A whole reconciliation: sign in as the Primary Admin, go to All apps → Accounting → Reconcile → History by account, find the reconciliation and choose Undo in the Action column. Intuit warns that this can't be reversed and "permanently deletes associated reports and attachments," so download them first. In Intuit's video on undoing a client's reconciliation (in Intuit Accountant Suite), undoing one month also undoes every reconciliation after it.

QuickBooks Desktop: beginning balance is off

In Desktop, go to Banking → Reconcile and pick the account. QuickBooks fills in the Beginning Balance from your last reconciliation's ending balance, and Intuit says to make sure it matches the statement. If the Beginning Balance is zero or wrong, Intuit gives four possible reasons:

• The account wasn't set up with a balance, or with the right one.
• Transactions that were already cleared and reconciled were voided, deleted or modified.
• The file was converted from another version of QuickBooks (Intuit notes that reconciliation works differently in QuickBooks for Mac and QuickBooks Online, so some transactions may come over unreconciled).
• Possible data damage.

The Begin Reconciliation window has a Locate Discrepancies button that opens the reports below, and an Undo Last Reconciliation button.

Zero or wrong opening balance (first reconciliation)

If this is the account's first reconciliation, Intuit says to create the opening balance again with a journal entry and reconcile it:

1. Company → Make General Journal Entries. Date it with the statement date of your beginning balance.
2. Pick the account and enter the opening balance in the Debit column, with Opening Balance Equity as the other account. Save. (Intuit's steps are written for a bank account. A credit card balance owed goes on the credit side. Ask your accountant if you're not sure.)
3. Banking → Reconcile, pick the account, and enter the statement date and ending balance that match the journal entry. Continue.
4. Under Deposits and Other Credits, select the journal entry. The Difference should now be zero. Select Reconcile Now.

Reconciled before: find what changed

• Reconciliation Discrepancy report: Reports → Banking → Reconciliation Discrepancy, pick the account, OK. It lists transactions changed since your last reconciliation, sorted by statement date. Note the transaction date and the Entered/Last Modified date, which tells you when the change happened.
• Previous Reconciliation report: Reports → Banking → Previous Reconciliation, pick the account and statement ending date, Display. Compare it with the statement. Intuit notes that QuickBooks Pro only keeps the last reconciliation report, so save a PDF of each one if you're on Pro.
• Audit Trail: Reports → Accountant & Taxes → Audit Trail, filtered to the account, with an Entered/Modified range from the previous reconciliation's creation date (shown on the Previous Reconciliation PDF) to today.

Once you've found the change, Intuit offers two ways to correct it: undo the previous reconciliation and redo it, or ignore the discrepancy and let QuickBooks enter an offsetting adjustment. To undo: back up the company file, then Banking → Reconcile → Undo Last Reconciliation, Continue, OK. Intuit notes that the beginning balance then goes back to the previous reconciliation's beginning balance, and every transaction cleared in that reconciliation becomes uncleared.

Check the statement dates. Desktop attaches the statement date to every transaction you reconcile. Intuit explains that if a later statement was reconciled before an earlier one, or a future date was typed as the statement date, the beginning and ending balances on the reconciliation report come out wrong. The fix is to undo back to the wrong reconciliation, delete the service charges, interest and balance adjustments it entered, and "reconcile each statement again separately and in sequential date order." Catch-up work is where this happens most, so reconcile the oldest statement first.

QuickBooks Desktop: the difference isn't 0.00

Intuit's list of causes for Desktop adds two to the Online list: someone edited or deleted already-reconciled transactions, and someone adjusted your last reconciliation with a journal entry. When you finish a bank reconciliation that isn't at $0.00, QuickBooks opens the reconcile adjustment window with three choices:

• Return to Reconcile: go back and review.
• Leave Reconcile: save your progress, fix transactions and come back later.
• Enter Adjustment: QuickBooks creates a journal entry in a special expense account called Reconciliation Discrepancies. Intuit says to do this only if you know all the correct transactions are in QuickBooks, and warns: "Adjustments don't fix errors. And if you fix the errors later on, an adjustment causes problems down the road."

To find the cause, Intuit suggests the Reconciliation Discrepancy report (above), a Missing Checks report (Reports → Banking → Missing Checks) to find checks that aren't on the statement, and a Transaction Detail report (Reports → Custom Reports → Transaction Detail) filtered to the account, with Entered/Last Modified set from your last reconciliation to today. To find adjustments made earlier, open the Reconciliation Discrepancies account from the Chart of Accounts, or use Edit → Find → Advanced → Memo and search for Balance Adjustment.

For catch-up imports into Desktop, also check how the transactions got there:

• IIF imports post straight to the register. They don't go through bank feed matching, so a file that overlaps transactions you already entered creates duplicates. Import only the dates you don't have yet (see IIF import errors).
• Web Connect (.QBO) skips transactions it has already imported, as long as each transaction's ID stays the same. A file from a different source for the same month can still bring in duplicates (see .QBO Web Connect import errors).
• QuickBooks Desktop 2023 lost bank feeds and Web Connect uploads after May 31, 2026. On that version, IIF is the import that still works.

If you can't find anything, Intuit says you may need to undo previous reconciliations until the opening balance is correct, and if someone edited or deleted a transaction from years ago, that can mean undoing reconciliations for the past few years. Back up first.

Xero: statement balance doesn't match

Xero has the same problem under a different name. Xero Central: if the statement balance in Xero doesn't match your actual bank balance for the same date, "either the opening balance in Xero is wrong or there's an error in the bank statement lines in Xero." The causes it lists are the import problems above: a missing bank statement line, a duplicate line ("one that was imported twice into Xero"), a line deleted in error, or a transaction marked as reconciled by mistake, which creates a manual statement line. Xero's steps:

1. Check that the bank account's opening balance matches your actual closing bank balance for the day before you started using Xero, and that the conversion balances are saved.
2. Find when it went wrong. Run the Bank Reconciliation Detail report a month at a time from the last date the balances matched, then the Bank Reconciliation Summary for shorter ranges within the month, until you find the date the balances part.
3. Compare that period with the bank statement line by line, and check the Statement Exceptions report for deleted, manual and duplicate statement lines.
4. Fix it: import the missing line, delete the duplicate line, restore the line deleted by mistake, or delete the manual line if you marked a transaction as reconciled and then imported its bank line.

To close out a month, Xero's Reconcile period tab has you enter the statement's opening and closing balances. Enter credit card balances as negatives (Xero's example is -200). Xero won't let you close a period until the balances match and every transaction in it is reconciled. For Xero import problems, see Xero bank statement import errors.

Checklist before the next import

1. Back up the company file (Desktop), or make sure you can undo the batch (QuickBooks Online: exclude it on the For review tab).
2. The opening balance entry is dated the day before the oldest transaction you'll import, and its amount matches the bank for that date.
3. Statements chain together: each opening balance = the previous closing balance, with no month missing.
4. Each file ties out to its statement (opening + transactions = closing) in the balance checker or the Excel formula.
5. Card files: charges and payments go the right way. In QuickBooks Online's CSV upload, check the amounts screen and use Reverse all values if they're backwards.
6. The file's date range starts after the newest transaction already in the account, so nothing overlaps the bank feed or an earlier import.
7. One source per month: don't upload the same month as both a CSV and a PDF.
8. Transfers between your own accounts are recorded once and matched on the other side.
9. Reconcile the oldest statement first, one statement at a time, and don't enter an adjustment to make a month close.

Related: catch-up bookkeeping with a year of statements, upload a PDF statement to QuickBooks Online, .QBO Web Connect import errors and QuickBooks Desktop IIF import errors.

Sources (Intuit help articles and Xero Central, read October 20, 2026): Fix beginning balance issues when reconciling in QuickBooks Online (updated 9/1/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/statement-reconciliation/fix-issues-accounts-reconciled-past-quickbooks/L8lx6PQQ5_US_en_US ; Fix issues the first time you reconcile an account in QuickBooks Online (updated 8/24/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/fix-issues-first-time-reconcile-account-quickbooks/L1aksm3QU_US_en_US ; Reconcile transactions that are older than your opening balance (updated 8/28/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-registers/reconcile-transactions-older-opening-balance/L6k9pajyX_US_en_US ; Reconcile an account in QuickBooks Online, https://quickbooks.intuit.com/learn-support/en-us/help-article/statement-reconciliation/reconcile-account-quickbooks-online/L3XzsllsK_US_en_US ; Fix issues at the end of a reconciliation in QuickBooks Online (updated 8/25/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/statement-reconciliation/fix-issues-end-reconciliation-quickbooks-online/L3mZimyAb_US_en_US ; Undo or remove transactions from reconciliations in QuickBooks Online (updated 8/24/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/accounting-bookkeeping/undo-remove-transactions-reconciliations-online/L6ERlEXxn_US_en_US ; Undo a client's entire reconciliation in Intuit Accountant Suite, https://quickbooks.intuit.com/learn-support/en-us/help-article/statement-reconciliation/undo-clients-reconciliation-quickbooks-online/L2rUvgAg6_US_en_US ; Fix duplicate transactions in QuickBooks Online bank feeds, https://quickbooks.intuit.com/learn-support/en-us/help-article/duplicate-transactions/fix-duplicate-transactions-quickbooks-online-bank-feeds/L1fjxl88f_US_en_US ; Manually upload transactions into QuickBooks Online (updated 8/24/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US ; Format CSV files in Excel to get bank transactions into QuickBooks (updated 8/24/2026; credit card CSV tips), https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US ; Reconcile an account in QuickBooks Desktop (updated 8/5/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/reconciliation-reports/reconcile-account-quickbooks-desktop/L2U5ZKM1J_US_en_US ; Fix beginning balance issues in QuickBooks Desktop (updated 8/24/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-feeds/fix-beginning-balance-issues-quickbooks-desktop/L04fjomHI_US_en_US ; Fix issues when you're reconciling in QuickBooks Desktop (updated 8/5/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/fix-issues-reconciling-quickbooks-desktop/L9dJ0KWR9_US_en_US ; Resolve common issues on the previous reconciliation report in QuickBooks Desktop (updated 8/5/2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/reconciliation-reports/resolve-common-issues-previous-reconciliation/L6T5gJIKt_US_en_US ; QuickBooks Desktop 2023 service discontinuation policy (read October 19, 2026), https://quickbooks.intuit.com/learn-support/en-us/help-article/feature-preferences/quickbooks-desktop-service-discontinuation-policy/L17cXxlie_US_en_US ; Xero Central, Compare the statement balance in Xero to your actual bank balance, https://central.xero.com/s/article/Compare-the-statement-balance-in-Xero-to-your-actual-bank-balance-US ; Xero Central, Reconcile and close a period, https://central.xero.com/0/article/Reconcile-a-period . The "divisible by 9" test is a bookkeeping rule of thumb, not something Intuit documents. Intuit's menu labels vary by QuickBooks Online layout (some screens use the gear icon → Reconcile); if a screen differs, follow the current article for your version.

FAQ

Related guides

• How to import bank transactions into QuickBooks Desktop after bank feeds stopped (2026)
• How to convert a credit card statement PDF to Excel
• QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need
• Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
• Xero bank statement import errors (and how to fix them)
• How to upload a PDF bank statement to QuickBooks Online (and check nothing was missed)
• QuickBooks Desktop IIF import errors (File not imported, Review now, and how to fix them)
• QuickBooks .QBO (Web Connect) import errors: OL-222, OL-221, “unable to verify the financial institution” and how to fix them
• Duplicate transactions in QuickBooks after an import: find them, remove them, and stop them coming back