Data Conversion

2. Balances (1 per employee)

If you start the implementation mid way through a tax year you will also require the following P14/P60 details:

2.1 Parallel Processing

EMP_ID                             Employee Reference

Previous Employment (this tax year)

TAX_GROSS_PREV         Taxable Pay

TAX_PAY_PREV              Tax Deducted

This Employment (this tax year)

TAX_GROSS                    Taxable Pay

TAX_PAID                        Tax Deducted

2.2 General Information

If you are proposing to submit End of Year returns for the Tax Year in the software application then the following accumulated balances will be required in addition to the PAYE values described above.

EMP_ID                             Employee Reference

SSP                                   SSP (Number of days of SSP paid)

SMP                                  SMP (Number of days of SMP paid)

SPP                                   SPP (Number of days of SPP paid)

SAP                                   SAP (Number of days of SAP paid)

STUDENT_LOANS            Student Loan Deductions

3. National Insurance Balances

There should only be 1 occurrence of this set of details for an employee, but if an employee has changed NI Category in the course of the tax year then a second set may be present. There could be a 3rd or 4th set but this is unlikely.

If it is known that only one set exists for all employees then this file can simply be an extension of the previous file.

EMP_ID                              Works/Payroll No.

NI_CAT                               Category

NI_AtLEL                            Earnings at LEL

NI_LELtoET                        Earnings between LEL & ET

NI_ETtoUAP                       Earnings between ET & UAP

NI_UAPtoUEL                     Earnings between UAP & UEL

NI_EE_CON                        Employee Contributions

NI_ER_CON                        Employer Contributions

NI_1_SCON                        Scheme Contracted-out Number

This is optional and may not be available for any employee.