Overview
There are a few ways to get your commission data into AgencyBloc. Generally, you'll import commission data from an electronic statement provided by the carrier in an excel format. If the carrier does not provide a statement, you can use the standard import template or manually add entries. Using manual entries is also a good option for posting a small number of commission payments or making adjustments to an agent’s commissions.
IN THIS ARTICLE
Importing commissions (5:38)
7/17/2019 - We updated AgencyBloc to support commission number. See release notes for more details.
Step-by-step instructions
To process commissions in AgencyBloc, you need to bring carrier commissions statements into AgencyBloc.
There are three methods to do this:
Conventional method
This is the most commonly used method for importing commission data into AgencyBloc. You’ll use this method if the carrier sends you commission statements in Excel spreadsheets.
- Go to Commission > Import Carrier Data.
- Choose the import map that corresponds with the commission statement you are importing.
- Many agencies use a statement date that reflects when they are paying out to their agents or when they are reconciling and posting the payments. No matter how you use this date, it is for your reference throughout AgencyBloc and should make sense to the person processing commissions.
- Assign a statement date.
- Many agencies use a statement date that reflects when they are paying out to their agents or when they are reconciling and posting the payments. No matter how you use this date, it is for your reference throughout AgencyBloc and should make sense to the person processing commissions.
- Select the Upload button and review the import summary.
- Select the View & Edit Entries link to review all policies that were on your statement that you need to link.
Standard method
In some cases, the carrier may not provide commission statements in Excel spreadsheets. If this happens, you can still import your commission data by adding it to our standard template.
To download and add your commission data to the standard template:
- Go to Commission > Import Carrier Data.
- Select the ‘Download Standard Template’ link.
- This will open an Excel template that you can copy and paste your data into.
- After adding your data to the standard template, save the file and import it into AgencyBloc following the conventional method.
- Make sure you select ‘Standard Format’ in the ‘Import Map' field. Leave the ‘Carrier’ field blank if you are importing multiple carriers in the same file.
Standard template details
In the standard template, you may notice certain fields are bold. These bold fields are required for a successful import. You may skip any columns that aren’t bold if they are not relevant to your business.
Do not delete or rearrange the columns in any way. This can create errors during import.
The data you add to the CarrierAbbrev column should mirror what you have listed in Commission > Commission Settings > Import Maps > Translations. A translation takes the Coverage Type or Revenue Type value in your commission import file and changes it to a matching value in AgencyBloc.
It's important for this value to match so your commissions are correctly linked to policy records. If you don’t use translations, you will place the name in the carrier column that is listed in AgencyBloc.
Manual method
In some instances, the carrier will not provide an electronic file of your statement. If this happens, you will need to use the manual method to enter payments. See this article for step-by-step instructions.
Common questions
I keep getting an error when I try to upload my commission statement using the carrier map. What is wrong?
The most common answer to this question is that the carrier changed the format of their file so your AgencyBloc Import Map is no longer accurate.
How to fix it: Go back into your import history (located within the Import Carrier Data section) and find a file from a previous month that worked correctly for that carrier. Open that file and compare the columns to the file that just failed. Check to make sure the data is located in the same columns on each spreadsheet. If you find a difference that means the carrier has indeed changed their file. You will need to submit the new file to our developers so they can update your map. This can be done within the Import Carrier Data section under the Modify Existing Import Map tab. You will receive an email when the update has been finished. Typical turnaround time is about 24-48 hours.
I keep getting an error when I try to upload a commission statement using the Standard Format template. What is wrong?
Common things to check:
- Make sure the columns have not been moved or altered. Also, make sure no columns have been added or deleted.
- Make sure the Carrier name is spelled and appears exactly like it is entered in the Carriers tab of AgencyBloc.
- Make sure all dates are in the format of MM/DD/YYYY
- Make sure all the number columns are set to “General” as the format- No dollar signs, no commas, etc. (this only applies to premium and commission information)
- Make sure the file is saved as an .xls format (shown as “Excel 97-2003” as the file type)
- Make sure Coverage Type for each entry is exactly how it appears in AgencyBloc (spelled the same)
- If you have a value in the InRate column, you must have a value in the Premium column or the Lives column.
- If you don’t have a Premium amount (carrier didn’t provide it) it is best to put a “0” in the Premium column.