cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

Certified Payrolls older than 90 Days

Does anyone know a way to run older certified payroll reports?  QB is only showing me pay dates in the past 90 days. 

Solved
Best answer May 22, 2020

Best Answers
Highlighted
Community Champion

Certified Payrolls older than 90 Days

When creating the report, above the date field it says "pick or enter a date".

 

So, if you can't pick the date because it is too old, enter the date.

View solution in original post

16 Comments
Highlighted
Community Champion

Certified Payrolls older than 90 Days

When creating the report, above the date field it says "pick or enter a date".

 

So, if you can't pick the date because it is too old, enter the date.

View solution in original post

Highlighted
Level 3

Certified Payrolls older than 90 Days

Thanks, that is helpful.  Do you happen to know the simplest way to get a listing of the dates we had payroll on a particular project going back a couple of years?

Highlighted
QuickBooks Team

Certified Payrolls older than 90 Days

Good day, @CCNCem.

 

You can run the Summarize Payroll Data in Excel workbook and filter the dates and project in the Pivot Tables in Excel. This way, it will show the list of dates for a particular project from previous years. Let me show you how:

 

  1. Go to the Reports menu and choose Employees & Payroll.
  2. Click Summarize Payroll Data in Excel.
  3. QuickBooks Payroll Reports Workbook window will open.
  4. Select the Dates to This Year and click Get QuickBooks Data. An Excel Worksheet will open.
  5. Go to the Rates and Hours by Job tab.
  6. Click Customer: Job option
  7. On the Choose field to add to the report, make sure to toggle the check mark of Customer: Job and Date option.

I've added these resources that can help you about running reports in QuickBooks Desktop:

 

Let me know if you have any other questions. I'm always here to help. Take good care.

Highlighted
Level 3

Certified Payrolls older than 90 Days

Thank you, I will give that a go when I get back to work on Tuesday :-)

Highlighted
Community Champion

Certified Payrolls older than 90 Days

Yes, in the Payroll center you can see your paychecks and their dates on the Transactions tab.

Highlighted
Level 3

Certified Payrolls older than 90 Days

I'm finally finding the time to get back at this project...

 

I have gotten as far as finding the "Rates and Hours by Job" tab and filtered the Customer:Job to the the project that I need dates for.  However, the date option only seems to drill down to the level of month.  I can't seem to get a list of actual pay dates for this job which is what I need to type in manually to get each certified payroll report.

 

Please let me know if I'm missing something.  I appreciate your help!

Highlighted
Level 3

Certified Payrolls older than 90 Days

Thanks but there doesn't seem to be any way to filter for specific project which is what I need - all of the dates that I paid employees on a specific job from 2018 to 2020.

Highlighted
QuickBooks Team

Certified Payrolls older than 90 Days

Hello, CCNCem.

 

We're glad to see you here again! I'll chime in this thread to help you get the actual pay dates for the jobs and help you filter the report. 

 

Aside from adding the Date column, you can also add Paid Through to show the actual pay dates for the job. Here's how: 

 

  1. Go to the Rates & Hours by Job worksheet tab again.
  2. Click the table (anywhere within it). 
  3. The Pivot Table Fields sidebar will appear. Ensure that the Date and the Paid Through columns are checked.
  4. The data will appear with small plus or minus icons. Simply click on them to expand the data.
  5. You can move the columns to make the view easier. 

This is what the Excel worksheet would look like after enabling the columns: 

 

PaidThrough1.PNG

 

Also, let's make sure you've selected a specific project under on the "Customer:job" field. This can help you filter out the projects you don't want to show. 

 

PaidThrough3.PNG

 

You can play around the pivot table fields to get other data you might need for your certified payroll report. 

 

If you need other payroll data, there are a number of payroll reports you can pull up. I'd recommend checking out our Payroll Reports articles for a guide. 

 

You can also browse other payroll-related articles if you need more help. Simply click here and ensure QuickBooks Desktop Payroll is set as the topic. Click the + More topics button to expand the view. 

 

If you have follow-up concerns about the report, please let us know. We also welcome other questions for QuickBooks Desktop. 

Highlighted
Level 3

Certified Payrolls older than 90 Days

Thank you :-)

 

I actually found a really simple solution just a little while ago and hadn't got back here to update yet.

 

I ran a detailed job profit report, drilled down to just show the labor. 

 

To make it even simpler to work with, I downloaded that into Excel, then used Data/Data Tools/Remove Duplicates to remove all but the first line for each date.

 

I'm left with a simple list of dates that I had payroll on this project!

Highlighted
Level 1

Certified Payrolls older than 90 Days

I have the same issue.  However, when I manually enter a date older than 90 days, it says there is no data.  I have ran a report showing the time I have for this certain job and it shows up in the report.  Not sure why it won't pull up the data? 

Highlighted
QuickBooks Team

Certified Payrolls older than 90 Days

Hi, SharpErectors.

 

You'll want to follow the suggestion provided by @CCNCem. However, if you're still unable to run the report, you can run the Verify and Rebuild Data Tool in QuickBooks Desktop to identify and resolve any data integrity issues. Let me guide you with the steps.

 

To verify data: 

  1. Choose Window then Close All.
  2. Verify Data. Choose File then Utilities. Select Verify Data.

To rebuild data: 

  1. Select where you want to save your backup, then select OK at the bottom of the QuickBooks Desktop Backup window.
  2. The Rebuild Data utility starts as soon as the backup is finished.
  3. Click OK when you get the message "Rebuild has completed".

Please check this article for the complete steps: Verify And Rebuild In QuickBooks.

 

Feel free to visit these articles for more information: Account Management.

 

If there's anything else you want us to help with, please let us know so we can get back to you.

Highlighted
Level 1

Certified Payrolls older than 90 Days

Thank you for the advice.  I verified the data and it came up with no problems.  I also ran the repair data tool and it also said no problems.  I tried to pull up the certified payroll again and it gave me the same error..."No data found!  Nonpayroll transactions were found for this date.  Do you want to continue and create en empty report?"

 

I use the weekly time sheets and looked back at those and the data is there.  I also looked afnpaycheck stubs from the weeks I need the report fir and the time is on the pay stubs. When I run and time by job report, the hours show up there as well and give me the dates the employees were on this particular job.  Not sure why the data will not pull up for the certified payroll reports.  The time starts pay period ending 7/30/2019 and ends on 1/07/20.  

Highlighted
Moderator

Certified Payrolls older than 90 Days

Thanks for sharing an update about this Certified Payroll concern, @SharpErectors,

 

It looks like you've already tried all possible solutions without a positive result. To sort this out, I highly recommend reaching out to our Technical Team. They can run some diagnostics on the company file to identify underlying issues with the report path.

 

Here's how to contact support:

 

  1. Go to your QuickBooks Home page, then click the Help menu at the top.
  2. Choose QuickBooks Desktop Help from the drop-down.
  3. Hit the Contact us icon.

 

Let me know how the call goes by adding a comment below. I want to make sure you're all set, and I'm here if you need further guidance. Have a great day!

Highlighted
Level 1

Certified Payrolls older than 90 Days

I tried entering a different date, but when it runs it I received the message that no payroll information was found. It is possible to find another way of doing it. I need to run reports back from 2018, and 2019.

 

Thanks, 

Highlighted
QuickBooks Team

Certified Payrolls older than 90 Days

Hi there, BeardElectric.

 

The Certified Payroll report will only show the last 90 days of payroll records in your company. If you need to view the older data, we'll have to manually enter the exact date of your paycheck. I'll show you how:

 

  1. Select Reports reports from the top menu bar.
  2. Choose Employees & Payroll.
  3. Go to More Payroll Reports in Excel, then choose Certified Payroll Report.
  4. Follow the on-screen instructions to create the report.
  5. From the QuickBooks Certified Payroll Report window, enter the appropriate paycheck date.

If the same thing happens, we can use the Verify and Rebuild features to fix discrepancies on reports and data integrity issues. You may follow the steps provided by my colleague, MariaSoledadG.

 

In case you'll need to track where your business stands in terms of employee expenses, we can customize the payroll reports.

 

Feel comfortable to leave a reply below if you have any other concerns or questions. I'll be around to help.

Highlighted
Level 3

Certified Payrolls older than 90 Days

I was going to say the same thing - first run the report to find the dates of all paychecks (not the payroll period or dates worked but paycheck dates). 

 

By the way, if you run payroll on Thursday, then void a check on Friday and run a new corrected paycheck, you will have to run reports for both of those dates.  This is extremely stupid and your customers will not understand why they are getting multiple reports for the same pay period but it is what it is.

Need to get in touch?

Contact us