Journal Entry Import Templates
  • 14 Jun 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Journal Entry Import Templates

  • Dark
    Light
  • PDF

Article summary

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:

  1.  Journal Entry

  2.  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

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:

  1. Payroll JEs for multiple Locations can be imported in the same upload

  2.  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

  3.  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.

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


Was this article helpful?