Premium Bordereaux vs Claims Bordereaux
Premium and claims bordereaux are both insurance reporting files, but they answer different operational questions. Mixing their validation rules is one of the easiest ways to miss important data problems.
What a premium bordereaux is for
A premium bordereaux reports written premium, risk or policy records, transaction dates, insured names, territories, classes of business, and financial fields such as gross and net premium. It is mainly used to reconcile written business and understand what has been bound, endorsed, cancelled, or reported during a period.
What a claims bordereaux is for
A claims bordereaux reports claim activity: claim references, loss dates, status, paid amounts, reserves, incurred values, and sometimes cause of loss or settlement detail. It is used for claims oversight, reserve review, delegated authority monitoring, and renewal discussions.
Fields that matter most
Premium bordereaux checks should focus on policy references, insured names, transaction dates, inception and expiry dates, country, currency, premium values, and class of business. Claims bordereaux checks should focus on claim references, policy references, loss dates, claim status, paid, reserve, incurred, currency, and line of business.
Validation differences
Premium files often fail because transactions are outside the binder period, premium amounts are negative or missing, or country and currency fields are not explicit. Claims files often fail because claim references are missing, loss dates are invalid, open reserves are unclear, or incurred values do not reconcile with paid plus reserve.
Download templates
Start with a clean structure: download the premium bordereaux template or download the claims bordereaux template. Then run the file through the Bordereaux Validator.