THE SHORT ANSWER
A net-proceeds worksheet separates gross recovery from fees, expenses, liens or reimbursement obligations, and amounts held back. Each entry needs a source and a confirmed or estimated status. The result is not reliable until counsel resolves the actual agreement and obligations.
Read the full explanation and source links below.A number quoted in a news story or negotiation is not necessarily the amount a family can spend. A useful accounting discussion distinguishes money promised, money received, deductions, and funds actually distributable. This guide describes a worksheet structure without inventing a standard deduction rate or a typical recovery. See settlement amounts and uncertainty for why published averages are often misleading.
What goes at the top of the worksheet?
Identify the specific recovery, the date of the estimate, the party or proceeding involved, and the document supporting the gross amount. Mark whether the amount is proposed, agreed, funded, or distributed. Do not combine several possible claims into one total without labeling which ones have actually reached a relevant stage.
Add the person preparing the worksheet and the intended purpose. A planning estimate is not a final distribution statement. If more than one lawyer or institution has records, identify which source controls each entry so competing spreadsheets do not silently become conflicting versions of the facts.
How should deductions be separated?
Use individual rows for the attorney fee, documented expenses, asserted liens or reimbursement obligations, and any proposed reserve. Leave a field for the governing agreement or other basis, the current amount, whether it is disputed, and the person responsible for resolving it. A blank amount means unresolved, not zero.
Ask counsel about the order of calculations. This publication does not decide how a particular agreement operates. Review the expense-ledger guide if you need help distinguishing an actual expense from an estimate or understanding the documentation behind a charge.
What can a simple example illustrate?
Suppose a planning sheet lists a hypothetical gross amount as G, an agreed fee calculation as F, documented expenses as E, and other resolved obligations as O. A provisional arithmetic expression might be G minus F minus E minus O. That expression is not a legal rule and does not settle whether each category is owed or how F is calculated.
If a reserve is necessary or an obligation remains uncertain, the distributable amount may require another line. The value of using letters instead of a dramatic sample payout is that the worksheet remains focused on the actual documents rather than anchoring expectations to an invented case.
Where do tax questions belong?
Do not label the entire recovery “tax free” based on the diagnosis. The IRS discusses different treatment for settlement components and emphasizes the nature of the payment. Take the agreement and allocation information to a qualified tax professional. 1
Use a separate tax-review field identifying the adviser and outstanding questions. It is not a substitute for a calculated tax liability, and it should not be silently counted twice if a related amount already appears elsewhere. Our tax-record organizer focuses on the supporting documents.
How do you close the worksheet responsibly?
Compare the final statement with the most recent estimate and ask for explanations of material changes. Confirm which amounts were received, paid, held, or remain outstanding. Retain the source documents and the date of the final explanation, especially if proceeds arrive through more than one process.
Avoid borrowing, spending, or promising money solely on an early projection. This worksheet is a conversation aid, not financial planning, tax advice, or a guarantee of timing. Individual agreements, obligations, disputes, and administrative steps must be reviewed by the professionals responsible for the actual matter.
Prepared September 28, 2026 using the linked sources. These are content dates, not professional-review dates. Rules, services, and individual circumstances can change. This is general information, not professional advice. Sources do not imply affiliation or endorsement.
Suggest a correction