Back to Reports
Balance Sheet Report
Financial position showing assets, liabilities, and equity at a point in time. Supports multi-period comparison and tracking filters.
Parameters
| Parameter | Required | Description |
|---|---|---|
| As of Date | Yes | Point-in-time snapshot date |
| Compare | No | Add 1-11 comparison periods (Monthly/Quarterly/Yearly) |
| Tracking | No | Filter by up to 2 tracking category/option pairs |
| Cash Basis | No | Show only paid transactions (default: accrual) |
| Hide Totals | No | Remove total/subtotal rows from the output (default: OFF). Available for Balance Sheet and P&L. |
| Display Mode | No | When using Compare: Columns (default) places periods side-by-side, Rows stacks them vertically. Locked after creation — insert a new report to change. |
Output
Account balances grouped by section (Assets, Liabilities, Equity) using Xero's standard layout format.
OrgID
OrgName
Section
Account
Balance
OrgID and OrgName are auto-added. When Compare is enabled, the Balance column is replaced with date-based period columns.
Tips
- Use Compare to show month-end position trends
- Use Tracking filters for business unit balance sheets
- "As of Date" reports show a snapshot - use date presets like "End of Last Month" for recurring reports
After Creation
Some settings can be changed after inserting a report; others are locked because they affect the column structure.
- Editable: Cash Basis, Tracking Filters, Hide Totals, Organizations, Date Range
- Locked: Comparison Periods, Timeframe, Display Mode — insert a new report to change these