QuickBooks Balance Sheet Out of Balance: How to Fix It

A QuickBooks balance sheet goes out of balance when total assets stop equaling total liabilities plus equity, usually because of a damaged transaction, a transaction posted to a date the report does not cover, or a difference that only appears on a cash basis report. The fix is to find the exact date the report broke, isolate the transaction behind it, then correct or re-enter that transaction. Back up the company file first, because you may need to edit entries.

Most out-of-balance reports trace back to one or two bad transactions, and QuickBooks gives you a fast way to pin down the date. The harder version is a balance sheet thrown off by a whole period of bank activity that never made it into the books, since the live feed only reaches back about 90 days and quietly drops connections. When a missing month is the cause, the quickest fix is to convert the statement PDF to a .qbo file with the tool above and import it, so every line the bank holds is back in QuickBooks before you reconcile. Here is how to work through each cause.

Why is my balance sheet out of balance in QuickBooks?

Your balance sheet is out of balance because total assets no longer equal total liabilities plus equity, which should always be true. The usual causes are a damaged or corrupted transaction, a multi-currency rounding issue, a transaction with a date outside the report range, or a report run on a cash basis that exposes an unbalanced cash entry. Each leaves the report showing two totals that do not match.

How do I fix a balance sheet that is out of balance in QuickBooks?

Back up the company file first. Then run the Balance Sheet Summary for all dates to find the day the report went out of balance, open the transactions on that date, and change their dates to flush them out. If changing the dates does not fix it, delete and re-enter those transactions. In QuickBooks Desktop, rebuild the data file when the report is out of balance on an accrual basis.

Is my balance sheet out of balance in cash or accrual basis?

Run the report both ways to find out. In QuickBooks Desktop go to Reports, Company and Financial, Balance Sheet Summary, then Customize Report and switch the basis between Accrual and Cash. If it is out of balance in accrual, rebuild the company file first. If it is out of balance only in cash basis, or still off after a rebuild, move on to finding the damaged transaction by date.

How do I find the transaction causing the balance sheet to be out of balance?

Find the date the report first broke. Go to Reports, Company and Financial, Balance Sheet Summary, select Customize Report, and on the Display tab set the Dates dropdown to All. Then narrow the date range, year by year, then month, then day, watching for where the two totals stop matching. The day the report goes out of balance holds the transaction causing it.

How do I fix the damaged transaction once I find it?

Open the transactions dated on the day the report broke and change each one's date to a day or two later, then back. Re-saving often rewrites a damaged transaction and balances the report. If editing the date does not work, delete the transaction and re-enter it exactly. Always back up the file before editing, since a wrong delete is harder to undo than the original problem.

Why does my balance sheet only go out of balance on a cash basis?

A cash basis balance sheet can go out of balance when an invoice or bill has a transaction linked to it that posts to a balance sheet account, like inventory or a payment applied across periods. QuickBooks converts accrual entries to cash on the fly, and certain linked transactions do not convert cleanly. The accrual report usually balances, while the cash version shows the gap.

Does rebuilding data fix an out-of-balance balance sheet?

Rebuilding the QuickBooks Desktop data file fixes an out-of-balance report when the cause is file damage rather than a single bad entry. Go to File, Utilities, Rebuild Data, and run Verify Data afterward to confirm. Rebuild first when the report is out of balance on an accrual basis. If the report is off only in cash basis, a rebuild rarely helps, so go straight to finding the damaged transaction.

Can missing bank transactions throw off the balance sheet?

Yes. When a month of bank activity never imports, the cash account and its offsetting entries are both absent, so the books carry the wrong cash balance and the balance sheet can drift. The live feed only pulls about the last 90 days and leaves a hole when it disconnects. Importing the missing period from the statement restores both sides of each entry and corrects the account. Firms rebuilding a full year before a filing deadline should follow the same route used to import bank statements into QuickBooks for taxes, month by month.

How do I import a missing bank period to correct the balance sheet?

Download the statement for the missing months, convert each PDF to a .qbo file with the bank statement to QBO converter at the top of this page, then in QuickBooks Online go to Transactions, Bank transactions, Upload from file. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. The transactions post with their real dates, so the cash account fills in and the balance sheet has every entry it needs.

Why does my balance sheet show a number for an unspecified account?

An out-of-balance amount sometimes appears against a blank or unnamed account line on the report. That line is QuickBooks flagging the unmatched total it cannot tie to a real account, which points to a damaged transaction rather than a normal entry. Use the date drill-down to find the day it appears, then repair or re-enter the transaction sitting on that date.

Can a journal entry put the balance sheet out of balance?

A standard journal entry cannot, because QuickBooks forces debits to equal credits before it saves. What does cause it is a journal entry posted to the wrong period, a one-sided entry created by data damage, or an entry later corrupted in the file. Review recent journal entries near the break date, confirm each is balanced, and re-save or re-enter any that look off.

How do I prevent my balance sheet from going out of balance?

Back up before large edits, reconcile every account monthly, and avoid deleting transactions that are already reconciled. Run Verify Data in QuickBooks Desktop periodically to catch file damage early, and import any bank month the feed skips so no period is missing. Regular reconciliation and a clean feed keep assets, liabilities, and equity tied together so the report stays balanced.

For related fixes, see why your bank balance doesn't match QuickBooks, how to fix a reconciliation discrepancy in QuickBooks, and how a wrong beginning balance breaks the next reconciliation. When a month is missing, follow the steps to import bank transactions further back than 90 days. To audit the raw figures behind a damaged report, a bank statement to Excel converter drops every line into a spreadsheet you can sum, a CSV to QBO converter handles accounts that only export CSV, and uncashed bills sitting behind a swollen cash balance are easier to track with accounts payable automation.