Exporting finance structures into multiple columns

When exporting journal entries to a .CSV file, the Finance Structure is displayed as one concatenated field. This table contains examples:

Finance structure Amount Currency Hours
CORE|8500|101|99800||||| USD
CORE|8500|101|12000||||| 3,000.04 USD
CORE|8500|101|18000|358654-2||GRANT 3|| -750.01 USD
CORE|8500|101|18000|358654-2||GRANT 3|| -750.01 USD
CORE|8500|101|18000|358654-2||GRANT 3|| -750.01 USD
CORE|8500|101|18000|358654-2||GRANT 3|| -750.01 USD

You can change the .CSV file to save each part of the finance structure to an individual column.

  1. Copy the .CSV file and rename the file with a .txt extension.
  2. Open the .txt file with Microsoft Excel.
  3. In the Text Import Wizard, select the My data has headers check box and click Next.
  4. In the Delimiters section, select the Tab, Comma, and Other check boxes. Clear the Semicolon and Space check boxes.
  5. Specify | in the Other field.
  6. Click Next.
  7. Click Finish.
    The Finance Structure field is separated into multiple columns. To match the data, you can adjust the headers of the columns after separating.