Easy

For non-technical users

Fast

Setup in under 5 minutes

Secure

Secure data architecture

Qbonline

QuickBooks Online Integration

One way sync
Accounting
OAuth Authentication

Data Objects

AP Aging Details

AP Aging Summary

AR Aging Details

AR Aging Summary

Account List Details

Accounts

Balance Sheets

BillPayments

Bills

Budgets

Cash Flows

Classes

CompanyCurrencies

CreditMemos

Customer Balance Details

Customer Balances

Customer Income

Customers

Departments

Deposits

Employees

Estimates

Expenses by Vendor

General Ledgers

Inventory Valuations

Invoices

Items

Journal Reports

JournalCodes

JournalEntries

Name List Resources

Payment Methods

Payments

Profit and Losses

Profit_and_Losses_Details

PurchaseOrders

Purchases

RefundReceipts

Report Resources

Sales by Class

Sales by Customer

Sales by Department

Sales by Product

SalesReceipts

Tax Agencies

Tax Codes

Tax Rates

Tax Services

Tax Summaries

Terms

TimeActivities

Transaction Lists

Transaction Resources

Transfers

Trial Balances

Vendor Balances

Vendor Balances Details

Vendor Credits

Vendors

Flatten Data from QuickBooks Online

Destination: Google Drive +Google Sheets
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to CSV, Excel XLSX or Google Sheets files in Google Drive / Google Sheets on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place. Frozen rows, filters and sorts are preserved upon Sheet refresh. Using importrange and vlookup two Sheets can be linked and merged by ID fields.

Connect QuickBooks Online data to Google Data Studio via Google Sheets.


Destination: Microsoft OneDrive +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect QuickBooks Online data to Power BI via OneDrive.


Destination: Microsoft OneDrive for Business +Excel Online
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to CSV or Excel XLSX files in Microsoft OneDrive for Business on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.

Connect QuickBooks Online data to Power BI via OneDrive for Business.


Destination: Dropbox
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to CSV or Excel XLSX files in Dropbox folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Box
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to CSV or Excel XLSX files in Box folders on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Microsoft Azure
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to blobs in Microsoft Azure on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.


Destination: Amazon S3
Every 10 Minutes, Hourly, Daily

Data IntegrationFull Data Objects

Export QuickBooks Online comprehensive data objects to buckets in Amazon S3 on a recurring, automatic basis. Past and present data records are included. All rows and cells are refreshed in-place.