Journal Entries can be imported in to Restaurant365 using CSV templates. Click here for the Journal Entries Overview page. Two types of Journal Entries can be imported in to Restaurant365:
- Journal Entry
- Payroll Journal Entry
Each type can be imported using the same template, the 'R365 JE Import Template.csv', provided in Table 1 below. Journal Entries and Payroll Journal Entries can be imported by hovering over the 'Account' menu in the top ribbon and selecting 'Import Journal Entry'. Click here for more information on Importing Journal Entries.
R365 Journal Entry / Payroll Journal Entry Template
| Name | Type | Template Link | Usage Documentation | Comments |
|---|---|---|---|---|
| R365 JE Import Template | .csv | JE Import Template | Documentation | This template can be used to import Journal Entries or Payroll Journal Entries, as long as the Payroll Start and End Dates are included, with multiple entries on the same file. |
| R365 Payroll JE Import Template | .csv | Payroll JE Import Template | Documentation |
Note: The JE Import Template includes a 'Type' field, which helps to better classify the Journal Entry in R365. Daily transactions can either have 'Standard' entered in this column or leave this column empty while Payroll entries must have 'Payroll' entered in this column. Click here to learn more about Journal Entry Types.
Payroll Provider Import Files
In addition to Journal Entry and Payroll Journal Entry imports, various some payroll companies provide reports that can be easily imported into R365. The table below contains sample payroll files that can be easily imported into R365.
Payroll Provider Specific Entries can be imported as details on a new Payroll Journal Entry. First create the Payroll Journal Entry by hovering over the 'Account' menu in the top ribbon and selecting 'Payroll Journal Entry'. Complete the header information, then hover over 'Action' and select 'Import'. Find and select the file provided by your Payroll Provider to import the JE details. Click here for more information on Importing Payroll Provider Files.
It is important to note the following before import:
- Payroll JEs for multiple Locations can be imported in the same upload
- Both the JELocation and DetailLocation fields would need to either be the number of the Location or the exact name of the Location, as noted on the Location record
- If importing multiple Journal Entries in a single upload for a Location, the first 4 columns (JE Number, Date, JE Comment, and JE Location) must be identical in order to create the separate Journal Entries
| Name | Type | Template Link | Comments |
|---|---|---|---|
| Paychex Preview | .csv | JE Import Template | Paychex utilizes the R365 JE Import Template |
| ADP Workforce | .csv | ADP Workforce file | This sample file displays the expected output from the ADP Workforce file used in importing details in to an existing Payroll Journal Entry via the 'Import' prompt under the 'Action' menu. Note: occasionally ADP will deliver this file as a .XLSX file. It must be saved as a 'CSV' in order to be imported on the 'Actions' menu of the Payroll Journal Entry form. Here is the sample ADP Workforce file in it's original .xlsx file format: ADP Workforce file (XLSX) |
| Big Fish | .csv | Bigfish file | This sample file displays the expected output from the Big Fish Payroll file used in importing details in to an existing Payroll Journal Entry via the 'Import' prompt under the 'Action' menu |