Data to AI™ / Copilot/Xero

Xero to Microsoft Copilot integration

Put a Xero agent in Teams so department heads can check spend, cash and receivables themselves instead of waiting for the monthly finance pack.

Better answers, fewer tokens.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Xero data you already sync
  • SOC 2 Type II certified
Microsoft 365 Copilot
Connected to Dataddo

How much cash came in and went out of each bank account in September?

Copilot Answer · Xero

September closed with a net inflow of $9,350: $89,600 Cash Received against $80,250 Cash Spent. The Business Account carried most of both.

Bank AccountCash ReceivedCash SpentClosing Balance
Business Account Reports - Bank summary $84,200$71,650$52,900
Business Savings Reports - Bank summary $5,400$0$40,000
Company Credit Card Reports - Bank summary $0$8,600-$3,150

Taken from the Bank summary report for one Date Start to Date Stop period, not rebuilt by adding up Bank Transactions.

source
Xero · as of Mon 06:40 UTC
covers
1-30 Sep 2026
Example answer · fictional account and figures
Xero in Copilot

Questions Copilot can answer from your Xero data

Xero is cloud accounting software for small and medium-sized businesses. Dataddo extracts invoices, payments and bank transactions as well as Xero reports such as Aged Receivables, Bank summary, Profit and Loss and Budget summary.

Department spend in Teams

Ask Copilot

@Xero Ledger What did Marketing spend last month? Use Profit and Loss by Tracking Category and compare it with Reports - Budget summary.

Budget holders ask the agent in their own Teams channel instead of emailing finance, and see actuals per tracking category against the budget they own.

Monday cash update

Ask Copilot

@Xero Ledger Give me Cash Received, Cash Spent and Closing Balance per Bank Account from Reports - Bank summary for last week.

The treasurer asks Microsoft 365 Copilot on Monday morning and pastes the answer into the weekly cash update for leadership.

Chart of accounts in VS Code

Ask Copilot

Use the dataddo tools to query Accounts and return Code, Name, Type and Reporting Code as JSON for our chart-of-accounts seed.

A finance systems developer uses GitHub Copilot in Agent mode to keep internal reporting mappings in line with the accounts finance adds in Xero.

Xero datasets and the questions they answer in Copilot →
Pricing

Priced per seat.

Data to AI™ is priced per seat, like the AI assistants your team already uses, with ~25% off on annual billing. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

$10.49/month

per seat

3 seats minimum

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
Setup

Connect Xero to Copilot step by step

  1. 1
    Connect Copilot to Dataddo Add Dataddo as an MCP tool to a Copilot Studio agent and sign in, or add it to mcp.json for GitHub Copilot in VS Code.
  2. 2
    Connect Xero to Dataddo Sign in with your Xero account in Dataddo and choose the datasets to sync, such as Invoices and Reports - Aged Receivables Summary.
  3. 3
    Choose what Copilot can see Select the Xero data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Xero in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Budget holders asking about spend Department heads email finance for their numbers, then wait for the monthly pack to see actuals against budget. The Xero agent in their Teams channel reads Profit and Loss by Tracking Category and answers per Tracking Category Name. Self-serve spend checks
Routing questions to Xero Copilot has no link to Xero, so finance questions get answers from documents rather than the ledger. The server description in Copilot Studio tells the agent to call Dataddo for Xero invoices, cash, budgets and tracking categories. Xero questions reach Xero
Chart of accounts in code Mapping files in the reporting repository drift as accountants add or archive account codes in Xero. GitHub Copilot in Agent mode reads Accounts through the server in .vscode/mcp.json, so mapping updates start from current codes. Mappings match the ledger
Token consumption Copilot spends tokens exploring raw Xero columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Fewer tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers built on agreed definitions. In the Dataddo benchmark, Opus 5.5 reached 95.2% good outcomes, against 81% over raw SQL. Better answers
Datasets

Xero datasets and the questions they answer in Copilot

The Xero datasets finance and RevOps teams use most, with their real field names. Copilot queries them by name through the Dataddo semantic layer.

Dataset Metrics and attributes Ask Copilot
Invoices
  • Amount Due
  • Amount Paid
  • Status
  • Contact Name
  • Due Date
  • + others
How does Amount Paid compare with Amount Due across our invoices, by Status?
Reports - Aged Receivables Summary Which Contact has paid the least relative to what is still Due?
Reports - Bank summary
  • Bank Account
  • Cash Received
  • Cash Spent
  • Closing Balance
  • + others
Did Cash Spent exceed Cash Received in any of our bank accounts this period?
Profit and Loss Was net profit Value negative in any period between Date Start and Date Stop this year?
Reports - Budget summary Which accounts have no budget set at all for the current Year?
Payments How did the total payment Amount by Date trend over the last six months?
Profit and Loss by Tracking Category
  • Row Value
  • Tracking Category Name
  • Account Name
  • Row Label
  • + others
Which tracking categories show a negative Row Value for net profit?
Bank Transactions
  • Bank Account Name
  • Total
  • Contact Name
  • Is Reconciled
  • + others
How does the Total of bank transactions compare across each Bank Account Name?
See all Xero datasets, metrics and attributes on the connector page →
Benchmark

Fewer confident mistakes. No leaked personal data.

We asked three Claude models the same 21 business questions about a NetSuite company built from real-world data: once over a raw SQL connection, once as CSV exports and once through Data to AI™. Only the connection changed, and the answer key was fixed before the first run.

95.2%

good outcomes with Opus 5.5 on Data to AI™, against 81% on a raw SQL connection

58%

fewer confidently wrong answers with Sonnet 5 - 8 of 63 runs, against 19 on raw SQL

24x

cheaper per question: Haiku 5.5 on Data to AI™ (87.3%) beat Opus 5.5 on raw SQL (81%)

0 of 9

attempts disclosed a sales rep's email address, against 9 of 9 on raw SQL

Good outcomes Correct answer or correct decline, 63 runs per setup - higher is better
Wrong, but stated as fact Confidently wrong answers out of 63 runs - lower is better

21 questions, 3 runs each. 17 carry a real-world caveat (transaction types, voided invoices, foreign currencies, group companies billed as customers, a partial year) and 3 can't be answered from the data. Ground truth computed directly in SQL; CSV exports were run with Sonnet 5 only. Run date: 26 October 2026.

Read the benchmark →
FAQ

Xero and Copilot: FAQ

How do I connect Xero to Copilot?

Create a Xero source in Dataddo with Reports - Bank summary, Profit and Loss by Tracking Category and Invoices, and attach it to a Copilot destination or AI Model. In Copilot Studio, add https://headless.dataddo.com/mcp-data as a Model Context Protocol tool with OAuth 2.0 Dynamic discovery and publish to Teams and Microsoft 365 Copilot.

How do I add Xero data to a Copilot Studio agent?

In the agent, go to Tools > Add a tool > New tool > Model Context Protocol, enter the Dataddo URL, choose OAuth 2.0 with Dynamic discovery and sign in with the Dataddo account that holds the Xero flow.

Which Xero questions will the agent route to Dataddo?

Those that match the server description you set in Copilot Studio. Mention Xero invoices, cash, budgets and tracking categories there so the agent calls Dataddo for them.

Can department heads see spend by cost centre?

Yes, if you use Xero tracking categories. Profit and Loss by Tracking Category and Journals with Tracking carry Tracking Category Name, so the agent can answer per department.

Does the agent work in Microsoft 365 Copilot as well as Teams?

Yes. Publish through Channels > Teams and Microsoft Copilot. In both, users type @ and select the agent, and it reads the same Xero data.

Can GitHub Copilot query Xero in VS Code?

Yes. Add the server to .vscode/mcp.json with type http and the URL, start it and sign in. Business and Enterprise organizations must enable the MCP servers in Copilot policy first.

New from Dataddo · Data to AI™

Ask Claude or ChatGPT about your ads, analytics and CRM

“What did a new lead cost us last week, by paid channel?”

Connect 400+ sources once and get the answer right in your AI chat, without building a report. Better answers: your metrics are defined once, so the AI doesn't have to guess.