I’m trying to determine how the math is done on my sales tax and commission for what is sent over to Stripe connect. I have sales tax set for the user, and did an order with two items from two different vendors.
Item 1 from Vendor 1: 40.00 sale (free shipping) + 3.40 tax
Item 2 from Vendor 2: 5.00 sale + 1.00 shipping + .42 tax
Total for order: 49.82
Over on the Stripe Connect end:
49.82 received - 1.74 Stripe Fee = 48.08 net
Vendor 1 is transferred 34.83
Vendor 2 is transferred 5.23
This leaves us as the Marketplace with 8.02.
From that 8.02, we have to remit the 3.82 in sales tax, which leaves us with 4.20 in commission.
However, our commission is set for 9% of the sale price minus the tax, which should be 46.00 (cost of both items). My math shows that should be 4.14.
Can anyone assist with how the math is done on the CS cart end? I have follow up questions on the accounting and what it shows, but for now I just want to be able to say with certainty how CS-Cart calculates all this stuff. If necessary, I can add screenshots of my vendor plans or Stripe Connect addon settings?
EDIT: I also just realized that I had the box checked for “Include Taxes In Vendor Commissions,” which I found confusing, but based on other posts here, I have unchecked. The math still does not add up. I would greatly appreciate if someone could inform me how these calculations are done, and I feel like it would be good to have it in the documentation.
Randy - Alley Cove