Demo dataStart Here
Estimate: setup in 5 steps takes about 10 minutes, plus about 1 minute per retainer.
Every setting you set once is on Setup. The status in row 3 of every sheet reads OK, CHECK (n) or SAMPLE.
Retainer Burn & Capacity Planner · Excel 365
For small agencies, studios and consultancies that sell monthly retainers with an hours allowance.
Retainer hours for this month and team capacity for next month.

01What it answers
Projected hours left and a run-out date for every active retainer, at the pace so far, counted in working days.
Hours over the allowance at month end, and for hourly retainers the amount at your overage rate. Value retainers show the hours you would absorb.
Client-work hours for each person after time off and public holidays, against the retainer and project hours already planned for them.
02Demonstration








Start Here. The workbook opens here, with nothing to type: a Do this next line that tells you where to go, setup in 5 timed steps and a map of every sheet.
Setup. Your settings in one column (business name, currency, first month, theme), with a line that says when they're all set.
Dashboard. The date your hours are counted up to at the top, then six key figures, the checks, the retainers with the least hours left, term end dates coming up, and two charts: hours left by retainer and next month's capacity by person. A Do this next line gives one next step for the file as it stands.
Retainers. One row per retainer: included hours, start and term end dates, status, who delivers it and the rollover rule. The rest of the row works out this month's burn and next month's hours.
Hours Log. Hours used, hours added or rolled over, time off and project work, one row at a time, by month. Its first four columns match the Client Profitability Tracker's Work Log.
Summary. This month's totals for the retainers and next month's totals for the team, then every person sorted by headroom and every retainer sorted by hours left.
Team. Each person's hours per week and the share that can go to client work, plus your public holidays. Next month's capacity is worked out beside each name.
Guide. Every input, calculation and check explained inside the workbook, so you can use it without this website.
03What's inside
Demo dataEstimate: setup in 5 steps takes about 10 minutes, plus about 1 minute per retainer.
Every setting you set once is on Setup. The status in row 3 of every sheet reads OK, CHECK (n) or SAMPLE.
Demo dataHours counted up to is not a setting. You change it at the top of the Dashboard on each visit.
Clearing the sample rows leaves these settings as they are.
Demo dataHours counted up to sits at the top: leave it blank to count up to today, or type a date to see a month as it stood on that day.
Retainers running out or over, projected hours left, overage to bill, term ends in the next 30 days, people overbooked and team headroom.
Every figure comes with a check. If something does not add up, the status reads CHECK and names the problem.
Its Do this next line gives one next step for the file as it stands.
Demo dataHourly or value retainers, several per client, part months prorated for you.
Rollover rules: none, next month only, or carry forward, with an optional cap.
Demo dataKeep one row per retainer per month and update it, or add a row per timesheet. Both work.
Rows with a missing detail, an unknown retainer or a date outside the retainer's term are marked Review and left out of the totals.
Demo dataTotals use only rows with Row status OK; rows in Review are counted but left out.
Prints as three blocks: totals and people, the retainers, and the term end list.
Demo dataPart-time staff, freelancers, new starters and leavers are handled with hours per week and start and end dates.
Public holidays come off everyone's working days.
Demo dataSetup, every field, the projection and rollover rules in words, and what the planner does not do.
Read it in the workbook, or print it.
One ZIP file (about 815 KB), delivered by Payhip straight after payment.
| File | What it is | Size |
|---|---|---|
| xlsxretainer- |
The Excel workbook for your own data | 557 KB |
| xlsxretainer- |
The same workbook filled with demo retainers, people and hours | 560 KB |
| htmlSTART- |
Open this first: what each file is and where to begin | 10 KB |
| mdquick- |
Setup steps and how to read the result | 8 KB |
| mdmetric- |
Every field and calculation defined | 30 KB |
| mdsupport- |
What is tested, what isn't, and how to ask for help | 7 KB |
| mdlicense. |
The license terms for both tiers | 3 KB |
| mdrelease- |
What is in this version, and where the settings went | 10 KB |
| mdmoney- |
How to ask for a refund within 30 days | 1 KB |
| txtMANIFEST- |
Checksums to verify your download | 1 KB |
04Setup
Type your settings on Setup: your business name, and a check of the currency. The first month and the theme have defaults.
About 1 minute.List your team with hours per week and the share that can go to client work, plus your public holidays.
About 2 minutes.Add your retainers one row each: included hours, start date, status and who delivers it.
About 1 minute per retainer.Log this month's hours on the Hours Log, one row per retainer, then read the Dashboard. At its top, leave Hours counted up to blank to use today.
About 30 seconds per row.Estimate: a studio with 5 people and 10 retainers takes about 25 minutes the first time, then about 10 minutes a month.
05Worked example
Fictional example
A fictional five-person studio checks its retainers on Friday 14 August, 10 of 21 working days into the month. Six retainers are active, with 158.5 hours available and 84.5 used. At the pace so far, three will run out or are already over. The Aurora Dental SEO retainer has used 22 of its 36 hours and is on course for 46.2, so it runs out around 24 August, with 10.2 hours (US$1,224 at US$120 an hour) to raise with the client. For September the team has 148.6 client-work hours to spare, but Dev is 3.6 hours overbooked while Theo, who starts on 14 September, has 75.2 free. The studio moves the 12-hour Greenfield SaaS support retainer from Dev to Theo.
| Hours available | 158.5 |
|---|---|
| Hours used by 14 August | 84.5 |
| Projected at month end | 180.75 |
| Projected hours left | −22.25 |
| Included + rolled over | 30 + 6 = 36 h |
|---|---|
| Used by 14 August | 22 h |
| Projected at month end | 46.2 h |
| Overage to raise at US$120 an hour | US$1,224 |
The studio, its people and its clients are fictional. The figures are the data 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 | 37/41 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 run on temporary copies: every calculated value against an independent calculation, checks, validation, protection, clearing, theme, print on Letter and A4, 5,000-row capacity. Not run: 4 checks that need the Excel interface, a system setting or a person. Not applicable, so not counted: 3.17 (the exchange-rate check; this planner uses one currency). |
| Excel 365, Mac desktop | Not yet tested | — | — | — | Not yet tested. |
| Excel for the web | Not yet tested | — | — | — | Not yet tested. No macros are used; editing unlocked cells on protected sheets must be checked there. |
| Google Sheets (native edition) | Not yet tested | — | — | — | Not yet tested. The Google Sheets edition is free for every buyer when it ships. The worked example's Dashboard figures matched in a Google Sheets spot check of the build file on 1 Oct 2026; data entry, clearing the sample data, scenarios, charts and protection are not yet tested. |
| 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
No. Export hours by client and project from your time tracker and type or paste them into the Hours Log. One row per retainer per month is enough; update the number as the month goes on.
It takes the hours used so far, divides them by the working days gone, and carries the same pace over the working days left, skipping weekends and the public holidays you list. The run-out date is the working day the projection reaches the hours available. In the first three working days of a month it shows Too early instead of guessing.
The first or last month is prorated by calendar days, to the nearest half hour, and the pace only counts the working days the retainer actually runs.
Choose a rule for each retainer: none, next month only, or carry forward, with an optional cap. The planner shows the rollover the rule suggests, and you log the hours you agreed with the client. Contracts differ, so it never carries hours forward on its own.
Yes. Mark the retainer as Value and its hours are treated as a guide: you see the projected hours over, but no overage amount.
Yes, by copy and paste. The Hours Log's first four columns match the tracker's Work Log, so you paste its rows and delivery hours straight in. Rows that don't match a retainer are flagged for review.
It is a free update, delivered through Payhip. The settings moved from Start Here to a new Setup sheet, and Hours counted up to moved to 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.
Yes. The Google Sheets edition is free for every buyer when it ships, built from the same specification with the same sheets and checks. Its copy link comes through Payhip when it is ready. Until then, the download holds the Excel files. The tested-on table shows which platforms have been tested.
Yes, if they all work for the one business that bought it. A separate business, including a client or a related company, needs its own license. Agencies that keep working copies for up to 5 client businesses they manage need Agency/Team. It 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. The planner has no Agency/Team price of its own.
Yes, for your own business. Keep an untouched copy first. Changes to any cell that isn't yellow can stop the checks working, and support is easiest to give on the original file.
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.