For information about outages and scheduled maintenance, click here

Cintra Cloud one-off payment and deduction import template

Modified on Sat, 7 Dec at 5:56 PM

If you are bulk importing one-off payments and deductions into Cintra Cloud you will need to download a one-off payment template, instructions to download the template can be found on How Do I Import One-Off Payments in Cintra Cloud?
 

  Important

We recommend you download a fresh template from Cintra Cloud before completing each payroll period.

 

  Important

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

 

How do I complete the template? 

Column Name Required Expected Value Comment
Employment ID Yes Max length 10 Employment ID (This can be found in Cintra Cloud)
First Name Yes Max length 30 Employee's first name
Surname Yes Max length 35 Employee's Surname
Header Yes Either Payment Heading Name or Batch Import Code
Select payment heading from the pre-populated dropdown.
 

  Note:

If you are not sure what heading to select, please reach out to your payroll contact.

 
Units   numeric value See table below
Rate   numeric value See table below
From Date   Date
If no dates are provided, Cintra Cloud will automatically populate for you with the start and end date of the payroll cycle.
 

  Good to Know

If you would like to break payments down on employee payslips, enter from and to dates for each payment.

 
 

  Important

For example if an employee works 3 lots of overtime in a period. If this is entered as three separate rows detailing dates when the overtime was worked. It will provide the employee with a breakdown on their payslip. Alternatively, if you don't want the breakdown on the payslips, overtime worked could be totalled an imported as a single row.

To Date   Date  

 

How Do I Complete the Unit and Rate Columns?

Scenario  Rate Unit

I want to manually enter hours and rates.

For example pay employee 10 hours at £5 per hour. 
 
To pay an employee 10 hours at £5 per hour enter 5 into the rate column and 10 into the units column. 
 

Required (5.00)

Required (10.00)

I want to pay an employee a cash amount

For example I would like to pay a cash amount of £100.

To pay an employee a cash amount you will need to enter the amount in the rate column and 1 in the unit.  

Required (100.00)

Required - always 1

My payroll team manage rates

In most cases rates will be held in the payroll system.  Enter the number of hours to pay in the unit column and leave the rate column blank.  
 

  Note:

If you are not sure whether you should include a rate, please reach out to your payroll contact.

 

 

Required (10.00)

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article