I built a small Python kit that keeps accepted orders, exact duplicates and problem rows separate. The sample ends with $973.69 in accepted orders, and you can trace every number back to the original CSV.
A missing purchase cost should not turn into profit.
I built Order Profit Reconciler to match prepared sales and purchase CSVs. It keeps incomplete orders out of the profit total and shows the calculation behind each result.
In this fictional example, one sale has $110 in net...