Module 03 · Warehouses and Stock

Costing: Average vs FIFO for Distributors

Compare FIFO and average cost for wholesale stock. See how each changes cost of sales when prices rise, and how Reyuko sets the method for each product.

5 min readLesson 8 of 11 in this moduleUpdated 2026-10-24

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.

MethodCost of 50 soldValue of 150 leftAverage cost per carton left
Weighted Average550,0001,650,00011,000
FIFO500,0001,700,00011,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.

Doing this in Reyuko
  1. Open Products > Products and open the product.
  2. In the Stock & Status block, find Inventory Valuation Method.
  3. Choose Weighted Average or FIFO (First In, First Out).
  4. Save the product before any opening stock or receipt. After that, the field is locked.
  5. To check cost, open Inventory > Reports, open the Stock card report and choose the product.
The lock is permanent in Reyuko

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.

Frequently asked questions

Should a wholesaler use FIFO or average cost?

Neither is always right. When purchase prices rise, FIFO charges the oldest batch cost first, which gives a lower cost of sales and a higher stock value. Average cost blends all batches, so cost moves more slowly. Pick the method that fits how your stock turns, then confirm the choice with your accountant before you post opening stock.

Which method suits fast-moving or perishable distributor stock?

Stock that sells quickly and carries an expiry date often fits FIFO, because the oldest batch leaves first. In Reyuko, turning on Require Expiry Date makes FIFO use the batch that expires soonest, which behaves like FEFO. For slow-moving goods where batch cost matters less, average cost is simpler to read.

Is there one costing method for the whole company in Reyuko?

No. The Inventory Valuation Method is set per product, with Weighted Average as the default or FIFO. There is no company-wide setting, and services have no method. Once a product has a stock movement, the method is locked, so choose it before the first opening stock or receipt.

Which cost does a sale use once the FIFO batches run out?

Reyuko does not block the sale. When the batches run out, the cost falls back to the product's master cost, so the profit on that sale can look better or worse than it really is. Check Stock Movements for any sale whose cost looks wrong, and confirm the stock figure before you rely on the margin.

Put this into practice in Reyuko

Reyuko's inventory, purchasing, sales, purchasing and reporting tools work together on one ledger, so your stock and your books always agree.

Download ReyukoSee what's included