Knowing how many units you hold is half the job. The other half is knowing what they are worth, because that number sits on the balance sheet as inventory, and every unit that leaves becomes cost of goods sold (COGS, harga pokok penjualan) on the profit and loss. Get the value wrong and gross margin is wrong, every month.
Spreadsheet businesses usually value stock at "the last price we paid", updated whenever someone remembers. An ERP values every movement at the moment it happens, using one consistent costing method. This article explains the three methods Voltrus supports and how to choose.
What the standard says
In Indonesia, inventory follows PSAK 202 (formerly PSAK 14) (Persediaan), which matches IAS 2. The rules that matter for an ERP:
- Inventory is measured at cost: purchase price plus the costs of bringing it to its present location and condition (freight in, import duties, handling). For manufactured goods, cost includes materials, labour and a share of production overhead.
- Cost of interchangeable items is assigned by FIFO or weighted average. LIFO is not allowed.
- Items that are not interchangeable (a specific machine, a serial-numbered unit) use specific identification.
- Standard cost may be used as a measurement technique if the result approximates actual cost, which means standards must be reviewed regularly.
- At each reporting date, inventory is carried at the lower of cost and net realisable value (NRV): if goods can only be sold for less than they cost (damaged, obsolete, prices fell), they are written down.
The same month under three methods
One item, one month. Two receipts at different prices, then one issue:
| Date | Event | Qty | Unit price |
|---|---|---|---|
| 1 Mar | Receipt | 100 | Rp 10,000 |
| 5 Mar | Receipt | 100 | Rp 12,000 |
| 10 Mar | Shipment | 150 |
Total paid: Rp 2,200,000 for 200 units. The question is how that splits between COGS (150 units shipped) and closing stock (50 units left).
Moving average
After each receipt, the unit cost is recalculated as total value ÷ total quantity. After 5 March: Rp 2,200,000 ÷ 200 = Rp 11,000. Every issue uses the current average.
- COGS: 150 × 11,000 = Rp 1,650,000
- Closing stock: 50 × 11,000 = Rp 550,000
FIFO (first in, first out)
The oldest units are assumed to leave first. The shipment takes all 100 units from 1 March, then 50 from 5 March.
- COGS: 100 × 10,000 + 50 × 12,000 = Rp 1,600,000
- Closing stock: 50 × 12,000 = Rp 600,000
Standard cost
The item has a standard of Rp 10,500, set in advance. Stock is always carried at standard; the difference from the actual price goes straight to a variance account when goods are received (the purchase price variance, PPV).
| Event | Inventory at standard | Paid (GRNI) | Variance |
|---|---|---|---|
| 1 Mar receipt | 1,050,000 | 1,000,000 | 50,000 favourable |
| 5 Mar receipt | 1,050,000 | 1,200,000 | 150,000 unfavourable |
- COGS: 150 × 10,500 = Rp 1,575,000, plus net variance of Rp 100,000 expensed in the month
- Closing stock: 50 × 10,500 = Rp 525,000
Side by side
| Method | COGS + variance | Closing stock | Total |
|---|---|---|---|
| Moving average | 1,650,000 | 550,000 | 2,200,000 |
| FIFO | 1,600,000 | 600,000 | 2,200,000 |
| Standard | 1,675,000 | 525,000 | 2,200,000 |
The total is always what you paid. The method only decides when cost reaches the profit and loss. With rising prices, FIFO shows the lowest COGS and the highest stock value; moving average smooths it; standard isolates the price movement in a variance line where management can see it.
The journals behind it
Under moving average and FIFO, a receipt is valued at actual landed cost:
| Account | Debit | Credit |
|---|---|---|
| 1-1300 Inventory | 1,200,000 | |
| 2-1300 Goods Received Not Invoiced | 1,200,000 |
Under standard cost, the 5 March receipt is:
| Account | Debit | Credit |
|---|---|---|
| 1-1300 Inventory | 1,050,000 | |
| 5-9000 Cost Variance | 150,000 | |
| 2-1300 Goods Received Not Invoiced | 1,200,000 |
When the supplier's bill arrives, it clears GRNI at the value the receipts booked (billed quantity × the PO price), so GRNI for the order returns to zero. If the supplier bills a different price, within the three-way match tolerance, the difference goes to 5-9000 Cost Variance, not back into stock: stock already left at the receipt value, so the late difference is a period cost. A freight forwarder's bill works the same way against the freight the receipts accrued (see Freight, landed cost and supplier returns).
The shipment, under any method, is Dr 5-1000 Cost of Goods Sold / Cr 1-1300 Inventory at the method's cost. How operations post to the general ledger shows the full chain.
How each method works in Voltrus
The company setting costing_method is moving_average (the default), fifo or standard.
- Moving average: each receipt re-prices the item at its landed cost, with the PO's freight allocated in.
- FIFO: each warehouse keeps cost layers, one per receipt. Outbound stock uses the oldest layer first. Serial-tracked items use their own layer, which is specific identification. Transfers carry the layer's cost and original receipt date; returns come back at the cost they went out at. Freight that arrives later or a price correction is booked as a cost adjustment on the layer.
- Standard: stock is valued at the item's standard cost, and receipts post the price difference to Cost Variance. Standards come from the cost roll-up on the Cost roll-up page: it builds cost bottom-up from BOMs, routings and work-centre rates (see Product costing). Releasing a new estimate revalues stock in every warehouse in one journal, posted to 5-9300 Standard Cost Revaluation.
Switching method while you hold stock requires revaluing it, and only an admin can do it. Choose once at go-live and keep it; auditors expect the method to be applied consistently from year to year.
Net realisable value: a manual step
Voltrus has no automatic lower-of-cost-and-NRV test. At each year end (or quarter end, if you report quarterly), finance should:
- Pull the slow-moving and dead stock report from the Valuation tab on Stock.
- For each item at risk, estimate the selling price less costs to complete and sell.
- Where that is below cost, post a manual journal at Journals: Dr an inventory write-down expense, Cr an allowance account shown against inventory.
- Reverse or adjust it at the next review.
If goods are physically destroyed, scrap them instead: the scrap movement removes the quantity and posts the write-off in one step.
Proving the number
The valuation report values stock as at any date, using the value each movement actually posted rather than today's cost, and reconciles it to the inventory account in the general ledger. If the two differ, someone has posted a manual journal to the inventory account. That account should only be touched by stock documents.
Checklist
- Pick the costing method before go-live and record why.
- Make sure the PO freight is entered so landed cost is complete.
- Reconcile the valuation report to the inventory account every month.
- Under standard cost, review standards at least once a year.
- At year end, review slow-moving stock and book any NRV write-down.