What we do
Tools
Industries
Department
How we workLet's talk →
Home/Xero/Xero Reporting
Xero

Xero Reporting: How to Lay Out, Publish and Export a Management Report

The lender wants last quarter's profit and loss as a PDF, and the owner wants the same numbers split by location with last year beside them. Xero can do both without a spreadsheet. Its reports run live off your books, and you can rearrange rows and columns, add formulas and notes, compare periods and split by tracking category. A finished version can be published as a read-only copy, so the numbers you sent don't change underneath you.

Xero reports at a glance

Where: every report, from the profit and loss and balance sheet to aged receivables and budget variance, sits in one place.

Accounting Reports

Change the layout: drag rows and columns, add formulas and notes, filter by date range, comparison period or tracking category.

Finish it: save a draft while you work, publish a read-only version when it's final, and archive old ones.

Send it: export any report as a PDF or an Excel spreadsheet, or share it with your advisor in Xero.

Building a monthly management report in Xero

  1. 1

    Open the report closest to what you need

    Accounting Reports

    For most packs that's the profit and loss. Set the date range, then add comparison periods, such as the same month last year.

  2. 2

    Split it by tracking category

    Add a tracking category, for example location or department, to see each part of the business in its own column.

    Watch for: an Unassigned column. Those are transactions nobody tagged with a tracking option, and they belong to someone.

  3. 3

    Rearrange the layout

    Drag rows and columns into the order your readers expect, remove the ones they don't need, and add formulas (a margin, a variance) and notes that explain a spike.

  4. 4

    Save a draft

    A draft keeps your layout changes while the month is still being closed, without making them final.

  5. 5

    Publish, then export

    Publish the report to make a read-only version that can't be edited afterwards, then export it as a PDF or Excel file for anyone outside Xero.

    Watch for: late entries. If someone can still post into the month after you publish, the published copy and the live books drift apart. A lock date stops that, and setting one needs the advisor user role.

When Xero's report and the accountant's figure disagree

Cash basis on one side, accrual on the other

How you'll know: Revenue on your profit and loss doesn't match the accountant's for the same month.

Fix: Check which accounting basis the report is set to, and run both versions the same way.

A department that looks too profitable

How you'll know: One tracking column is lean, and Unassigned is large.

Fix: Code the untagged transactions to their tracking option, then re-run the report.

The published pack no longer matches Xero

How you'll know: A bill dated last month was entered after you published.

Fix: Set a lock date at month end, and publish a fresh version if a correction has to go in.

A spreadsheet only one person can rebuild

How you'll know: The pack is three Xero exports and a CRM report pasted together, and it waits whenever that person is away.

Fix: Bring what you can into Xero's own layouts. What's left, figures from other systems in a fixed format, is a build job, covered below.

Xero reports or Syft from Xero

Xero now owns Syft, and it comes at no additional cost with qualifying Xero business plans.

Inside Xero

Xero's own reports

  • Every plan includes them, and they run live off one organization.
  • Custom layouts, formulas, notes, tracking categories and comparisons.
  • Drafts, read-only published versions and an archive.
  • PDF and Excel exports.
Alongside Xero

Syft from Xero

  • Consolidates across entities and currencies.
  • Ready-made report templates, and reports scheduled to go out ahead of time.
  • KPI scorecards, benchmarking and forecasts with several scenarios.
  • Pulls in data from other business software.

One organization and a standard pack: Xero's reports. Several companies to combine: try Syft before anyone builds a consolidation spreadsheet.

Board packs that mix Xero with other systems

Some packs still don't fit either tool: the board wants Xero's numbers next to the sales pipeline from a CRM, headcount from the HR system or job margins from operations software, laid out exactly as it has been for years. That's usually rebuilt by hand every month.

n-frames builds that pack from the Xero API's report and transaction data plus the other systems' own APIs, refreshed on a schedule into the format the board already reads, whether that's a dashboard or a workbook, so it's ready on the first working day without anyone copying a cell. If the setup is new to you, Xero covers what else connects to a Xero file.

Xero report questions

How do I build a custom report in Xero?

Go to Accounting, then Reports, open the report closest to what you want, and change its layout: drag rows and columns, add formulas and notes, set comparisons and tracking categories. Save it as a draft while you work, then publish a read-only version when it's final.

What are Xero management reports?

Reports made for running the business rather than for filing: usually a profit and loss, a balance sheet and a few custom views bundled together, produced each month for an owner, a board or investors.

Can Xero generate consolidated reports across multiple organizations?

Not from its standard reports, which each cover one organization. Syft from Xero does consolidate across entities and currencies, and comes at no additional cost with qualifying Xero plans, so try that first. A custom pipeline that reads each organization through the Xero API is for packs Syft's layouts can't produce.

Can I save a report template in Xero to reuse across clients?

Yes. Report templates let an advisor who works across several Xero organizations set a layout once and use it for each client, instead of rebuilding it file by file. Syft from Xero also comes with ready-made templates. Check Xero Central for which user roles can create templates in your setup.

What's the difference between Xero's standard reports and the custom report builder?

Standard reports are the fixed formats, such as profit and loss and balance sheet, updating live off your books. Customizing changes the layout of those same reports: which rows and columns show, in what order, with what formulas, comparisons and notes. The data underneath is identical.

Who builds a Xero report that pulls in numbers from other systems?

n-frames does that work, reading Xero through its API, joining it with the CRM, HR or operations data the board wants beside it, and delivering the pack on a schedule.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.