by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Payroll Record Keeping Tips-How To Stay Organized

Print Friendly, PDF & Email

QuickBooks does a great job at allowing you to track employee time to specific jobs, issue payroll and even produce your quarterly and year-end payroll tax forms and W-2’s.  But the data that is stored in QuickBooks only provides pieces of the information that you need to keep on file to comply with the Fair Labor Standards Act.

Payroll Record Keeping Requirements overflowingIn Tuesday’s article, Payroll Recordkeeping – More Than Just Getting Employee’s Paid on Time, we mentioned that in order to be well prepared for a Wage & Hour audit that you need to keep your payroll records for the duration of EACH worker’s employment with your company PLUS 5 to 10 years!  Most Human Resources and legal experts are suggesting this to ensure these records are available in the event a claim is filed, according to a recent article I read published by Personnel Policy Service, Inc. in their HR Matters E-Tips newsletter.  

From a previous post, Fair Labor Standards Act – Employee Record Keeping Requirements, we learned that the following is a listing of the basic records that an employer must maintain in order to comply with the Fair Labor Standards Act:

  1. Employee’s full name and social security number.
  2. Address, including zip code.
  3. Birth date, if younger than 19.
  4. Sex and occupation.
  5. Time and day of week when employee’s workweek begins.
  6. Hours worked each day.
  7. Total hours worked each workweek.
  8. Basis on which employee’s wages are paid (e.g., “$9 per hour”, “$440 a week”, “piecework”)
  9. Regular hourly pay rate.
  10. Total daily or weekly straight-time earnings.
  11. Total overtime earnings for the workweek.
  12. All additions to or deductions from the employee’s wages.
  13. Total wages paid each pay period.
  14. Date of payment and the pay period covered by the payment.

Now, most of this information is held in your QuickBooks file and can easily be obtained – BUT – after 5 or 10 years how many of you will still be working in the same QuickBooks company data file that you started in (now) 2003?  Not only that – how many of you will have all of the hard copy paper documentation that was used to generate payroll from 10 years ago!  Unless you have a room (or two) full of metal file cabinets to store this data – you could be in for trouble in the event of a Wage & Hour Audit.  Telling an auditor – oh, we started a new QuickBooks file in 2010 and I don’t know what happened to the original one is not going to make the audit process any smoother or easier!

Organizing & Storing your Payroll Record Keeping Information:

Perhaps the most efficient means of storing payroll record keeping information is done through the use of your computer and storing all the backup documentation in pdf or Excel format.  This eliminates the need for a room or two full of metal file cabinets.  As a business owner you can limit employee access to that folder BUT you absolutely MUST have a backup plan in place to make sure that the information is safe!

Back when I was an active bookkeeper, I created a main folder on my computer called “Clients”, within that folder each client had their own folder, within each client folder there were folders for each year, within each year there were folders for each quarter, and within each quarter their was a folder for each month.  Everything was stored by month.  I’ve carried that practice over into our own business.

So let’s get creative, get yourself organized, and be in compliance!  Remember you need the last 5 to 10 years of information

  • Get a scanner if you don’t currently have one
  • Download a free pdf creator – I’ve used CutePDF
  • Create a folder on your computer or your server – name the folder “Your Company Name”
  • Start scanning and organizing your information.


Other articles about the Fair Labor Standards Act:

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