I, a vendor, need to find the sales tax from a tax included price that does NOT apply tax to the portion of the total that IS tax. Most answers result in overpayment of taxes.
Please do not tell me this: receipts from items subject to sales tax, divide the receipts by 1 + the sales tax rate. For example, if the sales tax rate is 6%, divide the total amount of receipts by 1.06. If the sales tax rate is 7.25%, divide the total receipts by 1.0725. Variations of this formula are provided everywhere I search and it is incorrect/incomplete for this situation.
Problem with this above answer: I am using my wholesale rate, NOT a sale + tax total. If I use the above formula, I will pay taxes on each of the three components of the price 1) wholesale cost 2) my markup or profit and 3) the local tax amount, all of which are a part of the tax included sale price. This means that I am paying tax on the tax. Is there an algebraic solution? Thank you for your consideration.
short answer: multiply the tax included price by $.063231850$ to calculate the tax you should charge- this gives you $3.79.$
$.06323185$ is equal to the tax rate divided by $(1$ + tax rate) or $\dfrac{.0675}{1.0675}$
Another way to view this problem is to break it up into pieces.
1) untaxed price
2) markup
3) combined price plus tax
4) subtract out 60 that the customer has already paid.
The first step IS to divide the customer price (which includes tax) by $1.0675$ to get the original untaxed price.
Add your markup to this untaxed price to get a subtotal.
Multiply this subtotal by the tax rate of $1.0675$ to get the tax amount.
Add the tax amount to the subtotal to get a total price.
Subtract out $60.00$ since the customer has already paid it.
Hope this helps.
Regards,
Laine