Open-to-buy is the dollar amount of new merchandise a retailer may receive in a given month without breaking its inventory plan. The calculation is planned sales plus planned markdowns plus planned end-of-month inventory minus beginning-of-month inventory, then minus merchandise already on order. Independent retailers run it monthly, per category, in retail dollars or at cost.
Key Takeaways
- Open-to-buy is a receiving budget, and it caps the dollars a store may receive in one month for one category.
- The retail-dollar formula is planned sales plus planned markdowns plus planned end-of-month inventory minus beginning-of-month inventory.
- Subtracting merchandise already on order separates a working plan from a decorative one, because committed purchase orders spend the budget before delivery.
- Stock-to-sales ratio is beginning-of-month inventory at retail divided by that month's planned sales at retail. It sets the end-of-month target in most independent-retail plans.
- Clothing and clothing accessory stores carried an inventories-to-sales ratio of 2.11 in May 2026, per Census data published by the St. Louis Fed. All retail stood at 1.25.
- The working cadence is a monthly reforecast, a pre-season rebuild twice a year, and a ten-minute weekly check of on-order.
- A negative open-to-buy means inventory on hand plus inventory on order already exceeds what the plan supports for that month.
What This Guide Covers
- What open-to-buy planning is, in one definition
- Why open-to-buy planning decides an independent retailer's cash position
- The open-to-buy formulas, worked line by line
- Building an open-to-buy template in Excel or Google Sheets
- The open-to-buy cadence: monthly, seasonal, and at the trade show
- A worked example: one boutique, one spring season, every line
- Open-to-buy benchmarks and what good looks like
- Comparing the five open-to-buy approaches side by side
- Start here: four moves before your next purchase order
- Frequently asked questions
What Open-to-Buy Planning Is, in One Definition
Open-to-buy planning sets a dollar ceiling on merchandise receipts for each future month, then buys against that ceiling instead of instinct. The ceiling comes from the store's own sales plan, its markdown plan, and the inventory level it wants at month end.
Management One sells merchandise planning to specialty and independent retailers. The firm defines open-to-buy as "the process by which retailers create budgets for future purchases for a specified period of time." The part it leaves implicit is that the budget is denominated in the owner's cash.
Every dollar of open-to-buy is a dollar the store has decided to convert from money into merchandise.
The Four Numbers Every Open-to-Buy Plan Runs On
An open-to-buy plan needs four inputs per month, per category, and nothing else. Getting all four wrong is common. Getting three of them right and skipping the fourth produces a plan that fails silently.
Planned sales is what the store expects to sell in that month, stated in retail dollars. It comes from last year's recorded sales for the same month, adjusted for what the owner knows about this year.
Planned markdowns is the retail dollars the store expects to give away in price reductions that month. Markdowns reduce inventory value without producing a sale at full ticket, so a plan that ignores them understates how fast inventory drains.
Planned end-of-month inventory is the retail value of stock the store wants on hand when the month closes. Most independent plans derive it from a stock-to-sales ratio: beginning-of-month inventory at retail divided by that month's planned sales at retail.
Beginning-of-month inventory is the retail value of stock on hand the day the month opens. It's the only one of the four that comes from a count rather than a forecast. Most spreadsheets let it go stale.
Open-to-Buy Planning and Inventory Management Do Different Jobs
Open-to-buy planning governs what comes into the store. Inventory management governs what happens to merchandise once it's inside: counting it, reordering it, transferring it, and reporting on it.
A store can run a spotless inventory management system and still overbuy every season. The reorder screen shows what sold and says nothing about what the month's budget allows. The distinction between the two software categories is covered in Inventory Planning vs Inventory Management Software: What's the Difference?
Cash Margin Partners is an inventory cash-recovery practice for independent, owner-operated retailers. CMP shows you how much cash is trapped in unsold inventory, then gives you a prioritized plan to get it back.
The number that anchors next season's open-to-buy plan is the one sitting in this season's leftovers. You can get a directional benchmark before you build a single spreadsheet row through the free trapped-cash calculator. It uses a short questionnaire, with no credit card and no trial clock.
Open-to-Buy Planning Is a Cash Control. Your P&L Records the Decision Months Later.
An open-to-buy plan is the only routine control an independent retailer has over the largest cash outflow in the business. Merchandise purchases move money out of the operating account immediately, or on vendor terms. The profit and loss statement records nothing until the item sells.
Inventory sits on the balance sheet at cost, and the cost of goods line waits for the sale. That accounting treatment is correct.
The back room is where that cash goes to sit down and stop moving. Open-to-buy is the control on the door into that room. Everything in this guide is about setting the width of that door month by month.
Rent, Payroll, and Next Season's Buy Come Out of One Account
An independent retailer funds rent, payroll, and next season's buy from a single operating account. A February overbuy of $8,000 at cost shows up as a June problem. The fall order needs a deposit, and the account balance says no.
Chains solved this decades ago with a planning department and a merchandise financial plan. A single owner solves it between a delivery truck and a payroll run.
Cost pressure is already coming from other directions. The Federal Reserve's 2026 Report on Employer Firms found 77 percent of small employer firms facing rising costs, tariff-related cost increases, or both. Those rising costs covered goods, services, and wages.
The Federal Reserve survey drew 6,525 responses from firms with 1 to 499 employees. Fielding ran from September 3 to November 14, 2025. It also found firms slightly more likely to report a revenue decrease than an increase.
Key Data Point: The National Inventory Position, May 2026
U.S. retailers held $832,414 million in inventories at the end of May 2026, with an inventories-to-sales ratio of 1.25, per the U.S. Census Bureau.
Clothing and clothing accessory stores ran at 2.11 over the same month, per Census data published by the St. Louis Fed. Apparel retail carries roughly 69 percent more inventory per sales dollar than retail as a whole. The category needs a tighter receiving budget than a hardware store does.
What an Overbought Season Costs in the Season That Follows
An overbought season taxes the next one twice. The leftover merchandise occupies floor space that new goods need. The cash it holds shrinks the budget available to buy those goods.
Take a boutique that ends its spring season with $27,000 at cost in unsold spring merchandise. That $27,000 was supposed to be back in the account by August, funding the fall buy.
The owner now has three options: a draw on the line of credit, a smaller fall order, or converting the spring leftovers. Only the third option costs nothing in interest, and it's the one that requires knowing which SKUs to touch.
Why "I Have a Feel for My Store" Fails at the Plan Level
Owner instinct is good at the SKU level and poor at the dollar level. An owner who has bought for the same store for fifteen years can usually tell you which sweater will sell. The same owner rarely states the retail value on the floor within 10 percent.
"I know my inventory." You know your merchandise, which is a different measurement from knowing your inventory dollars by month against a plan.
Where instinct and the sell-through record disagree, the record wins. Sell-through is the share of units received that sold in a period, and it settles arguments that gut feel keeps open.
The Open-to-Buy Formulas, Worked Line by Line
Open-to-buy has one core formula and three presentations: retail dollars, cost dollars, and units. Retail dollars is the version most independent retailers should run, because markdowns and stock-to-sales ratios are both natural in retail dollars.
The Retail-Dollars Open-to-Buy Formula
The retail-dollars open-to-buy formula is four terms:
Open-to-buy (retail) = Planned sales + Planned markdowns + Planned EOM inventory - BOM inventory
Inventory Planner publishes the identical four-term calculation on its open-to-buy page. The company describes open-to-buy as a planning method for working out how much inventory to buy by units, cost, or revenue. No vendor owns the formula, and it has been standard merchandise math for decades.
Read the formula as a statement about drains and levels. Planned sales and planned markdowns are the two ways inventory leaves during the month. The difference between the ending and opening levels is the change you intend to produce.
Work one month. Take a store planning $54,000 in May sales, $5,400 in May markdowns, and a $180,000 end-of-May inventory.
The store opened May with $178,200 on hand, so the calculation reads 54,000 + 5,400 + 180,000 - 178,200. May open-to-buy is $61,200 at retail.
The Cost-Dollars Open-to-Buy Formula
Convert retail open-to-buy to cost open-to-buy by multiplying by the cost complement of the initial markup. A store with a 55 percent initial markup has a cost complement of 45 percent.
Open-to-buy (cost) = Open-to-buy (retail) x (1 - Initial markup percentage)
The May example converts to 61,200 x 0.45, which is $27,540 at cost. That $27,540 is the number the owner takes to the vendor, because vendors quote wholesale.
Cost open-to-buy is the number to write on the back of the order pad. Retail open-to-buy is the number to plan with.
The Unit Open-to-Buy Formula
Unit open-to-buy replaces dollars with pieces, and it works in categories where the average retail price is stable. Basics, staples, and single-price categories are the natural fit.
Open-to-buy (units) = Planned unit sales + Planned EOM units - BOM units - Units on order
Take a sock wall planning 340 pairs of May sales. It holds 1,050 pairs on May 1 and targets 900 pairs for June 1. Add 60 pairs on order, and the math reads 340 + 900 - 1050 - 60, or 130 pairs.
Unit planning breaks down in fashion categories where one delivery averages $38 retail and the next averages $124.
How to Set Planned Sales for the Month
Planned sales starts with last year's recorded sales for the same month, then takes named adjustments. Vague optimism produces a plan nobody can audit later.
Write each adjustment as its own line with a reason attached. A store might plan February at last year's $33,000, plus $2,000 for a new brand landing in week two. Add $1,000 for a Presidents Day event skipped last year, and February plans at $36,000.
Sales plans built from named adjustments can be scored at month end. Sales plans built from a percentage lift applied to everything can't.
One structural note on the calendar. The National Retail Federation's 4-5-4 calendar groups the year into 4-week, 5-week, and 4-week months so weekend counts stay comparable between years. It adds a 53rd week roughly every five to six years.
Comparing a 5-week month against a 4-week month is the most common self-inflicted planning error I see. Check the week count before you conclude that April was soft.
How to Set Planned End-of-Month Inventory, Three Ways
Planned end-of-month inventory can be derived three ways, and independent retailers should pick one and cross-check with a second. All three answer the same question: how much stock does the floor need to support the sales plan.
The stock-to-sales ratio method multiplies the month's planned sales by a target ratio. A store planning $48,000 in April sales at a 3.5 stock-to-sales ratio targets $168,000 of April 1 inventory at retail.
The weeks-of-supply method states the target as weeks of forward sales coverage. Twelve weeks of supply on a category selling $4,000 a week at retail targets $48,000 on hand.
The basic stock method adds a fixed floor-presence figure to each month's planned sales. Basic stock equals average monthly inventory at retail minus average monthly sales at retail. A store averaging $157,300 of inventory and $48,000 of monthly sales carries $109,300 of basic stock.
Cross-checking is the point. When the stock-to-sales method and the basic stock method disagree by more than 10 percent in a month, one input is wrong. Finding out which takes ten minutes.
How to Set Planned Markdowns Without Guessing
Set planned markdowns from last season's recorded markdown dollars, expressed as a percentage of recorded sales, then adjust for known carryover. A store that took $31,000 in markdowns on $290,000 of sales ran a 10.7 percent markdown rate.
Carryover raises the rate. Merchandise entering a season already six months old needs a deeper reduction than fresh goods. Add markdown dollars in the months where you intend to clear it.
A markdown plan with no dollars in it is a plan to be surprised in July. Every apparel season ends with markdowns, and the only question is whether they were budgeted.
The On-Order Subtraction, Which Is Where Most Plans Break
On-order is merchandise already committed on a purchase order but not yet received. Subtracting it converts open-to-buy from a theoretical ceiling into a spendable balance.
Open-to-buy still available = Open-to-buy (retail) - On-order at retail for that month
A store with $28,000 of May open-to-buy at retail and $44,000 of May deliveries already committed has negative $16,000 available. Writing a new order in that state doesn't overspend the budget slightly; the budget was already gone.
The failure mode is mechanical, and carelessness has nothing to do with it. Purchase orders written at a January trade show for May delivery sit invisible in a folder until the truck arrives. The spreadsheet shows a healthy open-to-buy the whole time.
Operator Tip: File Every Purchase Order Under Its Delivery Month
File every purchase order under the month the goods are scheduled to arrive. Total those folders into your on-order row before each monthly update. A January order for August delivery spends August's budget.
Two people writing orders in the same store makes this mandatory. One shared on-order tab, updated the day an order is written, prevents the double-commit that produces most negative open-to-buy months.
What to Do When Open-to-Buy Comes Back Negative
A negative open-to-buy means inventory on hand plus inventory on order already exceeds what the month's plan supports. The number is a measurement of a decision made earlier, and it carries three responses.
Cancel or reschedule what the vendor will let you move. Many vendors will push a delivery a month for a phone call made before the ship date. None will do it after the box is in transit.
Raise planned markdowns in the current month to drain the excess. Every dollar of markdown is a dollar of inventory reduction. Markdowns appear in the open-to-buy formula on the same side as sales.
Write no new orders for that month. This is the response owners resist, and it's the only one that costs nothing.
Building an Open-to-Buy Template in Excel or Google Sheets
A complete open-to-buy template for a single-location independent retailer fits in twelve rows and twelve columns. Rows are the plan lines, columns are the months, and one tab holds one category.
The Twelve Rows Every Open-to-Buy Template Needs
Build the sheet in this row order, because each row feeds the one below it. Every row is stated in retail dollars except the last.
- Planned sales, entered by hand from last year plus named adjustments.
- Recorded sales, entered on the first business day of the following month.
- Planned markdowns, entered by hand from last season's markdown rate.
- Recorded markdowns, entered from the POS markdown report each month.
- Stock-to-sales ratio, entered by hand per month.
- Planned BOM inventory, calculated as stock-to-sales ratio times planned sales.
- Recorded BOM inventory, calculated from last month's closing balance.
- Planned EOM inventory, which equals next month's planned BOM inventory.
- Open-to-buy at retail, calculated from the four-term formula.
- On-order at retail, entered from the purchase order folders by delivery month.
- Open-to-buy still available, calculated as row 9 minus row 10.
- Open-to-buy at cost, calculated as row 11 times the cost complement.
The Formula Cells, Written Out
Assume months run across columns B through M, and the row numbers above. Four cells carry every calculation in the sheet.
Planned BOM inventory in row 6: =B5*B1
Recorded BOM inventory in row 7, for the second month onward: =B7+B_receipts-B2-B4. Receipts is the retail value of merchandise received in the prior month. Add a receipts row if your POS reports it, or read it off vendor invoices at retail.
Open-to-buy at retail in row 9: =B1+B3+B8-B7
Open-to-buy at cost in row 12: =B11*0.45, substituting your own cost complement for 0.45.
How to Split the Template by Category, Vendor, or Class
Split the template into separate tabs at the level where you make a distinct buying decision. For most independent stores that means four to eight tabs, plus a summary tab that sums them into a store total.
Apparel boutiques usually split by class: tops, bottoms, dresses, outerwear, accessories. Gift and home stores more often split by vendor, because vendor minimums drive the order size.
Splitting too finely is the more common error. A tab planning $3,000 of annual receipts produces monthly open-to-buy figures of $250. That's smaller than one case pack, and it does no work as a control.
The Three Mistakes That Break a Spreadsheet Template
Three failures kill spreadsheet open-to-buy plans, and all three come down to maintenance instead of math.
The first is a stale on-order row. An on-order figure updated monthly, instead of the moment an order is written, understates commitments for up to 30 days. That window covers the entire period in which the buying decision gets made.
The second is beginning-of-month inventory taken from the POS on-hand report without a physical check. On-hand quantities drift from reality through shrink, receiving errors, and returns. A plan built on a wrong opening balance is wrong in every downstream cell.
The third is planning at cost while measuring markdowns at retail. Mixing bases inside one sheet produces open-to-buy figures that look plausible and run 20 to 40 percent off.
Download: The Open-to-Buy Planning Template for Independent Retailers
The twelve-row structure above is available as a pre-built spreadsheet with the formula cells already written. It carries one tab per category plus a summary tab that rolls up to a store total. The season worked in this guide comes filled in, so you can see every cell populated before you clear it.
[PUBLISHER: place the Open-to-Buy Planning Template download and email capture form here]
The Open-to-Buy Cadence: Monthly, Seasonal, and at the Trade Show
Open-to-buy planning works on three clocks: a monthly reforecast, a twice-yearly seasonal rebuild, and an exception process for trade shows. The monthly clock is the one that keeps the plan alive, and it's the one most independent retailers drop by March.
The Monthly Rhythm: First Business Day, Forty-Five Minutes
The monthly update runs on the first business day and takes about 45 minutes for a store with six category tabs. It has four steps, in order.
Step one, enter last month's recorded sales and recorded markdowns from the POS into rows 2 and 4. Pull both from the same report run on the same date so the numbers reconcile.
Step two, calculate the recorded beginning-of-month inventory for the new month and enter it in row 7. Opening inventory plus receipts minus sales minus markdowns gives the closing balance that becomes this month's opening balance.
Step three, reforecast the remaining months of the season. When the season runs 8 percent under plan through three months, multiply every remaining month's planned sales by 0.92. Hold the original figure only when you have a named reason.
Step four, update the on-order row from the purchase order folders and read row 11. That figure is what you may spend this month, and it's the number to carry into any vendor conversation.
The Weekly Check That Takes Ten Minutes
A weekly check catches the drift that a monthly cadence misses, and it needs two numbers. Compare week-to-date sales against one quarter of the month's planned sales, and compare the on-order row against the remaining open-to-buy.
When week-to-date sales run more than 15 percent under the weekly pace two weeks running, the month's plan has already broken. Waiting until the first of the following month to act gives up two to three weeks of markdown runway.
The Seasonal Rhythm: Pre-Season, Mid-Season, Post-Season
Open-to-buy plans get rebuilt twice a year, six to eight weeks before each season opens. Most independent apparel and gift stores run a spring season of February through July and a fall season of August through January.
Pre-season sets planned sales, markdown rates, and stock-to-sales ratios for all six months. This is the only point in the cycle where the ratios themselves change. Changing them mid-season hides overbuying instead of correcting it.
Mid-season arrives at the end of month three, and it runs heavier than the routine monthly update. Compare recorded season-to-date sales against plan, apply the variance to the remaining three months, and recompute every downstream figure.
Post-season happens in the two weeks after the season closes, and it's the step almost nobody runs. Measure sell-through by delivery month, count the cost dollars left over, and carry both numbers into the next pre-season plan.
The Trade Show Exception, and How to Handle It
Trade shows break open-to-buy discipline by compressing six months of buying decisions into three days, with delivery dates spread across the season. The plan survives when the owner brings a printed on-order-by-delivery-month sheet and writes each order into it before leaving the booth.
Set a hard show budget per delivery month before the first appointment. A show budget stated as one total number gets spent entirely on February and March goods. The June and July windows go unfilled.
Timing matters more in seasonal categories than owners tend to price in. Holiday sales in November and December have averaged about 19 percent of total retail sales over the last five years, per the National Retail Federation. That puts roughly a fifth of the year inside two months of receiving.
Key Insight: The Cadence Beats the Formula
An approximate open-to-buy plan updated monthly outperforms a precise one updated twice a year. The formula is arithmetic that takes a minute; the beginning-of-month inventory figure it depends on goes stale in about three weeks.
Independent retailers who abandon open-to-buy almost always abandon the monthly update. The math was never the obstacle. Put the first business day of every month on the calendar as a recurring 45-minute block before you build the sheet.
A Worked Example: One Boutique, One Spring Season, Every Line
Take a 1,600-square-foot apparel and gift boutique running Shopify, doing about $620,000 a year at retail, with a 55 percent initial markup. The spring season runs February through July, and the owner buys at two trade shows plus a handful of rep appointments.
The boutique above is an illustrative store built to show the math end to end. Every figure below is constructed for the example, and none of it comes from a specific client.
Step 1: The Pre-Season Plan, Built in January
The owner plans $288,000 of spring sales at retail and a 12 percent markdown rate. Stock-to-sales ratios start high in February and fall toward the July clearance. August opens the fall season at $44,000 of planned sales and a 3.5 ratio, which sets the July end-of-month target at $154,000.
| Month | Planned sales | Stock-to-sales ratio | Planned BOM | Planned markdowns | Planned EOM | Open-to-buy (retail) | Open-to-buy (cost) |
|---|---|---|---|---|---|---|---|
| February | $36,000 | 3.8 | $136,800 | $3,600 | $151,200 | $54,000 | $24,300 |
| March | $42,000 | 3.6 | $151,200 | $4,200 | $168,000 | $63,000 | $28,350 |
| April | $48,000 | 3.5 | $168,000 | $4,800 | $178,200 | $63,000 | $28,350 |
| May | $54,000 | 3.3 | $178,200 | $5,400 | $180,000 | $61,200 | $27,540 |
| June | $60,000 | 3.0 | $180,000 | $7,200 | $129,600 | $16,800 | $7,560 |
| July | $48,000 | 2.7 | $129,600 | $9,360 | $154,000 | $81,760 | $36,792 |
| Season | $288,000 | $34,560 | $339,760 | $152,892 |
Two features of this plan deserve attention before the season starts. June's open-to-buy is $7,560 at cost, which closes the month to almost all new buying. July's $36,792 is large because fall merchandise starts landing.
An owner who reads this table in January knows that a June rep appointment has almost no budget behind it. An owner without the table finds out in June.
Step 2: What the Register Recorded, February Through April
Spring opened soft. February rang $34,200 against a $36,000 plan, March rang $39,900 against $42,000, and April rang $41,000 against $48,000.
Season-to-date sales landed at $115,100 against $126,000 planned, running 8.7 percent under. Markdowns ran ahead of plan at $14,600 taken against $12,600 budgeted, because the owner was already reacting to slow racks.
Receipts told the other half of the story. February and March landed on plan at $54,000 and $63,000 retail. April came in at $71,400 against a $63,000 budget, because a vendor minimum on an outerwear line forced an extra $8,400.
| Month | Opening inventory | Receipts | Recorded sales | Recorded markdowns | Closing inventory | Plan said |
|---|---|---|---|---|---|---|
| February | $136,800 | $54,000 | $34,200 | $3,100 | $153,500 | $151,200 |
| March | $153,500 | $63,000 | $39,900 | $4,600 | $172,000 | $168,000 |
| April | $172,000 | $71,400 | $41,000 | $6,900 | $195,500 | $178,200 |
May opened at $195,500 of inventory at retail against a planned $178,200. The store was $17,300 over at retail, which is $7,785 at cost.
Step 3: The Mid-Season Reforecast, Run on May 1
The owner applies the 8.7 percent shortfall to the remaining months. May reforecasts to $49,300, June to $54,800, and July to $43,800. Holding the original figures would have been the more comfortable choice and the more expensive one.
June's beginning-of-month inventory target falls with the sales forecast. At the planned 3.0 ratio, $54,800 of June sales calls for $164,400 on hand June 1, down from $180,000.
May's markdown budget rises from $5,400 to $9,800, because the April overbuy needs somewhere to go. Recomputing gives 49,300 + 9,800 + 164,400 - 195,500, which is $28,000 of May open-to-buy at retail.
Then the on-order row does its job. May deliveries already committed at trade shows total $44,000 at retail. Open-to-buy still available reads 28,000 - 44,000, which is negative $16,000.
The store is $7,200 at cost past its own ceiling before writing a single new order. That negative number is the entire value of the exercise. It arrived on May 1 instead of in a July bank balance.
Step 4: How June Pays for April
June opens at $180,400 of inventory at retail after May's committed deliveries land and May's markdowns clear. July's target, at $43,800 of forecast sales and a 2.7 ratio, is $118,300.
June markdowns rise to $12,400. Recomputing gives 54,800 + 12,400 + 118,300 - 180,400, which is $5,100 of June open-to-buy at retail, or $2,295 at cost.
The original plan gave June $7,560 at cost, and the corrected plan gives it $2,295. A single $8,400 April overbuy at retail removed roughly 70 percent of June's buying budget.
Overbuying costs a store the overbought amount plus the merchandise it could have bought later and couldn't. That is the mechanism, stated plainly.
Step 5: The Post-Season Audit, Run in Early August
The post-season audit measures sell-through by delivery month, because that's the unit the buying decision was made in. Spring receipts totalled $106,875 at cost across five delivery months.
| Delivery month | Received at cost | Weeks on floor at July 31 | Sell-through | Remaining at cost |
|---|---|---|---|---|
| February | $24,300 | 24 | 89% | $2,670 |
| March | $28,350 | 20 | 84% | $4,540 |
| April | $32,130 | 15 | 66% | $10,920 |
| May | $19,800 | 11 | 58% | $8,320 |
| June | $2,295 | 7 | 61% | $900 |
| Total | $106,875 | 74% | $27,350 |
Spring closed with $27,350 at cost still on the floor, and $19,240 of it came from the April and May deliveries. Those are the two months where receipts ran past the plan.
Weeks on floor is what makes the table readable. June's 61 percent sell-through after 7 weeks is a stronger result than April's 66 percent after 15 weeks. A category-level report would have shown neither.
The $27,350 now sets next season's opening condition. That merchandise occupies floor space in August and shrinks the fall buy. It also needs an exit plan of its own, covered step by step in How to Liquidate Excess Inventory in 8 Steps.
That $27,350 Has a Real Number Behind It in Your Store
The worked example above is constructed. The equivalent figure in your store is recorded right now in your Shopify or Square sales history. One connection surfaces it.
Create a free workspace through the trapped-cash diagnostic, then use an eligible production connection or compatible item-level upload. Direct provider availability depends on production launch status and workspace eligibility. Shopify supplies unit cost when available; Square and Lightspeed analyses add costs through CMP's prefilled template. After a successful import with sufficient history and cost evidence, the workspace classifies eligible SKUs and protects new or incomplete items as Data Incomplete.
What CMP Adds to the Post-Season Step
Cash Margin Partners surfaces current SKU classifications and cost dollars left in stalled inventory. A delivery-month sell-through table still requires receipt or delivery data from point-of-sale exports or the retailer's receiving records.
The read-only connection catalog covers Shopify, Square Point of Sale, and Lightspeed Retail X-Series where production launch status and workspace eligibility permit, with compatible item-level spreadsheet exports for other systems after column review. Clover is announced as coming next.
In the diagnostics we've run, owner memory and the delivery-month table diverge most in the middle of a season. February and July are memorable. April blurs.
After a recent successful supported live connection has supplied sufficient usable history and cost evidence, the predictive layer can add 30-, 60-, and 90-day cash-at-risk forecasts. Cash-at-risk is the dollar value of inventory CMP forecasts won't sell inside the window. Those are model projections rather than commitments, and the free workspace provides recovery evidence rather than an open-to-buy plan.
Open-to-Buy Benchmarks and What Good Looks Like
Open-to-buy performance is measured on four numbers, and a store hitting all four has a working plan. Each one is checkable from data an independent retailer already has.
The Four Open-to-Buy Benchmarks to Track Every Month
| Benchmark | What it measures | Target for an independent store | Where to read it |
|---|---|---|---|
| Receipt variance | Merchandise received against open-to-buy authorized | Inside 5% per month | Vendor invoices at retail against row 9 |
| Sales forecast accuracy | Recorded sales against planned sales | Inside 10% per month | POS sales report against row 1 |
| Stock-to-sales ratio | Opening inventory against the month's sales plan | 2.5 to 4.0 for apparel, 2.0 to 3.0 for gift | Row 7 divided by row 1 |
| Season-end carryover | Cost dollars unsold at season close against season receipts | Under 15% of receipts at cost | Post-season sell-through table |
The worked example above closed spring at 25.6 percent carryover against a 15 percent target. A store reading that figure in early August has five months to correct the fall plan.
How to Read the Census Inventories-to-Sales Ratio Against Your Own Numbers
The Census inventories-to-sales ratio compares inventory dollars against one month of sales dollars. It's a directional gauge rather than a turnover calculation. All retail stood at 1.25 in May 2026 and clothing and clothing accessory stores at 2.11, per Census data published by the St. Louis Fed.
Use the sector figure to check the direction of your stock-to-sales ratios, and use your own trailing twelve months to set them. A single boutique in a specialty category sits above or below the sector figure for reasons that figure knows nothing about.
Turnover is the companion measure, and the method for calculating it is covered in How to Calculate Inventory Turnover in 6 Steps. A store planning stock-to-sales ratios averaging 3.3 across a six-month season is planning roughly 3.6 annual turns at retail.
The Aging Report That Feeds Next Season's Plan
An inventory aging report groups on-hand merchandise by how long it has sat in the store. That report is the input that keeps a pre-season plan from repeating last season's error. Merchandise older than 180 days at season open needs markdown dollars budgeted against it in months one and two.
Run the aging report before you set stock-to-sales ratios. The procedure is laid out in How to Run an Inventory Aging Report in 7 Steps.
Merchandise with no verified sales history over the measured window is dead stock. It needs an exit instead of a markdown ladder. Shopify stores can isolate it using the method in How to Find Dead Stock in Shopify in 7 Steps.
The Position Most Planning Advice Skips
Open-to-buy planning fails in independent retail for a reason that has nothing to do with the arithmetic. The formula assumes an accurate beginning-of-month inventory figure, and most single-location stores can't produce one to within 10 percent on demand.
Retailers who fix the opening-balance problem first get a working plan in one season. Retailers who build a template on top of an unchecked POS on-hand figure get a different result. The plan drifts further from reality every month it runs.
Count first. Plan second.
Comparing the Five Open-to-Buy Approaches Side by Side
Independent retailers run open-to-buy through one of five approaches, and they solve different parts of the problem. Pricing and features below were checked on August 5, 2026.
| Approach | What it produces | Published cost | Best fit | Where it falls short |
|---|---|---|---|---|
| Spreadsheet template | A full monthly open-to-buy by category, maintained by hand | Free | Single-location stores with four to eight category plans | On-order goes stale; the opening balance depends on a manual count |
| POS-native reporting | Sales history, on-hand quantities, and markdown reports as plan inputs | Included in the POS subscription | Every store, as the data source feeding the plan | Reports what sold; produces no receiving budget |
| Dedicated planning software | Automated open-to-buy by category, brand, or vendor, with purchase order integration | Inventory Planner publishes no rates, quoting by inventory volume on request | Multi-location or high-SKU-count retailers | Quote-based pricing and setup time; heavier than a single boutique needs |
| Consultant-led planning | Forecasts, inventory targets, and open-to-buy built with a retail consultant | Management One publishes no rates, working by consultation | Owners who want a second opinion on the buy alongside the number | Ongoing engagement cost; the cadence depends on the consultant's calendar |
| Cash Margin Partners | Eligible-SKU classification of what last season's buy left behind, with new or incomplete items held as Data Incomplete | The Cash Margin Partners product and workspace are free; the proposed marketplace publishes a 10% fee on a closed transaction, subject to production acceptance | Owners who need the post-season evidence before writing the next plan | Produces no forward receiving budget; it measures what the buy did instead of capping the next one |
How Two of These Approaches Stack Together in One Store
Most independent retailers end up running two of these together. A spreadsheet or a planning tool sets the forward budget, and a diagnostic supplies the opening condition that budget has to absorb.
CMP doesn't replace an open-to-buy plan, and it never has. Cash Margin Partners measures the cash sitting in merchandise that already failed. That figure is the input a pre-season plan needs, and the one owners most often estimate from memory.
Start Here: Four Moves Before Your Next Purchase Order
The four steps below run in order, and the first one uses data already sitting in your POS today.
- Pull last season's sales by delivery month and build the sell-through table. Export receipts by month at cost, export units sold, and calculate the sell-through percentage per delivery month. Thirty minutes of spreadsheet work gives you the number your next plan opens with.
- Count the merchandise that has been on the floor longer than 180 days, at cost. That figure is the tax on your next season. It belongs in your markdown budget before you set a single stock-to-sales ratio.
- Build the twelve-row template for your two largest categories only. Two working tabs beat eight abandoned ones. Add categories in month two, once the monthly update has survived a cycle.
- Put the first business day of every month on the calendar as a 45-minute block. The update takes 45 minutes; rebuilding an abandoned plan in month four takes a full day and produces a worse answer.
Frequently Asked Questions
What is open-to-buy in retail?
Open-to-buy is the dollar amount of new merchandise a retailer may receive in a given month without breaking its inventory plan. The number is calculated per month, per category, and it falls as inventory on hand or on order rises. A store with a May open-to-buy of $28,000 at cost may write purchase orders up to $28,000 for May delivery.
What is the open-to-buy formula?
The open-to-buy formula in retail dollars is planned sales plus planned markdowns plus planned end-of-month inventory, minus beginning-of-month inventory. Inventory Planner publishes the same four-term calculation on its open-to-buy page. Subtract merchandise already on order for that month to get the open-to-buy still available to spend.
How often should an independent retailer update an open-to-buy plan?
Update an open-to-buy plan monthly, on the first business day, and rebuild it twice a year at pre-season. The monthly update rolls last month's recorded sales, markdowns, and receipts into the beginning-of-month figure, then reforecasts the remaining months. A ten-minute weekly check of on-order against remaining open-to-buy catches the rest.
What does a negative open-to-buy mean?
A negative open-to-buy means the store has more inventory on hand and on order than its own plan supports for that month. The three responses are cancelling or rescheduling purchase orders, raising planned markdowns, and writing no new orders that month. A negative open-to-buy is a measurement rather than a penalty, and it points at the month the plan broke.
Can I do open-to-buy planning in Excel, or do I need software?
A single-location independent retailer can run a complete open-to-buy plan in Excel or Google Sheets with twelve rows per category. The spreadsheet becomes the wrong tool at roughly eight to ten category plans, or when two people write purchase orders. Dedicated planning software earns its cost once keeping the on-order row current takes longer than the buying decision.
What stock-to-sales ratio should an independent retailer plan to?
Stock-to-sales ratio is beginning-of-month inventory at retail divided by planned sales at retail, and apparel boutiques plan between 2.5 and 4.0. Clothing and clothing accessory stores carried an inventories-to-sales ratio of 2.11 in May 2026, per Census data published by the St. Louis Fed. Set the ratio highest at the start of a season and lowest in the month before markdown clearance.
How do I know whether last season's buy was right?
Measure sell-through by delivery month against the weeks each delivery spent on the floor, where 89 percent after 24 weeks reads healthy. An April delivery at 66 percent sell-through after 15 weeks is where the cash stopped. This table requires receipt or delivery data from point-of-sale exports or the retailer's receiving records.
Build the Plan on Last Season's Record
An open-to-buy plan built on remembered performance repeats the buy that produced the leftovers. The delivery-month sell-through table is what replaces the memory, and every figure it needs is already recorded in your POS.
Start with the number you have. Create a free workspace through the trapped-cash diagnostic, then use an eligible production connection or compatible item-level upload. Review what last season left behind after the import succeeds with sufficient history and cost evidence, before you write next season's first purchase order.