get_company_info | Fetch the connected company (CompanyName, LegalName, addresses, Country, FiscalYearStartMonth, email). |
get_customer | Fetch a customer by Id (DisplayName, contact details, addresses, Balance). |
get_invoice | Fetch an invoice by Id (lines, CustomerRef, TxnDate, DueDate, TotalAmt, Balance, EmailStatus). |
list_accounts | List chart-of-accounts accounts (SELECT * FROM Account). Optional where clause in QuickBooks query syntax, e.g. “AccountType = ‘Bank’” or “Classification = ‘Revenue’” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_bills | List bills (supplier invoices to pay) (SELECT * FROM Bill). Optional where clause in QuickBooks query syntax, e.g. “DueDate < ‘2026-10-01’ AND Balance > ‘0’” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_customers | List customers (SELECT * FROM Customer). Optional where clause in QuickBooks query syntax, e.g. “Active = true AND DisplayName LIKE ‘Acme%’” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_invoices | List invoices (SELECT * FROM Invoice). Optional where clause in QuickBooks query syntax, e.g. “TxnDate >= ‘2026-01-01’ AND Balance > ‘0’” or “CustomerRef = ‘42’” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_items | List products and services (items) (SELECT * FROM Item). Optional where clause in QuickBooks query syntax, e.g. “Type = ‘Service’ AND Active = true” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_payments | List customer payments (SELECT * FROM Payment). Optional where clause in QuickBooks query syntax, e.g. “TxnDate >= ‘2026-01-01’” or “CustomerRef = ‘42’” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
list_vendors | List vendors (suppliers) (SELECT * FROM Vendor). Optional where clause in QuickBooks query syntax, e.g. “Active = true” (AND only — OR is not supported; Id filters support only = and IN). max_results 1–1000 (default 100); paginate with start_position (1-based). |
query | Run a QuickBooks query: SELECT * | count(*) FROM <Entity> [WHERE …] [ORDERBY …] [STARTPOSITION n] [MAXRESULTS n], e.g. “select * from Invoice where TxnDate > ‘2026-01-01’ maxresults 50”. Entities: Customer, Invoice, Item, Payment, Bill, Vendor, Account, Estimate, SalesReceipt, Purchase, Employee, TaxCode… AND only (no OR); MAXRESULTS ≤ 1000 (default 100). |
report_balance_sheet | Balance Sheet report: assets, liabilities and equity over start_date–end_date (or a date_macro), Cash or Accrual basis. |
report_profit_and_loss | Profit and Loss (income statement) report: income, cost of goods sold, expenses, net income over start_date–end_date (or a date_macro), Cash or Accrual basis. |