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.
Where this applies

Chris Greco
Founder and President, CFO Anywhere. CFO for owner-led companies since 2002. Executive MBA, Gies College of Business, University of Illinois.
About ChrisMore 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.