Shop / Guides / Deposit vs retainer invoice Excel
Guide · Invoicing · Deposit vs retainer
Deposit vs retainer invoice in Excel
A deposit reserves a project start; a retainer funds ongoing work each period. Mixing the labels on an Excel invoice confuses clients and your books — so name the line, state the project or period, and show one clear amount due. This is invoicing layout help, not legal or contract advice.
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 written agreement uses those words the same way. Clients read the line item.
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 — 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
What a retainer invoice needs
- Service period — e.g. “Retainer · Sep 1–30, 2026”
- Fee line — flat monthly amount as quantity 1
- Hours / overage — if time-capped, state the cap and overage rate
- 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 — type only in yellow; leave gray formula cells alone.
- One invoice number per cash event — deposit INV-1040, balance INV-1041, September retainer INV-1042.
- Never reuse a paid PDF — duplicate the template; change the number, dates, and line labels.
- Log billed vs received — deposits and retainers both matter for quarterly estimates.
- Print to PDF — File → Print → Save as PDF before you email; keep a blank master copy.
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 $19 kit
| Free invoice sample | $19 invoice kit | |
|---|---|---|
| Client invoice layout | Yes | Yes |
| Room for deposit / retainer / balance lines | Yes (edit text) | Yes |
| Expense log + 2026 mileage | No | Included |
| One-time download | Yes | Yes |
If you only need to practice deposit and retainer wording and a clean amount due, start free. If deposits, retainers, receipts, and miles live in one workflow, one workbook is less chaos than three files.
Record-keeping and template tips only — not legal, tax, or collections advice. Match deposit %, period fees, and rollover rules to your written agreement.