To track raw materials properly, record what you bought, count what is left at month end and work out what you actually used. The formula is simple: opening stock plus purchases minus closing stock equals materials used. That one number, set against sales, tells you whether your margins are healthy.
What should I record?
- Every purchase: date, material, quantity, rate, amount and supplier.
- Opening stock, which is last month's closing figure, valued at what you paid.
- Closing stock, counted on a fixed day and valued at what you paid.
- Wastage, spoilage or rejects, in a separate line.
- Amounts still owed to suppliers.
How often do the purchases arrive?
Perishable inputs are bought weekly or even daily. Non-perishables are bought in bulk when prices dip or cash allows. Credit suppliers send a periodic statement. All of these should land in the same monthly view, so use one purchase log with a column for the material.
How do I work out materials used?
Hypothetical month: opening stock valued at ₹6,000, purchases of ₹22,000, closing stock valued at ₹7,500.
| Line | Amount |
|---|---|
| Opening stock | ₹6,000 |
| Add: purchases | ₹22,000 |
| Less: closing stock | ₹7,500 |
| Materials used | ₹20,500 |
Check: 6,000 + 22,000 = 28,000; 28,000 - 7,500 = ₹20,500. If your sales for the month were ₹48,000, materials were 20,500 / 48,000, about 43 percent of sales. Next month, if materials used are ₹21,000 on sales of ₹40,000, the share is 52.5 percent, and that jump is your signal to look at prices, wastage or discounts.
How do I notice price changes?
Keep the rate per kilogram or per piece in your purchase log. Compare this month's average with last month's. If flour moves from ₹40 to ₹44 per kg, that is ₹4 more on every kilogram: on 100 kg a month, 100 × 4 = ₹400. Small changes across five materials add up faster than one big change. Then decide whether to revise your selling price, change the supplier or accept the lower margin.
Should I value stock at cost or at selling price?
At cost, meaning what you paid. Selling price includes your margin, which you have not earned yet. If you value ₹7,500 of ingredients at what the finished product would sell for, your materials used will look smaller and your margin larger than reality. Confirm with your CA how the closing value is to be shown in your accounts.
What if I cannot count stock exactly?
Estimate, but do it the same way every month. A rough count of bags, tins or rolls and an approximate value is better than a skipped count. A consistent estimate gives you reliable trends even when the absolute figure is slightly off. Do the first careful count with a friend or a family member so the method is clear to the people who will repeat it.
With SpendixAI, the purchases that go through your bank or card appear in an import you review before saving, cash purchases can be added in batches, and a report grouped by category and month shows the purchase totals. The stock count stays in your own notes.
How do I deal with wastage?
Keep a line for spoiled, spilt or rejected material. Hypothetically, if ₹1,200 of the ₹20,500 used was wasted, the waste is 1,200 / 20,500, about 6 percent of materials used. Whether that is acceptable depends on your trade; the trend matters more than any single figure. If it climbs for three months, look at storage, handling and ordering quantities before you blame the supplier.
Monthly checklist
- Enter all purchases with quantity and rate.
- Count closing stock and value it at cost.
- Work out materials used and compare with sales.
- Compare each material's rate with last month.
- Note what you still owe suppliers.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


