Skip to content
+

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

MetricHow it is computed
Booked vs channel revenue gapBooked revenue − net revenueA large gap that persists signals unrecorded or double-recorded orders.
Operating expenses to channel revenueSelling and administrative expenses ÷ net revenue
Operating profitBooked 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.

MetricDefinitionUnit
Booked vs channel revenue gapBooked 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 revenueCurrency
Operating expenses to channel revenueBooked selling and administrative expenses divided by net revenue of the retail channels.= Selling and administrative expenses / Net revenueRatio (%)
Operating profitGross 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 expensesCurrency
Gross margin %Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenueRatio (%)
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency

Questions you can answer

QuestionShopify onlyQuickBooks + Shopify combined
Does booked revenue match the orders?Books unknownGap by month
How much do operating expenses take?Not availableOperating expenses to channel revenue
Profit on the general ledger?Not availableOperating profit

Steps

  1. 1

    Connect Shopify

    Enter your shop name and the access token of a custom app with read access to orders, products and customers.

  2. 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. 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. 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