The FASTPay 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)

Preset or Variable Pay Rate Information

Preset or Variable Allowance Information

Preset 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 FASTPay 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. 
Preset 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. 
Preset 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 