Reseller Inventory and Profit Tracker Excel for resellers — item pricing after platform fees and shipping, a sales log by platform, stock and inventory, and a monthly P and L dashboard. Know what every item actually…
About this template
Reseller Inventory and Profit Tracker Excel for resellers — item pricing after platform fees and shipping, a sales log by platform, stock and inventory, and a monthly P and L dashboard. Know what every item actually costs — and whether the month actually made money. Built for resellers on eBay, Poshmark, Depop, and Mercari who need to know, item by item and sale by sale, whether the sale price covers what they paid, the platform fees, and the shipping — without accounting software. If an item is losing money after fees, this workbook shows it before you source more of it.
$49
Excel & Google Sheets template — instant download on Etsy
Items and Pricing — acquisition cost, platform fees plus shipping per item, total cost per item, average sale price, and margin in dollars and percent for every item. Change a cost and every sale profit updates by formula.
Sales Log — date, buyer, platform, item, quantity, price per item, revenue, cost per item pulled from the pricing sheet, profit per sale, and margin. Log sales from every platform in one place.
Stock and Inventory — stock line, unit, quantity on hand, reorder point, cost per unit, and stock value. Anything at or below its reorder point is flagged LOW STOCK so you source more before you run out.
Monthly P and L — revenue, item cost, packaging and shipping supplies, sourcing travel, and other expenses by month, Jan-Dec, with net profit and margin. Revenue and item cost are formulas from the Sales sheet.
Dashboard — total revenue, sales, items sold, average sale value, gross and net profit and margin, best item by margin per item and by margin percent, best-selling item, best sale and best platform, costs by category, and low stock count.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Reseller Inventory and Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Reseller Inventory and Profit Tracker track?
The Reseller Inventory and Profit Tracker tracks Items and Pricing; Sales Log; Stock and Inventory; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 1,651.00 from 20 sales and 22 items sold; average sale value 82.55.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.