Back to Reports
Profit & Loss Report
Income statement showing revenue, expenses, and net profit. Supports multi-period comparison and tracking category filters.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Date Range | Yes | From/To dates for the reporting period |
| Show | No | Number of prior comparison periods to add (1–11). |
| Frequency | No | Grouping for the comparison periods — Monthly, Quarterly, or Yearly. |
| Tracking | No | Filter by up to 2 tracking category/option pairs |
| Cash Basis | No | Show only paid transactions (default: accrual) |
| Costs & Expenses as Negative | No | Show cost of sales and operating expenses as negative numbers (default: ON) |
| Hide Totals | No | Remove total/subtotal rows from the output (default: OFF). Available for Balance Sheet and P&L. |
Date Range Limit
The date range cannot exceed 365 days (Xero API limitation). The wizard prevents selecting a longer range in Fixed date mode.
Multi-Period Comparison
Add prior comparison periods to see trends over time. Choose the number of periods and frequency (Monthly, Quarterly, or Yearly). Each period becomes its own row with a Date and Amount column:
| Account | Date | Amount |
|---|---|---|
| Sales | 31 Dec 24 | 50,000 |
| Sales | 30 Nov 24 | 45,000 |
| Sales | 31 Oct 24 | 48,000 |
| Expenses | 31 Dec 24 | -30,000 |
| Expenses | 30 Nov 24 | -28,000 |
| Expenses | 31 Oct 24 | -29,000 |
Tips
- Use Compare for board reports showing monthly or quarterly trends
- Use Tracking filters for departmental P&L
- Enable "Cash Basis" to match bank reconciliations
- The Date column uses absolute dates that update on refresh
After Creation
Some settings can be changed after inserting a report; others are locked because they affect the output structure.
- Editable:Cash Basis, Tracking Filters, Hide Totals, Costs & Expenses as Negative, Organizations, Date Range
- Locked: Show, Frequency — insert a new report to change these