Journal Entry: Using the Excel JE Upload Template to Create a .dat File.

Environment

FINPROD

Issue

Using the Journal Entry Upload Excel template to generate a .dat file with one or more journals. 

Resolution

The Journal Entry Upload Template can be downloaded from the U-M Finance website: https://finance.umich.edu/finops/accounting/journals

  • Enable macros in the Excel sheet
    • Otherwise, you will not be able to see or use the Journal Upload excel add-in. 
  • Multiple journals can be submitted through one data (.dat) file.
    • A new journal will be created for each valid Header ('H') row with subsequent valid Line ('L') rows beneath it.
    • As you fill in the journal upload template, do not skip any rows between the last line of the previous journal and the header row for the next. A blank line tells the program to stop writing the file information to the data file.
  • After entering the data in the excel spreadsheet, navigate to add-ins > Journal Uploads > Export to create the .dat file. 

Detailed instructions for creating and posting a JE can be found here: https://mylinccontent.dsc.umich.edu/mais/html/GL_JournalEntry_Resources.html

Additional Information

Need additional information or assistance? Contact the ITS Service Center.

Print Article

Related Services / Offerings (1)

This Service is an MPathways module that records the university's financial transactions. It is a key part of the university's accounting system and is used to manage finances, track revenue and expenses, and generate financial reports. For more info, see General Ledger Module on the ITS website.