How to Connect QuickBooks to Microsoft Copilot with Windsor.ai

How to connect QuickBooks to Microsoft Copilot

In short: connect QuickBooks to Windsor.ai (read-only), add the Windsor MCP server as a tool inside Microsoft Copilot Studio, then ask Copilot about your accounting numbers in plain language. There is no coding, no CSV exports, and no spreadsheet plumbing to maintain. Once it is set up you can ask things like “how much did I invoice this month, and how much is still outstanding” and get the answer back in seconds.

Windsor.ai is the no-code data platform used by 9,000+ marketing teams to bring live data into the tools they already work in. This guide walks through the full setup in three steps, shows the QuickBooks fields that matter, and gives you prompts you can paste straight into Copilot.

Get started free. Connect QuickBooks and start asking Copilot questions in minutes at onboard.windsor.ai/app/quickbooks. There is a free forever plan and no credit card is needed. Paid plans start from 19 dollars per month.

Why connect QuickBooks to Copilot with Windsor.ai

• Ask, do not build. Skip pivot tables and static reports. Query invoices, bills, cash flow and receivables in natural language and let Copilot do the summarising.
• Read-only and safe. Windsor.ai pulls your QuickBooks data through an authorised, read-only connection. Copilot can read and summarise the numbers, but it can never change, post or delete anything in QuickBooks.
• No code, no exports. There are no manual CSV downloads and no brittle spreadsheet syncs to keep alive. The connection refreshes on its own.
• One source of truth. Blend QuickBooks with the rest of your stack (ad spend, revenue, CRM and web analytics) so finance and marketing look at the same numbers.
• Always current. Copilot answers from the latest data Windsor.ai has synced, so month-end questions do not wait on someone rebuilding a report.

Before you start

• A QuickBooks Online account you can authorise.
• A Windsor.ai account. You can create one free at onboard.windsor.ai/app/quickbooks.
• Access to Microsoft Copilot Studio, where you can create or edit an agent and add tools. Adding a Model Context Protocol (MCP) tool is what lets Copilot reach your Windsor.ai data.

Connect QuickBooks to Microsoft Copilot in 3 steps

Step 1: Connect QuickBooks in Windsor.ai (read-only)

Go to onboard.windsor.ai/app/quickbooks and sign in or create your free account. Select the QuickBooks connector and authorise it. This is a read-only connection, so Windsor.ai can read your accounting data but cannot make any changes in QuickBooks. Once the connection is live, copy your Windsor.ai API key from your account settings. You will paste it into Copilot Studio in the next step.

Step 2: Add the Windsor MCP server in Copilot Studio

In Microsoft Copilot Studio, open or create the agent you want to give QuickBooks access to, then add Windsor as an MCP tool:

1. Open your agent and go to Tools.
2. Click Add a tool, then New tool.
3. Choose Model Context Protocol.
4. Set Server name to Windsor MCP.
5. Set Server URL to https://mcp.windsor.ai.
6. Set Authentication to API Key.
7. Set the header name to Authorization.
8. Set the value to Bearer <your-windsor-api-key>, replacing the placeholder with the API key you copied from Windsor.ai.
9. Click Save.

Copilot Studio will ask you to create the connection. Open the connections manager, click Connect, then Submit. If the status does not turn ready right away, click Retry. This last step is where most people get stuck, so give the connection a moment and retry until it shows as connected.

Step 3: Add the tool to your agent and ask

With the connection ready, add the Windsor MCP tool to your agent so it can use it, then start asking questions in the chat in plain language. Copilot reads the QuickBooks data through Windsor.ai and answers directly. See the example prompts below for ideas.

Ready to try it? Connect QuickBooks in a few minutes at onboard.windsor.ai/app/quickbooks and add the Windsor MCP server to your Copilot agent. Free forever plan, no credit card, paid plans from 19 dollars per month.

The QuickBooks data that matters

Windsor.ai exposes your core QuickBooks accounting data to Copilot, all read-only. These are some of the most useful fields to ask about:

What you want to know	QuickBooks field
Invoice total	invoices.TotalAmt
Invoice balance outstanding	invoices.Balance
Invoice due date	invoices.DueDate
Bill total	bills.TotalAmt
Bill balance outstanding	bills.Balance
Total assets	balancesheet.TotalAssets
Accounts receivable	balancesheet.TotalAssets.CurrentAssets.AR
Accounts payable	balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.AP
Net income	balancesheet.TotalLiabilitiesAndEquity.Equity.NetIncome
Ending cash	cashflow.EndingCash
Cash from operating activities	cashflow.OperatingActivities
Receivables current (not yet due)	agedreceivables.Current
Receivables overdue (aged 1 to 30)	agedreceivables.1_30
Receivables 91 days and over	agedreceivables.91andover
Customer name	customers.DisplayName
Customer balance	customers.Balance
Payment amount	payments.TotalAmt
Payment date	payments.TxnDate

That covers invoices, bills, the balance sheet, cash flow, aged receivables, customers and payments. For the complete list of everything you can pull, see the full QuickBooks field reference.

What to ask Copilot: example prompts

Once the Windsor MCP tool is added to your agent, paste any of these into the chat and adjust the dates and names to fit your business.

How much did I invoice this month, and how much is still outstanding?

List my top 10 customers by outstanding balance right now.

Break down my aged receivables into current, 1 to 30, 31 to 60, 61 to 90, and 91 days and over.

What were my total bills last quarter, and how much is still unpaid?

Show my ending cash and net income for the last three months and highlight the trend.

Which invoices are more than one month overdue, and what is the total value?

How it works

Windsor.ai sits between QuickBooks and Copilot. You authorise QuickBooks once inside Windsor.ai, which reads your accounting data on a read-only basis. Copilot then talks to Windsor.ai through the Model Context Protocol (MCP), an open standard that lets an AI assistant call an external data source in a structured, secure way. When you ask a question, Copilot requests the relevant figures from Windsor.ai, then writes the answer in plain language. Nothing is exported by hand and nothing is written back to QuickBooks.

Ways to connect QuickBooks to Copilot

There are a few ways to get QuickBooks numbers in front of Copilot, and they are not equal:

• Manual CSV exports. You can export reports from QuickBooks and hand them to Copilot, but the data is stale the moment you export it and you repeat the work every time you need an update.
• Spreadsheet syncs. Piping QuickBooks into a spreadsheet first adds a fragile layer that breaks when columns or tabs change.
• Windsor.ai MCP (recommended). A single read-only connection that Copilot queries live through the Windsor MCP server. It stays current on its own, needs no code, and never changes anything in QuickBooks.

Is my QuickBooks data safe?

Yes. The connection is authorised and read-only from end to end. Windsor.ai reads your QuickBooks data through the official authorisation flow, so you are never sharing your QuickBooks password with Copilot. Because the connector is read-only, neither Windsor.ai nor Copilot can create, edit, post or delete anything in your QuickBooks account. Your Windsor.ai API key controls access on the Copilot side, so treat it like a password and paste it only into your own Copilot Studio connection.

Other ways to use QuickBooks with AI

Copilot is not the only assistant Windsor.ai supports. If your team also works in other tools, the same read-only QuickBooks connection powers them too. See how to connect QuickBooks to ChatGPT or connect QuickBooks to Claude. You can also review all of the Microsoft Copilot Agent integrations Windsor.ai offers.

Troubleshooting

• The connection will not turn ready. In the connections manager, click Connect, then Submit, then Retry. It sometimes takes a moment before the status updates.
• Copilot says it cannot access the tool. Make sure you added the Windsor MCP tool to the specific agent you are chatting with, not just to your tool library.
• Authentication fails. Check that the header name is exactly Authorization and the value is Bearer followed by a space and your Windsor.ai API key, with no extra characters.
• A number looks empty. Confirm QuickBooks is connected in Windsor.ai at onboard.windsor.ai/app/quickbooks and that the first data sync has finished.

Bonus: analyze QuickBooks alongside your full stack

QuickBooks tells you what came in and what went out. It becomes far more powerful when Copilot can read it next to the rest of your business. Because Windsor.ai connects 350+ sources, you can bring ad spend, revenue, CRM and web analytics into the same read-only setup and ask blended, cross-channel questions. For example, ask Copilot to compare marketing spend against invoiced revenue by month, or to line up new customers in your CRM with the invoices they generated. That single source of truth is how finance and marketing finally agree on ROAS and on what each channel actually returns.

Conclusion

Connecting QuickBooks to Microsoft Copilot with Windsor.ai takes three steps: authorise QuickBooks in Windsor.ai, add the Windsor MCP server in Copilot Studio, and add the tool to your agent. From there you ask about invoices, cash flow, receivables and more in plain language, all read-only and all without code. When you are ready to blend it with the rest of your stack, the same connection scales to your whole business.