How do I export timesheet data in EPAY format?

Clean Smarts is capable of exporting timesheet data into a format that can be uploaded into EPAY payroll systems.

Enable the Integration

1. Option 1: Click your profile in the bottom left corner, go to Company Settings.
   Option 2: Use the search bar at the top left (or press Ctrl+K) and type Company Settings.

2. Select Payroll from the menu and click on the Your Payroll Software dropdown.

3. Select EPAY. 

4. Click Save Changes. 

Setting Employee Numbers

EPAY employee numbers and department codes must be defined in Clean Smarts, and these are exported in the EPAY report.

1. Go to Manage Users and select the employee profile you want to edit. 
2. Go to the Payroll tab and enter the EPAY Payroll System ID.
3. Save. 

Setting Department Codes

1. Go to Manage Location and select the location you want to edit.
2. Click the General tab and scroll down to Integrations. 
3. Enter the Payroll System ID. 
4. Save the location.

Exporting Data

1. To export data, go to Time Tracking > Approve Timesheets.

2. Click on the Export Data icon button in the top-right of the screen labeled "EPAY"

Data from Clean Smarts is mapped to a .csv file in the following manner, by column:

1. Employee #: User's employee code, as entered in the "External Payroll ID" field.

2. Name: User's first and last names, concatenated.

3. Override Dept: Location's department code (location associated with the check in), as entered in the External Payroll ID field.

4. Job: Not used.

5. Shift: Not used.

6. D/E/R: Will always be "E".

7. Earn Code: If the check in has a pay code, this will be the pay code description. Otherwise "01" for regular time and "02" for overtime.

8. Rate: User's pay rate.

9. Hours: Duration of the check in, in hours.

10. Year: Year of the check in.

11. Month: Month of the check in.

12. Day: Day of the check in.

13. Hour: Not used.

14. Minute: Not used.

15. Amount: Not used.

16. Seq Number: Not used.

17. Override Division: Not used.

18. Override Branch: Not used.

19. Override State: Not used.

20. Override Local: Not used.

21. Blank Fill: Not used.

22. Deduction 3 hours: Not used.

23. Deduction 3 amount: Not used.

24. SSN: Not used.

25. Workers’ Compensation: Not used.

26. Rate Number: Not used.

27. Punch In: Formatted check in time.

28. Punch Out: Formatted check out time.

29. Override Team: Not used.

30. Check Comments: Not used.

31. Line Item End Date Year: Not used.

32. Line Item End Date Month: Not used.

33. Line Item End Date Day: Not used.

Still need help? Contact us