Financial Reports
Generate financial reports from Xero directly in Excel. Not all features are available on every report — see the capability matrix below.
| Feature | Reports |
|---|---|
| Multi-period compare | P&L, Balance Sheet, Budget Summary (Bank Summary deferred) |
| Tracking filters | P&L, Balance Sheet only |
| Cash Basis | P&L, Balance Sheet, Trial Balance |
| Hide Totals | P&L, Balance Sheet |
Report Features
Multi-Period Comparison
Add up to 11 comparison periods (Monthly, Quarterly, or Yearly) to see trends over time.
Tracking Filters
Filter by tracking categories like Region, Department, or Project to see segmented reports.
Cash or Accrual
Choose between cash basis (when money is received) or accrual (when invoiced).
Auto-Refresh
Date presets like "Last Month" automatically adjust when you refresh the report.
Available Reports
Profit & Loss
Income statement showing revenue, expenses, and net profit
Date RangeBalance Sheet
Financial position showing assets, liabilities, and equity
As of DateTrial Balance
All account balances in debit/credit format
As of DateAged Receivables
Single customer aging detail (select a contact)
As of DateAged Payables
Single supplier aging detail (select a contact)
As of DateBank Summary
Bank account activity over a date range
Date RangeExecutive Summary
Key financial metrics overview
As of DateBudget Summary
Budget amounts by period for each account
As of DateDate Range Types
| Type | Description | Reports |
|---|---|---|
| Date Range | Activity between From and To dates | Profit & Loss, Bank Summary |
| As of Date | Point-in-time snapshot | Balance Sheet, Trial Balance, Aging |
Note: Profit & Loss and Bank Summary reports are limited to a maximum 365-day date range by the Xero API. The report wizard prevents selecting a longer range in Fixed date mode.