Reseller Inventory + Profit Tracker (Google Sheets): Track inventory, fees, shipping, and real net profit per item
I’m an online reseller, and I kept running into the same problem with inventory systems: they either feel bloated and slow, or they still do not answer the main question clearly, which is “what is my real net profit after fees and shipping?” So I built a Reseller Inventory + Profit Tracker in Google Sheets that stays simple but focuses hard on the numbers that actually matter for reselling.
This Google Sheets reseller profit tracker is designed for practical weekly use. You can track inventory, cost of goods, platform fees, shipping costs, and the net profit per item, so you can quickly see which flips are working and which categories are wasting time. It’s useful whether you sell on eBay, Poshmark, Depop, Mercari, or Facebook Marketplace, because the underlying problem is the same: cash gets tied up in inventory, and you need clarity to make better sourcing decisions.
If you are a reseller, I would love your input on what you track consistently and what you wish an inventory and profit tracker did better. I’m especially interested in views like aging inventory, cash tied up, and profit by category. Gumroad link: judeh1l.gumroad.com/l/reseller-profit-tracker
The "real net profit after fees" focus is exactly right. Most resellers I've talked to discover they've been losing money on certain categories only after doing a proper audit months later.
Views that would be genuinely useful:
Aging inventory is huge - items sitting 60+ days aren't just dead capital, they're often depreciating (especially electronics, seasonal items). A "stale inventory" alert that factors in category-specific decay rates would be powerful.
Profit by source location - not just category, but WHERE you sourced it. Thrift store A vs B, estate sales vs retail arbitrage. This reveals which hunting grounds are actually profitable vs just feel productive.
Time-to-sell distribution - knowing your median days-to-sell by category helps with pricing strategy. If jeans sell in 5 days but jackets take 40, you price jackets higher to compensate for capital lockup.
Fee creep tracking - platform fees change quietly. Having a rolling average of "effective fee rate" per platform would surface when eBay/Poshmark silently raises costs.
One question: how are you handling items that get returned or partially refunded? That's where a lot of "phantom profit" hides - the sale looks good until the return hits 2 weeks later.
Are you considering a way to import sales data automatically, or keeping it manual-entry only?