Uploading Time and Attendance 📇
Now that your colleagues have enrolled in Wagestream, Time & Attendance data should be uploaded. Wagestream recommends that only authorised and approved shifts are inserted into the Wagestream platform.
You can find more information about what to include in the Time and Attendance here.
Video Walkthrough
Example
The example file below shows one employee of ACME Ltd Bugs Bunny an hourly, variably paid employee. Bugs worked three shifts:
- Shift 1: 5-hour standard foundry shift worked on 01/11/2021. There is a one-hour break. The wages earnt are £54.25.
- Shift 2: 6-hour standard foundry shift worked on 02/11/2021. There is a one-hour break. The wages earnt are £65.10.
- Shift 3: 2-hour overtime foundry shift worked on 01/11/2021. The wages earnt are £30.00.
| employee_id | shift_id | worked_on | wages | type | info | started_at | ended_at |
|---|---|---|---|---|---|---|---|
| 0002 | 002_0111_SHIFT1 | 2021-11-01 | 54.25 | STANDARD | Foundry Shift Work - Standard Weekday | 2021-11-01T08:00:00.000Z | 2021-11-02T14:00:00.000Z |
| 0002 | 002_0211_SHIFT1 | 2021-11-02 | 65.10 | STANDARD | Foundry Shift Work - Standard Weekday | 2021-11-02T15:38:00.000Z | 2021-11-02T15:00:00.000Z |
| 0002 | 002_0111_SHIFT2 | 2021-11-01 | 30.00 | OVERTIME | Foundry Shift Work - Overtime Weekday | 2021-11-01T16:00:00.000Z | 2021-11-01T18:00:00.000Z |
You can download an example CSV below.
Example file
Download Shifts File example. Please note when opening a CSV file, your date format may incorrectly change to DD/MM/YYYY. The upload format for Wagestream is YYYY-MM-DD.
File Name
The name of the Time and Attendance file must be 'shifts.csv'. Wagestream will not detect or pick up the file should it have another name or data format.
Updated over 1 year ago