Automated Sales & Inventory Tracker (Excel) — SkillHaus PH

Tired of manually computing sales and stock balance? 😩

The Excel Sales & Inventory Management System is a ready-to-use, fully automated Excel workbook for small businesses, online sellers, and resellers.

Just enter the sale or purchase — everything else is automatic:

✅ Sales Entry → Inventory automatically decreases

✅ Purchase Entry → Stock and Inventory Value automatically increase

✅ Low Stock Alert when it's time to reorder

✅ Dashboard that shows Total Sales, Profit, and Inventory Value in real-time

✅ Monthly Sales Report with a chart

What's included?

• Dashboard (auto-updating KPIs)
• Products tab (SKU master list + live inventory tracking)
• Sales Entry (dropdown SKU selection, auto profit computation)
• Purchase Entry (auto stock update)
• Sales Report (monthly summary + chart)
• Step-by-step Instructions tab

Perfect for: online sellers, garments/RTW businesses, sari-sari stores, or any small business that needs to monitor stock and sales hassle-free.

Format: Microsoft Excel (.xlsx) — also works in LibreOffice Calc. Comes with sample data so you can immediately see how it works.

This is a solved problem, not just theory.

📌 Self-study product. If you have any questions or want customization, just message me

@ https://www.facebook.com/SkillHausPH

@ email address: maryjoylayron.qboa@gmail.com