Your AMS Says One Thing, the Carrier Paid Another: Working the Gap

The argument usually starts with a report from the agency management system (AMS). The carrier deposit does not match it. Both documents can be "right" and still describe different moments.

Compare report dates

Madgeek says EZLynx reports fail to match carrier data because the report and the carrier statement are different snapshots, taken at different times. For example, suppose you ran the commission report on the 8th. The carrier built the statement on the 11th. A cancellation, a rewrite or an additional premium landed in one of those windows and not the other. Check which changes each file includes.

Write the as-of date on both. "EZLynx commission report, pulled March 8" and "Carrier statement, generated March 11" can disagree by every policy that changed in those three days. List those changes before deciding which amount is due.

Reconcile booked commission against payment

Kite Technology's transaction-report guide describes a report that tracks commission by policy to check whether it arrived as expected. Kite's direct-bill notes explain the recording and reconciliation workflows. In Applied Epic, "Record commissions" adds items from a carrier statement when those items are not already in the system. "Reconcile commissions," used when the agency is on an accrual basis, compares items already in the system with the statement.

A commission-tracking report can be complete and still be a poor answer to "what did the carrier pay." If your close uses the report as the statement, you pay the expected amount and find the difference when the deposit is short. The monthly close checks the deposit against the statement.

The same Kite direct-bill notes distinguish cash-basis recording from accrual-basis reconciliation. Accrual asks what the agency has earned and booked. Cash asks what arrived. A carrier statement is closer to cash. It is the carrier's list of what it is paying now. An accrual report may include earned commission the carrier has not yet paid. Identify that timing difference before comparing the totals. That difference is not a missing check until the terms say the money should already have been sent.

Ask two questions.

• What did we book as earned?
• What did the carrier pay, on this statement, into this deposit?

If you only answer the first, you are not reconciling.

What one agency reported about commercial lines

HawkSoft published an agency story that compares EZLynx with HawkSoft. In the testimonial, Emmanuel Osuyah of Alpha Direct Agency says EZLynx lacks "the bells and whistles for Commercial account management." That is one customer's account on a vendor's site. If commercial lines are difficult to report in your system, check those lines against the carrier statement.

Work beside the system you have

Start with the two files available to you. Export the book, or the commission report, from the agency management system. Upload the carrier statement. Reconcile those two artifacts. The export is a CSV the agency already knows how to produce. That is the connection CommissionScope ships. Direct sync with an agency management system, including EZLynx, Applied Epic and HawkSoft, is custom work or later work.

What the side-by-side pass can show:

Exact policy-number matches can move forward. Anything fuzzier stays in human review. A correction to an extracted amount does not silently accept the match.

Suppose the Epic report on the 8th says $22,400 in direct-bill commission and the statement on the 11th pays $21,150. Investigate the $1,250 gap by listing policy changes and rate differences. Maybe $900 is a cancellation the carrier processed on the 10th, and $350 is a rate the statement paid below the schedule. Those are two different open items. One may clear when you accept the cancellation. The other is a phone call. Netting them into one number hides the item that needs a call.

Reconciliation checklist

• Write the as-of date on the management-system export and on the statement.
• Say whether each total is cash or accrual.
• List policies present on only one side. The missing-policy check is that list, started from the book.
• List policies on both sides where the commission differs.
• Separate "changed after the export" from "paid at the wrong rate."
• Do not pay from the report. Pay from the reconciled statement lines a person approved.
• Do not plan the close around a sync you do not have.

Bring the export and one carrier statement to a guided pilot. The point is to see the gap on your own files. You review the matches. You approve the batch. No payout file is produced before that, and no management system is synced in the process.