I will build an automated excel inventory tracker with reorder alerts

Morocco

I speak English, Arabic, French

51 orders completed

Data analytics and business performance specialist

I help businesses transform raw data into clear insights, automated reports, and better decisions. With experience in data analysis, KPI management, reporting, and process improvement, I create pract...
About this Gig

Are you managing inventory with disconnected files, manual calculations, or unreliable stock balances?


I will build a custom Excel inventory tracker that helps you record stock movements, monitor available quantities, and identify products that require attention.


FEATURES MAY INCLUDE:

  • product and supplier master data
  • stock-in and stock-out transactions
  • automatic current stock calculation
  • low-stock and reorder alerts
  • location and category tracking
  • Power Query imports
  • VBA buttons or forms
  • inventory dashboard and user guide


PACKAGES:

  1. BASIC: Tracker for up to 100 products and 1 location.
  2. STANDARD: Automated system for up to 500 products and 2 locations.
  3. PREMIUM: Multi-location system for up to 1,500 products and 5 locations.


I combine practical inventory knowledge with Excel automation. Every workbook is customized and tested against the agreed sample data.


IMPORTANT:

This is an Excel-based tool, not a cloud WMS or ERP. Live SAP, ERP, API, database, POS, accounting, and simultaneous multi-user integration are not included. VBA and Power Query compatibility depends on your Excel version and operating system.


Please contact me on Fiverr before ordering.

Platform:

Excel

•

VBA

•

Microsoft Office

Development technology:

VBA

•

Power Query

•

Excel

Expertise:

Pivot tables

•

Formulas

•

Macros

•

Dashboard

•

Data validation

My Portfolio