Can your commission calculations withstand an audit?
Now that you have a few months of commission calculations under your belt on your new sales compensation plans, how confident are you that the spreadsheets are set up exactly right and those calculations are perfect?
I audited hundreds of spreadsheets over my career and I can honestly say that there is at least 1 error in each of them if not more. Spreadsheet errors are costly.
Funny thing about errors, the compensation analyst�s phone will be ringing off the hook when there is an error that results in underpayment but rarely hears about an overpayment. Often when you confront the rep who was overpaid they say they didn�t realize it! [Read more…]