Opening Balance Wrong in QuickBooks After Import: How to Fix
No account needed for your first conversions. We never store your bank login.
Short answer: Importing transactions into QuickBooks never sets an opening balance. The opening balance comes from the figure you typed when you created the account, or from an Opening Balance Equity entry. If the number at the top of your register looks wrong after an import, you almost certainly have one of two different problems: a bad opening balance from account setup, or a wrong beginning balance on the reconcile screen caused by duplicates. They have different fixes.
These two phrases get used interchangeably and they are not the same thing. Sorting out which one you are actually looking at takes about thirty seconds and saves an afternoon.
Opening balance versus beginning balance: what is the difference?
The opening balance is a single transaction QuickBooks creates when you set up a bank or credit card account and type in a starting figure. It is dated the day your books begin and it posts against an account called Opening Balance Equity. The beginning balance is not a transaction at all. It is a number QuickBooks calculates on the reconcile screen by adding up everything you have already marked as cleared. One is something you entered. The other is something QuickBooks derives.
That distinction decides everything that follows. You fix an opening balance by editing a transaction. You fix a beginning balance by finding the transaction that changed underneath you.
| Symptom | Which balance | Usual cause | Fix |
|---|---|---|---|
| Register starts with the wrong amount on day one | Opening balance | Wrong figure typed at account setup, or taken from the wrong statement date | Edit the opening balance transaction |
| Reconcile screen shows a beginning balance that does not match the statement | Beginning balance | A previously reconciled transaction was edited, deleted or un-cleared | Run the Reconciliation Discrepancy report |
| Beginning balance is off by the exact amount of a few transactions | Beginning balance | The same transactions imported twice | Delete the duplicates, then re-reconcile |
| Opening Balance Equity has a balance sitting in it | Opening balance | Normal after setup, but it should not stay there | Journal it to Retained Earnings or owner's equity |
Why is my opening balance wrong in QuickBooks?
Because the figure entered at account setup did not match the bank on that exact date. The most common version of this: someone opened the account in QuickBooks in March, typed in the balance showing in online banking that morning, and then imported transactions going back to January. Now January and February transactions sit below an opening balance that already includes them, and every total is overstated by the same amount.
The fix is to make the opening balance match the closing balance of the statement immediately before your first imported transaction. If your first imported transaction is 2 January, the opening balance should be the 31 December closing balance, not today's balance. Find the opening balance transaction in the register, it is dated earliest and posts to Opening Balance Equity, and edit the amount.
Can an import change my opening balance?
No. A CSV upload or a .qbo import adds transactions to the register. It does not touch the opening balance transaction and it does not create one. This trips people up because the register total obviously changes after an import, so it looks like the opening balance moved. It did not. Only the running balance beneath it did.
There is one wrinkle worth knowing. A Web Connect file carries a ledger balance field internally, and some people assume QuickBooks reads it and sets the register from it. It does not use it to create an opening balance. QuickBooks builds your register balance from transactions, full stop.
Why is my beginning balance wrong in QuickBooks Online?
Because something that was already reconciled changed after the fact. A transaction that was marked cleared in a prior reconciliation got deleted, had its amount edited, had its date moved, or had its reconcile status flipped back to uncleared. QuickBooks recalculates the beginning balance from cleared transactions every time you open the reconcile screen, so any of those edits shows up immediately as a discrepancy.
Run the Reconciliation Discrepancy report. In QuickBooks Online it is under the reconcile history; in Desktop it is under Reports, Banking, Reconciliation Discrepancy. It lists exactly which transactions changed since the last reconciliation and by how much. In most cases the whole mystery resolves to one edited transaction.
How do duplicate imports break the beginning balance?
This is the failure mode that actually connects to importing, and it is the one to watch during catch up work. If you import a file covering January through March, then connect the bank feed, the feed pulls roughly the last 90 days and hands you many of the same transactions again. Accept them and the account now holds each transaction twice. Reconcile January and the beginning balance for February is off by whatever the duplicates totaled.
A properly built .qbo file protects you here. Every transaction inside it carries a unique ID, and QuickBooks uses that ID to recognize a transaction it has already imported and skip it. A raw CSV upload carries no such ID, which is why spreadsheet imports duplicate so readily and converted files usually do not. If you are backfilling history, convert the export with the CSV to QBO converter rather than uploading the spreadsheet, and import oldest range first.
What is Opening Balance Equity and should it be zero?
Opening Balance Equity is a holding account QuickBooks creates automatically to balance the entry when you type a starting figure for a new account. It is a temporary parking spot, not a real equity account, and once your setup is complete it should be zero. Leaving a balance in it means part of your books has never been assigned to a real account.
Clear it with a journal entry moving the balance to Retained Earnings, or to the owner's equity account for a sole proprietorship or partnership. Do this once, after you are confident every opening balance is right. Zeroing it out before you have finished setup just means doing it twice.
Can I change the opening balance in QuickBooks after transactions exist?
Yes. The opening balance is an ordinary transaction, so you can open it in the register and edit the amount or the date like any other. Two cautions. If the opening balance has already been marked as reconciled, editing it will throw a beginning balance discrepancy into your next reconciliation, so expect to see one. And if you edit it inside a closed period, QuickBooks will warn you and your prior period reports will move.
How do I fix a beginning balance discrepancy?
Work the discrepancy report rather than guessing. Open Reconciliation Discrepancy, identify each transaction that changed, and decide whether the change was correct. If it was a mistake, restore the original amount or date. If the change was legitimate, for example you deleted a genuine duplicate, enter an offsetting adjustment so the beginning balance ties back to the statement. Do not force a balance with a plug entry before you have looked at the report, because a plug hides the underlying error and it will surface again next month.
Why is my credit card opening balance negative?
Because a credit card is a liability, so a balance owed is entered as a positive liability, and the sign convention on imported card exports runs the opposite way from a bank export. A card file often lists purchases as positive and payments as negative, or the reverse, with no header telling you which. If charges land as payments your card register inverts. Check a handful of rows in the preview before you import, and see the credit card CSV to QuickBooks notes on the sign check.
Does the opening balance affect reconciliation?
Directly. The first reconciliation you run on an account uses the opening balance as its beginning balance, because nothing else has been cleared yet. If the opening balance is wrong, that first reconciliation cannot tie to the statement no matter how correct every imported transaction is. Fix the opening balance first, then reconcile. Doing it the other way around produces an adjustment entry that quietly memorializes the error.
What if I imported months of history and the balance is now unrecoverable?
It is recoverable more often than it looks. Undo the reconciliations back to the point where the balance was last correct, delete the duplicated batch, correct the opening balance to the statement close immediately before your earliest transaction, and re-import cleanly from that date forward. Tedious, not fatal. If the underlying records only exist as PDF statements, you can turn those statements into a spreadsheet first and work from clean rows rather than retyping a year of transactions.
A working order of operations
The sequence below prevents almost every version of this problem, and it costs nothing to follow on a new account.
- Decide the date your books begin, and find the bank statement that closes the day before it.
- Create the account in QuickBooks with that statement's closing balance as the opening balance, dated that day.
- Import transactions from your start date forward, oldest range first, as converted .qbo files so duplicates are caught by transaction ID.
- Reconcile the first month against the first statement. It should tie exactly.
- Once every account is set up and reconciled, journal Opening Balance Equity to Retained Earnings.
If your import needs to reach further back than the bank feed will go, the feed's roughly 90 day window is the constraint, not QuickBooks. The guide to importing older transactions covers how to pull and convert each range. For the mechanics of getting a clean file in the first place, start with how to convert CSV to QBO, or go straight to the CSV to QuickBooks Online converter. Desktop users need the Web Connect route described on the CSV to QuickBooks Desktop page, since Desktop will not read a spreadsheet of transactions at all.