Extracting Premium Breakdown From an Insurance Policy Declarations Page

The obvious validation on a declarations page is that the premium lines add up to the total premium. It fails constantly, and usually the document is right and the check is wrong.

There are two totals, not one

A declarations page generally supports two distinct equations, and conflating them is the source of most false failures:

sum(coverage premiums) + endorsement premiums = total premium

total premium + policy fees + taxes and surcharges = total amount due

Premium is what is charged for taking the risk. Fees are charges the insurer or broker adds for administration and are not premium. Taxes and surcharges are collected on behalf of somebody else and are not the insurer’s money at all. A document may print all three groups in one column with a single bold number at the bottom, but the number labelled “total premium” and the number labelled “total amount due” are answering different questions, and only the first one is the sum of the coverage lines.

So extract both totals as separate fields, always, even when only one appears — a null for the missing one is information. Then run both checks independently — two cross-field amount rules, not one — and report which one failed. A pipeline reporting “premium reconciliation failed” without saying which equation broke has told a reviewer nothing they could not have guessed.

The coverage lines themselves

Each line typically carries a coverage name, one or more limits, a deductible and a premium, and the extraction has to keep the premium column apart from the limit column. That sounds trivial until you see a commercial package policy where limits and premiums are both large round numbers in adjacent columns, and a column shift produces a perfectly plausible set of figures. The footing check is the defence: limits do not sum to the total premium, so a shifted extraction fails the arithmetic loudly.

Several line-level values are not numbers and need somewhere to go. “Included” or “INCL” means the coverage is provided at no additional premium, which is not zero in the sense of absent — it is a coverage that exists. “See schedule” points at a location or vehicle schedule whose own lines sum to this one. A blank means the coverage was not purchased. Encode these as an enum in a premium_qualifier field alongside a nullable numeric premium, rather than coercing all three to 0 and losing the distinction.

Endorsement premiums add a second layer. Endorsements listed by form number may carry their own premium, positive or negative, and a mid-term endorsement is often prorated for the remaining policy term, which is why an endorsement premium can be an odd figure that looks like an extraction error. Where the document shows a prorated amount and a full-term amount, capture both.

Taxes are not fees and neither is premium

The lines that sit between the two totals are worth naming because they are the ones that break a naive check:

• Policy fee, inspection fee, service fee. Flat charges, often non-refundable on cancellation, which is a detail that matters downstream if you compute return premiums.
• Surplus lines tax and stamping fee, on policies placed in the non-admitted market. These are percentage charges on premium, they vary by state, and the stamping fee goes to a stamping office rather than to the state.
• State assessments and guaranty fund surcharges, which are percentage charges with their own bases.
• Installment fees, where the policy is paid in instalments; the total amount due on the declarations page may then not match what is actually billed.
• Minimum earned premium, which is not a charge at all but a term stating what portion of premium the insurer keeps on early cancellation. It is a percentage on a page full of dollar figures, and it is regularly extracted as one.

Because tax lines are usually percentages of premium, they give you a third, weaker check: recompute the tax from the stated rate and the premium subtotal and compare. A mismatch of a few cents is rounding; a mismatch of a factor is a misread base, most often because the tax was calculated on premium plus fees rather than premium alone.

The separately disclosed terrorism line

US commercial property and liability policies frequently show a separate line for terrorism coverage. It exists because the federal terrorism risk insurance programme requires insurers to make the coverage available and to disclose the premium attributable to it, which is why the figure appears on its own rather than being folded into the coverage lines.

For extraction this line has three states and all of them occur: a positive premium where the coverage was accepted; a zero or a line reading “rejected” or “declined” where the insured turned it down, sometimes accompanied by a reference to a signed rejection form; and absence, on a policy where it does not apply. Extract it as its own field with an explicit accepted, rejected or not-applicable status, rather than as one more premium line. It is a frequent cause of a failed footing check precisely because reviewers think of it as a tax-like add-on when it is premium and belongs inside the first equation.

Where it goes wrong

• The audit adjustment. Policies rated on payroll or sales carry a deposit premium subject to audit; the declarations page premium is an estimate, and a later audit endorsement changes it. Extract the rating basis and the estimated exposure or the number is not what will be paid.
• Multi-year or multi-term policies. The total may cover more than the policy period shown on the same page.
• Per-location schedules. A property policy’s premium line may be the sum of a fifty-location schedule elsewhere in the document, so the declarations page foots while the schedule is the actual detail.
• Rounding to whole dollars. Where each line is rounded and the total is computed before rounding, the sum can differ by a few dollars legitimately. Set a tolerance and record it rather than chasing exact equality.
• Two currencies. On international programmes, local policy premiums may be shown alongside a master programme figure at a stated rate of exchange, and only the labels distinguish them.