ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / 12-Month Cash Flow Forecast
Free Excel template

12-Month Cash Flow Forecast

Free Excel 12-month cash flow forecast: receipts and payments by line, net flow, balance carried over month to month, threshold and overdraft alert, lowest point of the year.

Comptia by Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

Get the template by e-mail, and its updates.

Keep the six files of « 12-Month Cash Flow Forecast » in your inbox, to find or share them later. The direct download stays free, no sign-up.

  • The France, Québec and Africa versions, in French and English.
  • If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
  • Your details are never sold, one-click unsubscribe.
Contents

What the workbook contains.

Cash flow

Receipts, payments, net flow, balances, alerts over 12 months

Dashboard

Lowest point, its month, tight months

Free lines

One receipt and one payment line to name

Settings

Currency, first month, opening cash, threshold

Instructions

Get started in 3 minutes, cells protected without password

Print

One landscape page

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, enter the first month, the opening cash and the minimum threshold.

  2. 02

    Enter expected receipts and payments in the month the money moves, taxes included.

  3. 03

    Closing cash carries over to the next month; the alert flags months below the threshold or overdrawn.

  4. 04

    Each month, replace the forecast with the actual and add a month.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
The P&L measures what the business earns, at invoice date and net of tax. The cash flow forecast follows money actually received and paid, taxes included, in the month of payment. A profitable business can run out of cash if its customers pay late.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.