cancel
Showing results for 
Search instead for 
Did you mean: 
TheCornMan
Level 1

Certified Payroll Report

Hello All,

I work for a contractor here in California that performs primarily government works. Our quickbooks is desktop 2021. I need to do Certified Payroll Reports (CRP) to submit to the government every week, and have to change the format of my reports for a new submission agency. 

 

My question is: HOW can I add my employee's addresses and SSID's to the CRP? My current way of preparing a report is: Reports -> Employees & Payroll -> More Payroll Reports in Excel -> Certified Payroll Report

Thanks!

1 Comment 1
Rea_M
Moderator

Certified Payroll Report

Hello, TheCornMan.

 

You can export the Employee Contact List report and manually add employees' addresses and SSIDs to the Certified Payroll Report. Let me guide you on how to do this below.

 

Certified payroll reports must include a listing of the workers on the project, including work classifications, hours worked, wage rates, benefits, overtime compensation, total wages paid, and information related to payroll deductions. To get the data of your employees' addresses and SSIDs, you can export the Employee Contact List report. Here's how:

 

  1. Go to the Reports menu.
  2. Select Employees & Payroll, then Employee Contact List.
  3. Click the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
  4. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
  5. When you’re ready to export, select OK.

 

Once you're done, get the employees' addresses and SSIDs and manually add them to your Certified Payroll Report. Please see the screenshot below for your reference.

 

81.PNG

 

To further guide you in generating Excel-based payroll reports, please see the Generate Excel-based payroll reports section in this article: Export reports as Excel workbooks in QuickBooks Desktop.

 

Additionally, once you're ready to submit your Certified Payroll Report to the government, you may want to look into this page to do so: California Department of Industrial Relations.

 

Should you need anything else or you have other payroll concerns, let me know. I’m more than happy to help. Wishing you the best!

Need to get in touch?

Contact us