Fix a Wrong Opening Balance After a QBO Import

If your bank balance and your QuickBooks balance stopped matching right after you imported a QBO file, the cause is almost always one of three things: a duplicate import, a wrong opening balance entry, or an overlapping date range. The fix is to find the source of the extra (or missing) amount, remove the duplicate or correct the opening balance, then reconcile to confirm the numbers line up. None of it requires starting over.

This guide walks through the exact checks in order, from fastest to most thorough, so you can get the register back in balance without deleting a month of clean work. It applies to both QuickBooks Online and QuickBooks Desktop, and to statements you converted yourself with a PDF bank statement to QuickBooks converter before importing.

Why is my opening balance wrong in QuickBooks after an import?

An opening balance is usually wrong because QuickBooks posted one automatically, or because the imported file started on a date that already had transactions. When you first connect or import to an account, QuickBooks may book an Opening Balance Equity entry to make the register match the file. If that figure does not match your real bank balance on that date, every total after it is off by the same amount.

The second common cause is a date overlap. If last month already ran through, say, March 31, and the new QBO file also includes March 28 to 31, those few days import twice. The register then shows a balance that is higher than the bank by the value of the doubled transactions, which reads like a broken opening balance even though the real problem is duplication.

How do I fix a wrong opening balance in QuickBooks?

To fix a wrong opening balance, open the account register, find the Opening Balance line (it posts to Opening Balance Equity), and edit it to the correct bank balance as of that date, or delete it if the account should start at zero. Then re-check the running balance against your statement. In QuickBooks Online, go to the gear icon, Chart of Accounts, View register; in Desktop, open the Chart of Accounts and double-click the account.

Work through it in this order:

1. Pull the bank statement that covers the start date and note the actual closing balance for the day before your import begins.
2. Open the account register and sort by date so the earliest entries are at the top.
3. Find the Opening Balance entry and compare it to that real figure.
4. Edit the amount to match, or delete it if your imported transactions already cover the full history.
5. Save, then scroll to today and confirm the ending balance now matches the bank.

Why does my bank balance not match QuickBooks?

Your bank balance does not match QuickBooks when the register contains transactions the bank does not, or is missing ones the bank has. The usual culprits are duplicate imports, an incorrect opening balance, uncleared checks that have not posted yet, or bank fees and interest the import skipped. If the register is short rather than over, the problem is the reverse of a duplicate; see why QuickBooks bank feed transactions go missing for how to track down the gap. Compare the two ending balances and the gap usually points straight to the cause.

A quick way to isolate it: note the exact dollar difference. If it equals one transaction or a tidy block of them, you are looking at a duplicate or a missed entry. If it is a round, odd number that matches nothing, it is almost always the opening balance. Exporting the register to a spreadsheet and lining it up against the statement makes the odd entry jump out; a PDF bank statement to Excel converter turns the statement into a clean column you can diff against the register row by row.

How do I delete duplicate transactions after a QBO import?

To delete duplicates, open the account register, sort by date, and look for two identical entries with the same date, amount, and description. In QuickBooks Online, select the duplicate and choose Delete; in Desktop, right-click the line and choose Delete. Always delete the copy that is not reconciled, and never delete a transaction that is already part of a completed reconciliation.

If a whole date range imported twice, filter the register to those dates first so you can see the pairs together. Deleting one of each pair restores the balance. Going forward, the cleanest prevention is to set each QBO file to start the day after your last import ends, so the ranges never overlap. When you convert statements yourself, trim the date range before you generate the file rather than after it is in QuickBooks.

What is an opening balance equity account in QuickBooks?

Opening Balance Equity is a temporary holding account QuickBooks uses to balance the books when you set up an account or import a starting balance. It is normal for it to hold a number briefly, but the goal is to clear it to zero by moving that amount to the correct equity or retained earnings account once setup is done. A lingering balance there is a sign your opening balance was estimated rather than reconciled. If you are unsure how the opening balance relates to the beginning balance you see each time you reconcile, our explainer on opening balance vs beginning balance lays out the difference.

If you see a stubborn figure in Opening Balance Equity after importing several statements, it usually means the very first opening balance was off. Correcting that first entry, as covered above, normally clears it. An accountant can move any genuine remainder to the right account at year end.

How do I undo a bank import in QuickBooks?

QuickBooks Online does not offer a single undo button for a completed import, so you remove the imported transactions manually from the register, or exclude them from the For Review tab if they have not been added yet. In the Banking center, select the unwanted transactions under For Review and choose Exclude; for ones already added, open the register and delete them in a batch.

Because there is no clean one-click rollback, it pays to get the file right before you import. Review every transaction in the converter, confirm the date range, and check the totals against the statement first. If your data happens to be in a spreadsheet rather than a PDF, a CSV to QBO converter lets you clean the rows in Excel and only then build the import file, which avoids most of these cleanups entirely.

Get the import right the first time

Most opening-balance headaches trace back to the import file, not to QuickBooks. A file with a clean, non-overlapping date range and accurate transactions reconciles on the first try. When you convert a PDF statement to a QBO file, review each line and set the date range before you download, then import into an account whose opening balance you have already confirmed against the statement.

If a file refuses to import at all rather than importing wrong, that is a different problem with its own fixes; see why a QBO file will not import into QuickBooks. To match the register to the statement once everything is in, follow the steps in bank reconciliation from PDF bank statements. And when you have a stack of months to bring in, a batch PDF to QuickBooks converter keeps each file in its own clean date range so duplicates never creep in.