FAST-Pay™ File Specification

What is a FAST-Pay™ File?

FAST-Pay™ enables you to import a CSV file containing each payee's information to compose their pay run, meaning that no changes are required. This file can be created by any third party who consumes time and attendance data and can provide this customer with the interpreted data after applying the relevant rules.

FAST-Pay™ File Specification (CSV)

The structure detailed below must be used to format the FAST-Pay™ file. Failure to do so will prevent the file from being imported.

Sections:

Pay Run Information (Parent)
Employee Information (Child)
Pre-set or Variable Pay Rate Information
Pre-set or Variable Allowance Information
Pre-set or Variable Deduction Information

FAST-Pay Import Specification (CSV)

Example 1

ID1, W, 23/07/2020, 22/07/2020, 2

ID2, 22, 0

ID3, 12, 35

ID3, 27, 10

ID2, 28, 0

ID4, 13, 10, 15.5

ID6, 32, 10, 5.35

Explanation

Line 1 - Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees.
Line 2 - First Employee (DBID 22) with 0 Cost Centres.
Line 3 - First Pay Rate (DBID 12), Quantity of 35.
Line 4 - First Allowance (DBID 27), Quantity of 10.
Line 5 - Second Employee (DBID 28) with 0 Cost Centres.
Line 6 - First Pay Rate (DBID 13), Quantity of 10, Rate of 15.50.
Line 7 - First Deduction (DBID 32), Quantity of 10, Rate of 5.35.

Example 2

ID1, W, 23/07/2020, 22/07/2020, 2

ID2, 22, 2, 1, 5

ID3, 12, 35, 15, 20

ID3, 27, 10, 0, 10

ID2, 28, 2, 1, 6

ID4, 13, 10, 15.5, 5, 5

ID6, 32, 10, 5.35

Explanation

Line 1 - Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees.
Line 2 - First Employee (DBID 22) with 2 Cost Centres, DBID 1 and 5.
Line 3 - First Pay Rate (DBID 12), Quantity of 35, 15 Hours attributed to Cost Centre DBID1 and 20 hours attributed to Cost Centre DBID 5.
Line 4 - First Allowance (DBID 27), Quantity of 10, 0 Hours attributed to Cost Centre DBID1 and 10 hours attributed to Cost Centre DBID 5.
Line 5 - Second Employee (DBID 28) with 2 Cost Centres, DBID 1 and 6.
Line 6 - First Pay Rate (DBID 13), Quantity of 10, Rate of 15.50, 5 Hours attributed to Cost Centre DBID1, and 5 hours attributed to Cost Centre DBID 6 .
Line 7 - First Deduction (DBID 32), Quantity of 10, Rate of 5.35