A bordereau is the periodic report a coverholder owes its capacity provider: the business written (premium bordereau) and the claims (claims bordereau) under a binding authority. In Soldek they are a by-product of the book, not a month-end exercise, and they carry everything the platform knows about each line so the insurer's bordereau team never has to come back with questions.
What is in the premium bordereau
- One row per transaction in the period, the way capacity providers read it: new business and renewals incepting in the period, endorsements effective in the period (additional or return premium, with the endorsement number), and cancellations in the period (return premium, with the reason). A policy row says which it is; the Summary sheet subtotals per type.
- Agreement: coverholder, your reference with that insurer (coverholder PIN or agent code, set on the binder), UMR, slip reference, insurer, contract year, binder period, section, class of business and risk code.
- Policy and insured: policy number, insurer policy reference, quote number, product, product category and type, placement, status, inception, expiry, term in days, bound date, renewed-from policy, payment frequency, insured name, type, address and country, and the number of persons on the schedule.
- Distribution: direct or broker, the producing broker and firm.
- Money: sum insured, premium before discount, discount, gross written premium, broker commission model and rate, brokerage, MGA commission rate and amount, net premium to the insurer, policy fee, premium tax rate and amount, total payable, and the policy's payment position (paid, part paid, outstanding, overdue) with the last payment date.
- Underwriting: the underwriter, what the rating engine indicated, the deviation and its reason, the rules outcome, and the number of conditions still open on the policy.
- Schedule products add a Risks sheet: one row per insured person per coverage line (name, date of birth, nationality, occupation, role, employer, contract value, salary, coverage, sum insured, premium, deductible, waiting and benefit periods).
What is in the claims bordereau
Every claim under the binder that was open during the period or notified in it; a closed claim appears one last time in the month it closed with its final figures. Per claim: the agreement block, claim and insurer references, policy, product, insured, broker firm, policy term and limit, date of loss, date notified, days to notify, date closed, whether it is new this period, status, open, denied, cause, description, amount claimed, paid, outstanding reserve, total incurred, settlement date and note. When payments are recorded on your claims, the row also says what was paid in this period and how much of that came from the loss fund, the split into indemnity, expenses and recoveries, what is approved and not yet paid, your claims authority and the insurer's agreement with its date and reference. Each payment is reported once: one that is entered after its month was reported lands on the next bordereau. The summary gives the loss fund replenishment due for the period; record the insurer's reimbursement on the submitted bordereau when it arrives.
The workbook
- Summary: coverholder and agreement, totals, subtotals per transaction type and per section (premium) or the claims breakdown (open, closed, denied, notified this period, paid, reserve, incurred).
- Premium or Claims: the detail, one row per transaction or claim, with a filter row. Risks when any row carries a schedule.
- Columns: the data dictionary — every column with what it is and where it comes from. Send the file as it is; the insurer maps it from that sheet.
- CSV exports the detail sheet alone, for insurers that load bordereaux into their own system.
How they are generated and sent
- Every night the platform checks each active binder for completed months without a premium bordereau and generates what is missing — on the first of the month that is the month that just ended; a missed night is caught up the next. You can also generate one yourself from the Bordereaux screen — pick the binder, premium or claims, and a month (or other dates). A period with nothing written still produces a file: a nil return.
- A binder has exactly one premium and one claims bordereau per period — the database refuses a second, so a double-started job or a colleague generating next to the scheduler never sends the capacity provider the same month twice. To regenerate a period, delete the draft first; a submitted bordereau is final and a correction is reported in the next period's file.
- Each bordereau can be e-mailed to the capacity provider's address from the same screen. Switch on 'Submit the monthly premium bordereau automatically' on the binder and the platform does that on the first of every month: generated, e-mailed to the lead underwriter address, marked submitted and logged.
- Figures tie back to policies, endorsements, credit notes and invoices: a new-business or renewal line carries the premium at inception, each endorsement its own movement (so a change is reported once, on its own line, never again on the policy), a cancellation the return premium — all after the policy's discount, the way the client was billed. The sum insured follows the same rule: the policy line carries the limit at inception, an endorsement line the limit from its effective date. The commission split is the one recorded per line, and tax and fee are the ones on the invoice.