QuickBooks Desktop – Gotchas
QuickBooks Desktop is an on-premises accounting software by Intuit for small and medium-sized businesses, offering invoicing, expense tracking, payroll, and financial reporting capabilities.
18 gotchas across 12 resources
These are connector-specific behaviors and limitations to be aware of when integrating.
Bill Payments1 gotcha
billPaymentsAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
Bills2 gotchas
billsAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
billsAddOn create, bill expense lines map from line_items[] (ledger_account → expense account, total_amount, description). On update, QuickBooks Desktop cannot modify line items — only header fields (supplier, bill_date, due_date, bill_number, terms, memo) change. Recreate the bill to change lines.
Credit Notes2 gotchas
creditNotesAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
creditNotesAddOn update, QuickBooks Desktop cannot modify credit-note line items, the AR account, or class — only customer, date_issued, number, and note (memo) change. Recreate the credit note to change lines.
Customers1 gotcha
customersAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
Invoice Items1 gotcha
invoiceItemsAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
Invoices2 gotchas
invoicesAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
invoicesAddOn create, QuickBooks Desktop only honors customer, invoice_date, number, reference (memo), and line_items. Header fields such as due_date, terms, po_number, customer_memo, billing/shipping address, currency, and tracking category are ignored at create time — set them with a follow-up update. Each line item must include an item (QBD rejects invoices whose lines have no item). On update, line items cannot be modified — only header fields (customer, dates, ref number, memo) change; resend line edits by voiding and recreating.
Journal Entries1 gotcha
journalEntriesAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
Ledger Accounts1 gotcha
ledgerAccountsAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
Payments2 gotchas
paymentsAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
paymentsAddQuickBooks Desktop applies a payment to invoices via allocations[] — each allocations[].id is the target invoice's transaction id and allocations[].amount the amount applied. Without allocations, the payment is created unapplied. On update, QBD cannot change the applied invoices, payment method, or deposit/AR account — only customer, transaction_date, reference, total_amount, and note are updatable; recreate the payment to change allocations.
Purchase Orders2 gotchas
purchaseOrdersAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
purchaseOrdersAddOn update, QuickBooks Desktop cannot modify purchase-order line items — only header fields (supplier, issued_date, po_number, memo, expected_arrival_date, class) change. Recreate the PO to change lines. Per-line customer is not supported on QBD purchase-order lines.
Suppliers2 gotchas
suppliersAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.
suppliersAddOn create, QuickBooks Desktop only honors company_name, first_name, last_name, email, the primary phone, and the first address (line1/line2/city/state/postal_code/country). Fields such as title (salutation), middle_name, fax, supplier_category, terms, tax_number, display_id (account number), and notes are ignored at create time — set them with a follow-up update, which supports the full field set.
Tax Rates1 gotcha
taxRatesAllQuickBooks Desktop does not expose a reliable cross-page total record count. Getting total_count requires a separate COUNT query — an extra API call that is not currently implemented. meta.total_count will not appear.