Skip to main content

Documentation Index

Fetch the complete documentation index at: https://parabola.io/docs/llms.txt

Use this file to discover all available pages before exploring further.

QuickBooks Online is the system of record for the books at most SMBs and a large share of mid-market companies. Connecting it to Parabola lets finance and ops teams pull live AR, AP, GL, customer, and vendor data straight into automated reconciliations, accruals, and reports — without manually running and exporting reports out of QuickBooks each month.

​
Pull from QuickBooks Online

​
How to use Parabola’s QuickBooks Online integration

Parabola’s QuickBooks Online integration brings live accounting data directly into a flow:
  • Sync invoices, bills, payments, journal entries, customers, vendors, and other entities on a schedule
  • Run incremental loads that pick up only the records updated since the last run
  • Combine QBO data with shipments, sales orders, rate cards, or spend data from other systems to build accruals, reconciliations, and management reports
  • Push reconciled data into BI tools, Google Sheets, or back into your ERP
Learn more about Parabola’s QuickBooks Online integration below.

​
How to authenticate

QuickBooks Online uses OAuth 2.0. You authorize Parabola from inside Intuit’s standard login flow — there are no API keys to generate or paste.
1
In your Parabola flow, add a Pull from QuickBooks Online step.
2
Click Authorize. A pop-up will open the Intuit login flow.
3
Sign in to Intuit, select the QuickBooks Online company you want to connect, and approve the requested access.
4
Once authorization completes you’ll be redirected back to Parabola, and the step will be connected to that company.
Note:Each connected authorization corresponds to a single QuickBooks Online company file. If you manage multiple companies in QBO, authorize a separate account for each one.
To switch between connected companies — or to add another company — click Edit accounts at the top of the step.

​
Custom settings

Open the step and select an Entity from the dropdown. The dropdown lists every QBO entity Parabola supports, including:
  • Customers and vendors — contact records, billing addresses, payment terms, and balances
  • Items — products and services in your QBO catalog
  • Chart of accounts — every GL account on the books
  • Sales documents — invoices, sales receipts, estimates, credit memos
  • Purchases and bills — bills, bill payments, purchase orders, vendor credits
  • Money movement — payments, deposits, transfers, journal entries
You can apply optional filters on queryable fields — most commonly date fields like TxnDate or MetaData.LastUpdatedTime — to scope the rows the step returns. See the next section for guidance on which date field to use.

​
Filtering and incremental loads

For incremental loads — for example, “give me everything updated since yesterday” — filter on MetaData.LastUpdatedTime with a relative date range. Unlike TxnDate, which only carries the date portion of a transaction, MetaData.LastUpdatedTime includes a full timestamp. That means a Between range correctly includes records that were edited mid-day on the boundary, instead of silently dropping them. QuickBooks Online does not support filtering on currency or numeric amount fields (for example, Balance or TotalAmt) at the API level. To filter on amounts, pull the data unfiltered and add a downstream Filter rows step to apply the amount filter inside Parabola.

​
Tips for using Parabola with QuickBooks Online

  • Use MetaData.LastUpdatedTime for incremental loads, not TxnDate. Only MetaData.LastUpdatedTime carries full timestamp precision, so a relative date range correctly captures records that were edited mid-day on the boundary.
  • Filter amounts downstream, not in the step. QBO blocks filtering on currency and numeric columns. Pull the data unfiltered, then use a Filter rows step in Parabola to filter on Balance, TotalAmt, or any other amount field.
  • One authorization = one company. If you operate multiple QBO companies, authorize a separate account per company and switch between them on each step using Edit accounts.
  • Combine with Ramp, NetSuite, or shipping data to automate accruals, three-way match reconciliations, and AP aging reports — flows that would otherwise require running and exporting QuickBooks reports manually each month.
  • Schedule around close. Daily or hourly runs during month-end close keep your reconciliations current and reduce last-minute manual exports.

​
Troubleshooting common errors

When QuickBooks Online returns an error, the step translates Intuit’s parser jargon into a plain-English message. The most common ones:
  • “QuickBooks Online does not allow filtering on ‘<field>’ for this entity. Remove that filter and try again.” — The field you tried to filter on is not queryable on this entity in QBO. Remove the filter, or move it into a downstream Filter rows step.
  • “QuickBooks Online does not allow filtering on currency / numeric amount columns (e.g. Balance, TotalAmt). Remove that filter and try again.” — QBO never supports server-side filtering on currency or amount fields. Pull the data unfiltered and filter downstream.
  • “Access token invalid. Please reauthorize QuickBooks Online.” — The OAuth access token is no longer valid. Click Edit accounts on the step and reauthorize the connection.
  • “Your QuickBooks Online connection has expired. Please reauthorize.” — The OAuth refresh token has expired. Intuit expires refresh tokens after long periods of inactivity, so this typically appears on flows that haven’t run in a while. Click Edit accounts and reauthorize to reconnect.
  • “Rate limit exceeded by QuickBooks Online.” — QBO’s API rate limit was exceeded. The step automatically retries up to 3 times with exponential backoff before surfacing this error. If you see it consistently, reduce flow run frequency or split a large pull into smaller chunks (for example, by date range).
Last modified on May 6, 2026