Build Steel Job Work Portal -- 2
₹100-400 INR / hour
Posted 1 minute ago
•
Ends in 6 days
₹100-400 INR / hour
A steel processing company handled job work for more than 140 parties. They tracked every coil’s inward, outward, cutting and scrap manually in Excel. Finding the balance stock for each party took hours, and old coils sitting in the warehouse went unnoticed. I built a Job Work Portal that reads data directly from Google Sheets (live) or from uploaded Excel/CSV files. It calculates everything automatically. Key features: KPI dashboard: total inward, total outward, balance in stock, and pending coils older than a set number of days Party-wise stock statement: Balance = Inward – Outward – Trim/Scrap, for every party Coil-wise stock tracking: coil number, size, inward date, net/cut/scrap MT, balance, and status Stock ageing alerts: highlights coils older than 30/60/90 days, so old stock is followed up Item-wise summary: GP, CR, HR, GI, CL and TP grades with a bar chart Inward + Outward ledger and separate inward and outward registers Skipped rows report: catches bad or incomplete entries, so errors are never hidden Filters by party, item and date range, plus search by party, coil or truck number One-click Excel download of any report Scale handled: 12,558 coils received (1,49,027 MT inward) 16,470 dispatch entries (1,43,265 MT outward) 1,303 coils in stock across 43 parties 1,035 coils flagged as pending for more than 60 days Results: Party-wise stock is available instantly instead of after hours of manual Excel work Management can see old stock right away and follow up with parties Fewer reconciliation errors because invalid entries are flagged automatically
Project ID: 40812981
About the project
Open for bidding
Remote project
Active 57 yrs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗