Shopify reconciliation, explained

Margin Reports vs Profit Dashboards: What Each Number Can Prove

Published · Updated
Short answer

Profit dashboards estimate quickly. They connect to your store and ad accounts and keep a profit view current, so you can decide what to spend today. That is a real job and a genuinely hard one.

ProfitRoot ties every figure to Shopify to the cent, syncs nightly, and names any source it is missing instead of estimating. It does not attribute sales to an ad channel.

One number is built to be current; the other is built to be questioned. Most stores need both, and the trouble starts only when a number built for speed is asked to do the other job.

What each number is built from

The first row is the one that matters and the rest follow from it. A continuous profit view exists to be current, which means it must produce a figure before every input has arrived. A reconciled report exists to be checked, which means it can afford to wait and to refuse. Scoring them against each other would grade two designs on the criteria of one.

Profit dashboardsProfitRoot
What it's forOperating pulse. A profit view that updates as the day goes, so you can steer spend without waiting.Verification. A margin report where every figure names the source it came from.
How the number is producedBlended from connected accounts -- store, ad platforms, payment processor -- with attribution modeled across channels.From your Shopify orders, synced nightly, plus the cost files you add. Each figure names its source.
CadenceContinuous. The point is that today's number exists today.Nightly. Every figure names the period it covers.
When the data cannot support a layerThe view stays complete; modeling fills what direct measurement cannot see.The layer is gated and the missing source is named, rather than published as a figure the file cannot carry.
What it connects toYour store and ad accounts, by permission, on an ongoing basis.Your Shopify store, by install. It reads only; it changes nothing in your store.
Ad-channel attributionA core feature -- deciding which channel gets credit for a sale is much of the job.Not attempted at all. ProfitRoot has nothing to say about which channel earned a sale.

Where the two numbers get confused

The failure mode is not the dashboard. It is a number built for a Tuesday decision being carried into a room that expects a traced one -- a lender, a buyer, a board, an accountant closing a year. At that point the question changes from “roughly where are we” to “show me where this came from”, and a figure that was never built to answer the second question cannot start doing so retroactively.

Shopify documents the same separation from its own side: the Shopify Payments activity report "isn’t a statement of revenue for accounting purposes". Different surfaces answer different questions, and a tool that answers one well is not failing at the other.

Shopify Help Center: Shopify Payments activity report (read 29 Oct 2026)

For the method itself -- tie to the source, name every exclusion, gate what the data cannot prove -- see how to make a Shopify number defensible.

What a reconciled report costs

Free to install. Pro is $49/mo and Firm $149/mo, flat, with no order limits, billed by Shopify. Every feature is free for 90 days during founding. Firm adds a saved workspace per client.

Common questions

Can I keep my dashboard and use ProfitRoot?

Yes, and that is the expected setup. They do different jobs: the dashboard tells you what today looks like so you can act on it, and ProfitRoot produces a reconciled report for the moment someone asks where a margin figure came from. Neither replaces the other, and nothing about running ProfitRoot changes what your dashboard does -- it reads your store and changes nothing in it.

Why would a dashboard's profit number and a reconciled report differ?

Because they are built from different inputs for different purposes. A continuous view blends connected sources and models what direct measurement cannot see, which is what lets it be current. A reconciled report waits for the files, ties each figure to the rows behind it, and leaves a layer gated when the data cannot carry it.

What does ProfitRoot do when a figure cannot be proven?

It names what is missing and gates the layer that depends on it. If a period's product costs cover only part of the units sold, the gross margin layer stays gated and the report says which source would close it -- rather than publishing a margin figure that is quietly wrong by the size of the gap. A gated layer is more useful than a filled one, because a filled one gets quoted as a fact three slides later.

Can I see it before signing up?

Yes. The demo runs on a sample store with no account, so you can see a reconciled figure before you install anything. To see the same steps on your own orders, install ProfitRoot from the Shopify App Store.

What this does not tell you

This page is not a review, a ranking or a test. It describes what each kind of number is built from. It does not evaluate how well any dashboard performs its job, and nothing here is a claim that ProfitRoot is more accurate than any other product.

ProfitRoot attributes nothing to an ad channel and is not real-time. It looks ahead twice: next month’s expectation, printed with its tested error, and money in and out for 13 weeks, labelled as a projection. If what you need is to decide this afternoon’s ad spend, a reconciled report is the wrong tool and a dashboard is the right one.

Workspaces belong to the account that created them — there are no team seats or shared logins yet, so each person at your firm works from their own account.

Want to test your store?

Install ProfitRoot and see these steps on your own orders.

Install free from the Shopify App Store

Orders synced from a connected Shopify store are transmitted to and stored on our servers so they can be recomputed on later visits.

Related
ProfitRoot vs A2X vs Link My BooksQuickBooks and Shopify still differ after syncHow to make a Shopify number defensibleAll Shopify reconciliation guidesFree tool: holiday discount check

Sources last checked 2026-10-29.