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:
- Go to the Reports menu.
- Select Employees & Payroll, then Employee Contact List.
- Click the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
- If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
- 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 81.PNG](https://quickbooks.intuit.com/learn-support/image/serverpage/image-id/92012iE0D7B5BB2CA9E765/image-size/large?v=v2&px=999)
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!