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 (QBO) is Intuit’s cloud accounting platform, used by millions of small and mid-sized businesses to handle invoicing, bills, expenses, and the general ledger. Connecting QBO 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 QuickBooks reports each month.

​
Pull from QuickBooks Online

The Pull from QuickBooks Online step brings live accounting data 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, and combine QBO data with shipments, sales orders, rate cards, or spend data from other systems to build accruals, reconciliations, and management reports.

​
How to authenticate

QuickBooks Online uses OAuth 2.0. You authorize Parabola from inside Intuit’s standard login flow, so 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.
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.

​
Configure your 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.
Apply optional filters on queryable fields, most commonly date fields like TxnDate or MetaData.LastUpdatedTime, to scope the rows the step returns.

​
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 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 inside Parabola.

​
Available data

QBO exposes most of the entities used for accounting and reporting. The most common ones operators pull:
  • Invoices — customer-facing invoices with line items, customer references, due dates, balances, and status.
  • Bills — vendor bills with line items, GL account assignments, due dates, and balances.
  • Payments and bill payments — customer payments applied to invoices, and vendor payments applied to bills.
  • Journal entries — manual GL entries with debit/credit lines, accounts, classes, and memos.
  • Customers and vendors — contact records, addresses, payment terms, and current balances.
  • Items — products and services with rates, income/expense accounts, and SKU.
  • Chart of accounts — every GL account with type, sub-type, and current balance.

​
Common use cases

  • Automate AP aging and accrual reports: Pull bills and bill payments alongside spend data from Ramp or Coupa to build aging reports and month-end accruals without manually exporting QuickBooks each close.
  • Reconcile e-commerce revenue to the books: Combine QBO invoices and payments with order and payout data from Shopify, Amazon Seller Central, Squarespace, and Stripe so finance can post clean revenue and fee entries.
  • Audit shipping and 3PL invoices: Cross-reference QBO bills with carrier and 3PL records from FedEx, UPS, DHL, or ShipBob to catch overcharges and post adjustments.
  • Build cash and AR dashboards: Roll up open invoices, payments, and balances into a daily summary, dropped into Google Drive or pushed to Looker or Metabase for finance leadership.
  • Push reconciled data into the warehouse: Send QBO transactions into Snowflake, BigQuery, or Redshift so analytics teams can join GL data with the rest of the business.
  • Trigger finance alerts: Send a Slack message when a high-value bill is approaching its due date, when a customer balance crosses a threshold, or when a journal entry posts to a sensitive account.

​
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 edited mid-day on the boundary.
  • Filter amounts downstream, not in the step. QBO blocks filtering on currency and numeric columns. Pull unfiltered, then use a Filter rows step in Parabola to filter on Balance, TotalAmt, or any other amount field.
  • One authorization per 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 spend, ERP, and shipping data to automate accruals, three-way matches, and AP aging. These flows 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.
  • Document each step. QBO entities have overlapping field names (for example, TotalAmt exists on invoices, bills, and payments). Step notes help the next person reading the flow keep them straight.

​
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 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.
  • “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).

​
FAQ

​
Can I push data back into QuickBooks Online?

The Pull from QuickBooks Online step is read-only. To create or update QBO records (for example, posting a journal entry or creating a bill), use a Send to an API step pointed at Intuit’s QuickBooks Online API with your OAuth credentials.

​
Does the integration support QuickBooks Desktop?

No. The native step connects only to QuickBooks Online. QuickBooks Desktop uses a different API surface, so for Desktop, export reports to CSV and pull them via Google Drive, Dropbox, or FTP.

​
How do I connect multiple QBO companies in one flow?

Add a separate Pull from QuickBooks Online step for each company and authorize each one against the right Intuit login. You can union the results downstream with a Stack tables step.

​
Why are amount filters being ignored?

QBO blocks server-side filtering on currency and numeric amount fields. Pull the data unfiltered and add a Filter rows step downstream to filter on Balance, TotalAmt, or any other amount column.
With QuickBooks Online and Parabola connected, the AP aging workbooks, revenue reconciliations, and accrual schedules that used to consume the first week of every month run on a schedule, with clean data flowing into the systems where finance actually works.
Last modified on May 18, 2026