Managing commission allocation

Last updated: March 5, 2026

Manual commission allocation ensures insurance revenue is accurately recorded, fairly distributed, and properly tracked, supporting both financial management and producer compensation. Without proper allocation, agencies may experience:

  • Accounting misstatements

  • Difficulty reconciling payments

  • Errors in producer payables

This article explains how manual commission allocation works in amplo and how to manage it effectively.

Single commission entry

View available commissions

  1. In the App Launcher, search and select Commission Allocation.

    Screenshot 2026-03-04 at 10.07.53 AM.png
  1. Select the Billing Company from the dropdown.

    Screenshot 2026-03-04 at 10.09.09 AM.png
  2. Search the commission list, if needed.

  3. Check the checkbox(es) next to each policy you want to allocate commission to.

Screenshot 2026-03-04 at 10.11.06 AM.png
  1. Enter the total Agency Commission amount.

Screenshot 2026-03-04 at 10.12.07 AM.png

The system automatically calculates each policy’s aggregate percentage.

  1. Click Update.

Screenshot 2026-03-04 at 10.12.46 AM.png
  1. In the confirmation modal, click OK.

Screenshot 2026-03-04 at 10.13.09 AM.png

Cash receipt attachment

  1. In the App Launcher, search and select DB Statement Processing.

  2. Select the Agency and Billing Company to view policies and allocated commissions.

Screenshot 2026-03-04 at 10.15.24 AM.png
  1. In the Cash Receipt column, select the appropriate cash receipt.

image.png
  1. Click the Apply selected billings to cash receipt(s) button to update the cash receipt and record payment on each policy.

Screenshot 2026-03-04 at 10.17.11 AM.png

Note: Selecting a Commission Effective Date will determine the billing date of the commission. The allocation will still be recorded in the current Accounting Period.

Bulk import commissions

You can also import commission data using the carrier’s commission statement file.

  1. In the App Launcher, search and select IVANS Commission Download Details.

    Screenshot 2026-03-05 at 8.31.23 AM.png
  2. Click Import.

Screenshot 2026-03-05 at 8.34.00 AM.png
  1. On the DataLoader screen, click IVANS Commissions Download Details on the Custom objects tab.

    Screenshot 2026-03-05 at 8.35.24 AM.png
  2. Click Add new records. Adjust your mapping selections according to your prepared file.

Screenshot 2026-03-05 at 8.36.18 AM.png
  1. Upload commission report in CSV format, ensuring that the following fields are populated:

    1. Account ID

    2. Policy ID

    3. Effective Date

Note: For guide on how to achieve this type of report, see 📄 Using cross filters in reports.

  1. Click Next.

image.png
  1. To adjust the mapped fields, click Map in the Edit column.

Screenshot 2026-03-05 at 8.42.40 AM.png
  1. Select the appropriate mapping, then click Map.

Screenshot 2026-03-05 at 8.44.09 AM.png
  1. Click Next.

  2. Review the import information, then click Start Import.

image.png
  1. Any unmatched items can be reviewed and corrected manually.

Match unmatched commissions

If imported commissions do not automatically match a policy, they appear in the Commission Inbox.

  1. In the App Launcher, search and select Commission Inbox.

    Screenshot 2026-03-05 at 8.46.09 AM.png
  2. On the Commissions Download Inbox page, locate the appropriate policy in the System Policy column.

    Screenshot 2026-03-05 at 8.49.56 AM.png
Screenshot 2026-03-05 at 8.50.23 AM.png
  1. Select the checkbox in the Add column. Repeat this process for all unmatched commissions.

  2. Click Update.

Screenshot 2026-03-05 at 8.52.48 AM.png

Once reconciled, the system posts the commissions a Direct Bill Statement is created along with the associated billings.