- Category: accounting
- Auth: OAUTH2
- Composio-managed OAuth available? Yes
- Tools: 114
- Triggers: 0
- Slug:
QUICKBOOKS - Version: 20261101_00
Frequently Asked Questions
Why can QuickBooks OAuth show Cloudflare Error 1016 (Origin DNS error)?
Why can QuickBooks OAuth show Cloudflare Error 1016 (Origin DNS error)?
com.intuit.quickbooks.payment scope, check whether the QuickBooks Payments module is enabled for the selected QuickBooks company.That scope requires payment-module access in QuickBooks. If you do not need payment tools, remove com.intuit.quickbooks.payment from the auth config and reconnect. If you do need payment tools, enable QuickBooks Payments for that company/account, then start a fresh connection.Why can Claude block QuickBooks in consumer MCP sessions?
Why can Claude block QuickBooks in consumer MCP sessions?
When should I use the sandbox QuickBooks API base URL for sandbox connections?
When should I use the sandbox QuickBooks API base URL for sandbox connections?
https://sandbox-quickbooks.api.intuit.com as the URL/base URL when initiating the connection. Production connections should use the production Intuit API base URL.Tools
Capture Charge
Capture Charge
QUICKBOOKS_CAPTURE_CHARGETool to capture funds for an existing charge that was authorized but not captured. Use when you need to complete a previously authorized payment transaction in QuickBooks Payments API. This action finalizes the charge and transfers the funds from the customer’s payment method.Input Parameters
Output
Create Account
Create Account
QUICKBOOKS_CREATE_ACCOUNTCreate a new account in QuickBooks with the given parameters.Input Parameters
Output
Create Bank Account
Create Bank Account
QUICKBOOKS_CREATE_BANK_ACCOUNTCreate a new bank account on file for a customer in QuickBooks Payments API. Use this when you need to add ACH/eCheck payment capabilities for a customer.Input Parameters
Output
Create Bill
Create Bill
QUICKBOOKS_CREATE_BILLCreate a new bill in QuickBooks Online. A Bill is an AP transaction representing a request-for-payment from a third party for goods or services. Use this action when recording vendor bills for purchases, expenses, or services received.Input Parameters
Output
Create Bill Payment
Create Bill Payment
QUICKBOOKS_CREATE_BILL_PAYMENTCreate a bill payment in QuickBooks to record payment against one or more bills. Use when paying vendor bills via check or credit card.Input Parameters
Output
Create Class
Create Class
Create Credit Memo
Create Credit Memo
QUICKBOOKS_CREATE_CREDIT_MEMOTool to create a new credit memo in QuickBooks Online. Use when issuing credit to a customer for returns, refunds, or adjustments.Input Parameters
Output
Create Customer
Create Customer
QUICKBOOKS_CREATE_CUSTOMERCreate a new customer in QuickBooks with the given parameters.Input Parameters
Output
Create Deposit
Create Deposit
QUICKBOOKS_CREATE_DEPOSITCreates a new deposit in QuickBooks Online. A deposit represents funds received and deposited to an asset account (typically a bank account). Use this action to record deposits of customer payments, refunds, or other funds into your bank accounts. Each deposit must specify the destination account and at least one line item showing the source and amount of funds.Input Parameters
Output
Create eCheck Payment
Create eCheck Payment
QUICKBOOKS_CREATE_ECHECK_PAYMENTCreate an eCheck payment through the QuickBooks Payments API using customer bank account and routing details for an ACH debit. Requires the QuickBooks Payments authorization scope.Input Parameters
Output
Create Employee
Create Employee
QUICKBOOKS_CREATE_EMPLOYEECreate a new employee in QuickBooks.Input Parameters
Output
Create Estimate
Create Estimate
QUICKBOOKS_CREATE_ESTIMATECreates a new estimate in QuickBooks Online. An estimate represents a proposal for goods or services that a customer may purchase. Use this to provide pricing quotes to customers before they commit to a purchase. This action requires a valid customer ID and at least one line item with item details and amount. The created estimate can later be converted to an invoice when the customer accepts the proposal.Input Parameters
Output
Create Invoice
Create Invoice
QUICKBOOKS_CREATE_INVOICECreates a new invoice in QuickBooks for a customer. An invoice represents a sales transaction where goods or services are sold to a customer on credit or for immediate payment. This action requires: - A valid customer ID (obtain from QUICKBOOKS_CREATE_CUSTOMER or QUICKBOOKS_READ_CUSTOMER) - At least one line item with a valid item/service ID and amount The created invoice will have a unique ID, document number, due date, total amount, and balance. Use this to bill customers for products or services rendered. To update the invoice later, re-read it first to obtain the current SyncToken; stale tokens cause update rejections.Input Parameters
lines must reference active items/services.Output
Create Item
Create Item
QUICKBOOKS_CREATE_ITEMCreate a new item in QuickBooks Online. Items represent the products or services that a company buys, sells, or resells. Use when adding new inventory items, services, or non-inventory products to the QuickBooks catalog.Input Parameters
Output
Create Journal Entry
Create Journal Entry
QUICKBOOKS_CREATE_JOURNAL_ENTRYTool to create a new journal entry in QuickBooks Online. Use when you need to make adjusting or correcting entries that directly affect account balances. Journal entries require at least two lines with total debits equaling total credits.Input Parameters
Output
Create Payment
Create Payment
QUICKBOOKS_CREATE_PAYMENTCreates a payment record in QuickBooks Online. The Payment entity records payment from customers against single or multiple invoices and credit memos. Use this action when recording customer payments, whether full payment of an invoice or partial payment across multiple invoices.Input Parameters
Output
Create Purchase
Create Purchase
QUICKBOOKS_CREATE_PURCHASETool to create a new purchase transaction in QuickBooks Online. A purchase represents an expense such as a cash payment, check, or credit card purchase. Use when recording business expenses or making payments to vendors.Input Parameters
Output
Create Purchase Order
Create Purchase Order
QUICKBOOKS_CREATE_PURCHASE_ORDERCreate a new QuickBooks purchase order for a vendor to deliver goods or services.Input Parameters
Output
Create Refund Receipt
Create Refund Receipt
QUICKBOOKS_CREATE_REFUND_RECEIPTTool to create a new refund receipt in QuickBooks Online. Use when a customer receives a refund for returned goods or services.Input Parameters
Output
Create Sales Receipt
Create Sales Receipt
QUICKBOOKS_CREATE_SALES_RECEIPTTool to create a new sales receipt in QuickBooks Online. Use when recording a sale where the customer pays immediately (cash, check, credit card).Input Parameters
Output
Create Tax Agency
Create Tax Agency
Create Tax Code via TaxService
Create Tax Code via TaxService
QUICKBOOKS_CREATE_TAXSERVICE_TAXCODECreate a new tax code with associated tax rates using the TaxService endpoint. Use when you need to set up new tax codes for sales or purchase transactions with specific tax rates.Input Parameters
Output
Create Time Activity
Create Time Activity
QUICKBOOKS_CREATE_TIME_ACTIVITYCreate a new time activity record in QuickBooks Online. TimeActivity tracks employee or vendor time worked on jobs or projects. Use when recording billable or non-billable hours for employees or vendors.Input Parameters
Output
Create Vendor
Create Vendor
QUICKBOOKS_CREATE_VENDORCreate a new vendor in QuickBooks with the given details.Input Parameters
Output
Create Vendor Credit
Create Vendor Credit
QUICKBOOKS_CREATE_VENDOR_CREDITTool to create a new vendor credit in QuickBooks Online. Use when recording a credit from a vendor that reduces what you owe.Input Parameters
Output
Customer Balance Detail
Customer Balance Detail
QUICKBOOKS_CUSTOMER_BALANCE_DETAILGenerate a customer balance detail report in QuickBooks, optionally filtered to one or more customer IDs.Input Parameters
Output
Customer Balance Report
Customer Balance Report
QUICKBOOKS_CUSTOMER_BALANCE_REPORTGenerate a customer balance report in QuickBooks showing outstanding balances for customers. Can filter by specific customers, date ranges, payment status, and accounting method. Returns a hierarchical report with customer names, IDs, and their current balance amounts.Input Parameters
Output
Delete Bank Account
Delete Bank Account
QUICKBOOKS_DELETE_BANK_ACCOUNTDelete a bank account on file for a customer in QuickBooks Payments. When the API returns 204, the tool returns a success confirmation with the customer and bank account IDs.Input Parameters
Output
Delete Item
Delete Item
QUICKBOOKS_DELETE_ITEMDelete an item in QuickBooks Online by marking it as inactive (soft delete). Items cannot be permanently deleted if they have been used in transactions. Use this action when removing items from active catalogs while preserving historical transaction data. The item will be hidden from dropdowns but remain accessible in historical records. This action is irreversible through the API — the item can only be reactivated manually through the QuickBooks UI or by using an update action.Input Parameters
Output
Execute Batch Operation
Execute Batch Operation
QUICKBOOKS_EXECUTE_BATCH_OPERATIONExecute multiple QuickBooks operations in a single request. Operations are performed serially. Supports create, update, delete, and query operations on QuickBooks entities. Use this action to reduce network latency when performing multiple operations. Each operation is executed in order, and each response is correlated to its request via the bId field. Maximum 30 operations per batch. Ideal for bulk data operations or related entity updates.Input Parameters
Output
Aged Receivables Report
Aged Receivables Report
QUICKBOOKS_GET_AGED_RECEIVABLES_REPORTGenerate an aged receivables report showing outstanding customer balances by age. Use when tracking overdue invoices and managing accounts receivable aging.Input Parameters
Output
Get Attachable
Get Attachable
QUICKBOOKS_GET_ATTACHABLETool to read details of a specific attachable by ID in QuickBooks Online. Attachables represent file attachments linked to entities like invoices, customers, or bills.Input Parameters
Output
Get Balance Sheet Report
Get Balance Sheet Report
QUICKBOOKS_GET_BALANCE_SHEET_REPORTGenerate a Balance Sheet report showing company assets, liabilities, and equity at a point in time. Use when you need to understand the financial position with what the company owns versus what it owes.Input Parameters
Output
Get Bank Account
Get Bank Account
Get Bill
Get Bill
QUICKBOOKS_GET_BILLTool to fetch a QuickBooks bill by ID. Use when needing to retrieve bill details including vendor reference, line items, amounts, and payment status.Input Parameters
Output
Get Bill Payment
Get Bill Payment
QUICKBOOKS_GET_BILL_PAYMENTTool to retrieve details of a specific bill payment by ID in QuickBooks Online. Use when you need to view information about an existing bill payment.Input Parameters
Output
Get Changed Entities
Get Changed Entities
QUICKBOOKS_GET_CHANGED_ENTITIESTool to retrieve entities that changed since a specified timestamp using QuickBooks Change Data Capture (CDC) API. Use when you need to sync or refresh local data periodically by fetching only entities modified within the last 30 days. Returns full entity payloads (not just changed attributes) grouped by entity type with up to 1000 entities per response.Input Parameters
Output
Get Company Info
Get Company Info
Get Credit Memo
Get Credit Memo
Get Credit Memo PDF
Get Credit Memo PDF
Get Department
Get Department
Get Deposit
Get Deposit
Get Estimate
Get Estimate
Get Estimate PDF
Get Estimate PDF
Get Exchange Rate
Get Exchange Rate
QUICKBOOKS_GET_EXCHANGE_RATETool to get exchange rate for a specific currency code and date in QuickBooks Online. Use when needing to retrieve the current or historical exchange rate between a foreign currency and the company’s home currency.Input Parameters
Output
Get General Ledger Report
Get General Ledger Report
QUICKBOOKS_GET_GENERAL_LEDGER_REPORTGenerate a General Ledger report showing all transactions with debits, credits, and running balances. Use when you need a detailed view of all accounting transactions posted to each account.Input Parameters
Output
Get Inventory Valuation Summary
Get Inventory Valuation Summary
QUICKBOOKS_GET_INVENTORY_VALUATION_SUMMARYGenerate an Inventory Valuation Summary report showing inventory quantities and their current values. Use when you need to understand inventory asset values, track stock levels, or analyze inventory costs by item.Input Parameters
Output
Get Invoice PDF
Get Invoice PDF
Get Item
Get Item
QUICKBOOKS_GET_ITEMTool to retrieve a specific item by its ID from QuickBooks Online. Use when you need full details of a product or service item.Input Parameters
Output
Get Journal Entry
Get Journal Entry
Get Payment
Get Payment
Get Payment Method
Get Payment Method
Get Payment PDF
Get Payment PDF
Get Company Preferences
Get Company Preferences
QUICKBOOKS_GET_PREFERENCESTool to read company preferences that control application behavior in QuickBooks Online. Use when needing to retrieve accounting settings, sales form configurations, tax preferences, time tracking settings, or other company-wide preference data.Input Parameters
Output
Get Profit and Loss Detail Report
Get Profit and Loss Detail Report
QUICKBOOKS_GET_PROFIT_AND_LOSS_DETAIL_REPORTGenerate a detailed Profit and Loss report showing company income and expenses with transaction-level details. Use when you need to analyze profitability with individual transaction details, customer/vendor breakdowns, and account-level activity.Input Parameters
Output
Get Profit and Loss Report
Get Profit and Loss Report
QUICKBOOKS_GET_PROFIT_AND_LOSS_REPORTGenerate a Profit and Loss report showing company income and expenses over a period. Use when you need to analyze profitability, revenue, costs, and net income for a specific date range.Input Parameters
Output
Get Purchase
Get Purchase
QUICKBOOKS_GET_PURCHASETool to fetch details of a specific purchase by ID in QuickBooks Online. Use when you need to retrieve complete purchase information including line items, payment details, and metadata.Input Parameters
Output
Get Purchase Order
Get Purchase Order
Get Purchase Order PDF
Get Purchase Order PDF
QUICKBOOKS_GET_PURCHASE_ORDER_PDFTool to download a QuickBooks purchase order as a PDF file. Use when you need to retrieve the printable PDF version of a purchase order.Input Parameters
Output
Get Refund Receipt
Get Refund Receipt
Get Refund Receipt PDF
Get Refund Receipt PDF
QUICKBOOKS_GET_REFUND_RECEIPT_PDFTool to download a QuickBooks refund receipt as a PDF file. Use when you need to retrieve the printable PDF version of a refund receipt.Input Parameters
Output
Get Report - Account List
Get Report - Account List
QUICKBOOKS_GET_REPORT_ACCOUNT_LISTRetrieve the AccountList report from QuickBooks showing a list of all accounts. This report displays all account details including name, type, and balance information.Input Parameters
Output
Get Report - Aged Payable Detail
Get Report - Aged Payable Detail
QUICKBOOKS_GET_REPORT_AGED_PAYABLE_DETAILGenerate an aged payable detail report showing aging detail for accounts payable. Use when you need to analyze outstanding vendor bills grouped by aging periods.Input Parameters
Output
Get Report - Aged Payables
Get Report - Aged Payables
QUICKBOOKS_GET_REPORT_AGED_PAYABLESRetrieve an Aged Payables aging summary report from QuickBooks showing outstanding vendor balances grouped by age. Shows amounts owed to vendors categorized by aging periods (e.g., current, 1-30 days, 31-60 days overdue).Input Parameters
Output
Get Report - Aged Receivable Detail
Get Report - Aged Receivable Detail
QUICKBOOKS_GET_REPORT_AGED_RECEIVABLE_DETAILGenerate an aged receivable detail report showing aging detail for accounts receivable. Use when you need to analyze outstanding customer invoices grouped by aging periods.Input Parameters
Output
Get Report - Cash Flow
Get Report - Cash Flow
QUICKBOOKS_GET_REPORT_CASH_FLOWGenerate a cash flow report in QuickBooks showing cash inflows and outflows categorized by operating, investing, and financing activities. Use when you need to analyze cash movement and liquidity over a specified period.Input Parameters
Output
Get Report - Class Sales
Get Report - Class Sales
QUICKBOOKS_GET_REPORT_CLASS_SALESGenerate a ClassSales report in QuickBooks showing sales amounts grouped by class. Use when you need to analyze sales performance by class tracking categories.Input Parameters
Output
Get Report - Customer Income
Get Report - Customer Income
QUICKBOOKS_GET_REPORT_CUSTOMER_INCOMEGenerate a customer income report in QuickBooks showing revenue by customer. Use when you need to analyze income generated from each customer over a specified period.Input Parameters
Output
Get Report - Customer Sales
Get Report - Customer Sales
QUICKBOOKS_GET_REPORT_CUSTOMER_SALESGenerate a customer sales report in QuickBooks showing sales transactions and totals for customers. Can filter by specific customers, date ranges, and accounting method. Returns a hierarchical report with customer names, IDs, and their sales amounts.Input Parameters
Output
Get Report - Department Sales
Get Report - Department Sales
QUICKBOOKS_GET_REPORT_DEPARTMENT_SALESGenerate a department sales report in QuickBooks showing sales data broken down by department. Use when you need to analyze sales performance across different departments within a date range. Note: Department tracking must be enabled in the QuickBooks company file for this report to return data.Input Parameters
Output
Get Report - Item Sales
Get Report - Item Sales
QUICKBOOKS_GET_REPORT_ITEM_SALESGenerate an ItemSales report showing sales data for products and services. Use when you need to analyze sales performance by item including quantity sold, revenue, COGS, and gross margin.Input Parameters
Output
Get Reports
Get Reports
QUICKBOOKS_GET_REPORTSRetrieve QuickBooks reports such as TransactionList, BalanceSheet, ProfitAndLoss, and others. Use when you need to access standardized financial or transaction reports with flexible filtering options.Input Parameters
Output
Get Report - Trial Balance
Get Report - Trial Balance
QUICKBOOKS_GET_REPORT_TRIAL_BALANCEGenerate a Trial Balance report showing account debits, credits, and balances for a specified period. Use when you need to verify that total debits equal total credits across all accounts for accounting reconciliation.Input Parameters
Output
Get Sales Receipt
Get Sales Receipt
Get Sales Receipt PDF
Get Sales Receipt PDF
QUICKBOOKS_GET_SALESRECEIPT_PDFTool to download a QuickBooks sales receipt as a PDF file. Use when you need to retrieve the printable PDF version of a sales receipt.Input Parameters
Output
Get Tax Rate
Get Tax Rate
Get Term
Get Term
Get Time Activity
Get Time Activity
Get Transaction List Report
Get Transaction List Report
QUICKBOOKS_GET_TRANSACTION_LIST_REPORTGet the Transaction List report showing all transactions in the company. Use when you need a comprehensive view of all transactions with flexible filtering by date, customer, vendor, account, or other criteria.Input Parameters
Output
Get Transfer
Get Transfer
QUICKBOOKS_GET_TRANSFERTool to fetch a QuickBooks transfer by ID. Use when needing to retrieve transfer details including from/to account references and transfer amount.Input Parameters
Output
Get Vendor Credit
Get Vendor Credit
QUICKBOOKS_GET_VENDOR_CREDITTool to fetch a QuickBooks vendor credit by ID. Use when needing to retrieve vendor credit details including vendor reference, line items, amounts, and balance status.Input Parameters
Output
Get Vendor Expenses Report
Get Vendor Expenses Report
QUICKBOOKS_GET_VENDOR_EXPENSES_REPORTRetrieve a vendor expenses report from QuickBooks showing expense transactions by vendor. This report displays the total expenses incurred for each vendor, providing a detailed view of vendor-related spending. Filter by specific vendors, date ranges, payment status, and customize with various grouping and sorting options.Input Parameters
Output
List Cards
List Cards
QUICKBOOKS_LIST_CARDSList payment cards on file for a customer in QuickBooks Payments. A 404 response is returned as an empty card list, so an empty list can also mean the customer was not found.Input Parameters
Output
List Departments
List Departments
QUICKBOOKS_LIST_DEPARTMENTSQuery Department entities in QuickBooks using SQL-like syntax. Use when you need to list departments or filter departments by criteria like active status, name patterns, or parent relationships. Supports WHERE clauses, pattern matching (LIKE with %), ORDERBY, and pagination.Input Parameters
Output
List Invoices
List Invoices
QUICKBOOKS_LIST_INVOICESList invoices through the QuickBooks Query endpoint with pagination and selectable fields. By default, the query selects only the invoice ID, sync token, document number, total, balance, and transaction date.Input Parameters
Output
Query Account Entities
Query Account Entities
QUICKBOOKS_QUERY_ACCOUNTQuery Account entities in QuickBooks using SQL-like syntax. IMPORTANT: Queries the Account entity ONLY (chart of accounts). For other entities (Purchase, Invoice, Bill, Payment, etc.), use their respective query actions. NOTE: API returns ALL fields with values regardless of SELECT clause (projections not supported). CRITICAL RESTRICTIONS: Parentheses and OR operator are NOT supported. Use IN operator for multiple values: WHERE AccountType IN (‘Bank’, ‘Credit Card’) Supports: WHERE clauses (=, <, >, LIKE, IN), AND operator, pattern matching (%), ORDER BY, pagination (MAXRESULTS up to 1000, STARTPOSITION), COUNT. Common fields: Id, Name, AccountType, AccountSubType, Classification, Active, FullyQualifiedName, CurrentBalance, AcctNum, Description, SubAccount. Examples: - SELECT * FROM Account WHERE AccountType = ‘Expense’ MAXRESULTS 100 - SELECT * FROM Account WHERE Active = true ORDER BY Name - SELECT * FROM Account WHERE AccountType IN (‘Bank’, ‘Credit Card’)Input Parameters
Output
Query Account Entities
Query Account Entities
QUICKBOOKS_QUERY_ACCOUNTSQuery Account entities in QuickBooks using SQL-like syntax. Use this action when you need to retrieve multiple accounts from the chart of accounts with filtering, sorting, or pagination. IMPORTANT: Queries the Account entity ONLY (chart of accounts). For other entities (Purchase, Invoice, Bill, Payment, etc.), use their respective query actions. NOTE: API returns ALL fields with values regardless of SELECT clause (projections not supported). CRITICAL RESTRICTIONS: Parentheses and OR operator are NOT supported. Use IN operator for multiple values: WHERE AccountType IN (‘Bank’, ‘Credit Card’). Supports: WHERE clauses (=, <, >, LIKE, IN), AND operator, pattern matching (%), ORDER BY, pagination (MAXRESULTS up to 1000, STARTPOSITION), COUNT.Input Parameters
Output
Query Attachable Entities
Query Attachable Entities
QUICKBOOKS_QUERY_ATTACHABLEQuery Attachable entities in QuickBooks using SQL-like syntax. Use when you need to retrieve multiple attachables or search for specific file attachments.Input Parameters
Output
Query Bills
Query Bills
QUICKBOOKS_QUERY_BILLSQuery Bill entities in QuickBooks using SQL-like syntax. Returns bills with vendor information, line items, amounts, due dates, and payment status. Use this action when you need to search or filter bills by criteria such as vendor, date range, balance, or total amount. IMPORTANT: Queries the Bill entity ONLY (vendor bills/payables). For other entities (Invoice, Payment, Account, etc.), use their respective query actions. NOTE: API returns ALL fields with values regardless of SELECT clause (projections not supported). CRITICAL RESTRICTIONS: Parentheses and OR operator are NOT supported. Use IN operator for multiple values: WHERE VendorRef IN (‘1’, ‘2’, ‘3’) Common queryable fields: Id, TxnDate, DueDate, VendorRef, TotalAmt, Balance, DocNumber. NON-QUERYABLE fields: PrivateNote, AccountRef, CurrencyRef, DepartmentRef, ClassRef.Input Parameters
Output
Query Customer Entities
Query Customer Entities
QUICKBOOKS_QUERY_CUSTOMERSQuery Customer entities in QuickBooks using SQL-like syntax. Use this action when you need to find customers by name, email, balance, active status, or other criteria with pagination support. IMPORTANT: Queries the Customer entity ONLY. For other entities use their respective query actions. CRITICAL RESTRICTIONS: Parentheses and OR operator are NOT supported. Use IN for multiple values. Supports: WHERE (=, <, >, LIKE, IN), AND, pattern matching (%), ORDER BY, pagination (MAXRESULTS up to 1000), COUNT.Input Parameters
Output
Query QuickBooks Entities
Query QuickBooks Entities
QUICKBOOKS_QUERY_ENTITIESExecute SQL-like queries on QuickBooks Online entities. Supports all entity types (Customer, Invoice, Bill, Payment, Purchase, Account, etc.) with WHERE clauses, pattern matching, ordering, and pagination. IMPORTANT: Many fields are NOT queryable in WHERE clauses including PrivateNote, AccountRef, CurrencyRef, DepartmentRef, ClassRef, etc. Use queryable fields like Id, TxnDate, PaymentType, DisplayName instead. For non-queryable field filtering, query by date range and filter client-side. See parameter description for full list of queryable vs non-queryable fields. Use entity-specific query tools when available for typed responses.Input Parameters
Output
Query Estimate Entities
Query Estimate Entities
QUICKBOOKS_QUERY_ESTIMATESQuery Estimate entities in QuickBooks using SQL-like syntax. Returns estimates matching specified criteria such as status, customer, date range, or amount. Use this action when you need to search for, filter, or list QuickBooks estimates based on specific conditions. The query syntax supports WHERE clauses, pattern matching with LIKE, ordering, and pagination. IMPORTANT: Queries the Estimate entity ONLY. For other entities (Invoice, Bill, Payment, Account, etc.), use their respective query actions. NOTE: API returns ALL fields with values regardless of SELECT clause (field projections not supported). CRITICAL RESTRICTIONS: Parentheses and OR operator are NOT supported. Use IN operator for multiple values: WHERE CustomerRef IN (‘1’, ‘2’) Common queryable fields: Id, TxnDate, TotalAmt, CustomerRef, DocNumber, TxnStatus, ExpirationDate, EmailStatus, PrintStatus. NON-QUERYABLE fields: PrivateNote, DepartmentRef, ClassRef, CurrencyRef cause QueryValidationError.Input Parameters
Output
Query Invoices
Query Invoices
QUICKBOOKS_QUERY_INVOICESQuery QuickBooks invoices with custom SQL-like filters or customer, transaction-date and payment-status filters, with pagination. A custom query replaces the convenience filters; the overdue status filter checks only for a positive balance, so add a due-date condition to identify overdue invoices.Input Parameters
Output
Query Item Entities
Query Item Entities
QUICKBOOKS_QUERY_ITEMSQuery Item entities in QuickBooks using SQL-like syntax. Use this action to search, filter, and retrieve products and services from the QuickBooks catalog. IMPORTANT: Queries Item entity ONLY. For other entities use their respective query actions. Parentheses and OR operator NOT supported - use IN instead. Reference fields NOT queryable - filter client-side if needed.Input Parameters
Output
Query Payment Entities
Query Payment Entities
QUICKBOOKS_QUERY_PAYMENTSQuery Payment entities in QuickBooks using SQL-like syntax. Use when searching, filtering, or listing payments by date, customer, amount, or other attributes. For a single payment by ID, use GetPayment instead.Input Parameters
Output
Query Vendor Entities
Query Vendor Entities
QUICKBOOKS_QUERY_VENDORSQuery Vendor entities in QuickBooks using SQL-like syntax. Returns vendors matching the specified criteria with full details. Use this action when you need to search, filter, or list vendors based on conditions such as active status, display name, balance, or 1099 eligibility. Supports pagination for large result sets. IMPORTANT: Queries the Vendor entity ONLY. For other entities use their respective query actions. Parentheses and OR operator are NOT supported - use IN operator instead.Input Parameters
Output
Read Account
Read Account
Read Class
Read Class
Read Customer
Read Customer
Read Employee
Read Employee
Read Invoice
Read Invoice
Read Vendor
Read Vendor
Send Credit Memo
Send Credit Memo
QUICKBOOKS_SEND_CREDIT_MEMOTool to send a credit memo to a specified email address. Use when you need to email a credit memo to a customer.Input Parameters
Output
Update Attachable
Update Attachable
QUICKBOOKS_UPDATE_ATTACHABLETool to update an existing attachable in QuickBooks Online. Use when you need to modify attachable properties like note text or entity references. Requires the attachable Id and current SyncToken for optimistic locking.Input Parameters
Output
Update Company Info
Update Company Info
QUICKBOOKS_UPDATE_COMPANY_INFOTool to update company information in QuickBooks Online. Use when you need to update company details like name, address, or contact information. Requires Id and SyncToken from a previous read operation.Input Parameters
Output
Update Department
Update Department
QUICKBOOKS_UPDATE_DEPARTMENTTool to update an existing department in QuickBooks Online. Use when you need to modify department details. Requires the department Id and current SyncToken to prevent concurrent update conflicts.Input Parameters
Output
Update Full Invoice
Update Full Invoice
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.Input Parameters
Output
Update Payment Method
Update Payment Method
QUICKBOOKS_UPDATE_PAYMENT_METHODUpdate an existing QuickBooks Online payment method using its ID, current SyncToken, and name. The request is a full update; active defaults to true if omitted, and the type can also be supplied.Input Parameters
Output
Update Preferences
Update Preferences
QUICKBOOKS_UPDATE_PREFERENCESUpdate company preferences in QuickBooks Online. Requires Id and SyncToken from a previous read. Use sparse=true for partial updates (only specified fields are changed) or sparse=false/omitted for full replacement.Input Parameters
Output
Update Sparse Invoice
Update Sparse Invoice
Update Term
Update Term
QUICKBOOKS_UPDATE_TERMUpdate an existing QuickBooks Online payment term, including its name, status, type or payment conditions. Requires the term ID, current SyncToken, name and type; the request is a full update.Input Parameters
Output
Update Transfer
Update Transfer
QUICKBOOKS_UPDATE_TRANSFERTool to update an existing transfer in QuickBooks Online. Use when you need to modify a transfer between accounts. Requires the transfer Id and current SyncToken to prevent concurrent update conflicts.Input Parameters
Output
Vendor Balance Detail
Vendor Balance Detail
QUICKBOOKS_VENDOR_BALANCE_DETAILRetrieve a QuickBooks vendor balance detail report, optionally filtered to one or more vendor IDs.Input Parameters
Output
Vendor Balance Report
Vendor Balance Report
QUICKBOOKS_VENDOR_BALANCE_REPORTRetrieve a QuickBooks vendor balance report summarizing accounts payable by vendor. Filter by vendor, payment status, report date or date macro, and customize column summarization and sort order.