Droppah's Timesheet Export feature allows you to create a custom CSV file, so that you can easily export your employee timesheet data, ready for import into any payroll or reporting systems.
Export Timesheets
Once your employees have clocked in and out for the week, you can navigate to the Timesheet View and click on the options button in the top right corner of the page. Select Export Timesheet.
A pop-up will appear, confirming the Team and date range you're downloading time for. The date range to export can be changed if required by clicking the Change Dates button, and selecting the appropriate period.
When you're happy with the details, click Export Timesheet to download the timesheets. A CSV file will download to your device.
Customising your Export Template
You can change the formatting and data included in your exported file to suit your company's requirements. To make changes to the template, click on the drop-down menu to the top right of the screen and select Settings, then navigate to the Export Template tab.
The information included in your report is entirely up to you and can be defined by adding or removing columns from the report, and customising how the included columns will appear.
Adding & Removing Columns
To add a new column, select it from the Columns area on the right-hand side of the page. Alternatively, you can click the purple '+ Column' button and select the required columns to add.
To remove a column you no longer require in your export, click the red Remove button, which can be accessed by clicking the column to expand it.
The table below lists the columns available to export out of Droppah.
| Column Name | Data Type | Description |
| Date | Date | The date the time entry is recorded on |
| Duration | Number | The total duration of the time entry, in hours |
| End Time | Time | The end time for the time entry |
| Notes | Text | Any notes associated with the time entry |
| Paid Break Duration | Number | The duration of any paid recorded breaks, in hours. Only applicable if your company uses the Paid Breaks function |
| Person Display Name | Text | The Display Name of the Person the time entry is for |
| Person Export ID* | Text | The Export ID specified on the Person the time entry is for |
| Work Group Export ID* | Text | The Export ID specified on the Work Group associated with the time entry |
| Work Group Name | Text | The name of the Work Group associated with the time entry |
| Start Time | Time | The start time for a recorded time entry |
| Team Name | Text | The name of the Team the entry was recorded against |
| Timesheet Pay Rate** | Number | The pay rate of the time entry |
* These fields will only appear if the 'Allow Export IDs' setting is enabled. See the 'Settings' section of this article below for more information
** If this field is included in the export, Team Managers who don't have the 'Payrates Visible' setting turned on will be unable to export timesheets.
Editing Columns
To customise the details of your columns, click on a column to expand it.
There are two settings you can change on each of the columns in your export:
Alias - Your preferred name for this column. This will be included in your report if the 'Include Headers' setting is turned on, instead of the Droppah name for that field. For example, if your payroll system requires an 'Employee Name' column, you'd want to set that as the alias on the 'Person Display Name' column.
Format - Customise the data format of the column. The format types available are:
| Data Type | Format Options |
| Text | Choose between upper and lower case formatting. Selecting 'None' will format the text exactly as it has been entered in the corresponding Droppah field. |
| Date | Choose between (MM/DD/YYYY), (DD/MM/YYYY), abbreviated (i.e. 14 Oct, 2023) and the date written in full (i.e. 14 October, 2023). |
| Number | Choose to round figures to 0, 1, 2, 3 or 4 decimal places. |
| Time | Choose to have the time written numerically (i.e. 10/14/2023, 1:30 PM), written in full (i.e. Oct 14th, 2023, 1:30 PM) or in 24-hour time with no date information (i.e. 13:30). |
You can also click and drag on the handlebars icon to rearrange the order of your columns to suit.
Settings
In the top right of the page, you can customise two additional settings:
Include Headers - This setting determines whether the first line of your export file contains headings. By default, the headers will be the names of the columns, but you can set an Alias on each column if you wish to customise the header titles - see the 'Editing Columns' section above for more detail.
Allow Export IDs - Enabling this setting will make two additional columns available - Person Export ID and Work Group Export ID. These fields are useful if the system you wish to export to has custom IDs. Once enabled, you will find an 'Export ID' field on your People and Work Groups in Droppah, so that you can specify the appropriate ID that should be exported. See the screenshots below to see where these fields will appear.
Person Export ID
Work Group Export ID
Frequently Asked Questions
Shifts with unpaid breaks generate multiple time entries in Timesheet Exports. This has the following effects on time entries:
-
Unpaid breaks recorded via the time clock create an initial time entry which finishes at the time the unpaid break started. The next time entry starts when the unpaid break finished.
- For example, a 9am to 5pm shift where the employee clocked a 35 minute unpaid break at 12:30pm will be exported as a 9am to 12:30pm entry and a 1:05pm to 5pm entry.
-
Unpaid breaks which haven't been recorded using the time clock (i.e. breaks manually added to a rostered or worked shift, or specified via the Default Break Duration in the shift settings) are assumed to start 4 hours into a shift.
- For example, a 9am to 5pm shift with a 30-minute break will be exported as a 9am to 1pm entry, and a 1:30pm to 5pm entry.
-
In cases where the shift is less than 4 hours long, the break is applied to the end of the shift.
- For example, a 1pm to 4pm shift with a 15 minute unpaid break will be exported as a 1pm to 3:45pm entry.
Time entries that span midnight will be specified in the export in different ways, depending on the 'Midnight Break Rule' you've specified in your company settings.
Click here to learn more: Calendar Settings
Allowances do not have durations or timesheet rates assigned to them, so if you'd like to see the dollar value of an Allowance that's been applied, we'd recommend including the rate in its name as part of the setup process.
Details on setting up Allowances can be seen here: Overtime and Allowances
Comments
0 comments
Article is closed for comments.