Skip to content

Accounts Receivable (A/R)

The Accounts Receivable (A/R) report itemizes exactly how much commission is outstanding for each policy. Use it to track delinquent carrier payments and ensure your agency is paid what it is owed.

💡 Why Use This

Use this report when:

  • Tracking delinquent payments — Identify which carriers have not sent expected commissions.
  • Auditing outstanding balances — View an itemized list of commissions due by policy.
  • Monitoring aging — Use the Months Overdue filter to see how long payments have been outstanding.

This report is different from the Payment Discrepancy report, which tracks payments that were received but for the wrong amount.

🗺️ How to Access

  1. Navigate to Reports → Accounts Receivable.
  2. Choose your Filter Options (Carrier, Agent, Revenue Group, etc.).
  3. Set Months Overdue if you are looking for older outstanding debt.
  4. Click View Report.

Training Video

If the video below does not play, please copy and paste this link into your browser: Watch on YouTube

Report Options and Filters

  • Primary Groups — Filter by Carrier, Client, or Primary Agent.
  • Revenue Group — Limit the report to specific business units or revenue types.
  • Months Overdue — Filter by the age of the balance to surface the oldest outstanding debt first.

A/R Filter Options

Key Requirements and Logic

Expected Commission Logic

The A/R report relies entirely on Expected Commission values.

  • Setup required — If you have not set up a Carrier Commission Table or set the Commission Per Payment value directly on the policy, the system cannot calculate what is owed and the policy will not appear in this report.
  • Partial payments — If a partial payment is recorded, the system automatically deducts it from the Expected Commission and shows only the remaining balance.

A/R Logic and Partial Payments

Termination Rules

Policies with a status of Terminated have specific behavior on this report:

  1. After the Termination Date — Policies do not appear for billing periods after their Termination Date.
  2. Prior commissions — If a payment was due in the same month as or prior to the termination, it will still appear as outstanding if it has not been paid.

Termination Behavior Example

What Happens When a Payment Is Received

  1. The amount received is applied against the Expected Commission.
  2. If paid in full, the policy is removed from the A/R report.
  3. If partially paid, the remaining balance continues to show as outstanding.

🔧 Troubleshooting

A policy is missing from the A/R report. The most likely cause is that no Expected Commission is set for that policy. Check the policy record to confirm a Commission Per Payment value or a Carrier Commission Table is assigned. Without one of these, the system has nothing to compare against and will not generate an A/R entry.

The report includes Bonus or Override payments. It should not — the A/R report focuses on regular recurring commissions only. If bonus amounts are appearing, verify that those entries were not posted as standard commission payments. Bonuses should be entered using the Bonus/Override function.

I need to see the total outstanding for a specific carrier. Use the Carrier filter to limit the report to that carrier, then look at the report footer for the grand total of outstanding commissions.

A terminated policy is still showing on the report. Check the policy's Termination Date. If a payment was due in the same month the policy was terminated or earlier, it will remain on the report until the payment is recorded. Once the payment is posted, the balance clears automatically.

Need help? Contact support@commission-tracker.com