Description
Value one item of stock on a first-in, first-out basis: enter each purchase and the total quantity sold, and see which lots remain and the cost of goods sold.
- Automatic summary: Total quantity purchased, Quantity on hand, Closing stock value (FIFO), Cost of goods sold (FIFO)
- Calculated for you: Purchase value, Cumulative qty, Qty used (sold), Qty remaining, Value remaining, Lot status
- Colour-coded status and progress highlights
- Example rows and a step-by-step "How to Use" sheet
Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.
Payment & Security
Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.