Payroll Journal Entries
  • 19 Jul 2024
  • 8 Minutes to read
  • Dark
    Light
  • PDF

Payroll Journal Entries

  • Dark
    Light
  • PDF

Article summary

Payroll journal entries record journal entries that are imported from your organization's third-party payroll provider and are used to reconcile labor accrual entries imported from the POS for each day of the pay period.

There are three unique fields on a payroll journal entry transaction that set it apart from a normal journal entry transaction:

  • Payroll Start Date - Records the start date for the pay period.

  • Payroll End Date - Records the end date for the pay period.

  • The Payroll Estimate Clearing tab - Displays the reversing entry of all the labor accrual entries.

Labor accrual entries are created using two sources:

  • Hourly Wages - Imported through the POS integration and created by matching job titles and labor punches.

  • Salaried Wages - Set using the Daily Manager Salary field on the Labor Estimate tab of the Location record.


Prerequisites

Ensure that all related daily sales summaries are approved before creating a payroll journal entry. If all of the Labor information is not approved, the payroll journal entry will not clear out the accrued payroll account properly. More information on this topic is explained in the 'Approving a Payroll Journal Entry' section below.


Navigation

In the top ribbon menu, hover over the Account option and select Payroll Journal Entry.
A blank Journal Entry record opens in a new tab.


Fields and Controls on the Payroll Journal Entry Record

Field

Description

1

Save

Provides the following options for saving the record:

  • Save - Saves the record and remains on the current page.

  • Save and New - Saves the record and opens a new, blank record.

  • Save and Close - Saves the record and closes the page.

2

Approve

Provides the following options for approving the record:

  • Approve - Approves the record and remains on the current page.

  • Approve and New - Approves the record and opens a new, blank record.

  • Approve and Close - Approves the record and closes the page.

3

Action

Provides the following actions that can be performed on the record:

  • Reverse

  • Memorize

  • Import

  • Email Link

  • Spread

4

Date

Date of the journal entry. For most payroll journal entries, this is the same as the last day of the pay period in which the transaction is recorded.
Default: Today's date.

5

Location

Location to which the payroll journal entry is assigned. For most payroll journal entries, this is the corporate locate of the legal entity that owns the account from which funds are withdrawn. Individual payroll expenses are broken down by more specific locations in the Details tab.

If your company does one payroll entry per legal entity, then all locations can be cleared for the legal entity in the same entry. To set this preference, navigate to the Miscellaneous tab of System Preferences and set Payroll Clearing to Per Location or Per Legal Entity.

6

Link to Asset

When selected, items in the Details tab can be linked to assets.

7

Number

A system-generated number used to identify the transaction.

8

Comment

An optional field where the user can enter comments about the journal entry.

9

Type

Type of journal entry. For payroll journal entries, this field is set to Payroll and is read-only. When importing journal entry data, Payroll must be written in the Type column for the import to be successful.

10

Payroll Start Date

First date included in the pay period.

11

Payroll End Date

Last date included in the payroll period.

12

Tabs

The Payroll Journal Entry record includes three tabs on which additional information can be entered:

  • Details – Enter the full journal entry transaction as provided by your organization's payroll provider.

  • Distribution – Once you have selected the Payroll Start Date and Payroll End Date and entered the full journal entry on the Details tab, access this tab to view the net effect of this payroll journal entry on GL accounts. The reason why this is not simply the values on the Details tab is because this transaction is also creating a reversing entry of all the labor accruals that have been made. Therefore, the Distribution tab displays the difference between the full payroll entry for the period and the reversing (or clearing) entry of all the accrual entries for the period.


    The values displayed on the Distribution tab should be relatively small if your accrual percentages are accurate. If job titles are assigned to the incorrect GL accounts (as described above), they might be larger than expected.

  • Payroll Estimate Clearing – This tab displays the reversing entry of all labor accrual entries made by the POS integrations after the transaction is approved.


    Individual daily labor accrual entries are not lost. The payroll clearing entry makes a single reversing transaction on the date of the payroll journal entry for the sum total of all the accrual entries for the payroll period.

13

Upload File

Opens a file manager window from which the user can import journal entry data from their device.


Importing a Payroll Journal Entry

  1. To begin importing a payroll journal entry, download the Payroll JE Import Template.

  2. Using the template, enter the necessary payroll information.

  3. In the Type column, enter 'Payroll' for each row.
    (Otherwise, the file imports as a standard journal entry.)

  4. In the top ribbon menu, hover over the Account option and select Import Journal Entry.
    The Import Journal Entry page opens in a new tab.

  5. (Optional) Select Import as Approved to mark the new payroll journal entry as approved upon creation.

  6. Select Payroll Journal Entry to indicate that the file should create a payroll journal entry.
    Two new fields appear: Payroll Start Date and Payroll End Date.

  7. In the Payroll Start Date field, enter the first date of the pay period in which to record the payroll journal entry.

  8. In the Payroll End Date field, enter the last date of the pay period in which to record the payroll journal entry.

  9. Click Select Files.
    A file manager window opens.

  10. Select the file to import from your device.
    The page updates to display the status of the import.


Approving a Payroll Journal Entry

Approving a Payroll Journal Entry

To approve a payroll journal entry, hover over Approve in the ribbon above and select your preferred option. The Payroll Estimate Clearing tab calculates and displays the sum total of all the approved labor accrual entries made by the POS integration (via the DSS) between the start and end date of the payroll period.

It is essentially a single reversing entry on the last day of the pay period. The difference between the reversing entry and the actual payroll entry from the payroll provider appears on the Distribution tab and indicates the net impact to labor-related GL accounts.

Correcting Approvals

Be sure to approve all the DSS (Daily Sales Summary) records for the pay period prior to entering and approving the payroll journal entry, as the payroll journal entry only creates a reversal for approved labor accrual entries on DSS records.

If you accidentally approve (and create the reversal) before approving all DSS in the date range or if changes are made to the labor entries in the POS. You can re-run the accrual reversal by unapproving the payroll journal entry and later approving it again to recreate the calculation.

The smaller the amounts are on the Distribution tab, the more accurate the accruals have been. If there are large dollar values on the Distribution tab, adjust the accrual percentages on the Location record. The accrual clearing amounts might also be larger than expected (or off), if the accounts assigned to job titles or to the location default accounts are incorrect.

For example, the Cook job title might incorrectly be assigned to FOH Labor in R365 but actual payroll entry from the payroll provider applies Cook labor to BOH Labor, so the Distribution tab displays the full amount going to BOH Labor and the full amount coming out of FOH Labor. If the amounts on the Distribution tab are larger than expected, review the job titles to make sure everything matches as expected.


Another Sample Payroll Journal Entry

After running payroll through the payroll provider, import (or enter) a journal entry that has the summary of the expense accounts (FOH, BOH, Manager, etc.) and a single line for each employee's net pay (the amount for each check that will clear the bank) into R365. By doing this, we can use R365's Bank Reconciliation to reconcile the payroll account and capture actual payroll expenses.

The lines below display sample entries for each payment run using an example of 3 locations (with one corporate location where executive and administrative salaries are booked). The amounts credited to the payroll checking account automatically create withdrawal entries in Bank Reconciliation and are automatically reconciled when bank activity is imported into R365:

Debit $1,000 FOH Hourly Wages Expense – Location A
Debit $1,000 FOH Hourly Wages Expense – Location B
Debit $1,000 BOH Hourly Wages Expense – Location A
Debit $1,000 BOH Hourly Wages Expense – Location B
Debit $1,000 Administrative Salaries Expense – Location Corporate
Debit $500 Taxes/Benefits/Insurance – Location A
Debit $500 Taxes/Benefits/Insurance – Location B
Debit $500 Taxes/Benefits/Insurance – Location Corporate
Credit $500 Payroll Checking Account – “Jane Doe” “Check 1123”
Credit $500 Payroll Checking Account – “Steve Smith” “Check 1124”
Credit $500 Payroll Checking Account – “Kobe Bryant” “Check 1125”
Credit $500 Payroll Checking Account – “Tim Duncan” “Check 1126”
Credit $500 Payroll Checking Account – “Steven Smith” “Check 1127”
Credit $500 Payroll Checking Account – “Parley Pratt” “Check 1128”
Credit $500 Payroll Checking Account – “Dan Jones” “Check 1129”
Credit $500 Payroll Checking Account – “Brittany Spears” “Check 1130”
Credit $500 Payroll Checking Account – “Elton John” “Check 1131”
Credit $500 Payroll Checking Account – “Steve Wonder” “Check 1131”
Credit $500 Payroll Checking Account – “Jim Kaa” “Check 1131”
Credit $500 Payroll Checking Account – “Carl Karcher” “Check 1131”
Credit $500 Payroll Checking Account – “Summer Harris” “Check 1131”

The entry will have a single row for each check sent out (the credits) and a row for the total expense by GL account by location (the debits). After running payroll just as you do today, you can either prepare this entry in Excel and import it into Restaurant365 or create a Memorized GL Transaction in Restaurant365. For each pay period, you update the dollar amounts and check numbers in the comment for each row.

Restaurant365 takes this entry and uses it to offset the labor accruals that come in daily from your POS system into Restuarant365. When you import or enter the journal entry above, you select the start and end date of the pay period for which it covers. The system then makes an adjustment to true up/down the accrued payroll expenses for the pay period. This way, you get the benefit of having weekly prime cost reports and having them totally accurate however often you run actual payroll.



Was this article helpful?