Xero

Xero Balance Sheet Error: Why It Does Not Balance and How to Fix It

A Xero balance sheet that does not balance or shows incorrect figures is almost always a data entry or account mapping issue -- not a Xero bug. Here is how to find and fix it.

What You Are Seeing

The most common Xero balance sheet errors include the report showing Assets do not equal Liabilities + Equity, retained earnings not matching the prior year closing balance, opening balances failing to import correctly, or comparative figures being wrong after a conversion from another platform. In some cases the report simply fails to load and returns a Report timed out message.

Why Xero Balance Sheets Go Out of Balance

Incorrect Opening Balances

Opening balances entered during setup that do not net to zero are the most common cause of a Xero balance sheet that will not balance.

Journal Entries Posted to Wrong Accounts

Manual journals that debit or credit an incorrect account type (e.g. posting income to an asset account) distort the balance sheet structure.

Retained Earnings Discrepancy

Xero calculates retained earnings automatically. If income or expense accounts have been reclassified, the retained earnings figure will shift unexpectedly.

Conversion Errors from Another Platform

Migrating from MYOB, QuickBooks, or Sage with unbalanced trial balance data brings the imbalance into Xero directly.

How to Fix Xero Balance Sheet Errors

Fix 1

Check and Correct Opening Balances

  1. 1

    Go to Accounting and select Advanced, then Opening Balances.

  2. 2

    Xero will show you whether your opening balances net to zero. Any amount shown in the Retained Earnings field that you did not enter is Xero absorbing an imbalance.

  3. 3

    Compare the opening balances against your prior platform's closing trial balance line by line.

  4. 4

    Correct any mismatched figures and save. The balance sheet will recalculate immediately.

Fix 2

Run the Account Transactions Report to Find the Culprit

  1. 1

    Go to Accounting and open Reports, then run Account Transactions.

  2. 2

    Filter by the balance sheet accounts that look wrong (Assets, Liabilities, Equity).

  3. 3

    Look for transactions posted to unexpected account types -- particularly income or expense accounts appearing under balance sheet sections.

  4. 4

    Click into any suspicious transaction and recode it to the correct account.

Fix 3

Check Manual Journals for Errors

  1. 1

    Go to Accounting, then Advanced, and select Manual Journals.

  2. 2

    Review all journals posted in the period where the balance sheet discrepancy begins.

  3. 3

    Check that every journal has equal debits and credits, and that account types are correct (e.g. not debiting a revenue account to record a purchase).

  4. 4

    Edit or reverse any incorrect journals.

Fix 4

Compare Balance Sheet to Trial Balance

  1. 1

    Run both the Balance Sheet and Trial Balance reports for the same date in Xero.

  2. 2

    The totals for assets, liabilities, and equity on both reports should match exactly.

  3. 3

    Any account that appears in one report but not the other points to an account type misconfiguration. Go to Chart of Accounts and check the account type setting for that account.

Related Xero Reporting Issues

Xero Reconciliation Errors Xero GST Errors Xero Export Errors Xero Bank Feed Not Updating Xero Integration Errors Xero Invoice Payment Errors

Xero Balance Sheet Still Not Balancing?

Finding the source of a balance sheet discrepancy can take hours of forensic work. Our Xero-certified team can pinpoint the issue and fix it correctly -- without disturbing your live data.

Book a Free 30-Min Session