Demo dataStart here
A Do this next line reads Open Setup until the settings are complete, then points you to the sample rows and the steps left.
Version, status and support details on one printable page.
Cash & Runway Planner · Excel 365
For small agencies, studios, consultancies and freelancers with retainers, project invoices and a payroll to cover.
A 12-month cash flow forecast with late-payment, lost-client and new-client scenarios.

01What it answers
Months in a row, from the month you start, in which cash at month end stays at or above the minimum buffer you set, for up to 12 months.
Type extra days late or a leave month next to any client, pick the scenario, and see the months covered, the lowest month-end cash and the month it happens, beside the base case.
Your largest client's share of the year's money in, and a check against the fees in your Client Profitability Tracker, so a missing or doubtful client stands out.
02Demonstration








Start here. What to do next, setup in five steps and a map of the sheets. Nothing to type here.
Setup. The settings you set once: business name, currency, start month, opening cash, minimum buffer, the optional tax set-asides and theme, with a Setup complete line.
Dashboard. Pick the scenario at the top; months covered for the base case and that scenario, the lowest month-end cash and when it happens, your largest client's share, nine checks and two charts. A Do this next line gives one next step for the file as it stands.
Money in. One row per retainer or project invoice. Each client's usual delay moves the payment into the month it really arrives.
Money out. One row per committed cost: payroll, contractors, rent, software, loans and drawings, paid once, weekly, every two weeks, monthly, quarterly or yearly.
Cash plan. Twelve months of money in, tax set-asides, money out and cash at month end, for the base case and the scenario, with costs by category and money in by client.
Reference. Your client list with each client's usual delay, the optional scenario columns, and a place to paste fee totals from the Client Profitability Tracker.
Guide. Every input, calculation, scenario and check explained inside the workbook, including how to roll the plan forward each month.
03What's inside
Demo dataA Do this next line reads Open Setup until the settings are complete, then points you to the sample rows and the steps left.
Version, status and support details on one printable page.
Demo dataThe scenario is not a setting. You pick it at the top of the Dashboard each time you read it.
To roll the plan forward, change the start month and the opening cash here.
Demo dataThe scenario is picked from a list at the top (B4), and the base case always stays beside it.
Five scenarios: base case, late payment, client leaves, new client, or all three together.
Its Do this next line gives one next step for the file as it stands.
Demo dataPartly paid and overdue invoices are handled and labelled.
Unsigned work can be kept out of the base case and tested as a new client.
Demo dataMonths with three paydays show three.
A cost linked to a client stops when that client leaves in the scenario.
Demo dataPrints on three pages as a report.
Demo dataThe two workbooks are never linked; you paste values.
Demo dataRead it in the workbook or print it.
One ZIP file (about 1139 KB), delivered by Payhip straight after payment.
| File | What it is | Size |
|---|---|---|
| xlsxcash- |
The workbook for your own plan | 718 KB |
| xlsxcash- |
The same workbook with a demo plan and scenarios | 726 KB |
| htmlSTART- |
Open this first: what each file is and where to begin | 11 KB |
| mdquick- |
Setup steps, reading the Dashboard and using scenarios | 12 KB |
| mdmetric- |
Every field and calculation defined | 21 KB |
| mdsupport- |
What is tested, what isn't, and how to ask for help | 5 KB |
| mdlicense. |
License terms for both tiers | 3 KB |
| mdrelease- |
What is in this version, and where the settings went | 9 KB |
| mdmoney- |
The 30-day money-back guarantee | 1 KB |
| txtMANIFEST- |
Checksums to verify your download | 1 KB |
04Setup
Fill in Setup your currency, start month, opening cash and the minimum cash you want to keep.
About 3 minutes.List your clients and what they owe you how late each client usually pays, then one row per retainer or unpaid invoice.
About 1 minute per row.Add your committed costs and read the Dashboard payroll, contractors, rent, software, loans and drawings; then pick a scenario.
About 1 minute per row.Estimate: a first plan with 6 clients and 10 costs takes about 25 minutes, including setup.
05Worked example
Fictional example
A fictional studio starts October 2026 with US$48,000 in the bank, US$4,000 of it kept for tax, and wants at least US$15,000 at every month end. Its signed retainers and invoices keep it above that line for 9 months, to June 2027. If its brand client Sample Studio leaves in January, the plan covers 5 months and cash goes below zero in May. If Beacon Legal and Elm Street pay 45 and 30 days later than usual, it covers 6. Signing Harbor Retail at US$4,000 a month from February would keep it covered for all 12 months.
| Cash in the bank | US$48,000 |
|---|---|
| Kept for tax | −US$4,000 |
| Cash available | US$44,000 |
| Money in | US$35,400 |
|---|---|
| Set aside for income tax (5%) | −US$1,770 |
| Money out, with three paydays | −US$37,900 |
| Cash at the end of October | US$39,730 |
The studio and its clients are fictional. These are the figures in the worked-example workbook, not a customer result.
06Fit
07Tested on
Each release is tested against written checks, and the results are listed here and on the compatibility page. "Not yet tested" means exactly that: it may work, but we haven't confirmed it.
Latest test run
| Environment | Status | Checks | Version and build | Last tested | Notes |
|---|---|---|---|---|---|
| Excel 365, Windows desktop | Tested with notes | 36/40 passed, 4 not yet run | Workbook 1.2.0 · Excel 16.0.20527.20150 · Windows Server 2025 Standard 10.0.26100 | Nov 7, 2026 | Automated runs on temporary copies: every calculated value against an independent calculation, the five scenarios, checks, validation, protection, clearing, theme, print on Letter and A4, and capacity. Not run: 4 checks that need the Excel interface, a system setting or a person. Not applicable, so not counted: 3.11 (plausibility warnings: every input rule here is a hard limit); 3.17 (exchange-rate check: each file holds one currency). |
| Excel 365, Mac desktop | Not yet tested | — | — | — | Not yet tested. |
| Excel for the web | Not yet tested | — | — | — | Not yet tested. |
| Google Sheets (native edition) | Not yet tested | — | — | — | Not yet tested. The Google Sheets edition is free for every buyer when it ships. |
| Excel mobile (iOS, Android) | Not supported | — | — | — | Viewing only; not tested for data entry. |
| Google Sheets mobile apps | Not supported | — | — | — | Viewing only; not tested for data entry. |
| Google Sheets (importing the .xlsx) | Not supported | — | — | — | Use the native Google Sheets edition. |
| LibreOffice Calc | Not yet tested | — | — | — | — |
| Apple Numbers | Not yet tested | — | — | — | — |
A free update for every buyer, delivered through Payhip. The Dashboard has its own Do this next line. The inputs, names and results are the same.
Inputs affected: No. Nothing you type moved: every setting, name, table and column is where it was.
08What you get
Each purchase includes the files above, updates, email support and a license for your business.
09License
Two licenses. Both let you edit the workbook, keep backups and share the reports it produces. Neither lets you pass the editable file to another business. Tracking your own clients is exactly what Single-business is for. You need Agency/Team only if you keep a working copy for another business's own figures.
included at US$29
For one business or sole trader, and everyone who works in it: staff and contractors.
30-day money-back guarantee. No questions asked.
Store-wide
For an agency and up to 5 client businesses it manages, and everyone who works in the agency. Store-wide: it covers every Metricvalley business template your business owns.
Agency/Team is store-wide: the Client Profitability Tracker's US$99 Agency/Team license, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template your business owns, including this planner, for up to 5 client businesses. This planner has no Agency/Team price of its own.
The full terms are in the download and shown before checkout. Nothing in them limits rights you have under consumer law. Read the full license terms.
10Guarantee
If the planner isn't right for your business, email [email protected] within 30 days of purchase with your order number. You'll get a full refund to your original payment method. No questions asked and no forms to fill in; we only ask that you delete your copies. This guarantee is in addition to your rights under the Australian Consumer Law and any other consumer law that applies to you.
11FAQ
It is a free update, delivered through Payhip. The settings moved from Start Here to a new Setup sheet, and the scenario you compare is now picked at the top of the Dashboard. Every name, table and column is the same, so your rows paste straight in. The setup guide lists where each setting went.
Month by month, the planner adds the money you expect in, takes off any tax set-asides and your committed costs, and compares cash at each month end with your minimum buffer. Months covered counts the months in a row, from the start month, that stay at or above it, up to 12.
Type the extra days next to that client on the Reference sheet, then pick Late payment from the scenario list at the top of the Dashboard. Every payment from that client moves later by those days, so you see which months lose it and how the months covered change. The base case stays beside it.
No. You type or paste your opening balance, the payments you expect and your costs. There are no macros or connections, so nothing changes unless you change it.
Yes. Costs can be paid once, weekly, every two weeks, monthly, quarterly or yearly, and a month with three paydays shows three.
No. You can keep aside a share of what you receive for sales tax, GST or VAT, and for income tax, at percentages you choose, so the plan shows cash that is yours to spend. It is not tax advice.
Paste each client's net fees from the tracker's Summary into the planner. It shows them beside the first three months of your plan, so a client you forgot stands out. The two files are never linked.
Yes, if they all work for the one business that bought it. Agencies that keep working copies for client businesses (up to 5) need Agency/Team, which is store-wide: the Client Profitability Tracker's US$99 Agency/Team license, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template you own, including this one. This tool has no Agency/Team price of its own.
Yes. The Google Sheets edition is included free for all buyers when it ships. It is built from the same specification, with the same sheets and checks. When it is ready, you get its Make a copy links through Payhip. Until then, use the Excel file: importing the .xlsx into Google Sheets is not supported.
Checkout is handled by Payhip. You get a download link on the confirmation page and by email: one ZIP file with a blank workbook, a filled-in example workbook and eight short files, including START-HERE.html, the license terms and a checksum manifest.
It hasn't been tested in Excel for Mac yet, so we don't say it works there. The current version is tested in Excel 365 for Windows desktop, and it uses no macros. The compatibility page lists every environment and its status. If you buy it for a Mac and it doesn't work as described, the 30-day money-back guarantee gives you a full refund.
More answers in the setup guide and the help center.