cancel
Showing results for 
Search instead for 
Did you mean: 
doctorsheahan
Level 1

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

 
7 Comments 7
Rasa-LilaM
QuickBooks Team

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

I’m happy to see you today, @doctorsheahan.


Welcome aboard to the Community. Let’s go to the employee’s profile and then manually enter the correct contribution in the Amount per pay period section.


Here’s how:

 

  1. Go to the Workers menu on the left panel and choose Employees to see the list of workers.
  2. On the My payroll page, double-click on the employee’s name to view the complete details.  
  3. Selecting these options will take you to the Employee details window.
  4. From there, click the Pencil icon for Pay to view more information.
  5. Navigate to the Does employee have any deductions section and hit the Add a new deduction link to set up the payroll item.
  6. In the What deductions or contributions does employee have page, hit the drop-down for Deduction/contribution and choose New deduction/contribution.
  7. Then, pick the appropriate payroll item by clicking the drop-downs for Deduction/contribution type and Type.
  8. Input the agency's name in the Provider field box.
  9. Navigate to the Employee deduction section and click the drop-down for the Amount per pay period to select the $ amount ($92.30) or you can also select % of gross pay.
  10. For the Company-paid contribution, follow the same process found in Step 9.
  11. Click OK to save the changes.

    si.pngsi1.pngsi2.pngsi3.pngsi4.pngsui1.pngsui2.pngsui3.pngsui4.pngsui6.png

In regard to the premium, the calculation should be (200x12)/26 since it’s on a bi-weekly schedule. Simply click on this link to learn more about the number of payouts per year and proceed directly to the Pay schedule section to view the complete details.


For additional information such as contribution limits and which box on the W-2 the health insurance is reported, check out this article: Set up Health Savings Account (HSA) plans.


Post a comment below if you have additional questions while working in QuickBooks. I’ll pop-right back in to assist further. Have a great rest of the day.

 

DanN69
Level 1

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

This solution does not make sense.

If I do that starting in January and there are 2 pay periods I will have deducted $184.60 from the employee's pay for the actual $200 premium that is owed in January. If the employee resigns after the second paycheck then the company is out the $15.40 remaining premium for January.

How is that money accounted for?

Catherine_B
QuickBooks Team

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

Hello there, DanN69.

 

You have the option to edit the employees paycheck and enter the deduction in a lumpsum amount so you don't have any balance on the next pay period. I still suggest reaching out to a payroll advisor so they can advise the correct way on how to create final paychecks of your employee. 

 

Once you create the employee’s final paycheck, update their employee status. This removes them from your active employee list so you don’t get billed for them anymore. You can refer to this link for more details: Update their employee status.

 

Feel free to leave a reply below if you have additional questions in processing payroll. Take care!

DanN69
Level 1

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

Terrible solution.

Because the system can't handle it I have to do extra work of accounting for monthly bills that do not reconcile because the employee has not paid the full amount each month. Then when we have a 3 paycheck month the employee has overpaid and I need to account for that.

 

Then if that wasn't enough if an employee leaves mid-year I have to do a calculation to reconcile their medical deductions MANUALLY.

 

With some programming and computers you would think the system could figure out when a 3 paycheck month is coming and adjust.

EwaM
Level 1

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

Have you found a solution to this problem? I have the same issue. Unfortunately, it seems that the payroll companies do not accommodate this (I checked with three of them). I agree with you, that it would be a simple programming on a back end. 

JessT
Moderator

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

Hi EwaM,

 

While we're unable to set up a bi-weekly schedule for monthly health insurance, I recommend sending feedback to our product development team. That way, they can consider adding such an option in future updates.

 

  1. Click on the Gear icon.
  2. Choose Feedback.
  3. Enter a summary of your suggestion and click Next.

 

On the other hand, if you want to see some references for QBO payroll, you can go to the main support page, scroll down a bit, and click More Topics.

 

Let me know if you have any other concerns. Have a good one.

uday1
Level 2

How do I set up Monthly Health Insurance Premium on a bi-weekly schedule? If employee monthly premium is $200 & employer contrib is 50%, is it (100x12)/26?

Terrible solution, you guys do know that you have a payroll product that you charge hefty fees for..

Need to get in touch?

Contact us