The 13-Week Cash Flow Forecast: A Simple Tool Every Long Island Small Business Should Use
Denise runs a small landscaping supply shop and knows her bank balance down to the dollar every morning. What she doesn’t know is what that balance looks like six weeks from now, after payroll, after the quarterly insurance payment, and before the spring rush brings cash back in. She finds out the hard way, one tight week at a time.
That’s not a bookkeeping problem. It’s a visibility problem, and it has a simple fix.
Why “checking the balance” isn’t a cash flow plan
Most small business owners manage cash by glancing at the bank balance and reacting. It works until it doesn’t, usually right when a big expense lands the same week as a slow sales stretch. By then there’s no time to plan around it, only time to scramble.
A 13-week cash flow forecast fixes this by giving you a rolling look at the next quarter, broken into weeks instead of months. Weeks are short enough to be accurate and long enough to see problems coming before they arrive.
What it actually is
Strip away the finance jargon and it’s a simple spreadsheet with four things for each of the next 13 weeks:
- Starting cash. What you have on hand at the start of the week.
- Cash in. Expected customer payments, invoices due, deposits, anything hitting the account.
- Cash out. Payroll, rent, loan payments, supplier invoices, taxes, anything leaving the account.
- Ending cash. Starting cash plus in, minus out. This becomes next week’s starting cash.
That’s it. No forecasting software required, though QuickBooks and similar tools can help populate it once it’s set up.
Why 13 weeks specifically
One quarter is long enough to see a slow season coming, a big tax payment approaching, or a seasonal ramp-up before it’s already happening. It’s also short enough that the numbers stay realistic. A 12-month forecast is mostly guessing. A 13-week forecast is mostly known.
For Long Island’s many seasonal businesses, landscaping, home services, retail with a summer or holiday bump, this window is exactly the length where the swings start to show up on paper before they show up in the bank account.
Building the first one
Start rough. The first version doesn’t need to be perfect, it needs to exist.
List every recurring expense you know is coming: payroll dates, rent, loan payments, insurance, subscriptions, tax deadlines. Add expected customer payments based on your invoice due dates or typical sales pattern. Update it weekly as actual numbers come in, and the forecast gets sharper every week you run it.
The value isn’t in precision. It’s in seeing a tight week three weeks out instead of three days out, while there’s still time to adjust: delay a purchase, follow up on a slow-paying invoice, or line up a short-term option before it’s an emergency.
What to do when it shows a problem
A forecast is only useful if you act on what it tells you. If week seven shows a cash dip, that’s the moment to speed up receivables, hold off on a discretionary purchase, or have a financing conversation while you’re not under pressure, not after the account is already tight.
That’s the entire value of the tool: turning a surprise into a decision you had weeks to make.
Free download: The 13-Week Cash Flow Forecast Template
Ready to build your own? Grab the fillable Soundview template, thirteen weeks, one page, no spreadsheet degree required.
Soundview Marketing Group helps Long Island businesses build the marketing engine that keeps revenue predictable, which is half the battle behind a forecast you can actually trust.
