Print Friendly

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

Was this article helpful to you?

Comments are closed.