By Tim King · Updated
Retainer Overage Calculator
Monthly Retainer Invoice for Hours Over the Allowance, and Unused Hours Value
OneTask is free, with no sign-up, and built by one person.
If this tool saved you time, a coffee helps keep new ones coming.
How the Retainer Overage Calculator works
This retainer overage calculator bills the hours over a retainer. Enter the retainer fee, the hours it includes, the hours actually logged and the agreed overage rate. The calculator returns the excess hours, the overage charge, the total to invoice, and the effective rate the month worked out at once everything is counted.
Retainer overage calculator: hours over the allowance
A retainer sells a block of hours for a fixed monthly fee. Overage is the mechanism that stops the block being a ceiling on the work and a floor on the loss, and it only functions if it is stated in the agreement before the month it is first needed.
Set the overage rate above the effective retainer rate. A £4,000 retainer covering 25 hours is £160 an hour. If overage is billed at £160 too, the client has no reason to stay inside the allowance and every reason to treat the retainer as a discount on unlimited access. Pricing overage at the standard hourly rate — typically 10% to 25% above the retainer rate — restores the incentive and reflects the truth that unplanned work is more expensive to deliver than scheduled work.
Watch the effective rate, not the invoice total. The number that tells you whether the arrangement is working is the total invoice divided by hours actually worked. A retainer that looks healthy at £160 an hour becomes £127 an hour if the month runs to 31.5 hours and the overage is waived, which is the most common way a profitable retainer quietly becomes an unprofitable one. Track this figure every month; a downward trend across a quarter is a renegotiation signal long before it becomes a crisis.
Decide the rollover rule explicitly, and prefer no rollover. Allowing unused hours to carry forward sounds generous and creates a growing liability: a client who under-uses for four months and then calls in the accumulated balance during your busiest week has effectively bought priority access at a discount. The common compromises are no rollover at all, rollover capped at one month, or a partial credit. Whichever you choose, it belongs in the agreement rather than in an awkward email.
Under-use is a warning, not a win. A client consistently using half the allowance is receiving half the value they are paying for, and will notice at renewal. The healthy response is to propose work that uses the time, or to reduce the retainer to a size that gets consumed. Silently banking the fee produces a churn event with no warning.
Approve overage before it is incurred. The single practice that prevents disputes is notifying the client when logged hours pass roughly 80% of the allowance and getting written agreement before continuing. Overage delivered as a surprise on an invoice is the most reliable way to damage a retainer relationship, even when the contract plainly permits it.
Retainer overage table by hours logged
A $4,000 retainer covering 25 hours, with extra hours billed at $180.
Overage charge and total invoice for a 25-hour, $4,000 retainer
| Hours logged | Overage charge | Total to invoice | Effective rate |
|---|---|---|---|
| 25 | $0.00 | $4,000.00 | $160.00 /hr |
| 26 | $180.00 | $4,180.00 | $160.77 /hr |
| 27 | $360.00 | $4,360.00 | $161.48 /hr |
| 28 | $540.00 | $4,540.00 | $162.14 /hr |
| 29 | $720.00 | $4,720.00 | $162.76 /hr |
| 30 | $900.00 | $4,900.00 | $163.33 /hr |
| 31 | $1,080.00 | $5,080.00 | $163.87 /hr |
| 32 | $1,260.00 | $5,260.00 | $164.38 /hr |
| 33 | $1,440.00 | $5,440.00 | $164.85 /hr |
| 34 | $1,620.00 | $5,620.00 | $165.29 /hr |
| 35 | $1,800.00 | $5,800.00 | $165.71 /hr |
| 36 | $1,980.00 | $5,980.00 | $166.11 /hr |
| 37 | $2,160.00 | $6,160.00 | $166.49 /hr |
| 38 | $2,340.00 | $6,340.00 | $166.84 /hr |
| 39 | $2,520.00 | $6,520.00 | $167.18 /hr |
| 40 | $2,700.00 | $6,700.00 | $167.50 /hr |
| 41 | $2,880.00 | $6,880.00 | $167.80 /hr |
| 42 | $3,060.00 | $7,060.00 | $168.10 /hr |
| 43 | $3,240.00 | $7,240.00 | $168.37 /hr |
| 44 | $3,420.00 | $7,420.00 | $168.64 /hr |
| 45 | $3,600.00 | $7,600.00 | $168.89 /hr |
| 46 | $3,780.00 | $7,780.00 | $169.13 /hr |
| 47 | $3,960.00 | $7,960.00 | $169.36 /hr |
| 48 | $4,140.00 | $8,140.00 | $169.58 /hr |
| 49 | $4,320.00 | $8,320.00 | $169.80 /hr |
Retainer overage formula and worked examples
The formula: excess hours = hours logged − hours included (zero if negative); overage = excess × overage rate; total invoice = retainer + overage; effective rate = total ÷ hours logged.
First example. a £3,000 retainer covers 30 hours and 36 were logged at an overage rate of £110. Excess is 6 hours, overage £660, invoice £3,660 and the effective rate £101.67.
Second example. if only 24 hours were logged, there is no overage, the invoice stays £3,000 and the effective rate is £125 — the client paid for six hours not used.
How many hours over before it is worth renegotiating? If overage runs above 15–20% of the included hours for three months in a row, the retainer is too small.
FAQ
What should I charge for retainer overage hours?
Above the effective retainer rate — usually your standard hourly rate, which typically sits 10% to 25% higher. Charging the same rate as the retainer removes any incentive for the client to stay within the allowance.
How do I calculate the effective hourly rate on a retainer?
Divide the total invoiced, including overage, by the hours actually worked. This is the number that reveals whether the retainer is still profitable, and it falls quickly when overage is regularly absorbed rather than billed.
Should unused retainer hours roll over to the next month?
Usually not, or only with a cap of one month. Uncapped rollover builds a liability that a client can call in at the worst possible moment, effectively buying priority access at a discount.
What if the client consistently uses far fewer hours than they pay for?
Treat it as a renewal risk. Either propose additional work that consumes the time, or reduce the retainer to a size that is actually used. Clients who notice they are paying for nothing tend to cancel rather than negotiate.
See also: all Rates & Pricing tools, Profit & Growth, Invoicing & Payments.
Related tools
Blended Rate Calculator
One weighted hourly rate across a mixed team of roles.
Overhead Rate Calculator
Annual overhead spread across the hours you can actually bill.
Milestone Payment Splitter
Split a project fee into deposit and milestone amounts.
Freelance Time-Off Surcharge
The rate uplift that pays for your unpaid time off.
Meeting Cost Ticker
Watch what a meeting costs while it is happening.