Personal Injury Claim Expense Tracker Spreadsheet

After an accident — whether a car collision, a slip and fall, a workplace injury, or any incident caused by someone else’s negligence — the last thing on your mind is record-keeping. But what you document in the days and weeks following an injury directly determines how much compensation you recover. Insurance companies and courts do not award damages based on how much you suffered. They award damages based on how much you can prove you lost.

The gap between actual losses and documented losses is where claimants leave money on the table. A medical bill that was paid but not recorded, a day of lost wages that was not calculated, mileage to 30 physical therapy appointments that was never tracked, out-of-pocket expenses for prescription medication co-pays — each undocumented cost is money that the insurance company will never voluntarily include in a settlement offer.

This spreadsheet creates a comprehensive, organised record of every expense and loss associated with your personal injury claim. It is the document you hand to your attorney. It is the evidence you present to the insurance adjuster. It is the foundation on which your claim’s value is calculated.

Disclaimer: This tracker is provided as an organisational tool for informational and educational purposes only. It does not constitute legal, medical, or insurance advice. Personal injury claims are complex and fact-specific. Consult a qualified personal injury attorney for guidance on your specific situation. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why Documentation Determines Your Claim’s Value#

Insurance adjusters evaluate personal injury claims using a straightforward framework: documented economic damages (medical bills, lost wages, property damage) form the baseline, and non-economic damages (pain and suffering, emotional distress, loss of enjoyment) are typically calculated as a multiplier of the economic damages — commonly 1.5× to 5× depending on severity.

This means that every dollar of documented economic damage increases your claim value by $1.50 to $5.00 or more. A $500 medical expense that goes unrecorded is not just $500 lost — it is $750 to $2,500 in total claim value that evaporates.

The spreadsheet ensures nothing is missed by providing a structured framework for every category of damages. You do not need to remember what to track — the categories are built in. You just fill them in as expenses occur.

What the Spreadsheet Tracks#

Section 1: Medical Expenses#

The largest component of most personal injury claims. For each medical expense, you record the date of service, provider name and type (hospital, physician, physical therapist, chiropractor, specialist, pharmacy), description of service (ER visit, MRI, surgery, physical therapy session, prescription), billed amount (the full charge before insurance adjustments), amount paid by insurance, your out-of-pocket cost (copay, deductible, coinsurance), and the remaining balance owed.

The spreadsheet tracks both billed amounts and out-of-pocket costs because both are relevant. In many jurisdictions, you are entitled to recover the full billed amount (or reasonable value of medical services), not just what you paid out of pocket. Your attorney can advise on which standard applies in your state.

Categories include emergency room and urgent care, hospital admission and inpatient stays, surgical procedures, diagnostic imaging (X-rays, MRI, CT scans), primary care and specialist visits, physical therapy and rehabilitation, chiropractic care, mental health counselling (for accident-related anxiety, PTSD, depression), prescription medications, medical devices and equipment (crutches, braces, wheelchairs), and future estimated medical costs (if ongoing treatment is expected — your physician can provide a treatment plan with cost estimates).

Section 2: Lost Wages and Income#

If your injury prevented you from working — even partially — you are entitled to recover lost income. The spreadsheet tracks dates absent from work (full days and partial days), your regular daily or hourly wage, total lost wages for each period, employer verification (name, contact, willingness to provide a letter confirming absence), any sick or vacation days used (which have monetary value even if your paycheck was not reduced), reduced earning capacity (if you returned to work at reduced hours or in a lower-paying role due to the injury), and self-employment income loss (for freelancers and business owners, documented via comparison of pre-injury and post-injury income).

Section 3: Property Damage#

For vehicle accidents and other incidents involving property damage, the spreadsheet records the damaged property description (vehicle make/model/year, personal items), repair estimates and actual repair costs, rental car or alternative transportation costs during the repair period, diminished value (the reduction in your vehicle’s market value after repair, which is a recoverable damage in many states), and total loss value (if the vehicle was totalled — fair market value minus salvage).

Section 4: Out-of-Pocket Expenses#

The miscellaneous costs that are individually small but collectively significant. The spreadsheet tracks prescription co-pays and over-the-counter medications recommended by your physician, medical supplies (bandages, ice packs, heating pads), home modification costs (if the injury required temporary modifications like a shower chair or ramp), childcare costs (if the injury prevented you from caring for your children), household help (cleaning, lawn care, or other tasks you could normally do yourself), parking fees at medical facilities, and toll charges related to medical appointments.

Section 5: Mileage to Medical Appointments#

The IRS allows a medical mileage deduction for driving to and from medical appointments, and this mileage is also a recoverable expense in personal injury claims. For each trip, record the date, destination (provider and facility), round-trip miles driven, and the applicable mileage rate (the IRS medical mileage rate — check the current year’s rate at irs.gov). Over a course of treatment involving 20–40 physical therapy sessions plus specialist appointments, diagnostic imaging, and pharmacy trips, mileage can add up to hundreds of dollars.

Section 6: Total Damages Summary#

The dashboard at the top of the spreadsheet aggregates every category into a total damages summary: total medical expenses (billed and out-of-pocket), total lost wages, total property damage, total out-of-pocket expenses, total mileage costs, and grand total economic damages. This is the number your attorney uses as the baseline for calculating full claim value, including non-economic damages.

How to Use the Spreadsheet#

Step 1: Start immediately after the incident. Begin recording expenses on the day of the accident or as soon as possible afterward. The sooner you start, the more complete and credible your record will be. Insurance adjusters are sceptical of records that appear only when a claim is filed months later.

Step 2: Save every receipt, bill, and statement. The spreadsheet is your summary; the receipts are your evidence. Keep physical copies in a dedicated folder and photograph or scan each one. Digital backups prevent the disaster of lost paperwork.

Step 3: Record expenses as they occur. Do not wait until the end of the month or the end of treatment. Enter each expense within a day or two of incurring it. Real-time tracking is more accurate and more credible than reconstructed records.

Step 4: Request itemised bills from every provider. A single-line hospital bill for $15,000 is less useful than an itemised bill showing each service, test, and procedure. Itemised bills support the reasonableness of your claim and give your attorney specific evidence to present.

Step 5: Get employer verification of lost wages. Ask your employer for a letter confirming your dates of absence, your regular pay rate, and the total wages lost. This letter, combined with pay stubs showing your normal earnings, substantiates the lost wage claim.

Step 6: Share the completed tracker with your attorney. The total damages summary provides the economic foundation for your claim. Your attorney will use it to calculate full claim value, prepare the demand letter, and negotiate with the insurance company.

Download: Personal Injury Claim Expense Tracker — Excel (.xlsx)

What the Insurance Company Does Not Want You to Know#

Insurance adjusters are trained to minimise claim payouts. They do this by disputing the necessity of treatment (arguing you did not need that MRI or that many PT sessions), questioning the causal connection (arguing the injury was pre-existing or unrelated to the accident), lowering the multiplier for non-economic damages (offering 1× to 1.5× instead of 3× to 5×), and ignoring expenses you do not document (if it is not in writing, it does not exist in their calculation).

Thorough documentation counters every one of these tactics. Itemised medical bills with physician notes establish necessity. A consistent treatment timeline linked to the accident date establishes causation. A comprehensive economic damages total supported by receipts and records makes the multiplier negotiation start from a higher baseline. And nothing gets ignored because everything is documented.

For reviewing your auto insurance coverage before or after an accident, see our auto insurance comparison spreadsheet. For the broader framework on comparing insurance policies, see our complete guide to comparing insurance policies.

Frequently Asked Questions#

Should I use this spreadsheet even if I have an attorney?

Yes. Your attorney will create their own claim file, but providing them with a well-organised expense tracker saves them time (which saves you money if they bill hourly) and ensures nothing is missed. Attorneys appreciate clients who arrive with documentation rather than scattered receipts.

What if the insurance company has already made a settlement offer?

Compare the offer against your total damages summary. If the offer is less than your documented economic damages alone — before any multiplier for pain and suffering — it is almost certainly too low. The spreadsheet provides the evidence to demonstrate why the offer is inadequate.

How long should I track expenses?

Until your treatment is complete and your condition has stabilised (reached “maximum medical improvement”). Do not settle your claim while you are still receiving treatment — future medical costs are much harder to recover after a settlement is signed.

Can I include future medical expenses?

Yes, with medical documentation. If your physician determines that ongoing treatment will be needed (continued physical therapy, future surgery, long-term medication), they can provide a treatment plan with estimated costs. These future costs are recoverable damages and should be included in the tracker.

What about pain and suffering — does the spreadsheet track that?

The spreadsheet tracks economic damages (the quantifiable costs). Pain and suffering is a non-economic damage calculated separately — typically as a multiplier of economic damages. However, keeping a brief journal of how the injury affects your daily life (sleep disruption, inability to exercise, emotional distress, impact on relationships) provides evidence that supports a higher multiplier. The spreadsheet includes a notes section where you can record these impacts alongside the financial data.

Do I need to track expenses if the other party’s insurance is paying?

Absolutely. The other party’s insurer is paying because they are liable — but they will pay as little as possible. Your documentation determines whether you receive fair compensation or a lowball settlement. Track everything regardless of who is paying.

What if I do not have all the receipts?

Request duplicate bills from every provider. Medical facilities, pharmacies, and hospitals maintain billing records and can provide copies. For older expenses, check your health insurance company’s Explanation of Benefits (EOB) statements, which list every claim processed. Bank and credit card statements can verify out-of-pocket payments. Reconstruct what you can and note any gaps — partial documentation is vastly better than none.