What Baxter Dating History Actually Is
Baxter Dating History is essentially a record-keeping system used primarily in actuarial and insurance modeling contexts. It tracks the dating of exposure periods for policyholder data so that claims, premiums, and reserves can be assigned to the correct calendar or policy year. The "Baxter" part comes from a methodology named after an actuary who worked on refining how exposure dating works when you have mixed policy inception dates, cancellations, and mid-term adjustments in the same block of business. You use this when standard calendar-year dating doesn't cut it. Say you run a premium written book where policies are issued every single day of the year, not just on anniversaries. Simple calendar-year aggregation will smear your data across too many accident periods, and your loss ratio calculations become unreliable. Baxter Dating History gives you a cleaner way to map each dollar of premium to the period it actually belongs to. First, make sure your source data has these fields at minimum: policy number, inception date, expiration date, premium amount, and effective date of any mid-term changes. If you're missing any of those, the method won't work properly. I ran into this exact problem once with a commercial lines book where the mid-term adjustment dates weren't being captured in the legacy system. The workaround was to pull the adjustment logs from the billing module and join them back using policy number plus effective date as the key. Took about three hours of ugly SQL, but it fixed the gap.
Next, you calculate the daily premium exposure. Divide the total premium by the policy term in days to get a daily rate. Then multiply that daily rate by the number of days each exposure falls into your chosen study period. This gives you the prorate premium for that slice. The actual dating itself works by assigning each day of coverage to its corresponding calendar year or policy year. You build a date grid that runs from the earliest inception to the latest expiration in your dataset. Each row represents a single policy day, and you tag it with the period it belongs to. Once you've done that, you can roll up premiums and losses by that tagged period instead of by when the claim was reported or the policy was written.
Common Pitfalls
The biggest mistake beginners make is treating Baxter Dating History as a replacement for all other dating methods. It isn't. If your book is mostly one-year policies issued on or near the same date each year, standard accident year dating is fine and faster to compute. This method adds complexity for marginal gain. Another trap is forgetting about cancellations. If policies terminate early and you don't stop the daily exposure at the cancellation date, your denominator gets inflated and your loss ratios look artificially low. There is also a processing cost. For small books under fifty thousand policies, the setup time usually outweighs the accuracy benefit. I would only recommend this for blocks above that threshold or for anything with a high volume of mid-term adjustments.
Get the Full Details
When It Falls Apart
The method assumes you can reliably date every exposure. If your data is incomplete or your policy term lengths vary wildly without clean records, the daily proration becomes guesswork. In those cases, a simpler duration-based exposure approach or a cohort analysis might give you results that are close enough with far less data plumbing.
