Xero Custom Reports: 4 Ways to Build Them in 2026

If you've ever tried to create a custom report from Xero that doesn't look like it was designed by someone who hates finance professionals, you know the pain. The built-in reports are fine for basic stuff. But the moment your client or CEO asks for a board pack, a custom cash flow forecast, or a profitability report that actually matches how their business operates — you're either wrestling with Xero's layout editor or exporting to Excel and starting the copy-paste dance you've done a hundred times before.

This guide covers the main ways to get custom reports out of Xero in 2026, with honest assessments of what each method is actually good for.

The Four Approaches to Custom Xero Reports

There are really only four established paths to build reports that have a different structure from the standard P&L on Xero (AI assistants are the newcomer, and we come to them after Option 3):

• Xero's built-in report customization
• Export to Excel and build it yourself
• Build something with Xero's API (or use a BI tool that connects to it)
• Use a purpose-built reporting tool like Cheetah

Each has its place. Let's break them down honestly.

Option 1: Xero's Built-In Report Customization

Getting Started with the Layout Editor

Xero's customization lives in the Layout Editor, which you open by clicking "Edit layout" at the bottom of the Profit and Loss, Balance Sheet, Budget Variance, Cash Summary, Statement of Cash Flows, Movements in Equity or Blank report.

Once you're in the editor, you'll see your report broken into editable components. The interface is drag-and-drop, which makes rearranging things relatively intuitive.

What You Can Actually Do

Create and edit account groups. You can move accounts between groups, create new groups, or collapse multiple accounts into a single line item. This is useful when Xero's default groupings don't match how you think about your chart of accounts.

For example, if you want to combine "Food Ingredient COGS" and "Beverage" within Cost of Goods Sold, you can create the sub-group "Raw Ingredient COGS" and drag the relevant accounts into it.

Add custom columns. The Layout Editor lets you add columns for:

• Additional date periods (prior month, prior year, year-to-date)
• Variance columns ($ and %)
• Budget columns (if you've set up budgets)
• Percentage of revenue calculations

You add columns from the toolbar, then drag them into your preferred order.

Write formulas. You can create calculated rows using Xero's formula syntax. Common uses include:

• Gross margin percentage
• Operating expense ratios
• Custom subtotals that pull from specific account groups

The formula editor is basic but functional. You reference account groups by name, which can break if you rename things later.

Add text blocks and notes. You can insert text at the top or bottom of reports, or add annotations to specific line items. Useful for management commentary or explaining unusual variances.

Save as a custom layout. Once you've made your changes, click "Save as" and select "Custom." Your layout will appear in the Custom tab of the Reports menu, available for anyone in the organization with reporting access.

Management Report Packs

Xero also offers Management Report Packs, which bundle multiple reports (P&L, Balance Sheet, Cash Flow, etc.) into a single deliverable with an executive summary and space for commentary.

You can customize which reports are included, adjust the date ranges, and save the pack as a template. This is genuinely useful for recurring client deliverables — it beats exporting six separate PDFs and combining them manually.

For accounting firms, report templates now live in Xero Partner Hub (which now brings together Xero HQ and Practice Manager), which lets you apply templates across multiple client organisations (though you still need to generate each client's pack individually). Businesses can also build a pack straight from the Reporting menu in their own organisation.

Xero Analytics

Alongside the report layouts, Xero now includes Analytics. You get customisable dashboards, benchmarks and scheduled email delivery of dashboards and scorecards, with features varying by plan. It's built for quick insight on one organisation, not for reproducing your own P&L layout.

What You Can't Do

Here's where it gets frustrating:

Building from scratch only goes so far. Xero's Blank report gives you an empty page that you assemble yourself from account groups, schedules, formulas and text blocks. But it can't pull in anything that isn't a ledger balance, such as invoice-level detail, contact attributes or data from other systems. It also reports on one organisation at a time.

Multi-entity consolidation doesn't exist natively on standard plans. If you manage multiple Xero organisations (which most accounting firms do), Xero's own reports, including Xero Analytics, don't combine them. The exception is Xero Ultra, a plan Xero launched in Australia in July 2026 at A$500 a month, which includes consolidation. A UK beta is expected in autumn 2026, and we haven't seen an announcement for Singapore. Outside that plan, you run the same report for each organisation separately — or use a dedicated consolidation tool for Xero that handles eliminations and multi-currency for you.

Tracking categories only go so far. The newer Profit and Loss can compare tracking options side by side, and you can pair an option from one category with an option from the other in the same column (up to 200 columns). What it won't do is lay out the full Department by Region grid for you or show prior-period comparisons next to it. A monthly grid like that still tends to end up in a spreadsheet or a reporting tool.

Performance degrades with complexity. Large datasets, multi-year periods, or complex calculations can slow reports significantly. Month-end with multiple users running reports simultaneously can be painful. Browser limitations compound this — running multiple reports in different tabs while your cache fills up doesn't help.

Budgets are still entered per account. You can't type a budget against your own custom group in Budget Manager. But the Profit and Loss and Budget Variance reports both have the Layout Editor and can carry budget and variance columns. Test whether your regrouped layout gives you the comparison you need before assuming you have to leave Xero.

When Xero's Built-In Tools Make Sense

• Single-entity businesses with straightforward reporting needs
• Standard financial statements with minor tweaks (reordering accounts, adding a variance column)
• Quick ad-hoc reports where "good enough" is acceptable
• Management report packs for client deliverables where the standard formats work
• Situations where you'll run the report once or twice, not monthly

When They Don't

• Multi-entity reporting or consolidations
• Complex custom layouts that differ significantly from Xero's defaults
• Reports you need to produce repeatedly with minimal manual adjustment
• Dimensional analysis across multiple tracking categories

Verdict: Xero's native reporting has improved meaningfully over the years, and for single-entity businesses with standard needs, it can be sufficient. But the moment you need multi-entity views, data that isn't a ledger balance, or complex structures you have to rebuild every month, you'll hit limitations that no amount of Layout Editor finessing will solve.

Option 2: The Excel Export Workflow

This is the workhorse approach most finance professionals default to, and for good reason: Excel is familiar, flexible, and you control every cell. It also teaches you a tremendous lot if you're junior in your career looking to understand the nuts and bolts.

The Typical Workflow

• Export data from Xero (usually Trial Balance, transaction reports, or individual account details)
• Paste into your Excel template
• Rebuild formulas, fix formatting, adjust for this period's quirks
• Hope nothing breaks
• Repeat next month

The Problems

Xero's exports are designed for humans, not machines. The data comes out formatted for readability — merged cells, text headers, date formats that Excel interprets creatively. You'll spend time cleaning data before you can even start building.

It's manual. Every. Single. Time. Your cash flow forecast template is beautiful. But every month you're doing the same export-paste-adjust routine. Multiply that by the number of entities you manage. Live-data connectors such as G-Accon or LiveFlow take out the export step, but you still build and maintain the spreadsheet on top (we compare them in our guide to Xero reporting add-ons).

Formula fragility. One accidental row insert, one account code change, and your carefully constructed report breaks. You might not even notice until someone asks why the numbers don't tie.

Multi-entity hell. Need to consolidate five companies? That's five exports, five paste operations, and a consolidation logic layer that you pray doesn't have errors.

Version control chaos. Which Excel file is the latest? Who made changes? Is this the one we sent to the board or the draft?

When Excel Makes Sense

• Truly one-off analysis that you'll never repeat
• Ad-hoc modeling where you need maximum flexibility
• Situations where the report structure changes significantly each time
• Small operations where you're only managing one or two entities

When It Doesn't

• Any report you produce monthly (or more frequently)
• Multi-entity environments
• Reports that need to be audit-proof and error-free
• Teams where multiple people touch the same reports

Verdict: Excel is powerful but expensive in time. The flexibility that makes it great for ad-hoc work makes it terrible for repeatable processes. If you're spending 6+ hours a week on report building, you're not doing finance work — you're doing data entry.

Option 3: The API Route (Building It Yourself or Using BI Tools)

For the technically inclined, Xero has an API. You can pull data programmatically and pipe it into Power BI, Tableau, a custom dashboard, or whatever visualization tool you prefer.

What This Gets You

• Real-time or near-real-time data
• Flexibility to structure data however you want
• Integration with other data sources
• Automation (once it's built)

The Reality Check

Xero's API has quirks. Date formats aren't consistent across endpoints. Pagination behaves differently depending on what you're pulling. Some data types have idiosyncratic structures that require special handling. Plan for more development time than you expect.

You need someone to build it. Unless you have in-house development resources, you're hiring someone. Custom BI solutions aren't cheap, and they require ongoing maintenance as Xero's API evolves.

API pricing is tiered now. Xero's tiered, usage-based API pricing took effect on 2 March 2026. Up to five connected organisations is free (Starter). The sixth moves you to Core at A$35 a month for up to 50, then Plus at A$245 a month. Journals, the endpoint that pulls complete transaction data most efficiently, needs the Advanced tier at A$1,445 a month. Xero exempts bespoke integrations that an accountant builds for their own practice or a single client. Whichever tier applies, the bigger cost is building and maintaining the data pipeline.

When the API Route Makes Sense

• Large organizations with dedicated technical resources
• Situations where you need to blend Xero data with other sources (CRM, inventory systems, etc.)
• Enterprise-scale reporting with significant budgets
• Organizations already invested in a BI platform

If you decide this is for you, I've written a step-by-step guide on how you can build with Xero API.

When It Doesn't

• Small to mid-sized firms without development resources
• When the cost of building exceeds the cost of buying
• Organisations that need Journals-level data, which sits behind the Advanced tier at A$1,445 a month
• Teams that need something working this week, not this quarter

Verdict: The API route offers maximum flexibility but at significant cost in time, money, and ongoing maintenance. The tier fees are modest until you need Journals. The real cost is engineering time.

A newcomer: AI assistants. Since May 2026 Xero has offered a connector for Claude, and a Microsoft 365 Copilot agent followed in July, so you can ask plain-English questions of your live Xero data. The Claude connector was read-only at launch, which suits quick questions and one-off analysis. A board pack that needs the same structure and definitions every month still needs a defined template behind it, which is what the routes in this guide are for.

Option 4: Purpose-Built Reporting Tools

This is where specialized tools like Cheetah fit in.

The Approach

You provide a reference report — the cash flow forecast format your board expects, the aged receivables layout your client loves, the P&L structure that matches how they actually think about their business.

The tool systematizes it: connects to your Xero data, maps the fields, applies the logic. From then on, you generate that report with live data whenever you need it.

What This Solves

No more export-paste-format cycles. The report pulls live data. Month-end closes, you click generate (or let a schedule do it), you have your report.

Multi-entity without the pain. Need the same report across 10 companies? The logic is built once and applied everywhere.

The logic doesn't drift. The report definition is fixed, so every run rebuilds the sheet from the same mapping and rules. The data flows in. The structure stays consistent.

Someone else deals with the infrastructure. Data pipelines, API quirks, security, scalability — these are real problems, but they're not your problems. Finance professionals shouldn't need to think about pagination logic or date format inconsistencies or what happens when Xero changes an endpoint. A good reporting tool handles all of that so you don't have to.

Time goes back to analysis. When you're not spending hours on mechanics, you can spend hours on actually understanding what the numbers mean. That's the real work.

Honest Limitations

Purpose-built tools work best when your report structure is stable. If you're constantly reinventing your report format, you're better off in Excel.

They also require some upfront effort to set up. You're not exporting and pasting anymore, but you are defining what you want once.

And they can only report on what's in Xero. If your report needs data from three different systems, you'll need a solution that can integrate multiple sources.

When Purpose-Built Tools Make Sense

• Repeatable reports you produce monthly or more frequently
• Multi-entity environments
• Finance teams that want to spend time on insights, not mechanics
• Organizations where report accuracy is non-negotiable

When They Don't

• Pure one-off analysis
• Reports that change structure constantly
• Situations where all your reporting needs are genuinely simple (single entity, standard financials)

The Three Reports Everyone Struggles With

Let's get specific. These are the reports that cause the most grief, and how each approach handles them.

Custom P&L Layouts

The problem: Your client's business doesn't think in Xero's default account structure. They want revenue broken out by product line, COGS that separates direct labor from materials, and operating expenses grouped by function not account code.

Cash Flow Forecasts

The problem: You need a rolling forecast that shows where cash is heading — not just historical actuals, but projected inflows and outflows based on your outstanding receivables, payables coming due, and current cash position. Xero's cash flow report gives you actuals. The forecasting part is on you.

Aged Receivables by Custom Segments

The problem: You don't just want aged receivables. You want it by customer segment, or region, or sales rep. Xero's default aging report doesn't slice that way.

How to Decide

Here's a quick framework to make your decision:

Go with Xero's native tools if:

• You have one or two entities
• Your reporting needs align with Xero's default structures
• "Good enough" is genuinely good enough

Go with Excel if:

• It's truly a one-time analysis
• Your report structure changes constantly
• You enjoy spreadsheet work (no judgment)

Go with API/BI tools if:

• You have significant technical resources
• You need to integrate multiple data sources
• You're at enterprise scale with enterprise budgets

Go with purpose-built tools if:

• You're producing the same reports monthly
• You manage multiple entities
• Your time is better spent on analysis than mechanics
• You want reports that don't break

Frequently Asked Questions

Can you create custom reports in Xero?

Yes. Xero's Layout Editor (click "Edit layout" at the bottom of a financial report such as the Profit and Loss or Balance Sheet) lets you regroup accounts, add columns, write formula-based rows, insert commentary, and save custom layouts for reuse. You can even start from a Blank report. The catch is that everything is built from ledger account balances, so invoice-level detail, contact attributes and data from other systems need another route.

What are the limitations of Xero's custom reports?

The main ones: a Blank report can only be built from ledger account balances, there's no native multi-entity consolidation on standard plans, tracking categories can be compared side by side but Xero won't build a full two-dimension grid, performance degrades on large or complex reports, and budgets are still entered per account rather than against your own groupings.

Can Xero consolidate multiple entities or organizations?

Not natively on standard plans. Xero's own reports, including Xero Analytics, don't combine organisations. The exception is Xero Ultra, a plan Xero launched in Australia in July 2026 at A$500 a month, which includes consolidation. A UK beta is expected in autumn 2026, and we haven't seen an announcement for Singapore. Otherwise you run each entity separately and consolidate elsewhere, whether that's Excel, the Xero API, or a purpose-built consolidation tool that handles eliminations and multi-currency automatically.

Can you use two tracking categories in one Xero report?

Partly. The newer Profit and Loss can show tracking options side by side, including one option from each category in the same column, but Xero doesn't build the full two-dimension grid (Department and Region, say) or show prior-period comparisons alongside it. Monthly packs like that usually still need Excel, the API, or a dedicated reporting tool.

What's the best way to build custom Xero reports?

It depends on the job: the native Layout Editor for single-entity, standard tweaks; Excel for genuine one-offs; the API or a BI tool if you have engineering resources and multiple data sources to blend; and a purpose-built tool like Cheetah for repeatable, multi-entity, or bespoke reports you produce every month and need to not break.

Where Cheetah Fits

We built Cheetah because we think finance professionals should spend their time on analysis, not on wrestling with data exports and broken formulas.

Here's how it works: You give us your reference report — the exact format you want, whether that's a cash flow forecast, custom P&L, aged receivables breakdown, or something else. We systematize it so that it pulls live data from your Xero organization(s). We handle the data infrastructure, the API connections, the security, and the edge cases. When you need the report, you generate it. Every report arrives as a Google Sheet with a one-click Excel download, and you can schedule it to run for a rolling period like "last month" and land in your inbox. Current data, your format, minimal manual work.

If multi-entity reporting is your pain, our consolidation software for Xero is built for exactly the group views Xero can't produce natively on standard plans — eliminations, multi-currency, and bespoke group layouts included.

Interested? Get in touch — happy to show you how it works with your actual reports.

---

Updated 20 September 2026: we corrected what Xero's Blank report, tracking-category comparison and budget columns can do, added Xero Analytics and AI assistants, and brought the consolidation answers up to date with Xero Ultra. The API pricing section now follows Xero's tiered pricing from March 2026, and Xero HQ is now part of Xero Partner Hub.