Editorial responsibility: JusticeFinder. Source research checked September 30, 2026.
Open the tracker safely
An injury claim can leave you with bills, receipts, insurance statements, missed pay, and questions about costs that have not happened yet. A useful personal injury expense tracker keeps each amount connected to its source and shows what has changed since your last review.
Use this guide with the spreadsheet to build that record. You will separate medical charges from payments, document income loss, organize other expenses, and prepare a clear handoff. The running totals organize information; they do not determine what an insurer must pay or what your claim is worth.
Do not enter personal, medical, financial, or claim information in the public master spreadsheet or embedded preview. Make your own copy first and verify who can access it.
Choose “Make a Copy in Google Sheets,” save it in an account and folder you control, and give it a recognizable name. In your copy, open Share and check General access. Set it to Restricted, then review every listed person and any folder-related access before adding information. Restricted access still permits people who have been granted access to open the file. Google explains these controls in its file-sharing guidance.
Review every worksheet and replace or clear prefilled entries in your own copy before using totals. Preserve headings and formulas where appropriate; do not assume prefilled names or amounts describe your situation. Avoid copying comments unnecessarily. If you cannot confirm that your copy is private, use a separate private file instead.
The sections below describe information worth keeping. If a field is missing from your copy, add it carefully or maintain a separate private ledger. Check calculations against your records after making changes.
Set up the record before entering amounts
Start with the incident date, a short case label, and the date through which the tracker is current. Use a claim number only when necessary. Full Social Security numbers, payment-card numbers, and portal passwords do not belong here.
Keep five kinds of information distinguishable:
- Expenses already incurred, including unpaid bills
- Payments, adjustments, refunds, and current balances
- Work and income changes that have already occurred
- Future costs or earnings projections awaiting support or review
- Nonfinancial effects recorded in a dated journal
Give every expense a unique ID, such as MED-001 or TRAVEL-003. Record the service or loss date separately from the invoice date and payment date. Add the provider or payee, description, category, evidence reference, status, and last-checked date.
Use plain status labels: “statement received,” “payment posted,” “disputed,” “record requested,” or “estimate only.” A blank amount can mean unknown. A zero should mean you have a reason to record zero. Put unresolved questions in a notes field rather than silently filling gaps with assumptions.
Keep medical bills, EOBs, and balances distinct
A provider's bill lists charges and requests payment. An explanation of benefits, or EOB, describes how the health plan processed a claim. A receipt or account ledger helps establish what was actually paid. CMS cautions that an EOB is not a bill and may not reflect payments you have already made. Compare all three before recording an outstanding balance. CMS guide to reading an EOB
Keep separate columns for:
- Gross billed: the provider's original charge
- Adjustments: documented reductions, corrections, or write-offs
- Paid by health plan or another payer: payments identified by source
- Paid by you: amounts supported by receipts or payment records
- Outstanding balance: the provider's current unpaid amount, with an as-of date
Also retain the EOB's allowed amount and patient responsibility when available. Patient responsibility can include an amount you already paid, so it should not automatically become a new expense.
A bookkeeping example
Suppose a bill shows $1,000 in charges, a $400 adjustment, a $480 insurer payment, and an $80 payment by you. The remaining balance is $40. The $1,000 charge, $560 in total payments, and $40 balance describe the same service from different angles. Adding all three would inflate the ledger.
This is an invented arithmetic example, not a typical medical charge or a damages calculation. Actual accounts may include reversals, refunds, secondary insurance, or disputed charges. When records disagree, flag the discrepancy and request clarification rather than forcing the numbers to match.
The amount documented in a ledger is not necessarily the amount legally recoverable. For example, California's medical-expense instruction and accompanying authorities distinguish reasonable medical costs from billed charges and address amounts paid or still owed. Your state's rules and the type of claim need separate review. California CACI 3903A
Connect each entry to records you can find
Store original documents in an organized private folder, then put a document ID or restricted link in the tracker. A reference such as “MED-001-B, provider statement, September 18, page 2” is more useful than “bill in email.”
For medical care, collect the itemized bill, relevant treatment record, EOB, receipts, and later account statements. A billing record supports a charge; the treatment record supplies different information about the care. Request missing records explicitly rather than assuming one download contains everything.
HIPAA generally gives individuals access to medical, billing, payment, and claims records held in designated record sets by covered entities, subject to exceptions. HHS describes a 30-calendar-day response period and one permitted extension of up to 30 additional days with timely written notice. Record the request date, requested date range, response, and missing items. HHS guidance on access to health information
Maintain an evidence index with the document's ID, date, source, location, and related expense IDs. Save revised statements without treating them as new treatment. Note which version supplies the current balance, while retaining earlier versions for the history.
Document missed work with more than a total
For each absence or reduced shift, record the scheduled hours, hours actually worked, hours missed, pay rate, and reason. Keep pay periods separate from calendar months so totals can be checked against payroll.
Useful supporting records include pay stubs from before and after the incident, work schedules, timesheets, employer confirmation, and medical work restrictions where relevant. Record overtime, commissions, bonuses, or tips separately with the records and assumptions supporting them. Avoid assuming that a possible extra shift was guaranteed income.
Track sick leave, vacation time, disability benefits, and other wage replacement in separate fields. Do not automatically count the same period as both unpaid wages and paid leave. Preserve the facts so a reviewer can decide how applicable rules treat them.
For self-employment, keep canceled-job records, invoices, prior earnings records, business expenses, and any replacement-labor payments. Lost sales and lost personal earnings are different measures. Explain the method instead of copying gross business revenue into a lost-wages total.
Legal calculations can be jurisdiction-specific. New Jersey's model lost-earnings charge, for example, addresses net income and taxes. Keep both gross-pay information and available deductions rather than assuming one nationwide method. New Jersey Model Civil Jury Charge 8.11C
For a deeper explanation of employment evidence, see JusticeFinder's lost-wage claims guide.
Record property damage and practical expenses separately
Use a property entry for each damaged item. Identify the item, ownership, condition before the incident, photographs, repair estimates, completed repairs, and any payment already received. Keep estimates and paid invoices distinguishable. Two estimates for repairing one car are alternative evidence, not two separate repair losses.
Do not automatically add repair cost, replacement cost, and a full pre-incident value for the same item. The measure of property damages depends on the circumstances and applicable law. California's property-damage instruction, for example, addresses repair costs, changes in value, and limits on combinations of those amounts. California CACI 3903J
For transportation, parking, medical supplies, or paid help, record the date, purpose, amount, payee, and receipt. If you record mileage, retain the route and miles separately from any proposed reimbursement rate. A tax mileage rate is not automatically the rate for an injury claim.
Recording an expense preserves it for review; it does not establish entitlement to reimbursement. Note why you believe it relates to the incident and whether someone already reimbursed it.
Keep a factual journal of nonfinancial effects
Use short, dated entries describing what you actually experienced: interrupted sleep, difficulty using stairs, changed household tasks, canceled activities, or help needed. Explain the specific task, duration, and effect. Include improvement and days with fewer limitations as accurately as difficult days.
An entry such as “Stopped cooking after ten minutes of standing; someone else finished dinner” communicates more than repeating “bad pain.” If you record a pain score, add context. Keep your observations separate from a clinician's diagnosis, and identify the source of anything someone else told you.
Do not assign a daily dollar value or multiply your bills merely because a spreadsheet has room for a number. California's noneconomic-damages instruction, for example, tells jurors to evaluate the evidence without a fixed valuation standard. A journal helps describe the harm; it does not supply a guaranteed multiplier or payout. California CACI 3905A
Before sharing the journal, ask your attorney how it should be handled. Keep originals and date later corrections rather than rewriting earlier entries as though they were contemporaneous.
Keep future losses outside past-expense totals
A possible future procedure, reduced work schedule, or course of therapy belongs in a separate section. Record what is proposed, who recommended it, the supporting document, expected timing, quantity, cost source, and unresolved assumptions. Distinguish a recommendation from something merely discussed as a possibility.
Label every amount as an estimate and state the date it was prepared. Avoid choosing an interest rate, inflation rate, or lifetime duration without qualified input. California's future-medical instruction illustrates why support matters: it addresses reasonably necessary care the person is reasonably certain to need. California CACI 3903A
When care actually occurs, create the incurred-expense entry and update the future schedule so the same treatment is not counted in both places. Preserve the earlier projection with its date for comparison. Use the tracker to show what needs professional review, not to predict medical needs.
Reconcile the tracker before trusting the summary
Choose a regular review time and work through the underlying rows before looking at a dashboard:
- Match identities. Check provider, service date, invoice number, and expense ID for duplicates.
- Match documents. Connect bills, EOBs, and payments to the same service. A later statement may repeat an earlier charge.
- Update balances. Record posted payments, adjustments, and refunds, with the date checked.
- Check categories. A pharmacy copayment already included in a medical subtotal should not appear again as an additional expense.
- Check time periods. Keep incurred losses and future projections separate; reconcile overlapping wage-loss periods.
- Check formulas. Inspect included ranges, hidden or filtered rows, and added entries. Compare several results with a manual calculation.
If a separate medical ledger feeds this master tracker, summarize it once and reference that ledger. Do not also add all its underlying bills to the same master total. Mark replaced or duplicate entries as excluded with an explanation rather than losing the audit trail.
Present separate summaries for documented charges, payments, outstanding balances, past income loss, other expenses, and future estimates. Avoid a single unlabeled “total damages” number that blends incompatible amounts.
Prepare a limited and useful handoff
Before sharing, record an as-of date and prepare a short cover note: what is included, what remains missing, which figures are disputed, and which estimates need review. Confirm that referenced files exist and that the intended recipient can open only the material you mean to share.
Keep your working originals. Create a separate review copy or export when appropriate, check hidden sheets and comments, and remove unnecessary identifiers from the shared version. Use your attorney's approved transfer method. Review the intended scope before sending medical or financial records to an insurer or anyone else.
Flag potential reimbursement issues separately from expenses. Medicare, for example, may make conditional payments for injury-related care and seek repayment following a settlement or other payment. Its recovery process distinguishes interim conditional-payment information from the later formal demand. Do not treat an early figure as a final amount or add reimbursement again as a new medical service. CMS Medicare recovery process
A well-kept tracker makes missing evidence and conflicting amounts easier to resolve. Get state-specific legal guidance before turning its figures into a demand, signing a release, or assuming an expense is recoverable. Organizing this file does not replace checking claim deadlines.