Home / Guides / Client retainer invoices
Guide · Invoicing · Retainers
Client retainer invoices in Excel
A retainer is recurring cash with a clear period and scope — not a vague “standing offer.” Excel works well when each invoice states the month covered, fee, hours included (if any), overage rate, and amount due so bookkeepers and clients never guess.
May earn commissions. SoloDesk may earn a commission if you buy through affiliate links on this page. Recommendations are based on what we think fits the use case. See our affiliate disclosure.
Free Yellowcell invoice sample
Grab the free freelance invoice sample, then soft-path into Sole Ledger when you want retainers, expenses, and 2026 mileage in one workbook. Yellow inputs, no macros.
Retainer vs project vs hourly
| Monthly retainer | Project fee | Hourly | |
|---|---|---|---|
| Cash rhythm | Same amount each period (usually) | Milestones or one shot | Varies with hours worked |
| Invoice must show | Period dates + fee (+ hours / overage if capped) | Deliverable + fixed total | Hours × rate + period |
| Best when | Ongoing support, content, ops | Scoped one-off work | Fuzzy scope or discovery |
What every retainer invoice needs
- Service period — e.g. “Retainer · Sep 1–30, 2026” (not just “September services”)
- Fee line — flat monthly amount as quantity 1 (or prorated days if you mid-month start)
- Hours included — if the retainer is time-capped, state the cap and the overage rate on the same invoice or a linked SOW note
- Unused time policy — use-it-or-lose-it vs rollover (one sentence; match the contract)
- Amount due + due date — usually due on the 1st or Net 15; never leave the total blank
Excel patterns that stay clear
- One invoice number per period — INV-1042 for September, INV-1043 for October; do not edit last month’s PDF in place.
- Separate overage line — “Overage 3.5 hrs × $X” under the retainer fee so the flat fee stays obvious.
- Paid vs billed columns — for your books, log cash received separately from invoices sent (matters for quarterly estimates).
- Yellow inputs / gray totals — client name, period, fee, hours used; formulas for tax and amount due.
Common retainer invoice traps
- Billing “ongoing work” with no period dates
- Mixing project deliverables into the retainer fee without a change order
- Tracking hours in chat while the invoice shows only a round number
- Letting unused hours roll forever with no written cap
- Sending the same static PDF every month with yesterday’s invoice number
From free sample to kit
Yellowcell’s free invoice sample is enough to see line items and amount due. Sole Ledger adds a repeating client + period workflow plus Schedule C–style expenses and a 2026 mileage sheet — useful when retainers are your main income and you still need write-offs in one file.
Related SoloDesk guides
- Name-your-price invoicing in Excel
- Freelance invoice tools compared
- Client rate calculator in Excel
- Wave vs Excel invoice
- QuickBooks Online vs Excel invoice
Free magnets + invoice kit (Yellowcell)
Start with the free invoice sample and free downloads hub. Soft path to Sole Ledger when you want retainer-ready invoices, expenses, and mileage together — yellow inputs, no macros, no subscription.
Free invoice sample Free hub Free rate calculator Buy invoice kit