Retail Store Cash Flow: How to Forecast and Manage It

A shop’s cash lives on its shelves. Buy too much and cash is tied up in stock that won’t sell until it’s marked down; buy too little and the busy season’s sales are lost. Retailers who manage cash well treat stock purchasing as a cash decision first. This playbook sets out the routine. For how retail cash flow works and a worked Christmas example, see the retail store cash flow forecast page.

The weekly routine

1. Sales by category against forecast and last year.
2. Stock cover: weeks of stock for top categories and slow lines.
3. Deliveries and supplier payments due in the next eight weeks.
4. Markdowns planned or taken.
5. Labour as a percentage of sales.
6. Cash balance and the lowest point ahead.

Open-to-buy

Open-to-buy turns the sales forecast into a stock budget:

Open-to-buy = planned sales + planned closing stock + planned markdowns − opening stock − stock on order

All at cost. For example:

If buyers want to order more than $26,000, the forecast should show whether cash can support it. Open-to-buy keeps purchasing in line with sales and cash, and stops enthusiastic buying from running ahead of the forecast.

Weeks of cover in practice

Weeks of cover tells you how long current stock will last at current sales: stock on hand divided by average weekly sales, both at cost. A category with 20 weeks of cover in a business that restocks every four weeks is tying up cash. A bestseller with two weeks of cover and a six-week lead time is about to run out. Review cover weekly for your top twenty lines and monthly for the rest, and let it guide both reorders and markdowns.

Online sales alongside the shop

Many shops also sell online. Online orders bring payment processing, packaging, postage and returns costs, and may be paid out on a different schedule from in-store card sales. Forecast online sales as their own line with those costs attached, and make sure stock shared between the shop and the website is counted once. A popular product selling out online can leave the shop floor empty, and vice versa.

Supplier terms

The biggest cash lever in retail is when you pay for stock:

• negotiate payment 30 to 60 days after delivery, rather than on order
• ask for dated terms on seasonal orders, so autumn deliveries are paid in November or December
• consider sale-or-return or consignment for new or risky lines
• split large orders into several deliveries

Moving peak-stock payments by a month can remove the pre-Christmas squeeze entirely.

Markdowns

Slow stock ties up cash and space. Plan markdowns rather than reacting late: set a review date for each line, mark down in steps, and clear end-of-season stock before new stock arrives. A timely 20 percent markdown usually recovers more cash than a 50 percent one at the end of the season.

Peak season preparation

For a Christmas-heavy shop:

• July to August: forecast peak sales by category; set open-to-buy.
• September to October: stock arrives; cash is at its lowest point.
• November to December: peak sales; cash recovers.
• January: returns, markdowns, gift card redemptions and the quietest trading.

Arrange any seasonal facility in the summer, when your figures look strongest.

Staffing

Roster to footfall by day and hour, and plan seasonal staff from the forecast. Labour as a percentage of sales should stay roughly steady; if it rises in quiet weeks, adjust rotas.

Card fees, shrinkage and gift cards

Card fees apply to most sales; forecast them as a percentage. Shrinkage from theft, damage and errors is a real cost; count key lines regularly. Gift cards sold in December are January’s liabilities; keep a running total and hold cash to honour them.

A worked autumn

A gift shop plans December sales of $120,000 at a 52 percent cost of goods. Its buyer wants $70,000 of Christmas stock delivered in October, paid on delivery. The forecast shows October ending $8,000 below the $35,000 buffer.

Instead of cutting the order, the owner negotiates two changes with the main supplier: half the stock delivered in October and half in early November, and payment 30 days after each delivery. The October stock payment falls to $35,000 and moves into November, when sales have started to rise. The buffer holds all autumn, and the full range is on the shelves for December.

Rent and fixed costs

Rent, business rates or property taxes, insurance and utilities make up most of a shop’s fixed costs. Know your break-even sales per week, the sales needed to cover fixed costs and wages at your average margin, and compare each week against it. In quiet months, trading below break-even is expected; the forecast shows whether the busy months make up for it. Before a rent review or lease renewal, forecast the new rent against your quietest months.

Returns

Returns reduce cash after the sale, particularly after Christmas and for clothing and gifts. Forecast them as a percentage of sales in the weeks after each peak, and include any stock that can’t be resold.

Warning signs

• Weeks of stock cover rising on slow lines
• Open-to-buy regularly exceeded
• Markdowns taken late and deep
• Supplier payments due before the stock can sell
• Gift card balances spent as income
• Sales below last year for several weeks with no change to buying
• Suppliers shortening your terms or asking for payment upfront

When cash gets tight

1. Pause or reduce open orders where possible.
2. Clear slow stock with planned promotions.
3. Negotiate extended or dated terms with key suppliers.
4. Adjust rotas to current footfall.
5. Arrange a seasonal facility before the peak buying months.

Tools

The premium Retail Store template includes a Stock Purchases tab that pulls stock payments forward by lead time, a Card & Shrinkage tab, seasonal staff lines, scenarios for a weaker Christmas, and a dashboard. See also cash conversion cycle and seasonal cash flow.