Free Notion template
Retainer Drawdown Tracker
Hours bought, used and left, per client. Rollover and overage on the same row. On any Tuesday it tells you how many prepaid hours each client has left this month and who has gone over.
Retainer Drawdown Tracker
Hours bought, used and left, per client. Rollover and overage on the same row.
Add
Pages
- Retainers
- Hours
On file
- Start here
Retainers
| Client | Bought | Rollover | Used | Left | |
|---|---|---|---|---|---|
| The bakery on Argyle Street | 20 | 0 | 23 | −3 | Overage |
| Level 2 gym | 30 | 4 | 12 | 22 | On track |
| The courier on Bank Road | 10 | 2 | 6 | 6 | On track |
| The florist on Mill Lane | 15 | 0 | 15 | 0 | Used up |
Hours
- Route sheet, OctoberThe courier · Tue · 2 h
- Menu board photos, reprint fileThe bakery · Tue · 0.5 h
- September newsletter, draft twoLevel 2 gym · Mon · 2.5 h
Built on Ops on Paper
Left is a formula. Log hours, never type here.
The one that ran over.
"Left" is a formula. Log hours, never type there.
The home page, with four of the five sample clients. The fifth is paused and sits under its own tab.
What's on the page
You log the hours as you do the work: the client, the date, the hours. The Retainers table does the rest. Hours left is bought plus rollover minus used. Rollover is last month's unused hours, once, capped at the month's allowance, and off for clients whose agreement has none. When a client goes past zero the row says Overage, counts the hours, and puts the fee plus the overage at their rate in To invoice. Nothing is moved at month end; an entry belongs to the month of its date.
- Retainers: one row per client with Hours bought, Rollover, Hours used, Hours left, Standing, Overage and To invoice. You type the first one; the rest are formulas.
- Hours: the log, one entry per piece of work, with tabs for this week, this month and everything.
- Start here: the first three steps, the questions people ask about rollover and overage, and the watch-out on the formula columns.
Made for
A one-to-three-person agency or studio selling monthly retainers by the hour.
Not for
An agency billing on 15th-to-15th cycles, or one that needs a timer and invoicing in the same tool. This counts calendar months and leaves the invoice to you.
Questions people actually ask
What happens when a client goes over their hours?
Hours left goes below zero, Standing says Overage, and Overage counts the hours. To invoice adds them at the client's Rate. What you bill is your decision. The number is ready before you pick up the phone.
How does rollover work?
Hours unused last month carry into this month, once, up to a month's allowance. Older hours lapse. Untick Rolls over for a client whose agreement has none, like the florist. Change Hours bought on the 1st: the rollover reads the current allowance for last month too.
A job ran across the end of the month. Which month does it count in?
The month of the entry's date. Log the hours on the day you did them and nothing needs moving at month end. A job that spans the turn of the month is two entries.
Do I still need a timer?
No. Type the hours into Hours, to the half hour, on the day. If you run a timer anyway, copy the day's total across once.
Can I see dollars, not just hours?
Fee, Rate, Overage and To invoice sit on the Retainers row. To invoice is this month's fee plus the overage hours at the rate, as of today.
Hours left looks wrong. Where do I look?
It is bought plus rollover minus used this month. Open Hours, All: an entry with no Client counts for nobody, and one with no Date counts in no month.
My retainer runs from the 15th, not the 1st.
This page counts calendar months. Set Since to the day the retainer began; rollover starts the month after. A 15th-to-15th agreement needs the Agency Ops OS, where the cycle is a setting.
How do I delete the sample clients?
Open Hours, All, select all, Delete. Then Retainers, All, select all, Delete. Two select-alls; nothing else depends on them.
Get the Retainer Drawdown Tracker
One email with the duplicate link, then a note whenever the template changes. The template runs on Notion's free plan.
Also listed on the Notion Marketplace, where it duplicates with one click.