Cintra People Payroll has a new import tool to streamline the import process. For more general information on the tool - including which other areas you can import to - see Bulk import.
Importing one-off payments and deductions
Open a payroll and select the One-off payments & deductions tile.
Select Add One-off Payments & Deductions.
Select the Bulk import tab.
Select Download Template.
Alternatively, if you already have the import data in a separate spreadsheet, you can upload it directly without completing step 5.
.png)
Upload the saved template in the area below.
Cintra People will help you match the columns in your spreadsheet to the correct fields. See Bulk import - Mapping columns.
After mapping columns, you will be shown a list of all the data to be imported, with any errors highlighted in red. These must be fixed before completing the import. See Bulk import - Fixing errors.
Completing the bulk import template
Open the downloaded template in Excel or other spreadsheet program.
You may have to select Enable Editing to make changes.
For each payment or deduction, you must add information for each column into a new row.
When you select any cell, a tooltip provides more information about any validation rules:
.png)
Do not change the column heading names: this will cause the import to fail.
The mandatory columns depend on your payroll setup and the type of payment. The following sets of columns apply:
Employment ID, First Name, Surname.
Header: Select the type of payment / deduction from the drop-down list. This list is maintained in Cintra iQ.
Units: Either enter the number of hours worked, or to transfer a single amount of money, enter “1”
Rate / Amount: Either enter the hourly rate, or to transfer a single amount of money, enter the amount to be paid. If your payroll team manages these rates, you can leave this field blank.
From Date / To Date: If payments relate to a previous period, enter the actual From and To date so that employee payments are calculated correctly for hourly rates (e.g. overtime rates). If the From date is left blank, the current period is used.
Post: If the employee has more than one position, enter which position this payment / deduction relates to. Otherwise, leave blank.
Notes: Free text field
Cost Code(s): Where applicable, select suitable cost-codes from the drop-down list.
If there are any errors, select Cancel Import, fix the errors, then upload again. See Validation errors.
If there are no errors, a summary of the validate rows will be displayed. Click Complete Import to finish.
Click Recalculate to recalculate the payroll.