Accounting OAuth
Sync QuickBooks Online Data
to Flat Files
& Spreadsheets
Automatically sync your QuickBooks Online data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
Historical & Dynamic Data
One-way Sync
For Non-technical Users
About the integration: QuickBooks Online is a web-based accounting software package developed and marketed by Intuit. Flatly integrates with QuickBooks Online's official APIs.
Available Datasets
Flatly can sync the following datasets from QuickBooks Online.
- AccountsAll
- Accounts by Type
- Accounts-Assets
- Accounts-Equity
- Accounts-Expense
- Accounts-Liability
- Accounts-Revenue
- BillsAlltime
- BillsLast X days Date-ranged
- Bills+LineitemsAlltime Combo
- Bills+LineitemsLast X days Combo Date-ranged
- CustomersAll
- Deposits
- Employees
- Estimates-Alltime
- EstimatesLast X days Date-ranged
- Invoices-Alltime
- InvoicesLast X days Date-ranged
- Invoices+Lineitems-Alltime Combo
- Invoices+LineitemsLast X days Combo Date-ranged
- ItemsAll
- Items-Inventory
- Items-Service
- Items-NonInventory
- Payments-Alltime
- PaymentsLast X days Date-ranged
- Payments+Lineitems-Alltime Combo
- Payments+LineitemsLast X days Combo Date-ranged
- Purchases
- Report-AccountList-Alltime
- Report-AccountList-Last X days Date-ranged
- Report-AgedPayableDetail-Alltime
- Report-AgedPayableDetail-Last X days Date-ranged
- Report-AgedPayableSummary-Alltime
- Report-AgedPayableSummary-Last X days Date-ranged
- Report-AgedReceivableDetail-Alltime
- Report-AgedReceivableDetail-Last X days Date-ranged
- Report-AgedReceivableSummary-Alltime
- Report-AgedReceivableSummary-Last X days Date-ranged
- Report-BalanceSheet-Alltime
- Report-BalanceSheet-Last X days Date-ranged
- Report-CashFlow-Alltime
- Report-CashFlow-Last X days Date-ranged
- Report-CustomerBalance
- Report-CustomerBalanceDetail
- Report-CustomerIncome-Alltime
- Report-CustomerIncome-Last X days Date-ranged
- Report-GeneralLedger
- Report-GeneralLedger-Raw
- Report-GeneralLedger-Last X days Date-ranged
- Report-GeneralLedger-Raw-Last X days Date-ranged
- Report-InventoryValuation
- Report-Journal-Alltime
- Report-Journal-Last X days Date-ranged
- Report-Profit+Loss-Alltime Combo
- Report-Profit+Loss-Last X days Combo Date-ranged
- Report-Profit+LossDetail-Alltime Combo
- Report-Profit+LossDetail-Last X days Combo Date-ranged
- Report-SalesByClass-Alltime
- Report-SalesByClass-Last X days Date-ranged
- Report-SalesByCustomer-Alltime
- Report-SalesByCustomer-Last X days Date-ranged
- Report-SalesByDepartment-Alltime
- Report-SalesByDepartment-Last X days Date-ranged
- Report-SalesByProduct-Alltime
- Report-SalesByProduct-Last X days Date-ranged
- Report-TransactionList-Alltime
- Report-TransactionList-Alltime-Raw
- Report-TransactionList-Last X days Date-ranged
- Report-TransactionList-Raw-Last X days Date-ranged
- Report-TrialBalance-Alltime
- Report-TrialBalance-Last X days Date-ranged
- Report-VendorBalance
- Report-VendorBalanceDetail
- Report-VendorExpenses-Alltime
- Report-VendorExpenses-Last X days Date-ranged
- Vendors
Send QuickBooks Online data to
Flatly can sync QuickBooks Online data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- ChatGPT Apps
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.
QuickBooks Online
Tuned at the dataset level
Flatly syncs raw, standard and report format datasets from QuickBooks Online into your sheets and cloud storage systems.
- Superpagination.
- Special pagination mechanisms allow Flatly to fetch data beyond the standard QuickBooks Online API limits.
- Raw, unbridaled data.
- Some data sets are formatted raw, which is ideal for data analysis because business intelligence platforms can only ingest data that is structured for machines.
- Multi-tenant.
- Easily manage hundreds of QuickBooks Online tenants from a single connection manager with health monitoring and sync history.
"Fantastic Tool. If you are looking to extract back-end tables and data to csv, this is the app for you. The interface is easy to use and the tool runs very smoothly."
Matthew Butler
Accruity