How firms build a Xero Practice Manager dashboard with Claude
A six-step playbook for building a Xero Practice Manager dashboard with Claude: choose WIP, lockup days and jobs overdue, get read-only access, build one view and reconcile it to XPM. It covers the access routes that exist as at November 2026, the monthly refresh and a data-safety check, with a spec checklist and starter prompt to copy.
Part of our AI in accounting coverage. See the full AI for accountants guide →
Learning check · before you start
What do you already have in place?
A few quick questions, so you can skip the steps you have already done. Each one has a line explaining what it means. Not sure, or never heard of it? Choose “Not yet / not sure”: that is where most firms start, and the playbook walks you through it.
This playbook is for a firm owner or practice manager who runs on Xero Practice Manager (XPM) and is tired of exporting reports to a spreadsheet every month to see where the firm stands. You finish with a short dashboard spec, read-only access from Claude to your practice data, a first dashboard checked against XPM itself, and a routine to refresh it. Allow half a day for the first build and about twenty minutes a month after that.
Everything here was checked against vendor pages on 9 November 2026. Where a step depends on a product we could not fully verify, we say so.
Building XPM dashboards with Claude is one of the most-registered sessions at The Firm’s AI in Practice Summit: “XPM Claude Connector: Build Your Own Dashboards, No More Exports” with Kevin Garber of LogicGlue is on the agenda for 12 November. Notes will be at the summit notes page afterwards.
Step 1: Decide the three numbers
Your task for each of WIP, lockup days and jobs overdue, write one line saying exactly what counts and which system the number comes from.
You said you already have this covered. Skim this step, or skip to the next.
Start with three numbers a partner would act on this month.
- WIPtime and costs recorded on jobs but not yet invoiced, in dollars and by job. It lives in Xero Practice Manager.
- Lockup daysWIP days plus debtor days. WIP days are month-end WIP divided by trailing twelve months of revenue, times 365; debtor days are month-end receivables over the same revenue, times 365. Our guide to accounting firm KPIs explains why the debtor half is best taken from the firm’s own Xero ledger rather than the practice system.
- Jobs overdueopen jobs past their due date, by staff member and client. It lives in Xero Practice Manager.
Write down the exact definition of each, including what counts. Is a draft invoice billed or not? Are disbursements in WIP? The definitions are what Claude will follow, and what you will check against later.
Done when: three numbers, each with a one-line definition and the system it comes from.
Learning check
What would you do? Pick one; every answer is explained.
Step 2: Get read-only access
Your task choose how Claude will read your practice data, connect it with a login that can only see what the dashboard needs, and confirm it cannot change anything.
You said you already have this covered. Skim this step, or skip to the next.
As at November 2026 there are three routes, and the right one depends on how much setup you want.
A connector service that reads Xero Practice Manager. As at November 2026 we found no Xero-built Claude connector for Xero Practice Manager (Xero’s own connector reads accounting data), so firms that want live data use a third-party MCP service. The steps below follow one documented example, LogicGlue, because its setup and limits are published in detail; other services exist, and our list of MCP servers accountants can connect says what each reads. Whichever you use, check the same four things in its documentation: which records it reads, whether writes are off by default, which Claude plans it needs, and how you disconnect it. LogicGlue’s documentation, for example, says it reads XPM clients, jobs, tasks, job costs, invoices, quotes, staff and time entries, that write access is off until switched on under Settings, that Claude asks before any write, and that it needs a Claude Pro, Max, Team or Enterprise account. Setup is a custom connector: copy the address from the service’s settings, add it in Claude under Customize, then Connectors, and sign in.
The developer route. XPM has its own API, and a developer can build against it. That is a project, not an afternoon.
Exports. Run the report in Xero Practice Manager, export it if that report offers an export, and upload the file to a Claude project. It is manual, but no new service touches your data. It is also the honest fallback for any figure a connector cannot reach.
A lot of vendors do this: they don’t want things to be destructive, so they release with interpretation-style read access first and expand over time.
Whichever route, connect with a login that has only the access the dashboard needs, and leave write access off. A dashboard never needs to change a job.
Done when: Claude can answer “how many open jobs do we have” from live or exported data, and you have confirmed writes are off.
Learning check
What would you do? Pick one; every answer is explained.
Step 3: Build the first view
Your task ask Claude for one page showing your three numbers, the date the data was pulled and how each number was worked out.
You said you already have this covered. Skim this step, or skip to the next.
Ask for one view, not the finished product. Use the starter prompt in the box below, in a Claude project so the definitions stay with it. Claude can build an interactive page (an artifact) from the data it pulls. Claude also has a Dashboards feature in beta that runs against data warehouses and some connected apps; we could not confirm whether it works with a Xero Practice Manager connector, so the steps here use an ordinary artifact.
Expect gaps. LogicGlue’s tool list as at 9 November 2026 has no tool named for WIP balances or aged receivables, so Claude will calculate WIP from time entries, costs and invoices rather than read your XPM WIP figure. LogicGlue’s own documentation says some figures visible in XPM “are not available through Xero’s API”. Ask Claude to show its working for each number, so you can see what it summed.
Done when: one page showing your three numbers, with the date the data was pulled and how each was calculated.
Learning check
What would you do? Pick one; every answer is explained.
Step 4: Check it against Xero Practice Manager
Your task pick a month-end date, run the WIP report and jobs list in Xero Practice Manager and the aged receivables report in Xero for that date, and compare them with Claude's numbers.
You said you already have this covered. Skim this step, or skip to the next.
This is the step that decides whether anyone trusts the dashboard. Pick a month-end date. Run the XPM WIP report and the jobs list for that date, and the aged receivables report in Xero. Compare them with what Claude produced.
Differences usually come from definitions, not arithmetic: write-offs, draft invoices, disbursements, jobs with no due date, or a date-range limit (LogicGlue caps XPM date-range queries at twelve months per request). Fix the definition in the prompt, rebuild, and check again. If a number will not reconcile, take it from the XPM report by export and keep the rest live.
Done when: each number matches Xero Practice Manager or Xero within a tolerance you have written down, or you know exactly why it does not.
Learning check
What would you do? Pick one; every answer is explained.
Step 5: Refresh it on a schedule
Your task put a monthly refresh day in one named person's calendar, and save the dashboard prompt in Claude as a project instruction or a skill so it runs the same way each time.
You said you already have this covered. Skim this step, or skip to the next.
Do not assume the dashboard updates itself. LogicGlue says it has no background or scheduled access to your data; it fetches only when you ask. So the refresh is a routine: on a fixed day each month, open the project, run the saved prompt, and compare the headline numbers with last month’s. Save the prompt as a project instruction or a skill so anyone can run it the same way. If your Claude plan offers scheduled tasks, test one on a copy before relying on it.
Done when: the refresh day is in someone’s calendar with their name on it, and the prompt is saved where they can find it.
Learning check
What would you do? Pick one; every answer is explained.
Step 6: Run the data-safety check
Your task write the dashboard's data-safety checks into your AI policy, including whose account it runs on, who may see it and how to disconnect it, and have a partner sign them off.
You said you already have this covered. Skim this step, or skip to the next.
A practice dashboard pulls every client’s job data and every staff member’s time into an AI tool at once. Before it becomes a monthly habit, check four things.
- It runs on a firm-managed Claude account under business terms, as your AI policy requires.
- Staff time and productivity figures are personal information about your team. Decide who may see the dashboard before you share it.
- You have read the connector service’s data terms. LogicGlue says it does not store queries or results and does not train on your data; record where you read that and when.
- You know how to disconnect the connector in under a minute, and you do it when the person who set it up leaves.
Done when: the four checks are written into your AI policy and a partner has signed them off.
Dashboard spec checklist
- The three numbers, each with a one-line definition: [WIP], [lockup days], [jobs overdue].
- Source for each: Xero Practice Manager, the firm’s Xero ledger, or an export.
- What counts: draft invoices [billed or not], disbursements [in or out of WIP], jobs with no due date [shown or excluded].
- Breakdowns: by [partner, manager, client, job type].
- Access: read-only connector or export, firm-managed Claude account, writes off.
- Reconciliation: tolerance of [amount or %] against the XPM WIP report and Xero aged receivables.
- Refresh: [day of month], run by [name].
- Who may see it: [names or roles].
Starter prompt
“You are building an internal practice dashboard for [firm name] from our Xero Practice Manager data. Using only read tools, pull open jobs, time entries, job costs and invoices for [date range], and receivables from our Xero organisation. Calculate three numbers as at [month-end date]: WIP, defined as [definition]; lockup days, defined as WIP days plus debtor days using trailing twelve months of revenue; and jobs overdue, defined as open jobs past their due date. Show each number with the calculation and any records you excluded. If a figure is not available from the data, say so instead of estimating. Then build a single-page interactive dashboard with the three numbers at the top, a breakdown by [partner or manager] below, and the data pull date in the header. Do not create, update or delete anything.”
Learning check
What would you do? Pick one; every answer is explained.
Free to join
Join The Firm free to read the rest
Members get every playbook in full, plus free templates, downloads and tools across the site. Join more than 35,000 accounting professionals. All it takes is your email.
Where we could be wrong
The assumption most likely to be wrong is that a connector-built WIP figure will match XPM’s own. We have read the documentation, not run a reconciliation on a live practice, and LogicGlue itself says some XPM figures are not exposed through the API. Treat Step 4 as the real test.
We could not verify whether Claude’s Dashboards beta works with an XPM connector, whether every XPM report offers a CSV export, or how long any connector’s current features will stay as they are. Product details here are as published on vendor pages on 9 November 2026. Naming a product is not an endorsement, and this is general information, not security or legal advice.
Frequently asked questions
Does Xero make a Claude connector for Xero Practice Manager?
Not that we could find as at November 2026. Xero’s Claude connector reads Xero accounting data, read-only. Practice Manager data reaches Claude through third-party services or through exports you upload yourself.
Can the dashboard update itself every morning?
Not through LogicGlue, which says it fetches data only when you ask. A daily view would need a scheduled task in your AI tool or a developer build against the XPM API. For three monthly numbers, a monthly refresh is usually enough.
Is it safe to give Claude all our practice data?
It can be, on a business plan, read-only, with a policy that names who sees the output. The risk is less the model than the breadth: one connection now holds every client’s job history and every staff member’s time. Our guide to whether AI is safe for client data covers the plan terms.
Why start with only three numbers?
Because each number needs a definition, a source and a reconciliation before anyone trusts it, and that work multiplies with every tile you add. Get three right, then add the next one people ask for.
Do I still need the XPM reports?
Yes. They are the check. The dashboard is a faster way to see the numbers and slice them; Xero Practice Manager stays the record you reconcile to and the one your team works in.
Your one-page summary
Your answers, choices and decisions, on one page
Xero Practice ManagerClaudeDashboardsWIPLockupPlaybook
Get the editable practice dashboard spec Download the practice dashboard spec
The Word document (.docx), ready to fill in. Your profile unlocks every template on The Firm.
Or build it with AI
Open Claude or ChatGPT with the prompt filled in. It writes the finished document for your firm straight away, then asks a few questions to tailor it. No client data needed.
Works without client data. Don't paste client names, tax file numbers or ledgers into an AI tool your firm hasn't approved for them. AI data safety playbook.