Thirteen weeks is a quarter: far enough to see a squeeze coming, short enough to stay honest. Each week rolls opening cash, money in and money out into a closing balance against your minimum buffer, so a shortfall shows up weeks before it bites.

Is the 13-week cashflow free?

Yes. Download the 13-week cashflow as a ready-to-use Excel workbook, with no sign-in and no payment. It is yours to keep and edit.

What is inside the 13-week cashflow workbook?

Six sheets: a Start Here guide, the 13-week cashflow register (Week Starting, Opening Cash KES, Cash Sales KES, Customer Collections KES, Other Inflows KES, Supplier Payments KES, and more), a Dashboard that adds everything up, a Lists sheet for the dropdowns, a Settings sheet, and a Next step sheet. It opens in Excel, Google Sheets or WPS, with no macros.

Does it work in Google Sheets and on my phone?

Yes. The workbook opens in Excel, Google Sheets or WPS. There are no macros, so it works on a phone or a laptop. Keep your own copy before you share it.

How do I keep the 13-week cashflow consistent?

Use the dropdowns where they appear, and fill one row per entry. The Dashboard counts and summarises your entries, so you can see the picture at a glance without a formula.

How is this different from the SawaAfrik app?

A workbook is a file you fill in yourself. Inside a free SawaAfrik workspace the same shape fills from your real records, invoices, payroll and expenses flow in once and appear everywhere, deadlines remind you before they are due, and statutory figures are computed with their source and date. The workbook is the start; the app is when you stop retyping.

SawaAfrik

Money template

13-week cashflow: free Excel workbook

The 13-week cashflow is a free, multi-sheet Excel workbook for a Kenyan business: rolling 13-week view of cash in, cash out and closing balance.

The business is profitable on paper but still runs out of cash, and you never see it coming.

Free download

Excel workbook, no sign-in.

Download .xlsx Or start a free workspace

What is in the workbook

Start here

What the workbook is for, how to fill it, and the colour key.

13-week cashflow

The register: the right columns, dropdowns, and live totals. Type in the gold cells.

Dashboard

Your numbers added up as you go, with a simple bar view.

Lists

The dropdown options, so your data stays tidy and consistent.

Settings

The reporting currency, and where figures come from.

Next step

How SawaAfrik does this automatically from your real records.

The columns it includes

Week StartingOpening Cash KESCash Sales KESCustomer Collections KESOther Inflows KESSupplier Payments KESPayroll/Statutory KESRent/Overheads KESDebt Payments KESOther Outflows KESNet Cash KESClosing Cash KESMinimum Cash Buffer KES

How to use it

1Download the workbook and open the "13-week cashflow" sheet.
2Fill one row per entry. Type only in the gold cells; the white cells and the totals work themselves out.
3Where a cell has a dropdown, pick from the list instead of typing.
4Use the Dashboard to see your entries counted and summarised.
5When you outgrow the file, bring it into SawaAfrik, where it fills from your real records and the tax figures are computed for you.

Questions

Why 13 weeks?: Thirteen weeks is a quarter: far enough to see a squeeze coming, short enough to stay honest. Each week rolls opening cash, money in and money out into a closing balance against your minimum buffer, so a shortfall shows up weeks before it bites.
Is the 13-week cashflow free?: Yes. Download the 13-week cashflow as a ready-to-use Excel workbook, with no sign-in and no payment. It is yours to keep and edit.
What is inside the 13-week cashflow workbook?: Six sheets: a Start Here guide, the 13-week cashflow register (Week Starting, Opening Cash KES, Cash Sales KES, Customer Collections KES, Other Inflows KES, Supplier Payments KES, and more), a Dashboard that adds everything up, a Lists sheet for the dropdowns, a Settings sheet, and a Next step sheet. It opens in Excel, Google Sheets or WPS, with no macros.
Does it work in Google Sheets and on my phone?: Yes. The workbook opens in Excel, Google Sheets or WPS. There are no macros, so it works on a phone or a laptop. Keep your own copy before you share it.
How do I keep the 13-week cashflow consistent?: Use the dropdowns where they appear, and fill one row per entry. The Dashboard counts and summarises your entries, so you can see the picture at a glance without a formula.
How is this different from the SawaAfrik app?: A workbook is a file you fill in yourself. Inside a free SawaAfrik workspace the same shape fills from your real records, invoices, payroll and expenses flow in once and appear everywhere, deadlines remind you before they are due, and statutory figures are computed with their source and date. The workbook is the start; the app is when you stop retyping.

Related workbooks

All free workbooks

Want it built to your exact workflow, in your branding? We make custom workbooks, documents and software on the same registry-backed, audited platform.

Work with us