Small-Business Inventory & Sales Tracker: Stock, Fees & Profit (.xlsx)

Track what you have in stock, what you sell, and what you actually keep after fees, shipping and the cost of your goods. Made for small sellers: makers, resellers, market stalls and small online shops.

What's inside:

- Setup: up to 10 sales channels, each with its own fee % and fixed fee per order, and up to 12 product categories. Type your real fees. The sample fees are made up, and platforms change their fees.

- Products: up to 100 items with SKU, cost per unit, usual price, starting stock and reorder level. Shows in stock, stock value, sold recently, revenue, profit, margin and a status: OK, Low - reorder, Out of stock or Oversold - check.

- Restock: 500 rows to log new stock you make or buy. Stock goes up on its own.

- Sales: 2,000 rows. Date, SKU, quantity and channel, with optional sale price, shipping charged, shipping you paid and discount. Fees, cost of goods and profit are worked out for each sale.

- Monthly: sales, fees, cost of goods, shipping, profit and restock spend for each month of the year.

- Dashboard: year totals, stock value, low and out-of-stock counts, best seller, and results by channel and by category.

- Instructions tab first, dropdowns, locked formula cells and a layout designed for small screens.

Who it's for: Small sellers who want one simple file for stock and real profit per product, without a paid inventory app.

Everything is typed in by hand. Nothing connects to a store or a sales platform. Sales tax isn't separated out.

Not financial advice. Not tax or accounting advice. The file only does math on the numbers you type in.

Everything is typed in by hand. There is no live data and no account connection. The sample data is made up, so you can delete it and enter your own.

Format: one .xlsx file. Open it in Excel, or upload it to Google Sheets. It uses only standard formulas that both support. No macros, no add-ons, no links to other files.

Delivery: instant download after checkout. The download link is also in your receipt email.

Questions or a problem with the file? Use this store's Contact page, or email the address in your receipt. If the file doesn't work for you, we'll fix it or refund you.

License: personal use. Use it for yourself and your own small business. Please don't resell, share or re-upload the file.

Built and tested with AI assistance.