Are Your QuickBooks Payroll & Certified Payroll Processes Efficient?
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).
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!
Egads! 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?
Leave a Reply
- The Great Debate – QuickBooks Desktop vs. QuickBooks Online
- Using Account Numbers in Your QuickBooks Chart of Accounts
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks Tip - Child Support Garnishments
- How To Turn On and Use Manual Payroll in QuickBooks
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- QuickBooks Tip: Important Facts About Items Left as Billable
- Welcome to the QuickBooks for contractors blog
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks Tip - Handling Retainage
- QuickBooks 2015 Announced - Important System Requirements
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- How to Calculate & Display Retainage on an AIA G-702/G-703
- Tips for Effectively Using QuickBooks Purchase Orders