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.
This article references the updated journal entry experience which was enabled for all customers in Q3 2025.
The option to switch to the classic journal entry will be removed in Q4 2025.
Security
Users must have the following permission import journal entries:
General Ledger → Journal Entries → Create Journal Entries
These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.
Creating New Journal Entries via Import
To create a journal entry via import, follow these steps:
Click steps to expand for additional information and images.
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 determine 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. Learn more about Troubleshooting Import Errors.
4) Save the file as a CSV.
5) Open the Create menu 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.