Skip to main content

QuickBooks Online

Comprehensive QuickBooks Online connector for accounting operations including customers, invoices, payments, bills, and financial reporting.

Categories: Accounting, Finance, ERP

What you can ask​

  • List unpaid invoices over 30 days past due, by customer.
  • Pull total revenue by class for Q1 and rank by largest.
  • Find expenses tagged client-billable that haven't been invoiced.

Set up​

QuickBooks Online needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.

  1. Go to Organization > Connectors and find QuickBooks Online. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the QuickBooks Online developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. Each member connects their own account the first time they use it.

⚠️ Warning: Do not enter your Devs.ai or QuickBooks Online login email or password in the OAuth application fields.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

OAuth scopes used by these tools (1)

Grant the scopes for the tools you plan to allow.

  • com.intuit.quickbooks.accounting

Tools​

QuickBooks Online offers 77 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (39)​

View and search information without changing it.

ToolWhat it does
check_auth_configDiagnostic tool to check QuickBooks authentication configuration.
get_accountRetrieve comprehensive account details by ID including name, type, sub-type, classification, current balance, parent account, and account number.
get_billRetrieve comprehensive bill details by ID including vendor info, line items with account/item details, amounts, due date, and balance information.
get_bill_paymentGet one bill payment by ID: vendor, pay type, paying account, the bills it covers (Line.LinkedTxn), total and SyncToken.
get_classGet one class by ID: name, parent, active state and SyncToken.
get_customerRetrieve comprehensive customer details by ID including contact info, billing and shipping addresses, payment terms, balance info, tax settings, and metadata.
get_departmentGet one department by ID: name, parent, active state and SyncToken.
get_estimateRetrieve comprehensive estimate details by ID including customer info, line items with products/services, amounts, transaction date, expiration date, and acceptance status.
get_invoiceRetrieve comprehensive invoice details by ID including customer info, line items with quantities and amounts, payment status, delivery info, tax calculations, and financial totals.
get_itemRetrieve comprehensive item details by ID including name, description, SKU, unit price, purchase cost, income/expense accounts, inventory tracking, and quantity on hand.
get_paymentRetrieve comprehensive payment details by ID including customer info, payment method, line items showing invoice applications, amounts applied and unapplied.
get_purchaseGet one expense (purchase) by ID: payment type, paid-from account, payee, lines, total and SyncToken.
get_reportRun a financial report: ProfitAndLoss, BalanceSheet, CashFlow, TrialBalance, GeneralLedger, AgedReceivables/AgedPayables (aging), CustomerSales, ItemSales, TransactionList and more.
get_tax_agencyGet one tax agency (the authority a tax rate is owed to) by ID.
get_tax_classificationGet one tax classification (an item tax category used by Automated Sales Tax and non-US tax regimes) by ID.
get_tax_codeGet one sales tax code by numeric ID with the tax rates it groups.
get_tax_paymentGet one tax payment or refund made against a filed tax return, by ID.
get_tax_rateGet one tax rate by ID: percentage, tax agency and active state.
get_vendorRetrieve comprehensive vendor details by ID including contact information, addresses, email, phone numbers, tax identifier, balance, and 1099 status.
query_accountsQuery the Chart of Accounts by account type and active status (status='all' includes inactive), or with a raw SQL-like query.
query_bill_paymentsList or search payments made against vendor bills.
query_billsQuery bills by vendor, payment status (Payable/Paid) and date range, or with a raw SQL-like query.
query_classesList or search classes, e.g. to find the ClassRef ID for an invoice, bill or expense line.
query_customersQuery customers by active status (status='all' includes inactive), or with a raw SQL-like query for name, balance or other filters.
query_departmentsList or search departments (locations), e.g. to find the DepartmentRef ID for an invoice, bill or expense.
query_employeesList or search employees by name to find an employee ID, e.g. the entity_id (entity_type 'Employee') for an expense in create_purchase.
query_estimatesQuery estimates by customer, status (Accepted/Closed/Pending/Rejected/Converted) and date, or with a raw SQL-like query.
query_invoicesQuery invoices by customer, email delivery status (NotSet/NeedToSend/EmailSent, not payment status) and date, or with a raw SQL-like query.
query_itemsQuery products and services by type (Service/Inventory/NonInventory/Category) and active status (status='all' includes inactive), or with a raw SQL-like query.
query_payment_methodsList or search payment methods (Cash, Check, Visa) to find the payment_method_id for create_purchase, update_purchase, create_payment or update_payment.
query_paymentsQuery customer payments by customer and date range, or with a raw SQL-like query for amount or other filters.
query_purchasesList or search expenses (cash, check and credit-card purchases).
query_tax_agenciesList tax agencies, e.g. to find the tax_agency_id for a new rate in create_tax_code.
query_tax_classificationsList tax classifications.
query_tax_codesList or search sales tax codes, e.g. to find the TaxCodeRef ID for a line.
query_tax_paymentsList tax payments and refunds made against filed tax returns.
query_tax_ratesList or search tax rates, e.g. to reuse an existing rate in create_tax_code.
query_vendorsQuery vendors by active status (status='all' includes inactive), or with a raw SQL-like query for name or other filters.
validate_credentialValidate QuickBooks Online credentials by making a test API call.

Write (16)​

Create or send data.

ToolWhat it does
create_accountCreate Chart of Accounts entry.
create_billCreate bill record for vendor with line items for expenses or items.
create_bill_paymentPay one or more of a vendor's bills by check or credit card.
create_classCreate a class, or a subclass when parent_class_id is set (use query_classes to find the parent).
create_customerCreate customer with contact info, addresses, and settings.
create_departmentCreate a department (location), or a sub-department when parent_department_id is set (use query_departments to find the parent).
create_estimateCreate sales estimate for customer with line items.
create_invoiceCreate invoice with line items, customer details, and financial settings.
create_itemCreate item for products/services.
create_paymentCreate payment record for customer against invoices.
create_purchaseRecord an expense paid by cash, check or credit card (a credit-card refund with credit=true).
create_tax_agencyCreate a tax agency by display name, to receive new tax rates in create_tax_code.
create_tax_codeCreate a sales tax code through TaxService, from existing tax rates (tax_rate_id, see query_tax_rates) and/or new ones (name, rate_value, tax_agency_id from query_tax_agencies).
create_vendorCreate vendor record with display name, contact details, billing address, email, phone, tax identifier, and 1099 settings.
send_estimateSend estimate via email to customer.
send_invoiceSend invoice via email to customer.

Delete or overwrite (22)​

Remove or replace existing data.

ToolWhat it does
delete_billDelete bill by ID permanently.
delete_bill_paymentPermanently delete a bill payment; the bills it paid become payable again.
delete_customerSoft delete customer by setting status to inactive.
delete_estimateDelete estimate by ID permanently.
delete_itemDelete an item by marking it as inactive (soft delete).
delete_paymentDelete payment by ID.
delete_purchasePermanently delete an expense (purchase).
delete_vendorDelete vendor by ID.
update_accountUpdate account with new name, description, account number, or active status.
update_billUpdate bill with new vendor, line items, dates, or amounts.
update_bill_paymentChange a bill payment.
update_classRename, re-parent, deactivate (active=false) or reactivate a class.
update_customerUpdate customer with new contact info, addresses, and settings.
update_departmentRename, re-parent, deactivate (active=false) or reactivate a department.
update_estimateUpdate estimate with new line items, dates, customer memo, or addresses.
update_invoiceModify existing invoice with updated line items, financial details, and settings.
update_itemUpdate item name, description, SKU, pricing, accounts, or status.
update_paymentUpdate payment with new amount, method, or invoice applications.
update_purchaseChange an expense.
update_vendorUpdate vendor with new contact details, address, email, phone, tax info, or active status.
void_bill_paymentVoid a bill payment: it stays on record with its total zeroed and lines cleared, and the bills it paid become payable again.
void_invoiceVoid invoice while maintaining audit trail.
⌘J