Cash & Runway Planner · Excel 365

How many months can we cover if a client pays late?

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.

cash-runway-planner-v1.2.0-worked-example.xlsx Demo data
Dashboard of the Cash & Runway Planner with demo data: the scenario picker at the top set to Client leaves, months covered, lowest month-end cash, the checks, a Do this next line, a line chart of cash by month and a column chart of money in and out.
  • Yellow cells: you type. Leave every other cell to the workbook.
Open full-size image of the Dashboard sheet Watch the walkthrough (1:18)

01What it answers

Three questions, answered every month

  1. How many months does the cash cover?

    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.

  2. What if a client pays late or leaves?

    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.

  3. How much rests on one client?

    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

See the actual workbook

Walkthrough, 1:18: Start Here, Setup and the Dashboard, then a demo plan from Money In to the Cash Plan, and the Client leaves scenario cuts months covered from 9 to 5. Captioned, no sound needed.
Read what the video shows
  1. See how many months the cash covers if a client pays late or leaves. On screen: the Dashboard of the worked example, which opens on the Client leaves scenario. Status SAMPLE; plan Oct 2026 to Sep 2027, in USD.
  2. In this fictional demo, losing one client cuts 9 months covered to 5. Outlined: months covered of 12, base case 9; Client leaves 5, marked Fewer than the base case.
  3. Yellow cells: you type. Leave every other cell to the workbook. On screen: the color key on Start Here; the yellow swatch reads Yellow: you type here.
  4. White cells calculate. Grey cells hold lists and reference values. Outlined: White: calculated, don't type here, and Grey: lists and reference values.
  5. Start Here has nothing to type. Do this next says what to do. On screen: Start Here, row 5. Do this next is outlined. It reads "See the sample plan on the Dashboard, then clear the sample rows (steps below)." Nothing on Start Here is typed.
  6. Setup: start Oct 2026 with 48,000.00. Keep at least 15,000.00 at month end. On screen: Setup, the settings column, with currency USD and 4,000.00 already set aside for tax. Outlined: the start month and opening cash, then the minimum cash buffer, 15,000.00.
  7. Setup complete reads Yes, so Do this next moves on. On screen: Setup complete, row 20, reads Yes and is outlined. The note under it says that Start Here's Do this next reads this line.
  8. On the Dashboard, change Scenario shown from Base case to Client leaves. On screen: the top of the Dashboard. Scenario shown changes from Base case to Client leaves, and the key figures change with it. The note beside it names the plan, Oct 2026 to Sep 2027, and the currency, USD, and says to change them on Setup.
  9. Months covered drops from 9 to 5, with cash at -31,250.00 by Sep 2027. On the Dashboard: months covered, base case 9, Client leaves 5; lowest month-end cash -31,250.00, in Sep 2027; cash at end of Sep 2027 -31,250.00, Below zero.
  10. On Money In, add one row per retainer and one per unpaid invoice. On screen: 13 demo rows, IDs EX-IN-01 to EX-IN-13, for eight fictional clients.
  11. On Money Out, list each committed cost. Payroll: 3 paydays in October, 24,600.00. On screen: 10 demo costs; payroll is 8,200.00 every 2 weeks from 2 Oct 2026. The month columns show 24,600.00 for Oct 2026 and Apr 2027 and 16,400.00 for the months between.
  12. July ends at 9,505.00, below the buffer, so the base case covers 9 months. On screen: the Cash Plan base case; Jul 2027 reads Below buffer, and the Covered so far column adds up to 9.
  13. Scenario columns on Reference: Sample Studio leaves from Jan 2027. On screen: the client list with each client's usual days late; Beacon Legal and Elm Street Hospitality also have extra days late for the Late payment scenario, 45 and 30.
  14. Nine checks. Only Sample data is flagged, so the status reads SAMPLE. On screen: eight checks read OK; check 10, Sample data, counts 23 sample rows and reads SAMPLE.
  15. Clear the sample data in three steps, and the status reads OK. The steps on Start Here (steps 1 and 2 are on screen; step 3 is cut at the right edge of the frame and is shown by the next shot): click the Name Box; choose MV_Clear_MoneyIn and press Delete, then do the same for MV_Clear_MoneyOut and MV_Clear_Reference; check the Dashboard. After clearing, the Dashboard status reads OK, every check count is 0 and the key figures are blank. Settings are kept.
  16. Help: the Guide sheet, and email support. We reply within 1 business day. On screen: the Guide's Support row: [email protected]; include the version, your Excel version, the sheet and row, and what you saw; replies Monday to Friday, Australian Eastern time.
  17. See every sheet and what is tested at metricvalley.com. End card: Cash & Runway Planner, Excel 365, Google Sheets edition when it ships, metricvalley.com, beside the Dashboard's line chart of cash at month end for the base case, Client leaves and the minimum cash buffer.
  18. Recording note: Scenario shown was set to Base case before the walkthrough, then switched back to Client leaves, the value the file ships with. Nothing else was changed.

Watch it on its own page, with chapters

cash-runway-planner-v1.2.0-worked-example.xlsx Demo data
Money In sheet: demo retainers and invoices with amounts, due dates, each client's usual days late, expected payment dates and a timing note.

Money in. One row per retainer or project invoice. Each client's usual delay moves the payment into the month it really arrives.

03What's inside

Eight sheets, one job

Demo data

Start 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.

Demo data

Setup

The 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 data

Dashboard

The 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 data

Money in

Partly 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 data

Money out

Months with three paydays show three.

A cost linked to a client stops when that client leaves in the scenario.

Demo data

Cash plan

Prints on three pages as a report.

Demo data

Reference

The two workbooks are never linked; you paste values.

Demo data

Guide

Read it in the workbook or print it.

Exactly what's in the download

One ZIP file (about 1139 KB), delivered by Payhip straight after payment.

FileWhat it isSize
xlsxcash-runway-planner-v1.2.0-blank.xlsx The workbook for your own plan 718 KB
xlsxcash-runway-planner-v1.2.0-worked-example.xlsx The same workbook with a demo plan and scenarios 726 KB
htmlSTART-HERE.html Open this first: what each file is and where to begin 11 KB
mdquick-start.md Setup steps, reading the Dashboard and using scenarios 12 KB
mdmetric-dictionary.md Every field and calculation defined 21 KB
mdsupport-and-compatibility.md What is tested, what isn't, and how to ask for help 5 KB
mdlicense.md License terms for both tiers 3 KB
mdrelease-notes-v1.2.0.md What is in this version, and where the settings went 9 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
txtMANIFEST-cash-runway-planner-v1.2.0.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 10 minutes (estimate)

  1. Fill in Setup your currency, start month, opening cash and the minimum cash you want to keep.

    About 3 minutes.
  2. 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.
  3. 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

Twelve months at a fictional studio

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.

Opening position, October 2026 (fictional)
Cash in the bankUS$48,000
Kept for tax−US$4,000
Cash availableUS$44,000
October 2026 (fictional)
Money inUS$35,400
Set aside for income tax (5%)−US$1,770
Money out, with three paydays−US$37,900
Cash at the end of OctoberUS$39,730

The studio and its clients are fictional. These are the figures in the worked-example workbook, not a customer result.

06Fit

Is it right for you?

Good fit

  • Small agencies, studios and consultancies with retainers and project invoices
  • Businesses with a payroll or regular contractors to cover every month
  • Owners who want to see what one late payer or lost client does to the next 12 months
  • Anyone who wants the figures in a file they can check line by line

Not a fit

  • You need bookkeeping, invoicing, payroll, bank reconciliation or tax returns.
  • You need a daily or weekly cash forecast, or one longer than 12 months.
  • You hold cash in several currencies and need each forecast separately.
  • You want payments and balances to arrive automatically from your bank or other software.
  • You need several people editing at once with permissions or change history.

Known limitations

  1. It is a cash plan, not accounting. Balances are estimates from what you type, not your bank records.
  2. One currency per file. Convert money in other currencies before you type it. There are no live exchange rates.
  3. Cash is shown at each month end for 12 months from the start month. A dip between paydays shows only in the "Low point if costs go out first" column, so set your buffer to cover it.
  4. Tax set-asides are percentages you choose, not tax calculations or advice. The plan assumes tax bills are paid from money set aside.
  5. Tested in Excel 365 for Windows desktop. Mac, Excel for the web and the Google Sheets edition are not yet tested.
  6. Excel mobile and the Google Sheets mobile apps are for viewing only, not data entry.
  7. Capacity is 500 Money In rows, 200 Money Out rows and 200 clients; more needs the steps in the Guide.

07Tested on

Where it has been tested

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

36/40 checks passed, 4 not yet run
Excel 365, Windows desktop
  • Workbook version1.2.0
  • Last testedNov 7, 2026
  • Excel 365, Mac desktopNot yet tested
  • Excel for the webNot yet tested
  • Google Sheets (native edition)Not yet tested
  • Excel mobile (iOS, Android)Not supported

What the cases cover

  • Acceptance cases on the worked example, including all five scenarios, checked against an independent calculation
  • Retainers with two payments in one month, due days of 29 to 31, and pay every two weeks with three paydays
  • Overdue, partly paid and undated invoices, overdrafts, and a buffer of zero
  • Tax set-asides with clients that are not charged sales tax, and the tracker import
  • The 1.0.0 worked example's settings and rows entered into the 1.1.0 blank file gave the same figures: 938 values compared, 0 mismatches.
  • The 1.1.0 worked example's settings and rows entered into the 1.2.0 blank file gave the same figures: 940 values compared, 0 mismatches.
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 — — — —

What changed in 1.2.0

Nov 7, 2026

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.

  • The Dashboard has its own Do this next line: one next step for the file as it stands.
  • Excel 365, Windows desktop: Tested with notes, 36 of 40 checks passed, 4 not yet run, workbook 1.2.0, Excel 16.0.20527.20150, tested Nov 7, 2026. 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 for Mac, Excel for the web and Google Sheets: not yet tested.

Inputs affected: No. Nothing you type moved: every setting, name, table and column is where it was.

08What you get

What you get

Each purchase includes the files above, updates, email support and a license for your business.

  • Workbook: 8 sheets, no macros, no external connections; tested in Excel 365 for Windows desktop. The Google Sheets edition is free for every buyer when it ships.
  • Updates: 1.x updates are free and are delivered through Payhip.
  • License: Single-business, for one business and all its staff. Agency/Team is store-wide: the tracker's US$99 Agency/Team license, or the bundle's US$129 Agency/Team tier, covers this tool too, for up to 5 client businesses.
  • Support: Email support; we reply within 1 business day (Monday to Friday, Australian Eastern time).
  • Guide: a Guide sheet inside the workbook, plus a setup guide on this site.
  • Google Sheets: the Google Sheets edition is included free for every buyer when it ships.

09License

License

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.

Single-business

included at US$29

For one business or sole trader, and everyone who works in it: staff and contractors.

Allowed
Edit and extend the workbook, keep backups, share reports and results with your team, clients, advisers and board.
Not allowed
Using it for a second business, giving an editable copy to a client or anyone outside the business, reselling or posting it online.
Buy for US$29

30-day money-back guarantee. No questions asked.

Agency/Team

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.

Allowed
Everything in Single-business, plus separate working copies for up to 5 client businesses you manage, as long as you keep the file and send them the results.
Not allowed
Giving clients or anyone outside your agency an editable copy, reselling, or including it in a product, course or template library.
See Agency/Team on the tracker page

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

30-day money-back guarantee

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

Questions before you buy

I bought version 1.0.0. What changed in 1.1.0?

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.

How is "months covered" worked out?

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.

What happens if a client pays late?

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.

Does it connect to my bank or accounting software?

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.

Can it handle payroll every two weeks?

Yes. Costs can be paid once, weekly, every two weeks, monthly, quarterly or yearly, and a month with three paydays shows three.

Does it work out sales tax or income tax?

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.

How does it work with the Client Profitability Tracker?

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.

Can my whole team use it?

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.

Is the Google Sheets edition included?

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.

What happens after I pay?

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.

Does it work on a Mac?

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.

Cash & Runway Planner · US$2930-day money-back guarantee. No questions asked.

Buy for US$29