Excel Stock & Sales Tracker
Budget: $250 – $750 USD
Project Name:
Excel Stock & Sales Tracker with Email Alerts
Project Description:
I need a single, well-structured Excel workbook to monitor inventory and log sales easily. Key requirements:
Product Sheet: SKU, name, category, purchase cost, sale price, supplier, current quantity, and editable reorder point.
Sales Sheet: Enter SKU and quantity sold; stock auto-updates and sale date is recorded.
Low-Stock Alert: Email notification when stock falls below reorder point (color changes or pop-ups optional).
Dashboard: Quick-glance page showing total stock value, items needing replenishment, and daily sales summary.
The file must be easy to maintain, use clear named ranges, concise notes, and no password protection. Simple VBA is allowed only for the email alert.
Timeline: 7 days
Budget: $20–30 USD
Skills Required:
Excel, Excel VBA, Data Management, Data Analysis, Data Visualization, Visual Basic, Data Entry, Inventory Management, Process Automation
Please share what deliverables you’ll provide (template, instructions, short Loom walkthrough, etc.) and any clarifying questions.
Excel Stock & Sales Tracker with Email Alerts
Project Description:
I need a single, well-structured Excel workbook to monitor inventory and log sales easily. Key requirements:
Product Sheet: SKU, name, category, purchase cost, sale price, supplier, current quantity, and editable reorder point.
Sales Sheet: Enter SKU and quantity sold; stock auto-updates and sale date is recorded.
Low-Stock Alert: Email notification when stock falls below reorder point (color changes or pop-ups optional).
Dashboard: Quick-glance page showing total stock value, items needing replenishment, and daily sales summary.
The file must be easy to maintain, use clear named ranges, concise notes, and no password protection. Simple VBA is allowed only for the email alert.
Timeline: 7 days
Budget: $20–30 USD
Skills Required:
Excel, Excel VBA, Data Management, Data Analysis, Data Visualization, Visual Basic, Data Entry, Inventory Management, Process Automation
Please share what deliverables you’ll provide (template, instructions, short Loom walkthrough, etc.) and any clarifying questions.