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

Click Reset to put the whole filter screen back to the way it opens.

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.

Accounts Receivable filter screen with a saved setting applied

  • The A/R Cut Off Date is saved as "today" when you leave it at today's date, so the setting means "as of the day you run it". Any other date is saved as typed.
  • The Period box beside the Billing Date range (Last Month, This Year to date, ...) is what a saved setting remembers when the range is ticked. Choose Custom to save fixed dates.
  • Everything else on the screen is remembered: the carriers, primary agents, client, revenue groups, policy statuses, the months overdue, the $0 expected commission box and the grouping.
  • Lists left at (Select All) stay "all", so a carrier or agent added later is included automatically.

See Saved Report Settings for saving, renaming and deleting.

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