Importing to Payroll

Importing to Payroll - CSV Format

Payroll | Payroll Import Types | Details tab | Import Type field

Summary

Comma-separated format.

Null values should contain no data between the commas.

Field Number	Field Name	Format	Comment
1	EmployeeCode	Char 12	Mandatory
2	AllowanceCode	Char 12	Mandatory
3	Quantity	Double - rounds to 2 decimal places	Mandatory
4	RateCode	Char 12	Optional
5	CostCentreCode	Char 12	Optional
6	Date	Date - yyyymmdd	Optional
7	RateAmount	Double - rounds to 4 decimal places	Optional
8	Factor	Double - rounds to 4 decimal places	Optional
9	TotalAmount	Double - rounds to 2 decimal places	Optional
10	Recalculate	Logical - Y/N	Optional
11	ReasonCode	Char 12	Optional
12	JobCode	Char 12	Optional - Imported only if Edit Job codes = "Yes".
13	Reduce Quantity	999.99	Optional - Stored in cargo field.
14	Leave date end	Date - yyyymmdd	Optional - Stored in cargo field.
15	AwardCode	Char 12	Optional
16	PositionCode	Char 12	Optional - Imported only if Edit Position codes = "Yes".
17	Rank	Char 2	Optional
18	Text	Char 250	Optional
19	WAPCode	Char 12	Optional - Will be added only if Company Settings \| Transactions tab \| Edit WAP Codes = "Yes".
20	Lump Sum E Derived Tax Year End Date	Date - yyyymmdd	Optional - The date must meet the following requirements: 1. It must be prior to the pay sequences period YTD end date. 2. It must be a valid period YTD end date. 3. The allowance code must be of the tax override type "Lump sum in arrears".
21	Multi-use field based on Allowance. Holiday Start Date (Annual Leave) OR Absence Start Date (LWOP)	Date - yyyymmdd	Optional Annual Leave - The date that the leave transaction started. LWOP - The date the employee's absence began.
22	Weeks Absent	Char 5 (Value must be >= -9.99 and <= 99.99) If value exceeds the above then Weeks Absent will be set to 0.00 on the transaction after import. If consolidation is enabled and occurs, and value exceeds the above, then Weeks Absent will be set to 0.00 on the transaction after import.	Optional Only used for transactions where: Allowance Type = A. Allowance, H. Hourly, C. ACC, V. Leave Credit Paid, R. Salary and S. Sick/Special Leave. Paying = No Show Weeks Absent = Yes

Notes

Alt_Rate and CostCode are considered to be null values if empty.
Quantity and Factor for this format are always hardcoded to be 1.
If the allowance is not a leave-type allowance (V, S, L or O), then the Rateamount is hardcoded as the Quantity in the import file, and PayGlobal uses the first override rate code that it locates.