This guide explains how to export your data from Timesheet Mobile (TSM) in the correct format for import into Kenjo. The article covers four datasets: employee data, timesheets including attendance and time off records, and variable pay. Follow these steps to prepare your data for migration.
This guide explains how to export your data from Timesheet Mobile (TSM) in the correct format for import into Kenjo. It is divided into four sections, one for each required dataset:
Employee data
Timesheets (attendance & time off (vacations, sickness, absences) records
Variable pay (bonuses, commissions)
Note: The users can customize columns during an export. The columns below are mandatory for the time off import to work in Kenjo. - Site- Hours- Include Row(s) for Subtotals and Totals
To get a detailed understanding of migrating time off data from TSM, please read this article.
1. Export Employee Data
Log into your Timesheet Mobile account: https://dsp.timesheetmobile.com
Navigate to the Employees tab from the main menu.
Review the employee list and ensure all relevant fields are filled (e.g., name, email, role, department, pay rate).
Clock on More options and then you select Download CSV
Once downloaded, you can save the file as: Employees_TSM.csv
2. Export Timesheets (Attendance and time off records)
Unlike Kenjo, In TSM attendance & time off are part of the same dataset. Exporting attendance also exports time off records.
Go to the Reports section in the main menu and click on Timesheets
Filter the records by the desired date range (e.g., last 2 weeks or last month).
Review the entries (employee name, clock-in/out times, job codes, hours worked).
Click on the Download Arrow and select Employee CSV
You can save the file and name it as: Timesheets_TSM.csv
3. Export variable pay data
Variable pay data is not stored or exportable in TSM.