Payroll Auditor
In many cases, you use analyses to perform a check on the salaries. For example, you can check whether an employee is incorrectly receiving a travel expense allowance or whether an employee's wage is incorrectly processed based on the green table. You can also check for sudden salary increases for an employee. These checks take a lot of time as they are not part of the regular process.
That is why you now have the Payroll Auditor. The Payroll Auditor warns you in advance when a situation occurs in the salary processing that requires your attention. This gives you a better grip on the salary processing, it increases the quality and makes the time-consuming checks and analyses a thing of the past!
Advantages:
- Automated checks
- Grip on the quality of the salary processing
- Option to add your own checks
|
Content |
Video
Description
The Payroll Auditor uses audit components. The audit components contain parameters in which you record threshold values. The audit components do not guarantee that your salary processing is error-free, but they are a tool to help you get a better grip on the salary processing and reduce the number of errors.
We supply default audit components in the CLA. The first 70 audit components were supplied in the CLA Update with version 2015.01.01 and activated as from 1 February 2015. In CLA Update 2015.02.01 we supply new audit components.
From now on, for every CLA Update we will check whether we have to add sector or CLA specific audit components. If you find an audit component missing, please mail us your idea. Keep in mind, however, that an audit component is only feasible if Profit can calculate a value.
Supplied audit components
We supply the following audit components:
New audits in CLA Update 2015.02.01
Root number |
Description |
Activated |
Threshold |
Calculation basis |
|---|---|---|---|---|
100.009.304 |
Audit: Date of birth changed |
|
|
|
100.009.340 |
Audit: Minimum hours per week and timetable |
|
|
|
100.009.341 |
Audit: Maximum hours compared with minimum hours |
|
|
|
100.009.361 |
Audit: 'Voordeelregel' white >= 52% |
|
|
|
100.009.362 |
Audit: 'Voordeelregel' white < 52% |
|
|
|
100.009.363 |
Audit: 'Voordeelregel' green |
|
|
|
100.009.364 |
Audit: Transition reimbursement applies |
|
|
|
100.009.365 |
Audit: Manager/major shareholder with incorrect income relationship type |
|
|
|
100.009.366 |
Audit: Income relationship type is Manager/major shareholder, but Manager/major shareholder check box is not selected |
|
|
|
100.009.367 |
Audit: Manager/major shareholder wrongfully insured |
|
|
|
100.009.368 |
Audit: Manager/major shareholder wrongfully uninsured |
|
|
|
100.009.380 |
Audit: Sector risk group long, contract shorter than year |
|
|
|
100.009.381 |
Audit: Sector risk group long, contract shorter than year, employer initiative |
|
|
|
100.009.382 |
Audit: Sector risk group short, contract at least a year |
|
|
|
100.009.383 |
Audit: Sector risk group long, contract shorter than year, 'WW' benefit |
|
|
|
100.009.384 |
Audit: Sector risk group long, without timetable hours |
|
|
|
100.009.397 |
Audit: Lease motor bike and travel expenses |
|
|
|
100.009.398 |
Audit: Negative motorbike addition |
|
|
|
100.009.399 |
Audit: 'ZVW' code other than employer contribution rate |
|
|
|
Calculation basis
If you see a 
for a calculation basis, the audit component uses a calculation basis. That means that you can determine which wage components should be included in this calculation basis and, if applicable, your own payroll configuration.
Example:
In the case of a reimbursement for a work placement, you do not want to calculate a reservation for the holiday allowance, but perhaps not the deduction for the personnel association either. In that case, you determine which wage components are included in the calculation basis.
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
New CLA specific audits in CLA Update 2015.02.01
Root number |
Description |
Activated |
Threshold |
Calculation basis |
|---|---|---|---|---|
103.029.300 |
Audit: Declare reintegration bonus |
|
|
|
103.029.301 |
Audit: Declare extra leave |
|
|
|
106.019.300 |
Audit: Declare bereavement leave |
|
|
|
135.009.300 |
Audit: Manager/major shareholder at age of 'AOW' entitlement |
|
|
|
156.019.301 |
Audit: Declare extra leave |
|
|
|
157.019.301 |
Audit: Declare extra leave |
|
|
|
160.019.301 |
Audit: Declare extra leave |
|
|
|
161.009.300 |
Audit: Contract end date entered, but no employment end date |
|
|
|
Calculation basis
If you see a for a calculation basis, the audit component uses a calculation basis. That means that you can determine which wage components should be included in this calculation basis and, if applicable, your own payroll configuration.
Example:
In the case of a reimbursement for a work placement, you do not want to calculate a reservation for the holiday allowance, but perhaps not the deduction for the personnel association either. In that case, you determine which wage components are included in the calculation basis.
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
Threshold |
|---|---|---|---|
100.009.300 |
Audit: Invalid age |
|
13-70 |
100.009.301 |
Audit: Death without employment end date |
|
|
100.009.302 |
Audit: Social security number (BSN) missing |
|
|
100.009.303 |
Audit: 'AOW' entitlement age reached |
|
|
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
Threshold |
|---|---|---|---|
100.009.310 |
Audit: Net salary |
|
|
100.009.311 |
Audit: Net wage without 'LH' deduction |
|
|
100.009.312 |
Audit: Timetable without 'Apply timetable in Payroll' |
|
|
100.009.313 |
Audit: Not applying 'LH' deduction not realistic |
|
50% |
100.009.314 |
Audit: 'BT' annual wage missing |
|
|
100.009.317 |
Audit: Hourly wage is 0 |
|
|
100.009.318 |
Audit: Remarkable number of wage hours |
|
200 |
100.009.319 |
Audit: Minimum wage check |
|
|
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
Threshold |
|---|---|---|---|
100.009.330 |
Audit: Wage hours without wage days |
|
|
100.009.331 |
Audit: Wage days without wage hours |
|
|
100.009.332 |
Audit: Average number of hours per day |
|
12 |
100.009.333 |
Audit: Negative wage hours |
|
|
100.009.334 |
Audit: Average wage hours (calculation component) |
|
|
100.009.335 |
Audit: Average wage hours in reference period |
|
|
100.009.337 |
Audit: Employee has not worked for 6 periods (AV) |
|
6 |
100.009.338 |
Audit: Full-timer with extra hours |
|
|
100.009.339 |
Audit: Part-timer with overtime hours |
|
|
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
Threshold |
Calculation basis |
|---|---|---|---|---|
100.009.346 |
Audit: 'Ouderenvrijstelling' not applied |
|
|
|
100.009.347 |
Audit: Premium reduction for young employees possible |
|
|
|
100.009.348 |
Audit: Premium reduction for young employees and unpaid hours |
|
|
|
100.009.349 |
Audit: Employee excluded from wage declaration |
|
|
|
100.009.350 |
Audit: 'Artiestenregeling' and table code |
|
|
|
100.009.351 |
Audit: Premium reduction in case of minmax agreement |
|
|
|
100.009.352 |
Audit: Trainee with 'WW' and 'WIA' insurance |
|
|
|
100.009.353 |
Audit: White table without employee insurance(s) |
|
|
|
100.009.354 |
Audit: Green table and employee insurances |
|
|
|
100.009.355 |
Audit: 'WW' and 'WIA' not both enabled or disabled |
|
|
|
100.009.356 |
Audit: Premium reduction for older employees may be applicable |
|
|
|
100.009.357 |
Audit: Premium reduction for older employees incorrect |
|
|
|
100.009.358 |
Audit: Green table and 'Levensloopuitkering' from 61 years |
|
|
|
100.009.359 |
Audit: Benefit and green table |
|
|
|
100.009.360 |
Audit: 'AOW' age without salary and green table |
|
|
|
Calculation basis
If you see a for a calculation basis, the audit component uses a calculation basis. That means that you can determine which wage components should be included in this calculation basis and, if applicable, your own payroll configuration.
Example:
In the case of a reimbursement for a work placement, you do not want to calculate a reservation for the holiday allowance, but perhaps not the deduction for the personnel association either. In that case, you determine which wage components are included in the calculation basis.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
Threshold |
Calculation basis |
|---|---|---|---|---|
100.009.370 |
Audit: Wage to be paid much higher than net wage |
|
100 |
|
100.009.371 |
Audit: Wage to be paid much lower than net wage |
|
50 |
|
100.009.372 |
Audit: Wage with high tax rate (incl. salary from wage hours/days) |
|
TBD |
|
100.009.373 |
Audit: Wage with high tax rate (excl. salary from wage hours/days) |
|
TBD |
|
100.009.374 |
Audit: Negative payment |
|
|
|
Calculation basis
If you see a for a calculation basis, the audit component uses a calculation basis. That means that you can determine which wage components should be included in this calculation basis and, if applicable, your own payroll configuration.
Example:
In the case of a reimbursement for a work placement, you do not want to calculate a reservation for the holiday allowance, but perhaps not the deduction for the personnel association either. In that case, you determine which wage components are included in the calculation basis.
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Audits: Combinations and logic
Root number |
Description |
Activated |
Threshold |
Calculation basis |
|---|---|---|---|---|
100.009.390 |
Audit: Lease car and travel expenses |
|
|
|
100.009.391 |
Audit: Negative bicycle plan balance |
|
|
|
100.009.393 |
Audit: Invalid combination with placement reimbursement |
|
|
|
100.009.394 |
Audit: Negative car addition |
|
|
|
100.009.395 |
Audit: Contract hours and on-call hours |
|
|
|
100.009.396 |
Audit: Fully sick and travel expenses |
|
|
|
100.009.420 |
Audit: Obsolete payroll configuration |
|
|
|
100.009.421 |
Audit: Remarkable payroll configuration |
|
|
|
Calculation basis
If you see a for a calculation basis, the audit component uses a calculation basis. That means that you can determine which wage components should be included in this calculation basis and, if applicable, your own payroll configuration.
Example:
In the case of a reimbursement for a work placement, you do not want to calculate a reservation for the holiday allowance, but perhaps not the deduction for the personnel association either. In that case, you determine which wage components are included in the calculation basis.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Audits: Current/previous period
Root number |
Description |
Activated |
Threshold |
|---|---|---|---|
100.009.435 |
Audit: Hourly wage decreased |
|
0% |
100.009.436 |
Audit: Hourly wage significantly increased |
|
5% |
100.009.437 |
Audit: Large deviation in wage to be paid |
|
TBD |
100.009.438 |
Audit: Large deviation in net wage |
|
TBD |
100.009.439 |
Audit: Large deviation in gross wage (incl. salary) |
|
TBD |
100.009.440 |
Audit: Large deviation in gross wage (excl. salary) |
|
TBD |
100.009.441 |
Audit: Large deviation in employer costs |
|
TBD |
100.009.442 |
Audit: Employer costs (calculation component) |
|
|
100.009.443 |
Audit: Gross wage incl. salary (calculation component) |
|
|
100.009.444 |
Audit: Gross wage excl. salary (calculation component) |
|
|
100.009.445 |
Audit: Wage to be paid (calculation component) |
|
|
100.009.446 |
Audit: Net wage (calculation component) |
|
|
When activating an audit component, first consult the explanation. The explanation indicates, for example, if you have to add a threshold value.
You can always change a threshold value in an audit component activated by default.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.
Root number |
Description |
Activated |
|---|---|---|
100.009.460 |
Audit: General template |
|
100.009.461 |
Audit: Increase/decrease template |
|
100.009.462 |
Audit: Threshold value template |
|
100.009.463 |
Audit: Mandatory combination template |
|
100.009.464 |
Audit: Combination template not allowed |
|
100.009.465 |
Audit: Fully sick and calculation basis template |
|
100.009.466 |
Audit: Reference period template (calculation component) |
|
100.009.468 |
Audit: Conditional combination template |
|
If you create your own payroll configuration on a regular basis, you can create your own audit components. We recommend you first create the audit components in a test environment.
If you are not experienced in creating and maintaining your own payroll configuration, we recommend you contact an AFAS Consultant or AFAS Expert.
Note:
Each wage component has a comment in which the operation of the audit is explained. Always take a look at this explanation on the Comment tab in the properties of the wage component in the CLA.