Solution Properties
Solution ID:
200427112156084
Last Modified Date:
Fri May 09 13:35:34 UTC 2025
Taxonomy Path:
Case category//How do I...//setting up
Author:
[email protected]
Employee year to date (YTD) values
Description

If you set up Sage 50 Payroll part-way through the tax year, you need to enter values for the prior periods.

Your software uses these values to calculate tax for your employees, and includes them on the Full Payment Submission (FPS).

To do this, enter YTD values for your employees.

 TIP: The best source for employee YTD information is P11 Deduction Cards. These can be manual, from previous software, or from Sage 50 Payroll. 

Cause
Resolution

This process is suitable for employees without director status. If you need to enter YTD values for a director, follow our enter director year to date values article.

 NOTE: If you forgot to enter YTD values when setting up your software, enter them before processing the next period. HMRC receives these values on your next FPS. We recommend you contact HMRC to let them know what's happened.  

Tax and National Insurance (NI) YTD values

Follow the steps below to enter your employee's YTD values for tax and NI.

Tax

  1. Click Employee, then select the required employees.
  2. Select Employee Record, then Employment tab.
  3. Click YTD Values.
  4. If you have the employee's P45 or P6 from HMRC, complete the Previous (P45) Employment column with their:
    • Gross Pay for Tax
    • Tax Paid
       NOTE: N/A appears alongside the Total Gross Pay for NIC field. You don't need to change this. 
  5. In the Current Employment Payments column, enter the following information:
    • Total Gross Pay
    • Gross Pay for NIC
    • Gross Pay for Tax
    • Tax Paid
  6.  In the Current Employment Notional Payments column, enter the following information:
    • Gross Pay for NIC
    • Gross Pay for Tax

NOTE: Notional Payments are the total of Benefit in Kind and/or Disguised Remuneration. 

National Insurance

Go to the NIC tab, then enter the following information from the P11 deduction card NIC:

  • Earnings Up To LEL
  • Earnings LEL To PT
  • Earnings PT To UEL
  • Employee Contribution
  • Employer's NIC

Once you've entered these details, click Save, then click Next and repeat these steps for any further employees.

Other values

  1. Click Employee, then select the required employees.
  2. Select Employee Record, then the Employment tab.
  3. Select the YTD Values button. The following tabs are available:
    • Payments and Deductions
    • Attachments
    • Pension (available when you assign more than one pension scheme to the employee record)
    • Statutory Payments
    • Other YTD (if the employee record has one pension scheme, pension YTD values are in this tab)
  4. Click each tab in turn to view the required YTD values and edit them if required.
  5. Click OK, then click Save.

Check the values

If you'd like to review the YTD values, run the report below.

  1. Click Employee, then select the required employees.
  2. Click Reports, then click the Employee folder.
  3. Select the Payment Summary (Part 3) report.
  4. Click Print, then click OK.
  5. Click Close.

 

Steps to duplicate
Related Solutions