Upload timesheet data to WFM using Integration Central

Follow this guide to upload shift and timesheet records in bulk to Humanforce WFM using the Integration Central file import tool. This supports accurate tracking of worked hours across teams, especially in backdated or unscheduled workflows.

This task is designed for organisations managing shifts at scale or importing historical time data for payroll reconciliation and compliance.

If you're not familiar with the Integration Central file import feature, read Configure and run file import tasks in Integration Central before continuing.

For new users: All uploads are validated for formatting and field matching. The system accepts shift records for both scheduled and ad-hoc work periods.

Part 1: Prepare the timesheet file

1. Go to Management > Advanced > Integration Central > Add New > File Import.
2. Set the Data type to Timesheet Data.
3. Click Download template to get the latest version.
4. Open the newly downloaded template.
   • Review the field requirements in the reference section below to ensure your data is valid and complete.
5. Enter timesheet data into the file using the required headers
6. Save the file locally in .CSV format.

When your file is correctly structured and saved, it's ready to upload in Integration Central

Part 2: Upload the timesheet file

1. Go to Management > Advanced > Integration Central > Add New > File Import.
2. Set the Data type to Timesheet Data.
3. In the File section:
   • For an ad-hoc upload, drag and drop your file into the upload box, or click Browse to select the file from your computer.

   • For a scheduled upload, click Humanforce SFTP import.

     Note: You must have SFTP configured. To learn how, see How to setup the Humanforce SFTP folder.

4. (Optional) In Task completion notification, enter an email address to be notified when the import finishes.
5. Click Next.

Once your file is uploaded successfully, the system will automatically detect and display the column headers in the mapping screen.

Part 3: Configure field mappings and import the file

1. Review the Field mapping screen.
2. Select or update the following if required:
   • Field mapping rules (checkboxes at the top)
   • Source fields > target fields mapping
   • Format specifiers (e.g. dd/MM/yyyy, hh:mm AM/PM)
   • Lookup types and default values
3. Click Next.
4. Choose one of the following:
   • Save mapping & import – if you plan to reuse this setup in future.
   • Import only – if this is a one-time upload.
5. Once complete, you’ll see a confirmation summary including:
   • Number of rows successfully imported
   • Any failed rows
6. For saved mappings:
   • Click Got it to return to Integration Central > File Import.
   • Click the three dot menu next to your file and choose View logs or History to check results.

When successful, the uploaded timesheet records will appear under Management > Timesheets > Timesheets/Daily Authorisation for the selected dates and employees.

Additional information

• Only one employee identifier (e.g. Employee Code, Payroll Code) is required per row.
• A maximum of 500 records is recommended per file for optimal performance.
• Fields left blank will not update existing data unless explicitly mapped.
• If GrossHrs is blank and no Start/End Times are provided, the row will fail validation.
• To avoid duplication, do not upload the same file more than once.
• Locations, roles, and departments must already exist in the system. New ones cannot be created through upload.
• If your file includes new event or function codes not present in WFM, the upload will fail.
• Use export codes to avoid name conflicts across entities.
• If you need to automate uploads, speak to your administrator about scheduled import options.

Reference: Timesheet Data field definitions