Files delivered as downloads — on screen and by email, as soon as payment is confirmed.

Small Business Cashflow Model

A twelve-month cashflow workbook with one assumptions tab everything reads from, for small businesses without a finance function.

€39

Total price.

Google Sheets/Excel · V1.0 · Updated 17 July 2026
Schematic preview — tab structure and dependencies, not a screenshot of the model.

01 What's inside

What's inside

  1. 01cashflow-model.xlsxExcelThe workbook: assumptions, income, costs, tax set-aside, twelve-month cashflow, monthly summary and invoice tracker, with a documented formulas tab. (7 tabs)~420 KB
  2. 02cashflow-model-worked-example.xlsxExcelThe same workbook filled in for a fictional two-person studio, including one scenario where the closing balance goes negative in month eight.~440 KB
  3. 03cashflow-model-google-sheets-copy-link.pdfGoogle SheetsCopy link for the Google Sheets version, with a note on the lookup written differently there.~90 KB

3 files

02 Specification

Specification

File formats
Google Sheets, Excel
File size
~950 KB total
What you need
Requires Excel 2016 or later, or a free Google account for the Sheets version.
Compatibility
  • Excel 2016 and later on Windows and macOS, including Microsoft 365. Opens and calculates in LibreOffice Calc 7.x.
  • The Google Sheets version is a copy link; one lookup is written with QUERY there where Excel uses SUMIFS, and both are documented on the formulas tab.
  • No macros, no VBA, no add-ins, no bank feeds and no external connections. Nothing has to be enabled on open.
  • All tabs are unlocked and unprotected. Labels, currency formatting and note text are in English and can be changed.
Language
English
Technical protection
No DRM. Files are not password-protected.
Licence
Commercial licence — what you may and may not do with these files.
Version
1.0
Updated
17 July 2026
Delivery
Download link on screen and by email as soon as your payment is confirmed. See how buying works.

03 Suited to / not suited to

Who this is for

Suited to

  • Owners of small businesses and studios who see the bank balance but not the next six months
  • Freelancers with lumpy income and predictable costs
  • Anyone preparing for a hire, a quiet quarter or a large invoice paid at 60 days

Not suited to

  • Anyone needing bookkeeping, statutory accounts or a VAT return — this is a forecast, not a ledger
  • Businesses with stock, multi-currency trading or complex revenue recognition, none of which are modelled

Note

This is a spreadsheet, not accounting software. Nothing in it is accounting, tax or financial advice, and the figures it produces are only as good as the assumptions you enter.

04 More previews

More previews

Schematic preview — how the numbers flow through the workbook.

Included in

Included in a bundle

This product is part of Freelance Starter Bundle — 4 products for €89.

05 Licence

Licence

Commercial licence — what you may and may not do with these files.

06 Buying, delivery and refunds

Buying, delivery and refunds

Note

Because the files are made available immediately at your request, the 14-day withdrawal right ends then. Your rights if a file is faulty are separate and last two years. See Refunds & Withdrawal.

Download link on screen and by email as soon as your payment is confirmed. See how buying works.

07 Version and changes

Version and changes

  • Version 1.0Initial release.2026-07-17

08 Questions about this product

Questions about this product

Which currency is it in?

Number formats are set to euro, and changing them is a formatting change on four tabs — no formula depends on the currency. There is no exchange-rate handling, so multi-currency trading is out of scope.

Does the tax set-aside calculate my VAT?

No. It applies a rate you enter to the lines you flag and moves that amount out of the available balance, so you are not spending money you owe. It is not a VAT return and not a calculation anyone has certified.

Can I extend it beyond twelve months?

Yes. The month columns are built from a start date and a fill, and the formulas tab explains which three named ranges to extend. Beyond about twenty-four months the assumptions are guesswork anyway.

Will it import my bank statements?

No. There is no import, no feed and no integration. You enter figures, which for a business of this size takes a few minutes a month.

Related products

Related products

Small Business Cashflow €39