Tuesday, July 16, 2013

How To Fix an Unbalanced Balance Sheet in QuickBooks

This problem does happen every once in a while. You enter transactions, you go through the motions, and then you run a month end report just to see that your balance sheet is unbalanced.

What causes this issue? Majority of the time it is because you have a corrupted transaction.  While this might sound intimidating, the solutions are easy to follow.

The first thing you should do is rebuild the file. Open your QuickBooks program. Click on File>Utilities>Rebuild Data. This should fix the problem.

If it doesn't work the next solution is to try to search for the amount that you are off. This isn't the most likely solution, but it doesn't hurt to try.

If there are multiple issues causing the problem, you'll need to dig deeper into your accounts by following theses steps:
  1. Pull your Balance Sheet report for All Dates then select month for Columns.
  2. Find the first month that the report does not balance.
  3. Change the dates to that month and select Day for Columns to find out what day does not balance.
  4. Create a Custom Transaction Detail report for that day.
  5. Total the report by Account.
  6. Identify the issue.
  7. Delete the transaction, then re-enter it.
  8. You're done!

Enhanced by Zemanta