Data to AI™ / Copilot/QuickBooks

QuickBooks data in Microsoft Copilot and Teams

Finance managers and budget holders read the balance sheet, deposits and department results from QuickBooks through a Copilot agent in Teams, without waiting for a report pack.

Better answers, fewer tokens.

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

Which customers owe us the most, and how old is their oldest unpaid invoice?

Copilot Answer · QuickBooks

Northwind Supply has the largest open balance, $19,400, almost as much as the next two customers combined ($22,460). Its oldest open invoice was due on 14 Jul.

Customer nameOpen balanceOldest Due date
Northwind Supply AR Aging Detail Report $19,40014 Jul 2026
Bluebird Studio AR Aging Detail Report $12,1803 Aug 2026
Harbor Dental AR Aging Detail Report $10,28021 Aug 2026

Open balance comes from the AR Aging Detail Report, which pulls all current data on each run, not from summing invoice history.

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

Questions Copilot can answer from your QuickBooks data

QuickBooks is accounting software for small and medium businesses. Dataddo extracts its transactions and standard reports, from invoices and bills to AR and AP aging, cash flow and profit and loss.

Monday cash check for the CFO

Ask Copilot

@Books Assistant Sum Deposits Total Amount by Deposit To Account Name for last week, and show Balance Sheets V2 Total per Section.

The CFO asks the agent in Microsoft 365 Copilot for last week's deposits and balance sheet totals, then pastes the answer into the leadership update.

Department spend in Teams

Ask Copilot

@Books Assistant For Dept Name Marketing, list Profit and Loss Detail rows this quarter by Category with Amount, largest first.

Budget holders mention the agent in their Teams channel to see what their department spent, so spending questions are settled in the thread rather than by an analyst.

Actuals mapping in VS Code

Ask Copilot

Use the dataddo tools to describe Transaction Lines Report V2 and map Account name, Amount and Transaction date into our forecast actuals table.

A finance analyst who keeps the forecast model in a repository asks GitHub Copilot in Agent mode to write the mapping, so forecast and books use the same accounts.

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

QuickBooks in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Department figures for budget holders Budget holders wait for finance to cut a Profit and Loss Detail export per department and send it round each month. The agent in Teams answers per Dept Name from Profit and Loss Detail whenever a budget holder asks in the channel. No monthly report pack wait
Who sees which QuickBooks data A full export shared in a Teams chat exposes every account, customer and vendor to everyone in it. Attach only the datasets the agent's audience should see, and untick customer columns when you create the source. Finance controls the scope
Triggering a lookup Microsoft 365 Copilot has no link to your books, so a cash question gets a generic reply or a request for a file. A server description naming balance sheet, deposits and profit and loss tells the agent when to call Dataddo. Answers from your books
Forecast code and the ledger Analysts copy account names from a ledger export into forecast code and fix mismatches by hand later. GitHub Copilot in VS Code describes Transaction Lines Report V2 and samples real Section values through .vscode/mcp.json. One set of account names
Token consumption Copilot spends tokens exploring raw QuickBooks 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

QuickBooks datasets and the questions they answer in Copilot

The QuickBooks 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
  • Total Amount
  • Item Name
  • Document Number
  • Customer Name
  • Transaction Date
  • + others
Which Item Name appears most often on invoices above our average Total Amount?
Payments
  • Customer Name
  • Transaction Date
  • Total Amount
  • Unapplied Amount
  • + others
Which Customer Name paid us the most in total this quarter?
AR Aging Detail Report
  • Customer name
  • Due date
  • Amount
  • Open balance
  • Transaction type
  • + others
Which Customer name holds the largest share of all outstanding receivables in QuickBooks?
AP Aging Detail Report
  • Due date
  • Open balance
  • Vendor
  • Past due
  • Amount
  • + others
How much of our Open balance falls due in each of the next four weeks by Due date?
Bills
  • Vendor Name
  • Balance
  • Total Amount
  • Due Date
  • Department Name
  • + others
Which Vendor Name bills still have a Balance equal to the Total Amount, meaning nothing is paid yet?
Profit and Loss V2
  • Account
  • Total
  • Section
  • Start Period
  • End Period
  • + others
Which five expense accounts have the largest Total in the current QuickBooks period?
Cash Flow V2 Which cash flow accounts show a negative total this period?
Budgets
  • Budget Detail - Amount
  • Budget Detail - Account Reference - Name
  • Budget Detail - Budget Date
  • + others
Which months have a Budget Detail - Amount of zero for accounts budgeted in other months?
See all QuickBooks 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

QuickBooks and Copilot: FAQ

How do I connect QuickBooks to Copilot?

Sync QuickBooks datasets such as Balance Sheets V2, Deposits and Profit and Loss Detail with Dataddo and attach them to a Copilot destination or AI Model. Then add the Dataddo Data Access MCP tool (https://headless.dataddo.com/mcp-data) to a Copilot Studio agent, authenticate with OAuth 2.0 Dynamic discovery and publish it to Teams.

Does the Copilot agent connect to QuickBooks directly?

No. The agent reads QuickBooks data that Dataddo has already extracted, through the Data Access MCP server. Attach only the datasets the agent's audience should see, for example deposits and department results.

How do I stop the agent calling QuickBooks for every question?

Write a specific server description in Copilot Studio, for example accounting data from QuickBooks: balance sheet, deposits, profit and loss. The agent uses it to decide when to call Dataddo.

How do Teams users get the QuickBooks agent?

Publish the Copilot Studio agent, then add it through Channels > Teams and Microsoft Copilot. Users type @ and select the agent in Teams or Microsoft 365 Copilot to ask their question.

Can GitHub Copilot use the same QuickBooks data?

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

Why are some QuickBooks transactions missing for the agent?

The QuickBooks API returns up to 1,000 rows per batch, and date-range datasets only cover their window. Load larger or older histories in batches with a full data re-sync, then ask again.

Can the agent create invoices in QuickBooks?

No. The agent queries extracted QuickBooks entities through the Dataddo semantic layer. It cannot create, edit or send invoices, and Dataddo never accepts SQL from the model.

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.