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-billablethat 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.
- Go to Organization > Connectors and find QuickBooks Online. Click Enable, and choose which tools to allow.
- Create an OAuth application in the QuickBooks Online developer portal.
- Add the Redirect URI shown in the connector settings to the application.
- Copy the application's Client ID and Client Secret into the connector, then save it.
- 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.
| Tool | What it does |
|---|---|
check_auth_config | Diagnostic tool to check QuickBooks authentication configuration. |
get_account | Retrieve comprehensive account details by ID including name, type, sub-type, classification, current balance, parent account, and account number. |
get_bill | Retrieve comprehensive bill details by ID including vendor info, line items with account/item details, amounts, due date, and balance information. |
get_bill_payment | Get one bill payment by ID: vendor, pay type, paying account, the bills it covers (Line.LinkedTxn), total and SyncToken. |
get_class | Get one class by ID: name, parent, active state and SyncToken. |
get_customer | Retrieve comprehensive customer details by ID including contact info, billing and shipping addresses, payment terms, balance info, tax settings, and metadata. |
get_department | Get one department by ID: name, parent, active state and SyncToken. |
get_estimate | Retrieve comprehensive estimate details by ID including customer info, line items with products/services, amounts, transaction date, expiration date, and acceptance status. |
get_invoice | Retrieve comprehensive invoice details by ID including customer info, line items with quantities and amounts, payment status, delivery info, tax calculations, and financial totals. |
get_item | Retrieve comprehensive item details by ID including name, description, SKU, unit price, purchase cost, income/expense accounts, inventory tracking, and quantity on hand. |
get_payment | Retrieve comprehensive payment details by ID including customer info, payment method, line items showing invoice applications, amounts applied and unapplied. |
get_purchase | Get one expense (purchase) by ID: payment type, paid-from account, payee, lines, total and SyncToken. |
get_report | Run a financial report: ProfitAndLoss, BalanceSheet, CashFlow, TrialBalance, GeneralLedger, AgedReceivables/AgedPayables (aging), CustomerSales, ItemSales, TransactionList and more. |
get_tax_agency | Get one tax agency (the authority a tax rate is owed to) by ID. |
get_tax_classification | Get one tax classification (an item tax category used by Automated Sales Tax and non-US tax regimes) by ID. |
get_tax_code | Get one sales tax code by numeric ID with the tax rates it groups. |
get_tax_payment | Get one tax payment or refund made against a filed tax return, by ID. |
get_tax_rate | Get one tax rate by ID: percentage, tax agency and active state. |
get_vendor | Retrieve comprehensive vendor details by ID including contact information, addresses, email, phone numbers, tax identifier, balance, and 1099 status. |
query_accounts | Query the Chart of Accounts by account type and active status (status='all' includes inactive), or with a raw SQL-like query. |
query_bill_payments | List or search payments made against vendor bills. |
query_bills | Query bills by vendor, payment status (Payable/Paid) and date range, or with a raw SQL-like query. |
query_classes | List or search classes, e.g. to find the ClassRef ID for an invoice, bill or expense line. |
query_customers | Query customers by active status (status='all' includes inactive), or with a raw SQL-like query for name, balance or other filters. |
query_departments | List or search departments (locations), e.g. to find the DepartmentRef ID for an invoice, bill or expense. |
query_employees | List 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_estimates | Query estimates by customer, status (Accepted/Closed/Pending/Rejected/Converted) and date, or with a raw SQL-like query. |
query_invoices | Query invoices by customer, email delivery status (NotSet/NeedToSend/EmailSent, not payment status) and date, or with a raw SQL-like query. |
query_items | Query 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_methods | List or search payment methods (Cash, Check, Visa) to find the payment_method_id for create_purchase, update_purchase, create_payment or update_payment. |
query_payments | Query customer payments by customer and date range, or with a raw SQL-like query for amount or other filters. |
query_purchases | List or search expenses (cash, check and credit-card purchases). |
query_tax_agencies | List tax agencies, e.g. to find the tax_agency_id for a new rate in create_tax_code. |
query_tax_classifications | List tax classifications. |
query_tax_codes | List or search sales tax codes, e.g. to find the TaxCodeRef ID for a line. |
query_tax_payments | List tax payments and refunds made against filed tax returns. |
query_tax_rates | List or search tax rates, e.g. to reuse an existing rate in create_tax_code. |
query_vendors | Query vendors by active status (status='all' includes inactive), or with a raw SQL-like query for name or other filters. |
validate_credential | Validate QuickBooks Online credentials by making a test API call. |
Write (16)
Create or send data.
| Tool | What it does |
|---|---|
create_account | Create Chart of Accounts entry. |
create_bill | Create bill record for vendor with line items for expenses or items. |
create_bill_payment | Pay one or more of a vendor's bills by check or credit card. |
create_class | Create a class, or a subclass when parent_class_id is set (use query_classes to find the parent). |
create_customer | Create customer with contact info, addresses, and settings. |
create_department | Create a department (location), or a sub-department when parent_department_id is set (use query_departments to find the parent). |
create_estimate | Create sales estimate for customer with line items. |
create_invoice | Create invoice with line items, customer details, and financial settings. |
create_item | Create item for products/services. |
create_payment | Create payment record for customer against invoices. |
create_purchase | Record an expense paid by cash, check or credit card (a credit-card refund with credit=true). |
create_tax_agency | Create a tax agency by display name, to receive new tax rates in create_tax_code. |
create_tax_code | Create 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_vendor | Create vendor record with display name, contact details, billing address, email, phone, tax identifier, and 1099 settings. |
send_estimate | Send estimate via email to customer. |
send_invoice | Send invoice via email to customer. |
Delete or overwrite (22)
Remove or replace existing data.
| Tool | What it does |
|---|---|
delete_bill | Delete bill by ID permanently. |
delete_bill_payment | Permanently delete a bill payment; the bills it paid become payable again. |
delete_customer | Soft delete customer by setting status to inactive. |
delete_estimate | Delete estimate by ID permanently. |
delete_item | Delete an item by marking it as inactive (soft delete). |
delete_payment | Delete payment by ID. |
delete_purchase | Permanently delete an expense (purchase). |
delete_vendor | Delete vendor by ID. |
update_account | Update account with new name, description, account number, or active status. |
update_bill | Update bill with new vendor, line items, dates, or amounts. |
update_bill_payment | Change a bill payment. |
update_class | Rename, re-parent, deactivate (active=false) or reactivate a class. |
update_customer | Update customer with new contact info, addresses, and settings. |
update_department | Rename, re-parent, deactivate (active=false) or reactivate a department. |
update_estimate | Update estimate with new line items, dates, customer memo, or addresses. |
update_invoice | Modify existing invoice with updated line items, financial details, and settings. |
update_item | Update item name, description, SKU, pricing, accounts, or status. |
update_payment | Update payment with new amount, method, or invoice applications. |
update_purchase | Change an expense. |
update_vendor | Update vendor with new contact details, address, email, phone, tax info, or active status. |
void_bill_payment | Void a bill payment: it stays on record with its total zeroed and lines cleared, and the bills it paid become payable again. |
void_invoice | Void invoice while maintaining audit trail. |