Payment Discrepancy Report
The Payment Discrepancy Report is a primary auditing tool that compares the actual commission received from a carrier against the expected commission calculated by the system. Unlike standard reports that show all data, this report isolates only the payments where the figures do not match, so you can quickly identify underpayments or carrier rate errors.
💡 Why Use This
Use this report when:
- Auditing carrier payments — Confirm that what was received matches your contracted rates.
- Finding underpayments or rate errors — Isolate specific payments where the carrier paid less than expected.
- Catching unexpected bonuses — Identify carrier payments that exceeded the expected amount.
- Combining with A/R tracking — Use the Include Missing Payments option to see both wrong-amount and no-payment situations in one view.
🗺️ How to Access
- Navigate to Reports → Payment Discrepancy Report.
- Select your Carrier, Date Range, and any Tolerance settings.
- Choose your inclusion options (see below).
- Click View Report.
How It Works
To find a discrepancy, the system needs a benchmark to compare against. This is provided in one of two ways:
- Carrier Commission Tables — The system calculates the expected amount based on your contract rates. See Carrier Commission Tables.
- Commission Per Payment — A fixed expected dollar amount entered directly on the policy record.
Setup Required
If neither a Carrier Commission Table nor a Commission Per Payment value is configured, the system cannot determine an expected amount and will not be able to identify discrepancies for that policy.
Report Filters and Settings
Date Range
Filter by Received Date (when you posted the money) or Billing Date (the month the premium was due).
Tolerance
Avoid noise from minor rounding differences by setting a tolerance threshold:
- Percentage — Only show discrepancies greater than a specific percentage (e.g., 10%).
- Dollar Amount — Only show discrepancies greater than a specific dollar amount (e.g., $10.00).
Premium vs. Commission
Choose whether to compare discrepancies in the Agency Commission total or the Client Premium total.
Enhanced Reporting Options
- Include Missing Payments — Shows billing months where no payment was received at all. This combines discrepancy tracking with Accounts Receivable functionality.
- Include All Payments — Shows every payment received, even those that match perfectly. Useful for a complete audit of a specific carrier or agent. While it is ticked the tolerance settings are greyed out, since nothing is being filtered by size.
Saved Settings
The filter screen has a Saved settings row at the top. Set the filters the way you run this report each cycle, type a name and click Save; next time, pick the name and the whole screen fills in. Saved settings are shared by everyone in your company, and the report remembers the last one you used.
- The Presets box under the dates (Last Month, This Year to date, ...) is what a saved setting remembers, together with the Receive Date / Billing Date choice. Choose Custom to save fixed dates.
- The tolerance is remembered in full: Commission or Premium, Percent or Dollar, and both amounts, so the greyed-out amount is still there when you switch the type.
- Everything else on the screen is remembered: the carriers, client, revenue groups, the two include boxes and the grouping.
- Lists left at (Select All) stay "all", so a carrier added later is included automatically.
- Reset puts the whole screen back to the way it opens: Receive Date, last month to today, tolerance on Commission by Percent with both amounts 0, neither include box, grouped by Carrier, every carrier and revenue group, all clients.
See Saved Report Settings for saving, renaming and deleting.
Reviewing the Results
The report highlights the Expected vs. Actual amounts and calculates the Variance (the difference) for each entry.
Discrepancy Report vs. Accounts Receivable
| Report | Primary Focus | Use Case |
|---|---|---|
| Payment Discrepancy Report | Incorrect payments | Identifying underpayments or rate errors |
| Accounts Receivable | Missing payments | Identifying policies that have not paid at all |
🔧 Troubleshooting
A policy constantly shows a discrepancy. Verify that the Term Number and Carrier Commission Table are configured correctly for that policy. A mismatch between the table version and the policy's current term is a common cause of recurring discrepancies. See Carrier Commission Tables.
The report is showing discrepancies on almost every payment. Check whether a Tolerance is set. Without a tolerance, even $0.01 rounding differences appear as discrepancies. Set a reasonable dollar threshold (e.g., $1.00) to filter out noise.
Missing payments are not appearing even with Include Missing Payments enabled. The policy must have a Commission Per Payment value or a Carrier Commission Table assigned for missing payments to be detected. Policies without expected commission values cannot generate A/R or discrepancy entries.
The report shows a bonus payment as a discrepancy. If a carrier paid more than the expected amount, it will appear as a positive variance. Confirm whether it is a legitimate bonus — if so, it can be recorded separately using the Bonus/Override function.
🔗 Related Topics
- Accounts Receivable — Track payments that are missing entirely.
- Carrier Commission Tables — Set up the expected commission benchmarks this report relies on.
- Preset Date Range — Set the reporting period quickly.
Need help? Contact support@commission-tracker.com