On the landing page or within the Create Journal Entry window, you can initiate an Excel document upload to facilitate the creation of a journal entry. This import method also supports .CSV files. To successfully upload the file into the JE module, the first row must specify the headers intended for population within the journal entry. The allowable header names are specified within the upload module. These headers do not need to be arranged in any particular order.
The journal entry itself must be entered on the first tab; however, the Excel file may contain multiple tabs beyond this point.
When importing journal entry data, the system first checks for Labels to populate the journal entry form. If no Labels are found, it will then use the External ID information instead.
Once you have selected an entity and uploaded the Excel file, you will have the option to attach the uploaded file to the journal entry and designate the appropriate workflow phase for the entry.
Attach Supporting Documentation
Supporting documentation can be attached to any journal entry submitted. Depending on configured settings, attaching supporting documentation may be mandatory to submit a journal entry for approval. Documents uploaded to this section will not be stored in your cloud storage provider; instead, they will be converted into read-only files. Individuals with journal access will be able to download the supporting documentation. All file types are accepted.
Frequently Asked Questions
Q: Can I import multiple journal entries at once?
A: No, that is not currently supported.
Q: How large of a journal entry can I import?
A: 10,000 lines
Q: Can I have my journal entry in different Excel sheets?
A: No, the journal entry always has to be on the first sheet in the Excel workbook.
Q: Does the sheet name matter?
A: No
Q: Why do I keep getting an account number error?
A: The Journal Entry Upload for account number only requires the number and not the account name.
Q: Why do I keep getting error messages on import?
A: All fields except account number require to be spelled out exactly how they are shown on the Journal Entry Management UI (ID + Name)
Q: What fields are required on each line?
A: Required fields on each line of the spreadsheet:
- Account number
- Transaction date
- Credit or debit amount
- Line-level fields marked as required in the ERP configuration