Wurkzen | Stripe Developers | Page 1

west idolBOT Dec 19, 2022, 2:25 AM

#

sick sphinx Dec 19, 2022, 2:25 AM

#

hello! how can I help?

icy dove Dec 19, 2022, 2:27 AM

#

Ok so we have a slight issue

#

So, we have a main account and now we are working with Connect Accounts, Standard Accounts to be precise... this session originally has 4 items that the final customer is buying, but, following your recommendations (with this link: https://support.stripe.com/questions/passing-the-stripe-fee-on-to-customers, and then with another person here in this chat), we are adding a 5th item where the processing fees (both Stripe fee + our platform fee) are located.

#

The initial 4 items has a Tax Rate (exclusive) and the 5th element doesn't, so taxes are not increased by it
cs_test_b1SlONZipSym8ASRt1KN0Q1nhi0Ug42PjS2MK0ZcpHLm04ltNd78IF1qg5
Everythings works fine when there is no discount applied...... BUT
We also allow discounts, and there's where the problem begins... as per what I've read in the docs, discounts per LINE item are not allowed, it's only one total order discount that you can add (and you can indicate to apply it to "X" product, but not more than one discount applied to one product)

So, as we DO offer the possibility of appliying different discounts per line item, we just add the discount to the total value... but, now we have that 5th line item (the processing fee), that, I repeat, does not have a Tax Rate... however, the discount application seems to alter the way you are calculating taxes, so taxes are not what they should be... let me show you:
cs_test_b1PjrpZkH0byuPMgXVQfLQIN42tu3nlqHtsWPTbRFKIpSznAa0UEYl841U

Taxes in this session should be USD 39.04, but you are applying, I don't know why, USD 39.15
So, look at the first example, the one WITHOUT discount:

Line items value (except the 5th with the fees): 449.97
Tax Rate rates of those line items: 9,08%
449.97 * 0.0908 = 40.86

=> That's CORRECT, you are applying the Tax Rate for the first 4 line items and just ignoring the 5th for taxes calculation
Now, look at the second example, the one WITH a discount:

Line items value (except the 5th with the fees): 449.97
Minus USD 20 discount: 429.97
Tax Rate rates of those line items: 9,08%
429.97 * 0.0908 = 39.04
=> You are showing 39.15 instead, this is not correct"

sick sphinx Dec 19, 2022, 2:33 AM

#

gimme a while to go through this

icy dove Dec 19, 2022, 2:40 AM

#

sure

#

maybe' we're not doing something right

#

we are adding the application fee as a line item / product in the checkout, my developers also said another option was to lump it in with the shipping fee and add a small descriptor like "Shipping & Processing Fee" I didnt like this option because sometimes there is no shipping fee at all so it would cause confusion

sick sphinx Dec 19, 2022, 2:53 AM

#

hrm, so the way Stripe calculates it is that the discount of $20 will be split across the line items proportionally. The tax amount for each line item will then be computed based on the (line item amount minus discount), and is getting rounded before adding up all of the tax amounts.

#

so using prod_MykgiyxTvE9f44 as an example, i think the tax would be (200 - (200 / 474.84 * 20)) * 9.08%

#

yep so

(200 - (200 / 474.84 * 20)) * 9.08% = 17.395 = (rounded) 17.4
(100 - (100 / 474.84 * 20)) * 9.08% = 8.697 = (rounded) 8.7
(49.99 - (49.99 / 474.84 * 20)) * 9.08% = 4.347 = (rounded) 4.35
(99.98 - (99.98/ 474.84 * 20)) * 9.08% = 8.695 = (rounded) 8.7

total tax = 39.15

#Wurkzen