Loading Financial Consolidation and Close Journals Process Description

At a high level, journals can be loaded as a regular data file, or as an Excel template.

If you load journals as a data file, you define an import format to import the journal file. The import format contains additional mappings for the journal label and description columns. The rest of the source data is imported in the same manner as standard data. Then you define a data load rule and set the load type to "journal" to import the data. Text journals can be imported like any other from the data load rule or the workbench. They can also be imported using a batch process similar to standard data load processes.

If you use the Excel template to load a journal, then you use an existing location, create a new data load rule for that location and specify load type of Journal for the data load rule. You then use the workbench to import the Excel journal template file. When you open the Excel template, you fill it out, upload it, and then post it.