DeRosa Mangold Blog

The Affordable Care Act requires employers to report the cost of employer provided group health insurance provided to an employee on Form W-2. The IRS has an easy to read document on their website which we have reproduced for you here. As always, we recommend you stay abreast of this ever changing environment and consult your tax advisor if you have any questions regarding IRS regulations. However, you may have some questions for us with regard to your Sage software. Below are a few questions you may have.

1. Does this apply to my company?

As we read current guidance, there is a reporting exemption for employers who report less than 250 employees in a year for 2012. Last year, popular guidance was that ALL employers would have to report the cost of Employer Provided Group Health Insurance in 2014 on Form W-2 for 2013. However, as we read current guidance, this exemption for 2012 extends to future years until IRS issues additional guidance and reporting would not be required until the next tax year beginning at least 6 months after the issuance of such guidance.

2. How is this tracked in Sage MAS 90, Sage MAS 200, Sage 100 ERP Payroll?

You would track this by setting up an Employer Deduction and assigning that deduction to an employee receiving the benefit.

If you have never used an employer deduction before, it’s not really a deduction. It’s an accrual of an employer provided benefit on an employee by employee basis. In MAS 90/200/100 ERP, the set up occurs in Deduction Maintenance and the "Type" is Employer Deduction. An Employer Deduction DOES NOT reduce the employee’s pay. It simply makes an accrual entry on the General Ledger (Debit Expense and Credit Liability) and tracks an amount in the Employee Masterfile each time an employee is paid with this deduction included in the payroll.

For Example, we provide our employee’s health insurance for themselves but they have to pay for their dependents. The monthly cost of their insurance is $480.00 and they are paid twice a month. We would want the Employer Contribution Deduction for the employee set to $240.00 per paycheck and it would result in the following entry:

Employer Provided Health Insurance Expense $240.00

Accrued Health Insurance Payable $240.00

Of course you can set up the entry as you wish or if you don’t want an entry made, you can set up the deduction to debit and credit the same account.

3. How is it put on Form W2?

In the deduction setup we would flag to put in Box 12 and give it a code of DD.

4. What if I don’t set up the deduction at the beginning of the year?

The deduction can be added to the employee at the end of the year and force the annual amount to put on your W2.

5. What coverages should be reported?

Visit http://www.irs.gov/uac/Form-W-2-Reporting-of-Employer-Sponsored-Health-Coverage#.UMpcyeSa86c.gmail to view a table explaining the coverages that are required, optional or not to be reported, as well as how they apply to entities. As always we encourage you to contact your tax advisor if you are unsure.

If you have any questions, please do not hesitate to call.

We are here to help you!

Recent Articles


Recent Articles

Archives

Categories

Whitepaper
"Four Ways Integrated CRM-ERP Solutions Improve Productivity"

Whitepaper
"The Future of Customer Relationship Management"

Whitepaper
"Getting Your Moneys Worth from Fixed Assets Software"

Whitepaper
"Finding Funds in a Demanding and Challenging Environment"

Whitepaper
"Top Ten Reasons To Consider JobOps For Your Manufacturing Solution"


"Mitzi is always pleasant and knowledgeable."

Rachelle, R&K Specialized Homes

"We had a very informative and helpful planning session in discussing the chart of accounts numbering scheme. The time spent was very productive in getting us ready for the conversion."

Texas Pension Consultants

"Mitzi is always professional, knowledgeable, and prompt to provide assistance."

S. Clark, Clark Benefit Group

"I’ve used MAS 90 for 6 weeks and I was able to still obtain more knowledge on this software by attending the training class."

Lisa, D&S Residential

"Mitzi was extremely helpful in getting our financial reports started. She spent time explaining certain accounting procedures and ensured I understood exactly what I need to do to finish the chart of accounts to accurately pull the data. I would highly recommend Mitzi to other companies."

R. Carrasco, D. R. Kidd

"Mitzi is always helpful even if I'm not sure of what I need!"

Shirley, Apollo Gate Operators

"Mitzi is always helpful!"

Shirley, Apollo Gate Operators

"Mitzi is GREAT!"

Sharon, Texas Wildlife Association

"I have spent a lot of time on the phone lately with Liz Ortega regarding W-2 reporting with the upgraded payroll module. She was extremely helpful with research and making sure she had us set up correctly for printing and e-filing. I would like to let you know how great she was, and we really appreciated the help and knowledge. Thank you Liz!"

Natalie, Mike Carlson Motor Co.

"DeRosa Mangold was great and prompted me to ask about several things I didn't know the system was capable of doing."

Shirley, CBC Innovis

"Just to let you know things have been going great! The addition of Rochelle has been a life saver! And of course, Mitzi, Liz and Caterina have been great. We are moving along quite nicely."

Dana Roy, AMPOL

"Mitzi was so helpful to us. She fixed our problems and explained many things to us. She is a joy to work with."

Dawn, Kwik Kopy

"Mitzi was knowledgeable in all areas of the purpose of her call. She presented herself as a professional and handled all questions satisfactorily."

Keith, San Saba Pecans

"Mitzi is Great!"

Rhonda, DEA Specialties

"DeRosa Mangold gave me the ability to keep my division seperate."

Joe, Big Red

"Once again the DMC personnel are extremely knowledgeable as well as very personable. I appreciate Mitzi coming from San Antonio to help."

Sheryl, Tejas Logistics

"Mitzi was called on the spur of the moment and came over as soon as she was available. She handled our situation professionally and quickly."

Shirley, Apollo Gate Operators

"I wanted to thank you all for the work that you did last week. Everybody that I talked with only had high praise for the job that you did."

Rickey, Process Technology International

"Mitzi understood my requirements and had good solutions and alternatives to get the job done."

Roberta, TRDI

"Liz will be a great addition to your staff, very nice to work with."

Milana, Waterfall Financial

"Big help in setting up MAS 90."

Gary, Coinstar Entertainment Services

"You have the very best people! No offense Mike but you may be the weakest link!"

Brenda, Well Testing

"Mike’s knowledge has helped us out tremendously. We now see the light at the end of the tunnel!"

Lisa, The Marbridge Foundation

"Mitzi is the greatest!!!"

Doreen, American West Laundry

"Mitzi is always professional, knowledgeable, and prompt to provide assistance."

S. Clark, Clark Benefit Group

"Lance did a great job for us. His effort is greatly appreciated!!"

Dan, The Letco Group

"Mike was very helpful and patient."

Kim, Applied Recovery Systems

"Mitzi is always pleasant with us. We always present her with an obstacle and she overcomes it each time. Out installation went smoothly."

Act Fast Delivery

"Mitzi was very patient with me and taught me a lot in the short time she was here. I like that she takes the time to go step by step and doesn't assume that I'm a CPA on someone certified. She's going to let me know when the workshop will be!"

Essie, The Whitley Company

"Mitzi is very helpful!"

Marta, CS Electric

"Mitzi was extremely knowledgable on our version of Peachtree (ver. 7) which not even Tech Support at Peachtree could help with."

Gloria, Jofel USA

"I have never had such a good experience in 15 years that I did working with Julie."

Duncan, C. S. Electric

"Thanks for saving us trouble!"

Theresa, Belco Manufacturing

"[The training class was] very informative and helpful for all aspects of sales order entry!"

Colleen, USA Wire & Cable

"The DeRosa Mangold team is very supportive and worked diligently through a long and difficult day."

Sharon, Dobbs-Stanford Corporation

"Thanks, I will sleep better tonight."

UBI Products

"Mitzi is great - have called on her for years. She's professional, knowledgeable - couldn't do without her. Many thanks!"

Elizabeth, Kendall County Appraisal District

"Mitzi is very knowledgeable, helpful and patient."

P. DiMasi, Southwest Regional Cancer Center

"We accomplished what we needed to do without having to go through a time consuming project."

Kim, Applied Recovery

"DeRosa Mangold has never failed us. I have all the confidence in the world in DeRosa Mangold. They are more knowledgeable than the software help desk."

Elaine, Centex ARC

"The class has been very helpful. We especially liked the examples and shortcuts. Very valuable info!"

Bridgette, Brown Distributing

"I wanted to take the time to formally acknowledge all the time and effort that Cecilia gives to us at Forum. Whether it is with daily issues or needing help on the weekend, I feel that she goes above and beyond to make me feel like I am her only client."

Tony, Forum Energy Technologies, Inc.

"I have worked only a few times with Mitzi, but she is very knowledgeable and knows her stuff. The new consultant was also very helpful. You have a great asset to your company."

Rachelle, R&K Specialized

"The installation went well. Your staff was very professional and efficient."

Kim, Applied Recovery Systems

"As always, Mitzi did a terrific job and I have great confidence she will be there when we need her!"

Shirley, Arts Center Enterprises

"Mitzi did a great job on custom reports; so good, that my boss is dreaming up more!"

M. Kessler, Pro-Tech Engineering

"Mitzi is a fantastic lady and always a joy to work with."

Linda, Aero Parts

"I am always very pleased with the service from Mitzi."

Gloria, Jofel USA

"A big thanks goes out to phone support for always helping me solve issues. I would tell others about the DeRosa service."

Margie, Built Wright Construction

"Great advice and training. Look forward to having you visit again! Thank you."

Michelle, Tige Boats

"DeRosa Mangold Consulting is doing a great job of keeping my tasks organized and helping me work through them."

Lisa, Docudata Solutions

"Mike, as always, was very pleasant and successful in solving my issues."

Kim, Applied Recovery Systems

"Mike is a very knowledgeable person and we are grateful for his help."

Rhonda, Central Texas Frame and Alignment

"Mitzi is a very pleasant person to work with."

Dijanna, Austin Gutter Man Inc

"We feel very confident dealing with Mitzi. She makes what seems hard easy instead."

Bill, Fun Equipment Sales

"Mitzi was able to do what I asked very timely and was willing to help in other areas. I always feel the job is complete and what I needed."

Shirley, Apollo Gate Operators

"It was a pleasure working with the DeRosa Mangold Consulting team."

Sheryl, Video General

"Good information in understanding the knowledge I need to support MAS 200. DeRosa Mangold [classroom instructors] has real world experience, and that was very helpful."

Terry, Alamo Body & Paint

"Mike has been a breath of fresh air. He is work with me and talking to us in relation to our Accounting Records instead for just data. He's the best Consultant out of six we've talked to in the last month."

Craig, The Marbridge Foundation

"Cecilia cleaned up a lot of small things that were still outstanding. I feel much better about going forward on MAS."

Lisa, Docudata

"Mike was very helpful - as usual."

Kim, Applied Recovery Systems

"Caterina is very pleasant to work with!"

Bill, Specialty Property

"Mike's asssitance with our General Ledger, Labor Code and Time System import discussions helped to get us headed in the right direction."

Lisa, Docudata Solutions

"The upgrade was virtually 'Painless'."

Kim, ARS

"I’ve used MAS 90 for 6 weeks and I was able to still obtain more knowledge on this software by attending the training class."

Lisa, D&S Residential

"THANK YOU SO MUCH!!! You folks are the best."

Jon, Granite Security Products, Inc.

"Mike was extremely helpful and solved many issues while in our office."

Donna, D&S Residential

"Our trainer was extremely knowledgeable about the subject matter and could answer even complex situational questions. She was very impressive!"

Angela, VIEO

"Julie helped me with several issues. She is so nice and helpful. I really enjoyed working with her."

Eric, TSI

"Mitzi is wonderful - she has a nice way of not letting me feel like an idiot when I mess up. ' and 'Mitzi is great, she designed our invoice template on the spot."

Diana, Training Rehabilitation and Development Institute

"Got a lot accomplished. She 'Mitzi' is very patient with me."

Marla, Pro-Tech Engineering Group, Inc.

"Mitzi has helped us since our beginning as a company. She is very knowledgeable, always helpful and a delight to work with."

August Consulting

"Thank you for your help upgrading DMS to Sage 100. We really appreciate it."

Tanya, Diversified Machine Systems

"Rob changed his task request once Mitzi arrived. She was very accomodating."

Shirley, Apollo Gate Operators

"Mel called me yesterday and she took care of it. Thanks for prompting her to call me. She is great to work with!"

Susan, Mesker Doors

"Thank you so much for your great service!!! :)"

Michelle, Tige Boats
Copyright © 2012, DeRosa Mangold Consulting, Inc. - (877) 772-2980
Accounting and ERP Solutions specializing in Sage 100 ERP*, Sage CRM and JobOps
*Sage 100 ERP is formerly known as Sage MAS90 ERP and Sage MAS200 ERP
Privacy Policy