Free · Works in FLYNT Sheets

Billable Hours & Retainer Calculator Template

A real spreadsheet for turning an hourly rate into a retainer number, not a guess. Enter your hourly rate and estimated monthly hours for a client, and it calculates the straight monthly fee, then applies a retainer discount to arrive at a discounted retainer fee and projected annual revenue — the actual math behind offering a client a retainer instead of hourly billing.

Hourly Rate$175.00
Estimated Monthly Hours20
Estimated Monthly Fee$3,500.00
Retainer Discount (10%)10%
Discounted Retainer Fee$3,150.00
Annual Retainer Revenue$37,800.00

Green rows calculate automatically from the values above them — change any number in FLYNT Sheets and they update.

Who it's for

Consultants, agencies, and freelance professionals deciding what to charge for a retainer, or explaining to a prospective client why a retainer costs what it does.

Key features

  • Hourly rate and estimated monthly hours fields
  • Straight monthly fee calculated automatically
  • Adjustable retainer discount percentage
  • Discounted retainer fee calculated automatically
  • Projected annual retainer revenue calculated automatically
  • Exports to a real .xlsx file

How to use it

  1. Click "Use this template" to open it in FLYNT Sheets
  2. Enter your real hourly rate
  3. Enter the estimated monthly hours for this client
  4. Adjust the retainer discount to what you're actually willing to offer
  5. Review the discounted retainer fee and annual revenue before quoting a client

What's included

  • Hourly rate, monthly hours, and retainer discount fields with example numbers
  • Monthly fee, discounted retainer fee, and annual retainer revenue formulas already wired up

Common use cases

  • Quoting a new retainer client a specific monthly number, not a rough estimate
  • Deciding how much discount a retainer can actually afford to offer against hourly billing
  • Projecting annual revenue from a client before committing to an ongoing retainer

Frequently asked questions

How much of a discount should a retainer offer?
It varies by practice, but many consultants offer roughly 10-20% off the hourly-equivalent rate in exchange for the predictability of guaranteed monthly hours. This template lets you see the real dollar impact of whatever percentage you're considering, rather than picking a number blind.
Can I use this for more than one client at once?
Yes — it's a real spreadsheet. Duplicate the sheet per client to compare retainer terms side by side.
Is this free to use?
Yes, on FLYNT's free plan — no credit card required.