Using Journal Templates to Import Data

Journal templates are Excel spreadsheets that are formatted as journal entry input screens.

FDM journal templates are typically used for the following types of adjustments:

GAAP adjustments to general ledger files
Transformations of gross balance accounts into roll-forward accounts (Beg, Add, Del, End)
Supplemental data entries (Head Count, Ratios, and so on)

The journal template (journal.xls) is located on the Tools > Templates menu. A sample journal template is included with the templates downloaded from E-Delivery, and should be saved in \\<FDMAppName>\Outbox\Templates directory, where FDMAppName is the directory on the machine where the application was created.