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

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

Example:

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: Personal details

Root number	Description	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.

Audits: Master data

Root number	Description	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.

Audits: Hours and days

Root number	Description	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.

Audits: Tax authority

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

Example:

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: Threshold values

Root number	Description	Threshold
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

Example:

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

Example:

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	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.

Audits: Templates

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.