How to Run a Balance Sheet Report in Xero
What Is the Quick Summary?
You can run a Balance Sheet report in Xero Accounting Software by selecting Reporting, then All reports, opening Balance Sheet, choosing an As at date, and clicking Update. Xero then lists your assets, liabilities, and equity on that date, using the data in your ledger.
This guide explains how to prepare your books, run the report, read each section, compare dates, and export the result. It also shows you how to fix common problems that make a Balance Sheet look wrong.
Key takeaways:
- A Balance Sheet shows your financial position on a single date.
- Assets always equal liabilities plus equity, so the report must balance.
- Reconcile bank accounts and approve all transactions before you run it.
What Is a Balance Sheet, and Why Does It Matter?
A Balance Sheet is a snapshot of what your business owns and owes on a specific day. Unlike a Profit and Loss report, which covers a period, the Balance Sheet captures one moment. Lenders use it to judge your stability, investors to value your company, and accountants to prepare year-end accounts.
Xero Accounting Software builds the report automatically from your chart of accounts. Every approved invoice, bill, payment, and journal feeds into it, so you never need to assemble the figures by hand.
What Is the Accounting Equation Behind the Report?
The Balance Sheet follows one simple rule: Assets = Liabilities + Equity. If you own 50,000 in assets and owe 20,000 in liabilities, your equity equals 30,000. When the report doesn’t balance, something is wrong with your data or setup.
How Does a Balance Sheet Differ From a Profit and Loss Report?
| Feature | Balance Sheet | Profit and Loss |
|---|---|---|
| Time frame | One date | A period of time |
| Main question | What do we own and owe? | Did we make a profit? |
| Key items | Assets, liabilities, equity | Income, costs, expenses |
| Typical audience | Lenders, investors, accountants | Owners, managers, tax authorities |
What Should You Prepare Before You Run the Report?
A Balance Sheet reflects the quality of your records. A few checks beforehand save you time later.
Which Data Checks Should You Complete First?
- Reconcile every bank account up to the report date.
- Approve draft invoices and bills that belong before that date.
- Record payments and allocate credit notes and overpayments.
- Post manual journals for depreciation, accruals, and prepayments.
- Review fixed assets and confirm that depreciation is current.
Why Does Bank Reconciliation Matter Most?
The Balance Sheet shows your bank balances. If you leave bank lines unreconciled, those balances may differ from your actual statements. Therefore, reconcile each account first and compare the Balance in Xero with the statement balance. Fixing differences now prevents confusing numbers later.
Is Your Chart of Accounts Correct?
The report groups figures by account type, such as current assets, fixed assets, current liabilities, and equity. Open Accounting, then Chart of Accounts, and confirm that each account sits in the right type. A loan coded as an expense, for instance, will distort both reports.
How Do You Run a Balance Sheet Report in Xero?
The steps are short and consistent. Xero Accounting Software places the controls at the top of the report screen.
What Are the Step-by-Step Instructions?
- Select Reporting from the main menu.
- Choose All reports.
- Under Financial Statements, click Balance Sheet.
- Pick the As at date, such as the last day of the month.
- Choose a Compare with option if you want earlier dates in extra columns.
- Select the Accounting basis, either accrual or cash, if the option appears.
- Add filters, such as a tracking category, if needed.
- Click Update.
After you click Update, Xero refreshes the figures. Always confirm the date before you share the report, because the numbers change with each date you choose.
Which Date Should You Choose?
Choose the date that matches your purpose. Use the last day of a month for routine reviews, the last day of a quarter for tax planning, and the last day of the financial year for annual accounts. Lenders often ask for a specific date, so check their request before you run the report.
Should You Use Accrual or Cash Basis?
Accrual reporting counts invoices and bills when you issue or receive them. Cash reporting counts them when money moves. Accrual provides a fuller picture of what customers owe you and what you owe suppliers. Because the choice affects receivables and payables, confirm the right basis with your accountant.
How Do You Read Each Section of the Balance Sheet?
Once the report loads, you will see three main groups. Understanding each one helps you interpret your financial health.
What Do Assets Include?
| Asset type | Examples | What it tells you |
|---|---|---|
| Bank | Current accounts, savings, cash | How much money you hold |
| Current assets | Accounts receivable, inventory, prepayments | What you expect to turn into cash soon |
| Fixed assets | Equipment, vehicles, property | Long-term resources you use to operate |
What Do Liabilities Include?
Liabilities show what you owe. Current liabilities, such as accounts payable, sales tax, and credit cards, fall due within a year. Non-current liabilities, such as long-term loans, fall due later. A high level of liabilities compared with assets may signal financial pressure.
What Does Equity Show?
Equity represents the owners’ stake in the business. It includes retained earnings, current year earnings, and owner contributions or drawings. Current-year earnings come from your Profit and Loss report, so changes in income or expenses flow into equity.
Which Ratios Can You Calculate?
You can use Balance Sheet figures to measure health:
- Current ratio equals current assets divided by current liabilities. A ratio above 1 suggests you can cover short-term debts.
- Debt-to-equity ratio equals total liabilities divided by total equity. A high ratio suggests heavy reliance on borrowing.
- Working capital equals current assets minus current liabilities.
How Do You Compare Balance Sheets Across Dates?
A single date has limited value. Comparison reveals movement and helps you plan.
How Do You Add Comparison Columns?
Use the Compare with option to add earlier months, quarters, or years. Xero shows each date in its own column. As a result, you can see whether cash, receivables, or loans grew or shrank over time.
Which Trends Deserve Your Attention?
- Rising accounts receivable that outpaces sales
- Falling cash while liabilities increase
- Growing loans without matching asset growth
- Equity that shrinks because of losses or high drawings
How Do You Drill Down Into a Line?
Click any account name on the report to open its transactions. This feature lets you quickly verify surprising figures. If you spot an error, fix the transaction and run the report again.
How Do You Customise the Balance Sheet in Xero?
The standard layout works for most businesses, yet you may need a tailored version. Xero Accounting Software offers several options, although availability depends on your plan and region.
How Do You Use Tracking Categories?
Tracking categories can split certain balances by department, location, or project. Set them up under Settings > Tracking categories, then apply them to transactions. Then filter the report to view one category at a time. Note that some Balance Sheet lines, such as bank balances, may not split by category.
How Do You Save a Custom Layout?
Many plans let you edit the layout, hide rows, group accounts, and add notes. Save the result to Custom reports so you can run it again without rebuilding it. This feature suits regular reporting packs for boards and lenders.
Which Customisations Help Most?
| Option | Benefit |
|---|---|
| Comparison columns | Shows change between dates |
| Hidden zero rows | Keeps the report short |
| Grouped accounts | Simplifies the view for non-accountants |
| Report notes | Explains unusual balances |
How Do You Export and Share the Balance Sheet?
A report must reach the right people to add value. Xero gives you several simple options.
How Do You Export to PDF, Excel, or Google Sheets?
After you run the report, select Export and choose your format. PDF fixes the layout for lenders and investors, while Excel and Google Sheets support further analysis. Check the date and filters before you export, because the file reflects the exact settings on screen.
How Do You Give Your Accountant Access?
You can email the exported file, or you can invite your accountant as an adviser user. The second approach gives them live data, so they always see the latest figures and can answer questions faster.
How Do You Fix Common Balance Sheet Problems?
Sometimes the report looks wrong. Most issues have clear causes and simple fixes.
Why Does the Balance Sheet Look Wrong?
| Symptom | Likely cause | Fix |
|---|---|---|
| Bank balance differs from the statement | Unreconciled lines or duplicates | Reconcile and remove duplicates |
| Accounts receivable differs from Aged Receivables | Manual journals to the receivables account | Review and correct the journals |
| Accounts payable differs from Aged Payables | Manual journals or unapplied credits | Review and allocate credits |
| Unexpected equity change | Edits to a closed period or wrong opening balances | Check conversion balances and lock dates |
| Large suspense or clearing balance | Unallocated transactions | Code the transactions correctly |
Why Do Receivables and Payables Not Match the Aged Reports?
The Balance Sheet and the aged reports should agree. A difference usually means someone posted a manual journal directly to the receivables or payables account, or a credit note remains unallocated. Run the Aged Receivables Summary and Aged Payables Summary for the same date and compare them with the Balance Sheet lines.
How Do You Prevent Repeat Problems?
- Reconcile weekly so differences never build up.
- Avoid posting manual journals to control accounts.
- Set a lock date after each closed period.
- Review conversion balances after you migrate to Xero.
- Ask your accountant to review year-end adjustments.
What Should You Remember About Running a Balance Sheet Report in Xero?
Running a Balance Sheet in Xero takes only a few clicks: open Reporting, select Balance Sheet, choose the As at date, and click Update. Prepare your records first, because reconciled bank accounts and approved transactions produce reliable figures. Then read the assets, liabilities, and equity sections, compare dates to spot trends, and export the report for the people who need it.
With this routine, Xero Accounting Software gives you a fast, dependable view of your financial position. Ask your accountant for help with adjustments such as depreciation or year-end entries, and consult Xero Central for the latest official guidance.
Frequently Asked Questions
Select Reporting from the main menu, choose All reports, and open Balance Sheet under Financial Statements. You can also search for the report by name.
Xero reports are built from double-entry data, so a true imbalance is rare. If the report looks wrong, check for incorrect conversion balances, edits to closed periods, or an unusual manual journal. Contact Xero support or your accountant if the problem persists.
Yes. Change the As at date to any past date and click Update. The report shows your position on that day based on the transactions recorded up to then.
