Free template · .xlsx

The 13-⁠week cash flow template we use with clients.

Four sheets, working formulas and a fictional company already filled in. Swap in your bank balance and your payment dates, and you have a weekly cash forecast in an afternoon.

Four sheets, working formulas and a fictional company already filled in. Swap in your bank balance and your payment dates, and you have a weekly cash forecast in an afternoon.

Get the template

First name*

Work email*

Company

Your role

We use your details to send the file and our monthly guide. We never sell your information.

We use your details to send the file and our monthly guide. We never sell your information.

01

01

Inside the file

Inside the file

What’s inside

What’s inside

What’s inside

01

01

Start here

How the file works, which cells to edit and which to leave alone. Input cells are shaded; everything else is a formula.

How the file works, which cells to edit and which to leave alone. Input cells are shaded; everything else is a formula.

02

02

Assumptions

Company name, forecast start date, opening cash and your minimum cash buffer. Every week and total on the other sheets reads from here.

Company name, forecast start date, opening cash and your minimum cash buffer. Every week and total on the other sheets reads from here.

03

03

13-⁠week forecast

Receipts, disbursements, net flow and ending cash for each week, with payroll, rent, taxes and debt service on their own lines. Any week below your buffer is flagged.

Receipts, disbursements, net flow and ending cash for each week, with payroll, rent, taxes and debt service on their own lines. Any week below your buffer is flagged.

04

04

Variance

Forecast ending cash against actual ending cash each week, with the gap in dollars and percent and a column to mark it as timing or permanent. This is where the Monday update happens.

Forecast ending cash against actual ending cash each week, with the gap in dollars and percent and a column to mark it as timing or permanent. This is where the Monday update happens.

05

05

Demo numbers included

A fictional company with about $10M in revenue is filled in across the input cells, including one week that dips below the buffer, so you can see what good looks like before you clear it.

A fictional company with about $10M in revenue is filled in across the input cells, including one week that dips below the buffer, so you can see what good looks like before you clear it.

02

02

Who it’s for

Who it’s for

Built for whoever answers for the cash number.

Built for whoever answers for the cash number.

Built for whoever answers for the cash number.

Founders who want their real runway, week by week, instead of a monthly estimate

Finance leads moving the team from a month-⁠end cash check to a weekly forecast

Companies preparing for a raise, a lender review or a board meeting about cash

Send me the template

Hand holding printed charts above a notebook and calculator

03

03

Questions

Questions

About the template

About the template

About the template

What is in the 13-week cash flow template?

Is the template free, and what do you do with my email?

Can I use the template with my accountant?

Create a free website with Framer, the website builder loved by startups, designers and agencies.