Spark Inventory Blog

A profitable product business can still run short of cash because inventory purchases happen before sales turn back into cash. That is why learning how to track inventory cashflow is not just a finance exercise. It is a purchasing decision: which SKUs to buy, how much to buy, when to place each order, and how long that cash will remain tied up.

For an operations leader, the goal is not to buy as little as possible. It is to fund enough inventory to protect demand through supplier lead time while avoiding stock that sits beyond a reasonable sales horizon. The useful view is forward-looking, per SKU, and tied to actual purchase commitments.

Start with the cash tied up in inventory

Inventory cashflow starts with a straightforward question: how much cash is currently invested in stock, and when is more cash likely to leave the business?

For each SKU, calculate inventory value as on-hand units multiplied by landed unit cost. Landed cost should include the product cost plus the costs required to make that unit available for sale, such as freight, duty, and handling where your business tracks them. Using only the supplier unit price can make a buying plan look safer than it is.

Then separate that value into three buckets: on-hand inventory, incoming inventory that has already been ordered but not received, and planned purchases that the business is likely to need based on demand. Each bucket matters differently. On-hand stock is cash already deployed. Incoming stock represents a committed or near-committed cash obligation. Planned purchases show the pressure that may hit the cash account next.

A total inventory valuation report is useful, but it is not enough to run purchasing. It tells you where money is today, not whether the next six to twelve weeks of buying are affordable.

Build a forward inventory cashflow view

The practical way to track inventory cashflow is to turn your buying plan into a calendar of expected cash outflows. Work in weeks or months, depending on your purchasing cadence and lead times. Weekly planning is usually more useful when demand changes quickly or suppliers require frequent orders.

For every proposed reorder, capture the expected order date, quantity, landed cost, payment terms, expected arrival date, and receiving location. The order date is not always the cash date. A supplier with 30% due upfront and the balance due before shipment creates two separate cash events. A supplier offering Net 30 after receipt shifts the outflow later, although the liability still needs to be visible.

Your projected inventory cash outflow for a period is the sum of supplier deposits, balance payments, freight payments, and any other purchasing costs due in that period. Compare that number with expected cash receipts from sales and with your broader operating cash plan. Inventory planning should not pretend rent, payroll, and marketing do not exist, but it should clearly show the inventory component that the purchasing team can control.

Track at SKU level, then roll up

A company-level number can hide the real decision. One category may be understocked and require an urgent buy, while another has six months of slow-moving inventory. Rolling both into one inventory total makes the situation look balanced when it is not.

At the SKU level, track forecast demand, on-hand units, incoming inventory, allocated or committed units if relevant, landed cost, supplier lead time, minimum order quantities, and days of supply. From there, calculate the next reorder recommendation and its cash requirement.

For example, a SKU selling 40 units per week with a 10-week supplier lead time needs coverage for expected demand during that lead time, plus any policy safety stock. If it has 300 usable units on hand and 150 incoming units, it may still need a reorder soon. The important cashflow question is not only whether the reorder is needed. It is whether buying the supplier's minimum quantity creates excess stock after the incoming shipment lands.

That is where a per-SKU forecast changes the conversation. Instead of saying, “We need to spend $80,000 this month,” the team can see which purchases protect near-term revenue and which ones pull cash into inventory that may not sell for several months.

Include timing, not just purchase cost

Inventory turns into cash only after it is received, made available, sold, and collected. For direct-to-consumer sales, collection may happen quickly after an order. For wholesale, payment terms can add 30, 60, or 90 days after shipment. The same inventory position can therefore have very different cash consequences by channel.

Do not treat all forecast demand as immediate cash recovery. Use the expected sales and collection pattern for the channel that will consume the stock. If wholesale demand is uncertain or customer orders are not yet confirmed, consider using a more conservative planning assumption than you would for consistently selling direct demand.

Warehouse location matters too. Inventory in the wrong warehouse can leave one location exposed to a stockout while another holds excess. A transfer may be cheaper and faster than a new purchase order, but it still has handling, freight, and timing consequences. Include transfer decisions in the same view so a buyer does not order new units simply because available stock is fragmented.

Use days of supply to spot cash risk early

Days of supply translates inventory into a more operationally useful measure: how long available stock will last at the current forecast rate. It is one of the clearest ways to identify both cash risk and service risk.

Very low days of supply signals a potential stockout and may justify an expedited purchase, even if freight raises the landed cost. Very high days of supply signals that cash is sitting in stock longer than planned. Neither condition automatically dictates the right action. A seasonal SKU may appropriately carry high days of supply before its selling window. A strategic item may need deeper coverage because a supplier is unreliable.

The key is to make the exception visible and deliberate. If a buyer chooses to carry extra inventory, the cash impact should be clear, along with the demand assumption and the date when that inventory is expected to convert back into sales.

Reconcile the plan with reality every cycle

A cashflow model becomes misleading when it is updated only at month-end. Purchase orders move, supplier lead times change, demand shifts, and incoming containers slip. A useful operating rhythm reviews the buying plan on a regular schedule and refreshes the assumptions that drive it.

Start by validating sales history and current inventory. Check whether on-hand counts, incoming quantities, open purchase orders, and supplier dates are credible. Then review stock-risk exceptions, changes in the per-SKU forecast, and any reorder recommendations that have moved forward or backward.

For each planned order, ask three practical questions: Is this order still required to prevent a stockout? Is the quantity appropriate given incoming inventory and days of supply? When will the deposit, balance, and freight actually be due? Those answers let finance and operations discuss a specific cash decision rather than debate a broad inventory budget.

If cash is constrained, rank purchases by operating consequence. Orders that protect a high-confidence near-term demand window generally come before orders intended to rebuild comfort stock. Orders with long lead times may need to be placed despite the cash pressure, while products with softening demand may need a smaller buy or a delay. There is no universal reorder rule. The right decision depends on margin, demand confidence, substitution options, supplier reliability, and the cost of a stockout.

Make purchasing decisions reviewable

Spreadsheets can track inventory cashflow, but they often break when forecasts, inventory counts, purchase orders, and supplier terms live in different files. The result is usually historical reporting that identifies the problem after the cash has already been committed.

A better workflow brings sales history, on-hand and incoming inventory, supplier lead times, and purchasing data into one planning process. Spark Inventory can use that information to maintain a per-SKU forecast, identify stock risk, and prepare a buying plan with reorder recommendations. It can also prepare draft purchase orders, while the operator reviews quantities, timing, and terms before approving anything.

That review point matters. A recommendation can be mathematically sound and still be wrong for the business if a supplier has changed terms, a large customer order is uncertain, or the cash plan has tightened. The system should prepare and explain the decision. The operator should make the commitment.

The most useful inventory cashflow process is the one that turns every planned purchase into a visible trade-off between availability and working capital. When buyers can see the SKU, the timing, the stock risk, and the cash requirement together, they can spend with intent rather than discover the consequence after the purchase order is sent.