Automated Excel Inventory Tracker

via Freelancer ·

Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted14 minutes ago
I have outgrown simple spreadsheets and need a single, streamlined Excel workbook that keeps my IT-asset stock levels accurate without manual counting. The core of the file should revolve around purchases and sales logs that automatically update current quantities, letting me see at a glance what is on hand, what has moved, and when I should reorder.

Every item must carry the fundamentals—its name, unique code, category, and supplier—plus real-time stock quantity, an adjustable reorder level, and the exact storage location. When a new purchase or sale is entered, formulas (or Power Query/VBA if cleaner) should instantly recalculate on-hand figures and flag anything that slips below the reorder point. A compact dashboard with key metrics or a pivot summary is welcome for quick decision-making, but accuracy of the live inventory table comes first.

Acceptance will be based on a workbook that:

• Contains a master inventory sheet with the columns noted above
• Includes purchase and sales entry sheets that drive automatic stock calculations
• Recalculates stock and reorder alerts reliably when sample transactions are added
• Remains fully editable so I can extend categories or suppliers later without breaking formulas

Hand over the finished .xlsx file, no external add-ins, ready for me to test with my own data.
visual basic data processing excel inventory management visual basic for apps 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.