Tip #1407 – Evaluating True Agency Performance

Often times an agency picks up new lines and also loses lines.  When looking at sales numbers in Sales IQ, these numbers can often be distorted when you display both new manufacturers and lost manufacturers along with your active manufacturers.  The following examples will help you to identify your true sales numbers by excluding these manufacturers.  Also, modifying the manufacturers name with a symbol provides a quick visual when displaying all manufacturers in a list.

Classifying a Manufacturer Status

When adding a manufacturer the status is set to “New” by default.  Once a “New” manufacturer has met the agency’s requirements for categorizing the manufacturer as “Active”, the status should be updated.   Many agencies make this change after 1 year.  The following example shows how to change a manufacturer’s status.

  1. From the Manufacturer Maintenance screen, select Active from the drop down list in the Status field.
  2. Select the Save button and then the Exit button.Manufacturer Maint Screen

Adding a Symbol to the Manufacturer Name for an Easy Visual of New or Lost Lines

For a quick visual of “New” or “Lost” lines in your Sales IQ display list, you can modify the manufacturer name with a symbol that is easily identifiable such as “<-“ for a lost manufacturer or “<+” for a new manufacturer.   Once you change the status from “New” to “Active”, then you can remove the symbol from the manufacturer.


In the following example you can see the new manufacturer Simplex Manufacturing which has the “<+” in front of the name and you’ll see that there are sales in the column Jan-Oct14 but no sales in previous years.  You will also see the inactive manufacturer S P & P Inc. which has the “<-“ in front of the name and no sales in Oct 14 or this YTD Jan-Oct 14  but sales in previous years indicating a lost manufacturer.

Sales IQ Screen 1

Excluding New and Inactive (lost) Manufacturers from the Sales IQ Display

You can remove “New” and “Inactive” manufacturers from the Sales IQ display by using the Filters button in Sales IQ.  This method will remove these sales numbers from the display showing you only the agency sales for “Active” manufacturers eliminating the new and lost lines.

  1. Select the Filter button from the Sales IQ screen.Filters Screen 1
  2. From the Filters screen select Active from the Status drop down list under Manufacturer.
  3. Select the Apply button.Filters Screen 2
  4. After filtering you can see that only ”Active” manufacturers are displayed in the Sales IQ screen.Sales IQ Screen 2

Case Study: C. R. Kinsman & Associates, Inc.

“All of our data is on the cloud, so we never have to worry about losing invaluable sales and commission information.”

Craig Kinsman, CPMR & President
C.R. Kinsman & Associates, Inc.

Client Challenge

Technology has changed the world since C.R. Kinsman & Associates Inc. (CRK) was founded in 1976. At the time, data was recorded 100% manually on paper. When computers were introduced, the agency was an early adopter. A custom sales and commission software was developed, and at the time it was cutting edge.

But as technology continued to evolve, the software became outdated. “Running reports was labor intensive, data entry was still manual and the reports were archaic.” says Craig Kinsman, CPMR and President. Like so many agencies, CRK continued to use it because “that’s the way it had always been done.”

CRK_StatisticsdynaMACS Solution

As the agency expanded its executive team, it was the perfect time to look into new sales and commission software. “We asked other agencies. dynaMACS was the software of choice,” Kinsman says.

dynaMACS transferred a two-year history of CRK’s data from Microsoft Access system with no loss of information.

The team was apprehensive about the learning curve in using new software, but Kinsman says, “We were shocked at how easy dynaMACS was. We wish we’d gotten it years ago.”

The agency chose to process on the cloud, giving the sales agency access to data anytime, from anywhere. Cloud processing also protects data because all sales and commission data is backed up on the cloud.

The days of archaic reports are ancient history. CRK generates the reports from more than 5,000 choices – or customizes reports for their specific needs. “The possibilities are endless,” Kinsman says. “We can get reports on any aspect of our sales and commission data and overall agency performance.”

With dynaMACS, inefficiency and costly downtime are a thing of the past for CRK.