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.
Keeping track of bookkeeping/accounting tasks and the information that is required when you hire a new employee can be pretty overwhelming for a business owner or bookkeeper. In the normal rush of day-to-day activities; sometimes important items can get overlooked and come back to bite you later.
Welcome to Tuesday Training!
Tuesday Training is a new feature here on the QuickBooks for Contractors blog. While everyday focuses on training of one sort or another, Tuesday’s are dedicated to more in-depth training.
We’ll teach you the things you need to know about using QuickBooks, that you won’t find in the QuickBooks Help file, in order to successfully run your construction business and obtain accurate job costing reports; from eBooks, live webinars, and recorded training sessions.
You’ll find high-quality (budget friendly) training without having to leave the comfort of your home or office.
Bookkeeping & Accounting Tasks
We’ve compiled a list of daily, weekly, monthly, quarterly, and annual bookkeeping and accounting tasks to help you stay on track – this is also a handy checklist to provide to a new bookkeeper.
This list is geared for contractors and include items such as certified payroll reports, AIA billing draws, Worker’s Comp, and General Liability Insurance tracking reminders.
Excel format, so you can easily add other items and customize it to meet the needs of your business.
We hope that you’ve found today’s Tuesday Training items to be helpful to your business – if so please take a moment to leave a comment or share this with others on your favorite social media network using the buttons below
Download your free copy of our Bookkeeping and Accounting Tasks checklist here.
Employee New Hire Packet
What should a “New Hire Packet” contain? Federal W-4, State W-4, and Form I-9 at a minimum – but that really isn’t enough information to keep on file. You, as well as your bookkeeper needs to have more information about a new employee than what is available on these forms. Utilize our New Hire Checklist” to provide your bookkeeper with additional information about the employee.
Word format, so you can easily add additional information and customize it to suit the needs of your business.
Download your free copy of our Employee New Hire Packet by clicking here.
We hope that you’ve found today’s Tuesday Training items to be helpful to your business – if so please take a moment to leave a comment or share this with others on your favorite social media network using the buttons below.
Working with taxable and non-taxable items and customers in QuickBooks sometimes just freaks people out and causes them to over think the entire situation. I’m frequently asked how to do this by people who are setting up our AIA billing program – here’s a question that I received recently.
I am getting ready to set the AIA billing program {Construction Application for Payment Solution} up tomorrow and just have a few questions.
Should the income items each be posted to an income general ledger account? Or will I use the subtotal line to point to an income account? If I have to post each income item to an income account – I will have to do 2 sets of them, one for wholesale (no tax) and one for retail (taxable) and I would like to avoid this if possible. I guess though we will have to post them to an income account…..thoughts?
Should we use the group items to setup our labor and materials for the schedule of values? For example, when we bill the customer- we only want DEMOLITION to show up, but for our purposes we have the DEMOLITION broken into labor and material. It seems like this would be a good place to use group items?
Each of your QuickBooks Items/Cost Codes should be set up and linked to BOTH and Income and an Expense/Cost of Goods Sold Account otherwise you’ll never get any decent job costing reports.
Subtotal Items do not link to either an Income or an Expense Account – they simply add up the numbers above it and display the amount on the Estimate and Progress Invoices that you create.
Unless you want to track Wholesale and Retail Income individually on your Profit & Loss Report, there is no need to create two sets of Items. QuickBooks can handle both taxable and non-taxable customers and sales using the same item list. You’ll just want to make sure that you have two Sales Tax Items – one that actually charges the Sales Tax Rate and one that has a 0% rate for Non-taxable sales.
Below is a YouTube video that demonstrates the procedure and shows you what your Sales Tax Liability Report will look like if you do it correctly.
As for using group items to track labor and materials for a specific cost code, there are a couple of different options that you could use, depending upon the amount of detail that you want to track. But group items are definitely the way to go if you want to job cost more information than you want the customer to see.
I hope you’ve found this article to be informative, if so please take a moment to leave a comment or share it with others on your favorite social media network using the buttons below.
Top 10 Thursday features 10 of the most interesting articles that I found the previous week. There is so much news and information available on the web – it’s difficult to read everything and stay up to date. As I read articles on the web – I’ll share some that I feel are important.
General Business:
- Guarding Against Fraud: How to Protect Your Organization
- Business-driving technology worth considering in 2012
Bookkeeping, Accounting, Payroll & Taxes:
- Committee to start work on payroll-tax cut in mid-January
- Taxpayers Warned of Changes for Tax Season
Construction:
- Top 10 transportation issues for 2012, including texting and cell phone usage while driving
- Indian considers right-to-work legislation
- Understanding General Liability Insurance for Contractors
- The Science of Bidding
- New York state plans to invest $15B in infrastructure improvements
Marketing & Social Media:
Well, there’s our Top 10 most interesting articles for last week – do you have some interesting news that you’d like to share?
So how do you find a “good” bookkeeper and test their knowledge before hiring them? Or, perhaps you are ready to hire a CPA to help you with your business and your books. Congratulations! We all know what a struggle it is to “try to do everything” yourself, and it almost goes without saying that as a busy contractor, we also know that time is best spent on the job and not in the office handling paperwork.
Welcome to Tuesday Training!
Tuesday Training is a new feature here on the QuickBooks for Contractors blog. While everyday focuses on training of one sort or another, Tuesday’s are dedicated to more in-depth training.
We’ll teach you the things you need to know about using QuickBooks, that you won’t find in the QuickBooks Help file, in order to successfully run your construction business and obtain accurate job costing reports; from eBooks, live webinars, and recorded training sessions.
You’ll find high-quality (budget friendly) training without having to leave the comfort of your home or office.
Construction Bookkeeper Test – $25.00
So how do you find a “good” bookkeeper and test their knowledge before hiring them? Well, we have scoured the internet searching for a “good” QuickBooks and Construction Bookkeeping Test, and while we have found some that would test an applicant’s basic knowledge of QuickBooks as well as some basic accounting knowledge, none have addressed any construction related functions. Being disappointed in what we have found, we’ve designed our own – somewhat based on issues that we deal with on a day to day basis supporting our own software which integrates with QuickBooks – and we are happy to offer you a copy {complete with the answers}.
Our Bookkeepers test asks applicants to answer a total of 145 questions, covering 5 different areas of knowledge.
Purchase your copy today for $25.00.
Hiring a Bookkeeper or CPA
We all know what a struggle it is to “try to do everything” yourself, and it almost goes without saying that as a busy contractor, we also know that time is best spent on the job and not in the office handling paperwork.
Before you hire someone to handle your books or your taxes, check their skills and lay the ground rules to make sure that you are getting the right person for your business and never make the big mistake of just “turning” it all over to someone (no matter how enticing that idea may be). Always keep an eye on what is going on.
FREE eBook – click here to download.
Additional Resources from the IRS
Even the IRS feels that this is an important subject, and the IRS urges you to choose that preparer wisely. Most return preparers are professional, honest and provide excellent service to their clients. But it is the taxpayer who is legally responsible for what’s on his or her tax return even if it is prepared by someone else.
We hope that you’ve found today’s Tuesday Training items to be helpful to your business – if so please take a moment to leave a comment or share this with others on your favorite social media network using the buttons below.
