cancel
Showing results for 
Search instead for 
Did you mean: 
User_20200731
Level 3

Hourly to Salary Conversion Due to Promotion

What would be the best way to handle a person that was an hourly employee before promotion that after promotion will be converted to a salary person?

 

Thoughts:

 

(1) Can these two types appear on one payroll cycle? If not, then I assume I would have to run an unscheduled payroll for pre-promotion, then an adjusted payroll prorated at salary post promotion.

 

What I have seen previous practice was to create a different spelling of the person, but I know this will cause an issue with W2s at YE. So, I know that is not ideal.

 

This is what I'm currently thinking. Run an unscheduled payroll at the hourly rate. Process. Then go to the employee profile change settings to salary and continue payroll from thereon at the salary prorated rate.

 

Bonus Related Question:

Also, is it possible to merge duplicate employees one was configured to hourly rate and one was configured at salary rate?  Example:  John Merry Doe (Employee ID 1001) J. Merry Doe (Employee ID 1002).

Solved
Best answer August 29, 2020

Best Answers
BigRedConsulting
Community Champion

Hourly to Salary Conversion Due to Promotion

@User_20200731 

RE: 1) Can these two types appear on one payroll cycle?

Yes.  That is easy to do. 

 

RE: What I have seen previous practice was to create a different spelling of the person, but I know this will cause an issue with W2s at YE.

It causes many more issues than that, in several cases. This is not a good idea.

 

RE: is it possible to merge duplicate employees one was configured to hourly rate and one was configured at salary rate?

No, it is not possible to merge two employees when they have both been paid.  You can merge an employee who has no payroll into another that does.

 

Here's what do to:

If the employee's promotion is effective mid-pay-period, then for the paycheck for that period:

1 - As you're creating payroll click the employee's name to open the paycheck preview.

2 - Pay the employee for their hourly hours as normal, for the part of the period they were hourly.

3 - Add the salary item you want to use to the earnings table.  For the pro-rated salary amount, manually calculate the salary/day based on the period salary.  For example, if you pay every other week and the salary for that period is $2000, then the daily salary is calculated like: $2000/10 days work or $200 per day.  If the employee worked 4 days of the period on salary, then the salary amount is $800.

4 - Complete the payroll as normal.

 

Then:

5 - Edit the employee, and then remove the hourly items and add the salary item, entering the annual salary there (using the example above, enter $52,000.)

6 - On your next payroll, make sure the paycheck includes only the salary (some settings might make QB pull in the prior paycheck's earnings table details.)

View solution in original post

10 Comments 10
CharleneMaeF
QuickBooks Team

Hourly to Salary Conversion Due to Promotion

Thanks for sharing what you'd like to achieve, @User_20200731.

 

We're unable to use hourly and salary rates in one payroll cycle. Though, we can create an item manually and add it to the employee's paycheck.

 

Here's how:

  1. Go to Lists and then select the Payroll Item List tab.
  2. Select Payroll Item and then select New.
  3. Click Custom Setup, then select Next.
  4. Select Wage and then select Next.
  5. Choose Hourly Wage.
  6. Select the appropriate pay type.
  7. Note: For holiday pay or other types not specifically listed, choose Regular Pay.
  8. Then click Next.
  9. Enter a name for the pay item and then click Next.
  10. Choose the Expense account where you want to track wages.
  11. Select Finish.

 

Then, we can now add the item to the paycheck. I'll guide you how:

  1. From the Employees menu, select Payroll Center.
  2. Click Start Unscheduled payroll.
  3. Select the name of the employee.
  4. Select Continue on the prompt message.
  5. Then click on Continue.
  6. Select Open Paycheck Detail.
  7. On the Item Name field, select the item you've created.
  8. Review the items and then click Save & Close.
  9. Click Create Paychecks.

 

Once done, let's change the rate of your employee to salary. Moving forward, this rate will show on your employee's info.

  1. From the Employees menu, select Employee Center.
  2. Double click the name of the employee.
  3. On the payroll info tab, select Salary.
  4. Once done, click on OK.

 

Also, to merge duplicate employees, you can make it identical to the one you're merging it with and click OK. Then select Yes to confirm.

 

Additionally, I've included an article that'll guide you in viewing what you've paid out. This way, you'll keep track of your payroll totals: Create a payroll summary report.

 

We're always here to help if you have other payroll concerns. Have a great day!

User_20200731
Level 3

Hourly to Salary Conversion Due to Promotion

What happens if an employee voluntarily transfers from salary to hourly what would the process be to convert in that direction also, and avoid creating a duplicate employee profile?

MariaSoledadG
QuickBooks Team

Hourly to Salary Conversion Due to Promotion

The employer must be informed if an employee wants to be paid on an hourly rate, User_20200731.

 

You'll just have to edit the employee's earning information to change from salary to hourly and to avoid duplicate employee's profile.

 

Here's how:

  1. Go to Employees, then select Employee Center.
  2. Double-click on the employee's name.
  3. Select the Payroll Info tab.
  4. Click on the blank area, in the Earnings box, below Item Name column.
  5. Select the drop-down arrow, then select your Hourly item.
    hourlyitem.JPG
  6. In the Hourly/Annual Rate column, enter the employee's hourly rate.
  7. Click OK.

In case you'll want to customize your payroll reports, here's an article for your reference: Customize Payroll And Employee Reports.

 

Drop a reply below if you need further assistance. I'll be here to help.

User_20200731
Level 3

Hourly to Salary Conversion Due to Promotion

How identical does the duplicate employee A need to be to duplicate employee A.1? 

What are the minimum essential items that are required to be the same to have a successful merger?

Thanks!  @CharleneMaeF 

 

Employee A

First Name:   A.

Middle Name:  Example

Last Name: Example

Payroll Schedule: Biweekly

Item Name = A - Hourly

Various Taxes

Class = 123

 

 

Employee A.1 

First Name:  ATrue

Middle: Example

Last Name: Example

Payroll Schedule: Biweekly

Item Name = A – Salary

Various Taxes – 1

Class = NULL

JonpriL
Moderator

Hourly to Salary Conversion Due to Promotion

You're on the right track, @User_20200731!

 

You can create a new employee profile with the salaried payroll data so you can merge it with the existing one. No need to duplicate all the payroll information as long as the employee's legal name is a match, QuickBooks will merge it successfully.

 

In addition, here's an article you can read to learn more about how to merge any names: Merge Accounts, Customers, and Vendors.

 

Lastly, I've got you this helpful article for ideas about how you can create a payroll check: How do I create a paycheck for an employee?

 

Keep me updated in the comments if you have any other questions. I'll be here to lend a hand.

BigRedConsulting
Community Champion

Hourly to Salary Conversion Due to Promotion

@CharleneMaeF 

RE: "We're unable to use hourly and salary rates in one payroll cycle. "

 

Yes, of course you can.  QB has always supported using both hourly and salary items on the same paycheck.

BigRedConsulting
Community Champion

Hourly to Salary Conversion Due to Promotion

@User_20200731 

RE: 1) Can these two types appear on one payroll cycle?

Yes.  That is easy to do. 

 

RE: What I have seen previous practice was to create a different spelling of the person, but I know this will cause an issue with W2s at YE.

It causes many more issues than that, in several cases. This is not a good idea.

 

RE: is it possible to merge duplicate employees one was configured to hourly rate and one was configured at salary rate?

No, it is not possible to merge two employees when they have both been paid.  You can merge an employee who has no payroll into another that does.

 

Here's what do to:

If the employee's promotion is effective mid-pay-period, then for the paycheck for that period:

1 - As you're creating payroll click the employee's name to open the paycheck preview.

2 - Pay the employee for their hourly hours as normal, for the part of the period they were hourly.

3 - Add the salary item you want to use to the earnings table.  For the pro-rated salary amount, manually calculate the salary/day based on the period salary.  For example, if you pay every other week and the salary for that period is $2000, then the daily salary is calculated like: $2000/10 days work or $200 per day.  If the employee worked 4 days of the period on salary, then the salary amount is $800.

4 - Complete the payroll as normal.

 

Then:

5 - Edit the employee, and then remove the hourly items and add the salary item, entering the annual salary there (using the example above, enter $52,000.)

6 - On your next payroll, make sure the paycheck includes only the salary (some settings might make QB pull in the prior paycheck's earnings table details.)

User_20200731
Level 3

Hourly to Salary Conversion Due to Promotion

What would be the best way to go about correct two employee profiles, after payment has been has been issued? These two employee profiles are for the same employee but payment has been issued and this spans over several months. @BigRedConsulting 

BigRedConsulting
Community Champion

Hourly to Salary Conversion Due to Promotion

This is a hard case for a few reasons:

1. You can't change the employee name on an existing paycheck.

2. You can't merge two employees that have both been paid.

3. The taxes on the paychecks may have over-run the annual limits, since they're split between two employees.

 

Here's what I'd do, very carefully:

In the end, you'll keep the employee that has a lot of data, and work to remove the new one incorrectly set up, which has only a few months of data.

 

One paycheck check at a time, starting with the oldest paycheck for the new unwanted employee, create a new paycheck for the old employee that is a duplicate:

- Make sure all the payroll items and amounts - from Gross to Net - are exactly the same on the new check as on the existing check, even if you have to overwrite the amounts manually.  Technically, you don't need to do this for the company paid taxes and other company paid items, as they don't contribute to the check amount, but you can do so.

- Double check that all the amounts are the same using payroll reports for the period you're duplicating the checks.  The main "Payroll Summary" report will be useful in this case.  You can filter it for one day, and/or for the entire period in question.

- Once you're sure the new paychecks mirror the existing ones, then carefully delete the paychecks for the unwanted employee.

- Then delete that employee from the employee center.

 

 

 

 

User_20200731
Level 3

Hourly to Salary Conversion Due to Promotion

So, here is some additional clarification of what I ended up doing with QuickBooks Payroll support.

 

As previously mentioned in the thread, you need to have the hourly and salary set up.

However, you need to reverse engineer the gross annually salary by the expected payroll gross total for the salary component (manually calculate), and then process payroll.  After payroll has been processed, then update the Employee Profile to reflect the true annual salary.

 

Example if company is set up biweekly:

  • Target Payroll 10 hours @ 15 per hour and $750 salary.
  • First setup the salary line item in QuickBooks then take 750 * 52 / 2 = 19,500.
  • Then go to the payroll cycle and confirm that the total amount of that first transitional payroll salary has $750.00. If not, revert and make correction as needed in the Employee profile.
  • Once payroll is processed and adjust payroll annual salary for that employee up to sought target  or source documents of 38,000.
  • Next payroll discontinue use of hourly and only use salary line item.

 

Yes, you can do salary and hourly on one payroll. But, you need to do it carefully and thought out.

 

Thanks @BigRedConsulting !

 

 

 

Need to get in touch?

Contact us