Home / Guides / Deposit vs retainer invoice
Guide · Invoicing · Deposit vs retainer
Deposit vs retainer invoice in Excel
A deposit locks a project start; a retainer keeps recurring work funded. Mixing the labels on an Excel invoice confuses clients and your books — so name the line, state the period or project, and show one clear amount due.
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, practice deposit and retainer line wording, then soft-path into Sole Ledger when you want invoices, expenses, and 2026 mileage in one workbook. Yellow inputs, no macros.
Deposit vs retainer — same PDF, different job
| Project deposit | Monthly retainer | |
|---|---|---|
| Purpose | Reserve the start / cover early work | Ongoing access or capped hours each period |
| Cash rhythm | One-time (or milestone) before / during a project | Same fee each period (usually) |
| Invoice must show | Project name + “Deposit X%” or fixed deposit + remaining balance note | Service period dates + fee (+ hours / overage if capped) |
| Best when | Scoped one-offs, launches, builds | Support, content, ops, advisory |
Do not label a monthly fee as a “deposit” or a project kickoff payment as a “retainer” unless your contract uses those words the same way. Clients read the line item; vague synonyms create refund and scope fights later.
What a deposit invoice needs
- Project / deliverable name — not only “services”
- Deposit line — e.g. “Deposit 40% of $5,000 project fee” or “Kickoff deposit — $2,000”
- Balance note — one sentence: remaining amount and when it is billed (milestone or final delivery)
- Amount due + due date — the deposit alone; do not bury remaining balance inside amount due
- Separate invoice later — final / balance invoice with a new invoice number; do not silently edit the paid deposit PDF
What a retainer invoice needs
- Service period — “Retainer · Sep 1–30, 2026”
- Fee line — flat monthly amount as quantity 1
- Hours / overage — if time-capped, state the cap and overage rate (or link the SOW)
- Unused time policy — use-it-or-lose-it vs rollover in one short line
- Amount due + due date — usually 1st of month or Net 15
Excel patterns that stay honest
- Yellow inputs / gray totals — client, project or period, deposit % or retainer fee; formulas for tax and amount due.
- One invoice number per cash event — deposit INV-1040, balance INV-1041, September retainer INV-1042.
- Never reuse a paid PDF — duplicate the template row; change the number, dates, and line labels.
- Log billed vs received — deposits and retainers both matter for quarterly estimates; cash received is not the same as invoices sent.
Common mix-up traps
- Calling every upfront payment a “retainer” when it is really a project deposit
- Putting remaining project balance on the same amount-due as the deposit without a second invoice
- Billing “ongoing retainer” with no period dates
- Rolling unused retainer hours forever with no written cap
- Editing last month’s retainer PDF in place instead of issuing a new number
Free sample vs invoice kit
Yellowcell’s free invoice sample is enough to practice deposit and retainer line wording and a clean amount due. Sole Ledger (the invoice kit) adds a repeating client workflow plus Schedule C–style expenses and a 2026 mileage sheet — useful when deposits, retainers, and write-offs live in one file.
Related SoloDesk guides
- Client retainer invoices in Excel
- Add late fees on Excel invoices
- Name-your-price invoicing in Excel
- Project fee calculator in Excel
- Freelance invoice tools compared
Free magnets + invoice kit (Yellowcell)
Start with the free invoice sample and free downloads hub. Soft path to Sole Ledger when you want deposit- and retainer-ready invoices, expenses, and mileage together — yellow inputs, no macros, no subscription.