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:
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.
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!
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:
This is what the Excel worksheet would look like after enabling the columns:
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.
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.
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!
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?
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:
To rebuild data:
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.
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.
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:
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!
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.
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:
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.