If you’ve ever been surprised by a negative bank balance, a 13-week cash flow forecast would have shown that coming eight weeks out. That’s not hindsight — it’s the whole point. This tool doesn’t predict the future perfectly; it shows you the shape of what’s coming so you can act before things get ugly.
Here’s how to build one that actually gets used.
Why 13 Weeks?
Thirteen weeks is one quarter. Long enough to spot seasonal dips and large bills landing together. Short enough that your estimates are based on real data, not wishful thinking. Monthly forecasts hide the week-to-week crunches that actually kill businesses — payroll week with a slow receivables week is a problem even if the month looks fine on paper.
The Spreadsheet Structure
Set up columns across the top: Week Ending Date for each of the 13 weeks. Then build three sections down the left:
Section 1 — Cash In
- Customer payments (by invoice due date, not invoice date)
- Other income (loans, owner contributions, one-time items)
- Total Cash In
Section 2 — Cash Out
- Payroll (net pay + employer taxes)
- Rent / mortgage
- Inventory / materials purchases
- Utilities and subscriptions
- Loan payments
- Owner draws
- Everything else (use a catch-all for small stuff)
- Total Cash Out
Section 3 — Running Balance
- Net Cash This Week:
=Total Cash In - Total Cash Out - Opening Balance: prior week’s closing balance
- Closing Balance:
=Opening Balance + Net Cash This Week
The first Opening Balance is your actual checking account balance today.
Filling It In
Cash In — look at your outstanding invoices. Sort them by due date. If a $4,000 invoice is due in week 3, put $4,000 in week 3. If customers typically pay 10 days late, shift it to week 4. Be honest about slow payers.
For recurring customers on predictable schedules, extrapolate from history. If you bill a client $2,500 every month and they pay in 30 days, model that.
Cash Out — most of your bills have fixed dates. Rent is the 1st. Payroll is every other Friday. Pull up your last 90 days of bank statements and list every payment with its date. Recurring = predictable. One-time items (equipment, insurance renewals) go in the week they’re actually due.
The Formula That Matters
In your Closing Balance row, use conditional formatting to highlight any cell where the value drops below a threshold — say, $5,000:
=IF(C20<5000, "ALERT", "OK")Or just apply a red fill via Format > Conditional Formatting > “Less than” > $5,000. When you see red, you have time to do something about it.
What to Do When It Turns Negative
A projected negative balance is not a crisis — it’s a warning. You have options:
Speed up receivables. Call customers with invoices due in weeks 6-8 and ask if they can pay early. Offer a 1-2% early payment discount if needed. This is usually the fastest cash you can access.
Delay payables. Call vendors you have relationships with and ask for an extra 2 weeks. Most will say yes once. Don’t make it a habit.
Tap your line of credit before you need it. Lines of credit exist for exactly this situation. Drawing on one when you can, not when you must, means you’re not begging for money under pressure.
Cut discretionary spending. If you were planning to buy equipment, push it past the crunch. The forecast shows you exactly how many weeks you need to survive.
Contact your bank early. If the gap is large enough that none of the above fixes it, talk to your banker now. Banks lend to businesses that plan ahead. They don’t rescue ones that show up in crisis.
Keeping It Current
A forecast only works if you update it. Spend 15 minutes every Monday:
- Move last week’s column to an “Actuals” tab for comparison
- Add a new week 13 column at the right
- Update cash in with any payments received Friday or today
- Flag any new bills that landed
After 6-8 weeks, you’ll have actual vs. forecast data that makes your future projections more accurate.
Next Step
Open a new Google Sheet right now. Create your 13 columns for the next 13 Fridays. Pull up your bank statement and outstanding invoices. Enter your opening balance and start filling in what you know is coming. You don’t need perfect numbers — you need directionally correct numbers. Done in an afternoon, useful for the rest of the quarter.
5 Google Sheets Every Small Business Needs
Cash flow, P&L, mileage log, invoice tracker, and payroll — all free.
No spam. Unsubscribe any time.