Financial Reports
Generate financial reports from Xero directly in Excel. Reports support multi-period comparisons and tracking category filters.
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 balances
As of DateExecutive Summary
Key financial metrics overview
As of DateBudget Summary
Budget amounts showing budget vs actual
As of DateDate Range Types
| Type | Description | Reports |
|---|---|---|
| Date Range | Activity between From and To dates | Profit & Loss |
| As of Date | Point-in-time snapshot | Balance Sheet, Trial Balance, Aging, Bank Summary |