Incentive, Compensation and Sales Performance Management

Hello Julien,

I hope this message finds you well. With recession alarm bells going off all over the world, it got me to thinking about the effects it might have on my company and the overall software industry. And an interesting point struck me…Software-as-a-Service (SaaS) wasn’t an option during the last recession. So, why does that matter?SaaS has established a strong track record over the past several years, proving its value in cutting costs and increasing flexibility. And what’s valuable in the best of times can prove priceless in the worst of times.

You know the litany. In contrast to on-premise enterprise software, SaaS means no upfront hardware and software costs, no worrying about costly ongoing software maintenance, and no vendor lock-in. Instead of being tied to an expensive software infrastructure, you’re free to quickly implement changes. And if a SaaS vendor doesn’t perform, you’re free to immediately choose one that will and be up and running in a matter of weeks. Believe me, savvy SaaS vendors know this! Subscriber retention is one of our key success metrics, along with speedy initial implementation and the ability to quickly deliver new functionality.

So, while SaaS delivers lower costs and enhanced flexibility, where does that leave employee and business productivity? Obviously, not all software applications—SaaS or on-premise—deliver equal boosts to productivity, at least not of the kind that directly impacts the bottom line.

Yet some categories excel in their ability to do so, including Sales Performance Management (SPM) applications. In a recession, businesses need to invest in getting the most profit possible out of their front-line employees. SPM applications do this by helping align sales behaviors to corporate objectives, focusing reps on the most strategic sales, maximizing agility in the face of market change, and providing visibility into key sales-success drivers. The last recession was a boom time for early-generation SPM applications—and that was even before the advent of SaaS. Today, thanks to the SaaS model, the SPM arena is expanding in scope like never before, and SPM functionality such as on-demand sales compensation management is finally affordable to companies of any size.

In short, SaaS plus SPM delivers a double whammy in the face of recession: SaaS economic value combined with SPM strategic business value. It just makes good business sense, whether you are managing in a recession or in a vibrant, high-growth economy.

If you’re interested in discussing this topic further, please let me know.

Cheers,
Chris

Christopher W. Cabrera

Founder & CEO
Xactly Corporation
35 S. Market Street
San Jose, CA 95113

• First, position the active cell to the first row and check if the mandatory Order Code is present. If this is the case, if it is in the proper format (2 upper-case letters followed by 3 digits in this example).
• Check if the Item Code is an alphanumerical value (only digits and letters allowed)
• Verify that the "Quantity" field is not null.
• Check to see if the "Amount" field only contains an amount (digits, "-" and ".") - I could write something more complex to make sure I don't get records like: "22-..2".
• Verify that the Unit type is allowed. I hardcoded a check for "USD".
• Check that the incentive date is actually in an Excel date format. Remember that it needs to be setup as mm/dd/yyyy for the Xactly upload.
• Verify that the split amount sums up to 100%. I also make sure that if a 2nd split amount is entered, that the associated second employee ID is entered.
• Lookup the "Amounts" column again, verify if there are numbers with the minus sign at the end of the number (2.0-), and transform it into the proper format (-2.0). I often get this problem when importing data from raw text files.
• Finally, verify that the incentive date is unique for every row.

All these steps will only take a few seconds to execute for several hundred rows.

How to Run my Macro

• Download this spreadsheet to your computer
• Click on Tools->Macros->Macro (Alt-F8 to be quicker)
• Select "editFile" (that's the name of my macro) and click on "Run"
• Tada! Your errors should now be highlighted in red.
• Correct the errors, remove the red-fill color and run the macro again if you want to verify your corrections.