Template
Rice Mill Finance Tracker
A rice mill makes or loses money in the gap between paddy cost and the realised value of rice plus its by-products — and that gap is decided by yield. This tracker is built for Indian rice mills to follow the money from paddy purchase through milling to sales, capturing the rice recovered, the bran and husk sold on the side, and the credit extended to buyers. It computes your milling yield and the true margin per quintal after by-product income. Use it to know your real cost of production, price rice with confidence, and keep tabs on the credit you have parked with wholesalers and traders.
Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.
What it does
The template follows a rice mill’s economics across the whole cycle rather than treating it as simple buy-and-sell. On the input side you record each paddy purchase — quantity in quintals, rate, and any mandi fees or transport — to build the landed cost. The milling block captures the rice recovered from that paddy (the yield, typically around 65-68%) plus the saleable by-products: bran, which goes to oil units, and husk, used as fuel or in board-making. On the output side you log rice sales and by-product sales, and the sheet works out the realised value per quintal of paddy and the margin after by-product income — the number that tells you whether a paddy lot was actually profitable. A buyer-credit block tracks rice sold on credit to wholesalers so you can see how much of your turnover is still uncollected.
Who it’s for
- Rice mill owners buying paddy from mandis or directly from farmers.
- Custom-milling units processing paddy for traders or government procurement.
- Family-run mills selling rice to wholesalers on credit and by-products for cash.
- Agri-entrepreneurs evaluating milling margins before scaling capacity.
Fields included
How to use it
- Record each paddy purchase — quintals, rate, mandi fee, and transport — to get landed cost.
- After milling, enter rice recovered to compute the yield percentage for that lot.
- Log by-products separately — bran sold to oil units, husk sold as fuel.
- Record rice sales by buyer, noting cash sales versus rice sold on credit.
- Let the sheet compute realised value per quintal of paddy after by-product income.
- Compare cost per quintal against realised value to see the true margin on each lot.
- Track outstanding buyer credit and follow up so collections fund the next paddy purchase.
Preview
| Particulars | Quantity | Rate (₹) | Value (₹) |
|---|---|---|---|
| Paddy purchased (landed) | 1,000 qtl | 2,280 | 22,80,000 |
| Rice produced (67% yield) | 670 qtl | 3,400 | 22,78,000 |
| Bran sold (to oil unit) | 60 qtl | 2,000 | 1,20,000 |
| Husk sold (fuel) | lot | — | 40,000 |
| Buyer credit outstanding | — | — | 14,00,000 |
Free Excel / Google Sheets template — no signup required.
Download Excel template (.xlsx)Example workflow
Annapurna Rice Mill near Raipur buys 1,000 quintals of paddy at ₹2,200 per quintal, with mandi fee and transport adding ₹80, for a landed cost of ₹22,80,000. Milling yields 67% — 670 quintals of rice — plus by-products: 60 quintals of bran sold to an oil unit at ₹2,000 (₹1,20,000) and husk sold as fuel for ₹40,000. Rice sells at ₹3,400 per quintal, giving ₹22,78,000, of which ₹14,00,000 is to wholesalers on 30-day credit and the rest cash. Adding the ₹1,60,000 of by-product income, total realisation is ₹24,38,000 against a landed-plus-milling cost of about ₹23,50,000 — a margin of roughly ₹88,000, or ₹131 per quintal of rice. The tracker makes clear that without the bran and husk income, this lot would have barely broken even, and that ₹14,00,000 is still parked as buyer credit to be collected before the next paddy lot.
Frequently Asked Questions
Ready to put this to work?
Download Excel template (.xlsx)