quickbooks-online-mcp-server
OfficialProvides full CRUD operations for 29 entity types (customers, invoices, bills, payments, etc.) and 11 financial reports (balance sheet, profit & loss, cash flow, etc.) for QuickBooks Online, enabling comprehensive accounting and financial management.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@quickbooks-online-mcp-servershow me the profit and loss for last quarter"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
QuickBooks Online MCP Server
A comprehensive Model Context Protocol (MCP) server for QuickBooks Online
Quick Start | Available Tools | Authentication | Documentation
Overview
This MCP server provides complete QuickBooks Online API integration for Claude Code and other MCP-compatible clients. It includes full CRUD operations for 29 entity types and 11 financial reports, giving you comprehensive access to QuickBooks Online functionality.
Key Features
144 Total Tools - Complete coverage of QuickBooks Online API
29 Entity Types - Full CRUD operations (Create, Read, Update, Delete, Search)
11 Financial Reports - Balance Sheet, P&L, Cash Flow, and more
OAuth 2.0 Authentication - Secure token-based authentication
TypeScript - Full type safety with Zod validation
Tested - Jest test suite with ESM support
Note: this is a local MCP server. It runs as a stdio subprocess on the developer's or partner's machine and authenticates to a QuickBooks Online company.
Quick Start
Installation
# Clone the repository
git clone https://github.com/your-username/mcp-quickbooks-online.git
cd mcp-quickbooks-online
# Install dependencies
npm install
# Build the project
npm run buildConfiguration
Copy the template .env.example to .env in the root directory and fill in your values:
cp .env.example .envQUICKBOOKS_CLIENT_ID=your_client_id
QUICKBOOKS_CLIENT_SECRET=your_client_secret
QUICKBOOKS_ENVIRONMENT=sandbox
QUICKBOOKS_REFRESH_TOKEN=your_refresh_token
QUICKBOOKS_REALM_ID=your_realm_id.env is gitignored so your real credentials stay local.
Claude Code Integration
Add to your Claude Code MCP configuration:
{
"mcpServers": {
"quickbooks": {
"command": "node",
"args": ["path/to/mcp-quickbooks-online/dist/index.js"],
"env": {
"QUICKBOOKS_CLIENT_ID": "your_client_id",
"QUICKBOOKS_CLIENT_SECRET": "your_client_secret",
"QUICKBOOKS_REFRESH_TOKEN": "your_refresh_token",
"QUICKBOOKS_REALM_ID": "your_realm_id",
"QUICKBOOKS_ENVIRONMENT": "sandbox"
}
}
}
}Available Tools
Entities
Complete CRUD operations are available for all entity types:
Entity | Create | Get | Update | Delete | Search |
Customer | ✅ | ✅ | ✅ | ✅ | ✅ |
Invoice | ✅ | ✅ | ✅ | ✅ | ✅ |
Estimate | ✅ | ✅ | ✅ | ✅ | ✅ |
Bill | ✅ | ✅ | ✅ | ✅ | ✅ |
Vendor | ✅ | ✅ | ✅ | ✅ | ✅ |
Employee | ✅ | ✅ | ✅ | ✅ | ✅ |
Account | ✅ | ✅ | ✅ | - | ✅ |
Item | ✅ | ✅ | ✅ | ✅ | ✅ |
Journal Entry | ✅ | ✅ | ✅ | ✅ | ✅ |
Bill Payment | ✅ | ✅ | ✅ | ✅ | ✅ |
Purchase | ✅ | ✅ | ✅ | ✅ | ✅ |
Payment | ✅ | ✅ | ✅ | ✅ | ✅ |
Sales Receipt | ✅ | ✅ | ✅ | ✅ | ✅ |
Credit Memo | ✅ | ✅ | ✅ | ✅ | ✅ |
Refund Receipt | ✅ | ✅ | ✅ | ✅ | ✅ |
Purchase Order | ✅ | ✅ | ✅ | ✅ | ✅ |
Vendor Credit | ✅ | ✅ | ✅ | ✅ | ✅ |
Deposit | ✅ | ✅ | ✅ | ✅ | ✅ |
Transfer | ✅ | ✅ | ✅ | ✅ | ✅ |
Time Activity | ✅ | ✅ | ✅ | ✅ | ✅ |
Class | ✅ | ✅ | ✅ | - | ✅ |
Department | ✅ | ✅ | ✅ | - | ✅ |
Term | ✅ | ✅ | ✅ | - | ✅ |
Payment Method | ✅ | ✅ | ✅ | - | ✅ |
Tax Code | - | ✅ | - | - | ✅ |
Tax Rate | - | ✅ | - | - | ✅ |
Tax Agency | - | ✅ | - | - | ✅ |
Company Info | - | ✅ | ✅ | - | - |
Attachable | ✅ | ✅ | ✅ | ✅ | ✅ |
Reports
Report | Tool Name | Description |
Balance Sheet |
| Assets, liabilities, and equity snapshot |
Profit & Loss |
| Income and expenses over a period |
Cash Flow |
| Cash inflows and outflows |
Trial Balance |
| Debit and credit balances |
General Ledger |
| Complete transaction history |
Customer Sales |
| Sales by customer |
Aged Receivables |
| Outstanding customer invoices |
Aged Receivables Detail |
| Detailed aging breakdown |
Customer Balance |
| Current customer balances |
Aged Payables |
| Outstanding vendor bills |
Vendor Expenses |
| Expenses by vendor |
Tool Reference
Tool | Description |
| Create a new customer |
| Get customer by ID |
| Update customer details |
| Delete a customer |
| Search customers with filters |
Tool | Description |
| Create a new invoice |
| Get invoice by ID |
| Update invoice details |
| Delete/void an invoice |
| Search invoices with filters |
Tool | Description |
| Record a customer payment |
| Get payment by ID |
| Update payment details |
| Void a payment |
| Search payments with filters |
Tool | Description |
| Create a new bill |
| Get bill by ID |
| Update bill details |
| Delete a bill |
| Search bills with filters |
| Create a new vendor |
| Get vendor by ID |
| Update vendor details |
| Delete a vendor |
| Search vendors with filters |
| Create a bill payment |
| Get bill payment by ID |
| Update bill payment |
| Delete a bill payment |
| Search bill payments |
Tool | Description |
| Create a sales receipt |
| Get sales receipt by ID |
| Update sales receipt |
| Void a sales receipt |
| Search sales receipts |
| Create a credit memo |
| Get credit memo by ID |
| Update credit memo |
| Void a credit memo |
| Search credit memos |
| Create a refund receipt |
| Get refund receipt by ID |
| Update refund receipt |
| Void a refund receipt |
| Search refund receipts |
Tool | Description |
| Create a bank deposit |
| Get deposit by ID |
| Update deposit details |
| Delete a deposit |
| Search deposits |
| Create an account transfer |
| Get transfer by ID |
| Update transfer details |
| Delete a transfer |
| Search transfers |
Tool | Description |
| Create a purchase order |
| Get purchase order by ID |
| Update purchase order |
| Delete a purchase order |
| Search purchase orders |
| Create a vendor credit |
| Get vendor credit by ID |
| Update vendor credit |
| Delete a vendor credit |
| Search vendor credits |
Tool | Description |
| Create a time activity |
| Get time activity by ID |
| Update time activity |
| Delete a time activity |
| Search time activities |
Tool | Description |
| Create a class |
| Get class by ID |
| Update class details |
| Search classes |
| Create a department |
| Get department by ID |
| Update department |
| Search departments |
Tool | Description |
| Create a payment term |
| Get term by ID |
| Update term details |
| Search terms |
| Create a payment method |
| Get payment method by ID |
| Update payment method |
| Search payment methods |
Tool | Description |
| Get tax code by ID |
| Search tax codes |
| Get tax rate by ID |
| Search tax rates |
| Get tax agency by ID |
| Search tax agencies |
Tool | Description |
| Get company information |
| Update company info |
| Create an attachment |
| Get attachment by ID |
| Update attachment |
| Delete an attachment |
| Search attachments |
Authentication
This server uses OAuth 2.0 to authenticate to a QuickBooks Online company. You'll set up an app on the Intuit Developer Portal and connect it to either a sandbox (for development) or your production QBO company.
Important: Sandbox vs Production
Mode | When to use | Redirect URI accepted | Setup difficulty |
Sandbox | Development, testing, demos |
| Easy |
Production | Real company data | Localhost rejected — must be a public HTTPS URL | Harder (see below) |
If you only want to read your own company's data, you still need to set up an app — Intuit does not offer per-user API keys. There is no shortcut around the OAuth + app-creation flow.
Sandbox Setup (recommended for first run)
Go to the Intuit Developer Portal and create a new app
Open the app → Settings (left sidebar) → Redirect URIs → add:
http://localhost:8000/callbackGet your Client ID and Client Secret from the app's Keys & Credentials page (Development keys)
Create or use a sandbox company under the Sandbox top-level menu item in the dev portal
Set
QUICKBOOKS_ENVIRONMENT=sandboxin your.envRun
npm run authto complete the OAuth handshake — your browser will open, you sign in to the sandbox company, tokens are saved to.env
Production Setup
The Intuit Developer Portal rejects http://localhost redirect URIs in production mode — every contributor hits this. Two known workarounds:
ngrok tunnel (most common): run
ngrok http 8000, then on your Intuit app go to Settings → Redirect URIs and add the generatedhttps://<id>.ngrok-free.app/callbackURL. Use that URL for the OAuth handshake, then revert to localhost afterwards.Deploy a small public callback handler (e.g., on a VPS or serverless function) that captures the auth code and hands it back to your local setup. More involved; only needed if you can't use ngrok.
After completing the production OAuth handshake, the refresh token is what matters — once it's in .env, you no longer need the public redirect URL for day-to-day use. Refresh tokens auto-rotate; the server persists the new token on each refresh.
Once you have tokens
QUICKBOOKS_CLIENT_ID=your_client_id
QUICKBOOKS_CLIENT_SECRET=your_client_secret
QUICKBOOKS_REFRESH_TOKEN=your_refresh_token
QUICKBOOKS_REALM_ID=your_realm_id
QUICKBOOKS_ENVIRONMENT=sandbox # or 'production'Common pitfalls
.envloaded from the wrong directory. The server resolves.envrelative to the compiled module, not your shell's CWD. If you launch via Claude Desktop, this matters — make sure you're on currentmain.Redirect URI mismatch. The URI you register in the Intuit portal must match exactly — protocol, host, port, path.
http://localhost:8000/callback.
Development
Building
npm run buildTesting
npm testThe test suite includes 396 tests with 100% code coverage across all metrics (statements, branches, functions, lines).
Project Structure
src/
├── clients/ # QuickBooks API client
├── handlers/ # Business logic handlers (87 files)
├── tools/ # MCP tool definitions
├── helpers/ # Utility functions
├── types/ # TypeScript types
└── index.ts # Server entry point
tests/
├── unit/ # Unit tests (396 tests)
│ ├── handlers/ # Handler tests (15 test files)
│ └── helpers/ # Helper tests
└── mocks/ # Test mocks
docs/
├── ARCHITECTURE.md # System architecture & design patterns
├── TESTING.md # Testing guide & patterns
└── plans/ # Development plansDocumentation
Document | Description |
Version history and all changes | |
System architecture, patterns, and design decisions | |
Testing strategy, ESM patterns, and coverage guide |
Error Handling
If you encounter connection errors:
Verify all environment variables are set correctly
Check that tokens are valid and not expired
Ensure the QuickBooks app has the correct redirect URIs
For sandbox testing, use
QUICKBOOKS_ENVIRONMENT=sandbox
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
License
MIT License - see LICENSE for details.
Acknowledgments
Built with the Model Context Protocol
This server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/intuit/quickbooks-online-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server