ERP & Operations SystemsSteel trading Live

OpsHub Steel Operations

A Mumbai steel trading company

One system for a steel trader to run orders, coil stock, dispatch, collections and GST.

Build something like this Ask on WhatsApp

OpsHub · Order SO-2291Weighed

EnquiryQuoteSales orderCoil mappedCuttingLoadingWeighedInvoicedGate passPaid

Dispatch board · today

SO-2291HR coil 2.0 mm → 1250 sheetsWeighed

SO-2288CR sheet 0.8 mm, slit 300Weighed 18.42 MT

SO-2284HR plate 5 mm, cut to lengthCutter queue

Receipt ₹12,40,000 · allocated oldest first

INV-1812 · 41 days₹5,62,300

INV-1840 · 28 days₹4,18,900

INV-1866 · part₹2,60,040

TDS 194Q @ 0.1%₹1,240

Balanced✓ ₹12,41,240

10order stages tracked

9role-based views

0.1%194Q TDS automated

Overview

A steel trading company ran orders, coil stock, truck dispatch, payments and tax filings across phone calls, Excel and Tally. OpsHub follows each order from enquiry to the truck leaving the gate. Each of nine roles sees only their part, and the owner gets a dashboard of sales, collections, overdue customers and bottlenecks.

Before and after

Before

Each order passed through about ten hands, with status kept in heads and WhatsApp.
Steel sells by weight, and mill and weighbridge weights often disagreed.
One bank receipt had to be matched across many invoices, with TDS and credit notes.
GST and TDS reconciliations were rebuilt by hand every month.

What I built

A ten-step order tracker from enquiry to gate pass, with the next action at each stage.
Coil-by-coil stock, cutting instructions, a dispatch board and a weighbridge log.
A receipt allocation workbench with oldest-first matching and automatic 194Q TDS.
GSTR-1, 2B, 3B and 26AS reconciliation screens and a CEO dashboard.

How it works

1
Order
Enquiry, quote and sales order booked against a customer PO.
2
Allocate
A mother coil is mapped from stock or bought from the mill.
3
Cut & load
Cutting instructions go out; the truck is loaded and weighed.
4
Dispatch
Invoice, e-way bill step and gate pass recorded.
5
Collect
Payment allocated to invoices with TDS and notes applied.

What it does

Know where every order is

A ten-step lifecycle tracker with a next action at each stage.

Right screen, right person

Nine roles, with margins visible only to senior staff.

Match payments faster

Receipts applied oldest-first with TDS and credit notes handled.

Weight differences caught

Weighbridge tare and gross recorded at the yard.

Every coil tracked

At yard, under process, part consumed, dispatched.

Ready for the tax return

GST and TDS reconciliation screens with GSTR-1 export.

Under the hood

ReactTypeScriptViteTanStack QueryTailwind CSSRechartsDocker + nginx

One payment split across many invoices with TDS, notes, part-payments and advances.
Role-based visibility that hides margin data from non-senior roles.
Indian formats throughout: lakhs and crores, MT and kg, CGST/SGST/IGST and 194Q.
Dense data screens kept fast with lazy loading and code splitting.

Outcome

Every order’s status is visible without a phone call.

Payment matching follows one consistent rule.

The owner sees overdue customers and bottlenecks on one screen.

SoldBookedOn holdAvailable

Flat 801Sold

2 BHK · 742 sq ft · Agreement ₹92.5 L

Received₹41.6 L

Due now₹4.6 L

ProgressSlab 5

Payment schedule · plinth, slabs 1 to 6, possession

!Cheque 004417 bounced. Linked to receipt R-2291, Flat 801. Net received updated.

MahaRERA inventory reportExport ready

ERP & Operations SystemsReal estate

Sales & Collections System

Live sales, payments and dues for every flat, pulled straight from Tally.

Statement → TallyBalance chain verified

Date	Narration	Debit	Credit	Balance
02 Sep	UPI/SWIGGY/4218…	1,240.00		4,82,116.40	✓
02 Sep	NEFT/MEHTA TRADERS		86,500.00	5,68,616.40	✓
03 Sep	IMPS/OWN A/C ICICI	1,50,000.00		4,18,616.40	✓
04 Sep	ACH/AWS INDIA	18,402.11		4,00,214.29	✓
05 Sep	UPI/RAKESH KUMAR	2,000.00		3,98,214.29	✓
05 Sep	RTGS/SUNRISE DIST.		2,40,000.00	6,38,214.29	✓