Cost of goods sold decides your gross margin. A wholesaler buys the same product at different prices over the year, so the cost you assign to each sale matters. Reyuko lets you choose between two methods, and it chooses them per product. The choice is also locked once the product has stock history, so decide it before any opening stock or first receipt.
Key takeaways
- Reyuko offers Weighted Average (the default) and FIFO (First In, First Out), chosen per product.
- The method is locked once the product has any stock movement.
- Cost is per product, not per warehouse. Two warehouses with the same product share one cost.
- Selling more than the cost batches hold is not blocked. The cost falls back to the product's master cost.
- Choose the method with your accountant before you post opening stock or the first receipt.
What each method does
Weighted Average blends the cost of all stock on hand. Each sale takes its cost from that blended figure. FIFO uses the oldest batch first. If the product has Require Expiry Date on, it uses the batch that expires soonest instead. Each receipt or opening stock line creates a batch with its own unit cost.
Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor's cooking oil carton has two batches. Opening stock was 100 cartons at 10,000. A later purchase was 100 cartons at 12,000. Harbor then sells 50 cartons.
| Method | Cost of 50 sold | Value of 150 left | Average cost per carton left |
|---|---|---|---|
| Weighted Average | 550,000 | 1,650,000 | 11,000 |
| FIFO | 500,000 | 1,700,000 | 11,333 |
Both methods total 2,200,000 of stock. The difference is only how that cost is split between cost of sales and stock left. In a rising market, FIFO gives a lower cost of sales. Your accountant should confirm the method for your reporting needs.
The choice is locked
On the product form, the Inventory Valuation Method dropdown is editable only while the product has no stock movement. After the first receipt or sale, the field is replaced by a locked display with a padlock icon. The lock message explains that changing the cost formula is a change in accounting policy.
Reyuko has no conversion step that changes a product from one method to the other. If you made the wrong choice, talk to your accountant before you change anything, and do not try to bypass the lock by editing data.
Costing does not follow the warehouse
The cost engine does not record a location for each batch. So the cost of a product is the same at every warehouse. Stock List shows one unit cost per product, not one per location.
This has two effects:
- With FIFO, transferred goods become a new batch at the destination and count as the newest stock, even if they are older. Check this in your version before you rely on it.
- Reyuko will not separate old and new stock by warehouse for costing. Use the Stock card report to read cost across all locations.
Selling more than the batches hold
Reyuko does not block a sale when the batch stock runs out. For Sales, Stock Count and Adjustment, the cost falls back to the product's master cost. That can make a sale look profitable or unprofitable for the wrong reason. Check Stock Movements for any sale whose cost looks wrong.
- Open Products > Products and open the product.
- In the Stock & Status block, find Inventory Valuation Method.
- Choose Weighted Average or FIFO (First In, First Out).
- Save the product before any opening stock or receipt. After that, the field is locked.
- To check cost, open Inventory > Reports, open the Stock card report and choose the product.
Once the product has a movement, you cannot change the method in Reyuko. Choose before the first opening stock or receipt, not after the first sale.
Check yourself: what is the Average cost after both batches?
Start with 100 cartons at 10,000 and 100 at 12,000. Total value is 2,200,000 for 200 cartons. Average cost is 2,200,000 divided by 200, which is 11,000 per carton.
Reyuko