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.
- Go to Inventory > Adjustment and click New Adjustment.
- Set Action Type to Surplus Adjustment (INV-10).
- Set Date and Location to the warehouse. The Location starts at the default, so change it.
- Check Account. It starts at 4-2006 Inventory Adjustment Gain. You can change it.
- Add lines with Product, Qty and Unit Cost. Unit Cost starts at the product's current cost.
- 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.
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.
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.
Reyuko