Loading...
operations

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 (required)
  • Vehicle Identification Number (VIN) (required)
  • Year / Make / Model (required)
  • Date of Loss (required)
  • State (required)

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) (required)
  • Estimated Repair Cost (required)
  • Known Supplement Amount

    Enter any known supplement amount if it is already documented; otherwise leave blank.

  • State Total Loss Threshold (%) (required)

    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? (required)
  • 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

  1. Enter the claim number, VIN, vehicle year/make/model, loss date, and state so the worksheet is tied to the correct file and jurisdiction.
  2. Record the actual cash value, estimated repair cost, supplement amount, state total loss threshold, and the source used to verify that threshold.
  3. 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.
  4. Set the likely total loss and escalation-needed fields based on the comparison, then add supporting notes that explain any borderline or unusual inputs.
  5. 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:

Repair cost is entered without the supplement amount, which understates the true repair total.
The wrong state threshold is used because the state field was left blank or not tied to the threshold source.
ACV is recorded without a source note, making the comparison hard to verify later.
The likely total loss field is marked too early, before the estimate is stable.
Supporting notes are too vague to explain why the claim was escalated or held.
Attachments are missing, so the reviewer cannot confirm the estimate or valuation basis.
Reviewer name and review date are left blank, weakening the audit trail.

Common use cases

Auto Claims Adjuster in a Borderline Repair Case
An adjuster uses the worksheet after the initial estimate comes in near the threshold. The form captures the ACV, repair total, and state rule so the adjuster can decide whether to escalate the file.
Collision Center Estimator Handling Supplements
A shop estimator updates the worksheet when supplements arrive after teardown. The revised repair total helps the team identify when a vehicle should be routed for total loss review instead of another repair cycle.
Claims Supervisor Reviewing State-Specific Thresholds
A supervisor reviews flagged claims across multiple states and needs a consistent record of which threshold was applied. The worksheet keeps the comparison and source documentation in one place for faster approval.
Fleet Manager Tracking High-Damage Vehicles
A fleet manager uses the worksheet to decide whether a damaged vehicle should be repaired or removed from service. The structured comparison helps standardize decisions across locations and vendors.

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.

Go deeper on the topic

Related concepts
  • 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 —...
Related guides

Ready to use this template?

Get started with MangoApps and use Total Loss Identification Worksheet with your team — pricing built for small business.

Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?