QB Payroll

Owned by Stephanie Pepper (e-manage|ONE)
Last updated: Jun 22, 2020
3 min read

If you are using QB Payroll you will need to do the following. 

e-manageONE Administrator 

Enter the Pay Schedule Items that are in QuickBooks into the Employees Pay Schedules under Corporate Divisions > Drop Down List Setup > Employee Pay Schedules.

e-manageONE Employee Management 

The customers homework is to enter all employee information. 

Enter your employees into the Employee Manager by selecting Human Resources > Employee Manager > Select "New" and filling all information in as follows: 

General Information 

  • Enter Employee Information

  • Attach employees to e-manage|ONE Users (if applicable)

  • Attach employee to salesperson (if applicable - only attach salespeople to salespeople)

  • Attach installer to installer (if applicable - only attach installer to installer)

  • Enter a Pay Schedule for Employee (See Below for Additional Information) 

Pay Schedules 

Pay / OT Rates: What the employee is being paid per hour . 

For Hourly employees create a Pay Schedule for each Pay Schedule available to them. The Schedule Name needs to match exactly to the QuickBooks Item Name. 

Actual / OT / hr: The actual (internal) cost to your company for that employee. This can be a combination of the hourly rate + benefits + other costs to your company. Other costs could be RSP Matching, CPP, etc. 

For Salary employees only create Actual / OT / Hr. To figure this out, take their Salary and divide it by 2080 hours and add the percent for taxes and benefits. See example below. This rate does not have to be completely accurate but will be used to show your employee cost on a project. 

$36,000 / 2080 = $17.31 x .25 = $4.33 + $17.31 = $21.64 Actual employee cost per hour 

Note: The pay rate in e-manageONE does not push over to QuickBooks. You need to enter it in both places. 

If you are using QuickBooks Payroll, you will need to create multiple Pay Schedules for Standard Pay, Overtime, Double Time, Davis Bacon, etc. 

Click here for more information on how to setup QuickBooks Payroll with e-manage.

Send e-manageONE Employee to QuickBooks 

Open the e-manage|ONE QuickBooks Integration form the Main Tool Menu and click Payroll > Send e-manage Employees to QuickBooks. Select the employee and click Send to QuickBooks.

Import Wage Items from QuickBooks in the e-manageONE QuickBooks Integration.

 

QuickBooks Employee Center (Payroll) 

Open QuickBooks and enter the employee Pay Rate(s) per Item Name. The QuickBooks Item Names need to match the Pay Schedule Names in e-manage. The rate only matters in QuickBooks for payroll.

Creating Payroll (Show/Hide Columns) 

You may want to adjust Salary employees payroll to accurately reflect the pay for when they are sick or hourly. The easiest way is to click the "Show/Hide Columns" button and show "Sick Salary & Vacation Salary".

Adjusting Payroll to accurately reflect payroll amounts for Salary, Sick, & Vacation and Available Sick & Vacation Hours 

You will only have to do this for Salary employees if you want to show accurate payroll. It will automatically update the available hours. 

Open the employee payroll and add "Salary" Item and the hours which is the vacation / sick minus the hours for the pay period. Below is a standard 80 hour pay period. 

You will see in the Employee Summary the breakout for Sick Salary, Vacation Salary and Salary amounts and YTD.

 

Â