It’s our last official post for 2011 and we’d like to wish you all the happiest of holidays and say a warm “thank you” for your support and patronage this past year!
Seasons Greetings and Happy Holidays to all of you! I hope each and every one of you have a fantastic holiday season.
I’d like to thank everyone for your support of the QuickBooks for Contractors blog during the past year.
Our office will be closed from Friday, December 23 through Monday, December 26 and again from Friday, December 30 through Monday, January 2, 2012; while we share the holiday season with friends and family.
During this time were also going to do some well deserved maintenance and updates to our main website to prepare for 2012.
When we relaunch on Tuesday January 3, 2012, you’ll find that we’ve been very busy during this time. The Federal WH 347, certified payroll report is due to expire on December 31 and we will be providing information about the new reporting requirements so that you’ll be up to date. Additionally, after a very long delay, the Compliance Monitoring Unit, part of the California Department of Industrial Relations, will go into effect. So there will be information available about this as well.
In addition to these prevailing wage law changes you’ll find that we’ve been busy updating and creating new QuickBooks training materials geared for commercial and government construction contractors. These new materials will be in the form of e-books, pre-recorded videos and live webinars. All which will be reasonably priced.
Until then, have a safe and happy holiday season and be sure to check back next year to see what we’ve been up to!
Payroll is a complex part of every bookkeeper’s job, new requirements for 2012 include showing company paid health insurance premiums on employees W-2′s; making things even more complex. See this question asked by a reader of our blog.
I have a question that I’ve been searching for an answer to, I’ve even asked our Tax Accountant about it. In 2012 it is mandatory that we show the company share of employee health insurance on W-2′s, do you know if there is there a way in QuickBooks to track this on a regular basis, so that it shows on the employees paystubs and then have it flow through onto the W-2 at the end of the year? Thanks, Kathleen S.
——————————————————————–
Answer:
Hi Kathleen,
Yes, you can set QuickBooks up to track employer paid health insurance contributions, have those contribution amounts appear on employee pay stubs and then have the full yearly contribution appear on the employee’s W-2. I’ve been doing this for a long time – thankfully the QuickBooks payroll module is pretty flexible, the hardest part is the setup – and then the maintenance.
Important things to take into consideration prior to setting up QuickBooks to track this information – OR the planning stages:
- Health insurance premiums for all employees are usually paid on a monthly basis in one lump sum made up of a specific amount for each employee based on the type of plan or coverage each employee has. The chances are that you pay your employees more often than that – so you want to set up a method of tracking company contributions for health insurance based on how often you pay your employees – so that the contribution is done automatically for you when you run your payroll rather than having to “remember” to do something once a month.
- Will the company pay 100% of the cost of health insurance or will the employee also pay a portion through a payroll deduction?
- How many pay periods your company actually has during the year.
- When does your company health insurance policy renew?
- Will you also be using/taking credit for company paid health insurance against the full fringe benefit amount that must be paid when employees work on prevailing wage jobs?
We’ve put together a video demonstrating the required QuickBooks setup and a free Excel Spreadsheet for tracking the costs of 100% company paid health insurance.
———————————————————————————————–
Information from the IRS regarding Employer Paid Health Insurance Reporting:
Employer-Provided Health Coverage — Not Taxable; Reporting is Voluntary for All Employers for 2011 and Small Employers for 2012
Starting in tax year 2011, the Affordable Care Act requires employers to report the cost of coverage under an employer-sponsored group health plan. To give employers more time to update their payroll systems, Notice 2010-69, issued last fall, made this requirement optional for all employers in 2011. IRS Notice 2011-28 provided further relief for smaller employers filing fewer than 250 W-2 forms by making the reporting requirement optional for them at least for 2012 and continuing this optional treatment for smaller employers until further guidance is issued. Notice 2011-28 also includes information on how to report, what coverage to include and how to determine the cost of the coverage.
The 2011 Form W-2 is available for viewing on IRS.gov. This is the W-2 that most employees will receive in early 2012. The form includes the codes that employers may use to report the cost of coverage under an employer-sponsored group health plan. {Currently, as of 12/12/2011, you will report Health Insurance Costs in Box 12 of the W-2 using code DD}.
This reporting is for informational purposes only, to show employees the value of their health care benefits so they can be more informed consumers. The amount reported does not affect tax liability, as the value of the employer contribution to health coverage continues to be excludible from an employee’s income, and it is not taxable.
What types of health care coverage must be included in the amount reported on the Form W-2?
A. Employers are required to report the total cost of all “applicable employer-sponsored coverage” provided to an employee. For any employee, “applicable employer-sponsored coverage” is coverage under a group health plan that the employer makes available to the employee that is non-taxable to the employee (or that would be non-taxable if the coverage were employer-provided).
Certain types of coverage are excluded from the definition of applicable employer-sponsored coverage and are not included in the amount reported. These types of coverage are:
- coverage only for accident, or disability income insurance, or any combination of these coverages;
- supplemental liability insurance;
- liability insurance (including general liability insurance and automobile liability insurance);
- workers’ compensation or similar insurance;
- automobile medical payment insurance;
- credit-only insurance; and
- other similar insurance coverage specified in regulations, if the benefits for medical care are secondary or incidental to other insurance benefits.
In addition, employers should not include the following amounts in calculating an employee’s total cost of coverage:
For additional information on this topic, visit these links:
- Affordable Care Act Tax Provisions - http://www.irs.gov/newsroom/article/0,,id=220809, 00.html
- 2011 Form W-2 - http://www.irs.gov/pub/irs-pdf/fw2.pdf
- IR-2011-31 - http://www.irs.gov/newsroom/article/0,,id=237870,00.html
- Notice 2010-69 http://www.irs.gov/pub/irs-drop/n-2010-69.pdf
- Notice 2011-28 http://www.irs.gov/pub/irs-drop/n-11-28.pdf
- Employer-Provided Health Coverage Information Reporting Requirements – Q & A - http://www.irs.gov/newsroom/article/0,,id=237894,00.html
- IRS YouTube Video – Health Care: W-2 Health Insurance Reporting - http://www.youtube.com/watch?v= TFepqFnEj5I&feature= youtu.be
- IRS Webinar - Reporting of Employer Healthcare Coverage on Form W-2 - http://www.irsvideos.gov/ReportingEmployerHealthcareCoverage/
- New Info added 1/3/2012 – IRS Notice 2012-09 – http://www.irs.gov/pub/irs-drop/n-12-09.pdf – Interim Guidance on Informational Reporting to Employees of the Cost of Their Group Health Insurance Coverage
We hope that you’ve found this post informative, if so please take a moment to leave a comment or share it on your favorite social network.
———————————————————————————————————
Update 12/16/2011 – Intuit Releases Payroll Update 21201
Late yesterday afternoon Intuit released Payroll Update 21201, which includes revised tax tables and several form updates. Included in this update is the option for reporting Health Insurance under Code DD on employee W-2′s.
When creating or editing an existing Company Contribution item type for Employer Paid Health Insurance, when you get to the Tax Tracking Type window, from the drop down list, select Health Coverage Cost, as shown in the screenshot below:
Right click on the image to enlarge it
We will be updating our video by the first of the year to reflect the actual selection of the correct tax tracking type.
Strategies for Making the Move to Public Works Construction Projects Seminar – American Subcontractors Association, San Diego branch, January 19, 2012
The current economic situation has dealt a serious blow to both homebuilders and commercial contractors and many are finding themselves make the move to Public Works construction and Prevailing Wage projects. Make the move to Public Works construction will require planning and quite possibly a variety of changes in the way you currently run your existing construction business.
Join industry experts; Steve Kuzmack, President of Fringe Benefit Experts and Nancy Smyth, President of Sunburst Software Solutions, Inc. for an intensive 2 hour session on January 19, 2012; on strategies for lowering labor costs and complying with certified payroll reporting requirements on Federal and/or State funded construction projects.
Learn How:
- To reduce payroll taxes and insurance premiums on your prevailing wage projects.
- “Bona Fide” benefit plans operate and how they decrease labor costs while increasing company profits and enhance employee benefit programs.
- You, the owner, can put more pre-tax money into your personal 401K.
- To smooth out the wage discrepancies between Private and Public Work.
- To save $2.00 – $4.00+ in payroll burden per man hour – based on San Diego Wage Rates.
- Supplemental Unemployment Benefit {SUB} Plans operate – and why your field workers like them.
Learn the Pros and Cons of Paying the TOTAL Hourly Prevailing Wage Rate on Payroll:
- Impact on your company
- Impact on your employees
Learn About Types of “Bona Fide” Fringe Benefit Plans:
- SUB Plan – “Field Workers Get Paid When Not Working” {Holidays, Layoffs, Reduction in Hours}
- Pension Plan – How to Increase Owner and Staff Pre-Tax Contributions
- Health Plan – Make Health Insurance Premiums not only Pre-Income Tax but Pre-Payroll Tax as well
Learn About Bookkeeping, Accounting & Payroll Procedures:
- When you pay the full fringe rate as part of employees hourly rate of pay
- When you pay the full fringe rate to one or more “bona fide” fringe benefit plans
- When you pay a portion of the fringe benefit rate to a plan and the balance in cash
Learn About Certified Payroll Reporting Requirements:
- What is a Certified Payroll Report?
- How do I complete a Certified Payroll Report?
- Are there different requirements for State and Federally funded construction projects?
If you want to get more competitive, grow your company and create more profit; then this seminar is for you.
This event will be held:
January 19, 2012 from 1:30 – 3:30 p.m. at the SMART Safety Office, 9471 Ridgehaven Ct. #C, San Diego, CA 92123. Non-member Price $60.00. Member Price $45.00. Register for the event OR download a seminar flyer.
Payroll can be one of the most complex duties of any bookkeeper’s job – especially when you need to OR want to track your Worker’s Compensation costs for job costing purposes and pay your employees Vacation, Holiday and Overtime wages. Just take a look at this question, submitted by one of our blog subscribers!
I have set up the Workers Compensation tracking in QuickBooks for a construction company with no problem, it seems to be working fine. My question is – how do you keep track of Holiday, Vacation, and Overtime pay? Do I set up each payroll item with the Workers Comp {WC} rate for each class? For example Carpenter-Holiday and Carpenter-Vacation? Thanks, Kathleen
—————————————————————–
Answer:
Hi Kathleen;
That’s an excellent question!
One of the first things that you should do is contact your Worker’s Compensation Insurance carrier and ask them if there is a reduced Worker’s Comp rate for when you pay your field workers for non-field related time such as Vacation or Holiday pay. I once asked this question of the Insurance underwriter and much to my surprise he told me {grudgingly} that Vacation and Holiday pay for field employees was computed at a lower experience rate than their normal wages; mainly because there was “no risk” involved for those wages – he quickly followed this up with “but this will involve more tracking on your part” for the annual audit/review.
The QuickBooks payroll module is pretty darn flexible; but like the rest of the program it’s generic – so sometimes it’s a little “lacking” when it comes to some specific things like the situation above.
Even if I didn’t fall into the special situation of a reduced WC Experience Rate for Holiday and Vacation time, I would still create specific payroll items based on Work Classification/type of wage: so Carpenter-Holiday or Carpenter-Vacation would be the way I would go.
Overtime can get tricky, especially if your contractor client works on prevailing wage jobs and pays the fringe benefit portion of the prevailing wage in cash to the employee as part of the hourly gross wage, QuickBooks will need some “help” when determining the overtime rate. {This becomes complex and cannot be explained in a blog post but I plan on providing a fee-based live and pre-recorded webinar on how to set this up and make it work in QuickBooks – which will be available in January 2012}.
You will need to add an “Overtime” payroll item to your Payroll Item List using either the E-Z Setup or Custom Setup method naming them Carpenter OT, Laborer OT, etc and being sure that you select that the type of wage is an Overtime rate. If the premium OR half-time portion of overtime pay is excluded from Worker’s Compensation tracking, make sure that you have checked that option in the Workers Compensation preference; found from the Edit menu -> Preferences -> Payroll & Employees -> Workers Compensation button and checking the option to “Exclude overtime premium from Workers Comp calculation”
Right click on the image to enlarge it
Make sure that your Codes in the Workers Comp List are descriptive – meaning that when you choose the WC Code in Weekly timesheets that you will understand what code is being assigned to what payroll item.
Setting things up in this manner will provide you with all the payroll numbers that you will need during an audit and clearly indicate the type of wages that are being paid.
If you feel this QuickBooks Payroll tip has been helpful, please take a moment to leave us a comment or to share it with others on your favorite Social Networking site 
