Data to AI™ / Copilot/Sage Accounting

Sage Accounting to Microsoft Copilot integration

Give finance and sales a Teams agent that answers who owes what in Sage, which suppliers are due and how ledger accounts are trending.

Better answers, fewer tokens.

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

Which customers still owe us for invoices that fell due in September?

Copilot Answer · Sage Accounting

Three customers still owe £18,450 on September invoices. Harlow Interiors accounts for about half of it, on an invoice due 4 Sep.

Contact nameTotal amountOutstanding amountDue date
Harlow Interiors Sales Invoices No Lines £14,600£9,2004 Sep
Brightwell Studio Sales Invoices No Lines £7,900£5,35012 Sep
Penrose Catering Sales Invoices No Lines £4,100£3,90019 Sep

Read from Sales Invoices No Lines, one row per invoice, so totals are not repeated for every invoice line.

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

Questions Copilot can answer from your Sage Accounting data

Sage Accounting, formerly Sage One, is cloud accounting software for small businesses. Dataddo extracts sales and purchase invoices, transactions, journals, ledger accounts, contacts and the product and service catalogues.

Order holds decided in Teams

Ask Copilot

@Sage Finance Is this customer over its Credit limit? Show Balance, Credit limit and the open Sales Invoices No Lines behind it.

Sales posts the question in the channel before confirming a large order. The account manager and credit controller agree on the reply in the same thread.

Payables for the approval meeting

Ask Copilot

@Sage Finance Summarise Purchase Invoices due before month end by Contact name, with Outstanding amount and Due date, for the payment approval meeting.

Before the weekly meeting, the finance lead asks Microsoft 365 Copilot for supplier bills due and pastes the grouped list into the meeting notes.

Nominal codes in the forecast repo

Ask Copilot

Use the dataddo tools to describe Ledger Accounts and list every Nominal Code with Name and Ledger Account Type Displayed As as JSON.

A finance engineer uses GitHub Copilot in VS Code to keep the cash forecast mapping aligned with the current chart of accounts in Sage.

Sage Accounting 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 Sage Accounting 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 Sage Accounting to Dataddo Sign in with your Sage Accounting account in Dataddo and choose the datasets to sync, such as Sales Invoices No Lines and Sales Invoices.
  3. 3
    Choose what Copilot can see Select the Sage Accounting data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Sage Accounting in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Where the question gets asked Sales emails finance, finance opens Sage, copies the customer balance into a reply, and the order waits in between. The Sage agent answers in the Teams channel where sales and finance already discuss the order. Answers inside the thread
When the agent calls Sage A general assistant has no idea which system holds receivables and answers from whatever document it finds. The server description you write in Copilot Studio tells the agent to call Dataddo for Sage invoices, suppliers and ledger questions. Finance questions routed correctly
Ledger account meaning A Nominal Code in a spreadsheet says nothing about whether it is income, expense or a balance sheet account. Ledger Accounts carries the type, group and classification next to each code, with field descriptions from the semantic layer. Codes the agent can read
Token consumption Copilot spends tokens exploring raw Sage Accounting 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

Sage Accounting datasets and the questions they answer in Copilot

The Sage Accounting 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
Sales Invoices No Lines
  • Total amount
  • Status
  • Contact name
  • Due date
  • Outstanding amount
  • + others
How many sales invoices are in each Status, and what Total amount does each hold?
Sales Invoices
  • Invoice line - ledger account
  • Invoice line - product
  • Invoice line - service
  • Invoice line - net amount
  • + others
Which sales ledger account receives the most revenue, using Invoice line - ledger account?
Purchase Invoices
  • Total paid
  • Outstanding amount
  • Contact name
  • Due date
  • + others
Which suppliers have been paid in full, with Total paid and no Outstanding amount left?
Transactions
  • Contact name
  • Total
  • Transaction type
  • Origin outstanding amount
  • + others
How does the Total of customer receipts compare with supplier payments for each Contact name?
Journals
  • Journal lines - ledger account name
  • Journal lines - debit
  • Journal lines - credit
  • + others
Which Journal lines - ledger account name has more credits than debits?
Ledger Accounts
  • Name
  • Nominal Code
  • Ledger Account Type Displayed As
  • + others
Which ledger accounts share a similar Name and might be duplicates in Sage?
Contacts
  • Credit days
  • Contact name
  • Balance
  • Credit limit
  • + others
How many contacts have Credit days longer than our standard payment terms?
See all Sage Accounting 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

Sage Accounting and Copilot: FAQ

How do I connect Sage Accounting to Copilot?

Create a Sage Accounting source in Dataddo with Sales Invoices No Lines, Purchase Invoices and Ledger Accounts, and attach it to a Copilot destination or AI Model. In Copilot Studio, add the Model Context Protocol tool https://headless.dataddo.com/mcp-data with OAuth 2.0 Dynamic discovery, then publish the agent to Microsoft 365 Copilot and Teams.

How does the Copilot agent know when to query Sage Accounting?

The server description you write in Copilot Studio tells the agent when to call Dataddo. Describe it as the source for Sage invoices, suppliers and ledger data so finance questions trigger a lookup.

Can the same Sage agent run in Teams and Microsoft 365 Copilot?

Yes. Publish it through Channels > Teams and Microsoft Copilot. Users then type @ and pick the agent in either app, and both read the same Sage flows.

What permissions does the Sage account need?

At least admin-level permissions in Sage, and the business must belong to the country you select during authorization. A Sage developer account is not linked to a business and cannot be used.

Can I use GitHub Copilot with Sage data instead?

Yes. Add the server to .vscode/mcp.json, start it, sign in and use Copilot Chat in Agent mode. On Business and Enterprise an admin must enable the MCP servers in Copilot policy.

Can I keep bank details out of the Copilot agent?

Yes. Untick Contacts fields such as Bank account - number and Bank account - IBAN when you create the source, so they never reach the flow.

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.