Fix QuickBooks Balance Sheet Out of Balance

Oct 24, 2025 |
Admin |
Estimated Read Time : 5 MIN

You must be wondering what to do when QuickBooks Balance Sheet Out of Balance. Before you proceed further, you must know that in the balance sheet, your total assets must be equal to your total liabilities. In case it is not, walk through this guide to figure out how to fix the issue with the balance sheet.

Before you begin, we would like you to make a backup of your company file since it may require you to edit transactions to fix the balance sheet issue. In this guide, we have covered everything that would bring out the expected result once you walk through this guide on the QuickBooks balance sheet out of balance.

Learn to fix your QuickBooks balance sheet when it is out of balance in QuickBooks Desktop

Step 1: Run the report on an accrual basis

In the Reports menu, click on Company & Financial.
Choose Balance Sheet Summary and click on Customize Report.

Click on Accrual on the Display tab.
Finally, hit OK.
You may need to rebuild your company file if your balance sheet is out of balance. Continue to sub-step 2 if it is out of balance on a cash basis only, or if, even after rebuilding, it remains out of balance.

Note:- Ensure whether the balance sheet is out of balance only on the accrual basis or on both cash and accrual basis.

Step 2: When your balance sheet is out of balance, find the date.

Navigate to the Reports menu.
Click on Company & Financials.
Select Balance Sheet Summary and choose Customizable Report.

Within the Display tab menu, click on Select All in the Dates option drop-down.
Enter the Report Basis section and select Accrual if your balance sheet is out of balance, or select Cash.
From the Display columns in the Columns section, choose Year and click OK.

You can make a comparison of your Total Assets Vs. Total Liabilities & Equity.
Make a check when your balance sheet goes out of balance.
After you find the year, you need to follow the same steps to confirm the exact date.
In step 2, repeat the same steps six times and click on Month from the Display columns’ drop-down.

Repeat sub-step two from 1st to 6th and select the Week.
Repeat the steps again, and this time select Day.

Finally, you can check the date of your report when it went out of balance and continue to step 3.

Step 3: Find the transactions that lead to the balance sheet being out of balance.

Click on the Report menu and choose Custom Report.
Select Transactions Detail.
Look for the Report Date Range section on the Modify Report window.

Select or enter the date you find the report went out of balance in the From and To fields.
Navigate to the Report Basis section and select Accrual if you find that your balance sheet is out of balance in accrual-only, or you can select Cash.
Uncheck Account, Split, Clr, and Clas in the Columns section.
When you do so, it will make the report easy to read.
Click on the Paid Amount column and select OK.
The amount that is out of balance should equal the ending balance in the Paid Amount.
You can check the report and find the transaction(s) that would add up to this amount.

Step 4: Re-date the transactions

You can change the dates if you find that the transaction(s) are causing the problem. Note down their current dates.
You can edit the date for each transaction to a day 20 years in the future.
Refresh the report after you save each transaction.
In case you found the correct transactions, the paid amount must now be zero after refreshing the report.
You need to locate the transactions that you must have dated in the future, and you could date them back to their original date.
Note:- Using and applying these re-dating steps would re-link the transaction and can repair it.

Step 5: Delete and re-enter the transactions

You must delete and re-enter the dates if changing the dates on the transaction(s) failed to fix the problem.

Step 6: Run a Vendor Report

Navigate to the Reports menu.
Click on Custom Reports.
Choose Transaction Detail, and a Modify Report window will open up.
In case it does not open, click on Customizable Report and navigate to the Display tab.

In the Display tab:

Set up your Report Basis to Accrual.
Set up the From and To fields to the day you found the balance sheet went out of balance.
Frame settings according to Total by Customer.

Filter tab:

Select Transaction Type on the Filters list.

Click on Multiple Transactions from the Transaction Type drop-down.
Mark Bill, Bill Credit, and Bill Payment, and finally hit OK.

Find the vendor with a non-zero sub-total, if the total is the amount that leads the Balance Sheet to go out of balance. The concerned vendor has damaged transactions.

You can add other transactions to the Transactions Type filter, such as Journal Entries, if the total is non-zero and not the amount by which the balance sheet went out of balance on this date.

Learn More – QuickBooks Something is Not Quite Right Error

Step 7: Run a Journal Report

Click on the Reports menu and select Accountant and Taxes.
Click on Journal and select Customize Report.
Now, navigate to the Display tab and set the Report Basis to the Accrual.

When the Balance Sheet goes out of balance, set the From and To fields.
Click on OK.

Note:- The Debit and Credit Totals would not match, and when the Balance Sheet is out of balance, it confirms that you now have the right date.

Also Read – View My Paycheck in QuickBooks Workforce

Step 8: Run a report for Other transactions

Click on the Reports menu and choose Custom Reports.

Click on Transaction Detail.
The Modify Report window will pop up automatically, and if it does not, you can click on Customize Report.
Now, navigate to the Display tab.

With the Display tab:

Set the Report Basis to Accrual.

Choose all from the Dates drop-down.
On the account list, set it to Total by.
Mark Item from the Columns list.
Click OK.
Now, navigate to the bottom of the report.

In case the last group of transactions has the Account column blank and has the heading No accnt, these transactions have no accounts assigned to them.

To fix this:

Navigate to the Lists menu and click on Item list.
Select Edit Item.
Change the Account type and click OK.
Repeat steps b and c, and change the Account back to the original account.
Click OK and repeat step d for each transaction that does not have an account.

Conclusion

Thanks for being with us so far! We find pleasure in providing you with concrete solutions to get your issues and errors related to QuickBooks fixed. However, sometimes, an error requires more advanced technical solutions that would only be available via our QuickBookSupportNet specialist at +1(866)500-0076.

Frequently Asked Questions

What is a Balance Sheet?

A balance sheet is a company’s financial statement that shows the company’s financial conditions at a certain point in time. A balance sheet contains details about a company’s assets, its liabilities, and the owners’ stake in the organization.

What happens if I get my data damaged?

If your specific forms of data were damaged, use these steps to recover them:

Backup your QuickBooks company file.
Click on the Lists menu and choose Chart of Accounts.
Right-click on the option Uncategorised Expense and click on Quick Report.
Click on Customize Report and select All from the Dates drop-down.
Navigate to the Filters tab.
Click on Posting Status.
Click on Either and hit OK.
Now, continue with repairing each transaction.
Keep on repeating step 7 to verify each transaction.

Where should I contact if I want to outsource to resolve the QuickBooks Balance Sheet being out of balance?

If you are looking to outsource this error and want your data to be protected while fixing the issue, contact our senior QuickBooks specialist at +1(866)500-0076

Why is My QuickBooks Balance Sheet Out of Balance? [Solved]