QuickBooks Online Integration
Datasets
Accounts by Type
Accounts-Assets
Accounts-Equity
Accounts-Expense
Accounts-Liability
Accounts-Revenue
AccountsAll
Bills+LineitemsAlltime
Bills+LineitemsLast30days
Bills+LineitemsLast365days
Bills+LineitemsLast90days
BillsAlltime
BillsLast30days
BillsLast365days
BillsLast90days
CustomersAll
Estimates-Alltime
EstimatesLast30days
EstimatesLast365days
EstimatesLast90days
Invoices+Lineitems-Alltime
Invoices+LineitemsLast30days
Invoices+LineitemsLast365days
Invoices+LineitemsLast90days
Invoices-Alltime
InvoicesLast30days
InvoicesLast365days
InvoicesLast90days
Items-Inventory
Items-NonInventory
Items-Service
ItemsAll
Payments+Lineitems-Alltime
Payments+LineitemsLast30days
Payments+LineitemsLast365days
Payments+LineitemsLast90days
PaymentsLast30days
PaymentsLast365days
PaymentsLast90days
Report-AccountList-Alltime
Report-AccountList-Last365days
Report-AccountList-Last90days
Report-AgedPayableDetail-Alltime
Report-AgedPayableDetail-Last365days
Report-AgedPayableDetail-Last90days
Report-AgedPayableSummary-Alltime
Report-AgedPayableSummary-Last365days
Report-AgedPayableSummary-Last90days
Report-AgedReceivableDetail-Alltime
Report-AgedReceivableDetail-Last365days
Report-AgedReceivableDetail-Last90days
Report-AgedReceivableSummary-Alltime
Report-AgedReceivableSummary-Last365days
Report-AgedReceivableSummary-Last90days
Report-BalanceSheet-Alltime
Report-BalanceSheet-Last365days
Report-BalanceSheet-Last90days
Report-CashFlow-Alltime
Report-CashFlow-Last365days
Report-CashFlow-Last90days
Report-CustomerBalance
Report-CustomerBalanceDetail
Report-CustomerIncome-Alltime
Report-CustomerIncome-Last365days
Report-CustomerIncome-Last90days
Report-GeneralLedger-Alltime
Report-GeneralLedger-Last365days
Report-GeneralLedger-Last90days
Report-InventoryValuation
Report-Journal-Alltime
Report-Journal-Last365days
Report-Journal-Last90days
Report-Profit+Loss-Alltime
Report-Profit+Loss-Last365days
Report-Profit+Loss-Last90days
Report-Profit+LossDetail-Alltime
Report-Profit+LossDetail-Last365days
Report-Profit+LossDetail-Last90days
Report-SalesByClass-Alltime
Report-SalesByClass-Last365days
Report-SalesByClass-Last90days
Report-SalesByCustomer-Alltime
Report-SalesByCustomer-Last365days
Report-SalesByCustomer-Last90days
Report-SalesByDepartment-Alltime
Report-SalesByDepartment-Last365days
Report-SalesByDepartment-Last90days
Report-SalesByProduct-Alltime
Report-SalesByProduct-Last365days
Report-SalesByProduct-Last90days
Report-TransactionList-Alltime
Report-TransactionList-Last365days
Report-TransactionList-Last90days
Report-TrialBalance-Alltime
Report-TrialBalance-Last365days
Report-TrialBalance-Last90days
Report-VendorBalance
Report-VendorBalanceDetail
Report-VendorExpenses-Alltime
Report-VendorExpenses-Last365days
... a flat-out huge number of resources
Auto export QuickBooks Online data to flat files
Every 10 Minutes, Hourly, Daily, Weekly
Full DatasetsData IntegrationFlat files
QuickBooks Online is a web-based accounting software package developed and marketed by Intuit.
Destination: Google Drive
Export and sync comprehensive QuickBooks Online datasets to Google Sheets, CSV or Excel XLSX files in Google Drive folders on a recurring, automatic basis. Historical data is included. Use Filter Views to sort or filter flattened data. Connect to Google Data Studio via Google Sheets or Google Drive.
Destination: └ Google Sheets
Export and sync comprehensive QuickBooks Online datasets to Google Sheets, CSV or Excel XLSX files in Google Drive folders on a recurring, automatic basis. Historical data is included. Use Filter Views to sort or filter flattened data. Connect to Google Data Studio via Google Sheets or Google Drive.
Destination: OneDrive
Export and sync comprehensive QuickBooks Online datasets to Excel Online XLSX or CSV files in OneDrive folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.
Destination: └ Excel Online
Export and sync comprehensive QuickBooks Online datasets to Excel Online XLSX or CSV files in OneDrive folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.
Destination: OneDrive for Business
Export and sync comprehensive QuickBooks Online datasets to Excel Online XLSX or CSV files in OneDrive for Business folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.
Destination: └ Excel Online
Export and sync comprehensive QuickBooks Online datasets to Excel Online XLSX or CSV files in OneDrive for Business folders on a recurring, automatic basis. Historical data is included. Connect to PowerBI via OneDrive or Excel Online.
Destination: Box
Export and sync comprehensive QuickBooks Online datasets to XLSX or CSV files in Box on a recurring, automatic basis. Historical data is included.
Destination: Dropbox
Export and sync comprehensive QuickBooks Online datasets to XLSX or CSV files in Dropbox on a recurring, automatic basis. Historical data is included.
Destination: Amazon S3
Export and sync comprehensive QuickBooks Online datasets to XLSX or CSV files in Amazon S3 storage buckets on a recurring, automatic basis. Historical data is included.
Destination: Azure Storage
Export and sync comprehensive QuickBooks Online datasets to CSV or Excel XLSX files in Microsoft Azure on a recurring, automatic basis. Past and present data records are included.
Destination: Google Cloud Storage
Export and sync comprehensive QuickBooks Online datasets to CSV or Excel XLSX files in Google Cloud Storage buckets on a recurring, automatic basis. Past and present data records are included. Connect to Google BigQuery and Google Data Studio.
Destination: FTP
Export and sync comprehensive QuickBooks Online datasets to CSV or Excel XLSX files on FTP servers.
Destination: SFTP
Export and sync comprehensive QuickBooks Online datasets to CSV or Excel XLSX files on SFTP servers.
Destination: HubSpot Files
Export and sync comprehensive QuickBooks Online datasets to CSV or Excel XLSX files in HubSpot Files.
