You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
e-PayDay Go - Payroll Anytime, Anywhere
FAST-Pay Import Specification (CSV)
print icon

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:

  1. Pay Run Information (Parent)

  2. Employee Information (Child)

  3. Pre-set or Variable Pay Rate Information

  4. Pre-set or Variable Allowance Information

  5. Pre-set or Variable Deduction Information

Pay Run Information (Parent)

Field Name

Max Field Length

 

Value

 
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

Max Field Length

 

Value

 
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

Max Field Length

 

Value

 
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

Max Field Length

 

Value

 
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

Max Field Length

 

Value

 
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

Max Field Length

 

Value

 
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

Feedback
0 out of 0 found this helpful

scroll to top icon