What a principal asks on the first of the month

Overview

One screen answers it: commission earned, what has actually arrived and what has not, what is still owed out to producers, the value of the book, retention, and the exception checks that cost money quietly — commission that never came, a statement line nobody could place, a policy expiring with nothing done about it. Every figure opens the records it was added up from.

The shortfall, carrier by carrier

Expected against received by accounting month, the percentage each carrier has actually paid of what it owes, and the exception queue split by why each item failed.

Today, yesterday, this week - on every list

Policies, prospect x-dates, commission entries, carrier statements and their lines, the not-received and exception queues, fee lines and client requests all carry the same eight windows, and the overview takes eleven of them - each compared against the window of the same length immediately before it.

New business production

Premium volume, agency commission and gross profit by producer and year, on the new-business filter — the league table read before a sales meeting.

Aged receivables and payables

What the insured owes us, what we owe the carrier and what a finance company owes us, in ageing buckets on one screen — because a brokerage is short of cash in both directions at once.

Loss ratio by carrier

Incurred against earned premium by carrier and class, read off the loss runs the carriers sent, so a renewal negotiation opens with the losses.