BundyPlus has a simple generic export file that can be used with any external payroll system that can map their importer to specific fields.
Filename
The exported filename will be either Transactions.txt or Transactions.csv
File format
Site.Clock#,Direction,ID,Date,Time,DepartmentID,JobActivityID1,JobActivityID2,JobActivityID3,JobActivityID4,
Transaction Fields and Requirements
- Site.Clock# (Required) - is the Site.clock number. Site and clock number is a max of 4 digits on either side.
Can be used to determine which location the clocking came from. - Direction (Optional) – is the direction of which the employee has clocked
I - In
O - Out
U - Unpaid Break
B - Paid Break
T - Transfer (Typically used to swap between jobs) - ID (Required) – This field is a max of 9 digits.
BundyPlus Studio use - Ensure this ID matches the Card ID field
External Use - Ensure this ID matches the Payroll/Employee ID - Date (Required) - Date the clocking was made
Format of DD/MM/YYYY - Time (Required) - Time the clocking was made
HH:MM:SS – 24 hour format
Job Costing is optional, however if required, please see next few fields
- DepartmentID – Department Code
Maximum of 9 numerical digits
Eg. Location, Department etc - JobActivityID1 - Level 1 Job activity
Maximum of 9 numerical digits - JobActivityID2 - Level 2 Job activity
Maximum of 9 numerical digits - JobActivityID3 - Level 3 Job activity
Maximum of 9 numerical digits - JobActivityID4 - Level 4 Job activity
Maximum of 9 numerical digits
Sample Transactions
Important notes:
- The commas are still required if there is no job costing
- Job costing can be present without a Department
No Direction file format -
- 0001.0001,,123456789,17/02/2019,11:20:21,,,,,,
- 0001.0001,,123456789,17/02/2019,19:46:02,,,,,,
Non Job Costing file format –
- 0001.0001,I,123456789,17/02/2019,11:20:21,,,,,,
- 0001.0001,O,123456789,17/02/2019,19:46:02,,,,,,
Job Costing file format –
- 0001.0001,I,800567,16/03/2019,05:45:02,54,J11,J11,562,123,
- 0001.0001,O,800567,16/03/2019,15:37:17,1,2,3,4,5,
Please see attached sample transactions file for more examples.
If you have any further queries, please feel free to give support a call on 03 9873 0355