How can I calculate tax with a flat discount and variable tax rates, ensuring accuracy down to the cent?

Question

question

jtg763 asked Oct 20, '23 bryanvargas commented Nov 9, '23

How can I calculate tax with a flat discount and variable tax rates, ensuring accuracy down to the cent?

If I have a total purchase composed of:

Item A with a price of $20 and a quantity of 2, subject to a 10% tax rate.
Item B with a price of $10 and a quantity of 3, subject to a 5% tax rate.
Item C with a price of $5 and a quantity of 1, subject to a 7% tax rate.

In this scenario, the subtotal for the items amounts to $75.

If a flat $10 discount is applied to the subtotal, how can I accurately distribute this discount among the items, considering their respective tax rates, to ensure the final amount is correct to the cent?

Taxes

1

10 |2000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bryanvargas ♦♦ commented · Nov 09, 2023 at 02:38 PM

Clover only has two ways to do the discount, order discount (uses the subtotal regardless of what tax rate an item has) and item by item discount. If you need a break down of each item discount, I would recommend using the item by item discount instead of the subtotal.

0 ·

Welcome to the
Clover Developer Community

Answer 1 · 2023-11-09T07:20:37Z

jefflawson1 answered Nov 9, '23 jefflawson1 edited Nov 9, '23

To distribute the $10 discount accurately, calculate each item's share based on its proportion to the total pre-discount cost, considering the individual tax rates for precise cent accuracy.

10 |2000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question