Journal Entry Import Templates

Journal Entries can be imported into Restaurant365 using CSV templates. Two types of Journal Entries can be imported in to Restaurant365:

Import templates and documentation for each import type are included below. Learn more about 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	R365-JE-Import-Template_Documentation 164.25 KB	This template can be used to import one or more journal entries. When importing multiple entries, ensure columns A–F match for all detail lines belonging to the same journal entry. Any difference in columns A–F signals the import tool to treat that row as part of a new journal entry. The import template supports location names, location numbers, and location groups. Location names and location group names must match the name in R365 exactly to import successfully. If a location and location group share the same name, the entry will be imported to the location.
R365 Payroll JE Import Template	.csv	Payroll JE Import Template	R365-Payroll-JE-Import-Template-Documentation 177.41 KB	This template can be used to import one or more payroll journal entries. When importing multiple entries, ensure columns A–F and L,M match for all detail lines belonging to the same journal entry. Any difference in columns A–F, L, or M, signals the import tool to treat that row as part of a new journal entry. The import template supports location names, location numbers, and location groups. Location names and location group names must match the name in R365 exactly to import successfully. If a location and location group share the same name, the entry will be imported to the location.

Name

Type

Template Link

Usage Documentation

Comments

R365 JE Import Template

.csv

JE Import Template

R365-JE-Import-Template_Documentation

164.25 KB

This template can be used to import one or more journal entries.

When importing multiple entries, ensure columns A–F match for all detail lines belonging to the same journal entry. Any difference in columns A–F signals the import tool to treat that row as part of a new journal entry.

The import template supports location names, location numbers, and location groups.

Location names and location group names must match the name in R365 exactly to import successfully.
If a location and location group share the same name, the entry will be imported to the location.

R365 Payroll JE Import Template

.csv

Payroll JE Import Template

R365-Payroll-JE-Import-Template-Documentation

177.41 KB

This template can be used to import one or more payroll journal entries.

When importing multiple entries, ensure columns A–F and L,M match for all detail lines belonging to the same journal entry. Any difference in columns A–F, L, or M, signals the import tool to treat that row as part of a new journal entry.

The import template supports location names, location numbers, and location groups.

Location names and location group names must match the name in R365 exactly to import successfully.
If a location and location group share the same name, the entry will be imported to the location.

The JE import template includes a ‘Type’ field used to classify the journal entry in R365. Standard entries can leave this field blank or enter ‘Standard,’ while payroll entries must include ‘Payroll.’ 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. 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

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