Journal Entries can be entered into Restaurant365 various ways. This article will discuss how Journal Entries can be imported through the use of .CSV templates. It is important to note that negative values cannot be entered in the Journal Entry Template. The importing process is outlined below.
Beta
The journal entry record has been updated and is currently in beta. All users can access the new experience.
Learn about the new journal entry features and how to switch to the new journal entry.
See documentation for the classic journal entry record.
Creating New Journal Entries via Import
1) Open R365 JE Import Template.
To begin creating Journal Entries via Import, first obtain the R365 JE Import Template and Documentation files. Click here for a list of all available JE Import Template files.
2) Read Template Documentation.
Read through the Documentation files to learn what each column in the JE Import template represents, and what data will need to be entered into the template.
3) Enter the Journal Entry details into the template.
Enter the journal entry information into the template per the instructions in the documentation. Ensure that the journal entry is in balance.
Existing records that are referenced in a JE Import template, such as Location Name/Number or Account Name/Number must match the same spelling or number as the corresponding record in Restaurant365. Misspelled or non-existing records will result in import failure. Click here for more information on Troubleshooting Import Errors.
4) Save the file as a CSV.
5) Hover over account then select import journal entry.
6) Set the desired Import Parameters: beginning balance, Import as approved, payroll journal entry. (Optional)
Beginning balance: Imports the journal entry as a beginning balance journal entry.
Learn more about journal entry types.
Import as approved: Imports the journal entry in an approved status.
Payroll journal entry: Marks the journal entry as a payroll journal entry.
7) Click select files to open the file explorer then select the desired journal entry file.
8) Review Import / Troubleshoot Errors.
If the Journal Entry (or entries) imported correctly, the importer will display how many records were created.
If there is an import error, the error will be displayed, along with a hyperlink to troubleshoot the error.
Imported Journal Entries will be listed in the 'Journal Entries' list of the 'General Ledger' subsection of the Accounting module.
This article has been rewritten. Click here to download the original version.