Cintra Cloud salary and allowances import template

Modified on Sat, 7 Dec at 5:56 PM

If you are bulk importing salary and allowances into Cintra Cloud, you will need to download a salary and allowance template, instructions to download the template can be found on How Do I Import Salary and Allowances into Cintra Cloud?

Note:

Salary and allowances within Cintra Cloud used to be called recurring payments.

Important:

We are continually improving and adding new features to Cintra Cloud. Please be aware that Cintra Cloud can be updated without notice.

Salary and Allowances Template Format

Column Name	Required	Expected Value	Comment
Employment ID	Yes	Max length 10	Employment ID must exist in Cintra Cloud.
First Name	Yes	Max length 30	Employee's first name
Surname	Yes	Max length 35	Employee's Surname
From Date	Yes
To Date
Addition Heading	Yes	Either Payment Heading Name or Batch Import Code	Heading / Import Code must exist in your payroll. If you are unsure of your payment headings please reach out to your Cintra contact.
Annual Amount		numeric value	See table below
Rate/Period Amount		numeric value	See table below
Inherit Standard Amount		Y or N	Use standard amount that has been setup as default in your payroll.

Payment Type Unit * Rate Requirements

Unit Times Rate	Ad hoc flag	Example	Rate	Unit	Annual Amount	Periodicity
True	True		Required (1000.0)	Blank	Blank	Blank
False	N/A	Annual amount 35000	Calculated: annual amount / payroll salary divisor	Blank	Required (35000.00)	Derived from the payroll (payroll membership)