Skip to main content
Important Announcements:

Please note: Our software products ONLY work with QuickBooks DESKTOP. NOT COMPATIBLE WITH QUICKBOOKS ONLINE, QUICKBOOKS MAC, or RIGHT NETWORKS HOSTING.

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

Reconciliation Step 1 Errors

Last Updated: 08 February 2013
Share this!
Pin It

These errors could be encountered after you click the NEXT button on the Step 1 screen.

8, 9, 10, 11, 12, etc. is an unsupported version of QuickBooks.  Program Ending.

You have updated to a new version of QuickBooks without installing the "compatibility update" that we provided.  We do notify ALL current customers via email when such an update is available.  You may oftain this update from the Web Service Center, Which is accessed from the CPS Help menu, and choosing Check for Updates.

 

Invalid Pay Period Ending Date.

The pay period ending date must be in mm/dd/yy OR mm/dd/yyyy format.

 

Invalid Check From Date.

The Check From date must be in mm/dd/yy OR mm/dd/yyyy format.

 

Invalid Check To Date.

The Check To date must be in mm/dd/yy OR mm/dd/yyyy format.

 

The From Check data may NOT come after the To Check date.

The check date is wrong or you have entered it backwards.

 

While a check date range is valid, this means that you printed checks on more than one day for this work week.  This check date range MUST NOT overlap with other week's payroll checks.  Do NOT think of the check date range as the work week itself.  Do you wish to continue?

This error message will occur any time that the check date range is for more than one day.  The Pay Period Ending Date is the date of the LAST day of the work week.  The Check Date Range is the date range that the checks were issued for the pay period.

 

No Transactions found.  Check Date is wrong.

Paychecks shown in QuickBooks as Transactions were not found for the paycheck date range you provided.  Payroll checks must be issued and printed BEFORE certified payroll reports can be generated.  Make sure that paychecks have been created and printed, and that the check date range is correct, and then run the report again.

 

No Timecards found.

No timesheets were found for the week ending date that was entered.  Timesheets must be entered to draw the hours worked each day on to the final reports.  Timesheets found without a job will be ignored, and a warning will be presented.  If timesheets and paychecks have been created and printed, verify that you have CPS "pointed" to the correct QuickBooks file by going to the CPS System Setup menu -> choosing System Preferences -> click on the Data Locations tab.  Click into the second (2nd) box from the top (QuickBooks file) and delete the address of the file, click OK.  Make sure that QuickBooks is open with the company file containing the paychecks and run your reports again.

 

At least one timesheet is not assigned to a valid job.  The timesheet(s) will be ignored.

After processing the timesheets for a specific pay period, at least one entry was found for one or more employees, that do not have a job assigned. These timesheets will be ignored, and it is assumed that they do not pertain to certified payroll jobs.  To correct this, in QuickBooks, from the Reports menu -> choose Jobs, Time & Mileage -> Time by Job Detail Report, and set the dates to be the same as the work week you are generating reports for.  Unassigned items will be listed at the bottom of this report.  Correct items on BOTH the timesheet and the paycheck detail window.  If you frequently enter hours for employees who do not work in the field (such as, clerical staff) and wish to avoid this error, in QuickBooks create a customer record for your Company, and assign clerical hours to this customer record when creating timesheets.

 

Employees listed below have multiple rates for the same payroll item name in the QuickBooks Employee Record, Payroll & Compensation tab, Earnings section for the following employees.  The correct wage amount may not be shown on the report until this is corrected.  The program will proceed, though it may be wrong.  A list of Employees follows.

There is no doubt that a payroll wage item exists multiple times, with the same or different pay rates, in the QuickBooks Employee Record for the listed employees.  Because there are multiple entries for the same payroll wage item, with the same or different rates, CPS is not sure which one to choose.  In QuickBooks, find the employees listed, and be sure that each payroll item is listed only one time, with a rate of pay.