How to set up a QuickBooks MCP server for AI-powered accounting

MCP (Model Context Protocol) is the bridge between AI assistants and external tools. A QuickBooks MCP server gives your AI access to invoices, customers, payments, reports, and all 42 QuickBooks Online API operations — through a standardized protocol that any MCP-compatible client can use.

The direct answer: a QuickBooks MCP server wraps the QuickBooks Online API in MCP's tool-calling format, handling OAuth2 authentication, request formatting, and response parsing. Your AI assistant calls "create_invoice" instead of constructing raw HTTP requests. Setup takes 15-30 minutes for the basic server, longer if you need custom operations or production hardening.

Anthropic's 2025 MCP ecosystem report noted that financial tool integrations were the fastest-growing MCP server category, with a 340% increase in GitHub repositories between Q1 and Q4 2025 (Anthropic). Unlike generic AI automation posts, this guide shows real CodeWords workflows — not just theory. For other MCP servers, see popular MCP servers and Google Drive MCP server.

TL;DR

• A QuickBooks MCP server exposes QuickBooks Online's 42 API operations as MCP tools that any AI assistant can call.
• Setup requires a QuickBooks Developer account, an OAuth2 app, and an MCP server (Node.js or Python) running locally or in the cloud.
• CodeWords can connect to QuickBooks MCP servers or access QuickBooks directly through Composio integrations, giving you accounting automation without manual server management.

What is MCP and why does QuickBooks need it?

MCP (Model Context Protocol) standardizes how AI applications connect to external data and tools. Instead of every AI tool building custom QuickBooks integrations, MCP provides a single protocol that any compliant client (Claude, Cursor, custom agents) can use.

For QuickBooks specifically, MCP solves three problems:

1. Authentication complexity — QuickBooks OAuth2 requires token refresh, company ID management, and scope handling. The MCP server manages this once.
2. API translation — QuickBooks API endpoints use specific query languages and nested JSON structures. The MCP server translates natural tool calls into correct API requests.
3. Discoverability — AI assistants can list available QuickBooks operations and understand their parameters without hardcoded knowledge.

What are the 42 QuickBooks MCP operations?

The full QuickBooks Online API surface exposed through MCP falls into seven categories:

Customer management (6 operations) - Create customer - Read customer by ID - Update customer - Query customers (with filter) - Delete/deactivate customer - List all customers

Invoice operations (7 operations) - Create invoice - Read invoice - Update invoice - Delete invoice - Send invoice via email - Query invoices (by date, status, customer) - Void invoice

Payment operations (5 operations) - Record payment - Read payment - Query payments - Delete payment - Void payment

Expense and bill management (6 operations) - Create expense/purchase - Create bill - Read bill - Pay bill - Query expenses - Categorize transaction

Item/product management (5 operations) - Create item - Read item - Update item - Query items - Deactivate item

Reporting (7 operations) - Profit and loss report - Balance sheet - Accounts receivable aging - Accounts payable aging - Cash flow statement - Trial balance - Custom report query

Account and settings (6 operations) - List chart of accounts - Create account - Read company info - Update company preferences - Query tax codes - Get exchange rates

How do you set up the QuickBooks MCP server?

Prerequisites

• QuickBooks Online account (sandbox or production)
• QuickBooks Developer account at developer.intuit.com
• OAuth2 application created with appropriate scopes
• Node.js 18+ or Python 3.10+

Step 1: Create an OAuth2 app

In the Intuit Developer portal: - Create a new app - Select "QuickBooks Online and Payments" APIs - Set redirect URI to http://localhost:3000/callback (for local development) - Note your Client ID and Client Secret

Step 2: Configure scopes

Request these scopes based on your needs: - com.intuit.quickbooks.accounting — Full accounting access (invoices, customers, reports) - com.intuit.quickbooks.payment — Payment processing - openid profile email — User identity

Step 3: Install and configure the MCP server

The community-maintained QuickBooks MCP server on GitHub provides the reference implementation. Clone it, install dependencies, and configure environment variables:

git clone https://github.com/quickbooks-mcp/quickbooks-mcp-server
cd quickbooks-mcp-server
npm install
cp .env.example .env

Set your environment variables: - QUICKBOOKS_CLIENT_ID — From your Intuit Developer app - QUICKBOOKS_CLIENT_SECRET — From your Intuit Developer app - QUICKBOOKS_REDIRECT_URI — Your callback URL - QUICKBOOKS_ENVIRONMENT — sandbox or production - QUICKBOOKS_COMPANY_ID — Your company/realm ID

Step 4: Complete OAuth2 flow

Run the server's auth setup command to open the browser, authenticate with QuickBooks, and store the refresh token:

npm run auth

This opens a browser window for QuickBooks login. After authorization, tokens are stored locally (usually in a .tokens.json file).

Step 5: Start the MCP server

npm start

The server is now available for MCP clients to connect to.

Step 6: Connect your MCP client

For Claude Desktop, add to your claude_desktop_config.json:

{
  "mcpServers": {
    "quickbooks": {
      "command": "node",
      "args": ["/path/to/quickbooks-mcp-server/index.js"]
    }
  }
}

How does CodeWords handle QuickBooks differently?

CodeWords provides two paths to QuickBooks automation:

Path 1: Direct Composio integration

CodeWords integrations include QuickBooks via Composio. No MCP server setup required. Authentication is managed. Tell Cody what you need:

"Build a workflow that creates an invoice in QuickBooks when a deal closes in HubSpot, sends the invoice to the customer, and posts a confirmation to Slack."

CodeWords generates the workflow with proper authentication, error handling, and retry logic.

Path 2: MCP server connection

If you already run a QuickBooks MCP server, CodeWords workflows can connect to it as a tool source. This is useful when you have custom MCP operations beyond the standard 42.

For most use cases, Path 1 is faster to production. See CodeWords pricing for execution costs.

What are common QuickBooks automation workflows?

Invoice automation - Generate invoices from time tracking data - Send payment reminders on aging receivables - Reconcile payments with bank transactions

Expense management - Categorize transactions using AI classification - Flag unusual expenses for review - Auto-match receipts to transactions

Reporting and alerts - Daily cash flow summaries to Slack - Weekly P&L comparisons to previous period - Monthly aging report emailed to stakeholders

Cross-system sync - CRM deal close → invoice creation - Shopify order → expense record - Payroll system → journal entry

Each of these patterns can be built in CodeWords through conversation with Cody. Templates include starting points for financial automation workflows.

FAQs

Is the QuickBooks MCP server secure for production?

The reference implementation stores OAuth tokens locally. For production, use encrypted token storage, rotate secrets regularly, and run the server in a secure environment. CodeWords handles token management in its managed infrastructure.

Can I use QuickBooks MCP with the sandbox environment?

Yes. Set QUICKBOOKS_ENVIRONMENT=sandbox to use Intuit's sandbox. The sandbox provides test data and does not affect real books.

What happens when the OAuth token expires?

QuickBooks access tokens expire after 1 hour. The MCP server should automatically refresh using the stored refresh token (valid for 100 days). If the refresh token expires, re-authentication is required.

Which QuickBooks editions support the API?

QuickBooks Online (Simple Start, Essentials, Plus, Advanced) all support the API. QuickBooks Desktop requires a different connector and is not covered by the standard MCP server.

From manual bookkeeping to AI-assisted accounting

A QuickBooks MCP server transforms your accounting system from a data silo into an AI-accessible tool. The setup cost is measured in minutes. The ongoing value is measured in hours reclaimed from manual data entry, reconciliation, and report generation.

Whether you run a dedicated MCP server or use CodeWords with managed QuickBooks access, the outcome is the same: your AI assistant becomes an accounting-aware operator that can read, write, and reason about financial data on your behalf.