---
title: "Preparing average holiday rate take-on data for import"
slug: "how-do-i-prepare-average-holiday-rate-take-on-data-for-import"
description: "In Cintra iQ, prepare a CSV file of historical pay data for employees without 52 weeks/12 months of payslip history, ready for import."
updated: 2026-07-29T08:49:52Z
published: 2026-06-10T11:26:23Z
canonical: "help.cintra.co.uk/how-do-i-prepare-average-holiday-rate-take-on-data-for-import"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.cintra.co.uk/llms.txt
> Use this file to discover all available pages before exploring further.

# Preparing average holiday rate take-on data for import

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**

[avg_hol_rate_takeon_template.xlsx](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/avg_hol_rate_takeon_template.xlsx)