For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

DisplayName

string

✅

"California State Tax Agency"

The name of the tax agency as displayed in QuickBooks. Must be unique.


Quickbooks Create Taxservice Taxcode

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

minorversion

integer

75

API minor version to use for the request. If not provided, uses the version from metadata headers.


Quickbooks Get Credit Memo

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

department_id

string

✅

—

The ID of the department to retrieve.


Quickbooks Get Deposit

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

payment_method_id

string

✅

—

ID of the payment method to be read


Quickbooks Get Payment Pdf

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

term_id

string

✅

—

The ID of the payment term to retrieve.


Quickbooks Get Time Activity

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

account_id

string

✅

—

ID of the account to be read


Quickbooks Read Class

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

employee_id

string

✅

—

The ID of the employee to be read.


Quickbooks Read Invoice

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

vendor_id

string

✅

—

ID of the vendor to be read


Quickbooks Send Credit Memo

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

invoice

object

✅

—

Invoice object containing Id, SyncToken, sparse flag, and fields to update


Quickbooks Update Term

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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

Integration 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.

Parameter
Type
Required
Example
Description

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.