Open-to-buy: a buying budget that ties stock to cash

Open-to-buy caps what you commit to stock each month using planned sales, stock on hand and cash you can actually spend. Includes a worked example.

Illustration for Open-to-buy: a buying budget that ties stock to cash

It is 11pm and you are staring at a supplier invoice that needs a 40% deposit by Friday. You know you need stock, but you also know the bank balance is tighter than it looks. This is where most stock and cash plans drift apart.

This post is about open-to-buy, a retail mechanic rebuilt around cash rather than sales alone. For anyone doing inventory planning on Shopify, it is the cleanest way to tie your stock plan to the money you actually have. We will walk through what the cash version of open-to-buy looks like, the formula, a worked example for one brand, where each number comes from, and how to run it monthly on the same day. We will also cover what it will not do, so you do not expect it to solve problems it cannot touch. By the end, you should have a monthly buying budget that stops the reorder question from being a surprise every time a supplier asks for a deposit.

What open-to-buy is and why the cash version looks different

Open-to-buy is a monthly cap on what you may commit to stock. Rebuilt around cash, it is planned sales this month, minus stock already owned at cost, minus cash you cannot spend on stock. Merchandisers set the retail original from planned sales and stock on hand, so the cap covers the shelf and says nothing about the bank account. That is where the drift starts: the stock plan knows what you own, the bank knows what you can pay, and most small brands keep those two in separate spreadsheets until a supplier deposit lands.

The cash-rebuilt formula in the next section is this article's own working method, not a definition from a standards body or a study. Treat it as a practical framework, and check it against your own numbers before you rely on it. For a sense of the wider picture, the US total business inventories-to-sales ratio was 1.33 in August 2026 against 1.40 a year earlier, according to the US Census live release published 15 October 2026. That figure covers manufacturers, wholesalers and retailers across the whole economy, not online brands, and it is not adjusted for price changes. The Census also states its estimates carry 90% confidence intervals and that small month to month moves should not be read as signals. So the national number is context, never a trigger. If you want to see how stock decisions and cash position fit together before we get to the formula, our guide to inventory planning for ecommerce walks through the same tension from first principles.

The cash-rebuilt open-to-buy formula

With that distinction clear, here is the sum itself.

Open to buy = planned sales this month minus stock already owned at cost minus cash you cannot spend on stock.

Planned sales this month means your expected sales converted to what they cost you, not what you sell them for. If you plan to sell £10,000 of stock at a 50% cost ratio, the number is £5,000.

Stock already owned at cost means the stock you are holding that will cover part of this month's sales, valued at what you paid, not at retail. This is not a reorder point, which triggers one SKU; open-to-buy caps the whole month.

Cash you cannot spend on stock means money already promised elsewhere: your minimum buffer, tax set aside, loan payments and deposits already committed.

Read the mechanic as two sums meeting. The first two terms produce what the stock plan wants to buy. The third is the funding gap between that want and what the bank will release, so the answer is always the lower of the two.

A negative or zero open-to-buy is information, not failure. It means this month's buying is already done, and the next order belongs in next month's sum.

A worked example for one Shopify brand

These figures are illustrative; no customer story or result is reported.

The brand's numbers this month

Planned sales $60,000. Cost of goods is 50% of selling price, so planned sales at cost are $30,000. Stock owned at cost $18,000. Cash in bank $24,000. Committed set-asides: minimum buffer $12,000, tax $3,000, loan payment $2,000. Cash unavailable for stock totals $17,000.

The arithmetic line by line

Planned sales at cost $30,000 minus stock owned $18,000 leaves stock need $12,000. Cash in bank $24,000 minus cash unavailable $17,000 leaves $7,000 spendable. Funding gap: $12,000 minus $7,000 equals $5,000. Open to buy: $30,000 minus $18,000 minus $5,000, so $7,000 may be committed to stock this month.

What changes when one input moves

Planned sales rise to $70,000. Planned sales at cost become $35,000, stock need becomes $17,000, and open to buy stays $7,000 because bank is unchanged. A supplier asks for a $3,000 deposit up front. The buffer must be topped up, spendable cash falls to $4,000, and open to buy falls to $4,000 though planned sales did not move.

Open to buy does not rise with sales optimism. It rises when stock runs down or cash genuinely frees up. For cash, see our guide to 13-week cash flow forecasting for Shopify brands.

Where each number comes from

The worked example only holds together if each input has one clear source. Here is where to pull them.

InputWhere you get the numberWhich plan it belongs to
Planned sales this monthYour sales plan and last year's same monthStock plan
Stock already owned at costYour stock report at landed costStock plan
Cash in the bankYour bank feed and unpaid billsBank
Cash you cannot spend on stockYour buffer rule, tax set aside and loan scheduleBank

Notice the split. Planned sales and stock on hand come from your stock plan. Cash in the bank and cash you cannot spend come from your bank and your commitments. Two systems, two numbers each, which is exactly where drift starts: stock says buy, bank says wait, and nobody writes both on the same page.

Writing all four on one page once a month is half the fix. The other half is using the same source every time, so the number does not move because you opened a different report. If your cash side still lives in a spreadsheet, our guide to building a cash flow template shows the rows to keep.

Running it monthly, on the same day each month

Once those numbers sit on one page, the only thing left to decide is when you look at them. Pick a date that follows your sales close, not the day a supplier calls. The point is to run the sum before you agree to any purchase order, so the answer arrives first.

The four steps

Update planned sales for the month first, using the most recent four weeks rather than a figure you set in January. Recent trading beats a forecast you have stopped believing.

Next, pull stock on hand at landed cost, including stock already in transit or sitting against a deposit. Paid for is paid for, whether or not it has reached the shelf.

Then read the bank and apply the set-asides before you look at what is left. That order matters: it means the buffer is never the thing you accidentally spend.

Finally, write the open-to-buy figure on the purchase order before it goes out, and hold it there all month. If you want to test whether an order fits, the stock order affordability calculator runs the question against both the stock and the cash.

There is one honest limit. If a supplier demands a deposit larger than this month's open-to-buy, move the order into the month the cash arrives. Borrowing the figure from next month just moves the problem somewhere quieter.

What open-to-buy will not do

It is worth being clear about the edges, so you do not expect more from the number than it can give.

Open-to-buy is a monthly cap, not a cash flow forecast. It tells you what you may commit, not what your balance will be in March. If you need the month by month picture, that is a different job, and our plain-English guide to cash flow forecasting covers it.

Seasonality is the next trap. If your year has two peak months, one flat number will be wrong for most of it. Use a rolling three month planned sales figure, or set a cap per season.

It also cannot beat supplier terms. A 60 day term and a deposit up front both change when cash actually leaves, so run the cap on the cash date, not the invoice date.

Do not build this year's plan on last year's stock levels if demand has moved. National figures such as the US inventories-to-sales ratio are economy-wide context, not a reading of your shop.

And no forecast is exact. A cap you can explain to yourself at 11pm beats a model you never open.

Keeping the stock plan and the bank on the same page

The sum above only holds together if the five numbers sit somewhere you can actually see them at once. Cushion is built for exactly that: one place where the cash forecast sees the stock and the stock plan sees the bank. It reads your bills, balances and payment terms, and connects read-only to Shopify, Xero and QuickBooks, so nothing is posted back into your accounts. The cap you just worked out on paper is the same number it can hold for you month after month.

You can run a version of the sum yourself with the cash flow forecast calculator before you commit to anything. If you are still deciding where your cash numbers should live, our post on what people moved to after Fluidly closed in 2023 sets out the options without the sales pitch.

Whatever you use, diary the date and write the figure down. A cap you can point to beats a spreadsheet you open twice a year.

When you want the stock plan and the bank reading from the same page, join the waitlist.

FAQs

Does open-to-buy work for a brand with irregular seasonal sales?

Yes. Use a rolling three month planned sales figure or a cap per season, and rebuild the stock base from current numbers, not last year's. National inventory data is an economy-wide average and cannot tell you what your shop will sell in November.

Does open-to-buy replace a cash flow forecast?

No. Open-to-buy caps commitments this month. A cash flow forecast is the month by month balance. Both should share planned sales, stock value and set-asides, so keep them in one place.

How often should I recalculate it?

Monthly as a minimum, on the same day. Recalculate mid month only when a deposit is called or a large order ships early, because those events move cash and nothing else in the sum has.

What happens when a supplier asks for a deposit up front?

The deposit is cash you cannot spend on stock this month even though stock arrives next month. Cut this month's cap by the deposit amount, or move the order into the month the cash lands. Either way, the cap follows the bank, not the hope.

More in our 18 articles.

What to do this month

You now have the method and its limits. Here is the smallest version worth starting.

Take five numbers onto one page: planned sales this month at cost, stock already owned at landed cost, cash in the bank, cash you cannot spend on stock, and the gap between the last two. Include the gap even when it is negative.

Write the open-to-buy figure at the top of that page and hold it for the whole month. A generous payment term or a persuasive rep does not move the bank, and the cap follows the bank.

Diary one date next month, after sales close, and repeat the sum with fresh sales and fresh cash. Two or three cycles in, the reorder question stops arriving as a surprise.

If the two plans still live in separate spreadsheets, that is the thing to fix. Cushion is built for exactly that: one place where the cash forecast sees the stock and the stock plan sees the bank. Join the waitlist at /waitlist when you are ready.

Conclusion

Open-to-buy turns a buying budget into a cash discipline. The version that ties stock to cash looks different because it starts with the bank, not the sales forecast, and it caps spending at what the bank can support. The formula is simple: cash in the bank, minus cash you cannot spend on stock, gives the gap that sets the cap. Run it monthly on the same date and recalculate mid month only when a deposit or early shipment moves cash.

The method has limits, but it stops overcommitting on stock and keeps the stock plan and the bank on the same page. Start this month with five numbers on one page. If your two plans still sit in separate spreadsheets, join the waitlist at /waitlist. One place where the cash forecast sees the stock and the stock plan sees the bank.

Filed underInventory PlanningCash Flow
Rory McLaughlan
Written by

Rory McLaughlan

Runs a Shopify store selling mystery football shirt boxes across the UK, EU and US. Built Cushion after years of joining up a cashflow sheet, a stock sheet and a sales forecast in his head every Sunday night.

See whether the next reorder leaves enough cash

Cushion puts your cashflow, stock and sales forecast on one screen, with read-only connections to your store, your books and your bank.