Connectors
Operations Applications

QuickBooks Online

4min
quickbooks online is a cloud solution for accounting developed and marketed by intuit datalakehouse supports only quickbooks online, it does not support the desktop version of quickbooks import quickbooks online accounts, bills, invoices, customers, etc directly to your target you can schedule your quickbooks online integration operations, via a sync bridge, to execute it automatically it allows you to create a copy of quickbooks online data in snowflake and keep it up to date with little to no configuration efforts you don’t even need to prepare the schema β€” datalakehouse will automatically create tables for your cloud data all you need is to specify the connections to quickbooks online and your target and select data to replicate, and datalakehouse does the rest it will copy the specified quickbooks online data to the target and maintain this copy up to date automatically with incremental updates connecting via quickbooks online, requirements ensure that you are an administrator or an owner of your quickbooks online account if you are not, please contact your quickbooks online administrator instructions (basic connection setup) datalakehouse io securely connects to your quickbooks online instance by redirecting you to the quickbooks portal for you to sign in via quickbooks's login datalakehouse io does not capture or store your password/credentials using the form please complete the following basic steps enter a name or alias for this connection that is unique in the 'name/alias' field this name is only visible in datalakehouse io and should be descriptive enough for you and other users of datalakehouse to understand its name click the 'authorize your account' button which will transport the page to the quickbooks online login, where you will enter your quickbooks account credentials once your credentials are accepted you will be automatically redirected back to the datalakehouse io portal and you will see a successful connection of your source if any issues occur with the quickbooks online authorization occur, simply return to the sources page in datalakehouse io, edit this source and click the 'authorize your account' or 're authorize your account' button if any issues persist please contact our support team via the datalakehouse support portal https //datalakehouse zendesk com replicated entities the following quickbooks online entities are available for replication to snowflake with datalakehouse io you select which ones you'd like replicated and you're always free to add additional ones at a later time these are the table names you will see in snowflake account address bill bill line bill linked txn bill payment bill payment line budget budget detail bundle bundle item class company currency credit memo credit memo line credit memo line bundle currency customer department deposit deposit line employee estimate estimate line estimate line bundle estimate linked txn estimate tax line invoice invoice line invoice line bundle invoice linked txn invoice tax line item journal entry journal entry line payment payment line payment method purchase purchase line purchase order purchase order line purchase order linked txn purchase order tax line purchase tax line refund receipt refund receipt line refund receipt line bundle refund receipt tax line sales receipt sales receipt line sales receipt line bundle sales receipt tax line tax agency tax classification tax code tax rate term time activity transfer vendor vendor credit vendor credit line