Skip to content
The first pages of the Cash Flow Forecast Report template

Cash Flow Forecast Report

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Difficulty
Beginner
Updated
November 6, 2026

Every page (7)

Overview

Finance managers often send a spreadsheet of weekly balances with no explanation, and lenders are left to work out where the pressure falls. This report puts the commentary beside the numbers: opening cash, receipts against budget, committed and flexible payments, headroom over the board floor, and a ranked register of what could move the forecast.

The sample follows Flintmere Capital through weeks 1 to 13 of 2027: cash opens at £400K, dips to £296K in week 7 after VAT and bonuses, and closes at £431K, always at least £96K above its £200K floor. Replace the opening balance, the receipts and payment lines, the floor and the risk owners with your own figures.

Useful for

  • A weekly treasury review where the finance manager explains receipts, payments and the cash low point
  • A lender update that shows headroom against a minimum cash requirement before a facility is renewed
  • A board paper that asks for approval to release new lending in tranches while cash stays above the floor

What's included

  • Opening page with title block, four headline figures and three points the reader needs first
  • Receipts and payments variance table with budget, forecast and actual in weekly averages
  • Payment tiers page with committed, controllable and deferrable payments and a ruled summary table
  • Headroom page with a closing cash chart, a payments donut and a key figures table
  • Risk register with ratings, owners and responses, plus a heat map page for the detail
  • Make it yours guide with five steps for replacing the sample content

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Enter your opening cash, the minimum cash floor and the forecast dates in the title block and headline figures on page 1.

  3. 3

    Replace the receipts and payments lines with your own weekly averages, and keep the totals, the donut shares and the key figures table tied.

  4. 4

    Re-rate the risks on both risk pages, name an owner for each and set a date for the next reforecast.

  5. 5

    Delete the Make it yours guide page, then share the forecast with your lender or board or present it.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Are the organisation and figures real?

No. Flintmere Capital, its people and every figure are fictional sample data, written so that the totals tie. Replace them with your own before you share the document.

Why are the variance figures weekly averages?

Weekly averages over the 13 weeks keep the table readable on one page. Link each line to your own model and show budget, forecast and actual on the same basis.

Can I change the floor and the headroom chart?

Yes. Edit the floor in the headroom text and key figures table, then update the chart values in Google Docs so the lowest balance and headroom still agree.

  • #cash-flow-forecast
  • #13-week-cash-flow
  • #treasury-report
  • #headroom
  • #finance-report
  • #google-docs-template
  • #liquidity

More financial projections templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…