by Sunburst Software Solutions, Inc.
Archives by Month

Are Your QuickBooks Payroll & Certified Payroll Processes Efficient?

Print Friendly, PDF & Email

QuickBooks Payroll and Certified Payroll processes really need to be efficient in order for a business to be successful.  When one of your businesses largest job expenses is payroll, you need to:

  • pay your employees correctly and on time to keep them happy,
  • make sure that those payroll costs are part of your accounting system so those costs are included in job costing reports,
  • and you need to submit your certified payroll reports accurately and in a timely fashion in order to be paid.

Yes, it’s a vicious cycle!

Ask any business owner how efficient he thinks his payroll and certified payroll processes are and I’m betting he’ll either say “oh they are very efficient” or “they could be better”.  Ask his payroll clerk who is dealing with a lot of manual data entry and I bet that she’ll have a far different answer!

I attended a really great webinar a couple of weeks ago, called “A Tale of Two Payroll Processes” – given by CPA Practice Advisor and TSheets and I have to admit I was pretty surprised by one of the slides in the presentation – Processing Payroll: Industry Snapshot (shown below).

Right click to enlarge image.

Right click to enlarge image.

When I first looked at this slide, I thought “awesome” 64% of small businesses process payroll in-house.

But then I looked more closely:

  • 62% use a spreadsheet, and
  • 66% do not have a payroll system that is tied to their accounting software!

manual payroll processesEgads!  Immediately I was mentally transported back about 15 years in time – when QuickBooks desktop payroll was not as robust as it is today and there were no third-party add-on available to automate critical tasks, like preparing certified payroll reports – and I was doing a LOT of payroll and certified payroll tasks manually using complex Excel spreadsheets.  As a bookkeeper, I hated my job – I spent 40+ hours every week doing nothing but entering the same employee time and payroll data in multiple places – over and over again in multiple Excel spreadsheets as well as in QuickBooks to cut paychecks!  If you were to have asked my boss at the time if the processes were efficient – he would have told you yes – because I was using Excel to automate the process instead of having to hand write all of the data!

For some businesses using a spreadsheet or having a payroll system that isn’t tied to their accounting software might be ok – at first glance. If you are a contractor or any type of business that needs to track employee time against specific customers or jobs and tasks or cost codes – then using a spreadsheet or a payroll system that isn’t tied to your accounting software isn’t efficient at all.

Payroll is a HUGE part of the cost of running a business and for many business type’s payroll is one of the largest portions of the cost of doing a job.

I know that many business owners who use QuickBooks will often use an outside payroll service to handle payroll – my question are:

  • • if you need job costing how are you getting those payroll costs into QuickBooks
  • • how are your certified payroll reports being created
  • • And then how efficient are the processes?

Payroll that is not tied to or part of your accounting system and certified payroll reports that are issued manually using complex Excel spreadsheets or fillable forms are time-consuming, tedious, error-prone and above all else disconnected from the rest of your financial data. This makes it difficult to obtain accurate and error-free financial information, because you are always having to enter the same information in multiple places.

If this sounds familiar and you would like to learn how to automate your payroll and certified payroll processes – join me tonight from 5-6 EST on Google+ for a 1 hour hangout called the Tale of Two Certified Payroll Processes, where we’ll compare the manual vs. the automated processes of entering employee time, generating paychecks, and finally creating certified payroll reports, EEOC and union dues and fringe benefit reports.  Can’t make the live hangout – that’s ok, it will be recorded and I’ll post the link so you can watch it on YouTube.

Below is the recording on YouTube of the hangout, it was a lot of fun!




9 Responses to Are Your QuickBooks Payroll & Certified Payroll Processes Efficient?

    About Your Host:

    Nancy Smyth, Certified QuickBooks ProAdvisor

    Nancy Smyth, Sunburst Software Solutions, Inc.
    QuickBooks Construction & Payroll Expert

    I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

    QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

    Top QuickBooks blogs to read in 2018
    We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
    Stay updated!

    Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

    Enter your email address:

    Delivered by FeedBurner

    We promise NOT to sell, rent, or otherwise distribute your name and email address!

    FREE 30-Day Trials

    Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

    Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

    Certified Payroll Training:
    Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

    certified payroll requirements webinar
    QuickBooks Training

    Frustrated with QuickBooks?

    QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

    QuickBooks Time Tracking

    Save 10%/FREE 14-day trial!

    QuickBooks Time Tracker