Free tool for agencies on monthly retainers
Retainer hours burn rate calculator
Projected hours = hours used ÷ day of month × days in month. In the example, a $4,000 retainer for 40 hours with 24 hours used on day 15 of 30 runs at 1.6 hours a day, so the month ends at 48 hours, 120% of the hours sold. That is 8 hours over, worth $800 at the $100 rate per hour sold, and the status is Red.
Last updated 2026-11-12.
- Projected hours at month end
- ( of hours sold)
- Status
- Over (+) or under (−) in hours
- Over (+) or under (−) in USD
- Pace so far
- per day
- Used so far
- of hours sold
- Hours left in the retainer
- Rate per hour sold (fee ÷ hours sold)
Check the inputs: fee and hours used not negative, hours sold above 0, days in month 28 to 31, day of month between 1 and the days in the month.
Take it with you
Example scenarios
Three cases, low, middle and high, worked through the same formulas as the calculator above. Put your own numbers in the calculator to see yours.
| Scenario | Inputs | Projected month-end hours | Projected % of hours sold | Over (+) / under (−) in USD | Status |
|---|---|---|---|---|---|
| Low | $2,500 for 25 h, 10 h used on day 18 of 31 | 17.2 h | 68.9% | -$778 | Amber |
| Typical | $4,000 for 40 h, 24 h used on day 15 of 30 | 48.0 h | 120.0% | $800 | Red |
| High | $3,000 for 30 h, 26 h used on day 25 of 31 | 32.2 h | 107.5% | $224 | Amber |
Method: Pace = hours used ÷ day of month; projected hours = pace × days in month; projected % = projected ÷ hours sold; rate = fee ÷ hours sold; over/under = (projected − hours sold), in USD × rate. Green 75–100%, Amber above 100% up to 110% or below 75%, Red above 110% or hours sold already used before the last day. Figures checked against the same formulas on 2026-11-12.
How the calculator works
Enter the monthly fee, the hours sold, the hours your team has logged so far, today's day of the month (count today as a full day) and the days in the month. The calculator divides the hours used by the day to get the pace, multiplies the pace by the days in the month to project where the month ends, and compares that with the hours sold.
The rate per hour sold is fee ÷ hours sold; the over or under in USD is the projected difference in hours times that rate. The status follows one rule: Green when the projection lands at 75% to 100% of the hours sold; Amber above 100% up to 110% (scope creep starting) or below 75% (the client may feel under-served); Red above 110%, or when the hours sold are already used up before the last day.
Worked example
A client pays $4,000 for 40 hours a month, so each hour sold is worth $100. On day 15 of 30 the team has logged 24 hours, 60% of the hours sold. The pace is 24 ÷ 15 = 1.6 hours a day, and 1.6 × 30 = 48 hours at month end: 120% of the hours sold, 8 hours or $800 over. Above 110% means Red.
Three more retainers with the same rule: $3,000 for 30 hours with 26 hours used on day 25 of 31 projects 32.2 hours (107.5%), $224 over, Amber. $6,000 for 60 hours with 30 hours used on day 16 of 30 projects 56.3 hours (93.8%), $375 under, Green. $2,500 for 25 hours with 10 hours used on day 18 of 31 projects 17.2 hours (68.9%), $778 under, Amber.
Why a straight-line projection, and when to check
It is the simplest honest forecast: if the team keeps logging hours at today's pace, this is where the month ends. Front-loaded work, such as a launch in the first week, makes the projection look worse early; check again mid-month. The projection is only as good as the logged hours, so make sure everyone has logged last week's time before you read it.
What this tool does not do
It checks one retainer for the current month and forgets everything when you close the page. It does not work out your margin after the month (the agency retainer profitability calculator does) or compare a retainer with hourly billing (the retainer vs hourly calculator does), and it does not know your contract's overage or rollover terms. To see every client at once, the Retainersdesk template linked below shows which retainer is over, close or on track this month.
Questions
How do I know if a retainer will run over this month?
Divide the hours used by today's day of the month and multiply by the days in the month. 24 hours by day 15 of 30 projects 48 hours, 8 over a 40-hour retainer.
When is a retainer Amber or Red?
Amber when the projection is above 100% up to 110% of the hours sold, or below 75%. Red above 110%, or when the hours sold are used up before the last day.
Does this page store my client numbers?
No. The math runs in your browser; nothing is sent or saved.
Made by Bardach Technologies. We also make Retainersdesk, a separate workspace template for agencies that runs in Notion and shows which client retainer is over, close or on track this month and what is due in the next 7 days (USD 67.99, one-time purchase on Gumroad). Retainersdesk keeps the hours of all clients in one place; this calculator checks one retainer at a time and saves nothing. This calculator is free and needs no sign-up; nothing is charged on this page. Get Retainersdesk on Gumroad (USD 67.99)