In the second row (Row 2), type the headers from the table above (Sl. No. through Remarks).
This tells you when to reorder.
"Stockout cost per hour: ____ (fill in). This register helps avoid that." Material Stock Register Format In Excel
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |---|---|---|---|---|---|---|---|---|---|---|---|---|---| | Item Code | Material Name | Category | Unit | Min Stock | Max Stock | Reorder Point | Opening Balance (Date) | Received | Issued | Closing Balance | Days to Min Stock | Last Reorder Date | Status (Auto) |
In Row 5, enter the following labels: | A | B | C | D | E | F | G | H | |---|---|---|---|---|---|---|---| | Date | Particulars | Voucher No. | Receipts (Qty In) | Issues (Qty Out) | Balance Qty | Unit Rate ($) | Value ($) | In the second row (Row 2), type the
(Pro tip: Select Row 5, go to "Format as Table" to make it automatically expand and look professional.)
Open a new Excel sheet. Merge and center the top row for your title: "MATERIAL STOCK REGISTER – [COMPANY NAME]." "Stockout cost per hour: ____ (fill in)
Excel formula automatically fills:
To track money, you need Value columns.
= (Opening Value + SUM(Value IN)) - SUM(Value OUT)