You open QuickBooks Desktop to review your company's financial position, but the Balance Sheet shows that total assets do not equal total liabilities and equity. Even a small difference can create confusion when preparing financial statements or closing the books.

QuickBooks Balance Sheet Out of Balance means that the report's total assets do not equal its combined total liabilities and equity. The problem can result from damaged transactions, incorrect report settings, changes to historical records, or company-file data damage. The safest solution is to identify when the difference first appeared, locate the affected transactions, and correct only the records responsible.

Quick answer: Open QuickBooks Desktop and run the Balance Sheet Summary using the accrual accounting method. Compare total assets with total liabilities and equity. If the report is still out of balance, create a verified backup, check the company file, and narrow the problem down by year, month, week, and day. Review the transactions responsible before changing anything.

What Does QuickBooks Balance Sheet Out of Balance Mean?

A Balance Sheet is a financial report that shows a company's assets, liabilities, and equity at a particular date.

The basic accounting equation is:

Assets = Liabilities + Equity

Assets represent what a business owns or controls, such as cash, equipment, inventory, and accounts receivable.

Liabilities represent what the business owes, including loans, unpaid bills, and other financial obligations. Equity represents the owner's financial interest in the business after liabilities are deducted from assets.

For example, imagine a business has:

  • Total assets: $125,000
  • Total liabilities: $45,000
  • Total equity: $80,000

The report balances because $45,000 plus $80,000 equals $125,000.

Now imagine the report displays total liabilities and equity of $124,500. The difference is $500.

That difference indicates that something needs investigation. It does not automatically mean that a particular bank account is incorrect. The problem could involve a transaction, a report calculation, or the company file itself.

Why Is Your QuickBooks Balance Sheet Out of Balance?

Understanding the possible causes helps prevent unnecessary changes to financial records.

Here are some common reasons a QuickBooks Desktop Balance Sheet may show incorrect totals.

1. Damaged or Incorrect Transactions

An individual transaction may contain damaged accounting information or an incorrect relationship with another transaction.

This can happen with invoices, payments, credit memos, journal entries, and other accounting records.

For example, an invoice may have a related payment or credit memo that is not linked as expected. The individual transaction may still appear in the company file, but the financial report may calculate incorrectly.

2. Incorrect Journal Entries

Journal entries affect multiple accounts and can change the Balance Sheet significantly.

A journal entry with an incorrect account, date, debit, credit, or relationship to an existing transaction can create unexpected financial results.

Review journal entries carefully, especially those involving Accounts Receivable, Accounts Payable, and credit memos.

3. Changes to Historical Transactions

Editing, deleting, or recreating older transactions can affect previously prepared financial reports.

This is particularly important when a company has already completed bank reconciliations, filed tax returns, or closed an accounting period.

4. Company-File Data Damage

A damaged QuickBooks Desktop company file may cause financial reports to display inconsistent information.

If the discrepancy continues after checking the report settings and investigating transactions, company-file data damage may be involved.

5. Incorrect Report Settings

Sometimes the accounting records are correct, but the report is being displayed with an unsuitable date range, reporting basis, or column setting.

Before repairing anything, verify that the report is using the intended accounting method and reporting period.

Start Here: Which QuickBooks Balance Sheet Problem Are You Facing?

Before making changes, identify the symptoms.

  • The report is out of balance only for one reporting date: Narrow the reporting period and investigate transactions around that date. Estimated initial investigation: 15–30 minutes.
  • The report is out of balance for multiple periods: Compare historical reports and identify the earliest period showing the difference. Estimated initial investigation: 30–45 minutes.
  • The report is correct on a cash basis but incorrect on an accrual basis: Follow the accrual-basis troubleshooting process and check the company file.
  • The report changes after refreshing: Check whether the issue is temporary report display behavior before changing transactions.
  • The discrepancy appeared after an upgrade: Preserve the current company file and a backup from before the upgrade. Investigate whether the problem began during the conversion.
  • The difference involves a specific invoice or journal entry: Review the transaction history and related records before editing anything.


This decision process helps distinguish a reporting problem from an accounting-data problem.

How Do You Fix QuickBooks Balance Sheet Out of Balance?

The following steps provide a structured way to investigate the discrepancy in QuickBooks Desktop.

Step 1: Create a Backup of Your Company File

Estimated time: 5–15 minutes.

Before attempting a repair, create a verified backup of the QuickBooks Desktop company file.

Follow these steps:

  1. Open QuickBooks Desktop.
  2. Select the File menu.
  3. Choose Back Up Company.
  4. Select Create Local Backup.
  5. Choose a secure storage location.
  6. Run the backup verification option when available.
  7. Confirm that the backup file has been created successfully.

The working company file generally has a .QBW extension, while a local backup generally has a .QBB extension.

Keep the backup separate from the original company file.

Do not skip this step. Some troubleshooting methods involve changing transaction dates, editing entries, or rebuilding company-file data.

If the backup fails: Check the available disk space, folder permissions, and destination drive. Do not proceed with a repair until you have a usable recovery copy.

Step 2: Run the Balance Sheet on an Accrual Basis

Estimated time: 5–10 minutes.

Intuit's documented troubleshooting process begins by checking the Balance Sheet on an accrual basis.

In QuickBooks Desktop:

  1. Open the company file.
  2. Select Reports.
  3. Choose Company & Financial.
  4. Select Balance Sheet Summary.
  5. Click Customize Report.
  6. Open the Display tab.
  7. Find the Report Basis section.
  8. Select Accrual.
  9. Click OK.

Compare total assets with total liabilities and equity.

Record whether the report is out of balance on:

  • Accrual basis only.
  • Cash basis only.
  • Both cash and accrual basis.

This distinction helps determine which troubleshooting steps to follow next.

If the report is out of balance on an accrual basis, Intuit's documented procedure recommends rebuilding the company file before continuing with transaction-level investigation.

If the report still shows a difference: Preserve the backup and proceed to the company-file verification and rebuild process appropriate for your QuickBooks Desktop release.

Step 3: Verify and Rebuild the Company File

Estimated time: 15–45 minutes, depending on file size and condition.

QuickBooks Desktop includes built-in utilities that can help identify and address certain company-file data problems.

First, run Verify Data:

  1. Open QuickBooks Desktop.
  2. Select Window and close any open company windows if necessary.
  3. Select File.
  4. Choose Utilities.
  5. Select Verify Data.
  6. Allow the verification process to finish.
  7. Review the results.

If QuickBooks identifies a problem and recommends rebuilding the file, use the appropriate rebuild process after confirming that a verified backup exists.

The general menu path is:

File → Utilities → Rebuild Data

Follow the prompts and allow the operation to finish. Afterward, run Verify Data again to check the company file.

Rebuilding is not a universal solution for every report discrepancy. It should be used according to the diagnostic results and applicable Intuit instructions.

If the report remains out of balance: Continue with the historical date investigation. Do not assume that rebuilding has corrected every damaged transaction.

Step 4: Find the Date When the Balance Sheet First Went Out of Balance

Estimated time: 15–30 minutes.

This is one of the most useful parts of the investigation.

Instead of reviewing thousands of transactions individually, narrow down the date when the discrepancy first appeared.

Follow these steps:

  1. Open Reports.
  2. Select Company & Financial.
  3. Open Balance Sheet Summary.
  4. Select Customize Report.
  5. Open the Display tab.
  6. Set the date range to All.
  7. Select the appropriate report basis based on your earlier results.
  8. Under Display columns by, choose Year.
  9. Click OK.

Compare the yearly totals and identify the period in which the difference first appears.

Next, narrow the investigation:

  • Change the columns to Month to identify the affected month.
  • Change the columns to Week to locate the affected week.
  • Change the columns to Day to identify the exact date.

Keep the reporting basis consistent throughout this process.

This approach turns a broad accounting discrepancy into a much smaller transaction investigation.

If the date is still unclear: Review the report filters and date range. Confirm that the report is not excluding accounts or transactions that should be included.

Step 5: Identify the Transactions Causing the Difference

Estimated time: 15–45 minutes.

Once you identify the date, investigate the transactions recorded on that day.

QuickBooks Desktop provides a Custom Transaction Detail report that can help identify the records involved.

Follow these steps:

  1. Select Reports.
  2. Choose Custom Reports.
  3. Open Transaction Detail.
  4. Enter the identified date in both the From and To fields.
  5. Select the appropriate report basis.
  6. Customize the columns to make the report easier to review.
  7. Include the relevant transaction amount information.
  8. Review the ending balance and compare it with the amount of the discrepancy.


Intuit's documented procedure uses the Paid Amount column during this investigation. Depending on the report configuration, the ending balance can help identify the transactions contributing to the difference.

Look for transactions whose amounts add up to the reported discrepancy.

Pay particular attention to:

  • Customer invoices and payments.
  • Vendor bills and payments.
  • Credit memos.
  • Journal entries.
  • Inventory returns and discounts.
  • Transactions that were edited or deleted.
  • Records dated outside their intended accounting period.

If you cannot identify the transaction: Expand the investigation using customer, vendor, journal, and other transaction reports. Avoid changing entries based only on similar amounts.

Step 6: Review and Correct the Affected Transactions

Estimated time: 15–30 minutes for a simple transaction; longer for historical accounting corrections.

After identifying the transaction responsible, review its original date, amount, account assignments, and related records.

Check whether:

  • The transaction was entered twice.
  • A payment was linked to the wrong invoice.
  • A credit memo was not connected correctly.
  • A journal entry contains an incorrect account.
  • The transaction date was changed unexpectedly.
  • The record was modified after a previous reconciliation.

Intuit's documented troubleshooting procedure describes a transaction re-dating method for certain identified damaged transactions.

The process involves recording the original dates, temporarily changing the affected transaction dates to a date 20 years in the future, saving the transactions, checking the report, and then restoring the original dates.

This is a specialized re-linking procedure, not a general accounting adjustment. Use it only when the affected transaction has been identified and the procedure is appropriate for the specific problem.

If this does not resolve the discrepancy, Intuit's instructions describe deleting and re-entering the affected transactions as another possible step.

Do not delete or recreate historical financial records casually. Such changes can affect previous financial statements, reconciliations, tax records, and customer or vendor balances.

If the difference remains: Stop and review the transaction relationships with an accountant before making further changes.

Conclusion: Fix QuickBooks Balance Sheet Out of Balance Carefully

When QuickBooks Balance Sheet Out of Balance appears, the right response is to investigate the difference instead of entering an adjustment immediately.

Start with the accrual-basis report, preserve a verified backup, check company-file integrity, and narrow the problem down by year, month, week, and day. Once the affected transactions are identified, review their accounting relationships before making corrections.

QuickBooks Tool Hub and QuickBooks File Doctor can help with certain application and company-file problems, but accurate financial reporting depends on correcting the actual cause of the discrepancy.

Data Service Team encourages businesses to review their accounting records carefully and avoid unnecessary changes to historical transactions. For a consultation, call +1-888-718-7888 — Free Consultation.

Quick Questions and Answers

Q1. Why is my QuickBooks Balance Sheet out of balance?

A QuickBooks Balance Sheet may be out of balance because of damaged transactions, incorrect journal entries, changes to historical records, or company-file data damage. Incorrect report settings can also create misleading results. Check the accrual-basis report first, then identify the earliest date when the discrepancy appears.

Q2. How do I find the date when my Balance Sheet went out of balance?

Open the Balance Sheet Summary, customize the date range to All, and display columns by Year. Identify the first affected year, then narrow the results by Month, Week, and Day. This method helps locate the transactions responsible without manually reviewing the entire company file.

Q3. Can QuickBooks Tool Hub fix an out-of-balance report?

QuickBooks Tool Hub provides diagnostic utilities for certain Desktop application and company-file problems. It does not automatically correct incorrect journal entries or damaged transaction relationships. If the discrepancy comes from an accounting record, investigate and correct that transaction rather than relying on a diagnostic utility alone.

Q4. Does QuickBooks File Doctor repair Balance Sheet errors?

QuickBooks File Doctor can investigate certain company-file and network-related problems, but it is not a dedicated Balance Sheet repair application. If the report is incorrect because of a damaged transaction relationship, identify the affected transaction and follow the appropriate accounting correction procedure.

Q5. Should I rebuild my QuickBooks company file if the Balance Sheet is out of balance?

Rebuilding may be appropriate in certain documented troubleshooting situations, particularly when the accrual-basis report is out of balance. Create a verified backup first, run Verify Data, and follow the applicable repair instructions. Rebuilding is not guaranteed to resolve every financial-report discrepancy.

Q6. Can an incorrect journal entry make a Balance Sheet go out of balance?

An incorrectly recorded journal entry can create unexpected account balances and affect financial reporting. Review the debit and credit accounts, transaction date, amounts, and relationships with invoices or credit memos. Correct historical entries carefully because changes may affect previously prepared financial statements.

Q7. Why is my QuickBooks Balance Sheet correct on a cash basis but incorrect on an accrual basis?

Cash-basis and accrual-basis reports recognize financial activity differently. If the report is incorrect only on an accrual basis, investigate the accrual-basis data and follow the appropriate company-file troubleshooting process. Do not assume that changing the report basis fixes the underlying accounting problem.

Q8. Can I fix an out-of-balance QuickBooks report with a journal entry?

A journal entry should not be created merely to force total assets to equal liabilities and equity. First identify the transaction or data problem causing the difference. An unexplained adjustment can hide the original error and make future financial statements less reliable.