13-Week Cash Flow Forecast — Excel Template

See the cash crunch coming weeks before it hits, while you still have time to do something about it.

Profit on paper doesn't pay the rent. Cash in the bank does. This forecast shows you, week by week for the next 13 weeks, how much cash you'll actually have, and warns you before a tight week sneaks up on you.

What's inside

• Forecast: enter your starting cash and the money you expect in and out each week. Ending cash rolls forward automatically.
• Safety buffer alerts: weeks below your comfort level turn yellow, and weeks below zero turn red. It also shows your lowest balance of the quarter and the first week you'll dip below your buffer.
• Cash chart: the whole quarter at a glance.
• Actuals: log what really happened each Friday.
• Forecast vs Actual: see exactly where your plan was off so next quarter's forecast is sharper.

Details

• Format: Excel workbook (.xlsx) with a Start Here tab and example numbers
• Works in Excel 2010 or newer (Windows, Mac, Microsoft 365) and opens in Google Sheets
• Instant download. Save a copy and roll it forward every quarter.

Pairs well with The 90-Day Business Planner.

Save with the bundle: The Owner's Toolkit includes this forecast, the Small Business Bookkeeping Kit and the Job Pricing & Breakeven Calculator for $30 instead of $47.

From Grit & Ledger: business knowledge and motivation for people who build things.