Simple Excel Inventory Tracking Sheet

I need a clean, easy-to-maintain Excel file that lets me keep tabs on every product I sell, warns me whenever stock falls below a set threshold, and logs each sale so I can see movement at a glance. All data will be typed in manually, so the layout must be intuitive for fast entry—no macros that complicate things, just smart formulas and, if useful, a bit of conditional formatting for the visual alerts.

Because I want this up and running as soon as possible, I’m looking for a ready-to-use workbook with these key elements:

• Product tracking table showing SKU, name, category, purchase cost, sale price, supplier, current quantity, and reorder point.
• Automatic stock level alerts that turn the quantity cell red (or trigger a clear visual cue) when it drops below the reorder point.
• Simple sales recording sheet that deducts sold units from the main inventory and date-stamps each transaction so I can filter by day, week, or month.
• Dashboard or summary section that totals current stock value and highlights items needing replenishment.

Please keep the file unlocked so I can tweak column names later if needed. A brief note explaining any formulas you build will help me maintain the sheet confidently. I’m ready to review and approve as soon as I see it working—speed is vital, but clarity and reliability come first.