For DSPs: Export data from TSM

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.

TABLE OF CONTENTS

• Export Employee Data
• Export Timesheets (Attendance records)
• Export variable pay data

Export Employee Data

1. Log into your Timesheet Mobile account: https://dsp.timesheetmobile.com
2. Navigate to the Employees tab from the main menu.

3. Review the employee list and ensure all relevant fields are filled (e.g., name, email, role, department, pay rate).

4. Clock on More options and then you select Download CSV

5. Once downloaded, you can save the file as: Employees_TSM.csv

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

 Export variable pay data

Variable pay data is not stored or exportable in TSM.