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 then uses these values to calculate tax for your employees.

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.


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. Click Employee Record, then click the 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

Click 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 YTD 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 YTD values are correct

  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