Templates Settlement Worksheets Workers' Compensation Credit/Offset Calculation Worksheet
Workers' Compensation Credit/Offset Calculation Worksheet
Ready to Edit

WORKERS' COMPENSATION CREDIT/OFFSET CALCULATION WORKSHEET

Case Name: [________________________________]
Case/Claim Number: [________________________________]
Date of Injury: [__/__/____]
Date Prepared: [__/__/____]
Prepared By: [________________________________]


SECTION 1: CASE OVERVIEW

Workers' Compensation Claim Information:

Field Information
Injured Worker Name [________________________________]
Employer at Time of Injury [________________________________]
WC Carrier/Administrator [________________________________]
WC Claim Number [________________________________]
Date of Injury [__/__/____]
Nature of Injury [________________________________]
Body Parts Affected [________________________________]

Third-Party Case Information:

Field Information
Third-Party Defendant(s) [________________________________]
Third-Party Case Number [________________________________]
Third-Party Carrier [________________________________]
Policy Limits $ [________________]

SECTION 2: JURISDICTIONAL RULES

State: [____]

Applicable Statute:

[________________________________]

Type of Recovery System:

Subrogation/Reimbursement System
- WC carrier has direct claim against third party or reimbursement from employee's recovery

Credit/Offset System
- Employer entitled to credit against future benefits for third-party recovery

Hybrid System
- Both lien reimbursement and future credit apply

Key State Rules:

Attorney Fee Allocation:
☐ WC lien reduced by proportionate share of attorney fees
☐ Statutory formula for fee allocation: [________________________________]
☐ No fee allocation required

Employer Fault Consideration:
☐ Witt v. Jackson or similar rule applies
☐ Employer negligence reduces lien/credit
☐ Employer fault not considered

Made Whole Doctrine:
☐ Applies - Employee must be made whole first
☐ Does not apply - WC recovers first dollar
☐ Modified: [________________________________]


SECTION 3: WORKERS' COMPENSATION BENEFITS PAID

A. Medical Benefits Paid to Date:

Provider/Category Date(s) of Service Amount Paid
[________________________________] [__/__/____] to [__/__/____] $ [________]
[________________________________] [__/__/____] to [__/__/____] $ [________]
[________________________________] [__/__/____] to [__/__/____] $ [________]
[________________________________] [__/__/____] to [__/__/____] $ [________]
[________________________________] [__/__/____] to [__/__/____] $ [________]
[________________________________] [__/__/____] to [__/__/____] $ [________]
TOTAL MEDICAL PAID $ [________]

B. Indemnity Benefits Paid to Date:

Benefit Type Period Rate Weeks/Amount Total
Temporary Total Disability (TTD) [__/__/____] to [__/__/____] $ [____]/wk [____] wks $ [________]
Temporary Partial Disability (TPD) [__/__/____] to [__/__/____] $ [____]/wk [____] wks $ [________]
Permanent Partial Disability (PPD) [__/__/____] to [__/__/____] $ [____]/wk [____] wks $ [________]
Permanent Total Disability (PTD) [__/__/____] to [__/__/____] $ [____]/wk [____] wks $ [________]
Death Benefits [__/__/____] to [__/__/____] $ [____]/wk [____] wks $ [________]
Other: [________________] [__/__/____] to [__/__/____] $ [________]
TOTAL INDEMNITY PAID $ [________]

C. Other Benefits Paid:

Benefit Type Amount
Vocational Rehabilitation $ [________________]
Mileage/Travel $ [________________]
Attendant Care $ [________________]
Home/Vehicle Modifications $ [________________]
Other: [________________________________] $ [________________]
TOTAL OTHER BENEFITS $ [________________]

D. Total Benefits Summary:

Category Amount
Total Medical Benefits Paid $ [________________]
Total Indemnity Benefits Paid $ [________________]
Total Other Benefits Paid $ [________________]
TOTAL WC BENEFITS PAID TO DATE $ [________________]

SECTION 4: ESTIMATED FUTURE BENEFITS

A. Future Medical Benefits:

Treatment/Category Estimated Cost Duration Total
[________________________________] $ [________]/yr [____] yrs $ [________]
[________________________________] $ [________]/yr [____] yrs $ [________]
[________________________________] $ [________]/yr [____] yrs $ [________]
[________________________________] One-time $ [________]
TOTAL ESTIMATED FUTURE MEDICAL $ [________]

B. Future Indemnity Benefits:

Benefit Type Rate Weeks Total
Continuing TTD $ [____]/wk [____] $ [________]
Continuing PPD $ [____]/wk [____] $ [________]
Continuing PTD $ [____]/wk [____] $ [________]
Continuing Death Benefits $ [____]/wk [____] $ [________]
TOTAL ESTIMATED FUTURE INDEMNITY $ [________]

C. Total Estimated Future Benefits:

Category Amount
Estimated Future Medical $ [________________]
Estimated Future Indemnity $ [________________]
TOTAL ESTIMATED FUTURE BENEFITS $ [________________]

SECTION 5: THIRD-PARTY RECOVERY

Settlement/Verdict Information:

Item Amount
Gross Third-Party Recovery $ [________________]
Less: Attorney Fees ([____]%) ($ [________________])
Less: Litigation Costs ($ [________________])
Net Third-Party Recovery $ [________________]

Detailed Cost Breakdown:

Cost Item Amount
Filing Fees $ [________________]
Deposition Costs $ [________________]
Expert Fees $ [________________]
Medical Records $ [________________]
Other Costs: [________________] $ [________________]
TOTAL COSTS $ [________________]

SECTION 6: LIEN/CREDIT CALCULATION

Method 1: Standard Lien Calculation

Calculation Step Amount
Total WC Benefits Paid (Lien) $ [________________]
Less: Proportionate Attorney Fees ($ [________________])
Less: Proportionate Costs ($ [________________])
NET LIEN AMOUNT $ [________________]

Attorney Fee Reduction Calculation:

Calculation Value
Gross Recovery $ [________________]
Attorney Fees $ [________________]
Attorney Fee Percentage [____]%
Costs $ [________________]
Total Litigation Costs $ [________________]
Litigation Cost Percentage [____]%
Proportionate Lien Reduction [____]%
Calculation Amount
Gross Lien $ [________________]
Times: (100% - Litigation Cost %) × [____]%
Reduced Lien $ [________________]

Method 2: Net Recovery Formula (Common in Many States)

Step Calculation
1. Gross Recovery $ [________________]
2. Less: Attorney Fees ($ [________________])
3. Less: Costs ($ [________________])
4. Net Recovery $ [________________]
5. WC Lien $ [________________]
6. Less: Pro Rata Litigation Costs ([____]%) ($ [________________])
7. Adjusted Lien $ [________________]

SECTION 7: EMPLOYER NEGLIGENCE ANALYSIS (Witt v. Jackson)

Does Employer Share Fault for Injury?

☐ Yes - Employer contributed to causing injury
☐ No - Employer not at fault
☐ Uncertain - Further analysis needed

If Employer At Fault:

Analysis Value
Employer's Percentage of Fault [____]%
Third Party's Percentage of Fault [____]%
Employee's Percentage of Fault [____]%
TOTAL 100%

Lien Reduction for Employer Fault:

Calculation Amount
Adjusted Lien (from Section 6) $ [________________]
Employer Fault Percentage [____]%
Reduction for Employer Fault ($ [________________])
LIEN AFTER EMPLOYER FAULT REDUCTION $ [________________]

Applicable State Law on Employer Fault:
[________________________________]
[________________________________]


SECTION 8: FUTURE CREDIT CALCULATION

Credit Against Future Benefits:

Calculation Amount
Net Third-Party Recovery to Employee $ [________________]
Less: Amount Paid to Satisfy WC Lien ($ [________________])
Employee's Net Recovery $ [________________]

Credit Application:

Calculation Amount
Employee's Net Recovery $ [________________]
Estimated Future WC Benefits $ [________________]
Credit Amount $ [________________]

How Credit Works:
If employee's net recovery exceeds zero, employer may be entitled to credit against future WC benefits equal to employee's net recovery amount.

Credit Status Value
Credit Amount $ [________________]
Current Weekly Benefit Rate $ [________________]
Weeks of Credit [________________]

SECTION 9: DISTRIBUTION WORKSHEET

Settlement Distribution:

Distribution Item Amount
Gross Third-Party Settlement $ [________________]
DEDUCTIONS:
Attorney Fees ([____]%) ($ [________________])
Litigation Costs ($ [________________])
WC Lien Payoff ($ [________________])
Other Liens: [________________] ($ [________________])
NET TO INJURED WORKER $ [________________]

Credit Holdback (if applicable):

Item Amount
Net to Injured Worker $ [________________]
Less: Future Credit Reserve ($ [________________])
Immediate Distribution to Worker $ [________________]

SECTION 10: STATE-SPECIFIC FORMULAS

Common State Approaches:

New York (Kelly/Burns Formulas):

☐ Kelly Formula (Schedule Loss of Use, PTD, Death, Benefits Terminated)
☐ Burns Formula (Continuing PPD Benefits)

Kelly Formula:
Net Recovery × (WC Lien ÷ (WC Lien + Claimant's Damages Excluding WC Paid)) = WC Share

Burns Formula:
Different allocation between past and future benefits

California (Labor Code § 3861):

Calculation Amount
Gross Recovery $ [________________]
Less: Reasonable Attorney Fees ($ [________________])
Less: Costs ($ [________________])
Net Recovery $ [________________]
WC Employer's Credit $ [________________]

Other State Formula: [________________________________]

Step Calculation
[________________________________] $ [________________]
[________________________________] $ [________________]
[________________________________] $ [________________]
Result $ [________________]

SECTION 11: NEGOTIATION TRACKING

Lien Negotiation:

Date Contact Discussion Offer/Counter
[__/__/____] [________________] [________________] $ [________]
[__/__/____] [________________] [________________] $ [________]
[__/__/____] [________________] [________________] $ [________]
[__/__/____] [________________] [________________] $ [________]

Resolution:

Item Amount
Original Lien Claimed $ [________________]
Final Negotiated Amount $ [________________]
Savings $ [________________]
Savings Percentage [____]%

SECTION 12: APPROVAL AND DOCUMENTATION

Required Approvals (Varies by State):

☐ Workers' Compensation Board/Commission approval required
☐ Employer/carrier consent obtained
☐ Court approval of settlement allocation
☐ Compromise and release filed
☐ Other: [________________________________]

Documentation Checklist:

☐ WC benefit printout (complete)
☐ Third-party settlement agreement
☐ Attorney fee agreement
☐ Litigation cost itemization
☐ Employer fault analysis (if applicable)
☐ State-specific calculation worksheet
☐ WC carrier lien letter
☐ Lien reduction agreement
☐ Distribution statement
☐ Release from WC carrier
☐ WC Board approval (if required)


SECTION 13: SUMMARY

Final Numbers:

Category Amount
Gross Third-Party Recovery $ [________________]
Attorney Fees $ [________________]
Costs $ [________________]
WC Lien Payoff $ [________________]
Other Deductions $ [________________]
Net to Injured Worker $ [________________]
Future WC Credit (if any) $ [________________]
Credit Period [____] weeks

CERTIFICATION

I certify that this workers' compensation credit/offset calculation is based on available benefit records, applicable state law, and the third-party recovery in this matter. This worksheet is for settlement calculation purposes.

Signature: ________________________________________ Date: [__/__/____]

Print Name: [________________________________]

Title: [________________________________]


SOURCES AND REFERENCES

  • Sullivan on Comp: Credit for Third-Party Recovery
  • Advocate Magazine: Lien Management in WC and Civil Cases
  • CLM Magazine: Recovering a Workers' Compensation Lien
  • State-specific workers' compensation statutes
  • MWL Law: Documenting WC Statutory Credits in All 50 States

This worksheet is for informational purposes only. Workers' compensation lien and credit rules vary significantly by state. Consult legal counsel regarding applicable state law and specific calculation requirements.

Ezel AI
Hi! Need help customizing this document? I can tailor every section to your specific case in minutes.
AI Legal Assistant
Ezel AI
Hi! Need help customizing this document? I can tailor every section to your specific case in minutes.

Insert Image

Insert Table

Watch Ezel in action (sample case)

All changes saved
Save
Export
Export as DOCX
Export as PDF
Generating PDF...
workers_comp_credit_worksheet_universal.pdf
Ready to export as PDF or Word
AI is editing...
Chat
Review

Customize this document with Ezel

  • Deep Legal Knowledge
    Understands case law, statutes, and legal doctrine.
  • Court-Ready Formatting
    Proper captions, certificates of service, and local rule compliance.
  • AI-Powered Editing on Your Timeline
    Edit as many times as you need. Tailor every section to your specific case.
  • Export as PDF & Word
    Download your finished document in professional PDF or DOCX format, ready to file or send.
Secure checkout via Stripe
Need to customize this document?

About This Template

Jurisdiction-Specific

This template is drafted for general use across all U.S. jurisdictions. State-specific versions with local statutory references are also available.

How It's Made

Drafted using current statutory databases and legal standards for settlement worksheets. Each template includes proper legal citations, defined terms, and standard protective clauses.

Important Notice

This template is provided for informational purposes. It is not legal advice. We recommend having an attorney review any legal document before signing, especially for high-value or complex matters.

Last updated: February 2026