Toolnoza
How to fill in the template
- Use one row per item for a single reporting period. Record the period in the item description.
- Enter opening stock, receipts and issues in the same unit. Enter zero for a recorded absence of movement.
- Closing stock is opening plus receipts minus issues. Carry the closing stock into the next period’s opening stock.
Calculations cover rows 10–39. To extend the file, copy the final row with its formulas and update total ranges.
Worked example
Opening stock of 100, receipts of 40 and issues of 25 give closing stock of 115.
What to check
Do not add closing quantities across different units. Negative stock is highlighted and requires checking the recorded movements.
Included columns
- Item code
- Item
- Unit
- Opening
- Received
- Issued
- Closing
Frequently asked questions
Is the file free?
Yes. Download without an account or payment. You can edit the file for your personal or professional use.
How do I open it?
Open the .xlsx file in Excel or a spreadsheet app supporting this format. You can import it into Google Sheets; check formulas and formatting after import.
Is my data sent to Toolnoza?
No. You fill in the downloaded file in your own spreadsheet app.