You're offline, showing the last version we saved.

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.

  1. Have you written a one-line definition and source for WIP, lockup days and jobs overdue?

    WIP (work in progress) is time and costs recorded on jobs but not yet billed. Lockup days is how long work takes to turn into cash, from doing it to being paid. A definition says what counts, such as whether a draft invoice is billed, and which system the number comes from.

  2. Can Claude already read your practice data, without being able to change it, and answer a question like "how many open jobs do we have"?

    Read-only means Claude can look at your Xero Practice Manager data but cannot change it. That can be a connector service using a login with only the access the dashboard needs, or exporting reports and uploading them to a Claude project.

  3. Do you have a first view showing the three numbers, the data pull date and how each was calculated?

    A view is one dashboard page. Showing when the data was pulled and Claude's working for each number lets you check what it added up, and Claude should say when a figure is not available rather than estimate it.

  4. Have you checked each number against the matching report in Xero Practice Manager or Xero, and do they agree within a margin you wrote down?

    Reconciling means running the Xero Practice Manager WIP report, the jobs list and Xero's aged receivables for one month-end date and comparing them with Claude's figures. Differences usually come from definitions, such as write-offs or draft invoices, not arithmetic.

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.

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.

You are building a practice dashboard with Claude, an AI assistant, using your Xero Practice Manager (XPM) data. A partner asks for ten tiles on it from day one. What do you start with?
You are writing down what WIP (work in progress: time and costs recorded on jobs but not yet billed) means for your firm's dashboard. Your definition does not say whether a job with a draft invoice counts as billed. What do you do?
Lockup days measures how long work takes to turn into cash: the days it sits as unbilled work plus the days clients take to pay. Where is the "days clients take to pay" half best taken from?

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.

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.

Beau Gaudron, Partner, Growthwise, speaking at The Firm’s AI in Practice Summit, June 2026

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.

You are looking at a connector service, a tool that lets Claude read your Xero Practice Manager data. What do you check in its documentation before connecting it?
You are connecting Claude to Xero Practice Manager so it can build a practice dashboard. Which login do you connect it with?
You want Claude to work with your Xero Practice Manager figures, but you do not want any new outside service connected to your practice data. Which route fits?

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.

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.

You have defined three numbers for a practice dashboard (WIP, lockup days and jobs overdue), and Claude can now read your data. What do you ask Claude for first?
Claude's practice dashboard shows a WIP figure (unbilled time and costs on jobs) with no explanation of how it got there. What do you do?
Claude is building your practice dashboard, but one of the numbers cannot be worked out from the data it can reach. What should Claude do?

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.

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.

You are checking a dashboard Claude built against your Xero Practice Manager (XPM) reports. Claude's WIP total does not match XPM's WIP report for the same date. Where do you look first?
You have fixed the definitions, and two of your three dashboard numbers now match your Xero Practice Manager reports. The third still will not match. What do you do?
Each month you check your practice dashboard's numbers against your practice management records. How close is close enough?

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.

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.

Your firm's Claude dashboard reads practice data through a connector that only fetches data when someone asks Claude for it. A partner assumes the dashboard updates itself overnight. What do you tell them?
Your Claude plan offers scheduled tasks, which run a prompt automatically at a set time. You already refresh the practice dashboard monthly from a calendar reminder. What do you do?
It is the monthly refresh day. You run the saved prompt and Claude rebuilds the practice dashboard with fresh numbers. What do you do next?

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.

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.

Copy this

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.

Your practice dashboard shows hours and productivity for each staff member. Before you share it, who should be able to see it?
The staff member who connected Claude to your practice data is leaving the firm next week. What do you do about the connector?
You find the practice dashboard was built on a staff member's personal Claude account rather than one the firm manages. What do you do?

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.

Already a member or subscriber? Enter the same email and the playbook opens. Privacy policy.

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

Sponsored

Vinyl: client meetings, minuted, with actions in your workflow. Start for free.

Xero Practice ManagerClaudeDashboardsWIPLockupPlaybook

Was this useful?
Thanks — noted.
Free template

Get the editable practice dashboard spec

Define WIP, lockup days and jobs overdue before anyone builds a tile, then connect read-only, reconcile against Xero Practice Manager, and refresh on a named day. Free with a firm profile: enter your email and we will send a code. No password. Read it in full first.

Have a password? Sign in

By continuing you agree to our terms and privacy policy.

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.

Open in ClaudeOpen in ChatGPT

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.

Sponsored

Vinyl: client meetings, minuted, with actions in your workflow. Start for free.
Read next
Related
Listen next