Generating weekly certified payroll reports when you issue bi-weekly paychecks to your employees can be difficult unless your accounting software will accurately accrue the wages for each week – QuickBooks doesn’t have this ability and quite often this causes problems.
Payroll is one of the largest expenses that a company will have. Most companies, when they start up, will find out what the minimum requirements for paycheck frequencies are for the state that their business resides in – earlier this week we discussed paycheck/payroll frequencies by state – and they will follow those rules. This will work fine unless you are a contractor who makes the move to Public Works/Government Construction projects and become subject to prevailing wage laws. This is when problems can occur.
Under the Federal Davis-Bacon and related Acts; contractors and subcontractors performing work on Federal or Federally-aided construction-type contracts are required to submit weekly payrolls. The Copeland Act provides further/clearer requirements; indicating that contractors and subcontractors performing work on Federally financed or assisted construction contracts “furnish weekly a statement with respect to the wages paid to each employee during the preceding week”.
Obviously, contractors and subcontractors who issue their payroll on a weekly basis find the necessary information easier to obtain; therefore, making compliance of certified payroll reporting easier on the people who actually have to complete the reports.
What happens when your company is subject to the rules found in the Davis-Bacon and the Copeland Act and you issue your payroll on a bi-weekly basis?
I’m not here to tell you that you HAVE to start issuing your paychecks on a weekly basis – I’m only here to tell you what the requirements are and about what COULD happen – based on my experience; so that you can make an informed decision.
If you are lucky enough to have an accounting program that accurately accrues and distributes payroll taxes and wages based on when it is earned rather than when it is paid – you shouldn’t run into any issues when you create the certified payroll reports. BUT, if you use QuickBooks you need to be aware that it does not have this ability and your payroll is recognized only when you actually issue the paycheck and this is where the problem with your certified payroll reports COULD begin.
Each certified payroll report has a weekly calendar section {shown below} where by day and date you enter the number of hours that each employee worked on the prevailing wage job site and the total hours that he/she spend there during the entire week.
Right click on the image to enlarge it
When you issue payroll in QuickBooks on a bi-weekly basis – you will enter the time worked for each of the two separate workweeks in two individual timesheets, for example, let’s say that your pay period ends on a Saturday:
- Your first work week covers Sunday, December 21, 2003 through Saturday, December 27, 2003
- Your second work week covers Sunday December 28, 2003 through Saturday, January 3, 2004
- Your paychecks will be dated on January 7, 2004
Below are the two timesheet entries from QuickBooks:
- Workweek 1 has 24 hours on the Prevailing Wage Job and 16 hours on a non-prevailing wage job
Timesheet Work Week 1 - Right click to enlarge
- Workweek 2 has 24 hours on the Prevailing Wage Job and 16 hours on a non-prevailing wage job.
Timesheet Work Week 2 - Right click to enlarge
Next, we’ll look at the QuickBooks paycheck detail, you’ll see that the total number of hours are accurate for the full two weeks.
- A total of 48 hour at $28.50 per hour for $1,368.00 in wages for the prevailing wage job
- A total of 32 hours at $28.50 per hour for $916.00 in wages for the non-prevailing wage job
- Total gross for the 2 week period of $2,280.00
- Net wages for the week $1,528.33
Bi-weekly paycheck - right click to enlarge
When you create or run your certified payroll reports {whether is is with our Certified Payroll Solution software or using the built-in QuickBooks certified payroll report} you’ll need to generate two individual reports; one for each week. This is what the reports will look like:
- Week 1 – the hours are correct {24} and the rate of pay is correct {$28.50} BUT the gross amount earned This Job/All Jobs represents the FULL amounts from the bi-weekly paycheck {$1,368.00/$2,280.00} instead of $684.00 this job/ $1,140.00 All Jobs which was actually earned for this specific workweek.
Certified Payroll Report Week 1 - Right click to enlarge
- Week 2 – again, the hours are correct {24} and the rate of pay is correct {$28.50} BUT the gross amount earned This Job/All Jobs represents the FULL amounts from the bi-weekly paycheck {$1,368.00/$2,280.00} instead of $684.00 this job/ $1,140.00 All Jobs which was actually earned for this specific workweek.
Certified Payroll Report Week 2 - Right click to enlarge
Is this wrong? Well, sort of; the laws do indicate that payroll should be reported {therefore, issued} for the preceding week.
What can you do if you issue payroll on a bi-weekly basis?
Many of our own customers issue payroll on a bi-weekly basis, and on the Statement of Compliance {in the Remarks section} they add a note that indicates that they issue paychecks on a bi-weekly basis and while the certified payroll report accurately reflects the correct number of hours worked on the job for the specified week; gross amounts earned This Job/All Jobs, deductions {including taxes and other withholdings} and Net Pay reflect the full amounts from the single bi-weekly paycheck.
Will this statement keep you out of trouble?
Not necessarily, it all depends on the Contract Administrator and Awarding Agency.
The best thing to do, in my opinion, is to just bite the bullet and issue your payroll on a weekly basis; at least for the employees who work on the prevailing wage projects. This may mean some additional planing and scheduling on your part, but it’s easier than having your certified payroll reports rejected and having to manually calculate the gross, taxes, deductions and net pay and resubmit the reports!
Look for similar articles next week on how a semi-monthly or monthly payroll run will affect your certified payroll reports.
I hope that you’ve found this article to be informative and helpful in making informed decisions for your business; if so please take a moment to leave a comment or to share this with others on your favorite social networking platform using the buttons below.
Minimum payroll frequencies are determined by each state and can be quite confusing. I’m often asked “How often do I have to pay my employees” during a Certified Payroll Training Webinar. State minimum paycheck frequencies are shown below – this information comes directly from the U.S. Department of Labor’s website.
It’s difficult to thoroughly cover the requirements of all 50 states in a 2 hour webinar, but it has crossed my mind that a series of blog posts on the differences between what State Laws are for how often payroll must be generated and how that can effect the generation of a certified payroll report would be a good thing to do. While I could have simply started this series and talked about the complexities of generating certified payroll reports when issuing employee payroll on anything other than a weekly basis – I first wanted to display the requirements by state, rather than just put off a link to the U.S. Department of Labor website.
Under the Federal Davis-Bacon and related Acts; contractors and subcontractors performing work on Federal or Federally-aided construction-type contracts are required to submit weekly payrolls. The Copeland Act provides further/clearer requirements; indicating that contractors and subcontractors performing work on Federally financed or assisted construction contracts “furnish weekly a statement with respect to the wages paid to each employee during the preceding week”.
Obviously, contractors and subcontractors who issue their payroll on a weekly basis find the necessary information easier to obtain; therefore, making compliance simpler to obtain.
State |
Weekly |
Bi-Weekly |
Semi-Monthly |
Monthly |
| Alaska | X | X | ||
| Arizona | X 3 | |||
| Arkansas | X | |||
| California | X 9 | X 9 | X | |
| Colorado | X | |||
| Connecticut | X 4 | |||
| Delaware | X | |||
| District of Columbia | X | |||
| Georgia | X | |||
| Hawaii | X | X 5 | ||
| Idaho | X | |||
| Illinois | X | X 2 | ||
| Indiana | X | |||
| Iowa | X | X 6 | X | X |
| Kansas | X | |||
| Kentucky | X | |||
| Louisiana | X | X 7 | ||
| Maine | X 8 | |||
| Maryland | X | |||
| Massachusetts | X | X | ||
| Michigan 9 | X | X | X | |
| Minnesota | X 10 | |||
| Mississippi | X 11 | X 11 | ||
| Missouri | X | |||
| Montana 12 | ||||
| Nebraska 13 | ||||
| Nevada | X | X 2 | ||
| New Hampshire | X | |||
| New Jersey | X | |||
| New Mexico | X | X 2 | ||
| New York | X 14 | X 14 | ||
| North Carolina 15 | ||||
| North Dakota | X | |||
| Ohio | X | |||
| Oklahoma | X | |||
| Oregon | X | |||
| Pennsylvania 13 | ||||
| Rhode Island | X 16 | |||
| South Dakota | X | |||
| Tennessee | X | |||
| Texas | X | X 17 | ||
| Utah | X 18 | |||
| Vermont | X | X 19 | X 19 | |
| Virginia | X 20 | X 20 | X 2 | |
| Washington | X | |||
| West Virginia | X | |||
| Wisconsin | X | |||
| Wyoming | X |
- Alabama and South Carolina – No regulations or not specified.
- Illinois, Nevada, New Mexico and Virginia – Monthly payday requirements for Executive, Administrative, and Professional personnel.
- Arizona – Payday two or more days in a month, not more than 16 days apart.
- Connecticut – Longer interval (up to monthly) permitted if approved by Labor Commissioner.
- Hawaii – Employees may choose to be paid on a monthly basis under special election procedure. Director of Labor and Industrial Relations also may grant exceptions to the general semi-monthly payday requirement. Payday requirement applies only to private sector employment.
- Iowa – Any predictable and reliable pay schedule is permitted as long as employees get paid at least monthly and no later than 12 days {excluding Sundays and legal holidays} from the end of the period when the wages were earned. This can be waived by written agreement; employees on commission have different requirements.
- Louisiana – Applicable to entities engaged in manufacturing, mining, or boring for oil, employing 10 or more employees, and to every public service corporation. Payment is required once every two weeks or twice during each calendar month.
- Maine – Payment due at regular intervals not to exceed 16 days.
- California and Michigan – Frequency of payday depends on the occupation.
- Minnesota – Employees engaged in transitory employment, i.e. migrant workers, which require and employee to change the employee’s pace of abode, because the employment is terminated wither by the completion of the work or by the discharge or quitting of the employee must be paid within 24 hours.
- Mississippi – Applicable to every entity engaged in manufacturing of any kind in the State, employing 50 or more employees and employing public labor, and to every public service corporation doing business in the State. Payment is required once every two weeks or twice during each calendar month.
- Montana – Wages must be paid within 10 business days after the wages are due and payable.
- Nebraska and Pennsylvania – Payday designated by employer.
- New York – Weekly payday for manual workers. Semi-monthly payday upon approval for manual workers and for clerical and other workers.
- North Carolina – None specified, pay periods may be daily, weekly, bi-weekly, semi-monthly or monthly.
- Rhode Island – Childcare providers shall have the option to be paid every two weeks.
- Texas – Monthly payday for employees exempt from overtime provisions of the Fair Labor Standards Act.
- Utah – Payments are to be paid at regular intervals but in periods no longer than semi-monthly.
- Vermont – Employers may implement bi-weekly and semi-monthly payday with written notice
- Virginia – Employees whose weekly wages total more than 150% of the average weekly wage of the Commonwealth may be paid monthly, upon agreement of each affected employee.
NOTE: South Carolina – Employers with 5 or more employees are required to give written notice at the time of hiring to all employees advising them of their wages agreed upon, and the time and place of payment along with their expected hours of work. The employer must pay on the normal time and at the place of payment established by the employer.
Stay tuned over the next week to find out some of the problems that can occur when a company follows various state payroll requirements {bi-weekly, semi-monthly, and monthly paychecks} and how the pay frequencies affect the submission of their certified payroll reports.
The QuickBooks Weekly Timesheet can cause a lot of confusion for users who are implementing employee time tracking for the first time, mainly because the timesheet contains both a Service Item and a Payroll Item. This article will explain what each column is used for and some common pitfalls that can happen.
Job costing and employee time tracking are important aspects of many businesses – not just construction businesses. However, when you initially set up timetracking there are many things that can cause confusion.
About Service Items:
The Service Item column represents the type of work that is being performed and allows you to select/enter/choose the name of the service item/cost code from your Item List that you want to use when your charge/bill your customer for this work – OR – when you pay a subcontractor/non-employee for this item.
Even if you do not intend to charge anyone for this work, entering a service item provides a record of the amount of time spent on this specific type of work. This information will then flow through the the various “Time by” reports as well as your job costing reports..
When a Service Item is brought into an Invoice, it tells QuickBooks which accounts to use to track the income you receive and what Cost of Goods Sold/Expense account to use to track the money your company has spent – so it’s important that your items are set up to capture both Income and Expenses. This provides you with the ability to analyze which types of work/services are the most profitable and how much company time is spent on producing them.
About Payroll Items:
Payroll Item column allow you to select a Payroll Item {that also exists in the employee record} which determines how much the employee should be paid for doing the work that you selected in the Service Item column. This information will then flow through into employee paychecks and perhaps any invoices that you create that are based on billable time and costs.
What if the Payroll Item Column isn’t displayed?
When the Payroll Item column doesn’t appear in the Weekly Timesheet, for one or all employees, it usually means that the employee’s haven’t been setup to utilize timetracking, and you’ll need to check the setup in the employee record to be sure that the “Use time data to create paychecks” option has been checked and that Time tracking has been turned on in the Preferences.
We hope you’ve found this article to be helpful, if so please take a moment to leave a comment or to share it with others on your favorite social networking site using the buttons below.
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.
We are teaming up with the Associated General Contractors {AGC} of America San Diego Chapter, Inc. for a day of QuickBooks for Contractors on Tuesday November 8, 2011; 8:00 AM – 4:00 PM .
QuickBooks is the leading small-business accounting software on the market today. But when it comes to knowing how to use QuickBooks in the commercial/government construction industry and dealing with complexities such as AIA Billing and certified payroll reporting, finding help becomes difficult. Join us {Nancy Smyth – Sunburst Software Solutions, Inc.} as we team up with the Associated General Contractors {AGC} of America San Diego Chapter; for an intensive day-long training session for using QuickBooks in the commercial/government construction industry. Below are some of the highlights of the course.
Morning Session – Job Costing, Estimating, Purchases & AIA Billing using QuickBooks
- The importance of job costing
- Working with/setting up you QuickBooks Item List {aka your cost codes}
- Creating and using Estimates & Progress Invoices
- Tracking Committed costs and subcontracts with Purchase Orders
- Proper Vendor/Subcontractor invoice entry
- Getting Equipment costs into your job costing reports
- AIA Billing and automation
Afternoon Session – QuickBooks Payroll & Certified Payroll
- What is Certified Payroll? Who makes the rules and how to comply
- Working with Wage Determinations
- Determining employee labor burden – OR – the hourly cost of having employees on the jobsite
- How to include employee labor burden in payroll
- Setting up and using QuickBooks Payroll to deal with Prevailing Wages – regardless of how you pay your fringes
- How to fill out a certified payroll report – what information is needed
- Electronic certified payroll filing requirements
- Automating the certified payroll reporting process
Who should attend?
- Business owners
- Estimators
- Controllers
- CFO’s
- Payroll processors
- Office Managers
- Accounting & Consulting professionals
- Union and non-Union Contractors
This course will be held at:
AGC San Diego Chapter Inc., 6212 Ferris Square, San Diego, CA 92121
Phone: (858) 558-7444 Extension 101
When: Tuesday November 8, 2011
Time: 8:00 AM – 4:00 PM (8 hours)
Cost: $199 AGC Members OR $259 Non-Members
Register Online: https://www.agcsd.org/Calendar/Registration/registration.php?classType=educat&classID=1244
I look forward to seeing and meeting you all! Nancy Smyth, Sunburst Software Solutions, Inc.
