Skip to main content
Back to insights

Cash flow · 6 min read · Published

How to build a 13-week cash flow forecast, with the template

By Chris Greco, Founder and President.

A 13-week cash forecast is a weekly table with nine rows: beginning cash, collections, payroll, vendors, debt service, taxes and distributions, capital purchases, ending cash and line availability. The rows are easy. The discipline is reconciling it to actual cash every week.

Collections come from the receivables aging by customer and how each one actually pays, not the terms on the invoice. Payables come from the aging by due date. Payroll is by cycle. Debt, taxes, distributions and equipment come from a calendar. Write the assumptions in the margin so someone can argue with them.

Every Monday, replace last week's forecast with what happened and read the variance by line. Collections short by $40k tells you which customer slipped. That variance is the whole point: it teaches you your business one week at a time. The template is on the Tools page.

Chris Greco

Founder and President, CFO Anywhere. CFO for owner-led companies since 2002. Executive MBA, Gies College of Business, University of Illinois.

About Chris

More from Chris

Cash flow · 1 min read

A forecast isn't useful because it's accurate

A forecast is not useful because it is accurate. It is useful because management knows what would make it wrong, and has already decided what to do when it is.

By industry · 4 min read

What we usually see when a carrier adds its tenth truck

When a carrier adds its tenth truck, revenue per truck goes up and cash per truck goes down. New equipment goes on new notes before the lanes that pay for them are full. Shippers get bigger and pay slower. Fuel moves faster than rates.

By industry · 3 min read

What we usually see when a family reaches its fourth entity

When a landlord or brokerage family reaches its fourth entity, each property has its own books kept differently, intercompany loans nobody documented, and K-1s that are late because the entity books close in March.

Tell us what's going on. We'll tell you what we see

One conversation with Chris, no deck. He'll tell you what he sees and what it would take to fix it, including if the answer is that you don't need a CFO yet.

Chris Greco, Founder and President.
Your first call is with him, not a sales team.