Journal Entries can be entered in to 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. Journal Entry templates can be imported using either of the following methods:
- Import and create one or more new Journal Entries
- Import Journal Entry Details in to a single existing Journal Entry
The importing process for each method will be outlined below.
Method 1 - Creating New Journal Entries via Import
Step 1: Obtain 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
Step 2: Read Template Documentation
Read through the documentation file to learn what each column in the JE Import template represents, and what data will need to be entered in to the template.
Step 3: Enter Journal Entry in to Template
Enter the Journal Entry information in to the template per the instructions in the documentation. Ensure that the Journal Entry is in Balance. Save as a .csv to prepare for import
Note: 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
Step 4: Open Journal Entry Import Screen
Hover over the 'Account' menu in the top ribbon and select 'Import Journal Entry' to open the Journal Entry import screen in a new tab
Step 5: Set Import Parameters, Select and Upload File for Import
Set the import parameters, including if the JE will be imported as Approved, or if it is a Payroll Journal Entry. Select the saved template, then upload
Step 6: 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
Method 2 - Importing Journal Entry Details
Step 1: Obtain the Journal Entry Detail File
When importing JE Details, typically the detail file is provided by a third party, such as a Payroll Provider. Click here for a list of Sample JE Detail files. Obtain the Detail file and proceed to Step 2
Step 2: Create New Journal Entry and Complete Header Information
Hover over the 'Account' menu in the top ribbon and select 'Journal Entry' or 'Payroll Journal Entry' to open a new form. Enter all of the JE header information, including the pay period dates if this is a Payroll Journal Entry. Click here for more information on entering the header information for Journal Entries and Payroll Journal Entries
Step 3: Import Details
Hover over the 'Action' menu and select 'Import'. This will open the Import prompt where the User can select the Detail file and import
Step 4: Review Imported Details and Save
Review the data that was imported from the Detail file. Verify that it imported correctly. Save & Close or Approve & Close the entry
Imported Journal Entries will be listed in the 'Journal Entries' list of the 'General Ledger' subsection of the Accounting Module
Note: This article has been rewritten as of 7/5/17. Click here to download the original version