1 How to manage inventory cash: turnover, aging and the count
Shelly Oden edited this page 4 hours ago


Learning how to manage inventory cash comes down to one question: how much of your money is sitting on the shelves, and how long will it stay there? The bank balance rarely answers that. A business can post a good quarterly profit and still struggle to pay suppliers, because profit is recorded when goods sell, while the cash left months earlier, when the stock was bought.

Why the bank balance hides the cost of stock


Start by asking what the bank balance is actually telling you. It shows the money that is free today, after bills, payroll and debt payments have cleared. It says nothing about the cash you already spent on products that have not sold yet. For a business that buys and resells goods, that hidden amount can be the largest figure in the company.


Think of it like this. Every unit on a shelf or in a warehouse is cash that left your account at some point, in the form of a purchase order, a deposit to a supplier or a freight invoice. Until that unit sells and the customer pays, the money is not available to you. It is parked on your shelves instead of working for you.


The symptom usually looks like a puzzle. Sales are steady, margins look reasonable on paper, and yet every month someone asks why there is no money for the next order. The owner suspects the bookkeeping, the bank suspects the forecast, and the team suspects the customers who pay late. Often the real answer sits in the inventory line, which quietly grew for several months while nobody read it as cash.


Profit and cash move on different schedules. When a sale is recorded, the cost of the item moves from inventory to cost of goods sold, which lowers the inventory balance and reduces reported profit. But the purchase that filled the shelf may have been paid weeks or months earlier. A business that buys heavily to avoid stockouts can look profitable while the same decision drains its cash.


Ask a simple question at the start: if you stopped buying tomorrow, how many months would your current stock last, and how much cash would it take to clear it? That answer is your baseline. It does not need to be exact on the first pass. It needs to be honest enough that you can see whether the inventory is a source of strength or a quiet drag.


This is also where an outside finance leader often starts, because the question is less about bookkeeping and more about how buying decisions connect to the business plan. A part-time CFO, a controller or a bookkeeper may all touch the inventory account, but the person who reads it as a cash decision is the one most likely to raise the question early, before the bank does.

Turnover: the first number to calculate and where it misleads


Inventory turnover answers a basic question: how many times in a period does the stock you hold get replaced by stock that was sold? A common calculation divides the cost of goods sold for the period by the average inventory held during that period. A higher result generally means stock is moving faster, and a lower result means cash is staying on the shelves longer.


Use cost, not sales, in the numerator. Sales include your markup, so dividing sales by inventory at cost overstates how fast the stock moves. Use the average of the opening and closing inventory balances for the same period, so one unusually large delivery at month end does not distort the picture. Those two choices are small, but they separate a number you can trust from one that flatters you.


In a hypothetical example, a small appliance shop in Miami reports cost of goods sold of 600,000 dollars for a year and keeps an average inventory of 200,000 dollars at cost. The turnover is three. The owner feels reasonably good about that, until a closer look shows that one product line accounts for most of the cost of goods sold, while the slowest lines sit untouched in the back room. The overall ratio hid two different businesses.


The ratio also misleads when the product mix changes. A store that adds a seasonal line in the fourth quarter may show lower turnover simply because it bought for the holidays before the sales arrived. That is not necessarily a problem. It becomes one if the seasonal stock is still on the shelves after the season ends. Read the trend across periods, and read it by product group, before you draw a conclusion.


Think of turnover as a thermometer, not a diagnosis. It tells you that something is running warm, but not which part of the business is causing it. Pair it with an aging view of the same stock, and with a count, before you cut purchasing or change prices. Otherwise you may starve the fast sellers while trying to fix the slow ones.


Turnover also belongs in the cash plan. If you know roughly how long stock stays on hand, you can estimate when a purchase turns back into cash and compare that with the payment terms your suppliers give you. A short cash flow forecast, often built over a 13-week horizon, makes that link visible week by week. The forecast will not be perfect, but it shows whether the next large order fits the cash you will actually have.

Aging: finding the stock that stopped moving


An aging report sorts your inventory by how long each item has been on hand, usually by the date it was received. It answers a question turnover cannot: which specific units are costing you money because they have stopped moving. Many inventory and accounting systems, including QuickBooks, NetSuite and Sage Intacct, can produce some version of it, though the setup and the level of detail vary.


Set the age ranges to fit your products. A grocery shelf and a stock of custom furniture do not age on the same clock. Group the stock into a few ranges, and watch the value that falls into the oldest range rather than the count of items. One expensive unit that sits for a long time can weigh more on cash than dozens of cheap items that sell every week.


Ask why the stock is old before deciding what to do with it. Usually one of a few causes is behind it:

The buying quantity was larger than demand justified, often because a supplier discount looked better on paper than it did in cash terms. The product was seasonal, and the season ended before it sold. The product was discontinued, replaced, or quietly stopped selling as the market changed. The item was received correctly, but the price no longer matches what customers will pay, or nobody promoted it.


Each cause points to a different correction. Overbuying calls for tighter purchase limits. Seasonal leftovers call for a clearance window with a clear end date. Discontinued stock may need to go to a liquidator or back to the supplier, if the contract allows it. Be careful about writing down or disposing of stock without understanding the accounting effect, because the decision touches cost of goods sold and reported profit under U.S. GAAP. Involve whoever keeps the books before you act.


There is a trap inside the aging report itself. Old stock that still sells occasionally can look normal in a summary, because the average age of the whole inventory is pulled down by recent purchases. Read the oldest bucket on its own line, and ask what share of your total inventory value it represents. The average hides the stock that is slowly turning into a loss.


If you run the aging report every month in the same format, patterns start to appear: which suppliers ship stock that ages, which product lines need tighter limits, and which items should be cleared before the next buying cycle. Consistency matters more than sophistication here. A simple report you read every month beats a detailed one you open once a year.

The count: when the system and the shelf disagree


A count checks whether the number in your records matches what is physically there. Turnover and aging are only as reliable as the quantities behind them. If the system says a product is in stock and the shelf is empty, the report will keep recommending purchases you do not need, and the cash plan will assume sales that cannot happen.


There are two common approaches. A full physical count stops operations, or a section of the business, and counts everything at once. It gives a clean snapshot but takes time. A cycle count checks a small group of items on a regular rotation, so the records are corrected continuously and the disruption is smaller. Many businesses use a full count at year end and cycle counts in between, though the right mix depends on the size of the stock and how quickly it turns.


A practical count follows a short sequence:

Freeze movements for the count window, so nothing is received or shipped while the count is in progress. Count each location with two people, one counting and one recording, and keep the sheets signed. Compare the physical quantities with the system records, and list every difference with its value. Investigate the largest differences first, looking for unposted receipts, returns, damage and transfers between locations. Post the adjustments with a reason code, and review them with whoever approves inventory changes.


The differences are information. Losses from theft, damage and miscounts are common in retail and warehouse settings, but a pattern is more useful than any single gap. If the same product keeps showing missing units, the problem may be in receiving, in packaging, or in the way returns are handled. A count that only adjusts the number and moves on wastes the effort.


Keep the controls simple enough that people follow them. Separate the person who can adjust inventory from the person who receives it, and review large adjustments before they post. These internal controls protect the reliability of the numbers, and they matter more before a loan review or an audit, when someone outside the business will want to test them.


Think of the count as a check on trust rather than a yearly chore. When the count and the records agree, you can use turnover and aging with confidence. When they do not, every other inventory decision rests on a guess.

Symptoms, likely causes and corrections


Most inventory cash problems show up first as a symptom, and the symptom is easy to misread. The table below pairs what you see all the details with the cause that tends to sit behind it and a correction worth testing. Treat it as a starting point for a conversation with whoever runs your numbers, not as a verdict.

Symptom Likely cause Correction to test

Cash is tight while profit looks fine Stock bought ahead of demand, with payments due before the goods sell Set purchase limits by product group and forecast cash against supplier terms

Turnover falls over several periods Slow lines kept at full depth, or seasonal buys that were never cleared Review the slowest product groups and reduce depth before the next order

The oldest aging bucket keeps growing Discontinued or seasonal items with no exit plan Set clearance dates, return rights and an owner for each aged item

The report shows stock that the shelves do not have Receiving errors, unposted returns or shrinkage Run cycle counts on the affected items and trace the largest differences

Supplier discounts keep driving large orders Buying decisions judged on unit price, not on cash tied up and time to sell Compare each discount with the cash committed and the expected time to sell

Year-end adjustments surprise leadership Inventory not counted or reconciled during the year Schedule regular counts and monthly reconciliation of the inventory account


Notice that several rows share a root cause: buying decisions made without a view of cash. A discount that improves the unit price can still be a poor decision if it ties up cash for the whole year. That is why the most useful correction is often not in the warehouse at all, but in the approval step that happens before the purchase order goes out.


Test one correction at a time where you can. Change the purchase limit for one product group for a month, then check turnover, aging and cash again. If you change five things at once, you will not know which one worked, and you may undo a good change when the next report looks worse for reasons unrelated to it.


Be honest about the limits of these fixes. Some of the cash is locked in stock that cannot be recovered at cost, and the correction is to stop the loss from growing, not to pretend it will come back. Writing that down early helps leadership decide what to do without waiting for a sale that may never happen.


Keep a short log of each symptom and the action taken. A month later, the log shows whether the problem moved, disappeared, or only changed shape. Over several cycles it becomes a record that anyone reviewing the business can follow, from a lender to a future buyer.


If the symptoms keep returning after the obvious fixes, the problem is usually in the process, not in a single number. That is the point where a second set of eyes on the whole finance function helps, and it leads straight to the question of who should own the work.

Who should own inventory cash and how a part-time finance leader fits


Inventory cash often falls between roles. A bookkeeper records receipts and sales, an accountant prepares the statements, a controller keeps the close and the controls running, and a CFO decides how much cash should be committed to stock in the first place. Each role touches inventory, but each asks a different question about it.

Role Typical focus on inventory Question it answers

Bookkeeper Recording receipts, sales and adjustments accurately Did every movement get posted?

Accountant Preparing statements and supporting year-end balances Do the reported balances follow the accounting rules?

Controller Closing the books, reconciling counts and running internal controls Can we trust the inventory balance each month?

CFO, full-time or part-time Linking purchasing and stock levels to cash, the plan and financing needs How much cash should be tied up here, and when will it come back?


Think of the four roles as layers. The bookkeeper supplies the raw movements, the controller checks that they reconcile, the accountant makes sure the statements follow U.S. GAAP, and the CFO uses all of it to decide how much cash belongs in stock. A small business may combine some of these roles in one person, and that works as long as someone clearly owns the cash question.


For a growing company in Miami, that question often gets missed. The owner is focused on sales, the bookkeeper is busy with the monthly close, and the purchasing manager is measured on availability. Nobody is paid to ask whether the next large order fits the cash plan. A part-time or interim finance leader can fill that gap without adding a full-time executive salary, which many smaller and mid-sized companies, startups and nonprofits are not ready to take on.


How the work fits with the existing team matters. A part-time CFO usually works alongside the bookkeeper and the controller, not in place of them. The useful arrangement sets clear hand-offs: who posts adjustments, who reviews the count, who owns the forecast, and who signs off on purchase limits. Without those lines, two people may fix the same problem in two different ways.


Scope is the other variable. Some businesses need a finance leader only to set up the inventory reports and the cash forecast, then hand them to the team. Others need a monthly review of purchasing decisions for as long as the business keeps buying heavily. Judge the work by the decisions it changes, such as a purchase deferred or a clearance planned, rather than by the hours logged. Ask how the engagement will end too, including who keeps the reports running and where the files live.


Whatever the arrangement, put ownership in writing. A short document that names the owner of each inventory task is more useful than a long plan nobody reads, and it makes any later change of hands much easier.

What buyers and lenders check in your inventory


Start by asking what a buyer or lender will ask you about stock. If you cannot answer it cleanly today, that is your to-do list. Lenders want to know whether the inventory is real, whether it is saleable, [empty] and whether it could become cash in a reasonable time if the business had to repay a loan. Buyers ask similar questions with more detail and more doubt.


Expect requests for the inventory listing, the latest count results, the aging report and the reconciliation between the physical count and the general ledger. Due diligence reviewers often compare these documents with the financial statements, and they look for gaps. A count that was never reconciled, or an aging report that does not match the balance sheet, makes the rest of the numbers harder to trust.


Be ready to explain the buying pattern. A buyer may ask why purchases spiked in one period, what the supplier terms look like, and what is part-time CFO services in Miami whether any stock is held on consignment or pledged elsewhere. Those answers should come from the records, and the person answering should understand the cash effect of each decision.


Watch for the obsolete stock question. Buyers tend to discount inventory they believe will not sell at full value, and they will ask how reserves were set and how old stock is handled. Clear documentation of your reserve method, and of the actions taken on aged items, shows that the number was managed, not just recorded.


Think of this as preparation rather than a sales tactic. Nothing here guarantees that a loan will be approved or that a transaction will close, and the outcome depends on many factors outside the inventory. What the work does is reduce surprises, so the conversation with a lender or buyer is about the business rather than about gaps in its records.


A simple test helps. Pick ten items at random from the inventory listing, trace each one to a purchase, a count and a current selling price, and note any item you cannot trace. The items you cannot explain are the ones a reviewer will spend the most time on.

The costliest mistake: trusting a report nobody has counted


The most costly mistake in managing inventory cash is trusting the inventory balance in the system without ever checking it against what is on the shelves. The report looks precise, so it gets used for purchasing, forecasting and profit reporting. When the balance is wrong, each of those decisions inherits the error, and the damage shows up later as surprise write-downs, missed cash and a credibility problem with lenders.


Here is how the mistake usually unfolds. Records drift for a few months through small receiving errors and unposted returns. Purchasing relies on the overstated balance, so it orders too little in some lines and too much in others. Cash runs tight, and nobody can explain why, because the forecast assumed stock that was never there. By the time the year-end count happens, the gap is large and the explanation is hard to reconstruct.


Avoid it with a few habits, not a big project. Run a cycle count on the highest-value items every month. Reconcile the inventory account to the count at each close. Review large adjustments before they post, and keep reason codes consistent. Each habit is small, but together they keep the number honest enough to use.


Think of it like this: an inventory report is a claim about the shelves, and a count is the evidence. A business that makes decisions on claims alone will eventually be surprised by the evidence. A business that checks regularly learns earlier, when the correction is still cheap.


Start with one question this week. Pick the product group that ties up the most cash, count it against the system, and write down every difference with its value. That single exercise will show whether the rest of your inventory cash plan rests on solid ground or on an assumption nobody has tested.