Excel Inventory and Sales Dashboard

via Freelancer ·

Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted1 hour ago
Excel-Based Inventory and Sales Tracking

I am looking for an Excel specialist to create an organized inventory and sales tracking workbook for a small business. The workbook should help manage product details, monitor stock levels, and keep track of daily sales without requiring any complicated setup.

The file should include a product list with item names, product codes, purchase prices, selling prices, and available quantities. It should also allow users to record new stock purchases and daily sales, with stock quantities updating automatically when items are sold or restocked.

I would also like a simple dashboard showing total products, current stock levels, total sales, and low-stock items. Basic formulas and conditional formatting should be used to highlight products that need restocking and make important figures easy to identify.

The workbook should be clearly organized into separate sheets for inventory, sales records, and summary reports. It should be easy to update and suitable for regular business use.

Required Skills: Microsoft Excel, Excel Formulas, Data Management, Conditional Formatting, Pivot Tables.
visual basic data processing data entry excel inventory management excel vba data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.