Xero's built-in reporting is good for anything that lives inside the ledger, and for a lot of businesses it's all they need: profit and loss, balance sheet, aged receivables and payables, budget variance, and the Management Report pack that bundles six of those into one monthly document. Power BI earns its place on top of Xero in three situations: when the numbers you want combine Xero with something else (a CRM, a job system, a stock system, a spreadsheet of targets), when the audience includes people who shouldn't have a Xero login, and when the question needs a model the ledger doesn't hold, like margin by customer over three years or a cash forecast built from open invoices. There's no native Microsoft connector for Xero any more, so getting the data across is a decision in itself, and I'll cover the routes below.
That's the short answer. The rest is the working-through, because "should we just use Xero's reports?" is a fair question, and the honest answer is "yes, until it isn't".
What does Xero's own reporting do well?
Xero has rebuilt its reporting over the last few years, and the new reports are better than they get credit for. Things it does well, listed honestly:
- The standard financial statements. Profit and loss, balance sheet, cash summary, with comparison periods, budget columns, and tracking category breakdowns. If your question is "how did we do last month against budget, by department", Xero answers it.
- Aged receivables and payables. Summary and detail versions, by contact, with ageing buckets you can change. Credit control can run from these.
- The Management Report pack. One document that groups six reports: Executive Summary, Cash Summary, Profit and Loss, Balance Sheet, Aged Receivables and Aged Payables, with average and variance columns on the summary pages. For a small business that just needs a monthly pack for the owner or the bank, this is the pack.
- Tracking categories. Two of them, which is enough for department and location, or region and product line. Every report can slice by them.
- Budget Manager. Budgets by month, by tracking category, and a budget variance report to go with them.
- Xero Analytics. On the Ultimate plan you get the Syft-powered analytics: short-term cash flow projection, business snapshot, KPIs and ratios. Xero bought Syft in 2024 and this is where that capability landed.
- The audit trail. The report and the transaction are in the same place. Drilling from a P&L line to the invoice is a click.
For a single-entity business whose questions are ledger questions, that's a complete answer, and I'd rather say so than sell you something you don't need.
Where does Xero reporting stop?
The stopping points are the same three every time.
The numbers you want aren't all in Xero. Revenue by customer is in Xero. Pipeline by customer is in HubSpot. Hours by job are in a job system or a timesheet app. The question the owner actually asks is "which customers are worth having, and what's coming next quarter?", and that needs all three joined on one customer list. Xero can't see the other two.
The audience isn't Xero users. A sales manager who wants to see sales by rep, a department head who wants their own cost centre and nothing else, a board that wants one page. Giving each of them a Xero login is a licensing cost and a permissions headache (Xero user roles are coarse), and in practice they won't log in anyway. A report on a phone that shows a department head their lines and only theirs gets opened.
The question needs a model, not a report. Rolling twelve-month margin by customer, cohort views of who you won last year and what they're worth now, a 13-week cash forecast built from open sales and purchase invoices plus expected close dates, revenue recognised against what was invoiced. The ledger is the source, but the answer needs a calendar table, relationships and measures. That's what Power BI's semantic model is for, and it's the thing Xero's report builder isn't.
Multi-entity. If you run more than one Xero organisation, Xero itself won't consolidate them. That's a known gap; Joiin, Fathom, Spotlight and Syft all exist because of it. Power BI can also do the management consolidation, and I've written that up separately at Group Reporting for Multi-Entity Businesses.
What does each Xero plan include for reporting, and what does it cost?
Xero's UK prices rose on 1 September 2026. These are the published figures from xero.com/uk as of that date, per month, excluding VAT:
| Plan | Price per month | Reporting you get | Notes |
|---|---|---|---|
| Ignite | £18 | Standard reports, capped at 20 invoices and 10 bills | For very small businesses |
| Grow | £39 | Standard reports, Management Report pack, Budget Manager, Projects for 1 user | The common starting point |
| Comprehensive | £55 | As Grow, plus multi-currency | Multi-currency is the reason to pick it |
| Ultimate | £70 | As Comprehensive, plus Xero Analytics (KPIs, ratios, cash projection), Projects for 10 users | The only plan with the Syft-powered analytics |
Source: xero.com/uk/pricing-plans, read 21 September 2026. Additional users on Grow and above are £2.50 per month each; check the page for the current introductory discount.
The reporting point in that table: if what you want is KPIs and ratios inside Xero, the answer is the Ultimate plan at £70 a month, and for one entity with ledger questions that's likely cheaper than anything I'd build. If what you want is Xero joined to something else, or shown to people who aren't in Xero, no plan gets you there, and that's where Power BI starts.
How do you connect Xero to Power BI?
This is the part that surprises people. Microsoft used to ship a Xero content pack for Power BI. It was deprecated in 2019, and there is no native Xero connector in Power BI's Get Data list today. So "connect Xero to Power BI" means picking one of three routes:
A third-party connector. CData, Dataddo, Connectorly, Windsor.ai, Coupler.io and Acterys all sell Xero-to-Power BI connectors, some as Power BI custom connectors, some as cloud services that copy Xero into a database or file that Power BI then reads. They handle the OAuth, the paging and the rate limits, and they're priced as monthly subscriptions. This is the route for a business that wants it working this week and doesn't have a developer.
Power Query against the Xero API directly. Xero's API is well documented and Power Query can call it, but you have to handle the OAuth2 token refresh yourself, which the Power BI Service doesn't do natively for custom endpoints. It's doable, I've done it, and it's the cheapest route in licence terms, but it's the one most likely to break on a Tuesday when the token expires and nobody's watching. If you go this way, put someone's name against it.
A staged database. A small job (Power Automate, a script, or a connector service) copies Xero's tables into a SQL database or a set of files on a schedule, and Power BI reads that. More moving parts, but the model reads from a stable source, the refresh is a normal database refresh, and you can keep history Xero doesn't (Xero's API gives you the current state of things; if you want "what did aged debtors look like every Monday", you have to store it yourself).
For a First Report on Xero I usually use the second or third route, because the client owns it afterwards with no subscription attached. For a business that wants to be self-sufficient without a developer, the first route is the honest recommendation.
What should you model once Xero is connected?
A few things I've learned building Power BI on Xero data:
- Pull the journals and invoices, not the reports. Model from the transaction lines with their account codes, contacts and tracking categories. Rebuilding Xero's P&L from Xero's P&L report is brittle; building it from the journal lines means any report is possible.
- Model on contact IDs, not names. Contact names get edited. IDs don't.
- Bring the budget in as its own table. Budget Manager exports cleanly, and budget versus actual in Power BI needs the budget at the same grain as the actuals (month, account, tracking category).
- Reconcile to Xero every refresh. The P&L total in the model and the P&L total in Xero, side by side, on a page. Zero is the only acceptable variance. This is the check that makes the numbers trustworthy, and it's the one most people skip.
- Store the snapshots you'll want later. Aged debtors as at each month end is the classic. Xero shows you today; a table of month-end snapshots shows you the trend.
What does it cost to put Power BI on Xero?
Licences first. Power BI Pro is £10.80 per user per month on Microsoft's UK page as of September 2026, paid yearly, excluding VAT. Everyone who views a report in a Pro workspace needs one. Add a connector subscription if you take the first route above.
Then the build. My published price for exactly this shape is the First Report: one system (Xero is one of the named ones), one report answering one written question, the headline number reconciled back to Xero to the penny, published to your own workspace, £1,950 fixed, ten working days. Details at the First Report. If the job is Xero plus your CRM, that's two sources and it's a Reporting Sprint instead. And if you're not sure which you need, the Setup Hour is an hour with your data for £195.
Broader UK market rates are in How Much Does a Power BI Consultant Cost in the UK? (2026) if you want to compare.
Common questions
Does Power BI have a native Xero connector?
No, not any more. Microsoft's Xero content pack was deprecated in 2019 and there's no Xero entry in Power BI's Get Data list as of September 2026. You connect through a third-party connector, through Power Query calling the Xero API, or through a database that something else keeps in sync with Xero.
Can I get management accounts out of Xero without Power BI?
Yes. Xero's Management Report pack bundles the Executive Summary, Cash Summary, P&L, Balance Sheet, Aged Receivables and Aged Payables into one document, and it's on the Grow plan and above. For a single-entity business with ledger questions it's usually enough. The longer answer is at Can Xero Produce Management Accounts? Yes, and Here's Where It Stops.
Do I need the Ultimate plan to get KPIs?
Inside Xero, yes: Xero Analytics (the Syft-powered KPIs, ratios and cash projection) is only on Ultimate, at £70 a month as of September 2026. If you're building KPIs in Power BI instead, the plan doesn't matter; Power BI reads the underlying data on any plan.
Can Xero consolidate multiple companies?
No. Xero doesn't do multi-entity consolidation natively and it's not on their public roadmap. Joiin, Fathom, Spotlight and Syft are the usual add-ons. Power BI can do a management consolidation across several Xero organisations too, which is covered at Group Reporting for Multi-Entity Businesses.
How often can the Power BI report refresh from Xero?
Up to eight scheduled refreshes a day in a Pro workspace, which is plenty for finance data that changes daily. Some connector services add their own schedule on top, so the effective latency is the slower of the two.
Will the numbers match Xero exactly?
They should, and if they don't the model is wrong, not Xero. Every model I build has a reconciliation page: the headline figure in Power BI next to the same figure in Xero. That check is written into the First Report's payment terms, so it isn't optional.
Is it worth it for a small business?
Only if one of the three stopping points applies to you: data outside Xero, an audience outside Xero, or a question that needs a model. If none of them does, stay on Xero's reports and put the money elsewhere. I'd rather tell you that in a 20-minute call than build something you don't open.