Skip to main content

What we found and fixed for ecommerce brands. Learn more about what we found and fixed for ecommerce brands

All resources

Guide16 min read

Ecommerce Reporting: One Set of Numbers for Your Store

Ecommerce reporting works when every number comes from a named source with a written definition, and every gap between sources has a known cause. Shopify, your ad platforms and your accounting software disagree for four reasons: they define terms differently, they credit sales differently, they collect data differently and they record it at different times. Some of that is normal and some is a bug. This guide gives you a table of why the numbers differ, the five reports a growing brand needs, a method for profit per order, a monthly payout check and a way to choose tools.

By Maksudur Rahman, FounderPublished Last reviewed

Key takeaways

What is ecommerce reporting, and what should it answer?

Ecommerce reporting is a fixed set of reports that tell a brand what it sold, what it cost to sell and what it kept, with one written definition for each number. It is not a dashboard. A dashboard shows numbers. Reporting makes sure they mean the same thing wherever you read them. A report that answers none of what sold, what it cost and what we kept is a candidate to delete. For the wider work around it, see what ecommerce operations covers and the glossary of terms.

Where each number lives

A growing brand keeps its numbers in five places. Each system is the right place to read one thing and the wrong place to read the others. Name one owner for each number, a person and not a tool.

Where each number lives and who should own it
NumberSystem to read it inWhat it countsOwner
OrdersShopifyActual orders, with no attribution modelStore operations lead
Ad spend and credited conversionsMeta, Google AdsConversions each platform credits to its own adsWhoever runs the ads
PayoutsShopify Payments or your payment providerMoney moved to your bank after fees and refundsFinance
Revenue in the ledgerAccounting softwareWhat has been posted to the booksFinance
Support ticketsHelpdeskConversations, which can include automated mail that is not a customerSupport lead

Source: Taggrs and Shopify Help Center. The owner column is our recommendation.

Why do Shopify, Meta, GA4 and your accounting software show different numbers?

They count different things, at different times, under different rules. Only part of the gap is a bug. Sort every gap into one of four causes: definition, attribution, collection or timing. A gap with a known cause is normal. A gap with no known cause is the one to chase.

Definitions differ

Shopify's sales reports define gross sales as product price x quantity before taxes, shipping, discounts and sales reversals, and say pending, canceled and unpaid orders are included. Net sales equal gross sales minus discounts minus sales reversals. Shopify's finance reports define total sales as gross sales minus discounts minus sales reversals plus taxes, shipping and fees.

So one store can report three different sales figures on the same day. Label every report with the one you use.

Attribution differs

An ad platform counts a sale when its own rules say the ad earned it. Meta's attribution settings count click-through events within 1 day or 7 days after a link click, and view-through events within 1 day after an impression. Google Analytics says an attribution model can be a rule, a set of rules or a data-driven algorithm. In Google Ads, data-driven attribution is the default for most conversion actions.

Collection and timing differ

A tool can only count what reaches it. Google says ecommerce events are not collected by Google Analytics automatically, and an event missing a required parameter is treated as a custom event and left out of the report. Audiense, which counts the tracking vendor Elevar among its three businesses, says in a blog post that Shopify purchase data can be 20 to 30% higher than what you see in Meta and GA4. The post credits an image to Elevar and names no study, and the vendor sells conversion tracking, so it is not a benchmark for your store. Use it as a reason to test your tagging.

Money also moves later than orders. A payout marked Deposited was sent to your bank, which does not mean the funds are in your account. Shopify says the bank may still need 1 to 3 business days.

A table of why the numbers differ

Use this table to explain a gap before you try to fix it.

Why the same sale can show up as different numbers
SourceWhat it countsRule that changes the countVendor page
Shopify net salesGross sales minus discounts minus sales reversalsGross sales include pending, canceled and unpaid orders; test and deleted orders are left outSales reports
Shopify total salesNet sales formula, plus taxes, shipping and feesAdds what net sales leave outFinance reports
Shopify Payments payoutsMoney moved through Shopify Payments: card payments, refunds, processing fees, disputes, duties and taxes, payoutsFees come off before the payout, and Deposited does not mean funds are in the bankActivity report, payout details
Meta conversionsEvents inside an attribution windowClick-through: 1 day or 7 days after a click. View-through: 1 day after an impressionMeta Business Help
GA4 conversionsConversions credited by an attribution modelEcommerce events are not automatic, and a missing required parameter drops the eventGoogle Analytics Help
Accounting ledgerWhat has been posted to the booksDepends on how sales are posted. A2X says its payout summaries match the deposit on the bank feedA2X

Source: the vendor pages linked in each row, read 21 Nov 2026. The A2X row is a vendor claim we did not test.

Which reports does a growing ecommerce brand actually need?

Five, run on a fixed rhythm. Everything else is an extra until these five are trusted. This is our view, not a vendor rule, and the cadences are ours too.

The five reports and how often to run them
ReportQuestion it answersWhere it comes fromCadence
Sales and ordersWhat sold?Shopify sales and orders reportsDaily
Margin by product and orderWhat did we keep?Shopify profit reports, with costs filled inWeekly
Ad spend against ordersIs spend producing orders?Ad platform spend beside Shopify orders for the same datesWeekly
Payouts against the ledgerDoes the bank match the sales?Payments activity report and the accounting softwareMonthly
Stock and open purchase ordersIs the stock number right?Your store and inventory system, as in the phantom stock guideMonthly

Source: the report list and cadences are Morsegrid's own view. The Shopify reports are described in Shopify's report types.

Start inside Shopify, and leave the extras for later

Shopify says Analytics' main features are available on any subscription plan, and that staff need the Analytics permission to open reports and dashboards. Leave out attribution dashboards, cohort views and any chart nobody acts on within a week until the five are trusted.

How do you get profit per order from Shopify?

Record a cost per item on every variant and read Shopify's Profit margin by order report, which includes product costs, shipping costs, duties and import taxes paid by your store. Ad spend, return handling and support cost are not tracked per order, so you share them out with one written rule. The result is an average profit per order, not the exact profit of a single order.

Step by step

Start with the cost per item, because every later step depends on it. Then work through these five steps in order:

  1. Add a cost per item to each variant. Shopify says that if a product has variants you need to add a cost per item to each variant, and that the cost is what you paid, excluding taxes, shipping or other costs.
  2. Open the Profit margin by order report for the timeframe you want.
  3. Check coverage. Shopify says profit is reported only for products and variants that had a cost recorded at the time they were sold. If orders are missing, those variants likely have no cost.
  4. In a sheet, take each period total Shopify does not allocate to orders: ad spend for the same dates, payment fees, return handling and support cost. Share each total out by one rule and keep the rule the same every month: the period total divided by the orders in the period, or by each order's share of the period's net sales. With made-up figures, 3,000 of ad spend across 600 orders is 5 per order. Subtract the shares from the order's margin to get average profit per order. Both rules are our method, not a Shopify feature.
  5. Compare the total with your payouts, using the check in the next section.

Why the margin on the product page differs from the report

Shopify's profit reports page gives the formula: net sales minus cost, divided by net sales, times 100. If the cost is 60% of net sales, the margin is 40%.

In its discount example, a T-shirt whose cost is half its list price shows a 50% margin on the product details page. Discount it 25% and it shows a 33% margin on the Gross profit by product report. Both are right: one uses the list price and the other what the customer paid. For discount rules, read ecommerce discount strategy that protects margin.

The limit: cost per item does not move with your costs

Shopify says the Cost per item field holds static data, so profit reports are only relevant to a point in time. For dynamic data, it advises running financial reports in another business system, such as an ERP or accounting system. The ERP integration guide covers how costs reach an ERP.

What profit per order includes

The first three rows follow Shopify's description of the Profit margin by order report. The rest are not named there, so share them out as described in step 4.

What profit per order includes and where else to find each line
LineIn Shopify's profit margin by order reportWhere else to find it
Product costYes, from the cost per item you recordedSupplier invoices or your ERP
Shipping costYes, shipping costs paid by your storeCarrier invoices
Duties and import taxesYes, those paid by your storeCustoms and carrier invoices
Payment feesNot named in the report descriptionThe fees group in the Payments activity report
Ad spendNoThe ad platforms, for the same dates; share it out by orders or net sales
ReturnsSales reversals reduce net sales; return handling cost is not namedWarehouse and carrier records, plus the returns playbook
Support costNoHelpdesk time or a flat monthly allowance

Source: Shopify profit reports and Payments activity report. The last column is our suggestion.

How do you reconcile Shopify sales with payouts and accounting?

Reconcile payout by payout, not order by order. Your bank sees deposits, not orders, and each deposit nets sales, fees, refunds and adjustments into one amount. Match the deposit first, then explain what sits inside it.

What is inside a payout

Shopify's Payments activity report breaks down how money moved through Shopify Payments for a date range and payout currency, with a gross figure before fees and payouts and a fees figure for what was deducted. Expand a group to see line items such as card payments, refunds, disputes or payouts.

The monthly check

Match each payout to a bank deposit first, then explain the gap to your sales reports. Run these steps once a month:

  1. Export the Payments activity report for the month.
  2. Match each payout to a bank deposit, allowing for the 1 to 3 business days a bank can take after Shopify marks a payout Deposited.
  3. Compare the gross figure with the sales reports for the same dates and write down the difference.
  4. Explain the difference by group: fees, refunds, disputes and taxes.
  5. Log anything unexplained, with a name beside it and a date to resolve it.

When a connector does this for you

A2X says its summaries match the deposit on your bank feed so you can reconcile with a single click. For Xero, it says it posts payout summaries as invoices. Those are the vendor's claims and we did not test them. A connector posts the numbers, but someone still owns your chart of accounts and what to do with a dispute. If your ledger lives in an ERP, start with the ERP integration guide.

How do you connect Shopify data to your other tools?

Pick the lightest method that keeps one owner per number. Most brands need Shopify's own reports and a spreadsheet or dashboard tool before they need a warehouse. Move up only when your current method cannot answer a question you ask every week.

Ways to connect Shopify data, from lightest to heaviest
MethodBest forWatch for
Shopify reports, built inThe five reports in this guideCost per item is static, so a later cost change is not restated
Dashboard tool such as Looker StudioStore and ad numbers in one viewIt shows whatever definitions you feed it, so write them down first
Accounting connector such as A2XPayouts into the ledgerYour chart of accounts and rules stay a person's decision
Shopify Flow or an automation toolAlerts and small rules, as in Shopify Flow, n8n or MakeIntegrations run in the background and can fail without notice
Warehouse with ETLBusiness intelligence across many sourcesSomeone has to own the pipeline and the definitions
Direct API or webhooksCustom flows a developer maintainsNeeds a developer, so it is the heaviest option

Source: Shopify Help Center, Supermetrics, A2X and two Shopify Enterprise articles. The Best for and Watch for wording is our reading of them.

Decide data ownership first

Shopify's data management guide advises assigning a system of record to each dataset: the platform that holds the authoritative version. Other systems may display it but should not override it. Write that list before you connect anything. Orders belong to Shopify, spend to the ad platform, cash to the bank and payment provider, and stock to the system of record in the inventory management guide.

Watch for silent failures

Shopify's data management guide says that because integrations run in the background, the issue often surfaces only when reports stop matching. Add one cheap check: each week, count Shopify orders for a date range and the orders in each destination for the same range. A mismatch is the first sign a connection has stopped.

Which ecommerce reporting tools fit which job?

Choose by job, not by brand. We list only tools named on vendor pages we read, and we did not benchmark any reporting tool for this guide.

Tools by job and what to check before buying
JobTools named on the pages we readWhat to check before buying
Built-in reportsShopify Analytics, on any plan per ShopifyWho has the Analytics permission, and which reports you adjusted
Dashboard across store and adsLooker Studio, named in Supermetrics' guideWhich definition of net sales it uses, and who maintains the connections
Payouts into the ledgerA2X, which says it supports Xero (A2X)Whether it supports your channels and accounting software, checked on the vendor page

Source: the vendor pages linked in the table, read 21 Nov 2026. Third-party profit trackers exist, but we did not read their pages for this guide, so we do not list them.

Questions to put to any vendor

Ask for the answers in writing:

  • Which definition of net sales does the tool use, and can you change it?
  • Does it restate history when a product cost changes, or freeze the cost at the time of sale?
  • How does it handle a refund processed in a later month than the sale?

When should you bring in a reporting consultant, and what should they fix?

Bring one in when two systems disagree for a reason you cannot find in a week, or when producing the weekly numbers takes more than a person-day. Both are our rules of thumb, not an industry standard. A good consultant fixes definitions and gaps first and builds new reports second.

What a good scope covers

Look for these five items, in this order:

  1. A map of the data flows between store, ad platforms, payments, accounting software and helpdesk.
  2. Duplicate and missing records, found by counting the same thing in two systems.
  3. Reconciliation of sales, refunds, taxes and payouts against the ledger.
  4. A reporting layer built on written definitions, once the gaps are explained.
  5. A plan with an owner for each report and each fix.

Where do inventory and reporting problems meet?

In the stock number. Shopify's inventory discrepancy guide defines a discrepancy as recorded inventory that does not match what you have in stock, and any report that reads that record, such as margin by product, carries the gap with it. That reading is ours. Decide which system owns stock, as in the inventory management guide, and ask a consultant to show the same SKUs counted in two systems before building a report on top.

How we work on this

Morsegrid diagnoses first, builds inside the tools you already use, writes the procedure down and trains your team. Our ecommerce page describes this work as numbers that reconcile. See what an ecommerce operations diagnosis covers and how to choose a partner.

What is a 30-day plan to get one set of numbers?

Four weeks, one job each, with a named owner. This is our plan. For a wider list of what to fix first, see ecommerce systemization.

  1. Week 1, definitions. Write one definition each for revenue, net sales, margin, new customer and repeat customer. Shopify advises a shared definitions document so reports stay consistent across teams.
  2. Week 2, costs. Add a cost per item to every variant, run the profit reports and list the orders that are missing.
  3. Week 3, payouts. Run the monthly payout check for last month and log what stays unexplained.
  4. Week 4, attribution. Compare ad platform conversions with Shopify orders for the same dates, then write down the gap and its cause using the table of why numbers differ.

Frequently asked questions

Why does Shopify show more orders than Meta or GA4?
Meta credits a conversion to its ads only inside an attribution window, 1 day or 7 days after a click or 1 day after an impression. Shopify counts the orders themselves. A third-party explainer says order data shows the highest number because it has no attribution model. Tagging gaps can widen the difference.
What is the difference between net sales and total sales in Shopify?
Net sales equal gross sales minus discounts minus sales reversals. Total sales equal gross sales minus discounts minus sales reversals plus taxes, shipping and fees. Use net sales for revenue comparisons and say which one a report shows.
Why is my Shopify profit report missing orders?
Shopify says profit is reported only for variants that had a cost recorded at the time they were sold. If orders are missing, those variants likely have no cost. Add a cost per item to every variant, but expect only sales made after that to show profit.
How do I reconcile Shopify payouts with my bank?
Use the Payments activity report for the month and match each payout to a deposit. A payout is not the order total, because fees and refunds sit between them. Shopify says a Deposited status does not mean the funds are in your bank yet, which typically takes 1 to 3 business days.

Start with one afternoon: write the definitions, name the owners and run last month's payout check. If you would like a second pair of eyes first, take the free 3-minute assessment and see which areas of your store to fix first.

How well does your store run?

Score six areas of your store, from stock to support, and see the three to fix first.

Take the Free Assessment About 3 minutes. Results instantly.