Retainer Burn & Capacity Planner · Excel 365

Will this retainer's hours run out before the month does?

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.

retainer-burn-capacity-planner-v1.2.0-worked-example.xlsx Demo data
Dashboard with demo data: Hours counted up to at the top with the date used, key figures, a checks block, a Do this next line, the retainers with the least projected hours left, term end dates, and bar charts of hours left and capacity by person.
  • Yellow cells: you type. Leave every other cell to the workbook.
Open full-size image of the Dashboard sheet Watch the walkthrough (1:20)

01What it answers

Three questions, answered every month

  1. Which retainers will run out of hours before month end, and when?

    Projected hours left and a run-out date for every active retainer, at the pace so far, counted in working days.

  2. How much overage is there to bill, or to absorb?

    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.

  3. Who is overbooked next month?

    Client-work hours for each person after time off and public holidays, against the retainer and project hours already planned for them.

02Demonstration

See the actual workbook

Walkthrough, 1:20: Start Here, Setup and the Dashboard, then one demo row goes into the Hours Log, the retainer's projected run-out and overage, next month's capacity and the checks. Captioned, no sound needed.
Read what the video shows
  1. See which retainers will run out of hours, and who is overbooked next month. On screen: the Dashboard list of retainers with the least projected hours left in Aug 2026. Harbor Retail -28.5 (Over), Aurora Dental -10.2 (Runs out early, 24 Aug 2026), Greenfield SaaS -1.1 (Runs out early, 27 Aug 2026), Sample Studio 1.7 (Close to limit), Beacon Legal 4.3 (On track), Copper & Co 11.6 (Under-used). Below it, two term end dates: Beacon Legal in 17 days and Harbor Retail in 32 days.
  2. In this fictional demo, Aurora Dental runs out 24 August. The Aurora Dental row stays outlined: 36.0 hours available, 22.0 used to date, -10.2 projected hours left at month end.
  3. Yellow cells: you type. Leave every other cell to the workbook. On screen: Start Here, row 3. The key sentence and the yellow swatch, "Yellow: you type here", are outlined.
  4. White cells calculate. Grey cells hold lists and reference values. The white swatch reads "White: calculated, don't type here" and the grey swatch "Grey: lists and reference values".
  5. Start Here has nothing to type. Do this next says what to do. On screen: Start Here, row 4. Do this next is outlined. It reads "See the sample on the Dashboard, then clear the sample rows (below)." Nothing on Start Here is typed.
  6. Setup holds the settings you set once. Setup complete reads Yes when done. On screen: Setup. The first three settings are outlined: Business name (blank in the worked example, and optional), Currency USD, and First month in month lists, Jan 2026. Then Setup complete, which reads Yes, is outlined.
  7. On the Dashboard, set Hours counted up to, or leave it blank for today. On screen: the top of the Dashboard. Hours counted up to is outlined: 14 Aug 2026, with Date used, 14 Aug 2026, beside it. The note beside it says to delete the date to go back to today's date.
  8. Add the hours used so far on Hours Log, typing left to right. On screen: the Hours Log, with rows of hours used, rolled over, added, time off and project work. The next empty row, row 28, is typed cell by cell: EX-008, Aurora Dental, SEO retainer, Aug 2026, Hours used. The view then moves right to the Person, Hours, Notes and check columns.
  9. Each row checks itself. Without hours, it reads Missing hours. Dev is typed as the person. The row's Required check reads Missing hours.
  10. Type the hours, 6.0, and it reads OK. Now the row counts. 6.0 is typed in Hours, and the Required check turns OK.
  11. Aurora Dental: 22.0 of 36.0 hours used, 46.2 projected, 1,224.00 USD to bill. On screen: Retainers. Aurora Dental's SEO retainer: 36.0 hours available, 22.0 used to date, 14.0 left now, 10 of 21 working days gone. Then projected hours at month end 46.2, projected overage 10.2 hours, overage to bill 1,224.00 (USD), run-out date 24 Aug 2026, burn status Runs out early.
  12. Next month Dev is overbooked: 138.0 hours committed, headroom -3.6. On screen: Team, next month (Sep 2026). Dev: 138.0 hours committed, headroom -3.6, planned load 102.7%, Overbooked. Maya has 28.0 hours of headroom, Sara 5.0 (Full), Theo 75.2 and Lena 44.0.
  13. The status sums up ten checks. Only Sample data is flagged. On screen: the Dashboard. Status SAMPLE. Key figures: 3 retainers running out or over, -22.3 projected hours left, 1,367.00 USD projected overage to bill, 1 term ending within 30 days, 1 person overbooked, 148.6 hours of team headroom. Nine checks read OK; check 10, Sample data, reads SAMPLE with a count of 34.
  14. Ready for your own retainers? Clear the sample data in four steps. On screen: Start Here, the four steps: choose MV_Clear_Retainers in the Name Box and press Delete; do the same for MV_Clear_HoursLog and MV_Clear_Team; delete "Hours counted up to" on the Dashboard; check the Dashboard.
  15. After clearing, the status reads OK and every check count is 0. On screen: the Dashboard after the four steps. Status OK; every check count is 0 and every result OK. With "Hours counted up to" deleted, the plan month is the current month (Oct 2026 on the day this was recorded).
  16. The Guide explains every input and check. Support replies within 1 business day. On screen: the Guide sheet, setup steps with the time each takes (step 1 reads "On Setup, ..."). Then the Guide's Support section: "Email [email protected]. Support replies within 1 business day (Monday to Friday, Australian Eastern time)."
  17. Get the planner at metricvalley.com. End card: Retainer Burn & Capacity Planner, Excel 365 · Google Sheets edition when it ships · metricvalley.com, above the Dashboard key figures. One Hours Log row was removed before this video, then typed back in. Every sheet shown is the v1.1.0 worked-example file in Excel 365.

Watch it on its own page, with chapters

retainer-burn-capacity-planner-v1.2.0-worked-example.xlsx Demo data
Retainers sheet with one row per demo retainer: client, retainer name, type and included hours, then the calculated hours available, hours used, projection, run-out date and burn status. Columns in between are not shown.

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.

03What's inside

Eight sheets, one job

Demo data

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

Demo data

Setup

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

Dashboard

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

Retainers

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

Hours Log

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

Summary

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

Team

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

Guide

Setup, every field, the projection and rollover rules in words, and what the planner does not do.

Read it in the workbook, or print it.

Exactly what's in the download

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

FileWhat it isSize
xlsxretainer-burn-capacity-planner-v1.2.0-blank.xlsx The Excel workbook for your own data 557 KB
xlsxretainer-burn-capacity-planner-v1.2.0-worked-example.xlsx The same workbook filled with demo retainers, people and hours 560 KB
htmlSTART-HERE.html Open this first: what each file is and where to begin 10 KB
mdquick-start.md Setup steps and how to read the result 8 KB
mdmetric-dictionary.md Every field and calculation defined 30 KB
mdsupport-and-compatibility.md What is tested, what isn't, and how to ask for help 7 KB
mdlicense.md The license terms for both tiers 3 KB
mdrelease-notes-v1.2.0.md What is in this version, and where the settings went 10 KB
mdmoney-back-guarantee.md How to ask for a refund within 30 days 1 KB
txtMANIFEST-retainer-burn-capacity-planner-v1.2.0.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 10 minutes (estimate)

  1. 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.
  2. List your team with hours per week and the share that can go to client work, plus your public holidays.

    About 2 minutes.
  3. Add your retainers one row each: included hours, start date, status and who delivers it.

    About 1 minute per retainer.
  4. 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

Mid-August at a fictional studio

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.

August, six active retainers (fictional)
Hours available158.5
Hours used by 14 August84.5
Projected at month end180.75
Projected hours left−22.25
Aurora Dental SEO retainer, August (fictional)
Included + rolled over30 + 6 = 36 h
Used by 14 August22 h
Projected at month end46.2 h
Overage to raise at US$120 an hourUS$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

Is it right for you?

Good fit

  • Agencies, studios and consultancies that sell monthly retainers with an hours allowance
  • Owners who check hours mid-month and plan next month's staffing at month end
  • Teams that mix full-time, part-time and freelance people
  • Client Profitability Tracker users who want the hours side in the same family of files

Not a fit

  • You need time tracking. This planner takes hours you have already tracked; it does not record time.
  • You need invoicing, billing or accounting. It shows overage to bill but does not bill it.
  • You schedule people by day or by task. It plans by month.
  • You want hours to arrive automatically from time-tracking or project software.
  • You need several people editing at once with permissions or change history.

Known limitations

  1. Retainer periods are calendar months. A retainer that runs from the 15th to the 14th is not supported.
  2. Projections assume the rest of the month continues at the pace so far, counted in working days (Monday to Friday, minus the public holidays you list).
  3. Rolled-over hours are logged by you. The planner suggests the figure from your rollover rule but never carries hours forward on its own.
  4. Capacity spreads each person's weekly hours evenly over Monday to Friday, and public holidays apply to everyone, so part-time days and regional holidays are approximate.
  5. Overage rates use one currency per file. There is no currency conversion.
  6. Automated tests run in Excel 365 for Windows desktop. Excel for Mac, Excel for the web and Google Sheets are not yet tested.
  7. Excel mobile and the Google Sheets mobile apps are for viewing only, not data entry.
  8. Capacity is 1,000 Hours Log rows, 200 retainers, 50 people and 30 public holidays; 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

37/41 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

  • Every calculated value of 83 test scenarios (the worked example, the blank file, the lite file, copies with one change each, filled copies at capacity, and the Google Sheets build files opened in Excel) matched an independent calculation in Excel 365 for Windows: 700,176 values, 0 mismatches.
  • Checks forced to fail one by one, sample data cleared, the three-record example entered, prints on Letter and A4, and 5,000 Hours Log rows after adding capacity.
  • The 1.0.0 worked example's data entered into the 1.1.0 blank file gave the same figures: 6,613 values compared, 0 mismatches.
  • The 1.1.0 worked example's data entered into the 1.2.0 blank file gave the same figures: 6,614 values compared, 0 mismatches.
  • Google Sheets, Excel for Mac and Excel for the web are not yet tested.
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 — — — —

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, 37 of 41 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.17 (the exchange-rate check; this planner uses 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. It needs Excel 2021 or later, or Microsoft 365. 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, for working copies for up to 5 client businesses, 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 this planner too. The planner has no Agency/Team price of its own.
  • Support: Email support. Support replies 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

Does it connect to my time tracker?

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.

How does it work out when the hours will run out?

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.

What about retainers that start or end mid-month?

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.

How are rolled-over hours handled?

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.

Does it work for value-based retainers?

Yes. Mark the retainer as Value and its hours are treated as a guide: you see the projected hours over, but no overage amount.

Can it use hours from the Client Profitability Tracker?

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.

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

Is the Google Sheets edition included?

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.

Can my whole team use it?

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.

Can I change the workbook?

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.

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.

Retainer Burn & Capacity Planner · US$2930-day money-back guarantee. No questions asked.

Buy for US$29