The 13-Week Cash Flow Forecast: A Step-by-Step Template for Contractors

A 13-week rolling cash flow forecast is the financial equivalent of a windshield. Without one, you're driving by looking in the rearview mirror - last month's bank statement, last quarter's P&L. With one, you can see ninety days down the road and adjust before you hit something.

Every Cash Flow Cowboy™ Clarity Build-Out engagement starts here. Not because it's fancy, but because it's the single tool that takes a contractor from reactive to in command.

Why 13 weeks?

Thirteen weeks is a calendar quarter. It's far enough out that you can see seasonal patterns, payment cycles, and tax due dates coming - but close enough that your estimates are still grounded in real receivables and real commitments. Anything longer becomes guesswork. Anything shorter is just a checkbook register.

The structure of the forecast

Your 13-week forecast has three sections stacked on top of each other:

• Cash inflows - collections by customer, retainage releases, deposits, financing draws, owner contributions.
• Cash outflows - payroll, payroll taxes, materials, subs, rent, insurance, debt service, owner draws, estimated tax payments.
• Net cash position - opening cash, plus inflows, minus outflows, equals closing cash. Every week.

Step-by-step build

1. 1.Open a spreadsheet with 13 columns across - one per week - plus a 'category' column down the left.
2. 2.Pull every open invoice into your inflows. Place each one in the week you actually expect to collect it, not the week it's due.
3. 3.Pull every committed expense into your outflows. Payroll runs, vendor bills, debt service, taxes, owner draws.
4. 4.Layer in the recurring expenses - rent, insurance, software, vehicles - in the correct week.
5. 5.Add a row for your opening cash position each week, then calculate closing cash = opening + inflows − outflows.
6. 6.Roll forward every Friday: drop the past week, add a new week 13, and update collections based on what actually happened.

Where contractors go wrong

The two killers I see most often: forecasting collections in the week they're due (instead of the week you actually expect payment), and forgetting tax due dates. Both turn the forecast into fiction inside a month. Be brutally honest about timing - that's where the value lives.

What changes when you have a real forecast

Three things, in this order: First, you stop being surprised. Cash crunches become events you saw coming, not emergencies. Second, you start making proactive moves - calling slow payers earlier, timing material orders better, adjusting draws before they hurt. Third, you start sleeping. The compounding effect of those three changes is enormous.

The Cash Flow Cowboy's™ rule of thumb

“A 13-week forecast doesn't have to be perfect. It has to exist. The act of building one and updating it weekly will change how you run the business - even before the numbers get accurate.”

If you'd like a copy of the template we use with our Clarity Build-Out clients, reach out. We'll send the spreadsheet and walk you through the first build on a 30-minute Cash Flow Cowboy™ Check-Up.