QuickBooks Opening Balance Incorrect? How to Fix It

An opening balance is the amount you enter for an account, whether a bank account, credit card, customer, or vendor, as of the date you started tracking it in QuickBooks. When that starting number is wrong, everything built on top of it is wrong too: your reconciliations won't match your bank statement, your reports will be off by a consistent amount, and your balance sheet won't reflect reality. If your QuickBooks opening balance incorrect, the good news is that the fix is usually a specific, findable number, not a mystery. This guide explains why it happens and how to correct it properly rather than patching around it.

What an opening balance actually is

When you add a new account in QuickBooks, whether a bank account, a credit card, a customer, or a vendor, QuickBooks asks for a starting balance as of a specific date. This number is not a transaction in the normal sense. It represents everything that happened before you started tracking that account in QuickBooks, compressed into a single figure. QuickBooks records it as a journal entry, usually posted to an account called Opening Balance Equity.

Why a QuickBooks opening balance incorrect problem happens

• The wrong figure was entered when the account was first set up, often from memory rather than an actual statement

• The balance was entered as of the wrong date, so it doesn't match the account's true position on that day

• A bank or credit card account was entered using the current balance instead of the balance as of the actual start date

• A customer or vendor opening balance included transactions that were later entered again individually, doubling the amount

• The account was set up correctly at first, but a later edit or an accidental duplicate opening balance entry changed it

• Data was imported or converted from another system, and the opening balance did not map correctly during that process

Signs of a QuickBooks opening balance incorrect problem

• Your bank reconciliation shows a difference that exactly matches, or is a multiple of, your opening balance

• A customer's or vendor's balance in QuickBooks doesn't match what they say they owe or are owed, going back to before you started using QuickBooks

• Your balance sheet shows Opening Balance Equity with a nonzero balance long after setup, when it should typically be closed out

• Reports for a full year show your books were off by the same consistent amount since day one

How to find the actual correct opening balance

1. Identify the account's true balance as of your actual start date, using a bank statement, credit card statement, or the last known figure from your prior bookkeeping system.

2. For a bank or credit card account, use the statement balance dated as close as possible to your start date, not today's current balance.

3. For a customer or vendor, add up their unpaid invoices or bills as of your start date, rather than guessing at a single total.

4. Write this correct figure down along with its source, since you'll need it to compare against what's currently in QuickBooks.

Step-by-step: fixing a QuickBooks opening balance incorrect entry

Fix 1: Locate the original opening balance entry

1. Go to your Chart of Accounts and open the account in question.

2. Look for the very first entry in the register, usually labeled Opening Balance, dated as of your start date.

3. Note its current amount and date.

Fix 2: Correct a bank or credit card opening balance

1. Open the account register and find the Opening Balance entry.

2. Edit the transaction directly, changing the amount to match your verified statement balance.

3. Confirm the date matches your actual intended start date.

4. Save the change, then reconcile the account against your statement to confirm the numbers now agree.

Fix 3: Correct a customer or vendor opening balance

1. Open the customer or vendor record.

2. Find the opening balance transaction in their transaction history, usually the earliest entry.

3. Compare it against your verified total of unpaid invoices or bills as of the start date.

4. If it's wrong, edit or delete the incorrect opening balance entry, then enter the correct amount, or better, enter the actual outstanding invoices or bills individually if you have that detail available, since that gives you more useful reporting than a single lump sum.

Fix 4: Deal with a duplicated opening balance

If you suspect the opening balance was entered twice, either directly or because transactions before your start date were entered individually as well as through the opening balance:

1. Review the account register for two entries near your start date with similar or identical amounts.

2. Delete the duplicate, keeping only the correct entry.

3. Recheck the account balance against your verified figure.

Fix 5: Clean up Opening Balance Equity

After correcting individual account balances, check the Opening Balance Equity account itself.

1. Run a report on the Opening Balance Equity account.

2. For a business that has been using QuickBooks for a while, this account should typically be at or near zero, with its balance moved to owner's equity or retained earnings through a journal entry, once your accountant confirms that's appropriate.

3. Don't zero it out yourself without professional guidance if you are not confident about where the offsetting entry belongs on your books.

Fix 6: Reconcile after making corrections

Once you've corrected an opening balance, reconcile the account against your bank or credit card statement for the period covering your start date.

1. Go to the reconciliation tool for that account.

2. Enter your statement's ending balance and date.

3. Confirm the account now reconciles without a mystery difference.

If it still doesn't reconcile after fixing the opening balance, there may be a separate issue, such as a missing or duplicated transaction elsewhere in the account.

What to avoid when fixing a QuickBooks opening balance incorrect entry

• Don't just add an adjusting journal entry to force the balance to look right without understanding why it was wrong in the first place, since this can mask a deeper data problem

• Don't guess at the opening balance figure. Use a real statement or a real total from your source records

• Don't delete large numbers of transactions to "start over" without backing up your company file first

• Don't change opening balances on accounts you've already reconciled for later periods without understanding how that will affect those completed reconciliations

When this needs professional attention

A single account with a clearly identifiable, correctable opening balance is reasonable to fix yourself using the steps above. If the error touches multiple accounts, if you're not sure what the correct figure should have been, if Opening Balance Equity has a large, unexplained balance, or if fixing one account's balance seems to affect your reports in ways you don't understand, it's worth involving a professional before making further changes.

When to get professional help

If your QuickBooks opening balance incorrect problem spans multiple accounts, affects your financial statements in ways you can't fully explain, or you're not confident making the correction without creating a new problem, a QuickBooks-certified bookkeeper or accountant can review your books and fix it correctly. You can reach BizBooksAdvice at +1-866-408-0444.

Frequently asked questions

What causes a QuickBooks opening balance incorrect error in the first place?
The most common cause is entering the wrong figure or the wrong date when the account was first set up, often because the setup used a rough estimate or the current balance instead of a verified statement balance as of the actual start date.

Can I just delete the opening balance and start over?
You can, but back up your company file first, and understand that deleting it removes the starting point for the account's history. It's usually better to correct the existing entry with the right figure and date rather than deleting it outright.

Why does my bank reconciliation keep showing the same difference every month?
A wrong opening balance often shows up as a consistent, unchanging difference in every reconciliation after it, since the error carries forward from the starting point. Correcting the opening balance itself, rather than adjusting later transactions, usually resolves this.

Should Opening Balance Equity always be zero?
For an established business, yes, it should typically be at or near zero once your accountant has properly closed it out to owner's equity or retained earnings. A large, ongoing balance there is usually a sign something in the setup wasn't finished correctly.

Is fixing an opening balance the same as fixing why QuickBooks won't open?
No, these are unrelated despite the similar wording. An opening balance is an accounting entry for an account's starting figure. QuickBooks not launching is a separate technical issue covered in our main guide on why QuickBooks won't open.