The Bulk Upload All Timesheet Data feature allows authorized users (Workspace Admin, Ops Admin, Back Office, External, AM/CR, Company Users, and Jombone Super Admin) to upload, update, or override multiple candidates’ timesheets at once using an Excel template—making timesheet management faster and more efficient.
How to Access Bulk Upload
Go to the Timesheets module.
Select a Company.
Click the 3-dot menu (:).
Select Upload All Timesheet Data.
🟨 Note:
This option is only visible when a company is selected.
If no company is selected, the option will not appear.
Upload Popup
Clicking the option opens a popup with the following:
Option | Description |
Browse | Upload your |
Upload | Submit the file |
Cancel | Close the popup |
Download Template | Download the Excel template |
Download Template
Click “Download All Timesheet Bulk-Upload Template” to download the template.
The template includes:
Data Included |
All active employments for selected company |
Job and location details (based on access) |
Work week format (e.g., Sun–Sat / Mon–Sun) |
Latest shift details (from shift roster) |
🟦 Info: The template is pre-filled to ensure accurate mapping of candidates, jobs, and shifts.
How to Upload Timesheet Data
Download the template.
Fill in the required timesheet data.
Click Browse and select your file.
Click Upload.
Upload Processing
After clicking Upload:
A processing popup will appear.
The system processes the file asynchronously.
Success Message
Once processing is complete, you will see:
🟩 “Timesheet upload processing is complete. You will receive a status email shortly.”
Email Notification
After processing, an email is sent to the logged-in user.
Email Includes
Detail |
Number of successful rows |
Number of errored rows |
If Errors Exist
🟥 The email will include:
An attached Excel file
Failed rows only
An ERROR column explaining each issue
🟨 Note: You can correct the errors and re-upload the file.
Data Handling Rules
Scenario | Behavior |
Valid rows | 🟩 Saved successfully |
Invalid rows | 🟥 Rejected |
Partial upload | 🟦 Supported (valid rows saved, invalid skipped) |
Existing entries | Overwritten if not locked/approved |
Locked/approved timesheet | 🟥 Upload fails |
Validation Rules & Common Errors
Timesheet Lock
Scenario | Result |
Timesheet is locked | 🟥 Row fails with: “Timesheet is locked.” |
Shift Validation
Scenario | Result |
Shift does not match roster | 🟥 Entire row fails |
Future Date Entries
Scenario | Result |
Any future-day data present | 🟥 Entire file fails |
Previous valid entries in same file | Not uploaded |
Data Format Errors
Scenario | Result |
Non-numeric values in numeric fields | 🟥 Entire file fails |
Invalid data format | 🟥 Row fails |
Hours Validation
Scenario | Result |
Hours > 24 in a day | 🟥 Row fails |
Important Notes
🟨 Important
File must be in .xlsx format
Each row is processed independently (except full file failures like future dates or Non-numeric values)
Ensure shift roster alignment before upload
Avoid entering future dates
Always validate numeric fields (hours, etc.)
Locked or approved timesheets cannot be updated