FAST-Pay™ is the ability to import already interpreted data from another system, pre-filling the pay run for review by following Process a Pay Run using FAST-Pay™
The File should be named FASTPAY.CSV and created using Notepad ( CSV (ASCII Text)). In order to import the file into the pay run, please ensure it is saved in the applicable company data folder.
A Sample FASTPAY.CSV is available to download here, which is based on Example 1 below.
The FASTPAY.CSV must be formatted using the below structure otherwise it will be unable to be imported. The Employee, Pay Rate, Allowance, and Deduction records are 1 per Employee. You can not have two or more employees, Pay Rate, Allowance, or Deduction records per line of text.
- Pay Run Information
- Employee Information
- Pre-set or Variable Pay Rate Information
- Pre-set or Variable Allowance Information
- Pre-set or Variable Deduction Information
| Pay Run Information | ||
|---|---|---|
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID1 |
| Pay Period | 1 | W = Weekly, F = Fortnightly, M = Monthly |
| Payment Date | 10 | Date required (eg. 22/07/2020) |
| Period Ending Date | 10 | Date required (eg. 21/07/2020) |
| Number of Employees | 5 | The total Number of Employees included in the file |
| Employee Information | ||
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID2 |
| Employee DBID | 5 | Print an Employee Listing Report to obtain this ID for each Employee |
| Number of Cost Centres | 50 | If inapplicable, enter 0 |
| Cost Centre DBID | 5 | Print an e-Cost Cost Centre Listing Report to obtain this ID for each Employee |
| Pre-set Pay Rate and Allowance Information | ||
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID3 |
| Pay Type DBID | 5 | Print a Pay Rate or Allowance List Report to obtain this ID |
| Total Quantity | 9 | Total Hours for the Pay Rate or Allowance required |
| Hours Attributed | 50 | Total hours per Cost Centre separated by a comma. If inapplicable, leave blank |
| Variable Pay Rate and Allowance Information | ||
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID4 |
| Pay Type DBID | 5 | Print a Pay Rate or Allowance List Report to obtain this ID |
| Total Quantity | 9 | Total Hours for the Pay Rate or Allowance required |
| Rate Value | 9 | Rate Per Hour for the Pay Rate or Allowance |
| Hours Attributed | 50 | Total hours per Cost Centre separated by a comma. If inapplicable, leave blank |
| Pre-set Deduction Information | ||
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID5 |
| Pay Type DBID | 5 | Print a Deduction List Report to obtain this ID |
| Total Quantity | 9 | Total Hours for the Deduction required |
| Variable Deduction Information | ||
| Field Name | Max Field Length | Explanation |
| ID | 3 | Will always be ID6 |
| Pay Type DBID | 5 | Print a Deduction List Report to obtain this ID |
| Total Quantity | 9 | Total Hours for the Deduction required |
| Rate Value | 9 | Rate Per Hour for the 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
1st Line: Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees.
2nd Line: First Employee (DBID 22) with 0 Cost Centres
3rd Line: First Pay Rate (DBID 12), Quantity of 35
4th Line: First Allowance (DBID 27), Quantity of 10
5th Line: Second Employee (DBID 28) with 0 Cost Centres
6th Line: First Pay Rate (DBID 13), Quantity of 10, Rate of 15.50
7th Line: 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
1st Line: Weekly Pay Run, Payment Date 23 July 2020 for Period Ending Date 22 July 2020, paying 2 Employees.
2nd Line: First Employee (DBID 22) with 2 Cost Centres, DBID 1 and 5
3rd Line: First Pay Rate (DBID 12), Quantity of 35, 15 Hours attributed to Cost Centre DBID1 and 20 hours attributed to Cost Centre DBID5
4th Line: First Allowance (DBID 27), Quantity of 10, 0 Hours attributed to Cost Centre DBID1 and 10 hours attributed to Cost Centre DBID5
5th Line: Second Employee (DBID 28) with 2 Cost Centres, DBID 1 and 6
6th Line: 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
7th Line: First Deduction (DBID 32), Quantity of 10, Rate of 5.35