The plural is bordereaux. There are three kinds: the risk or premium bordereau (each policy bound, with insured, period, limits, premium, commission and tax), the claims bordereau (each claim, with status, paid and outstanding amounts) and sometimes a separate paid bordereau for cash movements. Lloyd's prescribes standard column sets so managing agents can load them automatically.
Bordereaux are how the insurer sees its delegated book: it books the premium, sets reserves and files its own regulatory returns from them. Late, incomplete or unreconciled bordereaux are the most common finding in delegated authority audits, and the reason many MGAs still spend days each month in spreadsheets.
On Soldek
Because every policy, endorsement and claim on Soldek is structured data linked to a binder, the premium bordereau is generated per transaction (new business, renewal, endorsement, cancellation) and the claims bordereau per claim, per binder and period, with the agreement, risk, insured, broker, tax, payment and underwriting detail on every row and a data-dictionary sheet in the workbook; XLSX or CSV, reconciled to the book by construction, produced monthly by a cron.
Bordereaux softwareQuestions
- How often are bordereaux due?
- Monthly is the norm, within an agreed number of days after month end; some binders require quarterly reporting and some direct carriers accept live data feeds instead.
- What is a Lloyd's standard bordereau?
- A column specification from Lloyd's (and its delegated data manager programme) that defines the fields and formats for premium and claims bordereaux so managing agents can process them without manual mapping.