Why Revenue Numbers Differ Between Synplex and Shopify
Synplex revenue ≠ Shopify revenue. Is something broken?
No. This is normal and expected. Synplex and Shopify calculate revenue differently.
The Two Calculation Methods
Synplex Revenue Calculation
Synplex Revenue = Product Price × Quantity Sold
Example:
├─ Product: Blue T-Shirt
├─ Price: $20
├─ Quantity sold: 10 units
└─ Revenue: $20 × 10 = $200
What Synplex EXCLUDES:
├─ Taxes
├─ Shipping costs
├─ Discounts and coupons
├─ Customer refunds and returns
└─ Transaction fees
Result: Base revenue only, not final customer payment
Shopify Revenue Calculation
Shopify Revenue = Final Amount Paid by Customers
Example:
├─ Product: Blue T-Shirt
├─ Base price: $20 × 10 units = $200
├─ + Sales tax: $16 (8%)
├─ + Shipping: $10
├─ - Discount applied: -$5
├─ = Final customer payment: $221
├─ Minus refunds: -$10 (one return)
└─ = Net revenue: $211
What Shopify INCLUDES:
├─ Everything the customer actually paid
├─ Taxes
├─ Shipping
├─ Adjustments for discounts
├─ Adjustments for refunds
└─ Final settled amount
Result: Total money received from customers
Side-by-Side Comparison
| Factor | Synplex | Shopify |
|---|---|---|
| Base Price × Qty | ✅ Included | ✅ Included |
| Sales Tax | ❌ Excluded | ✅ Included |
| Shipping Costs | ❌ Excluded | ✅ Included |
| Discounts | ❌ Excluded | ✅ Included |
| Returns/Refunds | ❌ Not adjusted | ✅ Adjusted |
| Gift Cards | ❌ No | ✅ Yes |
| Result | Gross revenue | Net revenue |
Real Example: Why Numbers Don't Match
Scenario
You sell 100 Blue T-Shirts at $20 each in January.
Shopify Shows
Shopify Revenue for January: $2,284
Calculation:
├─ Base sales: 100 × $20 = $2,000
├─ Sales tax (8%): +$160
├─ Average shipping: +$200
├─ Discounts (5% off for 10 customers): -$100
├─ 2 returns (refunds): -$76
└─ Net: $2,284
Synplex Shows
Synplex Revenue for January: $2,000
Calculation:
└─ 100 units × $20 = $2,000 (that's it)
The Discrepancy
Shopify: $2,284
Synplex: $2,000
Difference: $284 (12% higher in Shopify)
Why the difference?
├─ Tax: +$160
├─ Shipping: +$200
├─ Discounts: -$100
├─ Returns: -$76
└─ Total adjustment: +$284
Why Synplex Uses This Method
Purpose of Revenue Metric in Synplex
Synplex revenue metric is for product-level performance analysis, not financial accounting:
Synplex asks: "Is this product selling well?"
├─ High revenue = Product is popular
├─ Low revenue = Product is struggling
├─ Revenue trend up = Growing interest
└─ Revenue trend down = Losing interest
Key insight: For inventory planning, we care about sales volume and popularity, not exact customer payment amount.
Why Exclude Taxes & Shipping?
❌ Tax varies by location
└─ NY state: 4%, CA: 8%, Canada: 5%+HST
└─ Can't compare fairly across regions
❌ Shipping varies by method
└─ Free shipping, standard, expedited, international
└─ Distorts revenue picture
└─ Not product-specific
✅ Price × Quantity shows:
└─ How many people wanted this product
└─ At what price point
└─ Clean comparison across products
Why Exclude Discounts & Returns?
❌ Discounts can vary widely
└─ Holiday sales, promotions, loyalty programs
└─ Distorts product comparison
└─ Not fundamental to demand
❌ Returns vary by product
└─ Some products have high return rates
└─ Some have low return rates
└─ We want to see INTENDED demand, not returns
✅ What we want:
└─ "How much did customers want to buy this?"
└─ Not "How much did we actually collect?"
What Each System Is Best For
Use Synplex Revenue For:
✅ Comparing product performance
└─ Which product sells most volume?
✅ Identifying trends
└─ Is interest in this product growing?
✅ Inventory planning
└─ Should I order more of this?
✅ Demand forecasting
└─ What demand patterns do I see?
✅ Product health grading
└─ Is this product healthy or declining?
Bottom line: "How popular is this product?"
Use Shopify Revenue For:
✅ Financial accounting
└─ Total money received
✅ Profitability analysis
└─ Revenue minus COGS
✅ Tax reporting
└─ Sales tax collection
✅ Cash flow planning
└─ What did customers actually pay?
✅ Business metrics
└─ Total company revenue for the month
Bottom line: "How much money did we make?"
Example: Same Product, Different Goals
The Product
Blue T-Shirt, regularly $20, sometimes on sale for $15
Synplex View
January: 100 sold = $2,000 revenue (base metric)
February: 80 sold = $1,600 revenue (fewer sales)
March: 120 sold = $2,400 revenue (more sales)
Insight: March was best seller month
Action: Increase inventory for March next year
Shopify View
January: 100 sold × $20 + tax + shipping - returns = $2,284
February: 80 sold × $18 avg (discounts) + tax + shipping = $1,456
March: 120 sold × $20 + tax + shipping - returns = $2,880
Insight: March had most revenue dollars
Action: Understand profitability with COGS
Both right, different purposes.
Can I Trust Synplex Revenue Numbers?
Yes, But Understand What They Measure
✅ Synplex revenue IS reliable for:
└─ Comparing products to each other
└─ Tracking demand trends
└─ Making inventory decisions
└─ Identifying popular items
❌ Synplex revenue is NOT for:
└─ Financial accounting
└─ Tax reporting
└─ Profitability (use COGS separately)
└─ Total company revenue (use Shopify)
How to Reconcile the Numbers
If You Want to Match Shopify Exactly
Take Shopify number
├─ Include taxes
├─ Include shipping
├─ Subtract discounts
├─ Subtract returns
└─ You get final payment amount
This matches Shopify's revenue metric
but NOT Synplex's inventory-planning metric
If You Want to Match Synplex Method
Take Shopify data
├─ Multiply: Price × Quantity
├─ (Ignore taxes, shipping, discounts, returns)
└─ You get product-level revenue metric
This matches Synplex
and is best for inventory decisions
FAQ
Q: "Is Synplex revenue wrong?"
A: No, it's correct—just different. Synplex excludes taxes, shipping, and adjustments. This is intentional for inventory planning.
Q: "Why does Shopify show more revenue?"
A: Shopify includes taxes, shipping, and shows final customer payment. Synplex shows base revenue only.
Q: "Which number should I use for business planning?"
A: Depends on your goal:
- Inventory planning? Use Synplex
- Financial planning? Use Shopify
- Profitability? Use Shopify minus COGS
Q: "Are the differences always the same?"
A: No, they vary month-to-month based on:
- Tax rates (vary by location)
- Average shipping costs
- Discount usage
- Return rates
Q: "How can I verify the calculations?"
A:
- Take Synplex revenue (e.g., $2,000)
- Go to Shopify and verify the order details
- Calculate: Base price × Quantity = $2,000 ✓
- Add taxes, shipping, discounts = Shopify total
Key Takeaway
Synplex: $2,000 base revenue = "People wanted to buy this"
Shopify: $2,284 net revenue = "People actually paid this"
Both are accurate.
Both are useful.
But for different purposes.
Related Resources
- Data Metrics Reference — Detailed metric definitions
- Metric Troubleshooting — Understanding metrics
- Shopify Revenue — Shopify's revenue reporting
Summary
| Question | Answer |
|---|---|
| Why is revenue different? | Different calculation methods |
| Is something broken? | No, this is normal and expected |
| Which is correct? | Both, for different purposes |
| Which should I use? | Synplex for planning, Shopify for accounting |
| Can I change this? | No, this is how each system works |
Remember: Numbers are both right. They just answer different questions.