Long Arrow Right External Link angle-right Search Times Spinner angle-left

Why Aren't My Reports Matching Shopify - Part 2

As covered in our previous article, so long as you're looking at comparable data, our reports should generally match the exact information that is presented in Shopify. 

However, one situation where a known discrepancy can occur is when you look at stores that have the "All prices include tax" option selected in Shopify AND have percentage-based discounts applied to orders.

To explain this a little further, this is caused by the fact that Shopify essentially has 2 ways in which a discount can be calculated when the product's price includes tax, depending on whether this is for the Sales Report or the Orders page. 

Stick with me - because this can get a little complicated! But we promise we'll make it simple at the end. 

Example - A dress with a Total price of $100.00 (incl. 10% Tax Rate) and a 25% Discount.

1.) Sales Report Calculation  

In this report, Shopify deducts the Taxes first and then applies the Discount.

  1. Total Price ($100) / (1+Tax Rate (0.10) = Price to Discount ($90.90)
  2. Price to Discount ($90.90) x Discount Percentage (0.25) = Discount Amount ($22.72)
  3. Price to Discount ($90.90) - Discount Amount ($22.72) = Discounted Price ($68.18) 
  4. Discounted Price = Taxable Price
  5. Taxable Price ($68.18) x Tax Rate (0.10) = Tax ($6.81) 

2.) Orders Page/Orders .CSV Export Calculation.  

In contrast, on the Shopify Orders page (and the subsequent Orders .CSV Export) the Discount is applied first and then the Taxes are deducted. 

  1. Total Price ($100) x Discount Percentage (0.25) = Discount Amount ($25). 
  2. Total Price = Price to Discount.
  3. Price to Discount ($100) - Discount Amount ($25) = Discounted Price = ($75)
  4. Discounted Price ($75) / (1+Tax Rate (0.10)) = Taxable Price ($68.18)
  5. Taxable Price ($68.18) x Tax Rate (0.10) = Tax ($6.81)

Honestly, it's much easier if you can see these numbers side-by-side in a table so you can see how they compare: 

undefined

As you can see, in Method 1, the Tax is removed (blue), and then Discount % is applied to give us the Discounted Price (red). In Method 2, the Discount is applied first (to red) and then the taxes are applied to this amount (blue)  

Note that in either case, only the items in bold have different values, so the most important numbers in either report remain the same - the order totals (Total Price/Total Sales), Discount %, Tax Rate and Tax Amount.

In other words, it is only the Discount Amount, Discounted Price, and Gross Sales that will be different.

Basically, if this all makes your head spin, what you really need to know is - 

For the Sales report, Shopify deducts the Tax first and then applies the Discount %
For the Orders report, Shopify applies the Discount % first and then deducts the Tax.

In Shopify, there is no way (currently) to reconcile the Discount Amounts across the Sales report and Orders. Therefore, merchants should choose between the Sales Report or Order Export CSV report for bookkeeping purposes. 

And remember, again - this only applies to stores that have taxes included in the product prices when applying percentage discounts.

So How Does This Apply to Report Toaster? 

It is this method used on the Orders page (#2 above) that is provided to third-party apps (like Report Toaster), to generate order reports. 

So if you want to compare the numbers in Report Toaster to those reported in Shopify, make sure you compare the numbers with those on the Shopify Orders page, rather than those represented in the Shopify Sales Report

We Are Here to Help!

If you still think there are discrepancies between Shopify's data and what you are seeing in Report Toaster, please let us know. Get in touch using the live chat in the app and let us help troubleshoot. Please just be ready with screenshots that show the discrepancies, as we can't see your Shopify admin.