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 
This payroll tip discusses being prepared for Wage & Hour and IRS Audits – what records have to be kept, how long you need to keep them, etc. From the General Ledger, a complete newsletter for Professional Bookkeepers published by the American Institute of Professional Bookkeepers.
Break out the trusty old metal/wooden file cabinets and wipe off the dust — or maybe it’s time to invest in some virtual file cabinets where documents are scanned in and stored off-site but accessible if you need them. Either way you are in for a shock!
We’ve mentioned previously that the U.S. Department of Labor is making a major push on wage-hour enforcements and that the IRS has also beefed up enforcement efforts – but what we didn’t include at that time was a list of documents that you must keep and how long they have to be kept. When October’s issue of the General Ledger arrived, this information was front page news; and I felt I needed to share it with you. I hope you are sitting down and have had your morning coffee!
Even if your company has never violated one IRS or DOL rule, substantial penalties may apply simply for not maintaining required records. Now is the time to gather or seek copies of the records you are required to keep under federal law. Records may be stored at at company offices; or for multiple locations, in a central office.
Keep for at least 4 years:
The IRS requires employers to keep the following for at least 4 years. NOTE: Because the 4-year period begins at different time, keep the following for at least 5 years.)
|
|
The DOL or IRS (or both) require you to keep the following data. If not in hard copy, it should be available to print.
Keep for at least 3 years:
|
|
Keep for at least 2 years:
Documents that support calculations for the following.
|
|
Keep for at least 4 year
From April 15 following the due date of the return; employment related tax forms and data.
|
|
Vendor and non-employee payments:
|
|
All of this adds up to a LOT of paperwork that you have to keep on hand and accessible. Storage is going to be an issue for most businesses as well as making sure that the stored documents are kept safe – I know that these issues are a concern for me, as like most business owners I only have limited space.
We’ve used QuickBooks since we started our business in 2000, so all of the “detail” is housed in our QuickBooks file; we did have to archive our file at the end of 2006 because it was getting too big and running slow, so we have a backup copy that contains all the detail stored in our safe deposit box at the bank. Our current QuickBooks file contains a summary of that archived information, and I keep that backed up and stored in a several locations – locally on an external hard drive, on a remote (cloud based) location that both my husband and I have access to, and a backup which I keep on my laptop – so my QuickBooks file is pretty safe.
But, the hard copy paper payroll related data – well, right now all of that is stored by year in 3-ring binders; and all of the paper copies of business income and receipts are stored in cardboard file boxes in our attic! If there was a fire – well, we’d loose all that paper data! I guess it’s time that I get my act together and do something about electronic storage for at least all of the payroll related data.
How are you storing all of the information that would be required for a wage-hour or IRS audit?
5 certified payroll reporting mistakes that will cause delayed payments – learn how to avoid them.
Filling out weekly certified payroll reports can be a time-consuming and frustrating task, especially if you complete them by hand or have to manipulate data in order to create them. Transposition errors and other mistakes are bound to happen, no matter how careful you think you are being. Making mistakes on certified payroll reports will lead to more frustration and you’ll end up spending more time correcting the errors; mistakes will also put your company’s good standing in jeopardy with the General Contractor or Project Administrator.
Certified Payroll/Prevailing Wage reporting can be complex and varies by state. Learning how to avoid the following mistakes and submit the reports properly the first time will benefit you and your company.
- Your reports are rejected as inadequate or incomplete – you may not have submitted the proper form or some of the required information is missing. You’ve been told that you need to correct the forms and resubmit them by a new deadline or your company, and the General Contractor, will have to wait longer to receive payment. Delayed payments have a negative affect on everyone’s cash flow. The Labor Standards Clause of the final contract (and the bid package) for each job usually provides you with a sample of the certified payroll reporting form that you will be required to submit; it will also inform you if you are required to file your reports electronically.
- You didn’t pay your employees prevailing wage and you didn’t submit certified payroll reports - you’ll need to make wage restitution to your employees to bring their rate of pay up to the prevailing wage rate required on the job and then you’ll need to submit ALL of the certified payroll reports within 30 days from the time that the General Contractor was notified. Payments to both your company and the General Contractor can be delayed. The requirement to pay prevailing wages and submit certified payroll reports is included and usually discussed in the Labor Standards Clause of the bid package and the final contract.
- You didn’t pay your employees the rate of pay listed in the Wage Decision – you’ll need to make wage restitution to your employees, provide proof of the wage restitution, and submit corrected certified payroll reports within 30 days from the time that the General Contractor was originally notified. A Wage Decision is a listing of all the different Work/Trade Classification and minimum wage rates (base PLUS fringe) that must be paid to anyone performing work on the jobsite. Some Wage Decisions cover several counties and/or types of construction (residential and commercial) and can be difficult to read – in instances such as this, the Contract Administrator may prepare a Project Wage Rate Sheet or issue a Wage Bulletin, which will only show the Work/Trade Classifications and wage rates for a specific project. The Wage Decision is found in the Labor Standards Clause of the bid package and the final contract.
- Your employees Work Classifications do not match those listed on the Wage Decision – you’ll need to correctly classify your employees according to the Work/Trade Classification found on the Wage Decision, and quite possibly make wage restitution to your employees. You’ll need to provide proof of any wage restitution, if applicable, and provide corrected certified payroll reports within 30 days from the time that the General Contractor was originally notified. Each employee must be classified and paid accordingly, based on the type of work they are performing. If the Wage Decision doesn’t contain the correct Work Classification; a written request must be submitted. The written request must identify the Work Classification that is missing, recommend a wage rate, and provide a description of the actual work being performed. This written request should be submitted/discussed at the bid qualification meeting.
- Your reports have incorrect computations, unclassified “Other Withholdings”, or do not indicate how the fringe benefit portion of the prevailing wage is paid – you will need to submit corrected reports within 30 days of the date that the General Contractor was originally notified. While these items may seem trivial, they are all part of the requirements of certified payroll reporting. Always check the “math” on the final reports before submitting them, for example, the Federal WH-347 certified payroll report should match the employees paycheck exactly for gross wages ALL jobs, withholdings and net wages paid for the week, even if you use a software program to generate your reports you should verify that these numbers match before you submit the reports.
Learning to avoid these mistakes is in your best interest because will you avoid extra paperwork and be paid in a timely manner.
If you are manually creating the reports or having to manipulate large amounts of data to generate the reports, you aren’t saving any time (or money) and need to automate the process in order to eliminate the transposition errors and save valuable time that could be better spent on other tasks. I see many QuickBooks users discussing on the Intuit forums how they generate the built-in QuickBooks certified payroll report and either manually make corrections or print the report and then enter that data into a fillable Federal or State Specific certified payroll report on a weekly basis.
Make sure that you have thoroughly reviewed the Labor Standards Clause of the bid package AND the final contract package and provide your payroll administrators with the information that they need to correctly pay your employees. If you continue to submit incorrect certified payroll reports you will be in violation of certified payroll reporting requirements and this can mean that you will be disbarred; not allowed to bid on or perform work on prevailing wage projects for up to 3 years. Additionally, you may be passed over in favor of another company (even if you do top quality work) if you have a “checkered past” in meeting the reporting requirements.
Wage Restitution is the difference between what the employee should have been paid (base PLUS hourly fringe) and what they were paid.
If you are new to certified payroll reporting requirements, sign up for a 2-hour Certified Payroll Reporting Training webinar, $69.00 per person.
If you use QuickBooks and want to automate the entire certified payroll reporting process, request a Free 30-Day Trial of Certified Payroll Solution.
Unraveling Certified Payroll Requirements On Federal Construction Projects webinar presented for L2 Federal Resources, LLC
Wednesday, May 18, 2011 • 1:00 – 2:30 PM EDT
Presented by: Nancy Smyth, Sunburst Software Solutions, Inc.
_____________________
Making the move from residential/commercial construction projects to government-funded construction projects, which have certified payroll reporting requirements, can be overwhelming for most contractors, their office staff, and the accounting professionals who support them. This often misunderstood requirement can lead to major problems, including non-approval of payment requisitions, denial of payment for change orders and claims, and contract termination. Don’t get caught in a payroll certification trap; learn the ins and outs of federal certification payroll requirements and get all your questions answered.
Our live, instructor-led, on-line training class focuses on the following:
- What government agencies make the laws behind certified payroll reporting requirements?
- How to comply with Labor Standards & Payroll Reporting requirements
- How to complete a Certified Payroll Report & Statement of Compliance
- Common methods for creating Certified Payroll Reports, Statements of Compliance, EEOC, ARRA and Fringe Benefit Reports
- State prevailing wage vs. Davis-Bacon forms and which form applies
- Electronic certified payroll filing requirements
- Ways contractors pay fringe benefits and how to report them
- Tracking employee time and work classifications
- Requesting additional “trade/work classifications” and wage rates
- Typical errors that require correction
- Don’t forget to include your subcontractors
- What happens when things go wrong
- Automating these time-consuming, error-prone tasks
- And much, much more!
In addition, a 10-to-15 minute period has been reserved at the end of the speaker’s presentation for an interactive question-and-answer session so you can discuss specific issues or gain additional knowledge about topics discussed.
Who Will Benefit?
Contractors who are currently (or are interested in) contracting with the federal government, and who want to better understand and improve their certified payroll processes. Certified payroll is everyone’s business; gather your whole team, including:
- Owners
- Estimators
- Controllers
- CFO’s
- Payroll processors
- Office managers
- Business development experts
- Accounting & Consulting professionals
- Union and non-Union Contractors
Register ONLINE, at the L2 Federal Resources, LLC registration page.
Taking a credit against the full prevailing wage fringe benefit for company paid 401k contributions and reporting it correctly on the Federal WH-347 Certified Payroll Report can be very confusing. This question was asked by a reader who recently requested our 4 Ways Contractors Pay Prevailing Wage Fringe Benefits eBook.
We are a non-union shop working on prevailing wage jobs; our Company offers a 401k plan and the company contributes 4% of our employee’s gross wages to the 401k. We understand that the 401k plan is considered a bona-fide plan, but how do we take an hourly credit when our contributions are based on a percentage of gross? Currently we just look at an employee’s gross wages for the month and make the calculations and contributions.
————————————————
Taking a credit against the full prevailing wage fringe benefit IS confusing, it’s NOT just you.
The fact that you are a non-union shop, and your employees are probably also work on non-prevailing wage jobs adds another layer of complexity to this. And if you also take credit for other company paid contributions, such as health insurance – well, that to will add complexity. If the credits that you take do not equal the FULL prevailing wage fringe – well that too adds an additional layer of complexity.
From what “I” know (and realize that I’m in Vermont and know enough about prevailing wage rules & regulations to be dangerous – I may not know all the fine print for your specific state). I will explain what I know and you should then verify it with the Prevailing Wage Unit of your local Department of Labor just to make sure. I also want to point out that this methods is not 100% accurate and extra work will need to be done if the combine credits that you can take do NOT equal the full fringe benefit rate.
Step 1 – Convert the percentage into an hourly rate
First you are going to need to convert the percentage into an hourly rate.
This is done by taking the prevailing wage hourly base rate and multiplying it by 4%. So if the base rate is $35.00 per hour multiply this by 4%, which equals $1.40.
Step 2 – Set up a company contribution item in your accounting software to track the hourly rate
While you probably already have a company contribution item in your accounting software, you’ll want to add another one specifically for the prevailing wage credit, this will make it easily identifiable in the event of an audit.
If you use QuickBooks to do your payroll, go to the Lists menu -> Payroll Item List -> click the Payroll Item button (bottom left of this window) -> choose New -> Custom Setup -> choose Company Contribution -> enter the name that you want to use in checks and reports (PW 401k) -> make sure the track expenses by job option is checked -> currently the Tax tracking type should be set to None -> on the Taxes tab, nothing should be checked -> select the Calculate based on quantity option -> and on the last window set default rate to 1.40 with no annual limit AND be sure that the This is an annual limit option is NOT checked. Click Finish.
Add this new company contribution item to the Payroll & Compensation Info tab of all employees in the Additions, Deductions and Company Contributions section.
Step 3 – When creating paychecks
This is where it gets really complex, especially if the credits you take against prevailing wage do not equal the full fringe rate and you pay a portion of the fringe in cash – which will then increase the hourly rate of pay.
EXAMPLE: John J. Equipment, your employee works 25 hours at $35.00/hr on a prevailing wage job and 15 hours at $28.00/hr on a non-prevailing wage job during the week.
Against the company contribution item for the prevailing wage 401k you will enter a quantity of 25 (for 25 hours worked on a prevailing wage job). This entry is pretty straightforward.
To determine the “normal” 4% of gross 401k contribution, you’ll need to take the total gross from all hours worked multiply it by 4% then SUBTRACT out the prevailing wage contribution, and enter that dollar amount.
- 25 prevailing wage hours x $35.00/hr = $875.00
- 15 non-prevailing wage hours x $28.00/hr = $420.00
- equals $1,295.00
- times 4% = $51.80
- MINUS 25 prevailing wage hours x $1.40/hr credit = $25.00
- $51.80 MINUS $25.00 = $26.80 remaining 401k contribution
You’ll enter the $26.80 in the RATE column for the “normal” 401k contribution.
Important Note: If the items that you are allowed to take credit for do not equal the full prevailing wage fringe; consider adding a bona-fide plan to handle the balance of the fringe benefit contribution. A very good plan to consider is the one offered by Prevailing Wage Contractors Association (PWCA), the employees have access to the fringe contributions if you have to lay them off for a short amount of time. For additional information please contact us or contact PWCA directly, indicating that you found them through Nancy Smyth from Sunburst Software Solutions, Inc.
