To reconcile a commission statement, the total of the matched line items must match the total of the commission statement. To accomplish this, all line items must match a policy in EZLynx. If any unmatched line items exist on a statement, they must be manually matched to the appropriate policy. Chargebacks and carrier fees often have to be manually added as a line item and matched to the “dummy chargeback” applicant.

TABLE OF CONTENTS

• Importing a Commission Statement
• Manually Creating a Commission Statement
• Working a Commissions Statement
  • Step 1 - Find the Statement
  • Step 2 - Unmatched Commissions
  • Step 3 - Add Chargebacks & Carrier Fees (if needed)
  • Step 4 - Update, Approve, & Finalize

Importing a Commission Statement

CSV file import is an option for recording a non-downloading commission statement in EZLynx. Once the agency obtains a non-downloading commission statement from a carrier (via email, regular mail or on the carrier's site), use this EZLynx CSV file template to format the data correctly for import. Be sure header columns are the first row of your spreadsheet, and the header names are entered exactly as they appear below.

KEY:

RED - indicates a field required for import

BLUE - indicates a field recommended for best import experience

Our step by step wizard helps streamline the steps involved to import commission statements making it easier to complete the process and pay producers.

• Step 1: Statement Summary 
  • Select carrier name
  • Enter statement number, total premium, & commission amount
• Step 2: Upload File 
  • Upload the commission statement received from Carrier.
  • You can also download the approved CSV template.
• Step 3: Map Column Headers 
  • If using the approved CSV template, you’ll skip to final step.
  • If using a carrier specific template, update the mappings.
  • EZLynx automatically saves the mapping and remembers it for the next import.
• Step 4: Review Imported Statement 
  • Preview the entire file.
  • Now make corrections and changes here on the screen!
  • Auto Update Corrections – EZLynx offers suggestions to correct transaction types and LOBs. For example, if New is set as the transaction type instead of New Business, our system flags it and a user can pick NBS – New Business from the list of transaction types. Now EZLynx locates all similar entries and makes corrections automatically.
    • EZTip: Choose Always Auto Update, so EZLynx remembers these corrections for future imports.
      
  • Similarly, when EZLynx doesn’t recognize a LOB code, a user can select from the list of recommended LOB codes.
  • Hit Finish to complete the import process.
  • EZLynx now searches to find the matching policies.
    • EZTip: Provide the line of business (LOB) information to help us find an accurate match.

Manually Creating a Commission Statement

Manually entering a Commission Statement into EZLynx, is a task for Admins at an agency that use EZLynx to pay commissions. The first step to paying monthly Commissions, is to reconcile each of your carriers’ Commission Statements. To do this, the statements must be available in EZLynx. Learn how to manually enter a Commission Statement for any carriers that do not send Statement downloads, or for any carriers that you do not have a CSV file Statement available to Import.

To manually enter a commission statement:

• Hover over the Policy Management icon- And under Commissions, select Statements.
• Click the blue New button in the upper right corner.
• Enter the required Statement information. EZTip: Any required field will be marked with a red *.
  • EZTip: If you do not have a specific Statement Number to use, we recommend to use the date of the statement in a mm/dd/yy format. (I.E. 080319 for August 30th, 2019)
  • At Commission, enter the statement's total commission amount.
• Click Add.
  
• Enter each line item from the paper statement.
  • EZTip: Increase efficiency by using a keyboard instead of a mouse:
• To start- Use the Search Applicant/Policy # field to locate the applicant & policy.
  • Select the correct Applicant, Policy #, Line of Business, & Carrier from the drop down.
    
• After selecting from the first drop down, another drop down will appear so that you can select the correct Transaction Type and Applied Date.
  
  • EZTip: After selecting, click anywhere in the white so that the drop down does not keep reappearing. 
• Enter the Premium and Commission amounts.
• Confirm that the policy Matches to the correct Commission rule #.
• Select the blue Add button in the bottom right corner, to add the line item to the statement.
  
• Repeat steps until all line items are added to the statement.

Working a Commissions Statement

Step 1 - Find the Statement

Locate The Statement:

• Hover over the Policy Management icon- And under Commissions, select Statements.
  
   
• The Commission Statements page defaults to all statements for the last three months.
• If necessary, use Commission Statement Filters:
  • Date Range – Filter uses Statement Date; Adjust the Date Range as necessary.
  • Statement Status – Page defaults to Open Statements; Toggle between All, Open, or Closed options.
  • Statement Type – Select Manual, Imported, or Downloaded Statement.
  • Ready to Finalize – Select All Statements, Ready, Not Ready, or Finalized.
  • Show Hidden Statements checkbox – From Actions, there is an option to Hide a Statement. To view a hidden statement, check the Show Hidden Statements checkbox. From the blue Actions link to the right, you can select Show Statement again, if desired.

• Search Box – Enter Carrier name, Statement #, or total Statement dollar amount- Then click Enter on keyboard.
  
• Sort Column – Click any column header to sort from A to Z; Click again to sort in the opposite direction.
  

Step 2 - Unmatched Commissions

Once you've located the statement to be reconciled in EZLynx, click Actions at right, select Edit Details.

• Look at the Unmatched Commission amount. 
  • If $0.00 – there are no unmatched commissions.  Skip to Step 4 - Update, Approve, & Finalize.
  • If any amount other than $0.00, continue to the next step.
    
• Click the Filter icon on left to select Unmatched in the Match Status dropdown.
  
• Click each line item with a Match link on the right. 
• At Applicant/Policy # box, search by applicant name and select applicant/policy from results dropdown.
  
• Ignore Service Team and Override Rule. Entire statement is updated later.
• Click the blue Match button.
• Repeat steps 3 – 6 until all unmatched line items are matched.
• The Unmatched Commission amount should equal $0.
  • If $0.00 – skip to Step 4 - Update, Approve, & Finalize.
  • If any amount other than $0.00, click here for instructions.

Step 3 - Add Chargebacks & Carrier Fees (if needed)

A commission statement may have a total commission amount that is different than the total of the line items. This is usually because a carrier has added or subtracted chargebacks and/or carrier fees to the commission total, but not included these as line items on the statement. When this happens, the chargeback(s) and/or carrier fee(s) must be added to the statement manually - as line items.

• From the opened commission statement, click the + Add Commissions button.
• At Applicant / Policy # box, search for your agency’s “chargeback fees” applicant.
• Select the policy for the type of fee you are adding.
• At the Commission box, enter the chargeback or carrier fee as a negative amount.
• Click Add button.
• Repeat steps 1 – 5 until all chargebacks and/or carrier fees are added.
• The Unmatched Commission amount should now be $0.00.

Step 4 - Update, Approve, & Finalize

Before finalizing a commission statement, line items must run through the commission rules. Also, all line items must be approved, and the statement finalized to ensure reporting accuracy.

1. From the opened Commission Statement, click the Update Commissions button.
   • This runs the line items through the rules and applies updates made to applicants, policies, and/or commission rules so that commissions pay accurately.
2. At top left of Line Items grid, check the Approve All box.
3. Click Finalize Statement at upper right.
4. Once the agency is ready to pay commissions and all related commission statements are finalized, run Commissions by Producer Reports.