I will create an excel inventory tracker with automated stock reports
ERP Key User Excel Reporting KPI Tracking Process Documentation
About this Gig
Tired of calculating stock by hand? I will build a clean Excel workbook that tracks your inventory every day: opening stock + receipts issues + returns = closing stock.
I have almost 20 years of experience in a manufacturing company and work daily as an ERP Key User with receipts, shipments and requisitions. I know what a warehouse report really needs.
You get:
Daily stock table with automatic calculations
Separate sheets for receipts and issues
Printable daily and monthly reports
Low-stock warnings
Short user guide
Please send me your current file or a list of your items before ordering. All communication is in writing, so every detail is clear and documented.
Platform:
Excel
•
VBA
Development technology:
VBA
•
Excel
Expertise:
Formatting
•
Forms
•
Pivot tables
•
Formulas
•
Macros

