Setting an inventory budget: the cash you can actually lock up

Fix the ceiling before you pick the products. The usual failure runs backwards: a cart of sensible reorders, a wince at the total, a hasty deletion of half the cart, and no record of why. A budget inverts it: one ceiling computed from what your cash can afford to have sitting on shelves, set before any purchase order goes out, plus a priority order that decides what fits underneath when the wish list outruns the money. This guide walks the four-step cap calculation with a worked example, the reserve the cap must leave alone, and the spending order for the tight weeks. Open-to-buy (the planned-sales purchasing budget by category, computed in cost dollars) is its own planning discipline, covered in the open-to-buy guide; this article covers the cash ceiling that purchasing has to live inside, the calendar of when money actually locks, and the priority order for spending under the cap.

What the budget actually caps

Inventory is cash in its least liquid form. The budget caps three components together: stock on hand at cost, goods in transit you've already paid for, and deposits sitting against unfilled purchase orders. Sales don't release the cash evenly (a unit sells, and the money arrives days or weeks later through your payout cycle), so the number that matters is the maximum locked at any moment, not an average.

The cap is a sentence before it's a spreadsheet: the most the business can have tied up in inventory without breaking something else: payroll, the tax set-aside, the next reorder that actually can't wait. Note the difference from open-to-buy: OTB sets each category's monthly purchasing budget from planned sales and assumes the cash is available; this budget is what decides whether it is — and what gets cut when it isn't.

The four-step cap calculation

Worked example throughout: a store selling yoga mats and stationery, with illustrative numbers you'll replace with your own.

Step 1 — trusted monthly COGS. Average the last three months of cost of goods sold: $21,000 (estimated). Use cost, not retail: the budget is about cash out, and revenue inflates it.

Step 2 — weeks of cover you must hold. Take your longest core-supplier replenishment cycle and add your review-and-receiving allowance: a 6-week overseas lead plus 2 weeks = 8 weeks ≈ 1.85 months (illustrative). This is the span you must bridge between reorders.

Step 3 — the cap. Monthly COGS × months of cover: $21,000 × 1.85 ≈ $38,900 (estimated). Round to $39,000. That's the ceiling on total inventory cash.

Step 4 — open cash. Cap minus what's already locked. Inventory at cost today is $26,400 (estimated; inventory convention values stock at cost, per IRS Publication 538, accessed November 2026), so open cash = $39,000 − $26,400 = $12,600 this month (estimated). That figure, not the cap, is what a buying decision spends.

Sanity-check the cap against turnover: $252,000 annual COGS ÷ $39,000 ≈ 6.5 turns a year, plausible for mixed general merchandise. A cap implying 2 turns means the shelves are a warehouse; 15 turns means permanent bare shelves on bestsellers. The days-of-cover arithmetic behind that check is linked at the end of this article.

The reserve the cap must leave alone

The cap is not the bank balance. Before calling open cash spendable, reserve: next month's fixed operating costs, the tax set-aside, a contingency of roughly 10–20% (illustrative), and the seasonal spike — if Q4 is three months out, the reserve grows rather than the ceiling, because the holiday buy will need its own funding (the seasonal calendar is in funding the holiday buy). If honoring the reserves shrinks open cash to near zero, the workable lever is fewer weeks of cover or a narrower assortment — not a hopeful budget that ignores the payroll date. And when the spend is one big seasonal PO rather than a list of SKUs, size it against scenarios first — the what-if buy plan prices the three versions of the same buy.

Spending under the cap: the priority order

When candidates exceed open cash (here $12,600, estimated), rank by days of cover measured against lead time, breaking ties with velocity. The order that consistently beats intuition:

1. Bestsellers at or near bare. Days of cover below lead time means the next cycle is already lost; fund first.
2. Core sellers below their cover target. Not urgent yet, but inside the current cycle.
3. New-product tests. A fixed slot (10% of open cash is a workable rule, illustrative) so experiments can't cannibalize the basics.
4. Tail and discretionary depth. Whatever remains; zero is a legitimate answer.

Applied to the worked store: MAT-YG-05 has 4 days of cover against a 21-day lead ($5,400 estimated to restore protection); NOTE-A5-08 sits below target at 12 days against 14 ($4,200); the test slot takes $1,250; TAPE-WA-01 and the rest of the tail share the last $1,750. Every figure illustrative; the ordering is the point, not the amounts.

One note about tools: reorder suggestions that don't know a cap will happily exceed it. The pattern is documented in the wild: the founder of one forecasting app wrote, "The current reorder suggestions use the same min and max inventory levels for all products…" (Assisty founder reply, January 2025), and uniformity is only half the gap; cap-blindness is the other. Whoever or whatever produces your buy list, the priority order above is what reconciles it with the money that actually exists. InventoryX's Monday Buying List orders SKUs by days of cover and suggests quantities with order-by dates, but it doesn't yet know your cash cap; applying the priority order when you convert the list into purchase orders is still your step.

When nothing fits: three real reductions

• Shrink protection deliberately. Lower the accepted run-out risk on B and C classes rather than trimming bestsellers invisibly; the trade-off has a formal dial, covered in the service level guide.
• Free cash from the tail. Dead stock is budget already spent; liquidating it is budget recovery, and the clearing methods get their own guide (linked in the Next step below).
• Reshape the orders. Split quantities, negotiate deposit schedules, or air-freight a small top-up instead of ocean-freighting everything — smaller commitments spread over more weeks fit inside the same ceiling.

Each reduction is visible and reversible. The alternative, skipping the budget and letting the biggest cart win, makes the reduction invisible, which is how stores end up with a warehouse of tail stock and no cash for the bestseller that's about to run bare.

Keeping the budget current each month

Monthly: after each purchase order batch, subtract the committed cash immediately (the cap is consumed at signature, not at delivery) and recompute open cash. Quarterly: refresh the four steps, because COGS drifts and suppliers change their spans. Two Shopify facts make the bookkeeping easier: native profit reports give you real cost per item, so Step 1 doesn't run on guesses (Shopify Help Center, accessed November 2026), and purchase order data landed in Shopify analytics with the Fall '26 Editions (Shopify Editions changelog, accessed November 2026), which makes committed cash visible without a separate spreadsheet.

Common questions

How much cash should a small store keep in inventory? Compute it rather than inherit it: monthly COGS × months of cover you must hold, minus reserves. Many mixed-merchandise stores land between four and eight weeks of COGS at cost (an illustrative range — your lead times decide). If the number feels high, the fix is shorter replenishment cycles or narrower assortments, not wishful budgeting.

What's the difference between an inventory budget and open-to-buy? Open-to-buy is a planned-sales purchasing budget: the dollar amount at cost each category can spend this period, computed from planned sales, a stock target, and what's already on order; it answers how much purchasing the sales plan supports. An inventory budget is the liquidity ceiling underneath it (the maximum the business can afford to have locked in stock, paid transit, and deposits) plus the reserve and the priority order for spending under the cap. The budget constrains the open-to-buy, not the reverse.

Do goods in transit count against the budget? Yes, from the moment you've paid — deposits included. The cash left your account regardless of where the units physically are, and a budget that ignores transit will let you commit the same dollars twice. Track three components: stock at cost, paid goods in transit, and deposits against unfilled purchase orders.

How often should I recompute the cap? Quarterly in stable seasons, plus immediately after any real shift: a supplier's lead time changes, COGS moves more than roughly 20% (illustrative threshold), or you add a category. Recompute in the same order every time (trusted monthly COGS, weeks of cover, cap, then open cash) so the number stays comparable across quarters.

Should the budget grow automatically when sales grow? No. Growth raises the target cover, but the cash still has to clear the reserve checks — operating costs, taxes, seasonality. Scale the cap deliberately each quarter off refreshed COGS and lead times, and fund step-changes like a new category from an explicit decision rather than letting the ceiling drift upward on its own.

Next step

Compute the four numbers for your own store today (trusted monthly COGS, weeks of cover, the cap, and open cash) and write them at the top of your buying document. Then rank next week's wish list by how many days of cover each SKU has against its lead time — the metric is defined in the days-of-cover guide and spend the open cash in priority order. If the ceiling feels tight after that, freeing cash from dead stock is the fastest legitimate source of new budget.