The numbers an underwriter runs on, from commission to cover by state
Qlik as the engine for Bascule Underwriting's finance and reporting, from agent commission and payments to policies and prices state by state, and reporting built into PolicyHub: commission, statements, renewals and quote performance.
- Client
- Bascule Underwriting
- Built
- Finance and underwriting reporting
- In
- Qlik and PolicyHub
- Covers
- 48 states
Commission across every agency, prices across every state.
The problem. Bascule writes business through agencies across 48 states, so finance needs each agency's commission and payments, and underwriting needs policies and prices state by state. The data starts in FileMaker, which is built for running policies one at a time, not for adding up thousands of them.
The approach. We set up Qlik as the reporting engine on top of FileMaker, for commission, payments, policies and prices by state. As PolicyHub grows, the reports Bascule's team uses every day are built into it, on the same records the team works from.
PolicyHub's commission analytics, rebuilt with invented figures: the filters; payments received, Bascule's margin, the effective commission rate, agencies with activity and the top five agencies' share for the last twelve months; agent commission month by month against the year before; the split of payments between agent, Bascule and reinsurer; and commission by agency, by division and product.
The year at a glance
Payments, Bascule's margin and the effective rate, against the year before.
Where every payment goes
Each one split between the agent, Bascule and the reinsurer.
Agency by agency
Commission for every agency, by division and by product.
Policies and premium, state by state
Written premium and policies for each of the 48 states Bascule writes in, darker where more is written. Choose a state for its figures.
Written premium, last 12 months
What the reporting shows
Qlik for the finance view across the business, and reports inside PolicyHub for the day-to-day.
- Agent commission and payments, agency by agency, in Qlik
- Policies and prices across the states Bascule writes in, in Qlik
- Commission analytics in PolicyHub: payments received, Bascule's margin, the effective rate and the split between agent, Bascule and reinsurer
- Commission by agency, by division and by product, with a data check that flags what needs a decision
- Monthly statements: opening, payments, adjustments, commission and closing, and what drove the month
- Renewal and past-due reports, and quote performance from the funnel to underwriting turnaround
- Agency reports for E&O cover and licences, expired or expiring soon
- PostHog across the website, the portals and PolicyHub
Where it stands
Finance and underwriting work from Qlik, and more of the day-to-day reporting now sits inside PolicyHub, beside the policies and claims it describes.
Each new report is built on the records the team already works in, so the numbers and the work never drift apart.
What we used
- QlikFinance and reporting: commission, payments, policies and prices by state
- FileMakerWhere the policy and invoice data starts
- SupabasePolicyHub's commission ledger and the reports on it
- Next.jsThe reports inside PolicyHub
- PostHogHow the website, the portals and PolicyHub are used
