Shop / Guides / Progress billing invoice Excel
Guide · Invoicing · Progress billing
Progress billing invoice in Excel
Long projects should not wait for one giant final invoice. Progress billing splits a fixed project fee into milestones so cash arrives as work lands — Excel is enough if each PDF shows this period’s share, what was billed before, and one clear amount due now. This is invoicing layout help, not legal or contract advice.
Progress billing vs deposit vs retainer
| Progress billing | Deposit | Retainer | |
|---|---|---|---|
| Tied to | Milestones / % complete on one project fee | Kickoff before work starts | Recurring period (month / sprint) |
| Cash event | Each stage gets its own invoice number | One upfront line, then balance invoices | Same fee each period until canceled |
| Invoice shows | “Milestone 2 — 40% of project fee” + prior billed note | “Deposit — 30% of project fee” | “September retainer — design hours” |
| Best when | Multi-phase build with a locked total | You need cash before kickoff | Ongoing access, not a single deliverable |
Do not mix labels. Calling a mid-project draw a “retainer” or burying prior payments inside one edited PDF confuses clients and your own books.
What a progress invoice needs
- New invoice number — one cash event per PDF; never overwrite a paid milestone
- Project + total fee — locked project fee so % milestones add up
- This period’s milestone — short description + % or fixed amount
- Prior billed (optional note) — “Previously invoiced: $X” so the remaining balance is obvious
- Amount due + due date — only this milestone’s total on this PDF
- Acceptance trigger — “Due on design approval” or a calendar date — pick one
Excel workflow that stays clean
- Lock the project fee — from hours × rate + contingency before you publish milestone %.
- Yellow inputs / gray totals — type only in yellow; leave gray formula cells alone.
- Duplicate the template — INV-2001 start, INV-2002 mid, INV-2003 final — freeze each after send.
- Track billed vs received — progress payments still feed quarterly estimates when cash lands.
- Print to PDF — File → Print → Save as PDF before you email; keep a blank master copy.
Common progress-billing traps
- Milestones that sum to more (or less) than the agreed project fee
- Sending work for the next stage before the prior invoice is paid
- Editing the original deposit PDF instead of issuing a new number
- Vague lines like “progress payment” with no milestone name
- Treating contingency as a free extra stage instead of risk already inside the fee
Free sample vs $19 kit
| Free invoice sample | $19 invoice kit | |
|---|---|---|
| Client invoice layout | Yes | Yes |
| Room for milestone / prior billed lines | Yes (edit text) | Yes |
| Expense log + 2026 mileage | No | Included |
| One-time download | Yes | Yes |
If you only need to practice milestone wording and a clean amount due, start free. If progress draws, 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 milestone %, acceptance triggers, and payment terms to your written agreement.