Stock Card (Weighted Average Cost)
Free Excel stock card valued at weighted average cost: receipts, valued issues, average cost recomputed after each receipt, stock in quantity and value, minimum-stock alert.
Your country's version.
Each country has its two files: one fully French, one fully English. Direct download, no sign-up.
Get the template by e-mail, and its updates.
Keep the six files of « Stock Card (Weighted Average Cost) » in your inbox, to find or share them later. The direct download stays free, no sign-up.
- The France, Québec and Africa versions, in French and English.
- If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
- Your details are never sold, one-click unsubscribe.
What the workbook contains.
Stock card
Receipts, issues, stock, average cost, value, alert
Valuation
Issues valued at the current average cost
Alert
Negative stock or below minimum
Settings
Item, unit, opening stock, minimum stock
Instructions
Get started in 3 minutes, cells protected without password
Landscape, repeated headers
Up and running in minutes.
- 01
In the Settings sheet, enter the item, the opening stock (quantity and unit cost) and the minimum stock.
- 02
Enter each receipt with its quantity and purchase unit cost: the average cost is recomputed.
- 03
Enter each issue with its quantity: it is valued at the current average cost.
- 04
Watch the alert: negative stock or below minimum, time to reorder.
Your questions, answered.
The same cycle, automated.
Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.