CSV Export — Field Guide for HR & Payroll
A reference for the person importing a Shift Show export into a payroll or HR system.
Reference document only
This export is a data report generated from information entered in the Shift Show app by the employee. Shift Show does not integrate with any payroll system and does not submit data to an employer on the user's behalf. HR / payroll should review and verify all figures against official records before use, and is responsible for mapping and importing the file into their own system.
This guide is provided for general reference only and does not replace the documentation or support channels of your payroll software provider. Please confirm import requirements directly with your payroll provider before relying on this guide. Shift Show and Jittercat accept no responsibility or liability for errors, omissions, or outcomes arising from the import or use of this data in any third-party payroll or HR system. See our Terms of Use for full detail.
1 What this file contains
Each row represents one shift or leave entry, exactly as entered by the employee in the app. Column headers are fixed and always appear in the order below.
| Column | Description | Format | Example |
|---|---|---|---|
| Employee Name | Full name as entered in the app's HR settings | Text | Jane Dlamini |
| Staff Number | Employee / staff ID as entered in the app | Text | 720003102 |
| Date | Calendar date of the shift or entry | YYYY-MM-DD | 2026-07-06 |
| Shift Type | Shift category worked, as configured by the employee. Blank on rows that are a leave entry rather than a worked shift. | Text | Night Shift (12h) |
| Ordinary Hours | Standard hours for the shift that are not Sunday time, public holiday time, or overtime | Decimal | 12.00 |
| Overtime Hours | Hours worked beyond the standard shift length | Decimal | 0.00 |
| Sunday Hours | Portion of the shift worked on a Sunday | Decimal | 0.00 |
| Public Holiday Hours | Portion of the shift worked on a public holiday | Decimal | 0.00 |
| Total Hours | Total hours recorded for this row (Ordinary, Overtime, Sunday, and Public Holiday hours combined). Zero on leave rows, where the hours are recorded under Leave Hours instead. | Decimal | 12.00 |
| Leave Type | Type of leave recorded, if applicable. Blank on rows that are a worked shift rather than a leave entry. | Text | Annual |
| Leave Hours | Hours of leave recorded for the entry | Decimal | 0.00 |
| Sunday/PH Rule Applied | Which counting rule the employee's Shift Show settings used to resolve a shift that qualifies as both Sunday time and public holiday time. One of: "Public holiday overrides Sunday", "Sunday overrides public holiday", or "Both Sunday and public holiday apply". Recorded on every row for reference, even where it made no difference to that row's figures. | Text | Public holiday overrides Sunday |
Reading a leave row: a day recorded as leave has a blank Shift Type, zero in every hour column except Leave Hours, and the leave category named in Leave Type — for example, a full day of annual leave appears as Annual in Leave Type with 12.00 in Leave Hours and 0.00 everywhere else.
2 Importing into a payroll system
Shift Show produces one generic CSV format. Most enterprise payroll and HR systems (Oracle HCM, Workday, ADP, Sage, SAP SuccessFactors, and others) include a CSV import or column-mapping feature for external timesheet data, although the exact process — and whether it is available at all — depends on the software edition, installed modules, user permissions, and configuration used by your organisation.
- 1Open the CSV in the payroll system's import / upload tool (often called "Import Timesheet," "Bulk Upload," or "Time & Labor Import"), if your payroll software supports CSV imports.
- 2Match each column to the corresponding field in the payroll system — for example, "Overtime Hours" in this file to whatever field the payroll system uses for overtime.
- 3Save the mapping if the system allows it, so future exports can be imported without repeating this step.
- 4Review the totals against the employee's official schedule or timesheet before finalising the import.
Not every column needs to be mapped. Most import tools let you skip fields your organisation doesn't use (for example, Sunday/PH Rule Applied, which is provided for reference rather than for payment calculation) — only your system's own required fields (typically an employee identifier and date) usually must be mapped for the import to succeed.
Combining several employees at once? If you've received a separate CSV per employee for the same pay period, our Manager's Tool can combine them into one file and flag common issues (duplicate submissions, missing employees, dates outside the pay period, or totals that don't add up) before you import — it runs entirely in your browser and nothing is uploaded anywhere.
3 Before you import
✓ Confirm the reporting period matches your payroll cycle
✓ Cross-check overtime and Sunday hours against your own rules
✓ Verify the Staff Number matches your payroll employee ID
✓ Confirm public holiday dates match your local calendar