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.
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.
Where: every report, from the profit and loss and balance sheet to aged receivables and budget variance, sits in one place.
Accounting › ReportsChange 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.
For most packs that's the profit and loss. Set the date range, then add comparison periods, such as the same month last year.
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.
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.
A draft keeps your layout changes while the month is still being closed, without making them final.
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.
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.
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.
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.
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 now owns Syft, and it comes at no additional cost with qualifying Xero business plans.
One organization and a standard pack: Xero's reports. Several companies to combine: try Syft before anyone builds a consolidation spreadsheet.
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.
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.
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.
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.
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.
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.
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.