For Independent Appraiser For Insurance Adjuster For Public Adjuster For Claims Attorney

Total Loss Valuation Worksheet

The total-loss file: clean-title comparables, the branded-title markdown, and the gap to the carrier offer.

Example query

Ask Claude or ChatGPT in plain English:

Build a total loss worksheet for VIN 3GNAXUEG2RS216393, 41,058 miles, ZIP 48120. Salvage title, the carrier offered $13,033.

My truck was totaled and the title is rebuilt. VIN 3C63R5SL3TG153504, 13,214 miles, ZIP 48124. Is the $21,500 offer fair?

Your assistant picks up the report, runs it against live MarketCheck data, and narrates the result back to you. Same credit balance, either assistant.

See a real rendered sample below

Cost

$4.99 per run

You provide

Must have

VIN17-character vehicle identification number.

Good to have (sharpens accuracy)

MilesOdometer reading at the time of the loss. STRONGLY RECOMMENDED, it drives the mileage adjustment and the comparable mileage band.
ZIPZIP code of the loss market. STRONGLY RECOMMENDED, defaults to 90210 if missing.
Title brandTitle status of the loss vehicle: "clean" (default), "salvage", "rebuilt", "flood", or "lemon". Anything other than clean values the vehicle from clean-title comparables and then applies the title-brand markdown.
Insurer offer (USD)The insurance carrier's settlement offer. The worksheet shows the settlement total minus this offer, with wording that only supports arguing the offer up when the selected comparables back it.

Optional (13)

Comp strategy
Title brand markdown (%)
Mileage cost per mile
Select comps
Exclude vins
Adjustments
Appraiser name
Appraiser license
Client name
Consumer name
Consumer address
Consumer phone
File number

Every path debits the same credit balance.

01What you get

You get back

Nearest matching clean-title comps with match %, options similarity %, and distance per comp
Every comp price verified on the dealer page (doc and dealer fees excluded), with a full-page evidence snapshot
Interactive selection plus an excluded-comps tab: the worksheet recalculates live and your changes save
Settlement math: average of selected asks, mileage adjustment at an editable per-mile rate, ACV, title-brand markdown, additions/deductions, total pre-tax
Title-brand markdown taken off the comp-derived ACV, 25% by default and editable, applied before your adjustments so documented receipts keep their full value
Gap between the settlement total and the insurance carrier offer
Branded Excel export and a locked read-only copy to hand the consumer

02Sample

What Claude/ChatGPT renders back

The interactive report your assistant shows right in the chat, the same view Claude and ChatGPT render, plus a shareable hosted link. Built on live MarketCheck data.

You

Build a total loss worksheet for VIN 3GNAXUEG2RS216393, 41,058 miles, ZIP 48120. Salvage title, the carrier offered $13,033.

Claude

via MarketCheck data

Each run also returns a shareable hosted link to this exact report.

03Try one of these

Tap to open in Claude or ChatGPT

Build a total loss worksheet for VIN 3GNAXUEG2RS216393, 41,058 miles, ZIP 48120. Salvage title, the carrier offered $13,033.

My truck was totaled and the title is rebuilt. VIN 3C63R5SL3TG153504, 13,214 miles, ZIP 48124. Is the $21,500 offer fair?

Ready when you are

One click. Your assistant does the rest.