Create Column based Mapping templates

If the uploaded payments file has multiple payments on each row, the Type of Mapping template used for the import must be Column based.

1. Select the Type as Column based.
2. To set how the payment information is imported, select an option from Import method.
3. If the file has header labels in the columns, select File has header row.
4. If a Department and Cost Centre apply to each row, select Has payline costings.
5. For each column in the import file, select Add a Column.

6. Enter the required details for the details in that column, then select Create.

   There are additional settings to allow more flexibility about the data: 

   • Reference Only — The information in the column is not to be imported and is only for reference.
   • Gross Up Target Net — The value applies to a payment with Gross up Target Net set for the pay code.
   • Multiplier — Sets whether the columns contains values that are hours or days rather than a monetary value.
7. Select Save mapping.