Easy

Easy point and click

Fast

Setup in under 5 minutes

Secure

Secure data architecture

QuickBooks Online

QuickBooks Online Integration

One way sync
CRM
OAuth Authentication

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 Power BI

Every 10 Minutes, Hourly, Daily, Weekly


Full DatasetsData IntegrationFlat files

QuickBooks Online is a web-based accounting software package developed and marketed by Intuit.

Power BI

Export and sync comprehensive QuickBooks Online datasets to Power BI using OneDrive or OneDrive for Business as a connector.

Power BI

External Resources about PowerBI: