SurePayroll is a very popular online employee payroll system that will calculate wages, pay your employees and help you stay compliant with payroll taxes & regulations. We’re happy to say that our pc time clock software, Time Clock MTS will now integrate with SurePayroll allowing you to quickly and easily export your employee time and attendance data to your payroll system. Here’s the steps that need to be taken to produce a data file suitable for exporting to SurePayroll.
1. Map Employee Names and ID’s Correctly
Time Clock MTS uses only one field for employee’s names while the SurePayroll system requires a first and last name. To get around this you must name your Time Clock MTS employees using the form LastName, FirstName. It is vital that you get the comma in between the last and first name. You can see in the image above that the employee is named Jones, Bill.
The second thing to ensure is that the Time Clock MTS employee Badge ID matches your SurePayroll employee numbers exactly. If this is not done then the time clock data for that employee will not be able to be imported to your payroll system. Above you can see that the employee Badge ID is 1010, this must be the same as the SurePayroll employee number.
2. Export Data Using the Pre-Defined SurePayroll Export Format
The next step is to actually export the data. This is done from within Time Clock MTS on the Reporting->Data Export->Export Data screen (shown above). Use the selection boxes on the left to choose what employee data you want to export. The date selection buttons on the top right allow you to select the date range that you want to export time clock data for. When you are happy with both the employee selection and the date range click the Export Data button to start the data export process. When the export is complete a Notepad window will pop up and you’ll see your exported data (see the image below). You can now save this file with the correct name and file extension required by SurePayroll and import it into your payroll system.
