Summary
Gives your AI assistant direct access to QuickBooks Online data through five focused tools. You can search across customers, invoices, and accounts with flexible filters, pull complete customer profiles with balances and contact details, list recent invoices or grab full line-item breakdowns by ID, and export your entire chart of accounts with classifications and balances. Runs as a hosted service through Pipeworx's gateway, so there's no local setup or OAuth flow to manage. Works standalone or as part of their larger 250+ data source collection. If you're building financial workflows or need an agent that can answer questions about receivables, customer history, or account balances without manual exports, this is the integration.
Fastest browser for AI agents to run web automation tasks, always free.
Download Free life-time →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
Tools
Public tool metadata for what this MCP can expose to an agent.
18 tools
QUICKBOOKS_CREATE_ACCOUNTCreate a new account in QuickBooks with the given parameters.4 params
Create a new account in QuickBooks with the given parameters.
Parameters* required
account_numberstringUser-defined account number to help the user in identifying the account within the chart-of-accounts and in deciding what should be posted to the account. must not contain colon (:). For France loc...
account_sub_typestringSub-type of the account. Must use exact enum values (no spaces/slashes). Examples: 'AdvertisingPromotional' (NOT 'Advertising/Promotional'), 'Checking', 'Inventory', 'OtherCurrentAssets', 'Vehicles...one of
CashOnHand · Checking · MoneyMarket · RentsHeldInTrust · Savings · TrustAccountsaccount_typestringType of the account to be createdone of
Bank · Other Current Asset · Fixed Asset · Other Asset · Accounts Receivable · EquitynamestringUser recognizable name for the Account. Account.Name attribute must not contain double quotes (") or colon (:).
QUICKBOOKS_CREATE_CUSTOMERCreate a new customer in QuickBooks with the given parameters.6 params
Create a new customer in QuickBooks with the given parameters.
Parameters* required
display_namestringThe name as displayed. Must be unique across all Customer, Vendor, and Employee objects. Cannot be removed with sparse update. If not supplied, the system generates DisplayName by concatenating cus...
family_namestringFamily name or the last name of the person. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
given_namestringGiven name or first name of a person. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
middle_namestringMiddle name of the person. The person can have zero or more middle names. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for...
suffixstringSuffix of the name. For example, Jr. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
titlestringTitle of the person (max 16 characters - keep it short like 'Mr.', 'Dr.', 'CEO'). This tag supports i18n, all locales. The DisplayName attribute or at least one of Title, GivenName, MiddleName, Fam...
QUICKBOOKS_CREATE_EMPLOYEECreate a new employee in QuickBooks.3 params
Create a new employee in QuickBooks.
Parameters* required
family_namestringFamily name or the last name of the person. At least one of `given_name` or `family_name` attributes is required.
given_namestringGiven name or Family name of a person. At least one of `given_name` or `family_name` attributes is required.
primary_addrobjectRepresents the physical street address for this employee. If QuickBooks Payroll is enabled for the company, the following PhysicalAddress fields are required: City, CountrySubDivisionCode, PostalCode.
QUICKBOOKS_CREATE_INVOICETool to create a new invoice in QuickBooks. Use after confirming customer and item details.3 params
Tool to create a new invoice in QuickBooks. Use after confirming customer and item details.
Parameters* required
customer_idstringID of the customer to invoice (CustomerRef.value)
linesarrayList of invoice line item objects. Each item must include at least: 'DetailType', 'Amount', and 'SalesItemLineDetail' with an 'ItemRef.value'.
minorversionintegerOptional minorversion query parameter to control API behavior
QUICKBOOKS_CREATE_VENDORCreate a new vendor in QuickBooks with the given details.6 params
Create a new vendor in QuickBooks with the given details.
Parameters* required
display_namestringThe name as displayed. Must be unique across all Customer, Vendor, and Employee objects. Cannot be removed with sparse update. If not supplied, the system generates DisplayName by concatenating cus...
family_namestringFamily name or the last name of the person. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
given_namestringGiven name or first name of a person. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
middle_namestringMiddle name of the person. The person can have zero or more middle names. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for...
suffixstringSuffix of the name. For example, Jr. The DisplayName attribute or at least one of Title, GivenName, MiddleName, FamilyName, or Suffix attributes is required for object create.
titlestringTitle of the person (max 16 characters - keep it short like 'Mr.', 'Dr.', 'CEO'). This tag supports i18n, all locales. The DisplayName attribute or at least one of Title, GivenName, MiddleName, Fam...
QUICKBOOKS_CUSTOMER_BALANCE_DETAILGenerate a balance detail report for a customer in QuickBooks with the given customer ID.13 params
Generate a balance detail report for a customer in QuickBooks with the given customer ID.
Parameters* required
aging_methodstringThe date upon which aging is determined.one of
Report_Date · CurrentarpaidstringStatus of the balance.one of
All · Paid · UnpaidcolumnsstringColumn types to be shown in the report. Supported Values: bill_addr, create_by, create_date, cust_bill_email, cust_comp_name, cust_msg, cust_phone_other, cust_tel, cust_name, deliv_addr, doc_num*,...
custom1stringFilter by the specified custom field as defined by the CustomField attribute in transaction entities where supported. Supported Values: Name of custom field.
customer_idsarrayOne or more comma separated customer IDs. Filters report contents to include information for specified customers.
department_idsarrayOne or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
end_duedatestringThe range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned.
report_datestringStart date to use for the report, in the format YYYY-MM-DD.
shipviastringFilter by the shipping method as stored in Invoice.ShipMethodRef.Name.
sort_bystringThe column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
sort_orderstringThe sort order.one of
ascend · descendstart_duedatestringThe range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned.
term_idsarrayOne or more comma separated term IDs. Filters report contents based on term or terms supplied.
QUICKBOOKS_CUSTOMER_BALANCE_REPORTGenerate a balance report for a customer in QuickBooks with the given customer ID.8 params
Generate a balance report for a customer in QuickBooks with the given customer ID.
Parameters* required
accounting_methodstringThe accounting method used in the report. one of
Cash · AccrualarpaidstringSupported Values: All, Paid, Unpaidone of
All · Paid · Unpaidcustomer_idsarrayFilters report contents to include information for specified customers. Supported Values: One or more comma separated customer IDs as returned in the attribute, Customer.Id, of the Customer object...
date_macrostringPredefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range.one of
Today · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datedepartment_idsarrayOne or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
report_datestringStart date to use for the report, in the format YYYY-MM-DD.
sort_orderstringThe sort order.one of
ascend · descendsummarize_column_bystringThe criteria by which to group the report results.one of
Total · 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 params
Tool to list invoices via QuickBooks Query endpoint. Use when retrieving invoices with optional pagination and custom fields.
Parameters* required
fieldsarrayList of fields to select in the query. Defaults to ['Id','SyncToken','DocNumber','TotalAmt','Balance','TxnDate'].
max_resultsintegerMaximum number of records to return; default 50, max 1000.default: 50
start_positionintegerStarting position for pagination within the result set. Default is 1.default: 1
QUICKBOOKS_QUERY_ACCOUNTQuery an account in QuickBooks with the given parameters.1 params
Query an account in QuickBooks with the given parameters.
Parameters* required
querystringQuery to be executed
QUICKBOOKS_READ_ACCOUNTRead an account in QuickBooks with the given account ID.1 params
Read an account in QuickBooks with the given account ID.
Parameters* required
account_idstringID of the account to be read
QUICKBOOKS_READ_CUSTOMERRead a customer in QuickBooks with the given customer ID.1 params
Read a customer in QuickBooks with the given customer ID.
Parameters* required
customer_idstringID of the customer to be read
QUICKBOOKS_READ_EMPLOYEERead an employee's details in QuickBooks with the given employee ID.1 params
Read an employee's details in QuickBooks with the given employee ID.
Parameters* required
employee_idstringThe ID of the employee to be read.
QUICKBOOKS_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 params
Tool 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.
Parameters* required
invoice_idstringID of the invoice to read; if not provided, fetches the latest invoice
minorversionintegerAPI minor version to use for the request
QUICKBOOKS_READ_VENDORRead a vendor in QuickBooks with the given vendor ID.1 params
Read a vendor in QuickBooks with the given vendor ID.
Parameters* required
vendor_idstringID of the vendor to be read
QUICKBOOKS_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 params
Tool to fully replace an Invoice. Use when you need to update all aspects of an existing invoice in a single operation.
Parameters* required
invoiceobjectFull Invoice JSON payload to update; must include Id and SyncToken. Any writable field omitted will be cleared. Do not set sparse=true.
minorversionintegerOptional QuickBooks API minorversion to access newer fields (e.g., 63).
requestidstringOptional idempotency key (<=50 chars) to prevent duplicate writes on retries.
QUICKBOOKS_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 params
Tool to perform a sparse update of an existing invoice. Use when you need to update only specific invoice fields without overwriting other data.
Parameters* required
invoiceobjectInvoice object containing Id, SyncToken, sparse flag, and fields to update
QUICKBOOKS_VENDOR_BALANCE_DETAILGenerate a balance detail report for a vendor in QuickBooks with the given vendor ID.12 params
Generate a balance detail report for a vendor in QuickBooks with the given vendor ID.
Parameters* required
accounting_methodstringThe accounting method used in the report.one of
Cash · AccrualappaidstringStatus of the balance.one of
All · Paid · Unpaiddate_macrostringPredefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range.one of
Today · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datedepartment_idsarrayOne or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
duedate_macrostringPredefined date range of due dates for balances to include in the report; otherwise, use the start_duedate and end_duedate to cover an explicit report date range. one of
Today · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-dateend_duedatestringThe range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned.
report_datestringStart date to use for the report, in the format YYYY-MM-DD.
sort_bystringThe column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
sort_orderstringThe sort order.one of
ascend · descendstart_duedatestringThe range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned.
term_idsarrayOne or more comma separated term IDs. Filters report contents based on term or terms supplied.
vendor_idsarrayOne or more comma separated vendor IDs. Filters report contents to include information for specified vendors.
QUICKBOOKS_VENDOR_BALANCE_REPORTGet the balance report of a vendor in QuickBooks with the given vendor ID.9 params
Get the balance report of a vendor in QuickBooks with the given vendor ID.
Parameters* required
accounting_methodstringThe accounting method used in the report. one of
Cash · AccrualappaidstringStatus of the balance.one of
All · Paid · Unpaiddate_macrostringPredefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range.one of
Today · Yesterday · This Week · Last Week · This Week-to-date · Last Week-to-datedepartment_idsarrayOne or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
qzurlstringSpecifies whether Quick Zoom URL information should be generated for rows in the report.
report_datestringStart date to use for the report, in the format YYYY-MM-DD.
sort_orderstringThe sort order.one of
ascend · descendsummarize_column_bystringThe criteria by which to group the report results.one of
Total · Month · Week · Days · Quarter · Yearvendor_idsarrayFilters report contents to include information for specified vendors. Supported Values: One or more comma separated vendor IDs as returned in the attribute, Vendor.Id, of the Vendor object response...
mcp-quickbooks
QuickBooks MCP Pack — query customers, invoices, and accounts via QuickBooks Online API.
Part of Pipeworx — an MCP gateway connecting AI agents to 1476+ live data sources.
Tools
| Tool | Description |
|---|---|
qb_query | Execute a QuickBooks SQL-like query (QBO query language) against any entity type — Customer, Invoice, Account, etc. Example: "SELECT * FROM Customer MAXRESULTS 10". Returns raw QuickBooks API response with matching records. |
qb_get_customer | Retrieve a customer's complete profile including contact info, email, phone, and account balance by customer ID. |
qb_list_invoices | Get recent invoices with number, customer, amount, due date, and payment status. Use qb_get_invoice for full line-item details. |
qb_get_invoice | Retrieve a complete invoice by ID including all line items, amounts, taxes, and payment history. |
qb_list_accounts | Get your chart of accounts with account names, types (asset/liability/equity/etc), balances, and classifications. |
Quick Start
Add to your MCP client (Claude Desktop, Cursor, Windsurf, etc.):
{
"mcpServers": {
"quickbooks": {
"url": "https://gateway.pipeworx.io/quickbooks/mcp"
}
}
}
What this endpoint actually serves
tools/list at https://gateway.pipeworx.io/quickbooks/mcp returns the tools in the table
above plus the shared Pipeworx meta-tools — ask_pipeworx,
discover_tools, search_within, remember/recall and the rest of the
gateway-wide set. So the tool count you see is larger than this table: a
single-pack endpoint currently lists roughly 30 shared tools alongside the
pack's own. The connection's initialize response states its exact scope, and
is the authoritative answer for a given day.
This is deliberate, not multiplexing by accident. The meta-tools are what let a
scoped connection answer a question this pack does not cover — via
ask_pipeworx, which routes across the whole catalog — without you adding a
second MCP server. There is currently no way to mount a pack endpoint without
them; if the extra schemas cost you more context than the routing is worth,
connect to the full gateway once rather than to several pack endpoints.
Or connect to the full Pipeworx gateway to get every pack's tools listed directly, instead of just this one's:
{
"mcpServers": {
"pipeworx": {
"url": "https://gateway.pipeworx.io/mcp"
}
}
}
Both URLs reach the same gateway and the same 1476+ data sources. The
only difference is which pack's tools are listed directly; ask_pipeworx
reaches all of them from either one.
Using with ask_pipeworx
Instead of calling tools directly, you can ask questions in plain English — this works on the pack endpoint above as well as on the full gateway:
ask_pipeworx({ question: "your question about Quickbooks data" })
The gateway picks the right tool and fills the arguments automatically.
More
License
MIT
No MCP client? Call it over HTTP
This pack runs against a connected quickbooks account, so it needs a Pipeworx key: sign in at https://pipeworx.io/account, connect quickbooks, then call POST https://gateway.pipeworx.io/v1/tools/qb_query with Authorization: Bearer <your Pipeworx key>. Inspect any tool: GET https://gateway.pipeworx.io/v1/tools/qb_query. Find one: POST https://gateway.pipeworx.io/v1/tools/search_packs with {"query":"..."}.
Featured
Fastest browser for AI agents to run web automation tasks, always free.
Download Free life-time →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
