Skip to main content
Important Announcements:
Please note: Our software products ONLY work with QuickBooks DESKTOP. NOT COMPATIBLE WITH QUICKBOOKS ONLINE or QUICKBOOKS MAC.

8/18/23 - The software that our website is built on underwent a major upgrade this week.  As with many upgrades, things break!  We're working diligently to correct the problems, but this is a HUGE website with almost 23 years of information.  We appreciate your patience.  

Folder Certified Payroll Solution How-To Support Videos

This section contains several short videos which cover our most frequent Support Calls.  All of the information in these videos also have written instruction in our printed and .pdf manuals as well as in the In-Program Help file (accessed from the big ? mark in the lower right corner of each window).

Topics covered include:  How to backup your data, How to restore your data, how to find your "lost" data, and more.

These videos have been created in an mp4 file format - which means they should run using whatever video software you have installed on your computer; heck they even work with the HP MediaSmart Video player on my laptop!


video How to Backup Your CPS Data Popular

By 8211 downloads

The information that you enter into CPS is not backed up when you back up your QuickBooks file and it requires it's own backup.

In less than 5 minutes we will walk you through the 4 steps that are necessary to set up the initial CPS backup routine, after that CPS will automatically back up your data every time you exit the program.

This simple procedure for creating a backup can save you a ton of time and effort if your computer crashes, is compromised by a virus or if you need to move CPS to a new computer.  Without a backup, you'll need to set everything up from scratch.

video How to Create an Electronic Certified Payroll Report File Popular

By 8663 downloads

More and more Federal, State, and even local agencies are requiring contractors to electronically upload their certified payroll data into on-line labor compliance programs.  The paper certified payroll reports, produced by Certified Payroll Solution, can be easily converted into an electronic file; compatible with the requirements of:

  • Texas Department of Transportation
  • Elation Systems - used by the Maine Department of Transportation and other agencies nationwide
  • TRS Consultants/Hill International - used by Wisconsin Department of Transportation, New York School Construction Authority, California Compliance Monitoring Unit (CMU) MyLCM and other agencies nationwide
  • LCPtracker used by various State of Colorado agencies, City of Chicago, and other agencies nationwide
  • Sandia National Laboratories in New Mexico
  • Alaska Department of Labor & Workforce Development
  • New York Department of Transportation
  • Wisconsin Department of Workforce Development

We've been providing a bridge between QuickBooks and these various on-line compliance programs since 2004.

video How to Network Certified Payroll Solution Popular

By 10003 downloads

Networking is the desire for 2 or more people to share or work with the same data/information.

With QuickBooks, you share a single data file (the .QBW file) between your computers.  With CPS you share a common folder.

Learn (and see for yourself in less than 7 1/2 minutes) how easy it really is to network the CPS data folder.

Note:  Written instructions are provided in the .pdf manual, printed manual and the in-program help, which is accessed from the CPS Help menu -> Contents -> Search -> Networking.

video How to Print Your Certified Payroll Reports to a PDF file Popular

By 6758 downloads

Printing and/or saving your Certified Payroll Reports to a .pdf file is an effective means of electronic storage and reduces the amount of "paper" work that you company needs to store in filing cabinets.  It is also an effective means of sending the reports via email.

One problem with this method though, is the inability to include a signature.  Make sure that you have some sort of written agreement for a "Signature on file" as technically certified payroll reports still require a "real" signature - not a graphic or stamped one.

video How to Restore Your CPS Data Popular

By 6555 downloads

Need to restore your Certified Payroll Solution (CPS) data, but aren't sure how to?

Maybe you aren't sure where your backups are located - learn how to use the "Search" function on your computer to locate your Cps Data *.zip file and restore it.

Restoring a backup is going to save you a ton of time if your computer crashed, was compromised by a virus or you are simply moving to a new computer.  Without having a backup to restore, you'll need to set everything up from scratch.

video How to Roll-Up/Combine Certified Payroll Reports Popular

By 10347 downloads

Job costing needs sometimes do not match the requirement of certified payroll report generation, for example:

You are awarded a job which involves work on several different buildings, for job costing purposes you've created a QuickBooks Job record for the entire project and then you created sub-jobs for each building - so you could generate accurate job costing reports.  However, the GC wants a single certified payroll report for the entire project.

This video will demonstrate 4 different options in which you can generate certified payroll reports:

  1. All jobs and sub-jobs are rolled up to the "Customer" level
  2. All sub-jobs, sub-sub-jobs, etc. are rolled up to the "job" level
  3. All jobs, sub-jobs, etc. are rolled up 1 level
  4. Customers, jobs, sub-jobs, sub-sub jobs, etc. are reported at the level they are entered in QuickBooks.

18 minutes.



video How to Save Your Certified Payroll Reports to Excel Popular

By 10885 downloads

Want/need to save your Certified Payroll Reports to Excel but don't know how?  This video will teach you how in just over 5 minutes and 4 easy steps!

The video also discusses some common reasons as to "why" you might want to save the to Excel.  If it's because you want to email them to someone, you might be better off printing them to a pdf file.

video How to Troubleshoot & Correct a Timecard/Paycheck Mismatch Error Popular

By 6607 downloads

A common error or message window that can appear when running your certified payroll reports is a Timecard/Paycheck mismatch.

A Timecard/Paycheck mismatch can occur:

  • If you delete/change a timecard entry when creating the actual paycheck
  • If the dates you entered are incorrect
  • If you have voided paychecks

This video will teach you how to troubleshoot and correct a Timecard/Paycheck mismatch.

video How to Troubleshoot When Deductions and/or Net Wages Are Incorrect on Your Final Reports Popular

By 6598 downloads

Troubleshooting why deductions and/or net wages are not correct on your final certified payroll reports can be a grueling task for us and for you - we have to ask you a LOT of questions because you have all the information right in front of you and we don't.

Most of the time, the problem is due to incorrect linking or assignments in the items that you'll find from the Linked Data menu -> Deductions.

This video will cover the most common (and a few not so common) reasons why these items aren't coming out correctly and how to fix them.