Commission Download

From Agency Systems Wiki
Jump to navigation Jump to search
Related Pages
Related Categories
Commission Download

The Newton Direct Bill Commission Download automates the direct bill invoice and payment process. The insurance carrier provides a special AL3 Download file that contains full invoice details mirroring the monthly commission statement.

After Newton imports and processes the the commission statement download:

  • Invoices are created for each line-item in the commission statement.
  • The invoices are created with agency commission rates specified by the carrier.
  • Producer commissions are added to the invoice based on the default commission rates in the Producer Profile.
  • A direct bill commission cash receipt is created (or an on-account transaction is used).
  • Each invoice is automatically reconciled, and the system is ready to reconcile producer payables.
  • Commission Statement Download report .PDF file is automatically attached to the Company Tab.

Commission Download is an add-on option within Download, which will need to be enabled by support if purchased.

Commission Download Setup

Verify which companies offer Commission Statement Download. It is important to know which carriers do not offer Commission Statement Download, as those paper statements will be handled separately.

Contact your companies and request Commission Statement Download.

Validate the producer profile default commission rates. Commission download will automatically generate the producer commission based off the commission rate specified in the producer profile.

Security System requirements.
  • Other -> Security System -> AR -> Policy Transaction -> Create (Required to create policies and invoices.)
  • Other -> Security System -> AR -> Cash Transaction -> Create (Required to create new cash transactions.)
  • Other -> Security System -> AP -> Check Transaction -> Create (Required to create new check transactions (refunds).)

Commission Download Processing

Commission Statement Download files are received in the same manner as daily policy downloads. Follow the Daily Process for Policy Downloads to import the download files.

The Commission Download files will be displayed in Other -> Download -> Pending as "Suspended".

Commission Statement Download Pre-Processing

  1. Close prior months to prevent accounting transactions in previous months.
  2. Gather the following information for each suspended commission statement:
    • Date the deposit was received in your bank account if received as EFT.
    • Total amount of the commission received.
    • List of any MVR Fees reducing direct bill commission or other adjustments.

Commission Statement Download Review and Processing

  1. Select Company -> Download.
  2. Select the Pending Tab.
  3. Right-Click on the pending commission statement download and select Edit Details.
  4. Select Edit Details/Payment Details to review the payment options.
  5. Select Create a New Cash/Check Transaction and verify the bank. (Select Use an Existing Cash/Check Transaction if an on-account cash was entered prior to receiving the download file. )
  6. Verify the total commission Amount, and enter any Direct Bill Commission Adjustments.
  7. Select Set All Invoice Dates to specify a specific day for all pending invoices. (Recommended)
  8. Select OK when finished.
  9. Select Show Errors....
  10. Clear any remaining Commission Notes and Errors.
  11. Close the commission statement download to return to the pending tab.
  12. Right-Click on the pending commission statement download and select Release this Item.
  13. Right-Click on the pending commission statement download and select Process this Item.

In a single step, Commission Download will create (or use an existing) a cash transaction, create the invoices, and apply the cash/check transaction to the invoices.