How to Create a Cash Flow Forecast for Retail Stores

TL;DR

• A retail cash flow forecast predicts the money moving in and out of your shop over the coming weeks and months, so you can spot shortfalls before they hit.
• Start by mapping your sales income, then add stock purchases, payroll, rent and other outgoings on the dates cash actually moves.
• Retail has quirks worth planning for: seasonality, stock bought before it sells, and card settlement delays.
• Update the forecast regularly and test what-if scenarios so you are never caught short.

A retail cash flow forecast is a projection of the cash entering and leaving your shop over a set period, usually week by week or month by month. To build a retail cash flow forecast, list your expected sales income, subtract your outgoings such as stock, wages and rent on the dates the money genuinely changes hands, and carry the running balance forward. This tells you exactly how much cash you will have available at any point in the future.

Cash flow is different from profit. You can be profitable on paper and still run out of cash if you have paid suppliers for stock that has not yet sold. That gap is precisely what a good forecast helps you manage.

---

What is a retail cash flow forecast?

A cash flow forecast is a financial tool that estimates how much cash a business will have on hand at any given point in the future. It draws on past cash flows, your current cash position and expected future inflows and outflows. For a retail business, it turns the messy reality of daily takings, supplier payments and quiet trading weeks into a clear picture you can plan around.

Why retail cash flow is different

Shops carry stock, and stock ties up cash. You often pay for goods weeks before a customer buys them, so money leaves your account long before it comes back. Seasonality adds another layer: a homeware or gift shop might earn most of its income between spring and early autumn, then face lean winter months. A retail cash flow forecast makes those swings visible so you can hold enough cash back to cover the quiet spells.

Cash flow versus profit and loss

Your profit and loss statement shows whether your sales beat your costs over a period. Your cash flow shows the timing of the actual money. A store can post a healthy profit for the quarter and still miss a rent payment because a big stock order landed the same week. Forecasting keeps both in view.

---

How to create a cash flow forecast for a retail store

Building a forecast is a case of working through your inflows, then your outflows, then reading the running balance. Here is a practical order to follow.

1. Forecast your sales income

Estimate your takings for each week or month ahead. If you have trading history, use it: look at the same period last year and adjust for what has changed. If you are new, base your figures on realistic customer numbers and average basket value. Split income by channel if it helps, for example in-store tills, click and collect and any online orders. The approach here overlaps heavily with an ecommerce cash flow forecast if you sell online as well as on the shop floor.

2. Account for how customers actually pay

Cash and contactless payments settle quickly, but card takings can take a day or two to reach your bank, and gift card redemptions shift income across periods. Record income on the date the money lands in your account, not the date of the sale. This small discipline is what separates a forecast that works from one that misleads.

3. Map your stock purchases

Stock is usually a retailer’s biggest cash outflow, so treat it carefully. Enter supplier payments on the dates you actually pay, allowing for any credit terms you have agreed. If you buy seasonal ranges in advance, that large outflow needs to sit in the forecast weeks before the matching sales appear. The same logic applies whether you run a fashion boutique, as covered in our guide to a cash flow forecast for a clothing business, or a mobile trader like a food van business.

4. Add your fixed and variable outgoings

List everything else that leaves the account: rent, business rates, utilities, payroll, insurance, card processing fees, marketing and loan repayments. Fixed costs like rent recur predictably. Variable costs move with your trading, so scale them against your sales forecast.

5. Calculate the running balance

For each period, take your opening balance, add inflows, subtract outflows and carry the closing balance into the next period. Any point where the balance turns negative is a warning: you need more cash, later payment terms or lower spending in the run-up to it.

---

Handling the tricky parts of retail forecasting

Planning for seasonal peaks and troughs

Most shops trade unevenly across the year. A useful method is to build your income from historical monthly patterns, then hold back cash from strong months to cover weaker ones. If your income is genuinely unpredictable, our tips on forecasting cash flow with an irregular income will help you set conservative assumptions.

Managing stock without draining cash

Order too much and cash sits on shelves. Order too little and you lose sales. Model different buying schedules in your forecast to find the balance that keeps shelves stocked and the bank account safe. Testing these choices before you commit is far cheaper than learning from a real cash crunch.

Testing what-if scenarios

Scenario planning means running your forecast under different assumptions, for example a 10% drop in footfall or a supplier raising prices. Comparing those versions side by side shows how resilient your store is and where to act first. This is the same principle behind cash flow planning for SaaS businesses, applied to shop trading.

---

Building your retail cash flow forecast in Brixx

Brixx is web-based financial forecasting and business planning software that turns your plan into a full cash flow forecast, profit and loss statement and balance sheet automatically, with no spreadsheets needed. You add components for your income streams and costs, place them on the Timeline for when cash moves, and the forecast updates as you go.

From plan to automated forecast

Our pre-built industry templates give retailers a sensible starting point, and the Xero integration lets you bring in real figures to sharpen your projections. For a step-by-step walkthrough, see how to create a cash flow forecast in Brixx, and if you want to understand the output first, read our guide to the cash flow forecast report.

---

Keeping your forecast useful

Review and update regularly

A forecast is only as good as its latest numbers. Compare actual takings and payments against your projections each week or month, then adjust future periods. Over time this makes your assumptions more accurate and your planning more confident. The same discipline helps a seasonal gardening business stay ahead of its own quiet months.

A well-maintained retail cash flow forecast gives you the visibility to buy stock with confidence, cover slow periods and make growth decisions without gambling with your cash.