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.