PRACTICAL GUIDE

Cumulative vs activity carrier statements: what are you reconciling?

Before reconciling a carrier statement, establish what its rows and total represent. A period activity report describes changes during a window. An open-item or cumulative view can include older unpaid amounts. Comparing either one with an agency report on a different basis creates differences that may be entirely about scope.

Start with scope, not the statement’s name

Check the carrier, agency account code, period, cutoff, and column definitions. Ask whether the report shows new charges, all open items, previously applied payments, or a mixture. The title alone may not answer those questions.

Questions to ask before matching any rows
ViewWhat it can showWhat you still need
Period activityTransactions within a defined windowOpening balance and activity outside that window
Open itemsAmounts still outstanding at a cutoffOriginal transaction and payment history
Balance roll-forwardOpening balance, changes, and closing balanceThe definitions and signs used for each change

Follow one balance across two periods

Suppose a agency has a $4,000 carrier balance at the end of September. During October it adds $2,000 of new net payables and the carrier applies a $3,000 payment. With no other activity, the October closing balance is $3,000.

Sample data.
ComponentAmountMeaning
September closing / October opening$4,000Existing balance carried forward
October new net payables+$2,000New activity in this period
October payment applied($3,000)Reduction already reflected in closing balance
October closing balance$3,000$4,000 + $2,000 + ($3,000)

Adding the September and October closing balances would produce $7,000 and count part of the history twice. Subtracting the same $3,000 payment again from October’s closing balance would create the opposite error. Keep a balance, a transaction, and an applied payment in distinct columns.

Put both sides on the same basis

  1. Choose the same carrier account and cutoff for both reports.
  2. Identify whether each amount is gross premium, net payable, original charge, or remaining balance.
  3. Pair the policy or bond reference with the transaction type and date. A reference can have several transactions.
  4. Trace prior payments to their application, including payments posted after the statement cutoff.
  5. Keep an unresolved item with its explanation and owner so it can be reviewed again next period.

Save the source statement and the agency report with the reconciliation. A short note explaining the scope can prevent the next reviewer from reopening a difference that has already been understood.

Common questions

Is account current the same as cumulative?
Not necessarily. Account current describes a settlement arrangement; the statement may have a different scope.
Why can one item appear on two statements?
An unpaid item may carry forward. Confirm whether the later row shows an existing open balance or new activity.
Should I subtract prior payments from the closing balance?
Only if the defined balance has not already incorporated those payments. Confirm the statement’s calculation before subtracting.

LET’S TALK ABOUT YOUR WORKFLOW

See what this looks like for your agency.

Tell us about your systems, reports, and the work you want to make easier. We’ll start there.