How to Fix Sage Payroll Error 7866

If an employee changes NI category during the tax year, when you submit a full payment submission (FPS) the following message may appear:

‘Sage 50 Error 7866 – The amount in [EMPLOYEESCONTRIBUTIONSONALLEARNINGSYEARTODATE] must be 0.00 if the [NILETTER] is ‘X’, ‘C’, or ‘W’.’

This Sage Payroll error 7866 message occurs when a value greater or less than zero is present against a category that should be zero, that is X, C or W. Normally, this happens if a refund of NI has been made against the wrong category or it may be caused by processing manual NIC on an incorrect category such as C where Employee NIC has been deducted.

Also Read: How to Fix Sage 50 Payroll Update Error

This is not a bug, the software is working as intended. If you receive this message you should roll back and reprocess the affected employee(s) correctly.

Rollback enables you to go back to a specific pay period for any of your employees and permanently delete any pay processing carried out after that pay period. This can be used to erase any errors made in the pay run. This option can only be used to clear pay history. The employee’s basic records, i.e. address and contact details, will not be affected, but all cumulative values, pay histories and absence records will be permanently deleted for the periods rolled back. Please note, when you roll back an employee’s pay, the corresponding Employer Payment Record – EPR (P32 replacement) values will be adjusted accordingly. We recommend that you do not roll back if the processed pay details have already been submitted to the HMRC.

To rollback a current employee, select Rollback Employees from the “Others ” drop down menu. Select Rollback Active Employee to roll back the pay periods of current employees. Read through the instructions and click on the Continue button. Now, click on the Rollback link for the employee you wish to rollback. Tick the period(s) you wish to roll back and click the Continue button. Further enter your Sign In password to confirm the rollback. All your employee’s pay run data will be rolled back to the pay period you have selected.

Before using the roll back wizard, please read the following:

If you have amended pension schemes in an earlier version of Sage 50 Payroll and have completed a roll back, you should check that your pension schemes are correct.

Have you changed an employee’s pension AVC amount and processed their payroll? When you roll back to a previous period, the AVC amount does not revert back to the old amount.

If you enter sickness for an employee, then roll back, the number of accrued waiting days are not cleared. You should manually delete these from their employee record.

If you enter absence and/or holidays for your employees, then roll back to a previous period, unless you choose to clear cumulative values these absences are not cleared from the Absence Diary.

Note: SSP values are removed up to the specified period.

Have you advanced holiday pay to any of your employees? When you roll back to a previous period, make sure you go back to a period before the holiday pay was advanced.

Any P45 figures that have been entered are not cleared, unless the oldest update is selected and when prompted to clear all cumulative values, you click Yes.

You cannot roll back pay periods in the previous tax year unless you first roll back everything that has been processed, in the current tax year, for the affected employee. You should then reprocess their payments up to date.

Note: Rolling back periods in a previous tax year may affect your tax year end returns. For more information, refer to HMRC guidance CWG2 Employer further guide to PAYE and NICs.

The Roll Back Employee Wizard does not roll back all details in the employee’s record. For example, pay elements and rates may have changed since the period you roll back to, but the wizard does not revert them back. You should therefore check your employee’s details and make any changes before reprocessing your payroll.

You can roll back more than one pay frequency at a time. Make sure you select the correct employees from the employee list.

Note: If no employees are selected, all employees are included in the process.