Annual Loss Checklist: What Actually Matters
A lot of people treat the yearly loss checklist like a compliance exercise. It's not. It's the document that saves your backside when an auditor or insurance adjuster shows up unannounced. I've seen companies spend thousands on legal fees because they skipped the reconciliation step in November. Here's how it works in practice. You start with your general ledger, then pull every claim file from the past 12 months. Match each entry to its corresponding documentation. Claims paid, claims denied, reserves still open. That's it. The checklist itself is just a spreadsheet with columns for claim number, date of loss, category, amount reserved, amount paid, and current status. But the actual work happens in the gaps between those columns.
I learned this the hard way during a merger audit. We had a subsidiary with over 300 claims going back two years. The parent company's team flagged 47 claims where the reserve was zeroed out but the claim was still technically open because the legal team hadn't received the closing correspondence. Those 47 claims turned into a $2.3 million exposure adjustment. We fixed it by pulling every "closed" file from the last five years and re-verifying the closing dates against the actual settlement letters. It took me three weekends and about 200 emails to the claims department. The workaround I use now is straightforward: I run the checklist in two passes. First pass covers the current year only. Second pass, done a week later, pulls any claims that were closed in the previous three years but show residual activity. This catches the lingering administrative deaths that fall through the cracks.
The Process
Step one, get the data locked. Contact your claims management system or insurance carrier and request a full ledger export for the fiscal year. Do not rely on your internal accounting records alone. There's almost always a discrepancy between what you paid and what the carrier recorded, usually in the rounding or the claim processing fees that get bundled separately. Step two, categorize by loss type. Property damage, liability, workers comp, auto, cyber. Each category has its own documentation requirements and statute of limitations. Mixing them up will cost you later. I keep a separate tab for each category in the spreadsheet so the categorization is invisible to anyone who isn't looking for it but available when you need it. Step three, verify reserves. This is where most people mess up. A reserve isn't just the last amount entered. You need to confirm whether it's a case reserve set by the adjuster or a blanket reserve held by the carrier. These are different things, and they age differently on your books. I've seen companies count a blanket reserve as a case reserve, which throws off the entire liability schedule.
Get the Full Details
Step four, cross-reference to your tax filings. If you claimed a deduction for a loss in a given year, that loss should appear in your checklist. If it doesn't, you have either an unreported claim or a timing difference that needs documentation. I use a simple VLOOKUP between my tax schedule and the claim ledger. Takes about ten minutes once the data is structured. Step five, document everything. Not just the numbers. The names of the people who signed off on each entry. The date of each verification. The source file or email where you confirmed a payment. When this checklist gets questioned two years later, you won't remember where the information came from. I store supporting documents in a folder labeled by claim number, not by date. It sounds counterintuitive but it saves hours when someone asks about claim #44712 in March of last year.
Where This Breaks Down
The checklist method assumes you have clean data. Many companies don't. Legacy systems, merged databases, claims transferred between carriers without full documentation. In those cases the checklist is only as good as whatever records survived the transition. I've worked with three organizations where the loss history from before a software migration was essentially unrecoverable, and the best workaround was pulling annual financial statements to back into approximate figures. It's not precise but it's defensible. Another limitation: the checklist doesn't account for pending litigation that hasn't been formally claimed yet. If your legal team knows about a potential claim but hasn't filed it, it won't show up in the data. I recommend adding a separate section for known exposures from legal counsel, even if no claim exists yet. Half the companies I work with skip this section entirely. If you're a small operation with fewer than 50 claims per year, the manual spreadsheet approach works fine. Beyond that, you're better off using a dedicated loss run management tool. The software costs money but the time savings are real. A tool like ClaimVantage or a customized Power BI dashboard can automate about 80 percent of the reconciliation work and reduce a two-day process down to roughly half a day.
The core principle doesn't change regardless of scale. Track every loss, verify the numbers, keep the paper trail, and do it before anyone asks you to.
