| Header | Description | Req. | Notes |
| Project | The project that this expense 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). |
| Expense Code | The expense code that this expense 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 expense code 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 expense code must be in the project's dependency list. |
| Source | The source field that this expense 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 source record 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 source must be in the project's dependency list. |
| Currency | The currency field that this expense 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 currency 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 currency must be in the project's dependency list. |
| Comment | The free-form notes that will appear in the text field of the expense 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 expense record will be assigned to. | Y | The value in this field must exactly match the Journyx login ID of the person to whom the expense record will be assigned. |
| Date | The date of the expense record. | Y | The date must be in YYYYMMDD format. |
| Amount | The amount of currency for this expense record. | Y | The amount must be formatted in decimal format. So 5 dollars and 89 cents would be formatted '5.89'. 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. |