Cash Flow Forecast Template for Retail Stores

A shop’s busiest months are also its most expensive to prepare for. Stock for the holiday season is ordered and paid for in late summer, seasonal staff start before the rush, and rent is due whether the high street is busy or empty. A retail cash flow forecast tells you how much stock you can afford to buy for the peak without running dry in the weeks before it.

Why retail cash flow is different

• Stock ties up cash. Most of a shop’s working capital sits on the shelves, and it has to be paid for before it sells.
• Seasonality is extreme. Many shops make a large share of annual sales in November and December.
• Supplier terms vary. Some suppliers want payment on order, others give 30 or 60 days; the difference changes cash dramatically.
• Card fees and shrinkage. Processing fees, theft, damage and markdowns reduce cash from every sale.
• Fixed costs don’t flex. Rent, business rates or property taxes, and core staff cost the same in February as in December.

A worked example

A gift shop sells about $75,000 a month, rising to $120,000 in December. Cost of goods is 52 percent of sales, and stock arrives two months before it sells.

October is the tight month: the shop is paying for December’s stock while taking October’s ordinary sales. A forecast lets the owner negotiate later payment terms, split the order, or arrange a short-term facility before October arrives.

How to build a retail cash forecast

1. Forecast sales by month from last year, adjusted for trends and events.
2. Calculate stock purchases from cost of goods and your supplier lead times.
3. Apply each major supplier’s payment terms.
4. Add payroll, including seasonal staff, rent, utilities and marketing.
5. Deduct card fees, shrinkage and markdowns as percentages of sales.
6. Keep a buffer to cover January and February, when sales are lowest.

Common mistakes

Ordering peak stock based on hope rather than last year’s sell-through. Forgetting that gift cards sold in December are January’s liabilities. And paying seasonal bonuses or taking drawings before January’s rent and supplier bills are covered.

What the template gives you

The Retail Store template includes a Stock Purchases tab that turns your sales forecast into stock payments using your cost of goods percentage and lead time, and a Card & Shrinkage tab for processing fees and losses. Change the Christmas forecast and see the effect on your October bank balance immediately.

Key assumptions built into the Retail Store template

• The Stock Purchases tab calculates what you pay for stock each month: cost of goods at 52% of in-store sales and online sales, paid 2 months before it sells. Raise next season’s sales forecast and the stock payments move earlier and grow automatically.
• The Card & Shrinkage tab calculates pos and card fees at 2.2% of in-store sales and online sales and shrinkage and markdowns at 1.5% of in-store sales. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 4 cash in lines and 8 cash out lines are already named for retail store businesses, and every one can be renamed or extended.
• The example figures follow a typical retail store year, busiest in December and November and quietest in January and February, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Retail Store template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Retail Store cash flow forecasting: questions

How much stock should a retail store buy for the holiday season?

Base it on last year’s sell-through by category, adjusted for trends, and check the cash flow forecast to confirm you can pay for it before the sales arrive.

How do supplier payment terms affect retail cash flow?

Longer terms mean you pay after some of the stock has sold. Moving from payment on order to 60-day terms can remove most of the pre-season cash squeeze.

What is a typical cost of goods percentage for retail?

It varies by sector, but many independent shops run cost of goods at 45 to 60 percent of sales.