Monthly Production Report

This project is data input into an Ezxcel worksheet. I am involved with a group of Insurance Agencies. Attached you will find a spreadsheet of all the insurance companies we do business with. Each Company assigns each Agency a producer code or several codes. These codes track the amount of insurance premium written with each carrier along with the loss ratio for the business produced. The data need to be input into each spreasheet is the YTD written premium, YTD new business premium and the YTD loss ration. The loss ratio is the amount claims paid divided by the amount of premiums written. Some Companies send these reports month/y, some send quarterly. Regardless, we need you to update the spreadsheet monthly. At first I will send you the reports, highlighting the numbers needed to be input into the spreadsheet and saved. Then you will go to an email account where the reports are sent each month. Further, not all companies will email this information and you may have to go to their website and obtain the production information. This work would be needed every month. Let me know what your thoughts are on this project.