Broker accounts and bordereaux

Some brokers and partners collect premium from their clients and pay it over to you; some handle whole books of business and report them in lists called bordereaux.

Broker remittances

When a broker sends money, record it on the broker's page (Record premium received) or under Distribution > Broker remittances. The money clears the open invoices of their clients' policies, oldest first.

If the broker keeps commission and sends the net premium (set on their page), each invoice is cleared in full for the premium less their commission, and that commission is marked as paid, so it is not paid twice in the next payout. The commission rate is the one booked on the policy.

Money that does not cover a whole invoice clears part of it. What is left over stays unallocated: use Allocate the rest to clear a specific invoice with it. Invoices cleared shows how each remittance was used.

Broker account shows a broker's position: billed on their policies, received, commission kept, money not yet allocated, and what is still owed by age (not yet due, 1-30, 31-60, 61-90 and over 90 days late).

Bordereaux from partners

A partner who sells under your name (a travel agency, a bank, a retailer) sends a monthly list of the policies and premiums they wrote, and another of the claims. Distribution > Bordereaux > Templates downloads the column layout.

Import a bordereau, choose the partner, the kind (premium or claims) and the file (Excel or CSV):

• Premium: each row is matched on the partner's policy reference. A new reference creates the customer (if needed), the policy, an invoice due after the partner's credit days, their commission and the reinsurance cession. A known reference updates the policy: a change in premium creates a debit or credit note and adjusts commission and reinsurance; a cancellation date cancels it.
• Claims: each row is matched on the partner's claim reference and attached to the partner's policy. Amounts paid are recorded and ceded to reinsurers.

Rows with a problem (a missing field, an unknown product or policy) are skipped and listed under Problems; the others are kept. Fix the file and import it again: rows already in are updated, not duplicated.

Bordereaux to partners and reinsurers

Send a bordereau downloads the list for a period: for an intermediary, their policies (with commission) or claims; for a reinsurer or co-insurer, everything ceded to them, premium or claims. Each one sent is logged in the list.