Inventory Sales Tracking Excel Sheet
Budget: ₹12,500 – ₹37,500 INR
I need a clean, well-structured Excel workbook that lets me manage inventory while capturing every sale in real time. The core workflow is simple: as I log each transaction, stock on hand should update automatically inside the sheet, and I should be able to pull a Daily Sales Report at the click of a button or via a clear pivot/dashboard layout.
Please build the file so that:
• All products, quantities, and sales data live in one central place yet remain easy to filter and sort.
• A daily report summarises total units sold, revenue, and current balance of each SKU.
• Formulas, tables, or VBA are clearly labelled so I can maintain them later.
If you have ideas for adding low-stock alerts or more advanced analytics, feel free to outline them, but the deliverable I’m hiring for right now is the functioning inventory sheet with reliable sales tracking and the daily report.
Please build the file so that:
• All products, quantities, and sales data live in one central place yet remain easy to filter and sort.
• A daily report summarises total units sold, revenue, and current balance of each SKU.
• Formulas, tables, or VBA are clearly labelled so I can maintain them later.
If you have ideas for adding low-stock alerts or more advanced analytics, feel free to outline them, but the deliverable I’m hiring for right now is the functioning inventory sheet with reliable sales tracking and the daily report.