Free inventory aging and reserve calculator

This free inventory reserve calculator turns an aging report into a reserve for old stock. Enter the value of your stock in each age band and the percentage you reserve for each. It shows the reserve in dollars, the share of stock older than 180 days, and the stock value after the reserve. It runs in your browser.

Inventory reserve calculator

Estimates for planning only. Results depend entirely on the numbers you enter. Nothing you enter is stored or sent.

The formulas

Reserve = sum of ( stock value in an age band × reserve % for that band )
Reserve share = reserve ÷ stock value
Stock value after the reserve = stock value − reserve

A worked example

Your aging report shows $800,000 of stock up to 90 days old, $90,000 at 91–180 days, $100,000 at 181–365 days and $60,000 over a year old. At 0%, 10%, 25% and 50% the reserve is $9,000 + $25,000 + $30,000 = $64,000, which is 6.1% of the $1,050,000 of stock. $160,000, or 15.2%, is older than 180 days, and the stock is worth $986,000 after the reserve.

Frequently asked questions

What is an inventory reserve?

An accounting allowance that lowers the value of stock that may not sell at full price, such as old, excess or obsolete items.

What percentages should I use?

They are a policy for you and your accountant, based on how your old stock has actually sold. Common starting points rise with age, for example 10%, 25% and 50%.

Where do the age bands come from?

From an inventory aging report, which matches the stock on hand to receipts, first in, first out. The Optimization Lab builds one from your item list and receipts.

Related

Want the aging report itself, item by item, from your own receipts? Inventory aging in the Optimization Lab builds it first in, first out, on every plan.

Try the live demoSee plans and pricing
Scroll to Top