Wages Calculation Extract

Enables you to calculate the amount due to furloughed employees based on the selected periods and the furlough type (salaried or varied). This task produces a CSV file which can be used as an aid to generate the correct payments for furloughed employees.

Note: This task can only be run for employees on the same tax calendar and pay frequency.

Refer to the CJRS in ResourceLink - user guide for details of the output from the Wages Calculation Extract.

Selection

Salaried\Varied

Select the furlough type to run the report for by entering S for salaried or V for varied.

Tax Year & Period

Enter the tax year and period.

Flexible Furlough

This indicates that the report should be produced using flexible furlough calculations. It will default to the selection in Furlough Parameters, but can be overridden.

Furlough PE

Select the pay element from the drop-down list that will be used to pay the furlough payment to employees.

This pay element is used to generate the header record within the summary CSV file. Whilst it is mandatory, it can be changed within the CSV file if required.

Top-up\Deduction PE

Select the pay element from the drop-down list that will be used to pay the top-up of the furlough payment to employees.

This pay element is used to generate the header record within the summary CSV file. Whilst it is mandatory, it can be changed within the CSV file if required.

Pay Top-up\Deduction

Select this check box to reduce the salary to a value lower than 100% of reference pay, or to pay the top-up to top the salary up to 100%.

Note: If you are using the top-up as a reduction and your employee’s period pay differs to the reference salary, you must adjust the reduction pay.

Varied Pay Daily Rate

This field is only available when processing varied-type employees.

Select this check box to use a daily rate for average period pay, rather than annualisation.

Top-up Negative

Select this check box to convert the top-up payment into a negative amount. This should be used when reducing the employees' pay by the specified top-up percentage using a payment type pay element, thus creating a negative payment.

Use Tax Calendar dates

This field is only available when processing varied-type employees.

Select this check box to use the employee’s relevant tax calendar when averaging pay for 2019.

Top-up Percentage

Enter the top-up percentage if you need to use a different rate to the one selected in Furlough Parameters. This option allows you to apply a different top-up rate if this varies for different groups in your organisation.

Note: You can enter a value greater than 20%, however, this will take payments to above 100% of normal salary.

Use Calendar end date

This field is only available when processing varied-type employees.

Select this check box to use the calendar end date for the days worked calculation to avoid reducing the numbers of days within the year with furlough periods in March.

Pay Adjustment PE

Select the pay element from the drop-down list that will be used to make a pay adjustment to the furlough payment paid to employees.

This pay element is used to generate the header record within the summary CSV file. Whilst it is mandatory, it can be changed within the CSV file if required.

Furlough Holiday PE

This field is only available when processing varied-type employees.

If the relevant PE category contains a pay element, when you tab down to this field it should auto-populate. Otherwise, enter the pay element that will be used to process the notional holiday pay. This pay element is used when generating the header record within the summary spreadsheet. It can be changed within the spreadsheet if required.

Summary file

A summary file in CSV format is produced when this task is run. The system automatically generates the file name COVID19_MMMDD_HHMM_SUM.csv, however, you can amend it.

Detail file

A detail file in CSV format is produced when this task is run. The system automatically generates the file name COVID19_MMMDD_HHMM_DET.csv, however, you can amend it.

Click the Continue button to produce the summary file and detail file, and download the files.

Note: You may need to disable your browser’s pop-up blocker if the summary file and detail file do not download.

MD312S02