Client Deposit Applied to a Final Invoice
A client deposit is cash you have already received; the final invoice is a bill for the whole job. Treat the deposit as a completed receipt and then bill the full invoice amount again, and you have counted the same money twice. The fix is structural: keep the deposit as its own transaction with its own ID, keep the invoice as its own document, and record the application of the deposit as a credit against that invoice rather than as a second receipt.
This is a bookkeeping worksheet, not a ruling on when income is recognized or whether any amount is taxable in a given period. US federal sources were checked on 2026-09-27. State rules and your individual tax treatment require separate review, and questions about how a deposit should be treated on your return belong with a CPA. The figures below are explicitly stated illustrations, not a field test or a product specification.
Why a deposit and an invoice are not two receipts
The IRS recordkeeping guidance is permissive about the shape of your system but firm about its function: you may choose any recordkeeping system suited to your business that clearly shows your income and expenses, and that system should include a summary of your business transactions, ordinarily kept in your business books (IRS: what records to keep). Supporting documents — sales slips, paid bills, invoices, receipts, deposit slips, and canceled checks — contain the information you record in those books and support the entries in your books and on your tax return.
That framing tells you what each document is for. The deposit advice and the bank credit are evidence that money moved. The final invoice is evidence of what the whole job was billed at. Neither one is a second payment. The double-counting error appears when a bookkeeper treats the deposit as one receipt and the invoice total as another, or when the invoice is quietly rewritten to show only the balance so the original billing amount disappears.
A cleaner structure keeps three things separate: the deposit transaction, the invoice document, and the application entry that links them. The application entry is not cash. It is a bookkeeping instruction saying part of this invoice has already been paid by that deposit. Publication 583 describes recordkeeping systems that include a summary of transactions and supporting documents, and it illustrates mechanics such as a check disbursements journal and a bank reconciliation (IRS Publication 583). Those are mechanics, not a prescribed chart of accounts, so the labels below are proposed worksheet choices rather than IRS categories.
Reading the inserted payment-and-refund table
The table inserted after this section is a payment-and-refund illustration, not the deposit scenario. It shows a single event: a payment of 5,000 USD recorded as transaction T-001, with the receipt and the bank entry both linked to T-001 as evidence of one transaction. A partial refund of 1,200 USD is recorded as its own transaction, T-002, with its own evidence. Net cash movement is 3,800 USD, and the table states plainly that tax treatment is not determined.
Read the arithmetic as a movement summary, not a deductible total. The positive-magnitude form is 5,000 minus 1,200 equals 3,800. Under an outflow-positive signed convention the same entries would be +5,000 and −1,200; under an inflow-positive convention both signs reverse. State your convention rather than mixing them.
The deposit-application case is a separate, explicitly hypothetical case with its own inputs, stated once here and held consistently for the rest of this article: deposit received 1,200 USD; invoice total 5,000 USD; amount applied 1,200 USD; remaining balance 3,800 USD. The arithmetic is the same shape — 5,000 minus 1,200 equals 3,800 — but the roles differ: in the table, 5,000 is the original payment and 1,200 is a refund; in the deposit case, 5,000 is the invoice total and 1,200 is the deposit applied against it. Do not carry the table's labels into the deposit case, or the deposit case's labels back into the table.
Illustrative example using explicitly stated assumptions; not a field test or product specification.
Building the deposit-to-invoice worksheet
A workable worksheet has five fields and one rule. The fields are: a stable transaction ID for the deposit; the deposit amount; the invoice reference and invoice total; the applied amount; and the remaining balance as a formula. The rule is that you never reuse an ID and never renumber. For corrections, preserve the original entry and mark it void or link an adjusting entry rather than deleting the evidence.
Start by recording the deposit when the cash is observed. Attach the deposit advice and the bank credit to the same transaction ID, because they are two pieces of evidence for one event. Do not create a second transaction for the bank line. Then record the invoice as its own document with its own reference, showing the full billed amount for the job. Finally, record the application: a line that references both the deposit ID and the invoice reference and states the amount applied.
The remaining balance is then derived. With the stated inputs — invoice total 5,000 USD, deposit applied 1,200 USD — the remaining balance is 3,800 USD. That number should appear as a formula in your ledger, not as a typed constant. If the client later disputes part of the invoice, or a second deposit arrives, the formula updates and the audit trail stays honest.
Keep the deposit date, the invoice date, and the application date distinct. They answer different questions, and collapsing them into one date makes it impossible to reconstruct the sequence later. A synthetic evidence set might use deposit-advice-T001.pdf, bank-credit-T001.csv, invoice-INV-014.pdf, and application-INV-014.csv. These are illustrative filenames, not real documents.
Where this worksheet breaks down
The first failure mode is treating the deposit as fully earned at receipt and then billing the full invoice again. The second is the opposite: leaving the deposit in a suspense account indefinitely so the invoice never shows as partially satisfied. Both distort the picture, and both are easy to spot if the deposit ID and the invoice reference are required fields on the application line.
The third failure mode is a deposit that is refundable or held against future work. If the engagement never proceeds, the deposit may need to be returned, and the return is its own transaction with its own evidence — not a silent edit of the original deposit amount. Keep the original deposit intact and record the return separately, exactly as you would record a partial refund. A fourth problem is a deposit applied to an invoice that is later revised: if the invoice total changes, the applied amount does not, but the remaining balance formula does. Record the revision as a new dated version rather than overwriting the original total.
Finally, watch for deposits received through a payment platform that nets fees before crediting your account. The gross deposit and the net bank credit are different numbers, and the fee is a separate item. Record the gross amount as the deposit and the fee as its own line, so the arithmetic reconciles to the bank statement.
Reconciling the worksheet to the bank
A deposit-to-invoice worksheet is only useful if it ties back to the bank. Once a month, compare the deposit transactions in your ledger against the credits on the bank statement. Every credit should have a transaction ID, and every transaction ID should have at least one supporting document. Publication 583 illustrates a bank reconciliation as part of a recordkeeping system, which is the same discipline applied at a smaller scale (IRS Publication 583).
When a credit appears that you cannot match, leave it unmatched rather than assigning it by guesswork. A credit that shares a date and amount with an expected deposit is still not proven to be that deposit until the description or reference connects them. Keep the uncertainty visible in a follow-up item with a next review date.
In the deposit case, the bank credit should show 1,200 USD and your ledger should show the same 1,200 USD applied against the 5,000 USD invoice. If the bank shows 1,050 USD because a platform fee was deducted, you have a 150 USD difference to investigate, not a number to force. Attach the platform statement and record the fee as its own line.
The reconciliation proves that cash moved. It does not decide when an amount belongs on a return, how your accounting method handles it, or whether a prior filing needs attention. Those are treatment questions, and they require a CPA who can see your full situation. For general orientation on how these records fit into filing, see the site's tax guides, and note that this material is educational only, as described in the disclaimer.
Sources and method
- IRS: what records to keep — retrieved 2026-09-27
- IRS Publication 583: starting a business and keeping records — retrieved 2026-09-27
AI-assisted writing with automated source, calculation and editorial checks. No hands-on testing or professional certification is claimed. Check the stated assumptions before applying this guide.