/quickbooks | Type: Application | PCID required: Yes
Tools
| Tool | Description |
|---|---|
quickbooks_create_account | Create a new account in QuickBooks Online |
quickbooks_create_attachable | Create a new Attachable in QuickBooks Online |
quickbooks_create_bill | Create a new bill in QuickBooks Online |
quickbooks_create_billpayment | Create a new bill payment in QuickBooks Online |
quickbooks_create_class | Create a new Class in QuickBooks Online |
quickbooks_create_credit_memo | Create a new credit memo in QuickBooks Online |
quickbooks_create_customer | Create a new customer in QuickBooks Online |
quickbooks_create_department | Create a new Department in QuickBooks Online |
quickbooks_create_deposit | Create a new Deposit in QuickBooks Online |
quickbooks_create_employee | Create a new employee in QuickBooks Online |
quickbooks_create_estimate | Create a new estimate in QuickBooks Online |
quickbooks_create_invoice | Create a new invoice in QuickBooks Online |
quickbooks_create_item | Create a new item in QuickBooks Online |
quickbooks_create_journal_entry | Create a new JournalEntry in QuickBooks Online |
quickbooks_create_payment | Create a new payment in QuickBooks Online |
quickbooks_create_payment_method | Create a new PaymentMethod in QuickBooks Online |
quickbooks_create_purchase | Create a new purchase in QuickBooks Online |
quickbooks_create_purchase_order | Create a new purchase order in QuickBooks Online |
quickbooks_create_refund_receipt | Create a new refund receipt in QuickBooks Online |
quickbooks_create_sales_receipt | Create a new sales receipt in QuickBooks Online |
quickbooks_create_term | Create a new Term in QuickBooks Online |
quickbooks_create_time_activity | Create a new TimeActivity in QuickBooks Online |
quickbooks_create_transfer | Create a new Transfer in QuickBooks Online |
quickbooks_create_vendor | Create a new vendor in QuickBooks Online |
quickbooks_create_vendor_credit | Create a new vendor credit in QuickBooks Online |
quickbooks_delete_attachable | Delete a Attachable from QuickBooks Online |
quickbooks_delete_bill | Delete a bill from QuickBooks Online |
quickbooks_delete_billpayment | Delete a bill payment from QuickBooks Online |
quickbooks_delete_credit_memo | Delete a credit memo from QuickBooks Online |
quickbooks_delete_customer | Deactivate (soft-delete) a customer in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of customers. |
quickbooks_delete_deposit | Delete a Deposit from QuickBooks Online |
quickbooks_delete_employee | Deactivate (soft-delete) an employee in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of employees. |
quickbooks_delete_estimate | Delete an estimate from QuickBooks Online |
quickbooks_delete_invoice | Delete an invoice from QuickBooks Online |
quickbooks_delete_item | Deactivate (soft-delete) an item in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of items. |
quickbooks_delete_journal_entry | Delete a JournalEntry from QuickBooks Online |
quickbooks_delete_payment | Delete a payment from QuickBooks Online |
quickbooks_delete_purchase | Delete a purchase from QuickBooks Online |
quickbooks_delete_purchase_order | Delete a purchase order from QuickBooks Online |
quickbooks_delete_refund_receipt | Delete a refund receipt from QuickBooks Online |
quickbooks_delete_sales_receipt | Delete a sales receipt from QuickBooks Online |
quickbooks_delete_time_activity | Delete a TimeActivity from QuickBooks Online |
quickbooks_delete_transfer | Delete a Transfer from QuickBooks Online |
quickbooks_delete_vendor | Deactivate (soft-delete) a vendor in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of vendors. |
quickbooks_delete_vendor_credit | Delete a vendor credit from QuickBooks Online |
quickbooks_get_account | Get an account by ID from QuickBooks Online |
quickbooks_get_aged_payables_report | Generate an Aged Payables (A/P Aging Summary) report from QuickBooks Online |
quickbooks_get_aged_receivable_detail_report | Generate an Aged Receivable Detail report from QuickBooks Online |
quickbooks_get_aged_receivables_report | Generate an Aged Receivables (A/R Aging Summary) report from QuickBooks Online |
quickbooks_get_attachable | Get a Attachable by ID from QuickBooks Online |
quickbooks_get_balance_sheet_report | Generate a Balance Sheet report from QuickBooks Online |
quickbooks_get_bill | Get a bill by ID from QuickBooks Online |
quickbooks_get_billpayment | Get a bill payment by ID from QuickBooks Online |
quickbooks_get_cash_flow_report | Generate a Statement of Cash Flows report from QuickBooks Online |
quickbooks_get_class | Get a Class by ID from QuickBooks Online |
quickbooks_get_company_info | Get company information from QuickBooks Online |
quickbooks_get_credit_memo | Get a credit memo by ID from QuickBooks Online |
quickbooks_get_customer | Get a customer by ID from QuickBooks Online |
quickbooks_get_customer_balance_report | Generate a Customer Balance Summary report from QuickBooks Online |
quickbooks_get_customer_sales_report | Generate a Sales by Customer Summary report from QuickBooks Online |
quickbooks_get_department | Get a Department by ID from QuickBooks Online |
quickbooks_get_deposit | Get a Deposit by ID from QuickBooks Online |
quickbooks_get_employee | Get an employee by ID from QuickBooks Online |
quickbooks_get_estimate | Get an estimate by ID from QuickBooks Online |
quickbooks_get_general_ledger_report | Generate a General Ledger report from QuickBooks Online |
quickbooks_get_invoice | Get an invoice by ID from QuickBooks Online |
quickbooks_get_item | Get an item by ID from QuickBooks Online |
quickbooks_get_journal_entry | Get a JournalEntry by ID from QuickBooks Online |
quickbooks_get_payment | Get a payment by ID from QuickBooks Online |
quickbooks_get_payment_method | Get a PaymentMethod by ID from QuickBooks Online |
quickbooks_get_profit_and_loss_report | Generate a Profit and Loss (Income Statement) report from QuickBooks Online |
quickbooks_get_purchase | Get a purchase by ID from QuickBooks Online |
quickbooks_get_purchase_order | Get a purchase order by ID from QuickBooks Online |
quickbooks_get_refund_receipt | Get a refund receipt by ID from QuickBooks Online |
quickbooks_get_sales_receipt | Get a sales receipt by ID from QuickBooks Online |
quickbooks_get_tax_agency | Get a TaxAgency by ID from QuickBooks Online |
quickbooks_get_tax_code | Get a TaxCode by ID from QuickBooks Online |
quickbooks_get_tax_rate | Get a TaxRate by ID from QuickBooks Online |
quickbooks_get_term | Get a Term by ID from QuickBooks Online |
quickbooks_get_time_activity | Get a TimeActivity by ID from QuickBooks Online |
quickbooks_get_transfer | Get a Transfer by ID from QuickBooks Online |
quickbooks_get_trial_balance_report | Generate a Trial Balance report from QuickBooks Online |
quickbooks_get_vendor | Get a vendor by ID from QuickBooks Online |
quickbooks_get_vendor_credit | Get a vendor credit by ID from QuickBooks Online |
quickbooks_get_vendor_expenses_report | Generate a Vendor Expenses report from QuickBooks Online |
quickbooks_query_account | Query accounts in QuickBooks Online using SQL-like syntax |
quickbooks_query_attachables | Query attachables in QuickBooks Online using a SQL-like query string |
quickbooks_query_billpayments | Query bill payments in QuickBooks Online using a SQL-like query string |
quickbooks_query_bills | Query bills in QuickBooks Online using a SQL-like query string |
quickbooks_query_classes | Query classes in QuickBooks Online using a SQL-like query string |
quickbooks_query_credit_memo | Query credit memos in QuickBooks Online using SQL-like syntax |
quickbooks_query_customers | Query customers in QuickBooks Online using a SQL-like query string |
quickbooks_query_departments | Query departments in QuickBooks Online using a SQL-like query string |
quickbooks_query_deposits | Query deposits in QuickBooks Online using a SQL-like query string |
quickbooks_query_employees | Query employees in QuickBooks Online using a SQL-like query string |
quickbooks_query_estimates | Query estimates in QuickBooks Online using a SQL-like query string |
quickbooks_query_invoices | Query invoices in QuickBooks Online using a SQL-like query string |
quickbooks_query_item | Query items in QuickBooks Online using SQL-like syntax |
quickbooks_query_journal_entries | Query journal entries in QuickBooks Online using a SQL-like query string |
quickbooks_query_payment_methods | Query payment methods in QuickBooks Online using a SQL-like query string |
quickbooks_query_payments | Query payments in QuickBooks Online using a SQL-like query string |
quickbooks_query_purchase | Query purchases in QuickBooks Online using SQL-like syntax |
quickbooks_query_purchase_order | Query purchase orders in QuickBooks Online using SQL-like syntax |
quickbooks_query_refund_receipt | Query refund receipts in QuickBooks Online using SQL-like syntax |
quickbooks_query_sales_receipt | Query sales receipts in QuickBooks Online using SQL-like syntax |
quickbooks_query_tax_agencies | Query tax agencies in QuickBooks Online using a SQL-like query string |
quickbooks_query_tax_codes | Query tax codes in QuickBooks Online using a SQL-like query string |
quickbooks_query_tax_rates | Query tax rates in QuickBooks Online using a SQL-like query string |
quickbooks_query_terms | Query terms in QuickBooks Online using a SQL-like query string |
quickbooks_query_time_activities | Query time activities in QuickBooks Online using a SQL-like query string |
quickbooks_query_transfers | Query transfers in QuickBooks Online using a SQL-like query string |
quickbooks_query_vendor_credit | Query vendor credits in QuickBooks Online using SQL-like syntax |
quickbooks_query_vendors | Query vendors in QuickBooks Online using a SQL-like query string |
quickbooks_update_account | Update an existing account in QuickBooks Online |
quickbooks_update_attachable | Update an existing Attachable in QuickBooks Online. The full Attachable object including Id and SyncToken must be provided. |
quickbooks_update_bill | Update an existing bill in QuickBooks Online. The full bill object including Id and SyncToken must be provided. |
quickbooks_update_billpayment | Update an existing bill payment in QuickBooks Online. The full bill payment object including Id and SyncToken must be provided. |
quickbooks_update_class | Update an existing Class in QuickBooks Online. The full Class object including Id and SyncToken must be provided. |
quickbooks_update_company_info | Update company information in QuickBooks Online. The full CompanyInfo object including Id and SyncToken must be provided. |
quickbooks_update_credit_memo | Update an existing credit memo in QuickBooks Online |
quickbooks_update_customer | Update an existing customer in QuickBooks Online. The full customer object including Id and SyncToken must be provided. |
quickbooks_update_department | Update an existing Department in QuickBooks Online. The full Department object including Id and SyncToken must be provided. |
quickbooks_update_deposit | Update an existing Deposit in QuickBooks Online. The full Deposit object including Id and SyncToken must be provided. |
quickbooks_update_employee | Update an existing employee in QuickBooks Online. The full employee object including Id and SyncToken must be provided. |
quickbooks_update_estimate | Update an existing estimate in QuickBooks Online. The full estimate object including Id and SyncToken must be provided. |
quickbooks_update_invoice | Update an existing invoice in QuickBooks Online. The full invoice object including Id and SyncToken must be provided. |
quickbooks_update_item | Update an existing item in QuickBooks Online |
quickbooks_update_journal_entry | Update an existing JournalEntry in QuickBooks Online. The full JournalEntry object including Id and SyncToken must be provided. |
quickbooks_update_payment | Update an existing payment in QuickBooks Online. The full payment object including Id and SyncToken must be provided. |
quickbooks_update_payment_method | Update an existing PaymentMethod in QuickBooks Online. The full PaymentMethod object including Id and SyncToken must be provided. |
quickbooks_update_purchase | Update an existing purchase in QuickBooks Online |
quickbooks_update_purchase_order | Update an existing purchase order in QuickBooks Online |
quickbooks_update_refund_receipt | Update an existing refund receipt in QuickBooks Online |
quickbooks_update_sales_receipt | Update an existing sales receipt in QuickBooks Online |
quickbooks_update_term | Update an existing Term in QuickBooks Online. The full Term object including Id and SyncToken must be provided. |
quickbooks_update_time_activity | Update an existing TimeActivity in QuickBooks Online. The full TimeActivity object including Id and SyncToken must be provided. |
quickbooks_update_transfer | Update an existing Transfer in QuickBooks Online. The full Transfer object including Id and SyncToken must be provided. |
quickbooks_update_vendor | Update an existing vendor in QuickBooks Online. The full vendor object including Id and SyncToken must be provided. |
quickbooks_update_vendor_credit | Update an existing vendor credit in QuickBooks Online |
quickbooks_create_account
Create a new account in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
account | object | Yes | — | Account object. Required: Name, AccountType. Optional: AccountSubType, Description. |
quickbooks_create_attachable
Create a new Attachable in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
attachable | object | Yes | — | Attachable metadata object. Optional: FileName, ContentType, AttachableRef. |
quickbooks_create_bill
Create a new bill in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
bill | object | Yes | — | Bill object. Required fields: VendorRef, Line (array of line items). Optional: DueDate, TxnDate, APAccountRef, etc. |
quickbooks_create_billpayment
Create a new bill payment in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
billPayment | object | Yes | — | BillPayment object. Required fields: VendorRef, TotalAmt, PayType, Line (linked bills). Optional: CheckPayment or CreditCardPayment details, TxnDate, etc. |
quickbooks_create_class
Create a new Class in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
class | object | Yes | — | Class object. Required: Name. |
quickbooks_create_credit_memo
Create a new credit memo in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
creditMemo | object | Yes | — | Credit memo object. Required: CustomerRef, Line array. |
quickbooks_create_customer
Create a new customer in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
customer | object | Yes | — | Customer object. Required fields: DisplayName. Optional: PrimaryEmailAddr, PrimaryPhone, CompanyName, BillAddr, etc. |
quickbooks_create_department
Create a new Department in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
department | object | Yes | — | Department object. Required: Name. |
quickbooks_create_deposit
Create a new Deposit in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
deposit | object | Yes | — | Deposit object. Required: DepositToAccountRef, Line array. |
quickbooks_create_employee
Create a new employee in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
employee | object | Yes | — | Employee object. Required fields: GivenName, FamilyName. Optional: PrimaryEmailAddr, PrimaryPhone, DisplayName, SSN, BillAddr, etc. |
quickbooks_create_estimate
Create a new estimate in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
estimate | object | Yes | — | Estimate object. Required fields: CustomerRef, Line (array of line items). Optional: TxnDate, ExpirationDate, BillEmail, etc. |
quickbooks_create_invoice
Create a new invoice in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
invoice | object | Yes | — | Invoice object. Required fields: CustomerRef, Line (array of line items). Optional: DueDate, TxnDate, BillEmail, etc. |
quickbooks_create_item
Create a new item in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
item | object | Yes | — | Item object. Required: Name, Type (Inventory/Service/NonInventory). For Inventory: IncomeAccountRef, ExpenseAccountRef, AssetAccountRef, QtyOnHand, InvStartDate required. |
quickbooks_create_journal_entry
Create a new JournalEntry in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
journal_entry | object | Yes | — | Journal entry object. Required: Line array with JournalEntryLineDetail. |
quickbooks_create_payment
Create a new payment in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
payment | object | Yes | — | Payment object. Required fields: CustomerRef, TotalAmt. Optional: PaymentMethodRef, DepositToAccountRef, Line (linked transactions), TxnDate, etc. |
quickbooks_create_payment_method
Create a new PaymentMethod in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
payment_method | object | Yes | — | Payment method object. Required: Name. |
quickbooks_create_purchase
Create a new purchase in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchase | object | Yes | — | Purchase object. Required: PaymentType (Cash/Check/CreditCard), AccountRef, Line array. |
quickbooks_create_purchase_order
Create a new purchase order in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchaseOrder | object | Yes | — | Purchase order object. Required: VendorRef, Line array, APAccountRef. |
quickbooks_create_refund_receipt
Create a new refund receipt in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
refundReceipt | object | Yes | — | Refund receipt object. Required: Line array. |
quickbooks_create_sales_receipt
Create a new sales receipt in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
salesReceipt | object | Yes | — | Sales receipt object. Required: Line array with at least one line item. |
quickbooks_create_term
Create a new Term in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
term | object | Yes | — | Term object. Required: Name, DueDays. |
quickbooks_create_time_activity
Create a new TimeActivity in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
time_activity | object | Yes | — | Time activity object. Required: NameOf (Employee/Vendor), ActivityType. |
quickbooks_create_transfer
Create a new Transfer in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
transfer | object | Yes | — | Transfer object. Required: FromAccountRef, ToAccountRef, Amount. |
quickbooks_create_vendor
Create a new vendor in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendor | object | Yes | — | Vendor object. Required fields: DisplayName. Optional: PrimaryEmailAddr, PrimaryPhone, CompanyName, BillAddr, etc. |
quickbooks_create_vendor_credit
Create a new vendor credit in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendorCredit | object | Yes | — | Vendor credit object. Required: VendorRef, Line array. |
quickbooks_delete_attachable
Delete a Attachable from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The Attachable ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_bill
Delete a bill from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The bill ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_billpayment
Delete a bill payment from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The bill payment ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_credit_memo
Delete a credit memo from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The credit memo ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_customer
Deactivate (soft-delete) a customer in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of customers. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The customer ID |
syncToken | string | Yes | — | The sync token for concurrency control |
displayName | string | Yes | — | The customer display name (required by QuickBooks update API) |
quickbooks_delete_deposit
Delete a Deposit from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The Deposit ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_employee
Deactivate (soft-delete) an employee in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of employees. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The employee ID |
syncToken | string | Yes | — | The sync token for concurrency control |
displayName | string | Yes | — | The employee display name (required by QuickBooks update API) |
quickbooks_delete_estimate
Delete an estimate from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The estimate ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_invoice
Delete an invoice from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The invoice ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_item
Deactivate (soft-delete) an item in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of items. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The item ID |
syncToken | string | Yes | — | The sync token for concurrency control |
name | string | Yes | — | The item name (required by QuickBooks update API) |
quickbooks_delete_journal_entry
Delete a JournalEntry from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The JournalEntry ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_payment
Delete a payment from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The payment ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_purchase
Delete a purchase from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The purchase ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_purchase_order
Delete a purchase order from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The purchase order ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_refund_receipt
Delete a refund receipt from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The refund receipt ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_sales_receipt
Delete a sales receipt from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The sales receipt ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_time_activity
Delete a TimeActivity from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The TimeActivity ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_transfer
Delete a Transfer from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The Transfer ID |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_delete_vendor
Deactivate (soft-delete) a vendor in QuickBooks Online by setting Active: false. QuickBooks does not support hard-deletion of vendors. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The vendor ID |
syncToken | string | Yes | — | The sync token for concurrency control |
displayName | string | Yes | — | The vendor display name (required by QuickBooks update API) |
quickbooks_delete_vendor_credit
Delete a vendor credit from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
id | string | Yes | — | The vendor credit ID to delete |
syncToken | string | Yes | — | The sync token for concurrency control |
quickbooks_get_account
Get an account by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
accountId | string | Yes | — | The account ID |
quickbooks_get_aged_payables_report
Generate an Aged Payables (A/P Aging Summary) report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
report_date | string | No | — | As-of date in YYYY-MM-DD format |
vendor | string | No | — | Filter by vendor ID |
aging_method | string | No | — | Aging method |
days_per_aging_period | integer | No | — | Number of days per aging period |
num_periods | integer | No | — | Number of aging periods |
quickbooks_get_aged_receivable_detail_report
Generate an Aged Receivable Detail report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
report_date | string | No | — | As-of date in YYYY-MM-DD format |
customer | string | No | — | Filter by customer ID |
aging_method | string | No | — | Aging method |
days_per_aging_period | integer | No | — | Number of days per aging period |
num_periods | integer | No | — | Number of aging periods |
quickbooks_get_aged_receivables_report
Generate an Aged Receivables (A/R Aging Summary) report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
report_date | string | No | — | As-of date in YYYY-MM-DD format |
customer | string | No | — | Filter by customer ID |
aging_method | string | No | — | Aging method |
days_per_aging_period | integer | No | — | Number of days per aging period |
num_periods | integer | No | — | Number of aging periods |
quickbooks_get_attachable
Get a Attachable by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
attachableId | string | Yes | — | The Attachable ID |
quickbooks_get_balance_sheet_report
Generate a Balance Sheet report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
accounting_method | string | No | — | Accounting method |
summarize_column_by | string | No | — | Summarize columns by period |
quickbooks_get_bill
Get a bill by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
billId | string | Yes | — | The bill ID |
quickbooks_get_billpayment
Get a bill payment by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
billPaymentId | string | Yes | — | The bill payment ID |
quickbooks_get_cash_flow_report
Generate a Statement of Cash Flows report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
accounting_method | string | No | — | Accounting method |
summarize_column_by | string | No | — | Summarize columns by period |
quickbooks_get_class
Get a Class by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
classId | string | Yes | — | The Class ID |
quickbooks_get_company_info
Get company information from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
quickbooks_get_credit_memo
Get a credit memo by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
creditMemoId | string | Yes | — | The credit memo ID |
quickbooks_get_customer
Get a customer by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
customerId | string | Yes | — | The customer ID |
quickbooks_get_customer_balance_report
Generate a Customer Balance Summary report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
report_date | string | No | — | As-of date in YYYY-MM-DD format |
customer | string | No | — | Filter by customer ID |
quickbooks_get_customer_sales_report
Generate a Sales by Customer Summary report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
customer | string | No | — | Filter by customer ID |
summarize_column_by | string | No | — | Summarize columns by period |
quickbooks_get_department
Get a Department by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
departmentId | string | Yes | — | The Department ID |
quickbooks_get_deposit
Get a Deposit by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
depositId | string | Yes | — | The Deposit ID |
quickbooks_get_employee
Get an employee by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
employeeId | string | Yes | — | The employee ID |
quickbooks_get_estimate
Get an estimate by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
estimateId | string | Yes | — | The estimate ID |
quickbooks_get_general_ledger_report
Generate a General Ledger report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
accounting_method | string | No | — | Accounting method |
summarize_column_by | string | No | — | Summarize columns by period |
columns | string | No | — | Comma-separated column names to include in the report |
sort_by | string | No | — | Column to sort the report by |
sort_order | string | No | — | Sort order |
quickbooks_get_invoice
Get an invoice by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
invoiceId | string | Yes | — | The invoice ID |
quickbooks_get_item
Get an item by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
itemId | string | Yes | — | The item ID |
quickbooks_get_journal_entry
Get a JournalEntry by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
journal_entryId | string | Yes | — | The JournalEntry ID |
quickbooks_get_payment
Get a payment by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
paymentId | string | Yes | — | The payment ID |
quickbooks_get_payment_method
Get a PaymentMethod by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
payment_methodId | string | Yes | — | The PaymentMethod ID |
quickbooks_get_profit_and_loss_report
Generate a Profit and Loss (Income Statement) report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
accounting_method | string | No | — | Accounting method |
summarize_column_by | string | No | — | Summarize columns by period |
customer | string | No | — | Filter by customer ID |
department | string | No | — | Filter by department |
class | string | No | — | Filter by class |
quickbooks_get_purchase
Get a purchase by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchaseId | string | Yes | — | The purchase ID |
quickbooks_get_purchase_order
Get a purchase order by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchaseOrderId | string | Yes | — | The purchase order ID |
quickbooks_get_refund_receipt
Get a refund receipt by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
refundReceiptId | string | Yes | — | The refund receipt ID |
quickbooks_get_sales_receipt
Get a sales receipt by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
salesReceiptId | string | Yes | — | The sales receipt ID |
quickbooks_get_tax_agency
Get a TaxAgency by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
tax_agencyId | string | Yes | — | The TaxAgency ID |
quickbooks_get_tax_code
Get a TaxCode by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
tax_codeId | string | Yes | — | The TaxCode ID |
quickbooks_get_tax_rate
Get a TaxRate by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
tax_rateId | string | Yes | — | The TaxRate ID |
quickbooks_get_term
Get a Term by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
termId | string | Yes | — | The Term ID |
quickbooks_get_time_activity
Get a TimeActivity by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
time_activityId | string | Yes | — | The TimeActivity ID |
quickbooks_get_transfer
Get a Transfer by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
transferId | string | Yes | — | The Transfer ID |
quickbooks_get_trial_balance_report
Generate a Trial Balance report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
accounting_method | string | No | — | Accounting method |
summarize_column_by | string | No | — | Summarize columns by period |
quickbooks_get_vendor
Get a vendor by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendorId | string | Yes | — | The vendor ID |
quickbooks_get_vendor_credit
Get a vendor credit by ID from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendorCreditId | string | Yes | — | The vendor credit ID |
quickbooks_get_vendor_expenses_report
Generate a Vendor Expenses report from QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
start_date | string | No | — | Start date in YYYY-MM-DD format |
end_date | string | No | — | End date in YYYY-MM-DD format |
vendor | string | No | — | Filter by vendor ID |
summarize_column_by | string | No | — | Summarize columns by period |
quickbooks_query_account
Query accounts in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM Account WHERE AccountType = ‘Bank’”). Defaults to “SELECT * FROM Account” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_attachables
Query attachables in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Attachable WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_billpayments
Query bill payments in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM BillPayment WHERE TotalAmt > ‘100.00’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_bills
Query bills in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Bill WHERE TotalAmt > ‘100.00’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_classes
Query classes in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Class WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_credit_memo
Query credit memos in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM CreditMemo WHERE TotalAmt > ‘50’”). Defaults to “SELECT * FROM CreditMemo” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_customers
Query customers in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Customer WHERE DisplayName = ‘John’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_departments
Query departments in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Department WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_deposits
Query deposits in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Deposit WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_employees
Query employees in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Employee WHERE FamilyName = ‘Smith’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_estimates
Query estimates in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Estimate WHERE TotalAmt > ‘500.00’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_invoices
Query invoices in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Invoice WHERE TotalAmt > ‘100.00’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_item
Query items in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM Item WHERE Name = ‘Widget’”). Defaults to “SELECT * FROM Item” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_journal_entries
Query journal entries in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM JournalEntry WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_payment_methods
Query payment methods in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM PaymentMethod WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_payments
Query payments in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Payment WHERE TotalAmt > ‘50.00’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_purchase
Query purchases in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM Purchase WHERE PaymentType = ‘Cash’”). Defaults to “SELECT * FROM Purchase” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_purchase_order
Query purchase orders in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM PurchaseOrder WHERE TotalAmt > ‘100’”). Defaults to “SELECT * FROM PurchaseOrder” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_refund_receipt
Query refund receipts in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM RefundReceipt WHERE TotalAmt > ‘50’”). Defaults to “SELECT * FROM RefundReceipt” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_sales_receipt
Query sales receipts in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM SalesReceipt WHERE TotalAmt > ‘100’”). Defaults to “SELECT * FROM SalesReceipt” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_tax_agencies
Query tax agencies in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM TaxAgency WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_tax_codes
Query tax codes in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM TaxCode WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_tax_rates
Query tax rates in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM TaxRate WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_terms
Query terms in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Term WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_time_activities
Query time activities in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM TimeActivity WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_transfers
Query transfers in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Transfer WHERE Id = ‘1’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_vendor_credit
Query vendor credits in QuickBooks Online using SQL-like syntax Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g. “SELECT * FROM VendorCredit WHERE TotalAmt > ‘50’”). Defaults to “SELECT * FROM VendorCredit” if not provided. |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_query_vendors
Query vendors in QuickBooks Online using a SQL-like query string Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
query | string | No | — | SQL-like query string (e.g., “SELECT * FROM Vendor WHERE DisplayName = ‘Acme’“) |
maxResults | integer | No | — | Maximum number of results to return |
startPosition | integer | No | — | Starting position for pagination (1-based) |
quickbooks_update_account
Update an existing account in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
account | object | Yes | — | Account object with updated fields. Must include Id and SyncToken. |
quickbooks_update_attachable
Update an existing Attachable in QuickBooks Online. The full Attachable object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
attachable | object | Yes | — | Full Attachable object including Id and SyncToken. |
quickbooks_update_bill
Update an existing bill in QuickBooks Online. The full bill object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
bill | object | Yes | — | Full bill object including Id and SyncToken. Required fields: Id, SyncToken, VendorRef, Line. Optional: DueDate, TxnDate, APAccountRef, etc. |
quickbooks_update_billpayment
Update an existing bill payment in QuickBooks Online. The full bill payment object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
billPayment | object | Yes | — | Full bill payment object including Id and SyncToken. Required fields: Id, SyncToken, VendorRef, TotalAmt, PayType, Line. Optional: CheckPayment or CreditCardPayment details, etc. |
quickbooks_update_class
Update an existing Class in QuickBooks Online. The full Class object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
class | object | Yes | — | Full Class object including Id and SyncToken. |
quickbooks_update_company_info
Update company information in QuickBooks Online. The full CompanyInfo object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
companyInfo | object | Yes | — | Full CompanyInfo object including Id and SyncToken. |
quickbooks_update_credit_memo
Update an existing credit memo in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
creditMemo | object | Yes | — | Credit memo object with updated fields. Must include Id and SyncToken. |
quickbooks_update_customer
Update an existing customer in QuickBooks Online. The full customer object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
customer | object | Yes | — | Full customer object including Id and SyncToken. Required fields: Id, SyncToken, DisplayName. Optional: PrimaryEmailAddr, PrimaryPhone, CompanyName, BillAddr, etc. |
quickbooks_update_department
Update an existing Department in QuickBooks Online. The full Department object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
department | object | Yes | — | Full Department object including Id and SyncToken. |
quickbooks_update_deposit
Update an existing Deposit in QuickBooks Online. The full Deposit object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
deposit | object | Yes | — | Full Deposit object including Id and SyncToken. |
quickbooks_update_employee
Update an existing employee in QuickBooks Online. The full employee object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
employee | object | Yes | — | Full employee object including Id and SyncToken. Required fields: Id, SyncToken, GivenName, FamilyName. Optional: PrimaryEmailAddr, PrimaryPhone, DisplayName, etc. |
quickbooks_update_estimate
Update an existing estimate in QuickBooks Online. The full estimate object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
estimate | object | Yes | — | Full estimate object including Id and SyncToken. Required fields: Id, SyncToken, CustomerRef, Line. Optional: TxnDate, ExpirationDate, BillEmail, etc. |
quickbooks_update_invoice
Update an existing invoice in QuickBooks Online. The full invoice object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
invoice | object | Yes | — | Full invoice object including Id and SyncToken. Required fields: Id, SyncToken, CustomerRef, Line. Optional: DueDate, TxnDate, BillEmail, etc. |
quickbooks_update_item
Update an existing item in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
item | object | Yes | — | Item object with updated fields. Must include Id and SyncToken. |
quickbooks_update_journal_entry
Update an existing JournalEntry in QuickBooks Online. The full JournalEntry object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
journal_entry | object | Yes | — | Full JournalEntry object including Id and SyncToken. |
quickbooks_update_payment
Update an existing payment in QuickBooks Online. The full payment object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
payment | object | Yes | — | Full payment object including Id and SyncToken. Required fields: Id, SyncToken, CustomerRef, TotalAmt. Optional: PaymentMethodRef, DepositToAccountRef, Line, etc. |
quickbooks_update_payment_method
Update an existing PaymentMethod in QuickBooks Online. The full PaymentMethod object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
payment_method | object | Yes | — | Full PaymentMethod object including Id and SyncToken. |
quickbooks_update_purchase
Update an existing purchase in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchase | object | Yes | — | Purchase object with updated fields. Must include Id and SyncToken. |
quickbooks_update_purchase_order
Update an existing purchase order in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
purchaseOrder | object | Yes | — | Purchase order object with updated fields. Must include Id and SyncToken. |
quickbooks_update_refund_receipt
Update an existing refund receipt in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
refundReceipt | object | Yes | — | Refund receipt object with updated fields. Must include Id and SyncToken. |
quickbooks_update_sales_receipt
Update an existing sales receipt in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
salesReceipt | object | Yes | — | Sales receipt object with updated fields. Must include Id and SyncToken. |
quickbooks_update_term
Update an existing Term in QuickBooks Online. The full Term object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
term | object | Yes | — | Full Term object including Id and SyncToken. |
quickbooks_update_time_activity
Update an existing TimeActivity in QuickBooks Online. The full TimeActivity object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
time_activity | object | Yes | — | Full TimeActivity object including Id and SyncToken. |
quickbooks_update_transfer
Update an existing Transfer in QuickBooks Online. The full Transfer object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
transfer | object | Yes | — | Full Transfer object including Id and SyncToken. |
quickbooks_update_vendor
Update an existing vendor in QuickBooks Online. The full vendor object including Id and SyncToken must be provided. Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendor | object | Yes | — | Full vendor object including Id and SyncToken. Required fields: Id, SyncToken, DisplayName. Optional: PrimaryEmailAddr, PrimaryPhone, CompanyName, BillAddr, etc. |
quickbooks_update_vendor_credit
Update an existing vendor credit in QuickBooks Online Parameters:| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
realmId | string | Yes | — | QuickBooks company ID (realm ID) |
vendorCredit | object | Yes | — | Vendor credit object with updated fields. Must include Id and SyncToken. |

