Advanced Payments and Deduction List

This feature is available in Opera 3.

Use the Advanced Payments and Deductions List to produce an analysis of multiple payments and deductions for a range of employees over one or more pay periods.

Job Retention Scheme Assistance: A report, including an Excel variant is available to assist employers in re-claiming monies due from HMRC for furloughed staff including ERs NICs and ERs minimum pension contributions. The reports are available form the Report Layout dropdown list on the publisher form of the Advanced Payments/Deductions List.

Employers with 250 or more employees must report gender pay gap information to HMRC and also publish on their own websites. This report can be used to assist you with collecting that information.

The following details are printed:

Employee reference and name

Rate

Units

Permanent value

Amount paid or deducted in the current pay period

Balance for the payment or deduction

Gender

Usual hours worked

Pay frequency.

Option	Description
Exclude zero period values	Excludes payments or deductions that weren't used for employees included in the report in the selected pay period/s. In the situation where more than one pay periods are selected the report will exclude zero period payments and deductions but include periods where the values are not zero. For example, if you're interested in seeing who was paid overtime from tax months 1 to 6, with this option ticked the report will list months 1 to 6 individually - each month only showing the employees if they were paid overtime in those months.
Exclude zero balances	Excludes payments or deductions that have never been used for employees included in the report up to the selected pay period/s. These have zero year to date balances (including the current pay period). Balances for payments and deductions can be cleared down when the Payroll - Utilities - Update command is run, or by using the Payroll - Global Changes - Zeroise Pay/Ded Balances command. For example, if you're interested in seeing who was paid bonuses in the tax year, with this option ticked the report will list all tax months individually - each month showing all employees who were paid a bonus (regardless of when) - some months may have zero values. Employees who were never paid a bonus in the tax year will not be shown.
Include zero values or balances	Includes payments or deductions even when they don't apply to an employee in the selected year/period range but only if they did apply to them in another pay period not selected for the report. Payments or deductions that have never applied to an employee will never be included on the report for that employee. For example, if an employee has never been paid overtime that payment will never be included on the report for that employee. Similarly, if an employee has never had a charity deduction, that deduction will never be included on the report for that employee.
Current period only	Includes payments or deductions for the current pay period only. Company totals for payments and deductions are shown at the end of the report when this option is included.
Include leavers	Includes employees who are marked as leavers in the previous pay period. Leavers in the current pay period with the selected payment or deductions are always included (unless the payment or deductions have zero values or balances and you have decided to exclude zero values or balances using one of the Exclude options).
Year/Period	Use to select the year and period you are interested in. The year and period boxes are disabled if the Current Period only box is selected, or you have chosen to include payroll groups with different pay frequencies. If you select just one period for the report you can also use the Display company totals balance option to show company payments and deductions totals at the end of the report. The totals are not shown when more than one period is selected.

Option

Description

Exclude zero period values

Excludes payments or deductions that weren't used for employees included in the report in the selected pay period/s. In the situation where more than one pay periods are selected the report will exclude zero period payments and deductions but include periods where the values are not zero.

For example, if you're interested in seeing who was paid overtime from tax months 1 to 6, with this option ticked the report will list months 1 to 6 individually - each month only showing the employees if they were paid overtime in those months.

Exclude zero balances

Excludes payments or deductions that have never been used for employees included in the report up to the selected pay period/s. These have zero year to date balances (including the current pay period).

Balances for payments and deductions can be cleared down when the Payroll - Utilities - Update command is run, or by using the Payroll - Global Changes - Zeroise Pay/Ded Balances command.

For example, if you're interested in seeing who was paid bonuses in the tax year, with this option ticked the report will list all tax months individually - each month showing all employees who were paid a bonus (regardless of when) - some months may have zero values. Employees who were never paid a bonus in the tax year will not be shown.

Include zero values or balances

Includes payments or deductions even when they don't apply to an employee in the selected year/period range but only if they did apply to them in another pay period not selected for the report. Payments or deductions that have never applied to an employee will never be included on the report for that employee.

For example, if an employee has never been paid overtime that payment will never be included on the report for that employee. Similarly, if an employee has never had a charity deduction, that deduction will never be included on the report for that employee.

Current period only

Includes payments or deductions for the current pay period only.

Company totals for payments and deductions are shown at the end of the report when this option is included.

Include leavers

Includes employees who are marked as leavers in the previous pay period.

Leavers in the current pay period with the selected payment or deductions are always included (unless the payment or deductions have zero values or balances and you have decided to exclude zero values or balances using one of the Exclude options).

Year/Period

Use to select the year and period you are interested in.

The year and period boxes are disabled if the Current Period only box is selected, or you have chosen to include payroll groups with different pay frequencies.

If you select just one period for the report you can also use the Display company totals balance option to show company payments and deductions totals at the end of the report. The totals are not shown when more than one period is selected.

To Print the Advanced Payments & Deductions list

Open the Payroll folder and then click EOY/Special Reports or click the Payroll & HR tab on the Ribbon Bar and then click Payroll - EOY/Special Reports.

Click Advanced Pay/Ded List.

If you are using groups, in the Select Payroll Groups list, click to select the group(s) you want to process and then click OK.

Select the sequence, range and so on.

In the list of payments and deductions, click to select profiles you want to include.

Click OK.

On the Publisher form, click the tab to select the output device you want to use and then complete any settings or options you want to apply to the output device. To process the output, click Publish.

To save this report in Opera 3 as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.