[Resolved] Need algorithm to determine what part of an order was charged sales tax

[cafeenman]

Pseudocode:

Keep better records

My record-keeping not withstanding that doesn't resolve the issue.

For example, let's say I do that and keep my business expenses and my personal purchases separate.

So I buy these items from Amazon. This is a shorter, easier list.

Item 1: $19.50
Item 2: $35.50
Item 3: $8.50
Item 4: $127.50
Item 5: $22.50
Item 6: $11.50

I pay 6.5% sales tax. The sales tax charged on this order was $2.02. Which items add up together and charged 6.5% came to $2.02?

Also, let's say we eliminate everything that alone would be more than that. So we can eliminate the $127.50 right away.

I can do this manually but I don't want to. It's time-consuming and tedious.