Material Stock Register Format In Excel

The stock quantity available at the start of the period.

| Date | Particulars | Doc. No. | Material Code | Material Name | Unit | Receipts | Issues | Balance | |------|-------------|----------|----------------|----------------|------|----------|--------|---------| | 01-Apr-2026 | Opening Stock | OS/001 | M-101 | Cement (OPC) | Bags | 500 | 0 | 500 | | 05-Apr-2026 | Purchase | PO/101 | M-101 | Cement (OPC) | Bags | 200 | 0 | 700 | | 08-Apr-2026 | Issued to Site A | IN/045 | M-101 | Cement (OPC) | Bags | 0 | 150 | 550 | | 10-Apr-2026 | Purchase Return | PR/002 | M-101 | Cement (OPC) | Bags | 20 | 0 | 570 | Material Stock Register Format In Excel

Note: Due to formatting constraints, the actual Excel file cannot be embedded here. However, you can replicate the structure above in 30 seconds by typing the headers into a blank sheet. The stock quantity available at the start of the period

Instantly see what is in stock without physical counts. | Material Code | Material Name | Unit