Module 03 · Warehouses and Stock

Opening Stock per Warehouse with Unit Cost

Enter opening stock per warehouse with a unit cost, then avoid counting it twice. Compare the Opening Balances and surplus adjustment paths step by step.

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

The stock you already hold needs a unit cost when you start using Reyuko, because that cost is the starting point for cost of goods sold and stock value. Reyuko has two ways to enter opening stock, and only one lets you choose the warehouse.

Key takeaways

  • Settings > Initial Setup > Opening Balances posts all its opening stock to the default location only.
  • To enter opening stock for a second warehouse, use a Surplus adjustment, with one document per location.
  • The unit cost you enter becomes the starting cost for Average and FIFO costing.
  • Enter each stock quantity through one path only. Entering it twice doubles the stock.
  • Unit Cost and Stock Value are shown per product, not per warehouse.

Path 1: Opening Balances

Open Settings > Initial Setup > Opening Balances. Section B, Opening Stock per Product, has the columns SKU, Name, Qty and Unit Cost. Use Add Stock Row for each product, or Upload XLS. This section is available from the Intermediate level.

Reyuko posts the section as one Surplus adjustment on the default location. The form has no location column. The journal debits 1-1201 Inventory and credits 3-1004 Opening Balance Equity. Use Save Draft to keep work in progress, then Post Opening Balances.

The XLS import for Opening Stock has an optional Lokasi column. We did not verify what it does with that column, so do not use it for a second warehouse until you have checked your version.

Path 2: Surplus adjustment per warehouse

Use this path for any warehouse other than the default. The Adjustment form takes a location, so each warehouse gets its own document. Each line creates a batch at the unit cost you enter, and Average and FIFO costing start from that batch. The journal debits 1-1201 Inventory and credits the Account for quantity times unit cost.

Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor counts two warehouses:

  • Main Warehouse document: Sugar 1 kg, 400 units at 14,000 = 5,600,000. Cooking oil 2 L, 120 bottles at 36,000 = 4,320,000. Total 9,920,000.
  • Branch Warehouse document: Sugar 1 kg, 150 units at 14,000 = 2,100,000. Total 2,100,000.

Together that is 12,020,000 of opening stock at cost. Stock List still shows one Unit Cost per product, so check each warehouse in Stock Movements, which shows the location and unit cost on each line.

Doing this in Reyuko
  1. Go to Inventory > Adjustment and click New Adjustment.
  2. Set Action Type to Surplus Adjustment (INV-10).
  3. Set Date and Location to the warehouse. The Location starts at the default, so change it.
  4. Check Account. It starts at 4-2006 Inventory Adjustment Gain. You can change it.
  5. Add lines with Product, Qty and Unit Cost. Unit Cost starts at the product's current cost.
  6. Check the Total, then click Post. Repeat for each warehouse.

Every line needs a product and a quantity above zero, and the document needs an account. A zero unit cost is accepted, but no journal is created when the total is zero.

Do not enter the same stock twice

Opening Balances posts to the default location. If the default location already holds sugar from Opening Balances, posting the same sugar again as a surplus adjustment doubles it. Check Stock List before and after each path. See Stock Movements: Tracing Why a Number Changed. Re-posting Opening Balances replaces its own earlier entry, but do not assume it removes an Adjustment you posted separately. Check your version for how to correct a posted Adjustment.

Which offset account?

Opening Balances credits 3-1004 Opening Balance Equity. The Adjustment starts at 4-2006 Inventory Adjustment Gain. If you use both paths, your opening stock is offset in two different accounts. Decide the offset account with your accountant before you post.

Costs are per product, not per warehouse. If sugar costs 14,000 in Main Warehouse and 15,000 in Branch, Reyuko keeps one running cost for sugar across all locations.

Check yourself: which path lets you choose the warehouse?

The Adjustment with Action Type Surplus. The Opening Balances section always posts to the default location, so use the Adjustment for any other warehouse.

Frequently asked questions

Can opening stock be entered per warehouse?

Yes, but not on the Opening Balances page. Section B posts every line to the default location and has no location column. For any other warehouse, create an Adjustment with Action Type Surplus Adjustment (INV-10), set Location to that warehouse, and post one document per location. Each line becomes a batch at the unit cost you enter.

How do I avoid counting opening stock twice?

Enter each product's quantity through one path only. Opening Balances adds stock to the default location, so posting the same product again as a surplus adjustment there doubles it. Check Stock List before and after each entry, and do not post a second opening quantity on the default location unless you have confirmed the first one is not already there.

Which account does opening stock post against?

It depends on the path. Opening Balances credits 3-1004 Opening Balance Equity against Inventory 1-1201. A surplus adjustment starts with 4-2006 Inventory Adjustment Gain as its offset, and you can change it. If you use both paths, your opening stock sits in two different offset accounts, so agree the offset account before you post.

Does the unit cost affect later cost of goods sold?

Yes. Each opening line becomes a batch at the unit cost you typed, and Average and FIFO costing start from that batch. Sales draw on that cost when they post, so a wrong unit cost shifts later cost of goods sold. A zero unit cost is accepted and makes later sales from that batch carry zero cost, so check each cost first.

Can I upload opening stock from Excel?

Yes, Section B of Settings > Initial Setup > Opening Balances has an Upload XLS button. Every line still posts to the default location, because Section B has no location column. For a second warehouse, post a separate surplus Adjustment with that location selected for each location.

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