Custom Conversions Import File Format

# Header Description Req. Notes
1 Measurement Name of the Unit value for which you want to add a custom conversion rate. Y Despite the column label "Measurement", this field refers to the data in the default Unit field on the custom entry screen. The value must be an exact match of an existing Unit value in the Journyx database.
2 Currency Name of the Currency value that will be used for the conversion. Y The value must be an exact match of an existing Currency value in the Journyx database.
3 StartDate The start date for when the conversion rate takes effect. Y The date must be in YYYYMMDD format.
4 StopDate The end date for when the conversion rate will no longer be in effect. Y The date must be in YYYYMMDD format unless you wish to leave the conversion open. If you don't want to set an end date yet, you can simply enter the word current (must be lower case) in this field.
5 Rate The numeric amount that applies to the conversion. Y Must be a number.