Ask Runway AI Copilot

Quickbooks

A step-by-step guide to setting up a Quickbooks integration.

Pre-requisites

Here’s what you’ll need to connect to Quickbooks:

  • An active QuickBooks Online admin account
  • The username and password for your account
  • The ability to receive confirmation codes for your account

Supported data

Runway reads these financial statements from Quickbooks:

  • Income Statement
  • Cash Flow
  • Balance Sheet

How data is handled

The data pulled from Quickbooks is converted into databases in Runway, letting you connect drivers to line items in these financial statements.

💡
Runway supports read-only integrations. We don’t write any data back to Quickbooks.

Connecting to Quickbooks

  • Go to the Integrations Directory in Runway. Quickbooks is listed as a featured integration—click + Set up to begin.
    • Notion image
  • Authorize the new schema name. We recommend keeping the default name as-is.
Notion image
  • You’ll be directed to our integration partner, Fivetran, to connect your Quickbooks instance. Once redirected, sign in to your Intuit Quickbooks account.
  • Once that’s done, you’ll be redirected back to Fivetran. Select Save & Test.
  • You’ll then be redirected to Runway, the initial sync will begin, and a new database will be created.

Pulling data from Quickbooks

Basic Income Statement, Balance Sheet, Cash Flow Statement queries can be accessed via Runway’s Templates section in the left-hand sidebar.

Notion image

Once your Quickbooks integration has been successfully connected, navigate to the Modeling section of the Templates page and select which statement you’d like to add to Runway. This will populate the query and configure a basic database, which you can output later if needed. It is worth noting that these templated queries are built for single-entity configurations only.

All done. You’re ready to start modeling! 👩‍💻

FAQ

Can I pull other types of data from Quickbooks?

Yes! Our integration is built to be highly customizable. The starter queries above fit most use cases, but we also support writing your own SQL queries leveraging this Quickbooks schema. Not a SQL expert? Not a problem—your CX crew member can help shape your data exactly the way you need.

 

Can I connect multiple instances of Quickbooks?

Absolutely. To add more instances, go to the Integration Directory in Runway. Click Installed and then select Set Up. You’ll be prompted to go through the same authentication flow as before—select the new instance and follow the steps listed above.

 

Runway offers 650+ integrations. Check out the full list here.

Did this answer your question?
😞
😐
🤩

Last updated on February 7, 2024