--- title: "Importing P11D benefits" slug: "how-do-i-import-p11d-benefits" description: "Import P11d benefits into Cintra iQ with our step-by-step guide and generate insightful reports effortlessly. Streamline your data management today!" updated: 2026-07-29T09:02:05Z published: 2026-06-10T11:26:23Z canonical: "help.cintra.co.uk/how-do-i-import-p11d-benefits" --- > ## 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 P11D benefits The **Cintra iQ** system allows users to import **P11d benefits** and subsequently run reports on the imported data. Here's a step-by-step guide to assist you in doing so: ## **Prepare the Data File** 1. Create a new file in a spreadsheet program (like Microsoft Excel or Google Sheets). 2. Add the following column headers: > [!NOTE] > **Note:** The "Made good" column can remain empty, but it's essential to include the column. - ID number - Value of benefit - Made good 3. Save the file in a .csv format for easy import. ## **Import the Data into Cintra iQ** 1. Launch the Cintra iQ software. 2. Navigate to the **Menu Bar > Expenses & Benefits > Import of Expenses and Benefits > Other Expenses**. ![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/204001066364.png) 3. Adjust the tax year accordingly. 4. Click on the **User Benefit Heading** option. 5. Press the **Next** button, which brings up the **Select File To Be Imported** window. 6. Choose and select your saved .csv file. 7. Map the three columns to their corresponding fields in Cintra iQ. Ensure that each column aligns correctly. 8. Click the **Next** button. - Be alert: If there are errors, such as an incorrect ID number, Cintra iQ will notify you of the problem. This allows you to make necessary corrections and re-import the file effortlessly. - Upon successful import, Cintra iQ will confirm that all the lines have been imported without issues. ## **Run a Report on the Imported Data** 1. Go to **Cintra iQ: Menu Bar > Expenses & Benefits > Reporting > Payrolled Benefits Summary**. 2. You will see two reporting options: - By Employee - By Benefit Choose the one that best suits your needs, and the report will be generated based on the imported data.