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

[cafeenman]

Because I'm stupid, I don't have an actual business account and because I'm stupider I mix my orders on Amazon to include business stuff and personal stuff. I know I should stop doing that.

The way Amazon works is you sometimes get charged sales tax for some of the order but not everything.

So I have to go through and try different combinations of things until I hit the magic number.

So I need something checks various combinations of items and find out which ones were taxed and which ones weren't.

The way I'm doing it now is I built in a calculator that's not really a calculator. It's just a list that I put all the amounts into until I hit the right combination.

It should be simple because I know how much tax I was charged and can figure out the total amount of items that add up to the amount that was charged tax and then figure out which items add up to that. But sometimes the orders are pretty large with lots of items on them.

Even if I separate my business from my personal I'd have the same problem when I enter it into expenses.

This is probably a standard sort of thing but it's taxing my brain too much.