Before renewing an acquisition budget, reconcile later commission adjustments with the business that produced the original receipts. A deposit total alone cannot explain which source gained or lost value. Use a small ledger to connect each adjustment to its supporting record, preserve unresolved differences and show the owner how the revised evidence changes the spending decision.
Set The Reporting Basis Before Matching Transactions
For this operating worksheet, measure net actual receipts: verified cash received for the selected business, reduced by settled deductions and increased by settled positive corrections. Keep expected compensation and unresolved statement entries separate. Ask the finance owner to reconcile this management view with the agency's accounting; the worksheet does not determine revenue recognition or tax treatment.
Choose a stable reference for the original policy or transaction and its acquisition source. Preserve the original reporting period when later information arrives. An adjustment posted this month may belong to business acquired earlier. Assigning it to the newest campaign merely because the dates match can distort both campaigns.
Keep A Row For Every Movement
Record the statement reference, original transaction reference, signed amount, stated reason, statement date, settlement evidence and matching status. Link the supporting documents in the controlled finance system. Use internal references in the marketing summary so owners can inspect source economics without copying customer details into another spreadsheet.
Add corrections as new linked entries. Preserve the earlier record and explain the change. If a statement already reports a net payment, connect its component entries to that payment without counting the payment again as additional revenue. A repeated import should identify an existing entry rather than create another deduction.
Reconcile A Mixed Deposit
Illustrative example: an older acquisition group previously produced $7,200 in verified receipts. A later $2,600 deposit comprises $3,000 for new business, a $600 deduction tied to the older group and a $200 positive correction for that same group. The components reconcile: $3,000 minus $600 plus $200 equals $2,600.
The older group now has $6,800 in net actual receipts; the new group has $3,000. Together they equal the original $7,200 plus the later $2,600. With $4,100 of recorded acquisition expense for the older group, its cash remainder after that expense falls from $3,100 to $2,700, before service costs and other expenses. These invented figures describe no standard commission arrangement.
Resolve Exceptions Without Guessing Their Source
Suppose the same illustrative statement also shows a $150 adjustment that has not settled. Keep it in an open-adjustments view with its evidence and owner; it does not yet change net actual receipts. If settled cash cannot be matched, show it in the cash reconciliation as unallocated rather than assigning it to the nearest-looking policy.
Have the responsible finance or carrier-contact owner investigate conflicting references, reasons and amounts against the actual agreement and records. The ledger does not establish whether a deduction is valid or recoverable. Record the question, response and resolution evidence. Keep disputed amounts visible even when someone expects a favorable correction.
Use The Reconciled View At The Budget Review
Present the original receipts, settled changes, revised net receipts and remaining exceptions together. Retain the earlier report so the owner can explain why a source's apparent contribution changed. Investigate whether repeated differences follow a particular transaction type, recording error or source pattern before attributing them to marketing quality.
Choose a concrete action: continue the purchase, reduce exposure while a material mismatch is resolved, or repair the matching process before comparing sources. Include the cost of investigating adjustments in the operating review. A budget decision should use the reconciled evidence available and state which open items could change it.
Common Questions
Should A Commission Adjustment Change The Original Lead Count?
An amount change alone does not establish that the original inquiry count was wrong. Keep acquisition volume, policy status and compensation movements as separate measures, and correct each only when its own evidence supports the change.
Can The Marketing Dashboard Replace The Commission Statement?
No. Use the dashboard as a summarized decision view linked to the authoritative finance records. Preserve the statement, settlement evidence and matching history so a reviewer can reproduce the result and investigate differences.