Material Stock Register Format In Excel May 2026

(Replace column references to match your sheet layout; use INDEX/MATCH or SUMIFS for more robust per-item running totals.)

Let’s build this from scratch. Open a blank Excel workbook and follow along.

While this article focuses on Excel, the same logic applies to Google Sheets. However, Google Sheets offers GOOGLEFINANCE for currency conversion and better collaboration. For strict offline work or complex VBA macros, Excel remains superior.

---

"The Lean Material Tracker: A Dynamic Stock Register for Zero Waste & Just-in-Time Replenishment" Material Stock Register Format In Excel

---

While I cannot attach a file here, use the following table to manually recreate a professional format.

Template Name: "Dynamic Material Stock Register v2.0"

Sheet 1: Settings

Sheet 2: Items

| Code | Name | UoM | Opening | Reorder Lvl | Max Lvl | Unit Cost | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | RM-01 | Raw Plastic | Kg | 500 | 200 | 2000 | 2.50 |

Sheet 3: Transactions (Columns A to J)

| Date | Ref | Code | Type | Qty | Unit Price | Total Price | Running Balance | Remarks | User | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 01-Jan | GRN-01 | RM-01 | In | 100 | 2.50 | 250 | 600 | PO #123 | Admin |

Formula for Running Balance: =IF(D2="In", G1+C2, G1-C2) (Assuming G1 is previous balance)

---

To make the register dynamic, you need to input the following formulas. (Assuming your data starts at Row 2). (Replace column references to match your sheet layout;