---
title: "Importing average holiday rate take-on data"
slug: "how-do-i-import-average-holiday-rate-take-on-data-into-cintra-iq"
description: "Ensure correct date formats and row entries for holiday pay calculations in Cintra iQ. Learn to import Take On data efficiently."
updated: 2026-07-29T08:49:57Z
published: 2026-06-10T11:26:23Z
canonical: "help.cintra.co.uk/how-do-i-import-average-holiday-rate-take-on-data-into-cintra-iq"
---

> ## 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.

# Importing average holiday rate take-on data

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

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.

Once you have entered **Take On** data in the **avg_hol_rate_takeon_template.xlsx**, you need to save the worksheet as a **.csv** file and then it will be ready for import into the **Cintra iQ** database.

## To import the avg_hol_rate_takeon.csv file

1. Navigate to the **Interface Definitions** window. Go to **Cintra iQ**: Tools > Interfaces ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064203.png)
2. Enter **Average** in the **Search** box.
3. Click the **Search** icon. The **Average Holiday Rate** **Data Take On** interface is displayed in the **Definitions** pane. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064204.png)
4. Ensure the **Average Holiday Rate** **Data Take On** interface is selected in the **IN** section.
5. Click the **Open** button. The **Interface History - Average Holiday Rate Data Take On** window appears. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064205.png)
6. Click the **Load File** button. The **Select File To Load** window appears.
7. Select the **avg_hol_rate_takeon.csv** file.
8. Click the **Open** button. The file is imported into **Cintra iQ** database awaiting processing. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064206.png)
9. Click the **Process Unprocessed Files** button. The file is processed.

> [!NOTE]
> **Note:** Click the **File Processing Log** button to view the details of the file's processing.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001064207.png)
10. Click the **Close** button when finished. You are returned to the **Interface Definition** window.
11. Continue to process the **Take On** data.