A basic register works, but a smart register alerts you. Here is how to upgrade your format.
To ensure you don't type "Bolt" as "Boltt," use Data Validation. Material Stock Register Format In Excel
To auto-fill the Description (Column D) based on the Item Code:
In Cell D2 of the Transactions sheet, enter this formula:
=VLOOKUP(C2,'Item Master'!B:C,2,FALSE) A basic register works, but a smart register alerts you
This section records every single transaction (Received or Issued). To auto-fill the Description (Column D) based on
| Column | Field Name | Description | | :--- | :--- | :--- | | H | Date | Day of transaction | | I | Voucher/Ref No. | GRN (Goods Receipt Note) or Material Issue Slip number | | J | Receipt (In) | Quantity added to stock | | K | Receipt Rate ($) | Purchase cost per unit | | L | Receipt Value ($) | (Receipt Qty * Rate) | | M | Issue (Out) | Quantity removed from stock | | N | Issue Rate ($) | Cost method (FIFO/LIFO/Weighted Avg) | | O | Issue Value ($) | (Issue Qty * Rate) | | P | Balance Qty | (Opening + Total Receipts - Total Issues) | | Q | Balance Value ($) | (Opening Value + Receipt Value - Issue Value) | | R | Remarks | Damage, Return to Vendor, Transfer, etc. |