Carrier Reconciliation Guides ·
How to Reconcile Travelers Commission Statements: Step-by-Step Guide
A practical Travelers reconciliation walkthrough for independent insurance agencies: find your commission records, compare policy-level payments, investigate differences and build a repeatable close process.
Based on publicly available carrier documentation. Exact portal menus, file formats and commission terms can vary by agency and appointment.
1. Locate your Travelers commission statement
Documented access: Travelers' public materials say agents can access commission statements online through Agent HQ. Its producer compensation disclosure distinguishes base commissions from contingent compensation, fixed value-based compensation, production incentives and other compensation. Travelers also publishes an EFT authorization form covering monthly commissions and other agency compensation.
For authorized users, begin with Agent HQ. Choose the statement or compensation report for the period you are reconciling. If your account offers a download, save the original statement before editing or converting anything. If no export is available, contact your agency administrator or carrier support rather than trying to bypass restricted access.
Travelers' publicly accessible direct-bill document is an older program-specific reference, not a guarantee that every product follows the same payment timing. Confirm current payment terms for your agency and line. Agent HQ navigation and available exports may differ by access permissions.
Write down the statement period, agency or producer code, reporting entity, report date, and total. Preserve the original file alongside any cleaned copy. If the carrier issues separate statements for different lines, offices or writing codes, reconcile each group before consolidating.
2. Build the expected commission ledger
Export your agency management system or internal tracker for Travelers policies in the statement window. Include policy number, insured or account name, effective date, transaction type, commissionable premium, expected carrier rate, expected commission, and assigned producer.
Expected commission is a control number, not proof that a carrier owes money. Verify whether the amount is based on written, billed, earned or collected premium under the applicable agreement. Include negative adjustments and prior-period corrections. A missing ledger row may be a data problem rather than a carrier problem.
Travelers notes that commission percentages may vary by type of business, risk and state. Verify the actual applicable schedule instead of applying a single rate to every Travelers policy.
3. Clean and match statement transactions
Keep the raw statement unchanged. In a working copy, normalize dates and currency fields, preserve policy numbers as text (including leading zeros), and record the source agency code. Carrier exports may use different column names; map the fields based on what your actual file contains, not a guessed template.
Match on the strongest available combination of policy number, transaction type, period, insured, and amount. Avoid treating every repeat policy number as a duplicate: one policy can produce a renewal, endorsement and cancellation in the same reporting cycle.
Keep base policy commissions separate from contingent compensation, incentive payments and other non-policy amounts. Otherwise an agency may mislabel a legitimate bonus as an unexplained commission overpayment.
When policy numbers differ because of rewrites or formatting, confirm the match against supporting policy records before merging. Unmatched carrier transactions and unmatched expected transactions belong in separate exception queues.
4. Calculate variances with a worked example
The following is an illustrative training example, not an actual Travelers statement or a claim about Travelers commission rates. It demonstrates the reconciliation math only.
| Policy | Transaction | Premium | Rate | Expected | Reported | Variance |
|---|---|---|---|---|---|---|
| ABC-1001 | New business | $1,200 | 12% | $144.00 | $144.00 | $0.00 |
| ABC-1002 | Renewal | $1,500 | 10% | $150.00 | $120.00 | $30.00 |
| ABC-1003 | Cancellation adjustment | — | — | -$45.00 | -$45.00 | $0.00 |
Here, expected minus reported equals the variance. Policy ABC-1002 has a $30 positive variance ($150 expected less $120 reported). Investigate premium adjustments, effective dates, applicable rates and payment timing before classifying it as underpaid. The $45 negative adjustment is shown on both sides, so it is not an unexplained discrepancy.
If one carrier statement line contains several installments or adjustments, compare the appropriate grouped total instead of forcing a one-to-one match. Keep a reference to every underlying row so that a reviewer can reconstruct the result.
5. Investigate Travelers exceptions
Separate the exception list into: missing expected payments; unexpected carrier rows; rate or premium differences; chargebacks and cancellations; duplicate-looking records; and timing differences. Assign an owner and review date to each item. A red variance cell is a starting point, not a conclusion.
For a suspected shortfall, check the current policy declarations, endorsements, billing or payment status, contract schedule, and prior statements. For a negative adjustment, confirm whether a cancellation, rewrite or premium decrease explains it. For an apparent duplicate, compare transaction references and posting dates.
When you contact carrier compensation support, include the agency code, statement period, policy reference, transaction date, expected and reported amounts, and a concise explanation. Avoid sending unnecessary policyholder personal information by unsecured email.
6. Reconcile the statement total to the bank deposit
After policy-level exceptions are classified, add all statement amounts—including negative adjustments—to reach the carrier's net statement total. Compare that total with deposits or remittance notices for the appropriate period. A deposit can cover several statements or arrive in a later bank period, so document timing differences.
Do not change individual policy amounts just to make a deposit tie out. Record separate adjustments or remittance differences and investigate them with the source documents. When compensation includes non-policy amounts, such as bonuses or incentives, track them in their own category rather than distributing them across unrelated policies.
7. Reconcile producer splits and close the period
Once carrier amounts are verified, calculate producer payouts under your agency's effective-dated split agreements. A producer's split may vary by policy line, transaction type, producer or contract date. Use the correct version of the agreement, not today's default rate, when reviewing historical transactions.
Close with a record of the source statement, expected ledger, reconciliation report, exceptions, follow-up owners, deposit comparison, and producer approvals. Carry unresolved items into the next cycle without erasing them. Reconciliation is a repeatable process, not a one-time spreadsheet cleanup.
If you reconcile several carriers, use the same exception definitions and review cadence across all of them while preserving carrier-specific commission rules. That makes cross-carrier reporting more useful without pretending that every carrier statement has the same structure.
How SplitVerde fits the workflow
For Travelers, the practical goal is to spend less time reformatting statements and more time identifying commissions that need attention. SplitVerde supports imports of CSV, Excel and supported text-based PDFs, expected-versus-actual comparisons, discrepancy review and producer payout organization. Some file layouts require mapping or manual review; direct Travelers integration and universal PDF compatibility are not claimed.
Begin with one statement period and a clean expected ledger. Check the imported fields, validate a few known transactions, review the exception list, then expand the process after you trust the results. The software can speed up comparison, but carrier contract interpretation and final approval remain with your agency.
Frequently asked questions
Does Travelers pay only base policy commissions?
No. Travelers publicly describes base commissions plus several other potential compensation arrangements, including contingent and production incentive programs. Not every producer qualifies for every type.
Can SplitVerde import every Travelers statement automatically?
Not necessarily. SplitVerde supports CSV, Excel and supported text-based PDF imports, with mapping or manual review where needed. Carrier-specific layouts and scanned PDFs are not guaranteed to work.
Is a missing commission always an underpayment?
No. Check the carrier payment cycle, premium collection, effective date, cancellations, agency code and contract terms before concluding a payment is owed.
How should I handle a commission chargeback?
Record the negative transaction separately, link it to the original policy and payment when possible, and confirm the reason and period before adjusting expected commissions.
Official references and limitations
Carrier-specific statements and portal menus may require an appointment and login. These links support the documented facts above; they do not verify every account's current file format or commission schedule.
- Travelers direct-bill overview ↗
- Travelers producer compensation disclosure ↗
- Travelers monthly commission EFT form ↗
- Travelers Agent HQ support ↗
Independent educational guide. SplitVerde is not affiliated with or endorsed by Travelers or its parent companies. Carrier trademarks belong to their respective owners.