How to Invoice a Deposit and Track Partial Payments Properly

The proposal is accepted, the project starts Monday, and there’s a gap between now and the invoice that nobody talks about: six weeks of work, in which you are lending the client the entire value of the job and finding out at the end whether that was a good idea.

A deposit closes that gap. Structuring it is straightforward. Recording it without corrupting your books is where most solo businesses quietly go wrong.

Start With What You Have at Risk

The right structure isn’t a matter of taste — it’s whichever one caps your exposure at a number you can survive. Here’s a $6,000 project over six weeks, four ways:

Two things stand out.

The first is how bad the default is. “Invoice on completion, Net 30” means you carry the full $6,000 for six weeks, then wait another month — and if it goes bad at week five you have lost five weeks of work and have nothing to negotiate with.

The second is that milestones beat a bigger deposit. A 30/40/30 schedule caps your exposure at $2,400 — lower than the 50/50 split — while asking the client for a smaller first cheque than 50%. Clients who flinch at “half upfront” often accept 30% without discussion, and you end up better protected. That’s the trade worth knowing.

Choosing a Structure

• Under ~$2,000, short turnaround: 50% deposit, or due on receipt on delivery for a client with payment history.
• $2,000–$10,000: 50/50 is the workhorse. Simple to explain, simple to track.
• Over ~$10,000 or longer than six weeks: milestones, tied to deliverables rather than dates, so each payment has an obvious trigger everyone agrees happened.
• Any first project with a new client: a deposit, regardless of size. It’s the cheapest credit check available — a client who won’t pay a deposit has told you something useful before you’ve done any work.
• Ongoing retainers: bill in advance for the coming month, not in arrears for the last one. Same work, and the exposure never accumulates.

Tie milestones to deliverables, not calendar dates. “On delivery of the first draft” is a fact; “at week three” is a debate about whose delay it was.

Invoicing a Deposit: Two Documents, One Total

When the deposit is a planned share of an agreed total, issue two invoices.

Deposit invoice — sent on acceptance, before work starts:

Final invoice — sent on delivery, showing the whole picture:

The credit line does real work. The client sees the full project value, sees their deposit applied, and doesn’t have to reconcile two unrelated documents. Your records show $6,000 of project revenue, not two disconnected $3,000 items — which matters the moment you want revenue by client or by project.

Three details that prevent arguments:

• Cross-reference both ways. The deposit invoice names the project total; the final invoice names the deposit invoice number and its payment date.
• Say what the deposit secures in your terms — the schedule slot, the first phase of work — and whether it’s refundable, in writing, before it’s paid.
• Don’t start work until it clears. A deposit that hasn’t arrived provides exactly the protection of no deposit.

Recording a Partial Payment: Keep Two Fields

The other case is unplanned — a client pays part of what they owe. This is where the common mistake lives.

The rule: amount invoiced and amount received are separate fields, and balance is a formula.

That single row now does four jobs at once: it records what you billed ($5,600), what you banked ($2,800), what’s still owed ($2,800), and it keeps the outstanding half ageing in your accounts receivable report — five days past its March 26 due date, in the worked quarter this invoice comes from.

Now the failure mode. Overwrite the $5,600 with $2,800 to make the row “look right”, and:

• The invoice reads as fully paid, so it drops out of your aging report entirely.
• The $2,800 still owed disappears from every outstanding total.
• Your revenue for February is understated by $2,800.
• Next month you have no idea this client ever short-paid you.

One field, four broken numbers. If your tracker doesn’t have a separate “amount received” column, that’s the column to add today.

When a Deposit Doesn’t Cover You

A deposit caps your exposure; it doesn’t eliminate it. Two cases still need watching:

The balance goes unpaid. You’re out the back half, not the whole job — better, but still a collections problem with a fixed escalation path. The 90-day ladder.

Scope grows past the deposit. If the project doubles, a 50% deposit on the original number is now 25% of the real one. Re-invoice the increase as its own line with its own deposit rather than absorbing it into the final invoice, where it becomes a surprise at exactly the wrong moment.

And a timing note worth flagging: on the cash method, income counts when you receive it, including advance payments (IRS Publication 334). A deposit taken in late December for January work generally lands in the earlier tax year. Storing the date received separately from the issue date is what lets your sheet answer that correctly instead of guessing. General information, not tax advice — confirm your own treatment.

The One-Line Change

If you take nothing else from this: add an amount received column next to your amount column, and make balance and status formulas.

That single change turns a binary paid/unpaid list into something that can hold a deposit, a milestone, a short payment and a late fee without you ever having to lie in either direction — and it’s the difference between an aging report you trust and one you quietly work around. If your terms are also part of the problem, the working-capital math on Net 30 versus due on receipt is the other half of the fix.

Featured on ReadySheetGo

Small Business Invoice & Client Manager — $17.99

Eleven tabs and 1,167 auto-calculating formulas. The Invoice Tracker holds 100 invoices with a dedicated Partial status alongside Draft / Sent / Paid / Overdue, separate amount and payment fields, and a running balance — so a part-paid invoice keeps ageing instead of disappearing. The Invoice Generator builds invoices with auto-calculated line items, tax and discount lines, which is where a deposit credit belongs on a final invoice. The AR Aging Report buckets every outstanding balance by Current / 30 / 60 / 90+ days, Recurring Invoices handles retainer billing in advance with automatic annual values, the Client Database stores default terms per client, the Revenue Dashboard returns collection rate and revenue by client, and the Tax Summary totals quarterly income against Schedule C categories.

Works in Microsoft Excel and Google Sheets.

Get the Small Business Invoice & Client Manager →

Sources: IRS Publication 334, Tax Guide for Small Business