Free companion page

Companion page: The MGA Handbook

Free to print: 8. Monthly Bordereau and Reconciliation Checklist, from The MGA Handbook.

This page is free and needs no sign-up. It reproduces material from The MGA Handbook by Julian R. Sterling so you can print it or keep it open while you work.

To print it, use your browser's print button. Figures are as stated in the book; check the official source before relying on any of them.

8. Monthly Bordereau and Reconciliation Checklist

When to use it: every month, before anything is sent to the carrier.

Each monthly premium bordereau carries, per policy: policy number, insured, state, class, gross receipts, limits, effective and expiry dates, premium, commission and transaction type. The claims bordereau comes from the claims service.

Monthly steps:

  1. Close the month in the policy system and freeze the data.
  2. Run completeness checks: no blank class, state or receipts field.
  3. Reconcile the bordereau total to written premium in the system.
  4. Reconcile premium collected to the fiduciary trust account.
  5. Compute premium net of commission owed to the carrier.
  6. Send the bordereau by the 15th of the following month.
  7. Remit by the last day of the following month.
  8. Log the date sent and the date received for each file.

The case audit found 3 of 8 monthly bordereaux of 2024 sent more than 15 days late, and one premium remittance 12 days late. Bordereaux were assembled in spreadsheets at the time. After the remediation plan they were produced from the system.