Difference between revisions of "Commission Download"

From Agency Systems Wiki
Jump to navigation Jump to search
(added builder link)
(updated how to access DL only)
(3 intermediate revisions by one other user not shown)
Line 9: Line 9:
 
<ul>
 
<ul>
 
<li>[[Direct Bill: Commission Statement Processing]]</li>
 
<li>[[Direct Bill: Commission Statement Processing]]</li>
<li>[[Commission Builder]]
+
<li>[[Commission Builder]]</li>
 +
<li>[[Direct Bill: Adjust Commission for Fees or Agency Bill Payable|Direct Bill Commission Adjustments]]</li>
 
<li>[[Requesting Policy Download Data From Companies]]</li>
 
<li>[[Requesting Policy Download Data From Companies]]</li>
 
<li>[[Certified Download Companies]]</li>
 
<li>[[Certified Download Companies]]</li>
Line 30: Line 31:
 
</tr>
 
</tr>
 
</table>
 
</table>
{{#ev:youtube|j7ptjzfD9Ck|300|right|Commission Download}}
+
{{#ev:youtube|rf899kQmTAE|300|right|Commission Download}}
 
The Newton [[:Category:Direct Bill|Direct Bill]] Commission Download automates the [[:Category:Direct Bill|direct bill]] invoice and payment process. The insurance carrier provides a special [[:Category:Download|AL3 Download]] file that contains full invoice details mirroring the monthly commission statement.  
 
The Newton [[:Category:Direct Bill|Direct Bill]] Commission Download automates the [[:Category:Direct Bill|direct bill]] invoice and payment process. The insurance carrier provides a special [[:Category:Download|AL3 Download]] file that contains full invoice details mirroring the monthly commission statement.  
  
Line 39: Line 40:
 
*A direct bill commission [[:Category:Cash|cash receipt]] is created (or an on-account transaction is used).  
 
*A direct bill commission [[:Category:Cash|cash receipt]] is created (or an on-account transaction is used).  
 
*Each invoice is automatically reconciled, and the system is ready to [[:Category:Payables|reconcile producer payables]].  
 
*Each invoice is automatically reconciled, and the system is ready to [[:Category:Payables|reconcile producer payables]].  
*Commission Statement Download report .PDF file is automatically attached to the company tab.  
+
*Commission Statement Download report .PDF file is automatically attached to the [[Company Tab]].  
  
 
Commission Download is an add-on option within [[:Category:Download|Download]], which will need to be enabled by support if purchased.
 
Commission Download is an add-on option within [[:Category:Download|Download]], which will need to be enabled by support if purchased.
Line 49: Line 50:
 
Validate the [[Producer Profile|producer profile default commission rates]].  Commission download will automatically generate the producer commission based off the commission rate specified in the producer profile.
 
Validate the [[Producer Profile|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 ([[Direct Bill: Create A Check For Return Commission|refunds]]).)''
 
== Commission Download Processing ==
 
== 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.   
 
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.   
Line 60: Line 65:
 
#*List of any MVR Fees reducing direct bill commission or other adjustments.
 
#*List of any MVR Fees reducing direct bill commission or other adjustments.
 
=== Commission Statement Download Review and Processing ===
 
=== Commission Statement Download Review and Processing ===
#Select '''Other -> Download'''.
+
#Select '''Company -> Download'''.
 
#Select the '''Pending Tab'''.  
 
#Select the '''Pending Tab'''.  
 
#'''Right-Click''' on the pending commission statement download and select '''Edit Details'''.  
 
#'''Right-Click''' on the pending commission statement download and select '''Edit Details'''.  

Revision as of 21:54, 7 March 2019

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.