Landed cost is the full cost of getting goods into your warehouse: the supplier's price, plus freight, import duties and other charges. If you record only the supplier's price, your stock value and margin look better than they are. Reyuko does not currently allocate freight or import duties into inventory cost. Here are the two practical ways to handle it today.
Illustration: Harbor Wholesale is a fictional business; numbers are examples.
Key takeaways
- Reyuko does not currently allocate freight or import duties into inventory cost.
- Option 1: spread the extra cost into the unit price. Use it only when the supplier bills that cost.
- Option 2: record the cost as an expense, with Cash > Cash Out or a manual journal.
Why the extra cost matters
Harbor Wholesale buys 200 cartons of rice at 50,000 per carton. The supplier price is 10,000,000. A trucking company charges 500,000 to deliver the goods.
Landed cost is (10,000,000 + 500,000) / 200 = 52,500 per carton. If Harbor records only the supplier price, its stock says 50,000 per carton, and every carton sold shows 2,500 more margin than the real figure.
Reyuko values stock by batch cost. Each Purchase Delivery creates a new batch at its net price (price minus discount). See costing: average vs FIFO.
What Reyuko uses for stock value
Stock value comes from the price on the Purchase Delivery line. The Purchase Bill is what you owe the supplier, and it does not move stock. Reyuko does not match a Bill against its Delivery, so a price difference stays in the goods-received-not-invoiced account (2-1103).
Option 1: spread the cost into the unit price
Use this option when the supplier's invoice includes the freight, so the higher amount is really owed.
Spread the freight over the quantity: 500,000 / 200 = 2,500 per carton. The new unit price is 52,500. Enter it on the Purchase Delivery line and on the Purchase Bill line. If you change only one of them, the goods-received-not-invoiced account will not clear to zero, and Reyuko will not warn you.
Do not use this option when a carrier bills you separately. Raising the Bill price would make you owe the supplier 500,000 they never charged.
Option 2: record the freight as an expense
When a carrier bills you separately, record the 500,000 as an expense. Stock stays at 50,000 per carton, and the freight shows as a cost for the period. Stock value and margin are lower than full landed cost, but the books are correct.
Check the account behind a Cash Out category before you use it. The default categories do not match the standard chart in every case. For example, "Transport" posts to 5-2002, which the standard chart names "Office Rent Expense." Change the account if it is wrong for your books.
Import duties work like a tax and differ by country. Read tax by country and check with your tax adviser.
Option 1: spread the cost into the unit price
- Open Purchase > Purchase Delivery for the shipment.
- Set the unit price on each line to the supplier price plus the freight per unit.
- Click Post. Click Finalize only after you check the document, because a finalized document cannot be edited or unposted.
- Open the Purchase Bill from this Delivery and check the copied prices.
Option 2: record the freight as an expense
- Open Cash > Cash Out (Basic and Intermediate levels only).
- Enter the Date, Amount, Category, Cash/Bank Account, Contact and Note. At the Advanced level, the Cash group is hidden, so use Accounting > Journal instead.
Typing the freight as a custom line on a Purchase Bill. It has no SKU, so it does not move stock, and the journal ignores its Account column. Also, changing the price on only the Bill or only the Delivery leaves the goods-received-not-invoiced account unbalanced.
Check yourself: which option?
A supplier's delivered price includes transport on its own invoice. Which option fits?
Option 1, because you owe the supplier the extra amount. If a carrier bills you separately, use Option 2.
Reyuko