How to Fix an Unbalanced Balance Sheet in QuickBooks
First try Rebuilding the file (File > Utilities > Rebuild Data). If you’re lucky, that’s all you’ll need.
If that doesn’t fix it, try searching for the amount you’re off. If there’s just one transaction causing the problem, this is usually the easiest way to find it.
If there are more than one causing the problem, you’ll need to do more research. Start by pulling a Balance Sheet report for All Dates and then select Month for Columns. Find the first month that it doesn’t balance, then change the dates to that month and select Day for Columns to find out what day doesn’t balance.
Then create a Custom Transaction Detail report for that day. If you Total the report by Account, it might be easier to identify the problem. Once you find the corrupted transactions, delete and re-enter them.
This article is provided for informational purposes and is not intended to be construed as legal, accounting, or other professional advice. For further information, please consult appropriate professional advice from your attorney and certified public accountant.