---
title: "Bulk import one-off payments and deductions"
slug: "bulk-import-one-off-payments-and-deductions"
updated: 2026-09-25T14:40:28Z
published: 2026-09-25T14:40:28Z
canonical: "help.cintra.co.uk/bulk-import-one-off-payments-and-deductions"
---

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

# Bulk import one-off payments and deductions

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](/payroll/docs/bulk-import).

### Importing one-off payments and deductions

1. Open a payroll and select the **One-off payments & deductions** tile.
2. Select **Add One-off Payments & Deductions**.
3. Select the **Bulk import** tab.
4. Select **Download Template**.
  - Alternatively, if you already have the import data in a separate spreadsheet, you can upload it directly without completing step 5.

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/image(630).png)

1. [Complete the checklist](/payroll/docs/bulk-import-one-off-payments-and-deductions#completing-the-bulk-import-template).
2. Upload the saved template in the area below.
3. Cintra People will help you match the columns in your spreadsheet to the correct fields. See [Bulk import - Mapping columns](/payroll/docs/bulk-import#mapping-columns).
4. 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](/payroll/docs/bulk-import#fixing-errors).

### **Completing the bulk import template**

1. Open the downloaded template in Excel or other spreadsheet program.
  - You may have to select **Enable Editing** to make changes.
2. 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:

![](https://cdn.document360.io/fc2cda72-4645-4b36-96bf-60439ec11f11/Images/Documentation/image(715).png)

1. Do not change the column heading names: this will cause the import to fail.
2. 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.
3. If there are any errors, select **Cancel Import**, fix the errors, then upload again. See [Validation errors](/payroll/docs/bulk-import-one-off-payments-and-deductions#validation-errors).
4. If there are no errors, a summary of the validate rows will be displayed. Click **Complete Import** to finish.
5. Click **Recalculate** to recalculate the payroll.