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.  Journal Entry templates can be imported using either of the following methods:

  1. Import and create one or more new Journal Entries
  2. 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