How do small sellers (under 100 orders/day) actually track per-ASIN profitability without paying for expensive software?
I’m a developer and I’ve been helping a few small Indian Amazon sellers understand their margins. The problem I keep running into is that the settlement report is a nightmare to parse manually.
For context, a typical settlement report has separate rows for:
– Principal
– Tax withheld
– FBA fees (per unit)
– Referral fees
– Shipping credits and charges
– Promotional rebates
– Liquidation fees
– Disposal fees
– Advertising charges (separate report entirely)
To get true per-ASIN profit, you have to join 3-4 different report types, handle credits and debits correctly, and attribute ad spend manually. This takes hours in Excel.
The expensive tools start at $20-50/month USD and are well worth it at scale — but for sellers doing $2,000-10,000/month GMV, it’s a significant cut.
I’m thinking about building a simpler tool: just upload your flat file settlement report + ad spend report as CSVs, get a clean per-ASIN breakdown of profit, fees, and ad spend. No subscription to a full suite, no API access required.
Three questions:
-
Is this actually a painful problem for you, or have you found a good solution?
-
What’s the #1 thing you wish settlement reports made easier to understand?
-
What would you pay for a simple CSV-upload-only tool that does just this one thing?
Hoping to learn whether this is worth building before I spend months on it.
submitted by /u/Curious_Custard_5088
[link] [comments]