How to Fix Sage Payroll Error 7866

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.

‘Error 7866’ when you Submit a Full Payment Submission (FPS)

This is a commonly occurring error that is usually encountered when an employee moves from category A to category C within the same period that their employee record has been set up with year-to-date values within Sage 50 Payroll. For instance, their NI category changes when moving to Sage from another software provider.

To work around this, complete the following steps:

  • Start by Rolling back the first payment that has been processed within the employee’s new employment.
  • Next, Click Payroll, 
  • Now click Change Process Date.
  • You need to set the process date to the tax period before the first payment within their new employment.
  • Next launch the employee’s record, 
  • Now click the Employment tab.
  • Next, Set the NI category to A and enter the category A NI year-to-date values. 
  • Click Save
  • Next, click Close.
  • In Enter Payments, set their gross pay to £0.00.
  • You also need to check that net pay is also £0.00.

 Note: If a tax rebate is calculated, you need to change the tax code to 0T week1/month1.

  • Now Update the records to save the NI year-to-date values against category A. You do not need to send an FPS at this stage.
  • Next, Click Change Process Date
  • Now enter the employee’s first pay date for the new employment.
  • Set the employee’s NI category back to C.
  • You need to Re-enter the correct tax code if necessary
  • Click Save 
  • Click Close.
  • Finally, Reprocess their first pay period. 
  • Lastly, The FPS error will no longer be displayed and you can send the submission.

Also Read : FPS Error after Upgrading to Sage 50 Payroll

Final Words

So, you see, these are some of the aspects regarding, How to Fix Sage Payroll Error 7866. However, if you still face issues regarding the same, be sure to visit us at and you are sure to find a great deal of useful details regarding the issue.

Accounting Professionals & Specialized Experts

Want quick help from accounting software experts? Get in touch with our team members who can install, configure and configure your software for you. Proficient in fixing technical issues, they can help you quickly get back to work whenever you encounter an error in Sage software. Our team is available 24/7 365 days to assist you. To get in touch.

Frequently Asked Questions(FAQs)

How can One Fix the Sage Payroll?

If you notice a mistake in a previous tax year, it’s easy to fix in Sage 50 Payroll. You need to roll back any periods in the current tax year and then roll back to the period that you need to correct in the previous tax year. You can then enter the correct pay then process your payroll up to date as normal.

How can one Roll back the Sage 50 Payroll?

To do this, you need to:
1. Back up the data.
2. Go to the Employee List
3. Next, click select the needed employees.
4. Now Click Tasks 
5. Next, click Rollback.
6. Click Next 
7. Now click Next once again.
8. Choose the earliest pay period that you wish to remove.
9. In case you select the employee’s first pay period, the following message will be displayed: ‘You have selected the oldest update. Do you also want to clear the following information?’ with a list of information. 
10. Click No on the message. 
11. Keep in mind that you should only click Yes if you are sure that you need to clear the values listed. 
12. Click Next then click Finish.
13. Finally, Click OK

Can you use Sage for Payroll?

Yes, Sage Payroll offers you all that you need to run your payroll and manage your team right. It is also easy to use and you do not need to be a professional to do so.

Related Posts

Further Reading