Combine QuickBooks with Shopify to reconcile your books with channel revenue
Shopify knows orders and revenue by channel; QuickBooks knows booked revenue, cost of goods, and selling and administrative expenses. Accountants usually reconcile the two with exported files at the end of each month. With both sources combined, DataxLand computes the gap between booked and channel revenue, operating expenses as a share of channel revenue and operating profit, so you see right away which month the books drift from the orders, and why. The owner gets one picture: profit by channel from orders and profit on the general ledger, in one place.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Booked revenue can differ from channel revenue because of recognition timing, refunds or orders not yet recorded.
- Operating expenses only exist on the general ledger; channel profit from orders does not subtract them.
- Automatic reconciliation on every build replaces the manual month-end check.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Booked vs channel revenue gap | Booked revenue − net revenueA large gap that persists signals unrecorded or double-recorded orders. |
| Operating expenses to channel revenue | Selling and administrative expenses ÷ net revenue |
| Operating profit | Booked revenue − cost of goods − selling and administrative expenses |
| Gross margin % | (Booked revenue − cost of goods) ÷ booked revenue |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| 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 |
| Operating expenses to channel revenue | Booked selling and administrative expenses divided by net revenue of the retail channels.= Selling and administrative expenses / Net revenue | Ratio (%) |
| 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 |
| Gross margin % | Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenue | Ratio (%) |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
Questions you can answer
| Question | Shopify only | QuickBooks + Shopify combined |
|---|---|---|
| Does booked revenue match the orders? | Books unknown | Gap by month |
| How much do operating expenses take? | Not available | Operating expenses to channel revenue |
| Profit on the general ledger? | Not available | Operating profit |
Steps
- 1
Connect Shopify
Enter your shop name and the access token of a custom app with read access to orders, products and customers.
- 2
Connect QuickBooks
Enter the client ID, client secret, refresh token and realm ID of an Intuit app with read access to your books.
- 3
Review Si's mapping
Si proposes which QuickBooks accounts are revenue, cost of goods and operating expenses, to map into the standard chart of accounts; you approve.
- 4
Build and read the dashboards
The Books and sales channels and the Business results and budget dashboards show the gap and profit; ask Si why this month is off.
Frequently asked questions
What if my QuickBooks chart of accounts differs from the Vietnamese standard?
Si proposes how each account maps into a standard group (revenue, cost of goods, selling expenses, administrative expenses); you adjust it during review. The mapping is saved and reused for every build.
Do I need my own Intuit app?
The QuickBooks connector needs the client ID, client secret, refresh token and realm ID of an Intuit app with read access to your company. DataxLand only reads and never creates journal entries.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect QuickBooks →Connect Shopify →Ask Si about your QuickBooks data →Ask Si about your Shopify data →
Other combinations
Combine QuickBooks and Shopify in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes