Protect Cash

How Much Cash Is Tied Up In Stock?

Stock uses cash when it is purchased. A stock-movement review shows how much is selling regularly, moving slowly or may no longer be saleable at its recorded value.

RM90,000 of stock divided into fast-moving, slow-moving and obsolete categories

The Short Answer

Start with a reliable stock listing valued at cost. Group the items by recent movement, then investigate material slow-moving and obsolete balances.

Stock on hand = fast-moving + slow-moving + obsolete stockThe recorded value shows working capital invested in stock. It is not necessarily the cash that will be recovered from selling it.

A Simple Example

Stock categoryValue at cost
Fast-moving stockRM45,000
Slow-moving stockRM30,000
Obsolete stockRM15,000
Total stock on handRM90,000

RM45,000 is tied up in slow-moving and obsolete stock. Management should review the items behind that amount before purchasing more.

What Each Category Means

CategoryManagement meaning
Fast-movingSelling regularly; cash may be recovered sooner.
Slow-movingSelling less often; cash remains committed longer.
ObsoleteLittle realistic demand; may need a discount or write-down.

Turn The Review Into Action

FindingPossible action
Healthy movementMaintain sensible reorder levels.
Purchases exceed usageReduce or postpone replenishment.
Slow movementReview demand, pricing and alternative use.
Obsolete or damagedAssess disposal, discounting and write-down.
Read The More Detailed Answer

Begin With A Reliable Stock Listing

Use a stock listing as at a clear date, showing item code, description, quantity, unit cost and total cost. Reconcile its total to the inventory balance in the accounts. Investigate negative quantities, duplicate items, old outstanding receipts and unexplained differences.

Confirm Quantity And Condition

Accounting records may show stock that is missing, damaged, expired or unsuitable for sale. Use regular cycle counts and periodic physical counts to confirm that quantities exist and are in saleable condition.

CheckQuestion
QuantityDoes the physical count agree with the records?
CostIs the unit cost calculated consistently?
ConditionIs the item saleable and undamaged?
OwnershipDoes the stock belong to the business?

Measure Movement Consistently

Set practical movement bands for the business—for example, items sold or used within 90 days, 91–180 days and over 180 days. The correct bands depend on the normal operating cycle. Seasonal, strategic and essential spare stock should be reviewed separately rather than automatically labelled unnecessary.

Calculate Stock Days

Stock days provide a broad measure of how long inventory is held. Use average stock because the closing balance alone may be unusually high or low.

Stock days = average stock ÷ cost of sales × number of daysCompare the result with prior periods, targets and the business’s normal purchasing and production cycle.

For example, average stock of RM90,000 and annual cost of sales of RM540,000 gives approximately 61 stock days: RM90,000 ÷ RM540,000 × 365.

Estimate The Cash Opportunity Carefully

The full stock balance cannot normally be released without affecting sales or production. Estimate the quantity genuinely required for normal operations, then review the excess above that level item by item.

QuestionWhy it matters
Will it be used or sold?Separates future demand from inactive stock.
Can purchases be stopped?Prevents the balance from growing further.
Can it be returned or transferred?May recover value without a retail sale.
What price is realistic?Identifies possible loss or write-down.

Review Purchasing And Reorder Controls

Slow stock often grows because purchasing decisions are based on habit, large minimum orders, outdated forecasts or weak approval controls. Review reorder points, order quantities, supplier lead times and demand forecasts. Link purchasing approval to existing stock and outstanding purchase orders.

Monitor The Position Monthly

Track total stock, stock days, slow-moving value, obsolete value, write-downs and stock differences. Assign owners to material items and record the action and review date. The objective is not simply to reduce stock; it is to hold enough of the right stock while avoiding unnecessary cash commitment.

Avoid These Mistakes

  • Reviewing only the total stock value.
  • Assuming every recorded item physically exists.
  • Treating all slow-moving stock as unnecessary.
  • Ordering more without checking stock already on hand.
  • Assuming recorded cost equals recoverable cash.

Quick Review

  • Does the stock listing agree with the accounts?
  • Are quantities and condition physically verified?
  • Which items are slow-moving or obsolete?
  • What purchases can be reduced or postponed?
  • Who owns each action and review date?

Key Takeaway

Review stock movement—not only stock value. Identify where working capital is committed, protect essential stock and take action on excess, slow-moving or obsolete items.

This guide provides general educational information. Inventory valuation, write-down, tax and disposal decisions should be assessed using the business’s circumstances and appropriate professional advice.