How-To: Setting Tolerances for Faster, Better Data Validation

Jul 11, 2018  | Topic: Analytics

No matter how optimized or standardized a global payroll process is, one step remains highly manual for the majority of multinational organizations: data validation. Payroll professionals routinely spend hours if not days every cycle manually verifying that the payroll data contained in Excel templates is accurate and ready for gross-to-net calculations, then again checking the data after it is processed.

This brief how-to video demonstrates how automating the data validation process saves significant, measurable time and effort in every payroll cycle by letting the system perform those checks for you. Key to this is setting tolerance levels for data inputs, such as capping the amount by which salaries can increase compared to the previous cycle or setting a limit on the total cost of a payroll. With these settings configured, the system algorithms automatically validate data according to your specifications both before and after the payroll run. So instead of spending hours looking for errors by hand, you benefit from a more accurate, expedited check that happens with just the click of a button.