Finance and payments
Connect QuickBooks to DataxLand
The QuickBooks Online connector reads the company's chart of accounts, journal entries, invoices, payments received, bills, bill payments, customers, vendors and items. Si maps them to the finance and accounting model (chart of accounts, journal lines, receivables and payables) so you get booked revenue, cost of goods sold, gross profit, operating expenses and operating profit, overdue receivables and average days to collect. Set next to your store or marketplace data, it also shows the gap between booked revenue and channel revenue.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with QuickBooks
- A monthly P&L straight from the books, with the same definitions on dashboards and in Si's answers.
- Watch overdue receivables and days to collect, and get an alert when they rise.
- Reconcile booked revenue with net revenue from Shopify, your website or marketplaces such as Shopee.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| accounts | Chart of accounts and account types. |
| journal_entries | Journal entries and their lines by account. |
| invoices | Sales invoices, due dates and balances still owed. |
| payments | Customer payments, linked to invoices. |
| bills | Bills from vendors. |
| bill_payments | Payments made to vendors. |
| customers | Customers (personal columns hashed on load). |
| vendors | Vendors. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Authentication |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Booked revenue | General ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income. | Currency |
| Cost of goods sold (ledger) | Debit postings minus credit postings on the cost of goods sold account (account 632). | Currency |
| Gross profit | Booked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger) | Currency |
| Gross margin % | Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenue | Ratio (%) |
| Selling and administrative expenses | Debit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422. | Currency |
| Operating profit | Gross profit minus selling and administrative expenses. Excludes financial income and expenses and other income and expenses.= Booked revenue - Cost of goods sold (ledger) - Selling and administrative expenses | Currency |
| Credit sales | Total value of credit sales invoices (creating accounts receivable) by invoice date. | Currency |
| Receivables collected | Total value of receivable invoices collected, by collection date. | Currency |
| Overdue receivables | Total value of invoices due in the period that remain uncollected as of the data date. | Currency |
| Average days to collect | Average days from invoice date to collection date for invoices collected in the period.= fin_collect_days_total / fin_ar_collected_count | Number |
| Vendor payments | Total value of payable invoices paid, by payment date. | Currency |
| Booked vs channel revenue gap | Booked revenue minus net revenue computed from retail channel orders. Positive means the books show more than the channels: off-channel revenue (credit sales to dealers) or timing differences in recognition.= Booked revenue - Net revenue | Currency |
Connect QuickBooks in 3 steps
- 1
Create an Intuit app
On Intuit Developer, create an app with the Accounting scope, copy the client ID and client secret, generate a refresh token for the company and note its Realm ID (company ID).
- 2
Add the source
In the workspace choose Add source, find QuickBooks in the connector library, choose to use your own Intuit app, enter the client ID, client secret, refresh token and Realm ID, then click Test connection.
- 3
Choose streams and review
Pick accounts, journal entries, invoices and bills, payments received and made (loaded incrementally); Si proposes which accounts are revenue, cost of goods and expenses, and you approve before the build.
Limits and caveats
- DataxLand does not run the Intuit sign-in for you; you need your own Intuit app and its refresh token.
- Classifying accounts as revenue, cost of goods or expense is a step you approve; the numbers are only as right as the company's chart of accounts and entries.
- The booked-versus-channel revenue gap needs a sales source as well. This is an Airbyte connector (ELv2) run inside DataxLand.
Frequently asked questions
Does DataxLand post entries to QuickBooks?
No. DataxLand only reads accounting data.
Does it work with QuickBooks Desktop?
This connector reads QuickBooks Online through its API; with Desktop, export your reports to Excel.
Who can see the financial numbers?
It follows workspace roles; Si only answers people allowed to ask in that workspace.
Dashboard templates that use this source
Connect QuickBooks and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes