Ask the owner of an Indian MSME factory whether the business is profitable and you will get a quick answer, usually from the balance sheet or the Tally profit and loss statement. Ask which of last month's orders made money and which did not, and the answer gets slower. Ask why a particular order lost money, and in most plants nobody can say for certain.
That gap matters because pricing is decided order by order. If an order's actual cost drifts from its quote and nobody measures the drift, the next quotation repeats the same assumption. This guide is for owners, costing heads and sales teams in units from engineering and job-work shops to precision machining and plastics and rubber units. It explains how order margins leak and how a manufacturing ERP such as ERPDrive makes each order's real margin visible.
Why Order Margins Leak Without Anyone Noticing
A quotation is a forecast. It assumes a material rate, a scrap allowance, a setup time, a cycle time, an outsourced process rate and a payment term. Each of those assumptions can be wrong on the day the order is actually made, and each one moves the margin. The problem is not that assumptions are wrong. The problem is that in most factories nobody goes back to check them.
Accounting software cannot do that check on its own. It records the steel bill, the wages and the sales invoice, but not which coil went into which order or how many pieces were scrapped. The costs arrive in ledgers, not against orders.
Here is a simple illustration, with figures chosen only to show the mechanism. Suppose a part is quoted at a price of 100 with material at 55, conversion at 25 and overheads at 10, leaving a margin of 10. If the material rate rises by a few percent after the quote, scrap runs a little above the allowance and the batch needs one extra setup, each change looks minor on its own. Together they can absorb most of that margin of 10, and the order still shows up in the sales register as a normal sale.
Key Takeaway: Margin is decided in the gap between the quote and the shop floor. A factory that measures actual cost order by order can correct its quotes within weeks. A factory that only reads the yearly profit and loss statement learns about the leak a year late, and in aggregate.
8 Ways Indian Manufacturers Lose Margin Order by Order
Problem 1: Quotes That Are Never Compared With Actual Cost
The Problem: The cost sheet is prepared in Excel when the enquiry comes in, the order is won, and the sheet is never opened again. Production happens, invoices go out, and nobody asks whether the cost assumptions held. Errors in the cost sheet survive for years because nothing tests them.
How ERPDrive Solves It: Quotations are built from the product's BOM, standard routing and current purchase rates, and an approved quotation converts into a sales order without re-entry. When the job completes, ERPDrive compares the estimated cost from the quotation with the actual cost from material consumption and job cards.
The Result: Every completed order becomes a check on the quote that won it. Read our guide to quotation and cost estimation.
Problem 2: Material Rates That Move After the Quote
The Problem: Steel, polymer, copper, yarn and paper prices move. An order quoted on last month's rate and purchased on this month's rate loses margin before production even starts, and when purchase bills are entered only in accounts, the rise is noticed at month end, if at all.
How ERPDrive Solves It: Purchase orders and goods receipts carry the actual rate paid, BOM costs roll up from the latest purchase rates, and the Purchase Cost Leakage report shows where the same material is now costing more than before.
The Result: Sales knows when a rate change should go into the next quote or a price revision request. See our guide to raw material price volatility.
Problem 3: Scrap and Rejection Above the Quoted Allowance
The Problem: The cost sheet assumes a scrap percentage. The shop floor may run above it on a difficult part, a new die or a material lot that does not behave. When scrap is written in a register or not recorded at all, the extra material and machine time disappear into the general cost of running the plant.
How ERPDrive Solves It: Job cards record output and scrap at each operation against the production order, rejections are logged with reason codes, and the Production Wastage report shows where material is being lost by product and process.
The Result: Scrap is charged to the order that caused it, and recurring causes become visible. Read our guides to reducing scrap and rejection analysis and rework.
Problem 4: Small Batches Carrying More Setup Time Than Quoted
The Problem: Setup time is a fixed cost per batch, spread over the pieces in that batch. A quote built for one large lot is often delivered in several smaller call-offs, each needing its own setup. The per-piece cost rises quietly, and the original price stays the same.
How ERPDrive Solves It: Each product's routing holds setup time and cycle time separately for every operation, and job cards capture the actual time booked against each production order. Estimated and actual time can be compared for the order as it was really run, not as it was quoted.
The Result: You can see when batch splitting has turned a good order into a weak one, and quote minimum batch quantities accordingly. See our guide to cycle time analysis.
See Quoted vs Actual Cost on Your Own Orders
See how ERPDrive builds quotes from your BOM and routings, captures actual material, time and scrap on the shop floor, and flags orders whose margin has slipped.
Book a Free DemoProblem 5: Job Work That Costs More or Loses More Than Planned
The Problem: Plating, heat treatment, painting and other outsourced processes can be a large part of conversion cost. Rates change, process losses run higher than expected and material sits at vendors. When challans live in a file, none of this is tied back to the order.
How ERPDrive Solves It: The job-work module issues material against a GST challan, tracks pending quantity by job worker and challan date, and records receipts and process losses on return. The ITC-04 report is prepared from the same transactions.
The Result: Outsourced cost and loss are visible per job worker and per order. See our guides to subcontracting and job work and job work GST compliance.
Problem 6: Late Orders That Need Expensive Recovery
The Problem: When an order runs late, the factory pays to recover it: overtime, an urgent purchase at a higher rate, a broken run on another machine or a split dispatch. None of these costs were in the quote, and they are rarely booked against the order that caused them.
How ERPDrive Solves It: Sales orders carry line-wise delivery dates, MRP raises material requirements against them, production is scheduled against capacity, and the Dispatch Delays report shows which orders are slipping before the promised date.
The Result: Late orders are seen early enough to be recovered calmly rather than expensively. Read our guide to on-time delivery and OTIF.
Problem 7: Profitable Orders That Are Paid Late
The Problem: An order that earns a fair margin but is paid months after delivery ties up working capital, and the factory funds that gap through its own cash or borrowing. A customer who always pays late is less profitable than the gross margin on the invoice suggests.
How ERPDrive Solves It: Invoices are raised from the dispatch with GST, e-invoice and e-Way Bill, receivables are tracked against each customer, and the Overdue Payments report shows who owes what and for how long. Accounts sync two ways with Tally.
The Result: Credit terms and follow-up can be set by customer using real payment behaviour. See our guides to accounts receivable and working capital management.
Problem 8: Averages That Hide Which Customers and Products Are the Problem
The Problem: A healthy overall margin can hide a few customers or product families that consistently lose money, carried by the orders that do well. Without order-level data, the loss looks like normal business, and sales keeps chasing the same kind of work.
How ERPDrive Solves It: The Low-Profit Orders report flags orders whose actual cost has eaten into their quoted margin. Reviewing those flagged orders by customer and product family each week shows whether the cause is price, scrap, setup, material rate or job work.
The Result: Repricing, process changes and customer decisions are based on evidence. See our guide to production costing.
Excel and Tally vs an ERP That Costs Every Order
| Area | Excel Cost Sheets and Tally | ERPDrive |
|---|---|---|
| Quotation | Separate cost sheet per enquiry | Built from BOM, routing and current rates |
| Quote to order | Retyped into the order book | Approved quote converts to a sales order |
| Material cost | Month-end purchase ledger | Actual rate at GRN and Purchase Cost Leakage report |
| Scrap | Register or not recorded | Booked on job cards with reason codes |
| Machine and labour time | Assumed from the quote | Actual time on job cards per operation |
| Job work | Challan file, cost in vendor ledger | Pending, losses and ITC-04 from transactions |
| Order margin | Not known per order | Estimated vs actual, Low-Profit Orders report |
| Collections | Ledger ageing only | Overdue Payments report by customer |
Order Profitability KPIs Every Owner Should Track
Track these weekly by customer and product family. Set targets from your own baseline once the data is reliable, rather than from rules of thumb.
| KPI | How It Is Calculated | What It Tells You |
|---|---|---|
| Actual margin per order | Order value minus actual material, conversion, job work and absorbed overhead | Which orders really made money |
| Margin variance | Actual margin minus quoted margin, per order | How accurate your quotes are |
| Material cost variance | Actual material cost against the BOM estimate, per order | Rate rises and over-consumption |
| Scrap against allowance | Actual scrap quantity against the scrap assumed in the quote | Process problems hidden in cost |
| Setup hours per order | Total setup time booked divided by orders completed | The cost of batch splitting |
| Share of low-margin orders | Orders below your target margin divided by orders completed | Whether the problem is a few orders or a pattern |
| Overdue receivables by customer | Amount past the agreed credit period, by customer | Which margins are being eaten by late payment |
How ERPDrive Makes Every Order's Margin Visible
Step 1: Quote From the BOM, Routing and Current Rates
Each quotation is built from the product's BOM, its standard routing with setup and cycle times, and the latest purchase rates, so the margin you promise is based on real inputs rather than an old cost sheet.
Step 2: Convert the Quote Into a Sales Order and Production Plan
An approved quotation becomes a sales order with its delivery dates, MRP raises material and job-work requirements, and production orders carry the estimate forward as the cost baseline.
Step 3: Capture Actual Cost on the Shop Floor
Material issues, job cards with actual time, output and scrap, and job-work receipts with process losses record what each order really consumed while it is being made.
Step 4: Compare Estimated and Actual Cost Per Order
When a job completes, estimated and actual cost are compared, and the Low-Profit Orders report flags orders where actual cost has eaten into the quoted margin.
Step 5: Review Weekly and Feed Back Into the Next Quote
Flagged orders, purchase rate movements, wastage and overdue payments are reviewed every week, and the findings correct the standard times, scrap allowances and rates used in the next quotation.
How to Get Started: A Practical Rollout Sequence
- Pick your top product families. Start with the parts or products that make up most of your sales value.
- Build BOMs and routings. Material per unit with a realistic scrap allowance, and operations with setup and cycle times.
- Load current purchase rates. Use the latest rates from your recent purchase orders so the first quotes are on today's costs.
- Quote and convert in the ERP. Make every new quotation in ERPDrive so each sales order carries its estimate.
- Turn on job cards and material issues. Capture actual time, output and scrap at each operation from the first week.
- Register open job-work challans. Load what is pending at each job worker today so outsourced cost is complete.
- Review weekly. Low-profit orders, purchase rate changes, wastage and overdue payments, with sales, production, purchase and accounts in one meeting.
For the cost building blocks behind each quote, read our BOM cost calculation guide and our guide to labour cost tracking. For a wider view of rollout, read our ERP implementation guide, and if you run accounts in Tally, see ERP vs Tally for manufacturing.
Frequently Asked Questions
What is order-wise profitability in manufacturing?
It is the margin earned on each sales order after its actual costs: the material actually consumed including scrap, the machine and labour time actually booked, outsourced job work, and the overhead absorbed by that time. It is compared with the margin assumed when the order was quoted, so you can see which orders, customers and products really make money.
Why does Tally not show which orders are profitable?
Tally records purchases, sales, expenses and payments at the ledger level. It does not hold the BOM, the routing, the job cards or the scrap booked against each production order, so it cannot work out what a particular order consumed. A manufacturing ERP holds that production data and, in ERPDrive's case, syncs two ways with Tally for accounts.
How does ERPDrive find low-margin orders?
Quotations in ERPDrive are built from the BOM, standard routings and current purchase rates, and convert to sales orders. Job cards then capture actual time, output and scrap, and material issues capture actual consumption. ERPDrive compares estimated and actual cost for completed jobs, and the Low-Profit Orders report flags orders whose actual cost has eaten into their quoted margin.
How often should a factory review order profitability?
Weekly is a practical rhythm for most MSME manufacturers. Review the orders completed that week, the open orders where actual cost is already running ahead of the estimate, and any material where purchase rates have moved. Monthly reviews alone find problems after the next order has already been quoted on the same assumptions.
Should we stop taking low-margin orders?
Not automatically. Some low-margin orders fill spare capacity or keep an important customer. The point is to know which ones they are and why the margin is low, whether that is price, scrap, setup time, material rates or job work, and then decide whether to reprice, change the process or accept the order knowingly.
Conclusion: Know the Margin on Every Order
A factory rarely loses money on one big mistake. It loses it on many ordinary orders where material, scrap, setups, job work or payment ran a little worse than the quote assumed, and none of it shows in a yearly profit figure until the next quotes are already out.
ERPDrive gives Indian manufacturers order-level visibility in one cloud ERP, from the quotation to the shop floor to the payment. Book a free demo to see estimated and actual cost on your own products, or message us on WhatsApp to talk through how you cost orders today.