Published: 03/25/2026
Last updated: 04/07/2026
Somewhere on your desktop lives a spreadsheet, last updated three months ago. It has a tab called "DO NOT DELETE", and the formula in column G is held together with hope and a VLOOKUP that nobody fully understands.
Sound familiar? You're not alone. Most founders start their cash flow forecasting in Excel, and most of them quietly stop updating it the moment things get busy – which is exactly when they need it most.
The good news: you don't need a perfect spreadsheet to forecast cash flow. You need a simple, honest picture of what's coming in and going out – and a habit of looking at it regularly. This article shows you how to build that, without being an Excel or finance wizard.
💡 Key takeaways
Cash flow forecasting doesn't require complex tools – it requires consistent habits.
The 13-week rolling forecast is the most useful format for product brands: long enough to see inventory cycles play out, short enough to stay accurate.
The three things to track: cash in (and when), cash out (and when), and the gap between them.
Tools like Float, Dryrun and Xero's built-in forecasting can replace the spreadsheet without adding complexity.
The goal isn't to predict the future perfectly – it's to see problems early enough to do something about them.
Why most founders stop forecasting
It usually starts well. You build a cash flow model before a big order, or when a bank asks for one. You update it for a few weeks. Then Q4 hits, or a supplier changes their terms, or you launch a new SKU, and the model quietly becomes fiction.
The problem isn't discipline – it's that most cash flow tools are built for accountants, not operators. They're backwards-looking, time-consuming to update, and they live in a format that doesn't fit how founders actually think.
What founders need isn't a model. It's a dashboard. Something that answers one question at any given moment: am I about to run out of cash, and if so, when?
The 13-week rolling forecast
If you do one thing after reading this article, make it this: set up a 13-week rolling cash flow forecast.
Thirteen weeks – roughly one quarter – is the sweet spot for product brands. It's long enough to see inventory payment cycles play out. Short enough that the numbers stay reasonably accurate. And "rolling" means you add a new week on the end every week, so you always have a 90-day view.
Here's what goes in it:
Cash in
Expected customer payments (with realistic timing, not invoice dates)
Any financing drawdowns expected
Other income
Cash out
Supplier payments (include deposits and final payments separately)
Payroll and contractor costs
Shipping and 3PL costs
Marketing spend
Overheads
The gap
Opening cash balance each week
Closing cash balance each week
Any weeks where closing balance goes below your minimum comfortable threshold
That last part is the whole point. You're not trying to predict every penny – you're trying to spot the weeks where cash gets tight before they arrive.
Tools worth knowing about
You don't have to build this in a spreadsheet. Several tools do most of the heavy lifting, especially if you're already using an accounting platform.
Float – integrates directly with Xero, QuickBooks and FreeAgent. Pulls your actuals automatically and lets you build scenarios on top. Genuinely founder-friendly. Good for brands doing £500k+ revenue who want something more robust than a spreadsheet but don't need full CFO software.
Dryrun – similar to Float, slightly more flexible for scenario planning. Better for brands with more complex cash flows – multiple currencies, wholesale and DTC combined.
Xero's built-in cash flow – if you're already on Xero, the short-term cash flow feature is worth turning on. It's not as powerful as Float, but it's free and it's already connected to your data.
A simple Google Sheet – honestly, if you're sub-£500k revenue and the tools above feel like overkill, a well-maintained Google Sheet shared with your bookkeeper is still better than nothing. The habit matters more than the tool.
Four forecasting habits that actually stick
The tool is only useful if you use it. These are the habits that make cash flow forecasting something you actually do, rather than something you mean to do.
1. Update it on the same day every week Pick a day – Monday morning, Friday afternoon – and make it non-negotiable. It takes 15 minutes once your system is set up. The consistency matters more than the frequency.
2. Always use realistic payment timing, not invoice dates If your retailer pays in 60 days but the invoice says 30, forecast 60 days. Optimistic cash flow forecasts are worse than useless – they give you false confidence at exactly the wrong moment.
3. Set a minimum cash threshold and treat it like a red line Decide what your minimum comfortable cash balance is – the number below which you'd genuinely be stressed. Make that number visible in your forecast. When a week shows you going below it, that's your trigger to act, not to panic.
4. Run a scenario before every major inventory order Before you commit to a purchase order, update your forecast to include it. See what it does to your cash position over the following 8–12 weeks. This is the single most useful thing a forecast can do for a product brand – it shows you whether you can actually afford the growth you're planning.
When your forecast shows a gap
Seeing a cash gap in your forecast isn't a failure – it's the whole point. You've spotted the problem before it's a crisis. What you do with it depends on the size and timing of the gap:
Small gap, short timeline: Offer an early payment discount to bring cash in faster, delay a spend, draw down on an existing facility.
Larger gap tied to a specific order: This is where inventory financing makes sense. Rather than stretching your cash or delaying the order, you fund the supplier payment and repay once the goods have sold. Treyd is built for exactly this situation – product brands that need to bridge the gap between paying suppliers and getting paid by customers.
Recurring gap that keeps appearing: That's a structural working capital problem worth looking at more carefully – your cash conversion cycle is probably longer than it should be. Your working capital health check is a good next read. See also our practical guide for product businesses on working capital.
Summary
Cash flow forecasting doesn't need to be complicated. It needs to be honest and consistent. A 13-week rolling forecast, updated weekly, with realistic payment timing and a visible minimum threshold – that's enough to run a product brand without nasty surprises. The spreadsheet on your desktop isn't going to save you in itself. But fifteen minutes every Monday morning might.
About Treyd
Treyd is working capital built for product businesses. We help fast-growing brands, wholesalers, and distributors close the gap between paying suppliers and getting paid by customers – so cash flow stops being the thing that slows you down.
Buy first, pay suppliers later. Advance your customer invoices. No collateral, no lengthy bank process – just a simple, human experience built around how product businesses actually work.
Over 1500 brands trust Treyd to fund their growth. See how at treyd.io/customers →
💜 Grow faster. Keep control. Bet bigger.
