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

    Journal Entry Import Templates

    • Dark
    • 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?