Bordereau Reports
Overview
Section titled “Overview”A bordereau is a detailed listing of all policies written within a period, organized by state. It is the standard report format used to report premium to your carrier partners. Run this report monthly or quarterly, or whenever the carrier requests a premium reconciliation.
Navigating to Bordereau Reports
Section titled “Navigating to Bordereau Reports”Reports menu with Bordereau highlighted, showing the path: Reports > Bordereau Reports
Go to Reports > Bordereau from the main menu.
Filtering the Report
Section titled “Filtering the Report”Bordereau filter panel showing date range picker, state dropdown, product line filter, and Run Report button
Set your filters before running the report:
- Date Range — Select the reporting period (monthly, quarterly, annual, or custom)
- State — Run for a specific state or all states
- Product Line — Filter by line of business or include all lines
Click Run Report.
What the Report Shows
Section titled “What the Report Shows”Bordereau report table showing columns for policy number, insured name, state, effective date, expiration date, gross premium, taxes and fees, commission, and net premium
Each row is one policy. The columns include:
| Column | Description |
|---|---|
| Policy Number | The issued policy number |
| Insured Name | Named insured |
| State | Policy state |
| Effective Date | Coverage start date |
| Expiration Date | Coverage end date |
| Gross Premium | Total premium charged |
| State Tax | Surplus lines tax |
| Stamping Fee | State stamping fee |
| Commission | Producer commission |
| Net Premium | Amount due to carrier |
The report totals all columns at the bottom.
Exporting and Submitting
Section titled “Exporting and Submitting”Click Export to Excel to download the bordereau. Carriers typically require the Excel format for reconciliation.