Costing & reports
What your stock is worth: lots, FIFO and cost per mat
Inventory → item → Costing: raw materials lot by lot at their landed rates, and the actual cost of every mat in stock.
What is the rubber and the mats in the store worth, and why?
Open the item in Inventory and its Costing tab. Bought materials show each lot left and its rate; finished mats show the cost per piece of what is in stock.
1Raw materials: lots and FIFO
WhereInventory → On Hand → Purchased → click the material → Costing
- 1InventoryIn the left menu. On Hand opens first.
- 2PurchasedRaw materials and spares.
- 3Process OilClick the material.
- 4Costing tabWhat the stock in hand is worth, lot by lot.
- 1On hand932.67 kg in the store.
- 2FIFO blended rate₹100.97/kg: the average of the lots still left, by quantity.
- 3Total value₹94,170.29 of oil in stock.
- 4Lots still in stockEach GRN with what is left of it and its landed rate: ₹110, ₹100 and ₹85.
2FIFO: oldest lot first, automatically
Nobody picks lots when logging. Each time production uses a material, Trakto takes it from the oldest lot still in stock, then the next. An example:
| Lot A (Sept) | Lot B (Oct) | Cost | |
|---|---|---|---|
| In stock | 100 kg @ ₹100 | 500 kg @ ₹110 | ₹65,000 |
| A log uses 150 kg | takes all 100 kg | takes 50 kg | ₹10,000 + ₹5,500 = ₹15,500 (₹103.33/kg) |
| Left | — | 450 kg @ ₹110 | ₹49,500 |
The log shows which lot each kg came from; the material's Costing tab shows what is left of each lot.
3FIFO or weighted average
Each bought material has a valuation method, set on the item (Edit Item).
| FIFO (default) | Weighted average (WAC) | |
|---|---|---|
| Stock used | Oldest lot first | Mixed: scooped from any bag or drum |
| Rate of what is used | The rate of the lot it came from | The running average of all stock |
| Costing tab shows | Each lot left, with its rate | The pool and its average rate |
| Good for | Rubber and chemicals in bags used in order | Oil or reclaim tipped into one tank or heap |
Either way, the Wtd Avg Cost card on the Details tab is the average rate of what is in stock now.
4Finished mats: cost per piece
WhereInventory → On Hand → Manufactured → Gym Mat → Costing
- 1InventoryIn the left menu.
- 2ManufacturedFinished and semi-finished goods.
- 3Gym MatClick the product.
- 4Costing tabCost per piece of the mats in stock.
- 1Cost in stock₹4,632.30 per mat: the actual cost of the 1,193 mats on hand.
- 2MaterialsPer mat, at the FIFO cost of the lots each log used.
- 3OverheadsPer mat, absorbed when each log was made.
- 4Stock and valuation1,193 mats worth ₹55.26 lakh.
- 5Materials inside the stockHow much NR, SBR, carbon … sits in today's mats, and at what rate.
This is the actual cost of the mats you hold, built from the logs that made them. It is your stock value and what dispatches take as the cost of goods sold.
5The stock ledger
WhereInventory → On Hand → the item → Movements
- 1MovementsThe item's full stock ledger.
- 2Filter by typeReceipts, dispatches, adjustments, consumption, returns …
- 3One moveDate, what it was and its document, quantity, running balance, rate and value.
- 4Batch detailsClick a row for the lots it touched.
Still stuck?
Book a set-up call. We'll configure your compound, variants and machines with you.