Record material movement in one unit and reconcile the balance.
The workbook separates each inward, issue and transfer value, calculates closing stock and includes checks for the references needed to investigate a difference.
Built for: Site stores, engineers and procurement teams
Know what you are downloading.
The workbook contains more guidance and fields; this table shows the record’s practical shape.
| Reference | Opening | Inward | Outward | Closing |
|---|---|---|---|---|
| DC-248 | 0 | 120 | 0 | 120 |
| MIR-031 | 120 | 0 | 38 | 82 |
| TR-009 | 82 | 0 | 12 | 70 |
Every column has a job.
Adapt the wording when needed, but keep the reporting boundary and responsibility clear.
Material identity
Item ID, agreed description and unit.
Movement context
Date, site, movement type and source or destination.
Reference
Challan, issue note or transfer reference.
Opening and movement
Separate inward, outward, transfer-in and transfer-out values.
Closing balance
Formula uses the opening balance and movement columns.
Review note
Explain an exception or approved adjustment.
A simple operating sequence
Start with the clean sheet and keep the completed example as a reference.
- 1
Standardise item names
Choose one unit for each item before entry.
- 2
Record every movement
Do not record purchases while ignoring issues and transfers.
- 3
Carry the balance
Use the previous closing value as the next opening value.
- 4
Compare with physical stock
Investigate differences and record approved adjustments visibly.
Review the record
- Item and unit are consistent
- Transfer references match
- Negative balances are investigated
- Evidence is traceable
- Adjustments include reasons
- Physical counts are documented separately
Understand the method and the connected workflow.
Use only complete, live resources.
Clear answers before you download.
The file is editable, direct and deliberately limited to an operating starting point.
Does the workbook calculate closing stock?
Yes. Closing stock is calculated from opening, inward, outward, transfer-in and transfer-out values.
How should different units be handled?
Use one agreed unit for each item or perform an approved conversion before entry. Do not combine mixed units in one balance.
Can it replace a physical stock count?
No. The register supports reconciliation; physical verification remains necessary at the frequency your project requires.