Connects to QuickBooks Online's API with a focus on financial professionals rather than developers exploring the API. Resolves vendor and account names automatically instead of requiring internal IDs, includes built-in tools for P&L, Balance Sheet, and Trial Balance reports, and defaults all write operations to draft mode so you see changes before they hit your books. Uses a single SQL-like query tool across all QuickBooks entities instead of separate search endpoints for each type. Handles OAuth token refresh automatically and supports both local credential storage and AWS Secrets Manager for shared environments. Ships via npm and designed for bookkeepers and CFOs who want to pull reports or create journal entries through an AI assistant using plain language.
Public tool metadata for what this MCP can expose to an agent.
QUICKBOOKS_CREATE_ACCOUNTCreate a new account in QuickBooks with the given parameters.4 paramsCreate a new account in QuickBooks with the given parameters.
namestringaccount_typestringBank · Other Current Asset · Fixed Asset · Other Asset · Accounts Receivable · Equityaccount_numberstringaccount_sub_typestringCashOnHand · Checking · MoneyMarket · RentsHeldInTrust · Savings · TrustAccountsQUICKBOOKS_CREATE_CUSTOMERCreate a new customer in QuickBooks with the given parameters.6 paramsCreate a new customer in QuickBooks with the given parameters.
titlestringsuffixstringgiven_namestringfamily_namestringmiddle_namestringdisplay_namestringQUICKBOOKS_CREATE_EMPLOYEECreate a new employee in QuickBooks.3 paramsCreate a new employee in QuickBooks.
given_namestringfamily_namestringprimary_addrobjectQUICKBOOKS_CREATE_INVOICETool to create a new invoice in QuickBooks. Use after confirming customer and item details.3 paramsTool to create a new invoice in QuickBooks. Use after confirming customer and item details.
linesarraycustomer_idstringminorversionintegerQUICKBOOKS_CREATE_VENDORCreate a new vendor in QuickBooks with the given details.6 paramsCreate a new vendor in QuickBooks with the given details.
titlestringsuffixstringgiven_namestringfamily_namestringmiddle_namestringdisplay_namestringQUICKBOOKS_CUSTOMER_BALANCE_DETAILGenerate a balance detail report for a customer in QuickBooks with the given customer ID.13 paramsGenerate a balance detail report for a customer in QuickBooks with the given customer ID.
arpaidstringAll · Paid · Unpaidcolumnsstringcustom1stringshipviastringsort_bystringterm_idsarraysort_orderstringascend · descendend_duedatestringreport_datestringaging_methodstringReport_Date · Currentcustomer_idsarraystart_duedatestringdepartment_idsarrayQUICKBOOKS_CUSTOMER_BALANCE_REPORTGenerate a balance report for a customer in QuickBooks with the given customer ID.8 paramsGenerate a balance report for a customer in QuickBooks with the given customer ID.
arpaidstringAll · Paid · Unpaiddate_macrostringToday · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datesort_orderstringascend · descendreport_datestringcustomer_idsarraydepartment_idsarrayaccounting_methodstringCash · Accrualsummarize_column_bystringTotal · Month · Week · Days · Quarter · YearQUICKBOOKS_LIST_INVOICESTool to list invoices via QuickBooks Query endpoint. Use when retrieving invoices with optional pagination and custom fields.3 paramsTool to list invoices via QuickBooks Query endpoint. Use when retrieving invoices with optional pagination and custom fields.
fieldsarraymax_resultsintegerstart_positionintegerQUICKBOOKS_QUERY_ACCOUNTQuery an account in QuickBooks with the given parameters.1 paramsQuery an account in QuickBooks with the given parameters.
querystringQUICKBOOKS_READ_ACCOUNTRead an account in QuickBooks with the given account ID.1 paramsRead an account in QuickBooks with the given account ID.
account_idstringQUICKBOOKS_READ_CUSTOMERRead a customer in QuickBooks with the given customer ID.1 paramsRead a customer in QuickBooks with the given customer ID.
customer_idstringQUICKBOOKS_READ_EMPLOYEERead an employee's details in QuickBooks with the given employee ID.1 paramsRead an employee's details in QuickBooks with the given employee ID.
employee_idstringQUICKBOOKS_READ_INVOICETool to fetch a QuickBooks invoice by ID or the most recent if no ID provided. Use when needing full invoice details including metadata and sync token.2 paramsTool to fetch a QuickBooks invoice by ID or the most recent if no ID provided. Use when needing full invoice details including metadata and sync token.
invoice_idstringminorversionintegerQUICKBOOKS_READ_VENDORRead a vendor in QuickBooks with the given vendor ID.1 paramsRead a vendor in QuickBooks with the given vendor ID.
vendor_idstringQUICKBOOKS_UPDATE_FULL_INVOICETool to fully replace an Invoice. Use when you need to update all aspects of an existing invoice in a single operation.3 paramsTool to fully replace an Invoice. Use when you need to update all aspects of an existing invoice in a single operation.
invoiceobjectrequestidstringminorversionintegerQUICKBOOKS_UPDATE_SPARSE_INVOICETool to perform a sparse update of an existing invoice. Use when you need to update only specific invoice fields without overwriting other data.1 paramsTool to perform a sparse update of an existing invoice. Use when you need to update only specific invoice fields without overwriting other data.
invoiceobjectQUICKBOOKS_VENDOR_BALANCE_DETAILGenerate a balance detail report for a vendor in QuickBooks with the given vendor ID.12 paramsGenerate a balance detail report for a vendor in QuickBooks with the given vendor ID.
appaidstringAll · Paid · Unpaidsort_bystringterm_idsarraydate_macrostringToday · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datesort_orderstringascend · descendvendor_idsarrayend_duedatestringreport_datestringduedate_macrostringToday · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datestart_duedatestringdepartment_idsarrayaccounting_methodstringCash · AccrualQUICKBOOKS_VENDOR_BALANCE_REPORTGet the balance report of a vendor in QuickBooks with the given vendor ID.9 paramsGet the balance report of a vendor in QuickBooks with the given vendor ID.
qzurlstringappaidstringAll · Paid · Unpaiddate_macrostringToday · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datesort_orderstringascend · descendvendor_idsarrayreport_datestringdepartment_idsarrayaccounting_methodstringCash · Accrualsummarize_column_bystringTotal · Month · Week · Days · Quarter · YearAn MCP server for QuickBooks Online — built for bookkeepers, CFOs, and accountants who use AI assistants in their daily workflow.
Ask your AI assistant to pull a P&L report, create a journal entry, or investigate an account balance — using plain language, not API payloads.
Intuit provides an official MCP server that's a solid starting point for developers exploring the QuickBooks API. This server takes a different approach: it's designed for financial professionals working in production books.
Intuit's server requires QuickBooks internal IDs for every reference — you need to look up a vendor's ID before creating a bill. This server resolves names automatically:
"Create a bill for PG&E, $450 to Utilities, dated 2025-01-15"
→ Vendor, account, and department names are resolved automatically
This is the only QuickBooks MCP server with report tools. Pull a P&L, Balance Sheet, or Trial Balance — broken down by month, department, or class — without leaving your AI conversation.
Every create and edit operation defaults to draft/preview mode. You see exactly what will be written to your books before committing. No accidental journal entries or misclassified expenses.
Instead of separate search tools for each entity type, a single SQL-like query tool works across all QuickBooks entities. AI assistants write SQL naturally, and QuickBooks validates it — no field whitelists to maintain.
"SELECT * FROM Purchase WHERE TxnDate >= '2025-01-01' AND TxnDate <= '2025-01-31'"
Store credentials locally for personal use, or in AWS Secrets Manager for shared environments. OAuth tokens refresh automatically and persist across sessions.
| Intuit Official | This Server | |
|---|---|---|
| Audience | Developers exploring the API | Bookkeepers, CFOs, accountants |
| Name resolution | Requires internal QB IDs | Resolves names automatically |
| Financial reports | None | P&L, Balance Sheet, Trial Balance |
| Write safety | Executes immediately | Draft preview by default |
| Query approach | Entity-specific search tools | SQL-like queries across all entities |
| Credentials | Local .env file | Local file or AWS Secrets Manager |
| Distribution | Clone from GitHub | npx quickbooks-mcp |
Choose the setup that fits your use case:
| Setup | Best For |
|---|---|
| NPM Install | Quick setup, using your own QuickBooks app |
| Local Checkout | Development, customization |
| AWS Mode | Shared/production environments |
The simplest way to get started. Credentials are stored locally on your machine.
https://developer.intuit.com/v2/OAuth2Playground/RedirectUrlAdd to your project's .mcp.json:
{
"mcpServers": {
"quickbooks": {
"command": "npx",
"args": ["-y", "quickbooks-mcp"]
}
}
}
Create ~/.quickbooks-mcp/credentials.json:
{
"client_id": "your_client_id",
"client_secret": "your_client_secret"
}
Once Claude Code is running, use the qbo_authenticate tool:
qbo_authenticate with no arguments to get an authorization URLcode and realmId from the redirect URLqbo_authenticate again with the authorization code and realm IDYour OAuth tokens will be saved and automatically refreshed.
For development or customization.
Follow the same steps as Option 1 above.
git clone https://github.com/laf-rge/quickbooks-mcp.git
cd quickbooks-mcp
npm install
npm run build
Add to your project's .mcp.json:
{
"mcpServers": {
"quickbooks": {
"command": "node",
"args": ["/path/to/quickbooks-mcp/dist/index.js"]
}
}
}
Create ~/.quickbooks-mcp/credentials.json with your client credentials (same as Option 1), then run qbo_authenticate to complete the OAuth flow.
For shared or production environments. Stores credentials in AWS Secrets Manager.
Create the secret in Secrets Manager:
aws secretsmanager create-secret \
--name prod/qbo \
--secret-string '{
"client_id": "your_client_id",
"client_secret": "your_client_secret",
"access_token": "your_access_token",
"refresh_token": "your_refresh_token",
"redirect_url": "https://developer.intuit.com/v2/OAuth2Playground/RedirectUrl"
}'
Store Company ID in SSM Parameter Store:
aws ssm put-parameter \
--name /prod/qbo/company_id \
--value "your_company_id" \
--type SecureString
Create a .env file in the quickbooks-mcp directory:
QBO_CREDENTIAL_MODE=aws
AWS_REGION=us-east-2
QBO_SECRET_NAME=prod/qbo
QBO_COMPANY_ID_PARAM=/prod/qbo/company_id
Note: Due to a known Claude Code bug, environment variables from
.mcp.jsonare not reliably passed to MCP servers. The.envfile workaround is required.
{
"mcpServers": {
"quickbooks": {
"command": "node",
"args": ["/path/to/quickbooks-mcp/dist/index.js"]
}
}
}
The server needs these AWS permissions:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"secretsmanager:GetSecretValue",
"secretsmanager:PutSecretValue"
],
"Resource": "arn:aws:secretsmanager:*:*:secret:prod/qbo*"
},
{
"Effect": "Allow",
"Action": ["ssm:GetParameter"],
"Resource": "arn:aws:ssm:*:*:parameter/prod/qbo/*"
}
]
}
By default, large responses (reports, query results) are written to /tmp files and the server returns a file path. This works well for Claude Code in terminal environments but breaks in Claude Desktop and plugin environments where the model cannot read from /tmp.
Set QBO_INLINE_OUTPUT=true to return all responses inline instead.
Option A — via .env file (recommended for local checkout):
Create a .env file in the quickbooks-mcp directory:
QBO_INLINE_OUTPUT=true
Option B — via .mcp.json env block (recommended for NPM install):
{
"mcpServers": {
"quickbooks": {
"command": "npx",
"args": ["-y", "quickbooks-mcp"],
"env": {
"QBO_CREDENTIAL_MODE": "local",
"QBO_CREDENTIAL_FILE": "~/.quickbooks-mcp/credentials.json",
"QBO_INLINE_OUTPUT": "true"
}
}
}
}
Note: Due to a known Claude Code bug, environment variables from
.mcp.jsonare not reliably passed to MCP servers in some configurations. If Option B doesn't work, use the.envfile workaround.
| Variable | Default | Description |
|---|---|---|
QBO_CREDENTIAL_MODE | local | Credential storage: local or aws |
QBO_CLIENT_ID | - | QuickBooks app Client ID (local mode) |
QBO_CLIENT_SECRET | - | QuickBooks app Client Secret (local mode) |
QBO_CREDENTIAL_FILE | ~/.quickbooks-mcp/credentials.json | Custom credential file path |
QBO_INLINE_OUTPUT | false | Return responses inline instead of writing to /tmp files. Required when using Claude Desktop or plugin environments where file-based output is not accessible to the model. |
QBO_SANDBOX | false | Use QuickBooks sandbox environment |
AWS_REGION | us-east-2 | AWS region (aws mode) |
QBO_SECRET_NAME | prod/qbo | Secrets Manager secret name (aws mode) |
QBO_COMPANY_ID_PARAM | /prod/qbo/company_id | SSM parameter path (aws mode) |
| Tool | Description |
|---|---|
| Setup | |
qbo_authenticate | Set up OAuth credentials (local mode only) |
get_company_info | Get connected company information |
| Query & Reports | |
query | Run SQL-like queries against any QuickBooks entity |
list_accounts | List chart of accounts with filtering |
get_profit_loss | Profit & Loss report (by month, department, class, etc.) |
get_balance_sheet | Balance Sheet report |
get_trial_balance | Trial Balance report |
query_account_transactions | All transactions affecting a specific account |
account_period_summary | Period summary for an account (opening/closing balance, debits, credits, count) |
| Journal Entries | |
create_journal_entry | Create a journal entry (validates debits = credits) |
get_journal_entry | Fetch a journal entry by ID |
edit_journal_entry | Modify an existing journal entry |
| Bills | |
create_bill | Create a vendor bill |
get_bill | Fetch a bill by ID |
edit_bill | Modify an existing bill |
| Expenses | |
create_expense | Create an expense (Cash, Check, or Credit Card) |
get_expense | Fetch an expense by ID |
edit_expense | Modify an existing expense |
| Sales Receipts | |
create_sales_receipt | Create a sales receipt with item lines |
get_sales_receipt | Fetch a sales receipt by ID |
edit_sales_receipt | Modify an existing sales receipt |
| Invoices | |
create_invoice | Create an invoice with item lines (customer required) |
get_invoice | Fetch an invoice by ID |
edit_invoice | Modify an existing invoice |
| Deposits | |
create_deposit | Create a bank deposit |
get_deposit | Fetch a deposit by ID |
edit_deposit | Modify an existing deposit |
| Vendor Credits | |
create_vendor_credit | Create a vendor credit |
get_vendor_credit | Fetch a vendor credit by ID |
edit_vendor_credit | Modify an existing vendor credit |
| Bill Payments | |
create_bill_payment | Pay bills and apply vendor credits (the QBO "check" / pay-bills flow) |
get_bill_payment | Fetch a bill payment by ID; flags unapplied amounts |
| Delete | |
delete_entity | Delete any transaction (journal entry, bill, invoice, deposit, sales receipt, expense, vendor credit, bill payment) |
The server automatically refreshes OAuth tokens on each request and persists them back to your credential store (local file or AWS Secrets Manager).
npm run dev # Run in development mode
npm run build # Build
npm run typecheck # Type check
Run the qbo_authenticate tool to set up OAuth credentials (local mode only).
Authorization codes are only valid for a few minutes. Start the OAuth flow again.
qbo_authenticate.env file has QBO_CREDENTIAL_MODE=awsQBO_CLIENT_IDsecretQuickBooks app Client ID from developer.intuit.com
QBO_CLIENT_SECRETsecretQuickBooks app Client Secret from developer.intuit.com
QBO_CREDENTIAL_MODECredential storage mode: 'local' (default) or 'aws'
QBO_SANDBOXSet to 'true' to use QuickBooks sandbox environment
io.github.shelvick/shopify-subscription-reconciliation
zleventer/google-ads-mcp
csoai-org/meok-stripe-acp-checkout-mcp
io.github.mharnett/google-ads
csoai-org/stripe-billing-mcp
co.pipeboard/google-ads-mcp