Use the Certified Payroll Data Export screen to create a report of certified payroll that is designed to be saved to Microsoft Excel for use in electronic submittal. Because this report is meant to be saved to Microsoft Excel, it has limited formatting and will not fit on letter- or legal-sized paper when you print it. You can save this report.

There are two default formats you can use to generate the report: Certified Payroll Data Export and Certified Payroll Data Export (3rd Party). If you are using a supported third party reporting application to validate certified payroll and file electronically, use the Certified Payroll Data Export (3rd Party) format. This format is compatible with LCPtracker Pro and LCPcertified and contains columns for all required certified payroll reporting categories by default. Alternatively, when you use the Certified Payroll Data Export format, the certified payroll reporting categories do not appear on the report unless you add them using the Modify Reports screen to customize the report.

If the Print Certified Payroll Reports checkbox is selected in the Project screen and there are hours for the reporting period, ProContractor will create the certified payroll report. If the Print Certified Payroll Reports checkbox is selected in the Project screen and there are no hours for the reporting period, ProContractor will not create the report.

You can control the output of the Certified Payroll Data Export report by entering details in one or more of the following fields on the Options tab:

• Select Format - Select Certified Payroll Data Export to create the standard certified payroll data export. Select Certified Payroll Data Export (3rd Party) to create the export for a third party reporting application. If you have modified the format and layout of any of these reports on the Modify Reports screen, click to select the format of the report you want to use.

• Company - Click to select one or more companies for the report. If no companies are selected, all companies appear in the report.

Project - Click to select one or more projects for the report. If no projects are selected, all projects appear in the report.

• Report End Date - Enter the end date for the report, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. The report will show a total of seven days including the report end date. This field is required.

• Certified Payroll Category 1 - Click to select the first certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 2 - Click to select the second certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 3 - Click to select the third certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 4 - Click to select the fourth certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 5 - Click to select the fifth certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 6 - Click to select the sixth certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 7 - Click to select the seventh certified payroll category you want to show in the report. If you are using the Certified Payroll Data Export format or a modified version of this format, the report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 8 - Click to select the eighth certified payroll category you want to show in the report. The report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 9 - Click to select the ninth certified payroll category you want to show in the report. The report must be modified to include the category; otherwise, the category does not appear in the report.

• Certified Payroll Category 10 - Click to select the tenth certified payroll category you want to show in the report. The report must be modified to include the category; otherwise, the category does not appear in the report.

You may need to add User-Defined Fields screen to the Project screen records and Employee screen records to meet the requirements of the state.

For information on running the Certified Payroll Data Export report, see Run and Print Reports.

For information on running the Certified Payroll Data Export (3rd Party) report, see Exporting Certified Payroll Data for Use in a Third Party Application.