I will build a custom excel vba inventory system

Algeria

I speak English, French, Arabic

Banking Finance Professional Risk Performance Management

I am a banking professional with over 9 years of experience in credit commitments, financial analysis, risk management, and performance monitoring. I have successfully managed Core Banking System migr...
About this Gig

Are you struggling with manual stock tracking, inventory discrepancies, or disorganized spreadsheets?

I develop robust, automated, and intuitive Excel & VBA Inventory Management Systems designed to give you full control over your warehouse, stock levels, and supply chain operationswithout expensive recurring SaaS software.

Key features included:

  • Real-Time Stock Monitoring: Live tracking with automated low-stock and reorder alerts.
  • Movement Logs: Fast logging for Purchase Orders (PO), Receptions, and Delivery Notes (DN).
  • Custom VBA UserForms: Quick data-entry forms with dynamic search and barcode scanner support.
  • Valuation & Costing: Accurate inventory valuation using Weighted Average Cost (PMP) or FIFO.
  • Executive Dashboard: Visual KPI cards, turnover analysis, and top-selling item metrics.
  • 1-Click PDF Export: Clean generation of delivery notes and audit sheets.

Why choose this solution?

  • Standalone .xlsm file with lifetime access (zero subscriptions).
  • Tailored to your specific product catalog and warehouse structure.
  • Clean, bug-free VBA code optimized for speed and daily ease of use.

Please contact me before ordering so we can discuss your specific workflow!

Platform:

Excel

•

Google Sheets

•

VBA

Development technology:

VBA

•

Excel

•

Power BI

Expertise:

Formatting

•

Fixing

•

Forms

•

Pivot tables

•

Formulas