Financing, tax rates, and accounting
Hello,
We are trying to figure out why there was a difference in the Discount value when you get the order details via the Orders API and when downloading the Total Sales report (in the shop admin reports).
For the Total Sales report, it shows the Discount value as:
7.26
However, when you check the Order JSON below, the `discount_allocations` amount is:
8.86
Here are the line item details (fields that refer to the particular store have been removed):
"line_items": [ { "fulfillable_quantity": 0, "fulfillment_service": "manual", "fulfillment_status": "fulfilled", "gift_card": false, "grams": 1100, "price": "88.56", "price_set": { "shop_money": { "amount": "88.56", "currency_code": "USD" }, "presentment_money": { "amount": "79.00", "currency_code": "EUR" } }, "product_exists": true, "properties": [], "quantity": 1, "requires_shipping": true, "taxable": true, "total_discount": "0.00", "total_discount_set": { "shop_money": { "amount": "0.00", "currency_code": "USD" }, "presentment_money": { "amount": "0.00", "currency_code": "EUR" } }, "variant_inventory_management": "shopify", "variant_title": null, "tax_lines": [ { "channel_liable": false, "price": "14.37", "price_set": { "shop_money": { "amount": "14.37", "currency_code": "USD" }, "presentment_money": { "amount": "12.82", "currency_code": "EUR" } }, "rate": 0.22, "title": "IT IVA" } ], "duties": [], "discount_allocations": [ { "amount": "8.86", "amount_set": { "shop_money": { "amount": "8.86", "currency_code": "USD" }, "presentment_money": { "amount": "7.90", "currency_code": "EUR" } }, "discount_application_index": 0 } ] } ],
We think this is related to VAT since this order was shipped in the EU. How would we calculate the correct Discount value in this scenario? Thanks!
Solved! Go to the solution
This is an accepted solution.
Hi There,
I would guess that you include tax on your prices? If so, here is an article about the discrepancy. I have been in touch with Shopify support and they have confirmed the difference.
https://support.cloudlab.com/portal/en/kb/articles/why-arent-my-reports-matching-shopify-part-2
Thanks,
Sam
This is an accepted solution.
Hi There,
I would guess that you include tax on your prices? If so, here is an article about the discrepancy. I have been in touch with Shopify support and they have confirmed the difference.
https://support.cloudlab.com/portal/en/kb/articles/why-arent-my-reports-matching-shopify-part-2
Thanks,
Sam
Hi Sam,
You are a lifesaver! Reading the article you posted it seems to be exactly what is happening in our case. I'll implement the solution in there and will send an update, thanks again!
Confirmed that this was the issue, thanks again!
We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024We want to take a moment to celebrate the incredible ways you all engage with the Shopi...
By JasonH Oct 15, 2024