Material Stock Register Format - In Excel

What are you in? (Construction, Pharmacy, Office Supplies?)

Use this sheet for Material Master Data (Code, Description, UOM, Reorder Level, Safety Stock). This rarely changes. Material Stock Register Format In Excel

| Date | Transaction Type | Material Description | Quantity | Unit Price | Balance | Supplier/Customer | | --- | --- | --- | --- | --- | --- | --- | | 01/02/2023 | Receipt | Material A | 100 | $10.00 | 100 | Supplier X | | 05/02/2023 | Issue | Material A | -20 | $10.00 | 80 | | | 10/02/2023 | Stock Transfer | Material B | 50 | $20.00 | 50 | | What are you in

If you're ready to start, you can download pre-made templates from Microsoft Support , Smartsheet , or ProjectManager . To provide a more tailored format for you: | Date | Transaction Type | Material Description

To start your register, you need an opening balance.

To auto-fill the Description (Column D) based on the Item Code: In of the Transactions sheet, enter this formula: =VLOOKUP(C2,'Item Master'!B:C,2,FALSE)