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
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
-
Reserve Action Type
Select the action being documented for the claim file.
-
Effective Date
Date the reserve action becomes effective.
-
Reason for Submission
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
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
-
Supporting Facts and Assumptions
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
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
Name or identifier of the person completing the worksheet.
-
Reviewed By
Name or identifier of the reviewer, if applicable.
- Approval Status
-
Approval Notes
Add any review comments, required corrections, or approval rationale.
-
Attestation
Required acknowledgment for the audit trail.
How to use this template
- 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.
- 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.
- Describe the reserve basis, list the supporting facts, and attach or reference the key documents that justify the proposed change.
- State the material change reason clearly, especially when the adjustment is driven by new medical information, liability findings, settlement activity, or expense exposure.
- Have the preparer, reviewer, and approver complete their fields, then record the approval status, notes, and attestation before the worksheet is filed.
- 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:
Common use cases
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.
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 —...
-
See how connected 1:1 tracking, employee audit history, and LMS completion records turn scattered processes into verifiable workforce documentation.
-
MangoApps Shifts & Schedules unifies frontline scheduling, time, and leave management in one native platform for faster, simpler operations.
-
See how bank branch managers use MangoApps scheduling to fill shifts, communicate policy updates, and eliminate last-minute coverage chaos.
-
See how customers use MangoApps Projects Module to collaborate, track progress, and share knowledge across teams.
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.