| Header | Description | Req. | Notes |
| Project | The project that this time record should contain. | Y (Unless a default value is assigned in the Custom Tool Settings) | The header name will match whatever this field is renamed to in your Journyx installation. The value in the field for any record must exactly match a project name that is in your Journyx installation and that the user has access to (via groups). |
| Task | The task that this time record should contain. | Y (Unless a default value is assigned in the Custom Tool Settings) | The header name will match whatever this field is renamed to in your Journyx installation. The value in the field for any record must exactly match a task name that is in your Journyx installation and that the user has access to (via groups). If the project (first column) has dependencies assigned, then the task must be in the project's dependency list. |
| Pay Type | The pay type that this time record should contain. | Y (Unless a default value is assigned in the Custom Tool Settings) | The header name will match whatever this field is renamed to in your Journyx installation. The value in the field for any record must exactly match a pay type name that is in your Journyx installation and that the user has access to (via groups). If the project (first column) has dependencies assigned, then the pay type must be in the project's dependency list. |
| Bill Type | The bill type that this time record should contain. | Y (Unless a default value is assigned in the Custom Tool Settings) | The header name will match whatever this field is renamed to in your Journyx installation. The value in the field for any record must exactly match a bill type name that is in your Journyx installation and that the user has access to (via groups). If the project (first column) has dependencies assigned, then the bill type must be in the project's dependency list. |
| Comment | The free-form notes that will appear in the text field of the time record. | N | The header name will match whatever this field is renamed to in your Journyx installation. This field is limited to a maximum of 252 total characters, and special characters like & count as multiple characters. |
| User | The user that this time record will be assigned to. | Y | The value in this field must exactly match the Journyx login ID of the person to whom the time record will be assigned. |
| Date | The date of the time record. | Y | The date must be in YYYYMMDD format. |
| Hours | The number of hours in the time record. | Y | The hours must be formatted in decimal format as opposed to HH:MM format. So 3 hours and 45 minutes would be formatted '3.75'. The maximum number of hours in a single time record is 24, inclusive. The maximum number of decimal places is 2. |
| Committed (or Commit) | Whether the record should be imported as committed (use 'y' or 'n'). | N | Set to 'y', 'yes', or 1 to mark this record as committed. Case does not matter. If this column is not present, the record will default to being imported with the committed flag set to Yes. A committed record cannot be further modified by the end user. If you wish the user to modify this record after the import but before submitting the sheet for approval, then set this field to 'n' to turn off the commit flag. |