How do I create import maps for pay period data?

Modified on Tue, 30 Dec, 2025 at 10:17 AM

TABLE OF CONTENTS

Batch imports and import maps
To create an import map
Applying the import map to the new Batch Input record

Batch imports and import maps

Payroll data such as ad hoc payments and deductions can be entered into Cintra iQ by bulk using batches. Ad hoc Payroll Period Input data can be holiday pay, overtime, bonuses, etc.

The batches of Payroll Period Input data can be either directly entered into a template defined previously or imported from .csv files that have been mapped to templates.
Any records that have been generated from a batch can be amended via the batch or in payroll period input.
Any records that are in a batch are posted to the employee records immediately once the batch is closed.
All batches can be amended at any time prior to the period being closed.

Cost Centre Allocation data can be included in batches, eliminating the need for manual journal entries to be made, post payroll processing.

Within Cintra iQ, you can create a Standard or Template Payroll Import Map, which can be used as the basis for importing a batch of Pay Period data. Once the map is created, it can be selected on the New Batch form.

To create an import map

Navigate to the Payroll Import Maps window.
- Go to Cintra iQ: Payroll> Payroll Setup> Import Maps.
Click the New button. The New Import Map dialogue appears.
Enter the Import Map Name.
Enter the Description.
Select whether the map is either of the following:
- Standard Import: A standard import map contains all pay values in one column with a payment heading (adjustment) name or code in a separate column.
- Template Import: A template import map contains specific payment headings in separate columns on the file that is to be imported. If you want to input predefined payment and deduction headings that are in separate columns, use the Template Import Map.
Click the Next button.
Select the Import file from the desired location. The Standard/Template Batch Import Map window appears.
Click the Load Columns button. The Column names appears in the Column Mappings pane and the Specify Column Headers dialogue appears.
1. Specify the number of column and rows, if necessary.
2. Click the OK button.
Map the desired adjustment headers to the desired columns.
1. To do this, select a column header on the left, then either double-click the relevant adjustment heading on the right.
2. If you change the mapping file, click Load Columns to reload the column headers.

Click the OK button. The map appears in the Payroll Import Maps window.

Note: Ensure any spreadsheets are saved as .csv before importing to Cintra iQ.

Applying the import map to the new Batch Input record

In the main toolbar of Cintra iQ, click the Batch icon.
In the Batch Input window, select the correct payroll and payroll period.
Right-click in the main window, then click New.
In the New Batch form, select the appropriate import map (standard import map or template import map).
Click Next, locate and select the file, then click Open.
Specify the number of header lines in the file, then click OK.
In the Import screen, select the correct map from the Use Map drop-down, then click Use Map.
The pre-defined mapping will then be applied. Click Next to continue entering data.
1. For more information, see Guide: Batch input of payroll data.