Skip to main content
QuickBooks Online is raw data only, without modeled P&L dashboards or Uni metrics.For delivery to a dedicated warehouse, see Choose raw tables. Choose from the tables offered under Warehouse → Raw data once the source is connected.
QuickBooks Online is your accounting system. SourceMedium reads QBO entities into BigQuery.

How to connect

1

Start in SourceMedium

Choose QuickBooks in the connector picker and click Authorize with QuickBooks.
2

Approve access in Intuit

Sign in to Intuit as a QuickBooks Online admin, choose the company to connect, and approve read access to its accounting data. You return to SourceMedium with the connection active.
SourceMedium keeps the authorization current. Intuit can still end it: after 100 days without a refresh, five years after access was approved, or when SourceMedium is disconnected in QuickBooks. The connection then asks you to reconnect. Removing the connection in SourceMedium stops syncing and ends SourceMedium’s access to the company in QuickBooks, unless another SourceMedium store is still connected to the same company.

What data syncs

Core QBO entities as source tables. Choose from the available tables after the first sync.