QuickBooks MCP Server Options Compared (2026): Intuit's Official Connector, GitHub, Zapier, CData and Excel

Comparison · By the HISAB 360 team · Published 15 September 2026 · Updated 25 October 2026 · ~11 min read

Tested in Excel. On 25 October 2026 we connected an outside MCP client (Claude Code) to HISAB 360's local MCP server on the same PC. It listed the open workbook's sheets and pulled a Profit and Loss from a QuickBooks Online sandbox company through erp_get_report_lines (27 lines; net profit matched a trial balance pulled separately; we asked for the period to 25 October and QuickBooks returned it to 24 October). We did not run the other routes; they rest on each vendor's pages, re-checked the same day.

"QuickBooks MCP" now means at least six different things, and two of them come from Intuit. Which one fits depends on three plain questions: where your QuickBooks company is based, who holds its login, and whether the answer should end up in a chat window or in a workbook you can tick and file.

Last checked: 25 October 2026. Every external claim links to its source, and all sources were checked on 25 October 2026; where official pages disagree we show both, with their dates. We make one of the routes, HISAB 360, so it comes last, with its limits spelt out.

Does QuickBooks have an MCP server?

Yes. Intuit offers two for working with your books, built for different people, plus a developer helper.

• A hosted connector inside Claude and ChatGPT. Claude's directory lists Intuit QuickBooks: made by Intuit, 74 tools, "Added March 2026". You sign in with Intuit; Intuit's setup steps involve no developer app.
• An open-source server on GitHub. intuit/quickbooks-online-mcp-server is an open-source TypeScript/Node project (Apache-2.0 per its LICENSE file, although its README says MIT) that you run yourself with your own Intuit developer app.
• A developer helper. Since October 2026 Claude's directory also lists Intuit Developer, which helps you create an Intuit app and sandbox from Claude. Intuit says it is not for business workflows or live accounting data.

Both are built on QuickBooks Online (Intuit's Claude article also accepts Intuit Enterprise Suite subscriptions). We found no official MCP server or connector for QuickBooks Desktop. Microsoft 365 Copilot's federated connector list (updated 30 September 2026) includes Xero and Zoho Books, but not QuickBooks.

QuickBooks MCP routes at a glance

Last checked: 25 October 2026. "Approval before posting" is what each vendor documents, not any prompt your AI client adds on top.

Other comparisons exist: Kipper's (updated 10 September 2026) compares Intuit's GitHub server, two community servers, Zapier, CData, DeepLedger and Kipper's own $200/month read-only layer, but not Intuit's hosted connector or Excel; DeepLedger's (updated 10 October 2026), from a vendor that sells a hosted QuickBooks MCP, compares local, self-hosted and hosted setup.

Route 1: Intuit's official QuickBooks connector for Claude and ChatGPT

Intuit's 23 April 2026 announcement described QuickBooks in Claude as analysis and reporting. On 28 July 2026 Intuit added write actions to Claude and ChatGPT: creating, updating, deleting and sending invoices, recurring invoices, estimates, payment links, new customers and products, and PDF downloads. The same update added payroll lookups and QuickBooks Capital loan benchmarking, and listed payroll actions such as compensation changes as coming next.

What it can write depends on which page you read:

• Intuit's Claude help article also lists importing and categorising transactions into the General Ledger, and updating the business profile.
• The Claude directory listing (checked 25 October 2026) says it can "add an employee or set base pay", and its tool list includes employee create and update tools. It also lists duplicating and scheduling invoices and estimates, and sending payment reminders. It is still the only page we found that mentions payroll writes; Intuit's July blog describes the payroll additions as lookups.
• For ChatGPT, the July blog says the new features cover both assistants, but Intuit's ChatGPT help article (updated 26 August 2026) describes only asking questions.

The US-only limit. The Claude help article (updated 21 October 2026) says: "The QuickBooks connector for Claude is currently available to US customers only", with other regions planned. The ChatGPT article says the same for US QuickBooks Online customers. Intuit's 28 July announcement also marks its Payments-based features, such as payment links, as not available in U.S. territories or outside the U.S. Go by Intuit: if your company is in the UK, Canada, Australia or elsewhere, this route is not yet for you.

Approval and data. Intuit's help article says destructive actions, such as deleting an invoice, need your confirmation, and the Claude listing now promises a preview and your confirmation before anything is sent. Neither describes a staging sheet or a batch review. Intuit also says QuickBooks data is not used to train Claude.

Good for: US owners and bookkeepers who want answers and quick invoicing in conversation. Not for: non-US companies today, or output that must be a reviewable schedule.

Route 2: Intuit's open-source quickbooks-online-mcp-server on GitHub

The README describes a local stdio server, not a hosted endpoint. It covers far more than the hosted connector: 145 tools, full CRUD on 29 entity types and 11 reports, including Trial Balance and General Ledger.

Setup means registering your own app on the Intuit Developer Portal, completing a one-time browser OAuth handshake, and keeping the client ID, secret, refresh token, realm ID and environment in a .env file.

The catch is the redirect URI. Sandbox accepts http://localhost, but the README says production rejects localhost and needs a public HTTPS callback for the first authorisation; it suggests ngrok. You may read that the server is sandbox-only. Intuit said so itself in a 21 October 2025 "Early Preview" developer blog post, which is no longer online; its search snippet says the server ran only in the Sandbox environment. The current README (checked 25 October 2026) documents production use with a public HTTPS callback, so the README is the newer word.

Control. QUICKBOOKS_DISABLE_WRITE, QUICKBOOKS_DISABLE_UPDATE and QUICKBOOKS_DISABLE_DELETE switch off the create, update and delete tools, so you can start read-only. The Releases page showed no published releases: treat it as source code you pin yourself.

Good for: developers building an agent who want the widest coverage. Not for: anyone who wants to click Connect and start.

Route 3: Hosted automation MCPs — Zapier and Pipedream

These remove the developer app: you connect QuickBooks once inside the platform, and a third party then sits between the AI and your ledger, holding the connection.

Zapier's QuickBooks Online MCP covers searches; creates for bills, invoices, journal entries, payments, purchase orders and more; updates for bills, invoices, estimates, customers, vendors and a few others (none for journal entries or payments); sending documents; and voiding invoices. Per its usage docs, each successful tool call, test calls included, uses two plan tasks. Its MCP security page cites SOC 2 Type II and per-user tool-call logs, but does not say how connection tokens are stored, so ask.

Pipedream's MCP docs say anyone can use its hosted MCP servers for their own use free, with production use inside your own app on paid plans. Credentials are encrypted at rest and requests go through Pipedream's servers, so Pipedream holds the QuickBooks tokens. Its pricing docs list MCP tool calls among operations that use credits, and bill compute at one credit per 30 seconds. Its pricing page lists a Startup plan at $99 a month billed annually ($150 monthly) with 10,000 credits, then $0.012 per credit. Its QuickBooks tool page still would not load; the open-source actions behind it include creates for invoices, bills, customers and payments, a few updates, sending, and voiding invoices.

Good for: teams already running Zapier or Pipedream. Not for: firms whose policy bars a third party from holding client ledger credentials.

Route 4: CData Connect AI for QuickBooks Online

CData Connect AI is a cloud-hosted MCP endpoint that treats QuickBooks Online as a SQL-style source, with QuickBooks permissions carried through and query logging. Its pricing page starts at $99/month, or $79/month billed annually (1 user, 1 source), with a 14-day trial. It lists query, insert, update, delete and bulk tools as universal tools for all sources; the QuickBooks Online page itself shows only query examples, so confirm write support during the trial. CData also publishes a read-only open-source server.

Good for: a data team wanting one governed endpoint. Not for: a sole practitioner with one QuickBooks file.

Route 5: A local MCP server inside Excel (HISAB 360)

This is our route, for a narrower problem. HISAB puts QuickBooks data into worksheet cells for reconciliation and review, and sends changes back from a sheet a person has checked.

How it works. HISAB is a paid add-in for Windows desktop Excel. It runs a local MCP server at http://localhost:7317/mcp (JSON-RPC over HTTP, bearer token), available only while Excel is open and listening on localhost only. The AI gets ERP tools such as erp_list_connections, erp_query, erp_get_report_lines and erp_stage_template alongside Excel read/write, formulas and a Python sandbox, running on your own Claude or ChatGPT subscription or on HISAB AI credits (see bring your own AI).

Reads and writes. You can query QuickBooks Online entities and pull reports such as Profit and Loss, Trial Balance and Aged Receivables into a sheet. Data is pulled when asked; there is no scheduled or automatic refresh. You can create invoices, bills, journal entries, payments, credit memos, customers and vendors, and update, void, delete or email existing records.

Every write is staged on a sheet, validated, submitted and audited. Writing is off until you set the connection to Read + Write. Every write, including a new customer or vendor, shows an approval card that names the company before anything posts (see ERP connectors). QuickBooks has no draft state, so an approved row posts as a final record. Write-back is in every plan.

Regions. The connector reads each company's country and blocks no region; for non-US companies it flags sales lines with no tax code before submission.

The limits, plainly:

• You need your own Intuit developer app. You paste its client ID and secret into HISAB and register the localhost redirect URI it shows you. This is similar setup friction to Route 2, and there is no shared HISAB app.
• Windows desktop Excel only. No Mac, no Excel for the web, no Google Sheets.
• Not hosted. Anthropic's custom connector guide (updated 1 October 2026) says custom connectors connect from Anthropic's cloud, even in Claude Desktop and Cowork, and need a server reachable on the public internet. So no custom connector (in claude.ai, Claude Desktop, Cowork or mobile) and no ChatGPT connector can reach HISAB. It adds itself to Claude Code automatically (and to the Codex that runs inside HISAB); another MCP client on the same PC can be pointed at it by hand if it supports HTTP with a bearer token, which is how we tested it.
• Plans are untested. HISAB does not check your QuickBooks Online plan, and we have not verified every record type on every plan. Intuit's pricing page (checked 25 October 2026) lists class and location tracking (40 on Plus, unlimited on Advanced) and inventory only from Plus up. It now also lists a free plan, which we have not tested. Test on your own company first.
• Not included: QuickBooks Desktop, payroll, payment links, QuickBooks Capital, or bank reconciliation posted into QuickBooks.

Good for: accountants whose output is a workpaper, reconciliation or journal batch in Excel, including non-US companies, though live testing so far covers only a UK VAT sandbox. Not for: browser chat or Mac users. For non-MCP routes, see connecting QuickBooks and Xero to Excel and the Power Query connector alternatives.

Security and control questions to ask of any QuickBooks MCP

1. Where does the OAuth refresh token live, and how is it revoked? Intuit's GitHub server: a local .env file. Zapier, Pipedream and CData: their platforms. Intuit's connector: your Intuit sign-in. HISAB: Windows DPAPI on your PC, never passed to the AI.
2. Which write access is granted, and can it be narrowed? The GitHub server has disable flags. HISAB connects with Intuit's one accounting scope, com.intuit.quickbooks.accounting (plus standard sign-in scopes), so its per-connection Read + Write switch records intent inside HISAB rather than adding OAuth scopes.
3. Does a person approve before anything posts, or only before deletes? Zoho, for its own server, advises admin approval before MCP actions.
4. Is there a per-call audit log? Zapier has a History tab, CData claims full query logging, and HISAB keeps a local log of every ERP write attempt, with the data hashed and the approval card it ran under.

Beyond QuickBooks: MCP options for Xero, Zoho Books, Odoo and FreshBooks

Last checked: 25 October 2026.

Odoo: Odoo's own documentation now has the MCP server page for Odoo 20, not for 19.0.

HISAB's connectors cover all four plus QuickBooks Online, with write-back staged on a sheet for review, and the same limits (Windows desktop Excel only, and your own developer app for the OAuth-based ledgers).

Which QuickBooks MCP route should you pick?

• US business owner, happy in chat: Intuit's official connector. Nothing to install, and it writes invoices and estimates.
• QuickBooks company outside the US: the official connector isn't available to you yet, per Intuit. Consider the GitHub server (with an HTTPS callback for production), a hosted platform, or HISAB if Excel is where you work.
• Developer building an agent: Intuit's GitHub server, with the write flags off to start, or CData if a data team needs one governed endpoint.
• Already on Zapier or Pipedream: add QuickBooks there. Budget for tasks or credits, and get a clear answer on token storage first.
• Accountant producing workpapers, reconciliations or journal batches for review: HISAB. Data lands in cells and writes are staged for a person to check. Not on a Mac or for browser chat.

For wider context, see AI Excel tools for accountants and Claude for Excel.