Quickbooks
Your Toolhouse AI Worker can connect to Quickbooks using 105 specialized tools.
Auth Connection
This service requires an auth connection to use its tools. You can set this up in your Toolhouse dashboard under Auth Connections.
Tools (105)
Quickbooks Capture Charge
Quickbooks Capture ChargeIntegration name: QUICKBOOKS_CAPTURE_CHARGE
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
amount
string
"10.00"
The amount to capture. If not provided, captures the full authorized amount. For partial captures, specify the amount as a decimal string (e.g., '10.55', '25.00'). The amount must not exceed the authorized amount.
context
object
—
Additional context information for the capture. This is an optional field that can contain merchant-specific metadata or transaction context.
charge_id
string
✅
"EMU123456789"
The ID of the charge to capture. This is the unique identifier for the authorized charge in QuickBooks Payments (e.g., 'EMU123456789', 'ECH123456789'). Use this to capture funds from a charge that was previously authorized but not captured.
Quickbooks Create Account
Quickbooks Create AccountIntegration name: QUICKBOOKS_CREATE_ACCOUNT
Create a new account in QuickBooks with the given parameters.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
name
string
✅
—
User recognizable name for the Account. Account.Name attribute must not contain double quotes (") or colon (:).
active
boolean
—
Whether or not the account is active. Inactive accounts may be hidden from display and cannot be posted to. Default is true if not specified.
parent_ref
object
—
Reference to another entity.
description
string
—
User-entered description for the account. May include information to guide bookkeepers in deciding what to post to the account. Maximum length is 100 characters for QuickBooks Online, 200 characters for QuickBooks Desktop.
sub_account
boolean
—
Specifies whether this is a subaccount. Set to true to create a subaccount. Must also provide parent_ref when true.
account_type
string
✅
—
Type of the account to be created. Required field. Valid values: 'Bank', 'Other Current Asset', 'Fixed Asset', 'Other Asset', 'Accounts Receivable', 'Equity', 'Expense', 'Other Expense', 'Cost of Goods Sold', 'Accounts Payable', 'Credit Card', 'Long Term Liability', 'Other Current Liability', 'Income', 'Other Income'.
currency_ref
object
—
Reference to another entity.
account_number
string
—
User-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 locales:
opening_balance
number
—
Opening balance amount when creating a new Balance Sheet account. Used only at account creation for accounts like Bank, Credit Card, etc.
account_sub_type
—
"AdvertisingPromotional"
Sub-type of the account. Must use exact enum values (no spaces/slashes). Examples: 'AdvertisingPromotional' (NOT 'Advertising/Promotional'), 'Checking', 'Inventory', 'OtherCurrentAssets', 'Vehicles', 'RetainedEarnings', 'Insurance', 'InterestEarned'. See QuickBooks API docs for complete list.
opening_balance_date
string
—
Date of the opening balance. Format: YYYY-MM-DD. Required if opening_balance is provided.
Quickbooks Create Bank Account
Quickbooks Create Bank AccountIntegration name: QUICKBOOKS_CREATE_BANK_ACCOUNT
Create 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
name
string
✅
"John Doe"
Account holder name (full name of the person or business).
phone
string
"555-123-4567"
Phone number associated with the bank account holder.
customer_id
string
✅
"test-customer-id"
The customer ID for whom to create the bank account.
account_type
string
✅
—
Type of bank account. Must be one of: PERSONAL_CHECKING, PERSONAL_SAVINGS, BUSINESS_CHECKING, or BUSINESS_SAVINGS.
account_number
string
✅
"1234567890"
Bank account number.
routing_number
string
✅
"021000021"
Bank routing number (must be valid and pass checksum validation). Use a valid 9-digit ABA routing number.
Quickbooks Create Bill
Quickbooks Create BillIntegration name: QUICKBOOKS_CREATE_BILL
Create 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of line items for the bill. At least one line item is required. Each line must specify DetailType, Amount, and the appropriate detail object.
DueDate
string
—
Date when payment for the bill is due in YYYY-MM-DD format.
TxnDate
string
—
Date of the transaction in YYYY-MM-DD format. Defaults to the current date if not provided.
DocNumber
string
—
Reference number for the bill (e.g., vendor invoice number).
VendorRef
object
✅
—
Reference to the vendor from whom the bill is received. Required field.
CurrencyRef
object
—
Reference to the currency. Format: {'value': 'USD'}.
PrivateNote
string
—
User-entered private note about the bill.
APAccountRef
object
—
Reference to the Accounts Payable account. Format: {'value': 'account_id'}. If not specified, uses the default AP account.
ExchangeRate
number
—
Currency exchange rate for multi-currency transactions.
SalesTermRef
object
—
Reference to the payment terms. Format: {'value': 'term_id'}. Defines when payment is due.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default version.
DepartmentRef
object
—
Reference to the department. Format: {'value': 'department_id'}.
GlobalTaxCalculation
string
—
Method in which tax is applied. Valid values: TaxExcluded, TaxInclusive, NotApplicable.
Quickbooks Create Bill Payment
Quickbooks Create Bill PaymentIntegration name: QUICKBOOKS_CREATE_BILL_PAYMENT
Create a bill payment in QuickBooks to record payment against one or more bills. Use when paying vendor bills via check or credit card.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of line items indicating which bills are being paid and the amounts applied to each.
PayType
string
✅
—
Payment method type. Must be either 'Check' or 'CreditCard'.
TxnDate
string
—
Date of the transaction in YYYY-MM-DD format. Defaults to current date if not specified.
TotalAmt
number
✅
—
Total amount of the bill payment. Must be positive and match the sum of all line amounts.
VendorRef
object
✅
—
Reference to the vendor receiving the payment.
PrivateNote
string
—
Private note for internal use, not visible to the vendor. Maximum 4000 characters.
CheckPayment
object
—
Check payment details for bill payment.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default from headers.
DepartmentRef
object
—
Reference to the department for location/department tracking. Must be a dict with 'value' key.
CreditCardPayment
object
—
Credit card payment details for bill payment.
Quickbooks Create Class
Quickbooks Create ClassIntegration name: QUICKBOOKS_CREATE_CLASS
Create a new class in QuickBooks Online. Use when you need to categorize transactions by department, location, or other business segments.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
name
string
✅
"Department Sales"
The name of the class. Must be unique and cannot contain a colon (:).
Active
boolean
—
Whether the class is active. Inactive classes are hidden from most display areas. Default is true.
SubClass
boolean
—
Whether this is a subclass. If true, ParentRef must be provided.
ParentRef
object
—
Reference to another entity.
Quickbooks Create Credit Memo
Quickbooks Create Credit MemoIntegration name: QUICKBOOKS_CREATE_CREDIT_MEMO
Tool to create a new credit memo in QuickBooks Online. Use when issuing credit to a customer for returns, refunds, or adjustments.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
line
array
✅
—
Array of line items for the credit memo. At least one line item is required.
txn_date
string
"2024-01-15"
Transaction date in YYYY-MM-DD format. Defaults to current date if not provided.
bill_addr
object
—
Physical address structure.
class_ref
object
—
Reference to the class for categorization. Format: {'value': 'class_id'}.
ship_addr
object
—
Physical address structure.
ship_date
string
"2024-01-15"
Shipping date in YYYY-MM-DD format.
bill_email
string
—
Email address to send the credit memo to. Must be a valid email format.
doc_number
string
—
Reference number for the credit memo (maximum 21 characters).
currency_ref
object
—
Reference to currency.
custom_field
array
—
Array of custom fields for the credit memo.
customer_ref
object
✅
—
Reference to the customer receiving the credit memo. Required field.
email_status
string
"NotSet"
Email status of the credit memo. Valid values: 'NotSet', 'NeedToSend', 'EmailSent'.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default version from headers.
print_status
string
"NotSet"
Print status of the credit memo. Valid values: 'NotSet', 'NeedToPrint', 'PrintComplete'.
private_note
string
—
Private note about the credit memo, not visible to the customer.
customer_memo
string
—
Message to the customer that appears on the credit memo. Maximum 1000 characters.
exchange_rate
number
—
Exchange rate for currency conversion.
department_ref
object
—
Reference to the department associated with the credit memo. Format: {'value': 'department_id'}.
sales_term_ref
object
—
Reference to the sales term. Format: {'value': 'term_id'}.
ship_method_ref
object
—
Reference to the shipping method. Format: {'value': 'ship_method_id'}.
global_tax_calculation
string
"TaxExcluded"
Method in which tax is applied. Valid values: 'TaxExcluded', 'TaxInclusive', 'NotApplicable'.
apply_tax_after_discount
boolean
—
Whether to apply tax after discount. Defaults to false.
Quickbooks Create Customer
Quickbooks Create CustomerIntegration name: QUICKBOOKS_CREATE_CUSTOMER
Create a new customer in QuickBooks with the given parameters.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Fax
object
—
Fax number of the customer.
Job
boolean
—
Whether this customer record represents a job. Default is false.
Notes
string
—
Free-form notes or comments about the customer.
title
string
"Mr."
Title 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, FamilyName, or Suffix attributes are required during create.
Active
boolean
—
Whether the customer is currently active. Default is true.
Mobile
object
—
Mobile phone number of the customer.
suffix
string
—
Suffix 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.
Balance
number
—
Opening balance amount for this customer at the OpenBalanceDate.
Taxable
boolean
—
Whether the customer is taxable. Default is true.
WebAddr
object
—
Website address (URI) of the customer.
BillAddr
object
—
Billing address of the customer.
ShipAddr
object
—
Shipping address of the customer.
ParentRef
object
—
Reference to the immediate parent customer for sub-customers.
ResaleNum
string
—
Resale number or tax-exempt number for the customer.
given_name
string
—
Given 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.
CompanyName
string
—
Company name associated with the customer.
CurrencyRef
object
—
Reference to the currency used for transactions with this customer (e.g., {'value': 'USD'}).
family_name
string
—
Family 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.
middle_name
string
—
Middle 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 object create.
PrimaryPhone
object
—
Primary phone number of the customer.
display_name
string
—
The 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 customer name components supplied in the request from the following list: Title, GivenName, MiddleName, FamilyName, and Suffix.
AlternatePhone
object
—
Alternate phone number of the customer.
BillWithParent
boolean
—
Whether this sub-customer should be billed with its parent customer. Default is false.
OpenBalanceDate
string
—
Date of the opening balance for the customer in YYYY-MM-DD format.
PrimaryEmailAddr
object
—
Primary email address of the customer.
PrintOnCheckName
string
—
Name to be printed on checks issued to this customer. If not provided, DisplayName is used.
PreferredDeliveryMethod
string
—
Preferred delivery method for invoices and communications.
Quickbooks Create Deposit
Quickbooks Create DepositIntegration name: QUICKBOOKS_CREATE_DEPOSIT
Creates 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
line
array
✅
—
List of deposit line items. Each line item represents funds being deposited. At least one line is required. Each line must include: (1) 'Amount' as a positive number, (2) 'DetailType' set to 'DepositLineDetail', (3) 'DepositLineDetail' with 'AccountRef' containing the source account ID. Example: [{'Amount': 100.00, 'DetailType': 'DepositLineDetail', 'DepositLineDetail': {'AccountRef': {'value': '87'}}}]
txn_date
string
—
Transaction date for the deposit in YYYY-MM-DD format (e.g., '2026-02-23'). If not provided, the current date will be used.
currency_ref
object
—
Reference to a currency.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). If not specified, uses the default API version.
private_note
string
—
Private note about the deposit (internal use only).
exchange_rate
—
—
Exchange rate for multi-currency transactions. Default is 1 for home currency.
department_ref
object
—
Reference to a department.
deposit_to_account_ref
object
✅
—
Reference to the asset account (bank account) where the deposit will be made. Must be a valid bank account ID. Example: {'value': '35'} for account ID 35. Use QUICKBOOKS_QUERY_ACCOUNT or QUICKBOOKS_READ_ACCOUNT to get valid account IDs.
Quickbooks Create Echeck Payment
Quickbooks Create Echeck PaymentIntegration name: QUICKBOOKS_CREATE_ECHECK_PAYMENT
Tool to create an eCheck payment using ACH bank transfer in QuickBooks Payments API. Use when processing payments from customer bank accounts via electronic check. The payment is debited directly from the customer's bank account using the provided routing and account numbers.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
amount
string
✅
—
Payment amount as a string (e.g., '10.55', '100.00'). Must be a positive number with up to 2 decimal places.
context
object
—
Transaction context information.
currency
string
✅
—
Currency code for the payment (e.g., 'USD'). Currently only USD is supported by QuickBooks Payments.
bankAccount
object
✅
—
Bank account details from which the eCheck payment will be debited. Includes account number, routing number, account type, name, and phone.
Quickbooks Create Employee
Quickbooks Create EmployeeIntegration name: QUICKBOOKS_CREATE_EMPLOYEE
Create a new employee in QuickBooks.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
fax
object
—
Fax number of the employee.
ssn
string
—
Social Security Number. Maximum 15 characters for QuickBooks Online, 1024 characters for QuickBooks Desktop.
title
string
—
Title or honorific of the employee.
active
boolean
—
Indicates whether the entity is enabled. Default is true. Employees are deactivated (active=false) rather than deleted.
gender
string
—
Gender of the employee.
mobile
object
—
Mobile phone number of the employee.
suffix
string
—
Name suffix of the employee. QuickBooks Online only. Maximum 15 characters.
web_addr
object
—
Website address or URI associated with the employee.
bill_rate
number
—
Hourly billing rate for the employee. QuickBooks Online only.
cost_rate
number
—
Cost rate associated with the employee.
birth_date
string
—
Birth date of the employee, in YYYY-MM-DD format.
given_name
string
✅
—
Given name (first name) of the employee. Required field. Maximum 100 characters.
hired_date
string
—
Date the employee was hired, in YYYY-MM-DD format.
other_addr
object
—
Other physical address(es) of the employee.
family_name
string
✅
—
Family name (last name) of the employee. Required field. Maximum 100 characters.
middle_name
string
—
Middle name(s) of the employee. Maximum 5-15 characters depending on product.
company_name
string
—
Company name associated with the employee.
custom_field
array
—
Array of custom fields associated with the employee.
display_name
string
—
Display name of the employee. Must be unique across all customer, employee, and vendor objects. Populated from FullName if not provided. Must not contain colon, tab, or newline characters.
organization
boolean
—
Internal flag for organizational structure.
primary_addr
object
—
Physical street address for this employee. If QuickBooks Payroll is enabled for the company, the following address fields are required: city, country_sub_division_code, and postal_code.
billable_time
boolean
—
Indicates whether employee time is billable. QuickBooks Online only.
employee_type
string
—
Employee type classification.
primary_phone
object
—
Primary phone number of the employee.
released_date
string
—
Date the employee left the company, in YYYY-MM-DD format.
use_time_entry
boolean
—
Indicates whether time sheets create paychecks for this employee.
alternate_phone
object
—
Alternate phone number of the employee.
employee_number
string
—
Employee directory number. Maximum 15 for QuickBooks Online, 99 for QuickBooks Desktop.
other_contact_info
array
—
List of additional contact information entities.
primary_email_addr
object
—
Primary email address of the employee.
print_on_check_name
string
—
Name as it should appear on printed checks.
default_tax_code_ref
object
—
Reference to the default tax code associated with the employee.
Quickbooks Create Estimate
Quickbooks Create EstimateIntegration name: QUICKBOOKS_CREATE_ESTIMATE
Creates 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
lines
array
✅
—
List of estimate line items. Each line item must include DetailType, Amount, and appropriate detail object (e.g., SalesItemLineDetail for item-based lines).
txn_date
string
—
Date of the estimate transaction in YYYY-MM-DD format (e.g., '2024-01-15'). If not specified, the current date is used.
bill_addr
object
—
Physical address structure.
class_ref
object
—
Reference to a class for categorization.
ship_addr
object
—
Physical address structure.
ship_date
string
—
Date for delivery of goods or services in YYYY-MM-DD format (e.g., '2024-03-15').
bill_email
string
—
Email address where the estimate should be sent.
doc_number
string
—
Reference number for the estimate. If not specified, QuickBooks generates one automatically.
customer_id
string
✅
—
ID of the customer for whom the estimate is created. This is the unique identifier for the customer in QuickBooks (e.g., '1', '3'). Use QUICKBOOKS_READ_CUSTOMER or QUICKBOOKS_CREATE_CUSTOMER to get valid customer IDs.
currency_ref
object
—
Reference to a currency.
custom_field
array
—
Custom fields for the estimate. QuickBooks Online supports up to 3 custom fields. The custom fields must already exist in QuickBooks.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). If not specified, uses the default API version from headers.
private_note
string
—
User-entered private note about the estimate, not visible to the customer. Maximum 4000 characters.
tracking_num
string
—
Shipping provider's tracking number for the delivery of goods. Maximum 31 characters.
customer_memo
string
—
Message to the customer that appears on the estimate.
exchange_rate
number
—
The exchange rate for the transaction. Applicable if multi-currency is enabled. Defaults to 1.
department_ref
object
—
Reference to a department.
sales_term_ref
object
—
Reference to sales terms.
expiration_date
string
—
Date by which the estimate must be accepted in YYYY-MM-DD format (e.g., '2024-02-28').
ship_method_ref
object
—
Reference to a shipping method.
global_tax_calculation
string
—
Method in which tax is applied. Valid values: TaxExcluded, TaxInclusive, NotApplicable. Default is TaxExcluded.
apply_tax_after_discount
boolean
—
If true, tax is applied after discount. If false or null, calculate sales tax first then apply discount. US QuickBooks companies only. Defaults to false.
Quickbooks Create Invoice
Quickbooks Create InvoiceIntegration name: QUICKBOOKS_CREATE_INVOICE
Creates 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
fob
string
—
Free On Board (FOB) designation for shipping terms. Defines when ownership and liability transfer from seller to buyer.
lines
array
✅
—
List of invoice line items. Each line item must be a dictionary with: (1) 'DetailType' set to 'SalesItemLineDetail', (2) 'Amount' as a number representing the line total, (3) 'SalesItemLineDetail' as a dictionary containing 'ItemRef' with a 'value' key for the item ID (e.g., {'ItemRef': {'value': '1'}}). Optional fields include 'Description' (text), 'Qty' (quantity as number), and 'UnitPrice' (price per unit as number). Example: [{'DetailType': 'SalesItemLineDetail', 'Amount': 100.00, 'SalesItemLineDetail': {'ItemRef': {'value': '1'}, 'Qty': 2, 'UnitPrice': 50.00}}]
due_date
string
—
Date when payment for the invoice is due in YYYY-MM-DD format (e.g., '2026-03-25'). Calculated from TxnDate and SalesTermRef if not explicitly provided.
txn_date
string
—
Date when the transaction occurred in YYYY-MM-DD format (e.g., '2026-02-25'). This is the posting date that affects financial statements. If not supplied, the current server date is used.
bill_addr
object
—
Bill-to address of the invoice. Provide as a dictionary with keys like 'Line1', 'City', 'CountrySubDivisionCode', 'PostalCode'. If not provided, defaults to the customer's billing address.
class_ref
object
—
Reference to the class associated with the transaction for categorization and reporting. Provide as a dictionary with 'value' key for the class ID (e.g., {'value': '5'}).
po_number
string
—
Purchase order number provided by the customer. Maximum 25 characters (QuickBooks Windows) or 15 characters (QuickBooks Online).
requestid
string
—
Optional idempotency key (maximum 50 characters) to prevent duplicate writes on retries. If provided, QuickBooks will not create a duplicate invoice if the same requestid is used again.
ship_addr
object
—
Shipping address for the invoice. Provide as a dictionary with keys like 'Line1', 'City', 'CountrySubDivisionCode', 'PostalCode'. If not provided, defaults to the customer's shipping address.
ship_date
string
—
Date when the product was shipped or service was performed in YYYY-MM-DD format (e.g., '2026-02-25').
bill_email
object
—
Email address where the invoice should be sent. Provide as a dictionary with 'Address' key (e.g., {'Address': 'customer@example.com'}).
doc_number
string
—
Reference number for the transaction. Maximum 21 characters for QuickBooks Online. If not provided, QuickBooks auto-generates this by incrementing the last number.
customer_id
string
✅
—
ID of the customer to invoice. This is the unique identifier for the customer in QuickBooks (e.g., '1', '92'). Use QUICKBOOKS_CREATE_CUSTOMER or QUICKBOOKS_READ_CUSTOMER to get valid customer IDs. Customer must be active; inactive customer IDs will cause invoice creation to fail. Similarly, all ItemRef values in lines must reference active items/services.
project_ref
object
—
Reference to the project associated with the invoice. Provide as a dictionary with 'value' key for the project ID (e.g., {'value': '10'}).
currency_ref
object
—
Reference to the currency in which all amounts on the invoice are expressed. Provide as a dictionary with 'value' key for the currency code (e.g., {'value': 'USD'}).
custom_field
array
—
Array of custom fields for the invoice. QuickBooks Online supports up to 3 custom fields. Each field should be a dictionary with 'DefinitionId', 'Name', 'Type', and value keys (e.g., [{'DefinitionId': '1', 'Name': 'Field1', 'Type': 'StringType', 'StringValue': 'Value1'}]).
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version.
private_note
string
—
User-entered, organization-private note about the transaction that will not appear on customer-facing records. Maximum 4000 characters.
template_ref
object
—
Reference to the template used for formatting the invoice. Provide as a dictionary with 'value' key for the template ID (e.g., {'value': '5'}).
tracking_num
string
—
Shipping provider's tracking number for the delivery. Maximum 31 characters.
bill_email_cc
object
—
CC email address for the invoice. Provide as a dictionary with 'Address' key (e.g., {'Address': 'cc@example.com'}).
customer_memo
object
—
User-entered message to the customer that appears on the invoice. Provide as a dictionary with 'value' key (e.g., {'value': 'Thank you for your business'}). Maximum 1000 characters.
exchange_rate
number
—
Currency exchange rate for multi-currency environments. Exchange rates are always recorded as the number of home currency units per one foreign currency unit.
bill_email_bcc
object
—
BCC email address for the invoice. Provide as a dictionary with 'Address' key (e.g., {'Address': 'bcc@example.com'}).
department_ref
object
—
Reference to the department for location tracking (QuickBooks Online). Provide as a dictionary with 'value' key for the department ID (e.g., {'value': '1'}).
sales_term_ref
object
—
Reference to the sales terms (payment terms) that determine the invoice due date. Provide as a dictionary with 'value' key for the term ID (e.g., {'value': '3'}).
ship_from_addr
object
—
Ship-from address for the invoice. Provide as a dictionary with keys like 'Line1', 'City', 'CountrySubDivisionCode', 'PostalCode'.
txn_tax_detail
object
—
Details of taxes charged on the transaction as a whole. Provide as a dictionary with 'TxnTaxCodeRef' and/or 'TaxLine' keys. QuickBooks automatically calculates this based on tax codes if not provided.
ship_method_ref
object
—
Reference to the shipping method. Provide as a dictionary with 'value' key for the shipping method ID (e.g., {'value': '2'}).
allow_ipn_payment
boolean
—
Specifies whether customer is allowed to use IPN (Instant Payment Notification) to pay the invoice.
allow_online_payment
boolean
—
Specifies whether customer is allowed to use eInvoicing (online payment) to pay the invoice.
deposit_to_account_ref
object
—
Reference to the asset account where payment deposits are recorded. Provide as a dictionary with 'value' key for the account ID (e.g., {'value': '35'}).
global_tax_calculation
string
—
Method used to apply taxes. Valid values: 'TaxExcluded', 'TaxInclusive', 'NotApplicable'. Default is 'TaxExcluded'.
allow_online_ach_payment
boolean
—
Permits customers to pay via electronic bank transfers (ACH) through eInvoicing.
apply_tax_after_discount
boolean
—
If false or null, calculate sales tax first then apply discount. If true, apply discount first then calculate tax. US QuickBooks companies only.
allow_online_credit_card_payment
boolean
—
Permits customers to pay via credit cards through eInvoicing.
Quickbooks Create Item
Quickbooks Create ItemIntegration name: QUICKBOOKS_CREATE_ITEM
Create 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
name
string
✅
"Composio Test Service"
User-recognizable name for the item. This is the name displayed in lists and forms in QuickBooks.
type
string
✅
—
Classification specifying the use of this item. Valid values: 'Service' (services offered for sale), 'Inventory' (products bought and sold with quantity tracking - requires QuickBooks Online Plus or Advanced), 'NonInventory' (products bought and sold without quantity tracking), 'Category' (used to group items together), 'Bundle' (combination of products/services sold together). Different types have different required fields.
active
boolean
—
Whether the item is active and available for use. Default is true.
taxable
boolean
—
Whether sales of this item are subject to sales tax. Default is false.
parent_ref
object
—
Reference to another entity.
unit_price
number
—
Unit price of the item for sales. This is the default selling price per unit.
description
string
—
Description of the item that appears on sales forms such as invoices. This helps customers understand what they are purchasing.
qty_on_hand
number
10
Current quantity on hand for this inventory item. REQUIRED if TrackQtyOnHand is true. Must be a non-negative number.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version.
purchase_cost
number
—
Cost to purchase this item from vendors. This is the default purchase cost per unit.
purchase_desc
string
—
Description of the item for purchase forms. This is the description used when purchasing the item from vendors.
inv_start_date
string
"2026-01-01"
Date when inventory tracking begins for this item. Format: YYYY-MM-DD. REQUIRED if TrackQtyOnHand is true.
asset_account_ref
object
{"name":"Inventory Asset","value":"81"}
Reference to another entity.
track_qty_on_hand
boolean
—
Whether quantity on hand is tracked for this item. If true, you must provide QtyOnHand and InvStartDate. Applicable for Inventory items.
income_account_ref
object
{"name":"Sales of Product Income","value":"9"}
Reference to another entity.
expense_account_ref
object
{"name":"Cost of Goods Sold","value":"80"}
Reference to another entity.
Quickbooks Create Journal Entry
Quickbooks Create Journal EntryIntegration name: QUICKBOOKS_CREATE_JOURNAL_ENTRY
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of journal entry lines. Each journal entry must have at least two lines, and the total debits must equal the total credits. Typically includes at least one debit line and one credit line with matching amounts.
TxnDate
string
—
Transaction date for the journal entry in YYYY-MM-DD format. If not provided, the current date is used.
DocNumber
string
—
Reference number for the journal entry. Maximum 21 characters.
Adjustment
boolean
—
Indicates if this is an adjustment journal entry. Set to true for adjusting entries.
CurrencyRef
object
—
Reference to an entity.
PrivateNote
string
—
Private note about the journal entry. Maximum 4000 characters.
ExchangeRate
number
—
Exchange rate for multi-currency journal entries.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version.
Quickbooks Create Payment
Quickbooks Create PaymentIntegration name: QUICKBOOKS_CREATE_PAYMENT
Creates 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
lines
array
✅
—
List of payment line items specifying which invoices or credit memos the payment is applied to. Each line item must contain Amount and LinkedTxn fields. Example: [{'Amount': 50.0, 'LinkedTxn': [{'TxnId': '11', 'TxnType': 'Invoice'}]}]
txn_date
string
—
Date of the payment transaction in YYYY-MM-DD format (e.g., '2024-01-15'). If not specified, the current date is used.
total_amt
number
✅
—
Total amount of the payment. This should equal the sum of all Line item amounts. Must be a positive number (e.g., 50.0, 100.0).
customer_id
string
✅
—
ID of the customer making the payment. This is the unique identifier for the customer in QuickBooks (e.g., '3', '58'). Use QUICKBOOKS_CREATE_CUSTOMER or QUICKBOOKS_READ_CUSTOMER to get valid customer IDs.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version.
private_note
string
—
Private note about the payment. Not visible to the customer. Maximum 4000 characters.
customer_name
string
—
Name of the customer. Optional field that helps with readability but not required by the API.
exchange_rate
number
—
Exchange rate for the transaction when using multi-currency. Applicable only if multi-currency is enabled. Optional field.
payment_ref_num
string
—
Reference number for the payment, such as a check number or transaction ID. Optional field.
process_payment
boolean
—
Indicates whether the payment should be processed through QuickBooks Payments. Set to true to process the payment, false otherwise. Optional field.
ar_account_ref_id
string
—
ID of the accounts receivable account. Optional field. Use QuickBooks query API to get valid AR account IDs.
currency_ref_value
string
—
Currency code for multi-currency environments (e.g., 'USD', 'CAD', 'EUR'). Required if the company file uses multi-currency. Optional otherwise.
credit_card_payment
object
—
Credit card payment details when payment method is credit card.
payment_method_ref_id
string
—
ID of the payment method used (e.g., '1' for Cash, '2' for Check). Optional field. Use QuickBooks query API to get valid payment method IDs.
deposit_to_account_ref_id
string
—
ID of the asset account where this payment should be deposited. Optional field. If not provided, uses the default Undeposited Funds account.
Quickbooks Create Purchase
Quickbooks Create PurchaseIntegration name: QUICKBOOKS_CREATE_PURCHASE
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of line items for the purchase. At least one line item is required. Each line must have an Amount and DetailType with corresponding detail object.
TxnDate
string
—
Date of the transaction in YYYY-MM-DD format (e.g., '2024-08-23'). If not provided, uses the current date.
TotalAmt
number
—
Total amount of the purchase including all line items. If not provided, QuickBooks will calculate it from the line items. Should match the sum of all line amounts.
DocNumber
string
—
Reference number for the purchase (e.g., check number). Maximum 21 characters.
EntityRef
object
—
Reference to an entity (vendor, customer, employee).
AccountRef
object
✅
—
Reference to the account from which the payment is made (e.g., {'value': '19'} for a checking account or {'value': '42'} for a credit card account).
CurrencyRef
object
—
Reference to a currency.
PaymentType
string
✅
—
Payment method used for this purchase. Choose 'Cash', 'Check', or 'CreditCard'.
PrivateNote
string
—
Private note about the purchase, visible only to company users. Maximum 4000 characters.
ExchangeRate
number
—
Exchange rate for multi-currency transactions. Required if CurrencyRef is different from home currency.
minorversion
integer
—
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). If not specified, uses the default API version from headers.
DepartmentRef
object
—
Reference to an account.
PaymentMethodRef
object
—
Reference to an entity (vendor, customer, employee).
GlobalTaxCalculation
string
—
Method used to apply tax on the transaction. Valid values: 'TaxExcluded', 'TaxInclusive', 'NotApplicable'.
TransactionLocationType
string
—
The location type of the transaction. Used for international tax calculations.
Quickbooks Create Purchase Order
Quickbooks Create Purchase OrderIntegration name: QUICKBOOKS_CREATE_PURCHASE_ORDER
Create a new purchase order in QuickBooks. Use when you need to send a request to a vendor to deliver goods or services.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
fob
string
—
Free On Board shipping terms indicating point of transfer of ownership.
memo
string
—
Memo or note about the purchase order visible on reports and to the vendor.
lines
array
✅
—
List of line items for the purchase order. Each line must have an 'amount' (number), 'detail_type' ('ItemBasedExpenseLineDetail' or 'AccountBasedExpenseLineDetail'), and corresponding detail object. For item-based lines, include 'item_based_expense_line_detail' with an 'item_ref'. For account-based lines, include 'account_based_expense_line_detail' with an 'account_ref'.
due_date
string
—
Date when payment for the purchase order is due in YYYY-MM-DD format.
po_email
object
—
Email address structure.
txn_date
string
—
Transaction date of the purchase order in YYYY-MM-DD format. Defaults to the current date if not provided.
class_ref
object
—
Reference to another entity.
ship_addr
object
—
Physical address structure.
total_amt
number
✅
—
Total amount of the purchase order. Should equal the sum of all line amounts.
vendor_id
string
✅
—
ID of the vendor for this purchase order. Use QUICKBOOKS_CREATE_VENDOR or QUICKBOOKS_READ_VENDOR to get valid vendor IDs.
doc_number
string
—
Reference number for the purchase order. If not provided, QuickBooks will auto-generate it.
vendor_addr
object
—
Physical address structure.
currency_ref
object
—
Reference to another entity.
custom_field
array
—
Custom fields for the purchase order.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default API version.
private_note
string
—
Private note about the purchase order, not visible to the vendor.
template_ref
object
—
Reference to another entity.
ap_account_id
string
✅
—
ID of the Accounts Payable account to use for this purchase order. This is typically the main AP account in your chart of accounts.
exchange_rate
number
—
Currency exchange rate for multi-currency transactions.
expected_date
string
—
Expected delivery date for products in YYYY-MM-DD format.
department_ref
object
—
Reference to another entity.
sales_term_ref
object
—
Reference to another entity.
txn_tax_detail
object
—
Transaction tax detail information including TxnTaxCodeRef and TaxLine.
ship_method_ref
object
—
Reference to another entity.
global_tax_calculation
string
—
Method in which tax is applied. Valid values: 'TaxExcluded', 'TaxInclusive', 'NotApplicable'.
Quickbooks Create Refund Receipt
Quickbooks Create Refund ReceiptIntegration name: QUICKBOOKS_CREATE_REFUND_RECEIPT
Tool to create a new refund receipt in QuickBooks Online. Use when a customer receives a refund for returned goods or services.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of line items for the refund receipt. At least one line item is required. Each line must specify Amount, DetailType, and relevant detail information.
TxnDate
string
—
Transaction date in YYYY-MM-DD format. If not provided, the current date is used.
DocNumber
string
—
Reference number for the refund receipt. Maximum 21 characters.
CurrencyRef
object
—
Reference to the currency.
CustomField
array
—
List of custom fields for the refund receipt.
CustomerRef
object
✅
—
Reference to the customer receiving the refund. Required.
PrivateNote
string
—
Internal note about the refund receipt, not visible to customer.
ExchangeRate
number
—
Exchange rate for multi-currency transactions.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default API version.
PaymentRefNum
string
—
Reference number for the payment (e.g., check number, transaction ID).
DepositToAccountRef
object
✅
—
Reference to the asset account where the refund is deposited. Required for the refund receipt.
Quickbooks Create Sales Receipt
Quickbooks Create Sales ReceiptIntegration name: QUICKBOOKS_CREATE_SALES_RECEIPT
Tool to create a new sales receipt in QuickBooks Online. Use when recording a sale where the customer pays immediately (cash, check, credit card).
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
line
array
✅
—
Array of line items for the sales receipt. At least one line item is required.
txn_date
string
"2024-01-15"
Transaction date in YYYY-MM-DD format. Defaults to current date if not provided.
bill_addr
object
—
Physical address structure.
class_ref
object
—
Generic reference type for various entities.
ship_addr
object
—
Physical address structure.
ship_date
string
"2024-01-20"
Date when goods or services are scheduled for delivery in YYYY-MM-DD format.
bill_email
object
—
Email address structure.
doc_number
string
—
Reference number for the sales receipt (maximum 21 characters).
currency_ref
object
—
Reference to currency.
custom_field
array
—
Array of custom fields for the sales receipt.
customer_ref
object
✅
—
Reference to the customer receiving the sales receipt. Required field.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default API version.
private_note
string
—
Private note about the sales receipt, not visible to the customer.
tracking_num
string
—
Shipping tracking number provided by the shipping provider.
bill_email_cc
object
—
Email address structure.
customer_memo
object
—
Customer memo for the sales receipt.
exchange_rate
number
—
Exchange rate for currency conversion.
bill_email_bcc
object
—
Email address structure.
department_ref
object
—
Generic reference type for various entities.
sales_term_ref
object
—
Generic reference type for various entities.
payment_ref_num
string
—
Reference number for the payment (e.g., check number, transaction ID).
ship_method_ref
object
—
Generic reference type for various entities.
payment_method_ref
object
—
Reference to the payment method (e.g., {'value': '1'}). Use to specify how the customer paid.
deposit_to_account_ref
object
—
Reference to the deposit account.
global_tax_calculation
string
"TaxExcluded"
Method in which tax is applied. Allowed values: TaxExcluded, TaxInclusive, NotApplicable.
apply_tax_after_discount
boolean
—
Whether to apply tax after discount. Defaults to false.
Quickbooks Create Tax Agency
Quickbooks Create Tax AgencyIntegration name: QUICKBOOKS_CREATE_TAX_AGENCY
Create a new tax agency in QuickBooks Online. Use when you need to set up a new tax authority or agency for tax reporting purposes.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
DisplayName
string
✅
"California State Tax Agency"
The name of the tax agency as displayed in QuickBooks. Must be unique.
Quickbooks Create Taxservice Taxcode
Quickbooks Create Taxservice TaxcodeIntegration name: QUICKBOOKS_CREATE_TAXSERVICE_TAXCODE
Create 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
TaxCode
string
✅
"SALES_TAX_8"
The unique identifier for the tax code being created. Must be unique within the QuickBooks company.
TaxRateDetails
array
✅
—
List of tax rate details to associate with this tax code. At least one tax rate detail is required.
Quickbooks Create Time Activity
Quickbooks Create Time ActivityIntegration name: QUICKBOOKS_CREATE_TIME_ACTIVITY
Create 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
hours
integer
—
Number of hours worked. Alternative to using start_time and end_time. Use with minutes field to specify duration.
minutes
integer
—
Number of minutes worked (0-59). Use with hours field to specify duration as an alternative to start_time and end_time.
name_of
string
✅
"Employee"
Specifies the type of entity: 'Employee' for employee time tracking, or 'Vendor' for vendor/contractor time tracking.
taxable
boolean
—
Whether the time activity is taxable. Set to true if subject to sales tax.
end_time
string
"2026-02-23T17:00:00+00:00"
End time of the time activity in ISO 8601 format with timezone (e.g., '2026-02-23T17:00:00+00:00'). Required unless using hours and minutes fields.
item_ref
object
—
Reference to another entity.
txn_date
string
"2026-02-23"
Transaction date for the time activity in YYYY-MM-DD format (e.g., '2026-02-23'). If not provided, current date is used.
class_ref
object
—
Reference to another entity.
start_time
string
"2026-02-23T09:00:00+00:00"
Start time of the time activity in ISO 8601 format with timezone (e.g., '2026-02-23T09:00:00+00:00'). Required unless using hours and minutes fields.
vendor_ref
object
—
Reference to another entity.
break_hours
integer
—
Number of break hours to subtract from the time activity duration.
description
string
—
Description of work completed during this time activity.
hourly_rate
number
50
Hourly billing rate for this time activity. If not provided, uses the default rate from the employee/vendor record.
customer_ref
object
—
Reference to another entity.
employee_ref
object
—
Reference to another entity.
break_minutes
integer
—
Number of break minutes (0-59) to subtract from the time activity duration.
department_ref
object
—
Reference to another entity.
billable_status
string
—
Billable status of the time activity.
payroll_item_ref
object
—
Reference to another entity.
Quickbooks Create Vendor
Quickbooks Create VendorIntegration name: QUICKBOOKS_CREATE_VENDOR
Create a new vendor in QuickBooks with the given details.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
fax
object
—
Phone number input for vendor creation.
gstin
string
—
GST Identification Number (applicable for Indian vendors).
notes
string
—
Additional notes or comments about the vendor.
title
string
"Mr."
Title 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, FamilyName, Suffix, or FullyQualifiedName attributes are required during create.
active
boolean
—
Indicates whether the vendor is currently active. Set to False to make inactive.
mobile
object
—
Phone number input for vendor creation.
suffix
string
—
Suffix 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.
balance
number
—
Opening balance amount for this vendor. Use with open_balance_date.
acct_num
string
—
Account number assigned to this vendor for tracking purposes.
term_ref
object
—
Reference type input for entity references.
web_addr
object
—
Website address input for vendor creation.
bill_addr
object
—
Physical address input for vendor creation.
bill_rate
number
—
Standard billing rate for the vendor (per hour or unit).
ship_addr
object
—
Physical address input for vendor creation.
given_name
string
—
Given 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.
parent_ref
object
—
Reference type input for entity references.
family_name
string
—
Family 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.
middle_name
string
—
Middle 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 object create.
tax_country
string
—
Country for tax purposes (e.g., 'US', 'CA', 'IN').
tds_enabled
boolean
—
Indicates if Tax Deducted at Source (TDS) is enabled (India).
vendor_1099
boolean
—
Indicates whether the vendor is eligible for 1099 tax reporting (US tax purposes).
company_name
string
—
The name of the company associated with the vendor. Useful when creating organizational vendors.
contact_name
string
—
Primary contact person's name at the vendor.
credit_limit
number
—
Maximum credit amount extended to the vendor.
currency_ref
object
—
Reference type input for entity references.
display_name
string
—
The 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 customer name components supplied in the request from the following list: Title, GivenName, MiddleName, FamilyName, and Suffix.
t4a_eligible
boolean
—
Canadian T4A tax form eligibility status.
primary_phone
object
—
Phone number input for vendor creation.
ap_account_ref
object
—
Reference type input for entity references.
t5018_eligible
boolean
—
Canadian T5018 tax form eligibility status.
tax_identifier
string
—
Tax identification number for the vendor (EIN or SSN).
alternate_phone
object
—
Phone number input for vendor creation.
business_number
string
—
Business registration number or tax identification number.
alt_contact_name
string
—
Alternate contact person's name at the vendor.
open_balance_date
string
—
Date of the opening balance in YYYY-MM-DD format.
primary_email_addr
object
—
Email address input for vendor creation.
tds_entity_type_id
integer
—
TDS entity type classification identifier (India).
print_on_check_name
string
—
The name of the vendor as it should be printed on checks. If not provided, uses DisplayName.
tax_reporting_basis
string
—
Tax reporting methodology (e.g., 'Cash', 'Accrual').
tds_section_type_id
integer
—
TDS section type categorization identifier (India).
default_tax_code_ref
object
—
Reference type input for entity references.
gst_registration_type
string
—
GST registration type (applicable for Indian vendors, e.g., 'Regular', 'Composition').
tax_id_effective_date
string
—
Effective date for the tax identification number in YYYY-MM-DD format.
tds_override_threshold
boolean
—
Whether to override the standard TDS threshold limits (India).
Quickbooks Create Vendor Credit
Quickbooks Create Vendor CreditIntegration name: QUICKBOOKS_CREATE_VENDOR_CREDIT
Tool to create a new vendor credit in QuickBooks Online. Use when recording a credit from a vendor that reduces what you owe.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Line
array
✅
—
List of line items for the vendor credit. At least one line item is required. Each line must specify DetailType, Amount, and AccountBasedExpenseLineDetail.
Memo
string
—
Memo for the vendor credit that appears on reports.
TxnDate
string
—
Date of the transaction in YYYY-MM-DD format. Defaults to the current date if not provided.
DocNumber
string
—
Reference number for the vendor credit (e.g., credit memo number from vendor).
VendorRef
object
✅
—
Reference to the vendor from whom the credit is received. Required field.
CurrencyRef
object
—
Reference to the currency. Format: {'value': 'USD'}.
PrivateNote
string
—
User-entered private note about the vendor credit.
APAccountRef
object
—
Reference to the Accounts Payable account. Format: {'value': 'account_id'}. If not specified, uses the default AP account.
ExchangeRate
number
—
Currency exchange rate for multi-currency transactions.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default version.
DepartmentRef
object
—
Reference to the department. Format: {'value': 'department_id'}.
GlobalTaxCalculation
string
—
Method in which tax is applied. Valid values: TaxExcluded, TaxInclusive, NotApplicable.
Quickbooks Customer Balance Detail
Quickbooks Customer Balance DetailIntegration name: QUICKBOOKS_CUSTOMER_BALANCE_DETAIL
Generate a balance detail report for a customer in QuickBooks with the given customer ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
arpaid
string
—
Status of the balance.
columns
string
—
Column 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*, due_date*, last_mod_by, last_mod_date, memo*, sale_sent_state, ship_addr, ship_date, ship_via, term_name, tracking_num, tx_date*, txn_type*. Additional columns with custom fields enabled: sales_cust1, sales_cust2, sales_cust3. Additional columns with location tracking enabled: dept_name*
custom1
string
—
Filter by the specified custom field as defined by the CustomField attribute in transaction entities where supported. Supported Values: Name of custom field.
shipvia
string
—
Filter by the shipping method as stored in Invoice.ShipMethodRef.Name.
sort_by
string
—
The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
term_ids
array
—
One or more comma separated term IDs. Filters report contents based on term or terms supplied.
sort_order
string
—
The sort order.
end_duedate
string
—
The 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_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
aging_method
string
—
The date upon which aging is determined.
customer_ids
array
—
One or more comma separated customer IDs. Filters report contents to include information for specified customers.
start_duedate
string
—
The 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.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
Quickbooks Customer Balance Report
Quickbooks Customer Balance ReportIntegration name: QUICKBOOKS_CUSTOMER_BALANCE_REPORT
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
qzurl
string
—
Specifies whether Quick Zoom URL information should be generated for rows in the report.
arpaid
string
—
Filter by payment status. 'All' includes all balances, 'Paid' shows only paid invoices, 'Unpaid' shows only outstanding balances. If not specified, defaults to showing all.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Delete Bank Account
Quickbooks Delete Bank AccountIntegration name: QUICKBOOKS_DELETE_BANK_ACCOUNT
Tool to delete a bank account on file for a customer in QuickBooks Payments API. Use when removing a customer's payment method. Returns 204 No Content on success with an empty response body from the API.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
request_id
string
"550e8400-e29b-41d4-a716-446655440005"
UUID for idempotency to prevent duplicate requests. If not provided, one will be generated automatically.
customer_id
string
✅
"test-customer-id"
The customer ID for whom the bank account is being deleted (can be a test ID like 'test-customer-id')
bank_account_id
string
✅
"200153232587278746893210"
The bank account ID to delete
Quickbooks Execute Batch Operation
Quickbooks Execute Batch OperationIntegration name: QUICKBOOKS_EXECUTE_BATCH_OPERATION
Execute 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
65
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version from metadata.
BatchItemRequest
array
✅
—
List of batch item requests to execute. Each item can be a create, update, delete, or query operation. Operations are performed serially in the order provided. Maximum 30 items per batch request.
Quickbooks Get Aged Receivables Report
Quickbooks Get Aged Receivables ReportIntegration name: QUICKBOOKS_GET_AGED_RECEIVABLES_REPORT
Generate an aged receivables report showing outstanding customer balances by age. Use when tracking overdue invoices and managing accounts receivable aging.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
arpaid
string
—
Filters customers by payment status. Use 'All' for all customers, 'Paid' for customers with fully paid balances, or 'Unpaid' for customers with outstanding balances. Default is 'Unpaid'.
date_macro
string
—
Predefined date macro like 'Today', 'This Month', etc. Alternative to report_date for specifying the report date using a macro.
num_periods
integer
—
Number of aging periods to display in the report. Must be between 1 and 10. Defaults to 4 if not specified. Each period shows receivables within that age range.
report_date
string
—
Date for the aged receivables report in YYYY-MM-DD format. Defaults to today if not provided. This is the as-of date for calculating aging.
aging_method
string
—
Method for calculating aging. 'Report_Date' calculates aging from the report date, 'Current' calculates aging from the current date. Defaults to 'Report_Date' if not specified.
aging_period
integer
—
Number of days per aging period. Must be at least 1. Defaults to 30 days if not specified. For example, with 30 days you get periods like 0-30, 31-60, etc.
customer_ids
array
—
One or more comma-separated customer IDs to filter the report. Filters report contents to include information for specified customers only. Provide customer IDs as returned in the Customer.Id attribute.
minorversion
string
—
API minor version number. Optional - defaults to x-minor-version header if not provided. Use this to access features from specific minor versions of the QuickBooks API.
Quickbooks Get Attachable
Quickbooks Get AttachableIntegration name: QUICKBOOKS_GET_ATTACHABLE
Tool to read details of a specific attachable by ID in QuickBooks Online. Attachables represent file attachments linked to entities like invoices, customers, or bills.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
API minor version to use for the request. If not provided, uses the version from metadata headers.
attachable_id
string
✅
"68120641"
ID of the attachable (file attachment) to retrieve
Quickbooks Get Balance Sheet Report
Quickbooks Get Balance Sheet ReportIntegration name: QUICKBOOKS_GET_BALANCE_SHEET_REPORT
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Bank Account
Quickbooks Get Bank AccountIntegration name: QUICKBOOKS_GET_BANK_ACCOUNT
Tool to retrieve a specific bank account by ID from QuickBooks Payments API. Use when you need to get details about a specific payment method for a customer.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
customer_id
string
✅
"123456789012345678901234"
The customer ID who owns the bank account
bank_account_id
string
✅
"200180091307278738147890"
The unique identifier of the bank account to retrieve
Quickbooks Get Bill
Quickbooks Get BillIntegration name: QUICKBOOKS_GET_BILL
Tool to fetch a QuickBooks bill by ID. Use when needing to retrieve bill details including vendor reference, line items, amounts, and payment status.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
bill_id
string
✅
"13"
ID of the bill to retrieve from QuickBooks
minorversion
integer
65
API minor version to use for the request (e.g., 65, 70, 75). If not specified, uses the default from headers.
Quickbooks Get Bill Payment
Quickbooks Get Bill PaymentIntegration name: QUICKBOOKS_GET_BILL_PAYMENT
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default from headers.
bill_payment_id
string
✅
"10"
ID of the bill payment to retrieve.
Quickbooks Get Changed Entities
Quickbooks Get Changed EntitiesIntegration name: QUICKBOOKS_GET_CHANGED_ENTITIES
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
entities
string
✅
"Customer,Invoice"
Comma-separated list of entity types to query for changes. Valid entity types include: Account, Bill, BillPayment, Budget, Class, CreditMemo, Customer, Department, Deposit, Employee, Estimate, Invoice, Item, JournalEntry, Payment, PaymentMethod, Purchase, PurchaseOrder, RefundReceipt, SalesReceipt, TaxCode, TaxRate, Term, TimeActivity, Transfer, Vendor, VendorCredit. Example: 'Customer,Invoice' or 'Bill,Payment,Vendor'.
changedSince
string
✅
"2026-02-16T00:00:00Z"
ISO 8601 timestamp indicating the starting point for change tracking. Returns entities modified after this timestamp. Maximum lookback period is 30 days. Format: YYYY-MM-DDTHH:MM:SSZ (UTC timezone recommended). Example: '2026-02-16T00:00:00Z'
Quickbooks Get Company Info
Quickbooks Get Company InfoIntegration name: QUICKBOOKS_GET_COMPANY_INFO
Tool to read company information from QuickBooks Online. Returns basic company info including name, addresses, fiscal year settings, and subscription status.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
API minor version to use for the request. If not provided, uses the version from metadata headers.
Quickbooks Get Credit Memo
Quickbooks Get Credit MemoIntegration name: QUICKBOOKS_GET_CREDIT_MEMO
Tool to fetch a QuickBooks credit memo by ID. Use when needing full credit memo details including metadata, customer info, line items, and remaining credit amount.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
70
API minor version to use for the request
credit_memo_id
string
✅
"14"
ID of the credit memo to read
Quickbooks Get Credit Memo Pdf
Quickbooks Get Credit Memo PdfIntegration name: QUICKBOOKS_GET_CREDIT_MEMO_PDF
Tool to download a QuickBooks credit memo as a PDF file. Use when you need to retrieve the printable PDF version of a credit memo.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
credit_memo_id
string
✅
"14"
The ID of the credit memo to retrieve as PDF (e.g., '14', '123').
Quickbooks Get Department
Quickbooks Get DepartmentIntegration name: QUICKBOOKS_GET_DEPARTMENT
Read details of a specific department by ID in QuickBooks Online. Use when you need to retrieve information about a department.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
department_id
string
✅
—
The ID of the department to retrieve.
Quickbooks Get Deposit
Quickbooks Get DepositIntegration name: QUICKBOOKS_GET_DEPOSIT
Tool to read details of a specific deposit by ID in QuickBooks Online. Use when you need complete deposit information including line items, amounts, and metadata.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
deposit_id
string
✅
"4"
ID of the deposit to retrieve. Use QUICKBOOKS_QUERY_DEPOSIT to find deposit IDs.
minorversion
integer
65
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). If not specified, uses the default API version from headers.
Quickbooks Get Estimate
Quickbooks Get EstimateIntegration name: QUICKBOOKS_GET_ESTIMATE
Tool to fetch a QuickBooks estimate by ID. Use when needing full estimate details including metadata, line items, and sync token.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
estimate_id
string
✅
"19"
ID of the estimate to read from QuickBooks
minorversion
integer
65
API minor version to use for the request
Quickbooks Get Estimate Pdf
Quickbooks Get Estimate PdfIntegration name: QUICKBOOKS_GET_ESTIMATE_PDF
Tool to download a QuickBooks estimate as a PDF file. Use when you need to retrieve the printable PDF version of an estimate.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
estimate_id
string
✅
"19"
The ID of the estimate to retrieve as PDF (e.g., '19', '123').
minorversion
string
"65"
API minor version to use for the request (e.g., '65', '75'). If not specified, uses the default API version.
Quickbooks Get Exchange Rate
Quickbooks Get Exchange RateIntegration name: QUICKBOOKS_GET_EXCHANGE_RATE
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
asofdate
string
✅
"2024-01-15"
The date for which to get the exchange rate, in YYYY-MM-DD format (e.g., 2024-01-15).
minorversion
integer
73
API minor version to use for the request. If not provided, uses the version from metadata headers.
sourcecurrencycode
string
✅
"EUR"
The source currency code for which to get the exchange rate (e.g., EUR, GBP, JPY).
Quickbooks Get General Ledger Report
Quickbooks Get General Ledger ReportIntegration name: QUICKBOOKS_GET_GENERAL_LEDGER_REPORT
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
columns
string
—
Column types to show in the report. Comma-separated list of column names (e.g., 'tx_date,txn_type,doc_num,name,memo,account,debit,credit,balance').
sort_by
string
—
The column type on which to base sorting (e.g., 'tx_date', 'account', 'txn_type'). Default is 'txn_type' if not specified.
end_date
string
—
End date for the report period in YYYY-MM-DD format.
class_ids
array
—
List of class IDs to filter the report. If not provided, the report includes all classes. Each ID should be the Class.Id value (e.g., ['1', '2']).
date_macro
string
—
Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use start_date and end_date to cover an explicit report date range.
sort_order
string
—
The sort order for rows (ascending or descending). Default is ascending.
start_date
string
—
Start date for the report period in YYYY-MM-DD format.
vendor_ids
array
—
List of vendor IDs to filter the report. If not provided, the report includes all vendors. Each ID should be the Vendor.Id value (e.g., ['1', '3']).
account_ids
array
—
List of account IDs to filter the report. If not provided, the report includes all accounts. Each ID should be the Account.Id value from the Account object (e.g., ['1', '35', '82']).
account_type
string
—
Account type from which to include transactions (e.g., 'Bank', 'Expense', 'Income').
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value (e.g., ['1', '5']).
department_ids
array
—
List of department IDs to filter the report. If not provided, the report includes all departments. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report (Cash or Accrual).
source_account_ids
array
—
List of source account IDs to filter the report. Each ID should be the Account.Id value for the source account.
source_account_type
string
—
Source account type for transaction filtering.
Quickbooks Get Inventory Valuation Summary
Quickbooks Get Inventory Valuation SummaryIntegration name: QUICKBOOKS_GET_INVENTORY_VALUATION_SUMMARY
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Invoice Pdf
Quickbooks Get Invoice PdfIntegration name: QUICKBOOKS_GET_INVOICE_PDF
Tool to download a QuickBooks invoice as a PDF file. Use when you need to retrieve the printable PDF version of an invoice.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
invoice_id
string
✅
"17"
The ID of the invoice to retrieve as PDF (e.g., '17', '123').
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
Quickbooks Get Item
Quickbooks Get ItemIntegration name: QUICKBOOKS_GET_ITEM
Tool to retrieve a specific item by its ID from QuickBooks Online. Use when you need full details of a product or service item.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
item_id
string
✅
"12421341"
Unique identifier of the item to retrieve from QuickBooks.
minorversion
integer
65
QuickBooks API minor version number to use for this request (e.g., 65, 70, 75). Allows access to version-specific features. If not specified, uses the default API version.
Quickbooks Get Journal Entry
Quickbooks Get Journal EntryIntegration name: QUICKBOOKS_GET_JOURNAL_ENTRY
Tool to read details of a specific QuickBooks journal entry by ID. Use when you need complete journal entry information including transaction date, line items, posting types, and account references.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
API minor version number (e.g., 75)
journal_entry_id
string
✅
"1"
The ID of the journal entry to retrieve
Quickbooks Get Payment
Quickbooks Get PaymentIntegration name: QUICKBOOKS_GET_PAYMENT
Tool to fetch details of a specific payment by ID in QuickBooks Online. Use when needing payment information including customer, amounts, and linked transactions.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
payment_id
string
✅
"18"
ID of the payment to retrieve
minorversion
integer
65
API minor version to use for the request
Quickbooks Get Payment Method
Quickbooks Get Payment MethodIntegration name: QUICKBOOKS_GET_PAYMENT_METHOD
Read details of a specific payment method by ID in QuickBooks Online. Use when you need to retrieve information about a payment method entity.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
payment_method_id
string
✅
—
ID of the payment method to be read
Quickbooks Get Payment Pdf
Quickbooks Get Payment PdfIntegration name: QUICKBOOKS_GET_PAYMENT_PDF
Tool to download a QuickBooks payment record as a PDF file. Use when you need to retrieve the printable PDF version of a payment.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
payment_id
string
✅
"18"
The ID of the payment record to retrieve as PDF (e.g., '18', '123').
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
Quickbooks Get Preferences
Quickbooks Get PreferencesIntegration name: QUICKBOOKS_GET_PREFERENCES
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
API minor version to use for the request. If not provided, uses the version from metadata headers.
Quickbooks Get Profit And Loss Detail Report
Quickbooks Get Profit And Loss Detail ReportIntegration name: QUICKBOOKS_GET_PROFIT_AND_LOSS_DETAIL_REPORT
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
Report end date in YYYY-MM-DD format. If not provided, defaults to today's date.
class_ids
array
—
List of class IDs to filter the report. If not provided, the report includes all classes. Each ID should be the Class.Id value from the Class object (e.g., ['1', '3']).
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
—
Report start date in YYYY-MM-DD format. If not provided, defaults to the start of the current fiscal year.
vendor_ids
array
—
List of vendor IDs to filter the report. If not provided, the report includes all vendors. Each ID should be the Vendor.Id value from the Vendor object (e.g., ['1', '5', '20']).
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Profit And Loss Report
Quickbooks Get Profit And Loss ReportIntegration name: QUICKBOOKS_GET_PROFIT_AND_LOSS_REPORT
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
Report end date in YYYY-MM-DD format. If not provided, defaults to today's date.
class_ids
array
—
List of class IDs to filter the report. If not provided, the report includes all classes. Each ID should be the Class.Id value from the Class object (e.g., ['1', '3']).
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
—
Report start date in YYYY-MM-DD format. If not provided, defaults to the start of the current fiscal year.
vendor_ids
array
—
List of vendor IDs to filter the report. If not provided, the report includes all vendors. Each ID should be the Vendor.Id value from the Vendor object (e.g., ['1', '5', '20']).
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Purchase
Quickbooks Get PurchaseIntegration name: QUICKBOOKS_GET_PURCHASE
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
purchase_id
string
✅
"20"
ID of the purchase to retrieve
minorversion
integer
65
API minor version to use for the request. If not provided, uses the version from metadata headers.
Quickbooks Get Purchase Order
Quickbooks Get Purchase OrderIntegration name: QUICKBOOKS_GET_PURCHASE_ORDER
Tool to fetch a QuickBooks purchase order by ID. Use when needing full purchase order details including line items, vendor information, and metadata.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
65
API minor version to use for the request
purchase_order_id
string
✅
"15"
ID of the purchase order to retrieve
Quickbooks Get Purchase Order Pdf
Quickbooks Get Purchase Order PdfIntegration name: QUICKBOOKS_GET_PURCHASE_ORDER_PDF
Tool to download a QuickBooks purchase order as a PDF file. Use when you need to retrieve the printable PDF version of a purchase order.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
purchase_order_id
string
✅
"25"
The ID of the purchase order to retrieve as PDF (e.g., '25', '123').
Quickbooks Get Refund Receipt
Quickbooks Get Refund ReceiptIntegration name: QUICKBOOKS_GET_REFUND_RECEIPT
Tool to fetch a QuickBooks refund receipt by ID. Use when needing details of a specific refund issued to a customer.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
75
API minor version to use for the request
refund_receipt_id
string
✅
"9"
ID of the refund receipt to retrieve
Quickbooks Get Refund Receipt Pdf
Quickbooks Get Refund Receipt PdfIntegration name: QUICKBOOKS_GET_REFUND_RECEIPT_PDF
Tool to download a QuickBooks refund receipt as a PDF file. Use when you need to retrieve the printable PDF version of a refund receipt.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
refund_receipt_id
string
✅
"22"
The ID of the refund receipt to retrieve as PDF (e.g., '22', '123').
Quickbooks Get Report Account List
Quickbooks Get Report Account ListIntegration name: QUICKBOOKS_GET_REPORT_ACCOUNT_LIST
Retrieve the AccountList report from QuickBooks showing a list of all accounts. This report displays all account details including name, type, and balance information.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
columns
string
—
Comma-separated list of column names to include in the report. Valid column names: 'account_name', 'account_type', 'detail_acc_type', 'account_desc', 'account_bal'. If not specified, all columns are included. Example: 'account_name,account_type,account_bal'
sort_order
string
—
The sort order for the accounts. Valid values: 'ascend' (ascending, A-Z) or 'descend' (descending, Z-A). If not specified, accounts are returned in their default order.
Quickbooks Get Report Aged Payable Detail
Quickbooks Get Report Aged Payable DetailIntegration name: QUICKBOOKS_GET_REPORT_AGED_PAYABLE_DETAIL
Generate an aged payable detail report showing aging detail for accounts payable. Use when you need to analyze outstanding vendor bills grouped by aging periods.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
appaid
string
—
Status of the payable balance.
columns
string
—
Column types to be shown in the report. Supported Values: bill_addr, create_by, create_date, vend_bill_email, vend_comp_name, vend_phone_other, vend_tel, vend_name, doc_num*, due_date*, last_mod_by, last_mod_date, memo*, term_name, tx_date*, txn_type*. Additional columns with custom fields enabled: purch_vend1, purch_vend2, purch_vend3. Additional columns with location tracking enabled: dept_name*
sort_by
string
—
The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
term_ids
array
—
One or more comma separated term IDs. Filters report contents based on term or terms supplied.
date_macro
string
—
Predefined date range for the report. Examples: 'Today', 'This Month', 'Last Month', 'This Fiscal Quarter', etc.
sort_order
string
—
The sort order.
vendor_ids
array
—
One or more comma separated vendor IDs. Filters report contents to include information for specified vendors.
end_duedate
string
—
The 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.
num_periods
integer
—
Number of aging periods to display in the report. Each period represents a time bucket for aging calculations (e.g., 0-30 days, 31-60 days).
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
aging_method
string
—
The date upon which aging is determined.
aging_period
integer
—
Number of days per aging period. Default is typically 30 days. For example, setting this to 30 creates buckets like 0-30, 31-60, 61-90 days.
duedate_macro
string
—
Predefined date range for filtering by due date. Examples: 'Today', 'This Month', 'Last Month', 'This Fiscal Quarter', etc.
start_duedate
string
—
The 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.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report. Supported values: Cash, Accrual.
Quickbooks Get Report Aged Payables
Quickbooks Get Report Aged PayablesIntegration name: QUICKBOOKS_GET_REPORT_AGED_PAYABLES
Retrieve 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).
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
appaid
string
—
Filters vendors by payment status. Use 'All' for all vendors, 'Paid' for vendors with fully paid balances, or 'Unpaid' for vendors with outstanding balances. Default is 'Unpaid'.
date_macro
string
—
Predefined date macro like 'Today', 'This Month', etc. Alternative to report_date for specifying the report date using a macro.
vendor_ids
array
—
Filters report contents to include information for specified vendors. Provide one or more comma-separated vendor IDs as returned in the Vendor.Id attribute.
num_periods
integer
—
Number of aging periods to display in the report. Must be between 1 and 10. Defaults to 4 if not specified. Each period shows payables within that age range.
report_date
string
—
Date for the aged payables report in YYYY-MM-DD format. Defaults to today if not provided. This is the as-of date for calculating aging.
aging_method
string
—
Method for calculating aging. 'Report_Date' calculates aging from the report date, 'Current' calculates aging from the current date. Defaults to 'Report_Date' if not specified.
aging_period
integer
—
Number of days per aging period. Must be at least 1. Defaults to 30 days if not specified. For example, with 30 days you get periods like 0-30, 31-60, etc.
minorversion
string
—
API minor version number. Optional - defaults to x-minor-version header if not provided. Use this to access features from specific minor versions of the QuickBooks API.
Quickbooks Get Report Aged Receivable Detail
Quickbooks Get Report Aged Receivable DetailIntegration name: QUICKBOOKS_GET_REPORT_AGED_RECEIVABLE_DETAIL
Generate an aged receivable detail report showing aging detail for accounts receivable. Use when you need to analyze outstanding customer invoices grouped by aging periods.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
arpaid
string
—
Status of the receivable balance.
columns
string
—
Column 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*, due_date*, last_mod_by, last_mod_date, memo*, sale_sent_state, ship_addr, ship_date, ship_via, term_name, tracking_num, tx_date*, txn_type*. Additional columns with custom fields enabled: sales_cust1, sales_cust2, sales_cust3. Additional columns with location tracking enabled: dept_name*
custom1
string
—
Filter by the specified custom field as defined by the CustomField attribute in transaction entities where supported. Supported Values: Name of custom field.
shipvia
string
—
Filter by the shipping method as stored in Invoice.ShipMethodRef.Name.
sort_by
string
—
The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
term_ids
array
—
One or more comma separated term IDs. Filters report contents based on term or terms supplied.
date_macro
string
—
Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use report_date to specify an explicit report date.
sort_order
string
—
The sort order.
end_duedate
string
—
The 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.
num_periods
integer
—
Number of aging periods to display in the report. Each period represents a time bucket for aging calculations (e.g., 0-30 days, 31-60 days).
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
aging_method
string
—
The date upon which aging is determined.
aging_period
integer
—
Number of days per aging period. Default is typically 30 days. For example, setting this to 30 creates buckets like 0-30, 31-60, 61-90 days.
customer_ids
array
—
One or more comma separated customer IDs. Filters report contents to include information for specified customers.
duedate_macro
string
—
Predefined date range of due dates for receivables to include in the report; otherwise, use the start_duedate and end_duedate to cover an explicit report date range.
start_duedate
string
—
The 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.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
Quickbooks Get Report Cash Flow
Quickbooks Get Report Cash FlowIntegration name: QUICKBOOKS_GET_REPORT_CASH_FLOW
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Report Class Sales
Quickbooks Get Report Class SalesIntegration name: QUICKBOOKS_GET_REPORT_CLASS_SALES
Generate a ClassSales report in QuickBooks showing sales amounts grouped by class. Use when you need to analyze sales performance by class tracking categories.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
class_ids
array
—
One or more comma separated class IDs to filter the report. If not provided, the report includes all classes. Each ID should be the Class.Id value from the Class object.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Report Customer Income
Quickbooks Get Report Customer IncomeIntegration name: QUICKBOOKS_GET_REPORT_CUSTOMER_INCOME
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
Report end date in YYYY-MM-DD format. Use together with start_date to specify a custom date range.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
—
Report start date in YYYY-MM-DD format. Use together with end_date to specify a custom date range.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Report Customer Sales
Quickbooks Get Report Customer SalesIntegration name: QUICKBOOKS_GET_REPORT_CUSTOMER_SALES
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
Report end date in YYYY-MM-DD format. Use together with start_date to specify a custom date range.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
—
Report start date in YYYY-MM-DD format. Use together with end_date to specify a custom date range.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Report Department Sales
Quickbooks Get Report Department SalesIntegration name: QUICKBOOKS_GET_REPORT_DEPARTMENT_SALES
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
End date for the report period in YYYY-MM-DD format. Use this with start_date to specify a custom date range, or use date_macro for predefined ranges.
date_macro
string
—
Predefined date range for the report (e.g., 'This Month', 'Last Quarter'). Use this as an alternative to specifying start_date and end_date explicitly.
sort_order
string
—
The sort order for the report results (ascend or descend).
start_date
string
—
Start date for the report period in YYYY-MM-DD format. Use this with end_date to specify a custom date range, or use date_macro for predefined ranges.
department_ids
array
—
List of department IDs to filter the report. Filters report contents to include information for specified departments if configured in the company file.
accounting_method
string
—
The accounting method used in the report (Cash or Accrual).
summarize_column_by
string
—
The criteria by which to group the report results (e.g., Total, Month, Quarter).
Quickbooks Get Report Item Sales
Quickbooks Get Report Item SalesIntegration name: QUICKBOOKS_GET_REPORT_ITEM_SALES
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
item_ids
array
—
List of item IDs to filter the report. If not provided, the report includes all items. Each ID should be the Item.Id value from the Item object (e.g., ['1', '2', '10']).
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Reports
Quickbooks Get ReportsIntegration name: QUICKBOOKS_GET_REPORTS
Retrieve QuickBooks reports such as TransactionList, BalanceSheet, ProfitAndLoss, and others. Use when you need to access standardized financial or transaction reports with flexible filtering options.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
vendor
string
"5"
Vendor ID or comma-separated list of vendor IDs to filter the report. Only transactions related to these vendors will be included. Use Vendor.Id value from the Vendor object.
cleared
string
"All"
Filter for transaction cleared status. Options: 'All', 'Cleared', 'Uncleared', 'Reconciled'. Note that 'cleared' can only be used as a filter parameter, not as a column in the result.
columns
string
"tx_date,txn_type,amount"
Comma-separated list of column types to include in the report. For example: 'tx_date,txn_type,doc_num,name,memo,account,amount'. If not specified, the report uses default columns.
sort_by
string
"tx_date"
Column type to use for sorting report rows. Common values include 'tx_date', 'txn_type', 'amount', etc. Must be a column that exists in the report.
customer
string
"1"
Customer ID or comma-separated list of customer IDs to filter the report. Only transactions related to these customers will be included. Use Customer.Id value from the Customer object.
end_date
string
"2024-12-31"
Report end date in YYYY-MM-DD format. Used to filter transactions or data up to this date. If not provided, the report uses its default end date or date_macro setting.
group_by
string
"Customer"
Column type to use for grouping report rows. Common values include 'Customer', 'Vendor', 'Account', etc. Groups transactions by the specified entity type.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
"2024-01-01"
Report start date in YYYY-MM-DD format. Used to filter transactions or data from this date onwards. If not provided, the report uses its default start date or date_macro setting.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
report_name
string
✅
"TransactionList"
The name of the report to retrieve. For example: 'TransactionList', 'BalanceSheet', 'ProfitAndLoss', 'CashFlow', etc. This is the report type identifier used in the QuickBooks API endpoint.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Report Trial Balance
Quickbooks Get Report Trial BalanceIntegration name: QUICKBOOKS_GET_REPORT_TRIAL_BALANCE
Generate 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
end_date
string
—
Report end date in YYYY-MM-DD format. If not provided, defaults to today's date.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
start_date
string
—
Report start date in YYYY-MM-DD format. If not provided, defaults to the start of the current fiscal year.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks Get Sales Receipt
Quickbooks Get Sales ReceiptIntegration name: QUICKBOOKS_GET_SALES_RECEIPT
Tool to fetch a QuickBooks sales receipt by ID. Use when needing full sales receipt details including customer info, line items, payment details, and metadata.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
65
API minor version to use for the request
sales_receipt_id
string
✅
"26"
ID of the sales receipt to read from QuickBooks
Quickbooks Get Salesreceipt Pdf
Quickbooks Get Salesreceipt PdfIntegration name: QUICKBOOKS_GET_SALESRECEIPT_PDF
Tool to download a QuickBooks sales receipt as a PDF file. Use when you need to retrieve the printable PDF version of a sales receipt.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
string
"70"
API minor version to use for the request (e.g., '70', '75'). If not specified, uses the default API version.
sales_receipt_id
string
✅
"31"
The ID of the sales receipt to retrieve as PDF (e.g., '31', '123').
Quickbooks Get Tax Rate
Quickbooks Get Tax RateIntegration name: QUICKBOOKS_GET_TAX_RATE
Tool to read details of a specific tax rate by ID in QuickBooks Online. Use when you need to retrieve information about a tax rate.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
tax_rate_id
string
✅
"1"
The ID of the tax rate to retrieve.
minorversion
integer
65
API minor version to use for the request
Quickbooks Get Term
Quickbooks Get TermIntegration name: QUICKBOOKS_GET_TERM
Read details of a specific payment term by ID in QuickBooks Online. Terms define payment conditions like Net 30 or Due on Receipt.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
term_id
string
✅
—
The ID of the payment term to retrieve.
Quickbooks Get Time Activity
Quickbooks Get Time ActivityIntegration name: QUICKBOOKS_GET_TIME_ACTIVITY
Tool to read details of a specific time activity by ID in QuickBooks Online. Returns complete time tracking information including employee/vendor reference, hours worked, billing rate, and associated customer.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
65
Optional API minor version parameter to use for the request
time_activity_id
string
✅
"1073741824"
The unique identifier of the time activity to retrieve
Quickbooks Get Transaction List Report
Quickbooks Get Transaction List ReportIntegration name: QUICKBOOKS_GET_TRANSACTION_LIST_REPORT
Get 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
cleared
string
"All"
Filter for transaction cleared status. Options: 'All', 'Cleared', 'Uncleared', 'Reconciled'. Note that 'cleared' can only be used as a filter parameter, not as a column in the result.
columns
string
"date,transaction_type,number,name,memo,account,amount"
Comma-separated list of columns to include in the report. Supports both user-friendly names and QuickBooks API identifiers: date/tx_date (Date), transaction_type/txn_type (Transaction Type), number/num/doc_num (Number), name (Name), memo/description (Memo/Description), account/account_name (Account), amount/subt_nat_amount (Amount), net_amount (Net Amount), split (Split), balance (Balance), customer (Customer), vendor (Vendor), employee (Employee), product_service (Product/Service), quantity (Quantity), rate (Rate), class (Class), department/dept (Department), location (Location). If not specified, report uses default columns.
sort_by
string
"date"
Column to sort report rows by. Supports both user-friendly names (date, transaction_type, amount, account, etc.) and QuickBooks API identifiers (tx_date, txn_type, subt_nat_amount, account_name, etc.). Must be a column that exists in the report.
end_date
string
"2024-12-31"
Report end date in YYYY-MM-DD format. Used to filter transactions up to this date. If not provided, the report uses its default end date or date_macro setting.
group_by
string
"Customer"
Column type to use for grouping report rows. Common values include 'Customer', 'Vendor', 'Account', etc. Groups transactions by the specified entity type.
class_ids
array
—
List of class IDs to filter the report. If not provided, the report includes all classes. Each ID should be the Class.Id value (e.g., ['1', '2']).
date_macro
string
—
Predefined date range for the report. Use if you want the report to cover a standard report date range; otherwise, use start_date and end_date to cover an explicit report date range.
sort_order
string
—
The sort order for rows (ascending or descending). Default is ascending.
start_date
string
"2024-01-01"
Report start date in YYYY-MM-DD format. Used to filter transactions from this date onwards. If not provided, the report uses its default start date or date_macro setting.
vendor_ids
array
—
List of vendor IDs to filter the report. If not provided, the report includes all vendors. Each ID should be the Vendor.Id value from the Vendor object (e.g., ['5', '8', '12']).
account_ids
array
—
List of account IDs to filter the report. If not provided, the report includes all accounts. Each ID should be the Account.Id value from the Account object (e.g., ['1', '35', '82']).
customer_ids
array
—
List of customer IDs to filter the report. If not provided, the report includes all customers. Each ID should be the Customer.Id value from the Customer object (e.g., ['1', '2', '10']).
department_ids
array
—
List of department IDs to filter the report. If not provided, the report includes all departments. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report (Cash or Accrual).
Quickbooks Get Transfer
Quickbooks Get TransferIntegration name: QUICKBOOKS_GET_TRANSFER
Tool to fetch a QuickBooks transfer by ID. Use when needing to retrieve transfer details including from/to account references and transfer amount.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
transfer_id
string
✅
"1"
ID of the transfer to retrieve from QuickBooks
minorversion
integer
65
API minor version to use for the request (e.g., 65, 70, 75). If not specified, uses the default from headers.
Quickbooks Get Vendor Credit
Quickbooks Get Vendor CreditIntegration name: QUICKBOOKS_GET_VENDOR_CREDIT
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
minorversion
integer
65
API minor version to use for the request (e.g., 65, 70, 75). If not specified, uses the default from headers.
vendor_credit_id
string
✅
"27"
ID of the vendor credit to retrieve from QuickBooks
Quickbooks Get Vendor Expenses Report
Quickbooks Get Vendor Expenses ReportIntegration name: QUICKBOOKS_GET_VENDOR_EXPENSES_REPORT
Retrieve 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
qzurl
string
—
Specifies whether Quick Zoom URL information should be generated for rows in the report.
appaid
string
—
Filters vendors by payment status. Use 'All' for all vendors, 'Paid' for vendors with fully paid balances, or 'Unpaid' for vendors with outstanding balances.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
vendor_ids
array
—
Filters 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 code.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.
Quickbooks List Cards
Quickbooks List CardsIntegration name: QUICKBOOKS_LIST_CARDS
Tool to retrieve all payment cards on file for a customer in QuickBooks Payments API. Use when needing to list saved payment methods for a customer.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
customer_id
string
✅
"00205184c555f1660c42d19c2d324f86ac3567"
The QuickBooks Payments V4IDPseudonym identifier for the customer. This is different from the QuickBooks Online customer ID - use the V4IDPseudonym field from the customer object.
Quickbooks List Departments
Quickbooks List DepartmentsIntegration name: QUICKBOOKS_LIST_DEPARTMENTS
Query 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
query
string
"SELECT * FROM Department"
SQL-like query string to filter and retrieve Department entities ONLY. IMPORTANT: This tool queries the Department entity exclusively - do NOT use it to query other entities. For querying other entity types, use their respective query tools. Query syntax: SELECT [fields] FROM Department [WHERE conditions] [ORDERBY field] [STARTPOSITION n] [MAXRESULTS n] NOTE: QuickBooks API returns ALL fields with values regardless of SELECT clause - field projections are not supported. You can write 'SELECT Id, Name' but the API will return all available fields anyway. Commonly queryable Department fields: Id, Name, Active, FullyQualifiedName, SubDepartment, ParentRef, SyncToken. Supports: - WHERE clauses with operators (=, <, >, <=, >=, IN) - LIKE operator with % wildcard - Boolean operators (AND, OR) - ORDERBY for sorting - Pagination with MAXRESULTS (max 1000, default 100) and STARTPOSITION - Aggregate functions (COUNT)
Quickbooks List Invoices
Quickbooks List InvoicesIntegration name: QUICKBOOKS_LIST_INVOICES
Tool to list invoices via QuickBooks Query endpoint. Use when retrieving invoices with optional pagination and custom fields.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
fields
array
["Id","DocNumber","TotalAmt"]
List of fields to select in the query. Defaults to ['Id','SyncToken','DocNumber','TotalAmt','Balance','TxnDate'].
max_results
integer
50
Maximum number of records to return; default 50, max 1000.
start_position
integer
1
Starting position for pagination within the result set. Default is 1.
Quickbooks Query Account
Quickbooks Query AccountIntegration name: QUICKBOOKS_QUERY_ACCOUNT
Query 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')
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
query
string
✅
"SELECT * FROM Account"
SQL-like query string to filter and retrieve Account entities ONLY. Do NOT use for other entities (Purchase, Invoice, Bill, etc.) - use their respective query tools. Query syntax: SELECT [fields] FROM Account [WHERE conditions] [ORDER BY field] [STARTPOSITION n] [MAXRESULTS n] CRITICAL SYNTAX RESTRICTIONS: - Parentheses for grouping are NOT supported - OR operator is NOT supported - use IN instead - Use: WHERE Active = true AND AccountType IN ('Bank', 'Credit Card') NOTE: QuickBooks API returns ALL fields regardless of SELECT clause. Commonly queryable fields: Id, Name, AccountType, AccountSubType, Classification, Active, FullyQualifiedName, CurrentBalance, AcctNum, Description, SubAccount. Supports: - WHERE with operators (=, <, >, <=, >=, IN) - LIKE with % wildcard - AND only (no OR - use IN for multiple values) - ORDER BY for sorting (MUST be two words, not 'ORDERBY'). Sortable fields: Name, Id. Non-sortable: AccountType, AccountSubType, Classification, and others. - MAXRESULTS (max 1000, default 100) and STARTPOSITION - COUNT
Quickbooks Query Attachable
Quickbooks Query AttachableIntegration name: QUICKBOOKS_QUERY_ATTACHABLE
Query Attachable entities in QuickBooks using SQL-like syntax. Use when you need to retrieve multiple attachables or search for specific file attachments.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
query
string
"SELECT * FROM Attachable"
SQL-like query string to filter and retrieve Attachable entities ONLY. IMPORTANT: This tool queries the Attachable entity exclusively - do NOT use it to query other entities like Purchase, Invoice, Bill, Payment, etc. For querying other entity types, use their respective query tools. Query syntax: SELECT [fields] FROM Attachable [WHERE conditions] [ORDERBY field] [STARTPOSITION n] [MAXRESULTS n] NOTE: QuickBooks API returns ALL fields with values regardless of SELECT clause - field projections are not supported. You can write 'SELECT Id, FileName' but the API will return all available fields anyway. Commonly queryable Attachable fields: Id, FileName, Note, Category, ContentType, Size, FileAccessUri, TempDownloadUri. Supports: - WHERE clauses with operators (=, <, >, <=, >=, IN) - LIKE operator with % wildcard - Boolean operators (AND, OR) - ORDERBY for sorting - Pagination with MAXRESULTS (max 1000, default 100) and STARTPOSITION - Aggregate functions (COUNT)
Quickbooks Query Entities
Quickbooks Query EntitiesIntegration name: QUICKBOOKS_QUERY_ENTITIES
Execute 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
query
string
✅
"SELECT * FROM Customer MAXRESULTS 5"
SQL-like query string to retrieve data from QuickBooks Online entities. Generic query tool supporting all entity types: Customer, Invoice, Bill, Payment, Purchase, Account, Vendor, Employee, Item, and more. Query syntax: SELECT [fields] FROM [EntityName] [WHERE conditions] [ORDERBY field] [STARTPOSITION n] [MAXRESULTS n] NOTE: QuickBooks API returns ALL fields regardless of SELECT clause - field projections are not supported. Supported operators: = < > <= >= != LIKE (% wildcard) IN AND ORDERBY MAXRESULTS (max 1000, default 100) STARTPOSITION COUNT. CRITICAL: OR operator is NOT supported for most QuickBooks entities (including Item, Account, and many others). If you attempt to use OR in a query, the API will return a QueryParserError. Use IN operator instead for matching multiple specific values (e.g., 'WHERE Id IN ("1", "2", "3")' instead of 'WHERE Id = "1" OR Id = "2"'). For pattern matching across multiple terms with LIKE (e.g., finding items containing 'Larkspur' in FullyQualifiedName OR Description), query without the WHERE clause or with a broader filter, then filter results client-side. CRITICAL QUERY FIELD RESTRICTIONS: Top-level entity references like CustomerRef, VendorRef are queryable on transactions (e.g., 'SELECT * FROM Invoice WHERE CustomerRef = "123"'). NON-QUERYABLE fields: PrivateNote, AccountRef, CurrencyRef, DepartmentRef, ClassRef on any entity; nested references like Line[].ItemRef. Using these in WHERE causes QueryValidationError. WORKAROUND: Query by date range and filter results client-side, or use entity-specific GET actions. Purchase entity queryable fields: Id, TxnDate, PaymentType, DocNumber, TotalAmt, PrintStatus. NOT queryable: AccountRef, CurrencyRef, DepartmentRef, ClassRef, PrivateNote. These lists are common examples, not exhaustive. Consult the QuickBooks API documentation or test incrementally to discover all queryable fields. Reference fields are generally NOT queryable unless explicitly documented. IMPORTANT: Use entity-specific query tools when available (e.g., QueryAccount for Account entities) as they provide typed responses. This generic tool returns untyped data and should be used only when no specific query tool exists.
Quickbooks Read Account
Quickbooks Read AccountIntegration name: QUICKBOOKS_READ_ACCOUNT
Read an account in QuickBooks with the given account ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
account_id
string
✅
—
ID of the account to be read
Quickbooks Read Class
Quickbooks Read ClassIntegration name: QUICKBOOKS_READ_CLASS
Read details of a specific class by ID in QuickBooks Online. Classes allow categorization of transactions.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
class_id
string
✅
—
ID of the class to be read
minorversion
integer
75
API minor version to use for the request. If not provided, uses the version from metadata headers.
Quickbooks Read Customer
Quickbooks Read CustomerIntegration name: QUICKBOOKS_READ_CUSTOMER
Read a customer in QuickBooks with the given customer ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
customer_id
string
✅
—
ID of the customer to be read Must be the QuickBooks-assigned numeric system ID, not a customer display name or free-text identifier.
Quickbooks Read Employee
Quickbooks Read EmployeeIntegration name: QUICKBOOKS_READ_EMPLOYEE
Read an employee's details in QuickBooks with the given employee ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
employee_id
string
✅
—
The ID of the employee to be read.
Quickbooks Read Invoice
Quickbooks Read InvoiceIntegration name: QUICKBOOKS_READ_INVOICE
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
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
invoice_id
string
"12345"
ID of the invoice to read; if not provided, fetches the latest invoice
minorversion
integer
65
API minor version to use for the request
Quickbooks Read Vendor
Quickbooks Read VendorIntegration name: QUICKBOOKS_READ_VENDOR
Read a vendor in QuickBooks with the given vendor ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
vendor_id
string
✅
—
ID of the vendor to be read
Quickbooks Send Credit Memo
Quickbooks Send Credit MemoIntegration name: QUICKBOOKS_SEND_CREDIT_MEMO
Tool to send a credit memo to a specified email address. Use when you need to email a credit memo to a customer.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
send_to
string
"test@example.com"
Optional email address to send the credit memo to. If not provided, sends to the customer's default email.
minorversion
integer
—
QuickBooks API minor version number (e.g., 65, 70, 75). If not specified, uses the default version from headers.
credit_memo_id
string
✅
"14"
The ID of the credit memo to send
Quickbooks Update Attachable
Quickbooks Update AttachableIntegration name: QUICKBOOKS_UPDATE_ATTACHABLE
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
—
The ID of the attachable to update.
Lat
string
—
Latitude coordinate where the file was created.
Tag
string
—
Tag string for the attachable.
Long
string
—
Longitude coordinate where the file was created.
Note
string
—
Note text for the attachable.
Category
string
—
Category of the attachable (e.g., Image, Document, Sound, Receipt, Other, etc.).
PlaceName
string
—
Name of the place where the file was created.
SyncToken
string
✅
—
The current SyncToken value for optimistic locking. Must match the latest value from QuickBooks.
AttachableRef
array
—
Array of references to entities this attachable is linked to.
Quickbooks Update Company Info
Quickbooks Update Company InfoIntegration name: QUICKBOOKS_UPDATE_COMPANY_INFO
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
—
Unique identifier of the company info object. Typically '1' for the company record.
Email
object
—
Email address structure.
Country
string
—
Country where the company is registered (e.g., US, CA, UK).
WebAddr
object
—
Website address structure.
LegalAddr
object
—
Company address structure for update requests.
LegalName
string
—
Legal name of the company.
NameValue
array
—
List of name-value pairs containing additional company attributes.
SyncToken
string
✅
—
Version number for optimistic locking. Must match current value to prevent concurrent update conflicts.
CompanyAddr
object
✅
—
Company address object. Required for updates and must include PostalCode.
CompanyName
string
—
Name of the company. Optional for partial updates.
PrimaryPhone
object
—
Telephone number structure.
CompanyStartDate
string
—
Date when the company started business, in YYYY-MM-DD format.
SupportedLanguages
string
—
Comma-separated list of languages supported by the company.
FiscalYearStartMonth
string
—
Starting month of the company's fiscal year (e.g., January, February).
CustomerCommunicationAddr
object
—
Company address structure for update requests.
CustomerCommunicationEmailAddr
object
—
Email address structure.
Quickbooks Update Department
Quickbooks Update DepartmentIntegration name: QUICKBOOKS_UPDATE_DEPARTMENT
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
—
The unique identifier of the department to update. Required for update operations.
Name
string
✅
—
Updated name of the department. Maximum length is 100 characters.
Active
boolean
—
Whether the department is active. Inactive departments may be hidden from most display purposes.
sparse
boolean
—
Set to true to perform a partial update (only specified fields are updated). Defaults to true for update operations.
ParentRef
object
—
Reference to the parent department if this is a sub-department. Contains 'value' (ID) and optionally 'name'.
SyncToken
string
✅
—
Version token for optimistic locking, obtained from a prior GET request. Prevents concurrent update conflicts.
SubDepartment
boolean
—
Whether this department is a sub-department. If true, ParentRef should be provided.
Quickbooks Update Full Invoice
Quickbooks Update Full InvoiceIntegration name: QUICKBOOKS_UPDATE_FULL_INVOICE
Tool to fully replace an Invoice. Use when you need to update all aspects of an existing invoice in a single operation.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
invoice
object
✅
—
Full Invoice JSON payload to update; must include Id and SyncToken. Any writable field omitted will be cleared. Do not set sparse=true.
requestid
string
—
Optional idempotency key (<=50 chars) to prevent duplicate writes on retries.
minorversion
integer
—
Optional QuickBooks API minorversion to access newer fields (e.g., 63).
Quickbooks Update Payment Method
Quickbooks Update Payment MethodIntegration name: QUICKBOOKS_UPDATE_PAYMENT_METHOD
Tool to update an existing payment method in QuickBooks Online. Use when you need to modify the name, status, or type of a payment method. Requires the payment method Id and current SyncToken.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
"2"
Unique identifier of the payment method to update. Required for updates.
Name
string
✅
"Business Check-Updated"
User-recognizable name for the payment method (e.g., 'Business Check', 'Cash', 'Credit Card'). Maximum length is 31 characters.
Type
string
"NON_CREDIT_CARD"
Type of payment method. Valid values: 'CREDIT_CARD', 'NON_CREDIT_CARD'. If not specified, defaults to 'NON_CREDIT_CARD'.
Active
boolean
—
Whether the payment method is active. Default is true.
SyncToken
string
✅
"0"
Version number for optimistic locking. Must match the current version in QuickBooks to prevent conflicts. Required for updates.
Quickbooks Update Preferences
Quickbooks Update PreferencesIntegration name: QUICKBOOKS_UPDATE_PREFERENCES
Update 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
—
ID of the preferences object, typically '1' for company preferences.
sparse
boolean
—
Set to true for sparse (partial) update, updating only provided fields. Set to false or omit for full update.
TaxPrefs
object
—
Tax preferences.
SyncToken
string
✅
—
Version number for optimistic locking. Required to prevent concurrent update conflicts.
OtherPrefs
object
—
Other miscellaneous preferences.
ReportPrefs
object
—
Report preferences.
minorversion
integer
—
QuickBooks API minor version to use (e.g., 65, 70, 75). Uses default if not specified.
CurrencyPrefs
object
—
Currency preferences.
SalesFormsPrefs
object
—
Sales forms preferences.
TimeTrackingPrefs
object
—
Time tracking preferences.
EmailMessagesPrefs
object
—
Email message preferences for various transaction types.
AccountingInfoPrefs
object
—
Accounting information preferences.
ProductAndServicesPrefs
object
—
Product and services preferences.
VendorAndPurchasesPrefs
object
—
Vendor and purchases preferences.
Quickbooks Update Sparse Invoice
Quickbooks Update Sparse InvoiceIntegration name: QUICKBOOKS_UPDATE_SPARSE_INVOICE
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
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
invoice
object
✅
—
Invoice object containing Id, SyncToken, sparse flag, and fields to update
Quickbooks Update Term
Quickbooks Update TermIntegration name: QUICKBOOKS_UPDATE_TERM
Tool to update an existing payment term in QuickBooks Online. Use when you need to modify the name, status, type, or payment conditions of a payment term. Requires the payment term Id and current SyncToken.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
"1"
Unique identifier of the payment term to update. Required for updates.
Name
string
✅
"Net 30"
User-recognizable name for the payment term (e.g., 'Net 30', 'Due on receipt'). Maximum length 31 characters.
Type
string
✅
"STANDARD"
Type of the sales term. Valid values: 'STANDARD' (if dueDays is not null) or 'DATEDRIVEN' (if dueDays is null).
Active
boolean
—
Whether the payment term is active. Default is true.
DueDays
integer
0
Number of days until payment is due. If specified, Type should be 'STANDARD'. Use 0 for 'Due on receipt'.
SyncToken
string
✅
"0"
Version number for optimistic locking. Must match the current version in QuickBooks to prevent conflicts. Required for updates.
DiscountDays
integer
0
Number of days within which payment must be made to receive the discount. Used with discount_percent for early payment discounts.
DayOfMonthDue
integer
—
Specific day of the month when payment is due. Used for DATEDRIVEN type terms. Valid range: 1-31.
DiscountPercent
number
0
Discount percentage available if paid within the discount days. Valid range: 0 to 100.
DueNextMonthDays
integer
—
Number of days in the month before the due date shifts to the next month. Used for DATEDRIVEN type terms.
DiscountDayOfMonth
integer
—
Specific day of the month when discount is available. Used for DATEDRIVEN type terms. Valid range: 1-31.
Quickbooks Update Transfer
Quickbooks Update TransferIntegration name: QUICKBOOKS_UPDATE_TRANSFER
Tool 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.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
Id
string
✅
—
The unique identifier of the transfer to update. Required for update operations.
Amount
string
✅
—
The monetary amount to transfer between accounts. Specified as a string (e.g., '35.00').
TxnDate
string
—
The date of the transfer transaction in YYYY-MM-DD format. Defaults to current date if not specified.
SyncToken
string
✅
—
Version token for optimistic locking, obtained from a prior GET request. Prevents concurrent update conflicts.
CurrencyRef
object
—
Reference to a currency for multi-currency transactions.
PrivateNote
string
—
Internal note about the transfer that is not visible to customers.
ExchangeRate
—
—
Exchange rate for multi-currency transactions. Default is 1 for home currency. Only applicable when using non-home currency.
ToAccountRef
object
✅
—
Reference to the destination account to which funds are transferred.
DepartmentRef
object
—
Reference to a department for location tracking.
FromAccountRef
object
✅
—
Reference to the source account from which funds are transferred.
Quickbooks Vendor Balance Detail
Quickbooks Vendor Balance DetailIntegration name: QUICKBOOKS_VENDOR_BALANCE_DETAIL
Generate a balance detail report for a vendor in QuickBooks with the given vendor ID.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
arpaid
string
—
Filter by payment status. Use 'All' for all balances, 'Paid' for fully paid balances, or 'Unpaid' for outstanding balances.
columns
string
—
Column types to be shown in the report. Supported Values: bill_addr, create_by, create_date, vend_bill_email, vend_comp_name, vend_msg, vend_phone_other, vend_tel, vend_name, deliv_addr, doc_num*, due_date*, last_mod_by, last_mod_date, memo*, vendor_sent_state, ship_addr, ship_date, term_name, tracking_num, tx_date*, txn_type*. Additional columns with custom fields enabled: purchase_vend1, purchase_vend2, purchase_vend3. Additional columns with location tracking enabled: dept_name*
sort_by
string
—
The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
term_ids
array
—
One or more comma separated term IDs. Filters report contents based on term or terms supplied.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
vendor_ids
array
—
One or more comma separated vendor IDs. Filters report contents to include information for specified vendors.
end_duedate
string
—
The 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.
num_periods
integer
—
Number of aging periods to display in the report. Each period represents a time bucket for aging calculations (e.g., 0-30 days, 31-60 days).
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
aging_method
string
—
Method for calculating age of payables. 'Report_Date' calculates age based on the report date, while 'Current' calculates age based on the current date.
aging_period
integer
—
Number of days per aging period. Default is typically 30 days. For example, setting this to 30 creates buckets like 0-30, 31-60, 61-90 days.
duedate_macro
string
—
Predefined 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.
start_duedate
string
—
The 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.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
Quickbooks Vendor Balance Report
Quickbooks Vendor Balance ReportIntegration name: QUICKBOOKS_VENDOR_BALANCE_REPORT
Retrieve a vendor balance report from QuickBooks showing outstanding balances for vendors. This report displays the total amount owed to each vendor, providing a summary of accounts payable. You can filter by specific vendors, date ranges, payment status, and customize the report with various grouping and sorting options.
Parameters
Your Toolhouse AI worker will automatically pass these parameters as input when the tool is called.
qzurl
string
—
Specifies whether Quick Zoom URL information should be generated for rows in the report.
appaid
string
—
Filters vendors by payment status. Use 'All' for all vendors, 'Paid' for vendors with fully paid balances, or 'Unpaid' for vendors with outstanding balances.
date_macro
string
—
Predefined 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.
sort_order
string
—
The sort order.
vendor_ids
array
—
Filters 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 code.
report_date
string
—
Start date to use for the report, in the format YYYY-MM-DD.
department_ids
array
—
One or more comma separated department IDs. Filters report contents to include information for specified departments if so configured in the company file.
accounting_method
string
—
The accounting method used in the report.
summarize_column_by
string
—
The criteria by which to group the report results.