Retainer Burn Tracker Template
A retainer burn tracker template shows, for each retainer client, how many hours are contracted each month, how many have been used, whether rollover applies, and whether any overage is owed. It answers the two questions that typically go unanswered until invoice day: how much of this client's retainer is left, and did we go over?
The template
One tab or view per month. One row per retainer client. Copy the structure below into a spreadsheet, or rebuild it as an Ascend Database.
Monthly Retainer Burn — column structure
| Column | Type | Description |
|---|---|---|
| Client | Text | Client name |
| Retainer tier / package | Text | e.g. "Growth Retainer", "10-hour block", "Core SEO" |
| Period | Date | Month this row covers (e.g. May 2026) |
| Hours contracted | Number | Hours included in the retainer for this period |
| Hours banked from previous month | Number | Unused rollover from last period (0 if no rollover policy) |
| Total hours available | Formula | Hours contracted + hours banked |
| Hours used | Number | Actual hours logged against this client this period |
| Hours remaining | Formula | Total hours available − hours used |
| Overage hours | Formula | MAX(hours used − total hours available, 0) |
| Overage fee ($) | Formula | Overage hours × overage rate |
| Overage rate ($/hr) | Number | Your agreed rate for hours beyond the retainer — per client |
| Retainer fee ($) | Number | Monthly fee billed, excluding overage |
| Total invoiced ($) | Formula | Retainer fee + overage fee |
| Invoice status | Dropdown | Pending / Sent / Paid / Overdue |
| Notes | Text | Any context — holiday buffer, planned light month, etc. |
Rollover policy reference (fill in per client)
| Client | Rollover allowed? | Max rollover hours | Rollover expires after | Overage billable? | Overage rate ($/hr) |
|---|---|---|---|---|---|
| [Client A] | Yes | 5 | 1 month | Yes | [rate] |
| [Client B] | No | — | — | Yes | [rate] |
| [Client C] | Yes | Hours contracted | Never | No | — |
Monthly summary row
| Column | Value |
|---|---|
| Total contracted hours (all clients) | SUM of hours contracted |
| Total hours used | SUM of hours used |
| Total overage hours | SUM of overage hours |
| Total overage fees ($) | SUM of overage fee |
| Total retainer revenue ($) | SUM of retainer fee |
| Total invoiced ($) | SUM of total invoiced |
| Average burn rate (%) | Total hours used ÷ total contracted hours × 100 |
Per-client burndown view (for client-facing reporting)
| Week | Hours this week | Cumulative hours used | Hours remaining |
|---|---|---|---|
| Week 1 | — | — | — |
| Week 2 | — | — | — |
| Week 3 | — | — | — |
| Week 4 | — | — | — |
| Month total | — | — | — |
Share this view with the client at mid-month so they know how much retainer time remains before requesting more work.
Formulas (for spreadsheet implementations)
Total hours available = hours_contracted + hours_banked
Hours remaining = MAX(total_hours_available - hours_used, 0)
Overage hours = MAX(hours_used - total_hours_available, 0)
Overage fee = overage_hours × overage_rate
Total invoiced = retainer_fee + overage_fee
Average burn rate (%) = (hours_used / hours_contracted) × 100
Guard: if hours_contracted = 0, display "—" rather than divide by zero.
How to use this template
- Create a database with the columns above — one record per client per month.
- Populate "Hours used" from Ascend's time tracking (hours logged against each client's records).
- Use Ascend Pages to publish a burndown view the client can see without accessing your full database.
- At invoice time, the overage fee column is already calculated — pull it directly into the invoice.
The problem retainers create that projects don't
A project has a start, a scope, and an end. A retainer is open-ended by design — and that openness is where hours disappear. A client who pays for 20 hours a month tends to think of those hours as an on-demand resource. Without a retainer burn tracker, both sides lose visibility into how fast the bucket is emptying. By the time someone checks, the client is at 22 hours and the conversation about overage is a surprise rather than a prior agreement.
The tracker converts that surprise into a routine. It is most useful mid-month, not at month-end.
The columns most retainer trackers leave out
Most retainer burn tracker setups track contracted hours and hours used, and stop there. The two columns that close the gaps:
Hours banked from previous month — if your retainer agreement allows rollover, failing to carry forward unused hours means you'll over-invoice. Clients notice. Carrying them forward explicitly, capped at the rollover limit, keeps the record honest.
Overage rate (per client) — not every client has the same overage terms. Storing the rate in the same row as the usage means the overage fee calculates automatically and can't be applied inconsistently.
Mid-month check-in: the habit that stops overages becoming disputes
A retainer burn dispute is almost always a communication failure, not a maths problem. The client didn't know they were running hot; the studio didn't flag it. A quick mid-month share of the burndown view — "you have 8 of your 20 hours remaining, here's where they went" — keeps the client in the loop and gives them the choice to slow down, approve an overage, or request a retainer increase.
Done consistently, this check-in also reframes the retainer from "a flat fee" to "a managed resource." That positioning makes retainer renewals easier.
When the burn rate points at a pricing problem
A retainer burn tracker isn't only a billing tool. The average burn rate column in the monthly summary tells you something about retainer pricing. If your clients consistently burn 95–110% of contracted hours, the retainer is priced close to correctly. If most clients consistently burn 60–70%, the retainer is over-sold relative to actual work volume — a generous margin short-term but fragile when clients notice. If burn regularly exceeds 110%, the retainer fee doesn't reflect the actual engagement cost and the relationship is slowly becoming unprofitable.
For scoping new retainers, see the client project database template to track historical hours per client before quoting the next retainer.
Frequently asked questions
What is a retainer burn tracker?+
A retainer burn tracker is a record of contracted hours versus hours used for each retainer client, tracked by period. It calculates remaining hours, rollover balance, and any overage owed — giving both the agency and the client a clear view of where the retainer stands at any point in the month.
What is retainer burndown?+
Retainer burndown is the progressive consumption of a client's contracted hours over a period. A burndown view shows hours remaining week by week. When the line reaches zero before month-end, any further work is either paused or charged at an overage rate.
How do I track retainer hours?+
Log time against each client as work happens, tagged to the client or project. At any point in the month, sum the logged hours and subtract from contracted hours. A retainer burn tracker template automates that subtraction and applies rollover and overage rules consistently.
Should unused retainer hours roll over?+
That depends on your retainer terms. Rollover is a goodwill gesture for clients with variable monthly workloads. Most studios that allow it cap rollover at one month's worth of hours and set an expiry. Whatever your policy, make it explicit in writing and track it in the burn tracker.
How do I handle retainer overage?+
Notify the client before the overage happens, not after. A mid-month burndown update gives the client the chance to pause non-urgent requests, approve additional hours at the agreed rate, or request a retainer increase.
Can I use this template in Ascend?+
Yes. Build the column structure as an Ascend Database. Hours used can be populated from time tracking within Ascend, and an Ascend Page can show the client their burndown without exposing your full project database.
What's the difference between a retainer burn tracker and a project tracker?+
A retainer burn tracker manages a recurring monthly engagement — contracted hours, rollover, overage. A project tracker manages a defined scope with a start and end. Most agencies need both.
Related template
Agency Deliverables Tracker Template
Track every deliverable for each retainer client, month by month, through production and sign-off.
Connect your burn tracker to time tracking.
The effort in a retainer burn tracker is keeping the "hours used" column accurate. When time tracking lives in a separate app, that number is always a manual export. Ascend tracks time against client records, and the same data generates the invoice — so the burn figure and the invoice total come from the same source. The free tier covers one client end to end.
Start with Ascend free