Kolumn

06 / 20 · Budget and finance

12-month cash flow forecast

Twelve months ahead: when money comes in and goes out.

SEK 129

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

See whether the money lasts, month by month. Enter receipts and payments when they actually happen (not when they are booked), and the template shows the closing balance each month and warns when it drops below your minimum.

What you get

Sheets
Cash flow
Each file also has an instructions sheet and a lists sheet.
Formulas
64
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Enter the start month, opening balance and the lowest acceptable balance at the top.
  2. Enter receipts and payments per month. Rename the rows as you like.
  3. The closing balance automatically becomes next month's opening balance.
  4. Months below the minimum balance are highlighted.