Connectors

/

Sources

/

QuickBooks

  • Source
  • Finance & Ops Analytics
  • Generally available

Move QuickBooks data anywhere it matters.

Move QuickBooks accounts, attachables and billpayments into your warehouse, lake or AI app.

Source

QuickBooks

  • Snowflake
  • BigQuery
  • Postgres
  • Databricks
  • Claude
Streams
34
Destinations
50+
Standard support
5.0.0

Overview

What is the Airbyte QuickBooks connector?

The Airbyte QuickBooks connector extracts data from QuickBooks and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 34 streams you can select per connection.

  • 01

    Sync to your warehouse

    Land 34 QuickBooks tables in 50+ destinations on a schedule you control.

  • 02

    Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • 03

    One authorization

    Authenticate QuickBooks once and Airbyte keeps every scheduled sync running on it.

  • 04

    Cloud or self-hosted

    Run the QuickBooks connector on Cloud, OSS, Hybrid.

34 streams

Every table you can sync from QuickBooks

  • Accounts
    Sync modesFullIncr.
  • Attachables
    Sync modesFullIncr.
  • BillPayments
    Sync modesFullIncr.
  • Budgets
    Sync modesFullIncr.
  • Bills
    Sync modesFullIncr.
  • Classes
    Sync modesFullIncr.

Setup

Live in eight steps

  1. First, navigate to the QuickBooks source connector page on Airbyte's website.

  2. Click on the "Add Source" button to begin the process of adding your QuickBooks credentials.

  3. In the "Connection Configuration" section, enter your QuickBooks OAuth2 credentials. This includes your client ID, client secret, access token, and refresh token.

Configuration fields

QuickBooks configuration fields
FieldTypeDescription
credentials*objectNot documented.
start_date*stringThe default value to use if no bookmark exists for an endpoint (rfc3339 date string). E.g, 2021-03-20T00:00:00Z. Any data before this date will not be replicated.
max_resultsintegerNumber of records requested per query page (Intuit's MAXRESULTS). Raising it reduces the number of requests on companies with long histories; 1,000 is the maximum Intuit accepts.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

  • Cloud
  • OSS
  • Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

QuickBooks connector questions

What data can I sync from QuickBooks with Airbyte?

34 streams, including Accounts, Attachables, BillPayments, Budgets, Bills, Classes, CompanyInfo, CreditCardPayments and more.

Does the QuickBooks connector support incremental sync?

Yes. The QuickBooks connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the QuickBooks connector?

Run the QuickBooks connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales

Start syncing QuickBooks in minutes.

Free 14-day trial. No credit card needed.