Expense Record Import File Format

Each row in this file is equivalent to a single expense record. The file must be tab-separated.
Default values can be assigned to certain fields for time, expense and mileage imports in the Custom Tool Settings tab.

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.