The structure detailed below must be used to format the FAST-Pay file. Failure to do so will result in the file being unable to be 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
Pay Run Information (Parent)
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID1 | This field will always be ID1. | ||||
Pay Period | 1 | W, F, M | W = Weekly F = Fortnightly M = Monthly |
||||
Pay Day (Payment Date) | 10 | DD/MM/YYYY | Enter the required Pay Day (Payment Date). | ||||
Period Ending Date | 10 | DD/MM/YYYY | Enter the required Period Ending Date. | ||||
Number of Payees | 5 | Enter the total number of Payees included in the FAST-Pay File. |
Payee Information (Child)
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID2 | This field will always be ID2 | ||||
Payee DBID | 5 | Generate the Payees List Report to obtain the DBID for each Payee. | |||||
Number of Cost Centres | 50 | Enter the number of Cost Centres that this Payees Pay will be split into. | |||||
Cost Centre DBID | 5 | Generate the Cost Centre List Report to determine the correct Cost Centre DBID to use. |
Pre-set Pay Rate and Allowance Information
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID3 | This field will always be ID3 | ||||
Pay Rate or Allowance DBID | 5 | Generate the Pay Rate List and Allowance List Reports to obtain the DBID for each Income Type required. | |||||
Total Quantity | 9 | Enter the total quantity to be paid using this Pay Rate or Allowance. | |||||
Hours Attributed | 50 |
Enter the total hours per Cost Centre separated by a comma. If not applicable, leave blank. |
Variable Pay Rate and Allowance Information
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID4 | This field will always be ID4 | ||||
Pay Rate or Allowance DBID | 5 | Generate the Pay Rate List and Allowance List Reports to obtain the DBID for each Income Type required. | |||||
Total Quantity | 9 | Enter the total quantity to be paid using this Pay Rate or Allowance. | |||||
Rate Value | 9 | Enter the Rate to be paid using this Pay Rate or Allowance. | |||||
Hours Attributed | 50 |
Enter the total hours per Cost Centre separated by a comma. If not applicable, leave blank. |
Pre-set Deduction Information
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID5 | This field will always be ID5 | ||||
Deduction DBID | 5 | Generate the Deductions List Report to obtain the DBID for each Deduction required. | |||||
Total Quantity | 9 | Enter the total quantity to be deducted using this Deduction. |
Variable Deduction Information
Field Name |
|
|
Explanation | ||||
---|---|---|---|---|---|---|---|
ID | 3 | ID6 | This field will always be ID6 | ||||
Deduction DBID | 5 | Generate the Deduction List Report to obtain the DBID for each Deduction required. | |||||
Total Quantity | 9 | Enter the total quantity to be deducted using this Deduction. | |||||
Rate Value | 9 | Enter the Rate to be deducted using this Deduction. |
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 |
DESCRIPTION |
1 |
Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees. |
2 |
First Employee (DBID 22) with 0 Cost Centres |
3 |
First Pay Rate (DBID 12), Quantity of 35 |
4 |
First Allowance (DBID 27), Quantity of 10 |
5 |
Second Employee (DBID 28) with 0 Cost Centres |
6 |
First Pay Rate (DBID 13), Quantity of 10, Rate of 15.50 |
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 |
DESCRIPTION |
1 |
Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees. |
2 |
First Employee (DBID 22) with 2 Cost Centres, DBID 1 and 5 |
3 |
First Pay Rate (DBID 12), Quantity of 35, 15 Hours attributed to Cost Centre DBID1 and 20 hours attributed to Cost Centre DBID5 |
4 |
First Allowance (DBID 27), Quantity of 10, 0 Hours attributed to Cost Centre DBID1 and 10 hours attributed to Cost Centre DBID5 |
5 |
Second Employee (DBID 28) with 2 Cost Centres, DBID 1 and 6 |
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 DBID6 |
7 |
First Deduction (DBID 32), Quantity of 10, Rate of 5.35 |