Material Stock Register Format In Excel [2021]

Convert your data range into an (Shortcut: Ctrl + T ).

Until you reach that limit, however, is the most powerful, cost-effective tool ever created for small business inventory control.

Go to the "View" tab and select "Freeze Top Row." This keeps your headers visible as you scroll down. Material Stock Register Format In Excel

Open a new Excel sheet. In , type the headers from A1 to L1 as mentioned above.

Assuming:

Protect cells containing formulas to prevent accidental deletion or overwriting by other users.

These columns track the physical flow.

💡 A stock register is only useful if it reflects the current reality. Input data as soon as the physical movement occurs.

| Column | Header Name | Formula / Logic | | :--- | :--- | :--- | | K | | Previous Balance + Receipt - Issue | | L | Stock Value | Closing Stock Qty * Rate | Convert your data range into an (Shortcut: Ctrl + T )

You can tailor the columns specifically to your industry, like adding "Batch Number" for manufacturing or "Site Location" for construction.

Date | Particulars | Doc.No | Mat.Code | Mat.Name | Unit | In | Out | Balance 01-Apr-26 | Opening Stock | OS/001 | M-101 | Cement OPC | Bags | 500| 0 | 500 05-Apr-26 | Purchase | PO/101 | M-101 | Cement OPC | Bags | 200| 0 | 700 08-Apr-26 | Issued to Site A| IN/045 | M-101 | Cement OPC | Bags | 0 | 150 | 550 10-Apr-26 | Purchase Return | PR/002 | M-101 | Cement OPC | Bags | 20 | 0 | 570 Open a new Excel sheet