Build Steel Job Work Portal -- 2

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