You open the Begin Reconciliation window, check the statement, and the beginning balance is wrong. Maybe it says zero. Maybe it’s off by a few hundred dollars, or by one odd amount you can’t explain. If your QuickBooks beginning balance is incorrect, don’t just keep clicking to make the Difference field hit zero. The number is telling you something changed in the account, and the fix depends on what.
This guide shows you how to work out which problem you have, then walks through the fix for QuickBooks Desktop and QuickBooks Online.
What Is the Beginning Balance in QuickBooks?
The beginning balance is the total of every transaction QuickBooks has already marked as cleared or reconciled for that account. When you start a new reconciliation, QuickBooks should show the same figure as the ending balance on your last statement. If the two don’t match, something in the cleared history no longer adds up.
Why Is the QuickBooks Beginning Balance Wrong?
Almost every case comes down to one of these:
- The account never had an opening balance, or it was entered wrong when you set up the account.
- A reconciled transaction was edited, voided or deleted after the reconciliation was finished.
- A cleared transaction was unmarked, so it dropped out of the cleared total.
- The file was converted from another version, such as from Mac to Windows, or from an older release.
- Data damage in the company file.
- Bank feed transactions (QuickBooks Online) from before your statement start date were matched or accepted.
- The wrong account or statement date was picked in the Begin Reconciliation window. It happens more often than you’d think when two accounts share one bank.
Which Problem Do You Have?
Use the symptom to pick your starting point:
- Beginning balance is $0 and this is the first reconciliation: the opening balance was never entered. Go to Fix 1.
- Beginning balance is off and you reconciled this account before: something changed after the last reconciliation. Go to Fix 2, then Fix 3 or Fix 4.
- It started right after a file conversion or upgrade: go to Fix 5.
- The numbers keep shifting or reports disagree: possible data damage. Go to Fix 6.
- You use QuickBooks Online: skip to the QuickBooks Online section.
Before You Start
- Back up your company file. Every fix below can change reconciled data. Our guide on setting up a QuickBooks backup helps if scheduled backups aren’t running.
- Keep your last two bank statements handy. You’ll compare them with the Previous Reconciliation report.
- Check your closing date. If you’ve set a closing date and password, QuickBooks may block or warn about edits to older transactions. Don’t remove the password just to get a number to match. Talk to your accountant first.
- Make sure you picked the right account and statement date in the Begin Reconciliation window.
How to Fix an Incorrect Beginning Balance in QuickBooks Desktop
Fix 1: Correct a Zero Beginning Balance With an Opening Balance Entry
If this is the first time you’re reconciling the account, QuickBooks has no starting figure to show. Create one with a journal entry.
- Go to Company > Make General Journal Entries.
- Set the date to the start of your first statement, or the day before your first transaction.
- In the first line, choose the bank account. For a regular bank account, enter the opening amount in the Debit column. For a credit card or loan account, enter it in the Credit column instead.
- In the second line, choose Opening Balance Equity and enter the same amount in the opposite column.
- Click Save & Close.
Now reconcile it:
- Go to Banking > Reconcile and choose the account.
- Enter the statement date and ending balance from the statement that matches your opening entry.
- Click Continue.
- Tick the journal entry in the list. The Difference should now show 0.00.
- Click Reconcile Now.
If you later find a transaction already sitting in the account from before that date, see how to reconcile a bank account in QuickBooks for the full process.
Fix 2: Find What Changed Since the Last Reconciliation
When the balance is wrong but not zero, you need to find the transaction that moved. Start with the quickest report.
Reconciliation Discrepancy report
- Go to Reports > Banking > Reconciliation Discrepancy.
- Choose the account and click OK.
- The report lists transactions that were changed or deleted after they were reconciled. Look at the Entered/Last Modified column to see when each change was made.
Our guide on how to fix a QuickBooks reconciliation discrepancy goes deeper into reading this report.
Previous Reconciliation report
- Go to Reports > Banking > Previous Reconciliation.
- Pick the account and the most recent statement date, then click Display.
- Compare the cleared transactions with your paper or PDF statement. Any item that appears on one and not the other is a suspect.
If you’re on QuickBooks Pro, you can only open the latest reconciliation report. Save PDFs of every one as you go, so you have something to compare against later.
Audit Trail report
If the first two reports don’t show the culprit, the Audit Trail will.
- Go to Reports > Accountant & Taxes > Audit Trail.
- Click Customize Report, then Filters, and choose Account, then your bank account.
- Set the Date filter so From is blank and To is your last statement date.
- Set the Entered/Last Modified filter from the date of your last reconciliation to today.
- Click OK and look for edits, deletes or voids on cleared items.
Fix 3: Undo the Last Reconciliation and Do It Again
If you found a transaction that was changed, the cleanest fix is to put the account back to where it was and redo the reconciliation properly.
- Back up your company file.
- Go to Banking > Reconcile and choose the account.
- Click Undo Last Reconciliation, then Continue, then OK.
- Close the window, reopen Reconcile, and repeat the reconciliation with the corrected transactions.
If the undone statement isn’t the one that caused the problem, repeat for the earlier statement, working back until the beginning balance matches.
Fix 4: Use Enter Adjustment (Only as a Last Resort)
If you’ve hunted for an hour and can’t find the cause, QuickBooks lets you finish the reconciliation anyway. When the Difference isn’t zero, click Enter Adjustment.
What this actually does: QuickBooks posts a journal entry for the difference to an expense account called Reconciliation Discrepancies. The reconciliation closes, but the underlying error is still in your books, now hidden behind an adjustment. That affects your profit and loss.
If you go this route:
- Use it for small amounts you’ve decided aren’t worth chasing.
- Review the entry afterward in your Chart of Accounts, or search Edit > Find > Advanced for the memo Balance Adjustment.
- Tell your accountant about it.
For anything large, go back to Fix 2.
Fix 5: Check Balances After a File Conversion
Converting a file, whether from an older QuickBooks version, from Mac to Windows, or from QuickBooks Online, can leave some transactions unreconciled. That changes the beginning balance.
- Reconcile the account again and mark the transactions that should be cleared, using your last statement.
- Open the file you converted from, if you still have it, and compare the ending balances.
- If the file asked to be updated, see the “company file needs to be updated” pop-up.
If the move involved platform changes, our guide on converting a Mac QuickBooks file to Windows explains what can go missing.
Fix 6: Verify and Rebuild if the File Is Damaged
If balances keep changing for no reason, or the register and reports disagree, the company file itself may be damaged. Verify and Rebuild can repair it.
- Back up the file.
- Go to File > Utilities > Verify Data and let it finish.
- If it finds problems, go to File > Utilities > Rebuild Data and follow the prompts.
- Run Verify Data again to confirm the file is clean.
- Return to Banking > Reconcile and check the beginning balance.
If the file won’t open or the tools fail, try the QuickBooks Tool Hub, and see QuickBooks File Doctor not working if File Doctor refuses to run. Condensing a file in the past can also leave odd balances behind, which our guide on unable to condense data touches on.
How to Fix an Incorrect Beginning Balance in QuickBooks Online
QuickBooks Online reconciles differently. Instead of a Previous Reconciliation report, you’ll usually see an alert on the reconciliation page.
If You See an Alert on the Reconciliation Page
Click the link in the alert to open the discrepancy report, then match your situation:
- Unreconciled transaction: open the register, find the transaction, and set its status back to R (reconciled).
- Changed transaction: the amount, date or account was edited. Change it back to what it was and save.
- Mistakenly reconciled transaction: set its status to blank or C, save, and reopen the reconciliation.
- Deleted transaction: recreate the transaction in the register with the original date and amount, then mark it R.
Repeat until the difference shows 0.00, then choose Resume Reconciling. If you need to roll back a reconciliation, see how to undo a bank reconciliation in QuickBooks Online.
If the Account Was Never Reconciled
- Click the Gear icon, then Chart of accounts.
- Find the account and click View register.
- Look at the first transaction. If it’s an opening balance, check its date and amount against your statement and edit it if needed.
- If there’s no opening balance, create a journal entry dated before your first transaction, using Opening Balance Equity as the other side, then mark it reconciled.
If Bank Feed Transactions Caused the Problem
When you first connect a bank, QuickBooks Online may download about 90 days of transactions and set a starting balance from them. If your statement starts later or earlier than that, the opening figure can be wrong.
- Delete or exclude downloaded transactions dated before your statement start.
- Compare the register’s starting balance with your statement.
Our guide on connecting a bank account to QuickBooks Online covers the setup, and importing transactions into QuickBooks explains the manual route.
If Nothing Seems to Match
Open QuickBooks Online in a private window. If the balance looks right there, clear your browser’s cache and cookies for all time, which our guide on QuickBooks Error 400 walks through, then try again.
What About Opening Balance Equity?
Opening Balance Equity is the holding account QuickBooks uses for opening entries. It should end up at or near zero once your accounts are set up correctly. If it keeps a balance after you’ve fixed the beginning balance, that usually means some opening entries were made without a matching real account, or your starting balances haven’t been moved to the right equity accounts. Don’t zero it out yourself. Ask your accountant, because the right entry depends on your business type and tax setup.
How to Prevent Beginning Balance Problems
- Don’t edit, delete or void reconciled transactions. If you must, undo the reconciliation first.
- Enter the right opening balance when you create an account, using the statement.
- Reconcile every month, so mistakes show up while they’re small.
- Save a PDF of each reconciliation report, especially if you use QuickBooks Pro.
- Run the Reconciliation Discrepancy report before you start each new reconciliation.
- Set a closing date and password after each year-end close.
- Back up before conversions or big changes. If you’re moving the file to a new machine, our guide to moving QuickBooks to a new computer shows how to do it safely.
Need Help Getting the Balance Right?
If you’ve worked through the steps and the beginning balance still won’t match, or you’re worried about changing reconciled data in a file with years of history, our QuickBooks team can review the account with you and find what changed. Contact Data Service Solutions or call +1-(855)-955-1942.
Frequently Asked Questions
Why is my QuickBooks beginning balance zero?
The account has no opening balance, or QuickBooks has no cleared transactions to total up. This usually happens the first time you reconcile an account. Create an opening balance journal entry dated at the start of your first statement, then reconcile it.
Why does the beginning balance not match my bank statement?
A transaction that was already reconciled was edited, voided, deleted or unmarked. Run the Reconciliation Discrepancy report and compare the Previous Reconciliation report with your statement to find it.
How do I fix a beginning balance in QuickBooks Desktop?
Find what changed with the Reconciliation Discrepancy and Audit Trail reports. Then either undo the last reconciliation and redo it, or correct the transactions. Make a backup before you start.
Is it safe to use Enter Adjustment?
It’s safe in the sense that it won’t damage your file, but it doesn’t fix the cause. QuickBooks posts the difference to the Reconciliation Discrepancies expense account, which affects your profit and loss. Use it only for small amounts you’ve decided not to chase.
Can I change the beginning balance directly?
Not in the reconcile window, because it’s calculated from your cleared transactions. In Desktop, fix the transactions or create an opening entry. In QuickBooks Online, you can edit the opening balance transaction in the account register.
Does converting a file change the beginning balance?
It can. Reconciliation works differently on Mac, Windows and QuickBooks Online, so some transactions may come over as unreconciled. Reconcile again and compare the ending balances with your last statement.
What should the offset account be for an opening balance entry?
Opening Balance Equity. For a bank account, debit the bank account and credit the equity account. For a credit card or loan, credit the account and debit equity.
When should I ask an accountant or expert for help?
When the amount is large, when it affects a closed period, when Opening Balance Equity keeps a balance, or when the fixes don’t bring the numbers into line. Changing reconciled data can affect your tax filings.
