Balance Sheet report (New)

The Balance Sheet report details the net worth of your organisation as at a particular date. This page covers the improved Balance Sheet, which lets you change account groupings, edit formulas and add your own columns.

Access and run the improved Balance Sheet report

  1. Go to Reports, then click All Reports.
  2. Under Financial, click ... to expand the section if the report is hidden.
  3. Click Balance Sheet (New).
  4. Select a date, then click Update to view your report.

Refine your report's settings

Click Report Settings to refine your report.

Image showing report settings fields.

After you've made your choices, click Update to close Report Settings and view your report.

Report settings explained

Compare periodsChoose the number of previous periods to compare with your selected period.
Accounting Basis

Choose Accrual to display revenue earned and expenses that occurred during the date range you selected.

Choose Cash to display revenue received and expenses paid during the date range you selected. For example, bill or invoice payments, spend or receive money transactions.

NumbersNumbers will show to 2 decimal places by default. To show only round numbers, click to clear the Show decimals checkbox.
RegionIf your organisation uses tracking, you can also filter by tracking category. The filters you choose will appear in a text block on the report. You can edit or remove the text block if you wish.

The Retained Earnings amount in your Balance Sheet is the Net Profit from your previous years' Profit and Loss reports, and also includes any other adjustments made for distributions etc.

You can see how it's made up by running the Account Transactions report for the retained earnings account, from the date you started using Xero.

Customise the report using the layout editor

Click Edit Layout to open the layout editor and:

  • Add your own columns for tracking, notes or other custom options.
  • Rearrange accounts and groups.
  • Move accounts between groups.
  • Edit formulas.
  • Move columns around by clicking and dragging.