I will create an excel inventory tracker with automated stock reports

Serbia

I speak Serbian, English

ERP Key User Excel Reporting KPI Tracking Process Documentation

ERP Key User with almost 20 years in manufacturing operations. I build practical tools that save time: Excel stock trackers, automated reports, KPI dashboards and simple web apps for warehouse, purcha...
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

Other Data Processing Services I Offer