Stock register format for Nepal (Excel and PDF)

What a stock register is for in Nepal

A stock register is a ledger for each item. Every receipt (stock in) and every issue (stock out) goes on its own line, and the balance column shows what should be on the shelf. Shops use it to find shrinkage, which is stock that has gone missing. Pharmacies use it to trace batch and expiry. Hardware and electronics dealers use it to know what to reorder. Every trader uses it at year end, when the stock count has to be explained.

It also links your purchase records to your sales records. Goods come in on a purchase bill and leave on a sales invoice, and the register is where the two meet.

How to fill it in

Use one sheet for each item at each location. Fill in the header once: item name, code, unit, warehouse and the period in both calendars. Enter the opening quantity on the first line. Then record each movement on its own row, with the date in AD and BS, the document number, the party, the batch if you track one, and the quantity in the in or out column.

The balance column is a formula. It takes the balance above, adds what came in and subtracts what went out. The running figure stays correct as you type, and the closing balance appears at the bottom. The value column multiplies the balance by the rate you enter. If you write entries on paper first, print the PDF sheet for the godown.

Common mistakes

How Kuver Books prints it automatically

In Kuver Books nobody types the register. Stock moves when a document is approved, so a sale, a purchase, a return or a transfer writes its own line. The balance for each item at each location is always up to date. Unlimited warehouses on every plan. You also get batch and expiry capture where you need it, low-stock alerts on the items that matter, and stock reports you can filter by Nepali month. The inventory reports are part of 32 built-in reports. See inventory and stock control.