Loading...
operations

Claim Reserve Setting and Adjustment Worksheet

Track initial claim reserves and every adjustment in one worksheet, with the facts, documents, review, and approval trail needed to explain each change.

Trusted by frontline teams 15 years of frontline software AI customization in seconds

Built for: Insurance Claims · Workers' Compensation · Property And Casualty · Risk Management

Overview

The Claim Reserve Setting and Adjustment Worksheet documents the reserve amount assigned to a claim and every later change to that amount. It captures the claim and policy identifiers, the reserve category, current and proposed indemnity and expense reserves, the change amount, and the rationale behind the update.

Use this template when a claim is first opened, when new facts change the expected cost of the claim, or when a periodic review shows the reserve no longer matches the file. It is especially useful when multiple people touch the claim and you need a consistent record of why a reserve moved up or down. The review, approval, and attestation section helps preserve an audit trail for finance, claims leadership, and internal audit.

Do not use this worksheet as a substitute for claim notes or a full loss run. It is not the place to document every contact or every procedural step. It also should not be used to collect unnecessary personal data; keep the fields limited to what is needed to justify the reserve decision. If a claim is still too early to support a change, leave the reserve unchanged and record that no material adjustment is warranted yet. The template works best when the facts, documents, and approval path are specific enough that another reviewer can understand the decision without extra context.

Standards & compliance context

  • Limit fields to the minimum necessary information needed to justify the reserve decision, consistent with data minimization principles.
  • If the worksheet is used in a public-facing or shared workflow, ensure the form fields, labels, and validation support WCAG 2.1 AA accessibility.
  • Use the attestation and approval trail to support internal controls and auditability for financial reporting and claim governance.
  • Avoid collecting sensitive personal data unless it is required for the claim reserve decision and permitted by your internal policy.

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

Claim and Submission Details

This section ties the reserve action to the exact claim, policy, claim type, and effective date so the change can be matched to the right file.

  • Claim Number (required)

    Enter the claim file identifier used in your claims system.

  • Policy Number

    Optional if needed to link the reserve action to the policy record.

  • Claim Type (required)
  • Reserve Action Type (required)

    Select the action being documented for the claim file.

  • Effective Date (required)

    Date the reserve action becomes effective.

  • Reason for Submission (required)

    Briefly explain why this reserve worksheet is being completed.

Reserve Details

This section shows the current and proposed indemnity and expense reserves and the amount of change, which is the core financial decision being documented.

  • Reserve Category (required)

    Select the reserve category or categories affected by this action.

  • Current Indemnity Reserve

    Current indemnity reserve amount before this action, if applicable.

  • Proposed Indemnity Reserve

    New indemnity reserve amount after this action, if applicable.

  • Current Expense Reserve

    Current expense reserve amount before this action, if applicable.

  • Proposed Expense Reserve

    New expense reserve amount after this action, if applicable.

  • Total Reserve Change Amount

    Calculated net change across indemnity and expense reserves.

Supporting Rationale

This section explains why the reserve changed and points to the facts and documents that support the new amount.

  • Primary Basis for Reserve Decision (required)
  • Supporting Facts and Assumptions (required)

    Summarize the claim facts, estimates, or assumptions used to support the reserve amount.

  • Key Documents Reviewed

    Select the documents or sources used to support the reserve decision.

  • Describe Other Basis (required)

    Provide details when ‘Other’ is selected as a reserve basis.

  • Reason for Change from Prior Reserve

    Explain what changed since the prior reserve was established.

Review, Approval, and Audit Trail

This section records who prepared, reviewed, and approved the worksheet so the reserve decision is traceable and defensible.

  • Prepared By (required)

    Name or identifier of the person completing the worksheet.

  • Reviewed By

    Name or identifier of the reviewer, if applicable.

  • Approval Status (required)
  • Approval Notes

    Add any review comments, required corrections, or approval rationale.

  • Attestation (required)

    Required acknowledgment for the audit trail.

How to use this template

  1. Enter the claim number, policy number, claim type, reserve action type, effective date, and submission reason so the worksheet is tied to the correct file and event.
  2. Select the reserve category and fill in the current and proposed indemnity and expense reserves using the same currency and calculation method your team uses in the claim system.
  3. Describe the reserve basis, list the supporting facts, and attach or reference the key documents that justify the proposed change.
  4. State the material change reason clearly, especially when the adjustment is driven by new medical information, liability findings, settlement activity, or expense exposure.
  5. Have the preparer, reviewer, and approver complete their fields, then record the approval status, notes, and attestation before the worksheet is filed.
  6. Save the completed worksheet in the claim file and update the claim system so the reserve record and the supporting audit trail stay aligned.

Best practices

  • Use a date picker for the effective date so the reserve change is tied to a precise event date.
  • Show both current and proposed reserve amounts whenever a change is requested so reviewers can see the delta immediately.
  • Keep the reserve basis factual and specific, and avoid vague phrases like "updated exposure" without explaining what changed.
  • Reference the exact document type and date for each supporting document so the reviewer can trace the decision quickly.
  • Use conditional logic to show only the reserve fields relevant to the selected claim type or reserve action type.
  • Require the approval notes only when the approval status is not approved, so exceptions are documented without overburdening routine cases.
  • Keep the worksheet limited to claim and reserve data; do not collect unrelated PII or narrative details that are not needed for the reserve decision.

What this template typically catches

Issues teams running this template most often surface in practice:

The proposed reserve is entered without showing the current reserve, making the size of the adjustment unclear.
The reserve basis is too generic to explain why the amount changed.
Supporting documents are listed but not connected to the actual exposure change.
Approval is recorded after the fact without a clear reviewer or attestation.
The effective date does not match the event that triggered the reserve change.
Expense reserve and indemnity reserve are combined in a way that hides the underlying exposure.
The worksheet captures more narrative than needed and drifts into unrelated claim history.

Common use cases

Workers' compensation claim handler
A claim handler updates indemnity and expense reserves after receiving a new medical report and work-status note. The worksheet captures the change reason, the supporting documents, and the supervisor approval before the file is closed for review.
Auto liability claims supervisor
A supervisor reviews a proposed reserve increase after defense counsel reports additional exposure. The form records the current amount, proposed amount, rationale, and approval notes so the adjustment can be traced later.
Property claims analyst
An analyst documents a reserve decrease after repair estimates come in below the original estimate. The worksheet shows the prior reserve, the revised expectation, and the documents that support the lower amount.
Risk management audit reviewer
A reviewer uses the worksheet to confirm that reserve changes were supported, approved, and filed consistently across the claim portfolio. The audit trail makes it easier to spot unexplained changes or missing sign-off.

Frequently asked questions

What is this worksheet used for?

This worksheet records the initial indemnity and expense reserve for a claim, then captures each later adjustment with the reason behind it. It is meant to keep the claim file aligned with financial reporting and internal review requirements. Use it when a reserve is set, increased, decreased, or reclassified.

Who should complete the worksheet?

It is usually prepared by the claim handler, adjuster, or claims analyst who has the facts needed to justify the reserve. A supervisor, manager, or finance reviewer can then review and approve the entry. The approval path should match your internal authority levels.

How often should reserve adjustments be documented?

Document the worksheet whenever a material change in exposure, medical status, liability assessment, litigation posture, or expense expectation occurs. Many teams also update it at scheduled claim reviews so the reserve stays current. The key is to record the change when the basis changes, not after the file has drifted.

What information should support a reserve change?

Include the reserve basis, the specific facts that changed, and the key documents that support the new amount. Examples include updated medical reports, demand letters, litigation updates, repair estimates, or counsel opinions. The worksheet should make it clear why the prior reserve is no longer sufficient.

How does this help with audit trail and consistency?

Each entry ties the reserve amount to a date, a reason, a reviewer, and an approval status. That creates a traceable record for internal audit, finance reconciliation, and claim file review. It also reduces unexplained reserve swings across handlers or offices.

What are the most common mistakes when using this template?

Common issues include leaving the rationale too vague, entering a new reserve without showing the prior amount, and skipping the approval step. Another frequent problem is listing documents without explaining how they affected the reserve decision. The worksheet works best when the change is specific and defensible.

Can this worksheet be customized by claim type or line of business?

Yes. You can tailor the reserve category, rationale prompts, and supporting documents to workers' compensation, auto liability, general liability, property, or other claim types. Many teams also add conditional logic so only relevant fields appear for the claim category.

How does it fit with claims systems or finance tools?

The worksheet can be used as a standalone record or as a supporting form that feeds a claims platform, document management system, or finance workflow. If you integrate it, keep the claim number and policy number fields consistent with your source system. That makes reconciliation and audit retrieval easier.

When should a reserve not be changed yet?

Do not update the reserve just because a new file note was added or because the claim is aging. If there is no material change in exposure, facts, or documentation, keep the current reserve and note the review outcome instead. The worksheet should reflect actual reserve decisions, not routine activity.

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 Claim Reserve Setting and Adjustment 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?