How do I prepare average holiday rate take on data for import?

Modified on Tue, 10 Dec at 2:31 PM

Normally when paid staff go on holiday, you can calculate their holiday pay based on the previous 52 weeks/12 months to the current payroll period. Should employees not have 52 weeks/12 months of payslip data (because you have not been using the Cintra system for that length of time), Cintra iQ has the facility to allow you to import Take On data so that you can calculate holiday pay and include data that is not available in a payslip.

You can prepare an average holiday rate take on data.csv file to be imported into Cintra iQ. Use the attached avg_hol_rate_takeon_template.xlsx as the method to collect your data before you save it as the .csv file.

Before you begin...

Ensure the date format in the From Date and To Date columns is set as dd-mmm-yyyy.
Ensure you have entered the number of rows per employee that are equal to the number of historical weeks/periods in their previous employment year. e.g. If an employee was on a weekly payroll in their previous employment, they would have had 52 weeks. Therefore, you would enter 52 rows on the template, one row per week.
Ensure you have saved the file in a .csv format before importing it into Cintra iQ.

Attachments (1)

xlsx

avg_hol_rate....xlsx
9.95 KB