Disclosure: This post contains affiliate links. If you sign up through our links, we may earn a commission at no extra cost to you — it helps keep our content free and independent.

Financial Reporting in Xero: P&L, Balance Sheets, Custom Reports

Xero financial reporting: For a small business, a useful financial report answers three questions: did we make money, what do we own and owe, and where is performance changing? Xero brings those answers together through standard reports, comparisons, tracking categories, budgets, and exports. Its set includes Profit and Loss (income statement), Balance Sheet, Cash Flow Statement, aged receivables and payables, and Budget Variance reports.¹

The important qualification is that a report is only as reliable as the bookkeeping behind it. Bank reconciliation, correct account coding, tax treatment, and period-end adjustments still matter. Treat Xero as a reporting system—not a substitute for review by an accountant when the numbers affect tax, lending, investors, or statutory accounts.

What Xero financial reporting includes

Xero reports use the transactions recorded in an organisation and can be run for a selected date range. Depending on the report, you can compare periods, filter by tracking category, change the presentation, and export a copy for further analysis or sharing.¹ Xero describes its reporting as using current accounting data, but “real time” does not mean every transaction is automatically correct or every bank feed has been reconciled.

A reporting routine combines:

• Performance reporting: P&L, sales, expenses, and budget-versus-actual results.
• Financial-position reporting: Balance Sheet, working capital, liabilities, and equity.
• Cash and collection reporting: Cash Flow, aged receivables, and aged payables.
• Management reporting: tracking categories, report layouts, formulas, notes, and selected report packs.

Feature availability can vary by country, organisation, and subscription. Check the plan and regional Xero Central guidance rather than assuming every screen behaves identically.²

P&L in Xero: measure performance over a period

The Profit and Loss report shows income and expenses for a period and calculates the resulting net profit or loss. It is a period report: changing the start or end date changes the activity included. That makes it useful for monthly close, year-to-date review, pricing decisions, and comparing this year with last year.

A simple review flow is:

1. Run the report for the month, quarter, or year you want to analyse.
2. Choose the accounting basis appropriate to the question—cash or accrual, where the report supports that option.
3. Add a comparison period, such as the prior month or the same month last year.
4. Inspect unusual movements by drilling into the underlying account or transactions where available.
5. Check that revenue, direct costs, payroll, tax, and one-off items are classified consistently.

A P&L can reveal a falling gross margin even when sales are growing, or show that a profitable month was driven by a non-recurring item. Pair it with the Balance Sheet and cash reports. Xero’s current reporting materials say most reports can be adjusted for date range, comparison period, and tracking-category filters; confirm the controls visible in your region and organisation.³

Balance Sheet in Xero: understand financial position

The Balance Sheet is a point-in-time report. It presents assets, liabilities, and equity as of a chosen date. Use it to review cash, receivables, inventory or fixed assets, loans, tax balances, payables, and owner or shareholder equity.

The accounting equation is:

Assets = Liabilities + Equity

A strong month-end review asks whether receivables are collectible, old payables are valid, bank and loan balances agree to statements, and tax accounts reflect filed or accrued amounts. Investigate unusual negative balances.

Retained earnings on the Balance Sheet represents accumulated profit from prior periods in the organisation’s accounting records. It is not the same as the current period’s sales or bank balance. The official Balance Sheet guidance explains the report’s treatment and available customization, which can differ by region and report version.⁴

Custom reports and Report Builder

“Custom reports” in Xero can mean two related things. First, you can customize an existing report’s date settings, columns, rows, grouping, formulas, notes, and filters. Second, in supported regions and organisations, Xero provides report-building tools for creating a report layout from available report components. Xero’s own product page describes adding, removing, and reordering rows and columns, adding formulas and notes, and linking to report schedules.¹

Reusable layouts help accountants produce consistent monthly packs and owners maintain a repeatable management view. Document the accounting basis, date convention, and tracking filters before saving one.

Custom reporting is not unlimited business intelligence. It remains tied to the data and dimensions in the Xero organisation. Businesses needing multi-entity consolidation, complex eliminations, or combined operational data may need spreadsheet work or specialist reporting software. Test the exact workflow with representative data before buying an add-on.⁵

Tracking categories: useful segmentation with setup discipline

Tracking categories let you tag transactions by a business dimension such as location, department, project, or service line. A P&L filtered by a tracking option can help answer questions that the company-wide report hides: which location is profitable, or which service line carries the highest direct cost?

The quality of the result depends on consistent tagging. Decide which transactions must carry a category, define who maintains the options, and review uncategorised entries during close. Each category adds coding and maintenance work.

A tracking-category report is also not automatically a full multidimensional analysis. Independent reporting guidance notes that standard reporting has constraints around comparing dimensions side by side and tracking-category budgets, so confirm the exact layout and filters available in your Xero edition before promising a management dashboard.⁵

Step-by-step: build a monthly Xero reporting pack

1. Close the source data

Reconcile bank accounts and payment providers, review unreconciled items, code bills and expenses, and check customer and supplier balances. Confirm that the reporting period is ready for review.

2. Run the core reports

Run P&L for the month and year to date, Balance Sheet at month end, aged receivables, aged payables, and relevant cash reports. Add a prior-period or budget comparison when useful.

3. Investigate exceptions

Look for material variances, missing categories, unusual margins, overdue invoices, unexpected liabilities, and balances that do not agree to external statements. Drill into transactions and record explanations for significant movements.

4. Apply a consistent layout

Use a saved custom layout or report pack where available. Keep headings, date labels, accounting basis, and comparison columns consistent so a reader can compare packs without relearning the format.

5. Export and review the final copy

Xero says reports can be exported as PDF or spreadsheet formats, with Google Sheets available in its export guidance.⁶ Open the exported file, check page breaks and totals, and mark whether it is draft or final. If the period is closed, consider an appropriate lock-date control; only authorised users should change it.¹

6. Share proportionately

Give stakeholders the minimum information they need and avoid emailing sensitive reports broadly. Xero describes MFA, encryption in transit and at rest, ISO 27001:2022 certification, and SOC 2 reporting; those controls do not replace good user permissions and safe sharing practices.⁷

Pros and cons for small businesses

Verified strengths: Xero provides core financial statements, comparison and filtering tools, custom layouts in supported workflows, and PDF or spreadsheet export.¹ Those capabilities can reduce repetitive spreadsheet preparation and make accountant collaboration easier.

Editorial trade-offs: customization requires a disciplined chart of accounts and tracking design. A straightforward business may find standard reports sufficient, while a multi-entity group or company needing extensive operational KPIs may need additional tooling. The trade-off depends on reporting complexity, not a universal feature score.

Xero financial reporting: FAQ

Does Xero have a P&L and Balance Sheet?

Yes. They are core Xero reports. The P&L measures income and expenses over a period; the Balance Sheet shows assets, liabilities, and equity at a date.¹

Can I create custom reports in Xero?

You can customize supported reports and save reusable layouts. Report Builder and specific layout options can vary by region, report, and organisation, so verify the current Xero Central instructions for your edition.²

Can Xero reports be exported?

Yes. Xero’s export guidance lists PDF and spreadsheet options and also documents Google Sheets export. Check the report’s own export menu because available formats can differ.⁶

Are Xero reports suitable for tax or statutory filing?

They can support bookkeeping and review, but a report is not automatically a completed tax return or statutory set of accounts. Confirm local requirements and have a qualified professional review material filings.

Are custom reports included in every Xero plan and country?

Do not assume so. Xero pricing and features are region-specific and can change. Confirm the current plan comparison and the organisation’s Xero Central documentation before relying on a particular report builder or forecasting feature.²

Neutral disclosure

This article is an independent educational draft, not accounting, tax, legal, or investment advice. It contains no affiliate claim or paid endorsement. For current product details, regional availability, and official terms, use Xero’s official website.

Sources