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.

  1. Pay Run Information
  2. Employee Information
  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
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
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
Number of Cost Centres 50 If inapplicable, enter 0
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
Number of Cost Centres 50 If inapplicable, enter 0
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 25
4th Line: First Allowance (DBID 37), Quantity of 10
5th Line: Second Employee (DBID 23) 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, 30
ID3, 27, 10, 0, 10
ID2, 28, 0., 1, 6
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 2 Cost Centres, DBID 1 and 5
3rd Line: First Pay Rate (DBID 12), Quantity of 25, 15 Hours attributed to Cost Cente DBID1 and 30 hours attributed to Cost Centre DBID5
4th Line: First Allowance (DBID 37), Quantity of 10, 0 Hours attributed to Cost Cente DBID1 and 10 hours attributed to Cost Centre DBID5
5th Line: Second Employee (DBID 23) 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 Cente DBID1, and 5 hours attributed to Cost Centre DBID5
7th Line: First Deduction (DBID 32), Quantity of 10, Rate of 5.35

Revision: 37
Last modified: Jan 20, 2021

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment