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 | 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.
| ||
R365 Payroll JE Import Template | .csv | 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.
| ||
Templates with Custom Fields | ||||
R365 JE Import Template with Custom Fields | .csv | This template can be used to import one or more journal entries that include custom fields. 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.
Custom Fields Notes:
| ||
R365 Payroll JE Import Template with Custom Fields | .csv | This template can be used to import one or more journal entries that include custom fields. 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.
Custom Fields Notes:
| ||
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 | Paychex utilizes the R365 JE Import Template | |
ADP Workforce | .csv | 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.
| |
Big Fish | .csv | 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 |
FAQ
Which journal entry import template should I use?
Use the R365 JE Import Template for standard journal entries and the R365 Payroll JE Import Template for payroll journal entries. If your entries use custom fields, use the matching template with custom fields. The template's Type field classifies the entry: standard entries can leave Type blank or enter Standard, and payroll entries must enter Payroll.
Why did my import create separate journal entries when I wanted one?
The import tool treats any difference in the matching columns as the start of a new journal entry. On the JE templates, columns A–F must match on every detail line that belongs to the same journal entry. On the Payroll JE template, columns A–F and L and M must match. Check those columns for stray differences such as extra spaces or different dates.
Why did my import fail on the location?
Location names and location group names must match the name in R365 exactly. The templates also accept location numbers. If a location and a location group share the same name, the entry is imported to the location.
Do I have to fill in every custom field column?
No. Unused custom field columns can be left blank. The column names must match the names used in Custom Field Setup exactly, and custom fields must be active to be imported.
My payroll provider sent an Excel file. Can I import it?
Save the file as a CSV first. For example, ADP sometimes delivers its Workforce file as .xlsx, and it must be saved as a CSV before you can import it using Action > Import on the Payroll Journal Entry.
Can I import payroll for several locations in one file?
Yes. Payroll journal entries for multiple locations can be imported in the same upload. The JELocation and DetailLocation fields must each be either the location number or the exact location name. To create separate journal entries in one upload, the first four columns (JE Number, Date, JE Comment, and JE Location) must be identical within each entry. See Importing Journal Entries for the full steps.