Fictional sample report from Fair Agents, written by the check on made-up files. Every person, business and number is invented. Names of real systems and marketplaces only show which export the made-up file imitates. Back to all samples

Commission statement check

13 statement line(s), 3892 paid against 3089.7 expected: 2 underpaid by 307.2, 1 overpaid by 20.5; 2 possible duplicate(s), 1 not in your policy list, 1 with no expected rate.

By status

StatusCount
underpaid2
possible_duplicate2
overpaid1
no_policy1
no_rate1
not_checked1
ok5

By carrier

CarrierCountPaidExpectedshortover
Sample Casualty3194421002520
Example Mutual71082.5892.255.220.5
Demo Indemnity297.597.500
Test Fire & Marine1768000

All rows (13)

StatusCarrierPolicyTransactionPremiumexpected rateExpectedPaidDifferenceDetail
underpaidExample MutualPA-5521800new184015276220.8-55.2Paid 220.8 on premium 1840; 15% (schedule: Example Mutual Personal Auto new) is 276, so 55.2 short (the statement shows 12%).
underpaidSample CasualtyWC-88120new126001012601008-252Paid 1008 on premium 12600; 10% (schedule: Sample Casualty Workers Compensation new) is 1260, so 252 short (the statement shows 8%).
possible_duplicateExample MutualHO-7730288endorsement2401536360The same endorsement line for HO-7730288 (36) appears 2 times.
possible_duplicateExample MutualHO-7730288endorsement2401536360The same endorsement line for HO-7730288 (36) appears 2 times.
overpaidExample MutualUMB-9002renewal4101561.58220.5Paid 82 on premium 410; 15% (schedule: Example Mutual Personal Umbrella) is 61.5, so 20.5 more than expected.
no_policyExample MutualPA-5599999new1500225PA-5599999 is not in your policy list.
no_rateTest Fire & MarineCA-20441new6400768No expected rate for Test Fire & Marine cauto new in the schedule, and none booked on the policy.
not_checkedSample CasualtyWC-88120audit1096No premium on the audit line to apply 10% to.
okSample CasualtyBOP104455renewal480017.58408400
okDemo IndemnityCGL-330017cancellation-325015-487.5-487.50
okDemo IndemnityCGL-330017new3900155855850
okExample MutualHO-7730141renewal221015331.5331.50
okExample MutualPA-5521911renewal126012151.2151.20

Limits

Written by a Fairpolicy agent from your files on this computer. Nothing was bound, cancelled, endorsed, sent or paid. This page contains client information: keep it in your secure folder and do not e-mail it.