Data to AI™ / Copilot/Exact Online

Exact Online to Microsoft Copilot integration

Sales managers and finance staff check invoice status, unpaid receivables and cash due in Teams through one Copilot agent that reads your Exact Online figures.

Better answers, fewer tokens.

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

Which customers have the most money stuck in the oldest receivables age group?

Copilot Answer · Exact Online

Van Dijk Bouw has the most in the oldest group, €14,200 of its €31,500 open total. Across these three accounts, €24,950 sits in Age Group 4.

Account NameTotal AmountAge Group 1 AmountAge Group 4 Amount
Van Dijk Bouw Financial - Aging Receivables List €31,500€9,800€14,200
Kessler Logistik Financial - Aging Receivables List €18,750€6,300€6,450
Maas Retail Financial - Aging Receivables List €12,900€8,600€4,300

Read from the current aging list, which reloads all open items on every run. Bucket meaning comes from the Age Group Description fields.

source
Exact Online · as of Mon 06:40 UTC
covers
Open items as of 28 Sep 2026
Example answer · fictional account and figures
Exact Online in Copilot

Questions Copilot can answer from your Exact Online data

Exact Online is cloud business software for accounting and financial management. Dataddo extracts its receivables aging, payables, sales invoices, budgets and profit and loss data.

Invoice status before a renewal call

Ask Copilot

@Exact Finance Desk Are any Sales - Invoices for Invoice To Name Kessler Logistik past their Due Date? Show Invoice Number and Amount DC.

Account managers mention the finance agent in their Teams channel to see whether a customer has paid, instead of messaging the bookkeeper and waiting for a reply.

Thirty-day cash position

Ask Copilot

@Exact Finance Desk Total Receivables Amount DC with a Due Date in the next 30 days against Payments due in the same window, and give the net.

The finance manager asks in Microsoft 365 Copilot for incoming against outgoing cash for the coming month and copies the summary into the weekly cash update.

FX mapping in VS Code

Ask Copilot

Use the dataddo tools to describe Exchange Rates, then list Source currency, Target currency, Rate and Start date for our conversion module.

A developer on the reporting pipeline asks GitHub Copilot in Agent mode for the real rate fields, so currency conversion code uses Exact Online names instead of guesses.

Exact Online 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 Exact Online 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 Exact Online to Dataddo Sign in with your Exact Online account in Dataddo and choose the datasets to sync, such as Financial - Aging Receivables List and Financial - Payables list.
  3. 3
    Choose what Copilot can see Select the Exact Online data Copilot may query. Access is read-only, and data you don't select stays out of reach.
Copilot setup guide →
With vs. without

Exact Online in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Invoice questions from sales Account managers message the bookkeeper to ask whether a customer paid, and the bookkeeper looks it up in Exact Online by hand. A Copilot Studio agent published to Teams answers from Sales - Invoices, so the account manager mentions it in the channel and gets the status. Fewer status requests to finance
When the agent calls Dataddo A generic Copilot chat answers finance questions from general knowledge, with nothing tying it to your administration. The server description tells the agent that invoices, receivables and payables live in Dataddo, so those questions trigger a lookup. Lookups on the right questions
Several divisions Each division is exported separately and pasted into the chat, so group totals depend on who collected which file. Multi-account extraction collects a dataset from every entity you can access, and the agent splits figures by the Division field. All divisions in one agent
Developers and finance data Developers ask finance for sample exports to learn field names for Exchange Rates and transaction lines. GitHub Copilot in VS Code describes the entities through .vscode/mcp.json, so code follows the real Exact Online fields. No sample exports needed
Token consumption Copilot spends tokens exploring raw Exact Online 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

Exact Online datasets and the questions they answer in Copilot

The Exact Online 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
Financial - Aging Receivables List
  • Account Name
  • Total Amount
  • Age Group 1 Amount
  • Age Group 4 Amount
  • Currency Code
  • + others
For each Account Name, how much of the Total Amount is still in the youngest age group?
Financial - Payables list
  • Amount
  • Account Name
  • Due Date
  • Approval Status
  • Invoice Number
  • + others
How much payable Amount falls due each week over the next month?
Sales - Invoices
  • Amount DC
  • Due Date
  • Invoice Number
  • Invoice To Name
  • Salesperson Full Name
  • + others
How did the total Amount DC of sales invoices change month over month by Due Date?
Financial - Outstanding Invoices Overview
  • Overdue Payable Invoice Amount
  • Overdue Receivable Invoice Amount
  • Outstanding Receivable Invoice Count
  • + others
Is our Overdue Payable Invoice Amount at a level where we should prioritize supplier payments this week?
Financial - Profit and Loss
  • Revenue Current Period
  • Costs Current Period
  • Result Current Year
  • Result Previous Year
  • + others
Are Costs Current Period growing faster than Revenue Current Period month by month?
Budgets
  • Reporting Period
  • GLAccount Description
  • AmountDC
  • Budget Scenario
  • Reporting Year
  • + others
How is the cost budget spread across each Reporting Period of the year?
See all Exact Online 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

Exact Online and Copilot: FAQ

How do I connect Exact Online to Copilot?

Extract Exact Online datasets such as Sales - Invoices, Receivables and Payments with Dataddo and attach them to a Copilot destination or AI Model. In Copilot Studio, add a Model Context Protocol tool pointing to https://headless.dataddo.com/mcp-data, sign in with OAuth 2.0 Dynamic discovery, then publish the agent to Teams and Microsoft 365 Copilot.

How do Teams users reach Exact Online data?

Through a Copilot Studio agent with Dataddo Data Access as its MCP tool. Publish it via Channels > Teams and Microsoft Copilot, and users mention it with @ in chats and channels to ask about invoices or receivables.

What should the server description say for an Exact Online agent?

The agent uses the description to decide when to call Dataddo. Mention invoices, receivables, payables and profit and loss from Exact Online, so finance questions trigger a lookup while unrelated chat does not.

Can GitHub Copilot read Exact Online data in VS Code?

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

We run several Exact Online divisions. Can one agent cover them all?

Yes, if the flows hold them. Multi-account extraction collects a dataset from every entity you can access, and the agent can split figures by Division where the dataset has that field.

Which Exact Online datasets suit a Teams agent?

Start with what people ask about most: Sales - Invoices for status questions, Receivables and Payments for cash due, and Financial - Profit and Loss for results. Attach only the datasets the agent's audience should see.

Can the Copilot agent approve supplier invoices in Exact Online?

No. The agent only reads extracted data through Dataddo. Approval Status in the Payables list can be queried, but approving or changing an invoice still happens in Exact Online itself.

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.