Cintra People Payroll: New starter import template

Modified on Fri, 16 Jan at 10:59 AM

If you are bulk importing employees into Cintra People Payroll - you will need to use the upload template. For more information, see Employee: Adding, editing, importing, and deleting.

This article provides more guidance on what to enter into each of the fields/columns found in the template.

Column Name	Required	Expected Value	Comment
Employment ID	Yes	Max length 10	The employment ID is needed for creating new employment records. The identifier provided is used to communicate employee payment details through the Full Payment Submission (FPS) to HMRC on payment to the employee.
Title		Max length 4	Mr, Mrs, Miss, Dr etc.
First Name	Yes	Max length 30	Employee's first name
Middle Name		Max length 30	Employee's middle name
Surname	Yes	Max length 35	Employee's surname
Gender	Yes	Male or Female
Date of Birth	Yes	Date
Address Line 1		Max Length 35
Address Line 2		Max length 35
Address Line 3		Max length 35
Address Line 4		Max length 35
Address Postcode		Valid postcode must be provided
Address Country		Max length 35
NI Number		Valid NI Number must be provided
Marital Status		Single Married Divorced Widowed Separated Civil Partnership With long term partner	Can be left blank.
Email		Max length 250 Valid email address must be provided	Employees main email address, this email address will be used for employee notifications through employee and manager Self-Service.
Email 2		Max length 250 Valid email address must be provided	Typically used for a secondary or private employee email address.
Religion
Nationality
IR35 Off Payroll Worker	Yes	Y or N
Start Date - Continuous Service		Date
Start Date	Yes	Date
Leaving Date		Date
Employment Status	Yes	Permanent Temporary Casual
Payment Method	Yes	Transfer Cash Cheque Internl
Payment Sort Code	Yes	Valid sort code 00-00-00
Payment Account Number		Max length 8	Eight digit account number
Payment Payee	Yes	Max length 60	Name of Payee
Payment Account Reference		Max length 18
Payment Autopay ID		Max length 8
Leaving Reason			Available Values: Deceased Dismissed - Failed Probation Dismissed - Gross Misconduct Dismissed - Ill Health Dismissed - Performance Dismissed - Redundancy End of Contract End of Volunteering End of Work Experience Mutual Agreement On System Twice Resigned After Stat Leave Resigned AlternativeEmployment Resigned Personal Reasons Resigned Promotion Resigned Relocation Resigned Retirement Resigned Under Performance Mgt Resigned Visa Expired Tupe Other
Pay Point
Salary effective date		Date
Salary Heading Name			Salary heading must exist in your payroll environment.
Salary Amount			This can be FTE or Annual salary depending on your payroll setup. If you are unsure, contact your Cintra representative.4