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.
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