Total Loss Identification Worksheet
Use this worksheet to compare a vehicle's repair estimate against its actual cash value and the applicable state total loss threshold. It helps estimators flag likely total losses early and document the review trail.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Auto Insurance · Collision Repair · Claims Operations · Fleet Management
Overview
The Total Loss Identification Worksheet is a claim-side screening form for comparing a vehicle's actual cash value, estimated repair cost, supplement amount, and the applicable state total loss threshold. It gives estimators and reviewers one place to capture the numbers, note the threshold source, and record whether the claim likely needs escalation.
Use this template when a repair estimate is close to the point where a vehicle may be uneconomical to repair, or when you need a consistent way to flag borderline claims before they move deeper into the workflow. It is especially useful after supplements, when the repair total can change enough to alter the decision. The worksheet also helps standardize review across states by making the threshold source visible.
Do not use it as a substitute for a final legal or title decision. If the vehicle is clearly repairable, or if your organization already has a separate total loss determination process with its own required forms, this worksheet may be unnecessary. It is also not the right tool for unrelated vehicle intake, damage appraisal, or settlement documentation. Its purpose is narrow: compare the key values, show the threshold math, and create a clear audit trail for the screening decision.
Standards & compliance context
- Limit the worksheet to the minimum necessary claim data to align with GDPR data minimization and general privacy principles.
- If the form is exposed to claimants or other external users, ensure fields, labels, and validation meet WCAG 2.1 AA accessibility expectations.
- Use a clear audit trail with reviewer name, review date, and attachments so internal claim handling can be traced later.
- If the worksheet is used in a regulated insurance workflow, keep the threshold source and state-specific rule visible to support consistent handling.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Vehicle and Claim Identification
This section ties the screening record to the correct claim, vehicle, and jurisdiction so the comparison is not detached from the file.
- Claim Number
- Vehicle Identification Number (VIN)
- Year / Make / Model
- Date of Loss
- State
Valuation and Estimate Inputs
This section captures the numbers that drive the decision, including ACV, repair cost, supplements, and the threshold source.
- Actual Cash Value (ACV)
- Estimated Repair Cost
-
Known Supplement Amount
Enter any known supplement amount if it is already documented; otherwise leave blank.
-
State Total Loss Threshold (%)
Enter the applicable state threshold percentage used to determine whether the vehicle is a likely total loss.
-
Threshold Source
Optional reference for the threshold used, such as state statute, carrier guideline, or internal policy.
Total Loss Screening Result
This section shows the actual comparison outcome and whether the claim should move to the next review step.
- Repair-to-ACV Percentage
-
Comparison Result
This result compares the estimated repair percentage to the state total loss threshold.
- Likely Total Loss?
-
Escalate to Total Loss Review?
Select if the estimate should be reviewed by a supervisor, adjuster, or total loss specialist.
Audit Trail and Notes
This section preserves the reviewer, date, attachments, and explanation so the screening decision can be verified later.
-
Supporting Notes
Include any assumptions, missing information, or estimate factors that affect the screening result.
-
Supporting Documents
Upload estimate pages, valuation reports, or other supporting documents if available.
- Reviewer Name
- Review Date
How to use this template
- Enter the claim number, VIN, vehicle year/make/model, loss date, and state so the worksheet is tied to the correct file and jurisdiction.
- Record the actual cash value, estimated repair cost, supplement amount, state total loss threshold, and the source used to verify that threshold.
- Calculate or confirm the repair-to-ACV percentage and compare it against the threshold so the worksheet can flag whether the claim is likely a total loss.
- Set the likely total loss and escalation-needed fields based on the comparison, then add supporting notes that explain any borderline or unusual inputs.
- Attach estimate pages, valuation support, or other documents used in the review, and enter the reviewer name and review date to complete the audit trail.
Best practices
- Use the state field and threshold source together so reviewers can see exactly which rule was applied.
- Include supplement amounts in the repair total before deciding whether the claim crosses the threshold.
- Keep the worksheet focused on the minimum necessary claim data and avoid collecting unrelated PII.
- Use numeric inputs for ACV, repair cost, supplements, and threshold values so the comparison is accurate and easy to validate.
- Add conditional logic to show escalation fields only when the claim is likely to need review, which keeps the form shorter and clearer.
- Document any manual override or exception in supporting notes so the audit trail explains why the screening result changed.
- Attach the estimate or valuation source at the time of review rather than relying on memory later.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What is this worksheet used for?
This worksheet is used to screen a vehicle claim for likely total loss status by comparing actual cash value, estimated repair cost, supplements, and the applicable state threshold. It gives estimators a consistent place to record the numbers behind the decision. The output is a documented screening result, not a final legal determination. It is most useful when you need to triage claims before sending them to a total loss specialist or manager.
When should I use it in the claims process?
Use it as soon as you have a credible repair estimate and a current ACV, then update it if supplements change the math. It works best during initial estimate review and again after any supplement that could move the claim across the threshold. If the vehicle is obviously repairable or obviously a total loss, you may not need a full screening pass. The worksheet is most valuable in the gray area where the threshold is close.
Who should complete this template?
An estimator, adjuster, or claim reviewer usually completes it, depending on your workflow. The person filling it out should understand valuation inputs, repair estimate structure, and the state threshold rule being applied. A supervisor or total loss reviewer can then confirm the escalation decision. If your process separates estimating from approval, this worksheet helps preserve a clear audit trail between roles.
Does this replace the final total loss decision?
No. It is a screening worksheet that helps identify claims that likely need escalation. Final handling may depend on state rules, title requirements, salvage procedures, and insurer policy. The worksheet should point to the next action, such as review, escalation, or additional valuation work. It should not be treated as the only authority for settlement or disposition.
What compliance or documentation issues should I watch for?
The main risk is using an outdated threshold or an undocumented source for the threshold comparison. You should also record the valuation source, review date, and any attachments that support the estimate or ACV. If the worksheet includes claimant or vehicle details, keep the data limited to what is needed for the claim. Clear notes and an audit trail help support internal review and state-specific handling.
How do I customize it for different states or carriers?
Add a controlled field for state and a threshold source field so reviewers can see which rule was applied. If your organization uses different escalation paths by state, use conditional logic to show the correct next-step fields or reviewer assignment. You can also add carrier-specific notes, salvage contact fields, or title handling steps if those are part of your process. Keep the core comparison fields unchanged so the worksheet stays consistent across claims.
What are the most common mistakes when using this worksheet?
Common mistakes include leaving out supplements, using the wrong state threshold, and recording ACV without noting the source date. Another frequent issue is treating the worksheet as final when the estimate is still changing. Teams also sometimes skip attachments, which makes later review harder. A clear review date and reviewer name help prevent confusion about which version was used.
Can this be integrated with other claim workflows?
Yes. It can sit alongside estimate intake, valuation review, salvage assignment, and approval workflows. The claim number and VIN fields make it easy to connect the worksheet to a claims system or document repository. If your platform supports automation, you can route likely total losses to a supervisor or total loss queue based on the screening result. The worksheet is designed to be a reusable step in a larger claim process.
Related templates
Go deeper on the topic
-
A standard operating procedure (SOP) is a documented, step-by-step procedure for a repeatable task — the written version of "how we do this here." Good SOPs...
-
Workforce management (WFM) is the operational discipline of getting the right employees, with the right skills, in the right place, at the right time — and...
-
A daily huddle is a brief (10–15 minute) standing meeting held at the start of a shift or workday to align the team on priorities, surface issues, and...
-
A deskless worker is any employee whose job happens without a desk, a company laptop, or a fixed workstation. They're roughly 80% of the global workforce —...
-
Discover 4 proven keys to successful project management and team collaboration — from transparent goal-setting to real-time communication and workflow...
-
Boost team collaboration with modern tools that improve visibility, accountability, and communication for stronger project outcomes.
-
Compare the best employee apps of 2026—MangoApps, Blink, WorkJam, Flip, and more—to find the right fit for your frontline workforce.
-
Discover how continuous feedback, dynamic goal-setting, and psychological safety replace annual review dread with a no-surprise performance culture that...
Ready to use this template?
Get started with MangoApps and use Total Loss Identification Worksheet with your team — pricing built for small business.