Inventory Ageing & Slow-Moving Stock Report

About the Inventory Ageing & Slow-Moving Stock Report

Ages the stock you have on hand. Open a list of the lots still in stock (the Stock Register's FIFO layers file is one), a list of receipts with each item's stock now, or a stock ledger of every move in and out, and the report splits each item's stock into the lots it is made of — first in, first out, so what is left is the most recent receipts — ages every lot at the date you choose, and values it at its own cost.

You get the stock in the age buckets you choose (0–30, 31–90, 91–180, 181–365 and over 365 days to start with), each with its value and share; every item with its value per bucket and its oldest lot; the slow-moving and non-moving items by the days since their last sale; the carrying cost at your own rate; and a provision column that applies the percentage you set for each bucket, as a working to discuss with your accountant.

Without a pass the report is a free preview: the item count of every bucket and the first rows of each table are on screen with the values hidden, and the workbook, PDF and CSV files unlock with a Premium pass. The file is read in your browser and never uploaded.

Common uses

• Year-end and month-end inventory reviews for management, the auditor or the bank.
• Finding the stock to clear with a discount or return to the supplier before it ages further.
• Supporting a provision for slow-moving and obsolete stock with a working the accountant can follow.
• Leaving old stock out of a bank stock statement, with the lots file of each lot’s category, receipt date, age and value.

How the stock is aged

• Lots on hand: each row is a lot still in stock with the day it came in, its quantity and its cost; the age of a lot is the days from that day to the as-at date.
• Receipts and the stock now: under first in, first out the stock left is the latest receipts, so the report takes each item’s stock on hand from its newest receipt back. Stock that the receipts in the file do not cover is aged as older than the oldest receipt, at its cost, and the notes say so: add older receipts for an exact age.
• A stock ledger: every move is replayed in date order with FIFO, which leaves the lots on hand with their dates and costs.
• A lot belongs to the bucket whose limit its age does not pass: with limits of 30 and 90, a lot of exactly 30 days is in 0–30 and one of 31 days in 31–90.

Slow-moving and non-moving stock

An item is slow-moving when it has gone more than the days you set without a sale, and non-moving after the longer limit. An item the file shows no sale of is judged by how long it has been in stock — the age of its oldest lot — so one that came in last week shows as recently bought, not as non-moving. The last sale comes from a “Last sale” column, or from the ledger’s last sale or issue (write-offs, stock adjustments and returns to the supplier take stock out but are not sales). A file with no sale dates at all is judged by each item’s newest lot instead — nothing bought for a long time has usually not been selling either — and the report says so.

Provisions and net realisable value

IAS 2, and Ind AS 2 in India, measure inventories at the lower of cost and net realisable value — the expected selling price less the costs to complete and sell — and the write-down is judged item by item. Old and slow-moving stock is where that judgement usually starts, so many businesses use percentages by age as a first estimate. The provision column applies yours; it is a working for discussion with your accountant or auditor, not an accounting entry.

Carrying cost

Money tied up in stock costs something: interest or the return the money could earn elsewhere, storage, insurance, handling, and shrinkage. Type one rate a year that covers what applies to you and the report shows the carrying cost of the stock for a year, and what holding each lot for its age has cost so far.

Limitations

• A working for information, not an accounting opinion: the write-down to net realisable value is a judgement for you and your accountant.
• Ageing by receipt dates assumes first in, first out. Where stock is not issued in that order, ages are those of the FIFO lots, not of the physical items.
• Quantities and costs come from your file as they are; transfers between locations, returns and adjustments must already be in it.
• Days are counted between calendar dates; the as-at date counts as day 0.

Privacy

Your stock file is read in this browser and never uploaded; only the bucket limits and settings you choose are remembered on this device.