Small Business Inventory & Sales Tracker Spreadsheet

Track stock, costs and sales for a small shop with low-stock alerts and a profit dashboard.

Stock, budget and sales in one connected workbook. Every sale lowers stock, every purchase raises it and counts as spending, and a dashboard shows plan vs. actual for any month.

• Products sheet: unit cost, shipping, channel fee and desired margin give you the suggested price, real margin, live stock and a REORDER alert
• Sales, Purchases and Expenses logs (1,000 / 500 / 500 rows) with drop-downs
• Budget sheet: plan vs. actual by month for sales, stock purchases, fees and 6 expense categories (OVER/OK flags)
• Dashboard: pick a month, see plan vs. actual, profit, stock value, products to reorder, top 5 earners and charts
• Any currency and year. No macros, no subscriptions, instant download

Works in Excel and Google Sheets. Includes English and Spanish versions. Management tool; not accounting or tax advice.