165
The FAST-Pay file must be formatted using the structure detailed below. Otherwise, it will be 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 Dat) | 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 |
