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.
Key takeaways
- Shopify's order data counts actual orders, while ad platforms count conversions they credit to their own ads under their own rules, one explainer notes.
- Gross sales, net sales and total sales are three different numbers by Shopify's own formulas, so say which one a report uses.
- Shopify's profit reports only include variants that had a cost recorded when they were sold, so missing costs mean missing orders.
- A payout is not an order total: fees, refunds and disputes sit between what customers paid and what reaches the bank.
- Write one definition per metric and one owner per number before you buy a tool.
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.
| Number | System to read it in | What it counts | Owner |
|---|---|---|---|
| Orders | Shopify | Actual orders, with no attribution model | Store operations lead |
| Ad spend and credited conversions | Meta, Google Ads | Conversions each platform credits to its own ads | Whoever runs the ads |
| Payouts | Shopify Payments or your payment provider | Money moved to your bank after fees and refunds | Finance |
| Revenue in the ledger | Accounting software | What has been posted to the books | Finance |
| Support tickets | Helpdesk | Conversations, which can include automated mail that is not a customer | Support 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.
| Source | What it counts | Rule that changes the count | Vendor page |
|---|---|---|---|
| Shopify net sales | Gross sales minus discounts minus sales reversals | Gross sales include pending, canceled and unpaid orders; test and deleted orders are left out | Sales reports |
| Shopify total sales | Net sales formula, plus taxes, shipping and fees | Adds what net sales leave out | Finance reports |
| Shopify Payments payouts | Money moved through Shopify Payments: card payments, refunds, processing fees, disputes, duties and taxes, payouts | Fees come off before the payout, and Deposited does not mean funds are in the bank | Activity report, payout details |
| Meta conversions | Events inside an attribution window | Click-through: 1 day or 7 days after a click. View-through: 1 day after an impression | Meta Business Help |
| GA4 conversions | Conversions credited by an attribution model | Ecommerce events are not automatic, and a missing required parameter drops the event | Google Analytics Help |
| Accounting ledger | What has been posted to the books | Depends on how sales are posted. A2X says its payout summaries match the deposit on the bank feed | A2X |
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.
| Report | Question it answers | Where it comes from | Cadence |
|---|---|---|---|
| Sales and orders | What sold? | Shopify sales and orders reports | Daily |
| Margin by product and order | What did we keep? | Shopify profit reports, with costs filled in | Weekly |
| Ad spend against orders | Is spend producing orders? | Ad platform spend beside Shopify orders for the same dates | Weekly |
| Payouts against the ledger | Does the bank match the sales? | Payments activity report and the accounting software | Monthly |
| Stock and open purchase orders | Is the stock number right? | Your store and inventory system, as in the phantom stock guide | Monthly |
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:
- 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.
- Open the Profit margin by order report for the timeframe you want.
- 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.
- 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.
- 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.
| Line | In Shopify's profit margin by order report | Where else to find it |
|---|---|---|
| Product cost | Yes, from the cost per item you recorded | Supplier invoices or your ERP |
| Shipping cost | Yes, shipping costs paid by your store | Carrier invoices |
| Duties and import taxes | Yes, those paid by your store | Customs and carrier invoices |
| Payment fees | Not named in the report description | The fees group in the Payments activity report |
| Ad spend | No | The ad platforms, for the same dates; share it out by orders or net sales |
| Returns | Sales reversals reduce net sales; return handling cost is not named | Warehouse and carrier records, plus the returns playbook |
| Support cost | No | Helpdesk 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:
- Export the Payments activity report for the month.
- 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.
- Compare the gross figure with the sales reports for the same dates and write down the difference.
- Explain the difference by group: fees, refunds, disputes and taxes.
- 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.
| Method | Best for | Watch for |
|---|---|---|
| Shopify reports, built in | The five reports in this guide | Cost per item is static, so a later cost change is not restated |
| Dashboard tool such as Looker Studio | Store and ad numbers in one view | It shows whatever definitions you feed it, so write them down first |
| Accounting connector such as A2X | Payouts into the ledger | Your chart of accounts and rules stay a person's decision |
| Shopify Flow or an automation tool | Alerts and small rules, as in Shopify Flow, n8n or Make | Integrations run in the background and can fail without notice |
| Warehouse with ETL | Business intelligence across many sources | Someone has to own the pipeline and the definitions |
| Direct API or webhooks | Custom flows a developer maintains | Needs 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.
| Job | Tools named on the pages we read | What to check before buying |
|---|---|---|
| Built-in reports | Shopify Analytics, on any plan per Shopify | Who has the Analytics permission, and which reports you adjusted |
| Dashboard across store and ads | Looker Studio, named in Supermetrics' guide | Which definition of net sales it uses, and who maintains the connections |
| Payouts into the ledger | A2X, 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:
- A map of the data flows between store, ad platforms, payments, accounting software and helpdesk.
- Duplicate and missing records, found by counting the same thing in two systems.
- Reconciliation of sales, refunds, taxes and payouts against the ledger.
- A reporting layer built on written definitions, once the gaps are explained.
- 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.
- 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.
- Week 2, costs. Add a cost per item to every variant, run the profit reports and list the orders that are missing.
- Week 3, payouts. Run the monthly payout check for last month and log what stays unexplained.
- 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.
Keep reading
Guide
Shopify ERP Integration: How It Works and How to Choose
How Shopify ERP integration works, what data syncs, why orders stop syncing, and how to choose between a connector, middleware or a custom build.
16 min read
Guide
Ecommerce Operations: What It Is and How to Manage It
Ecommerce operations is the work behind an online store: inventory, orders, support, reporting and finance. See the process, the KPIs and how to manage it.
16 min read