{"id":1149,"date":"2023-12-15T07:50:37","date_gmt":"2023-12-15T07:50:37","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=1149"},"modified":"2025-04-15T05:44:05","modified_gmt":"2025-04-15T05:44:05","slug":"certified-payroll-w-347-report","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/enterprise\/advanced-job-payroll\/certified-payroll-w-347-report\/","title":{"rendered":"Ch 02 – Certified Payroll W-347 Report"},"content":{"rendered":"

Contents<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
INTRODUCTION<\/a><\/td>\n<\/tr>\n
SETUPS<\/a><\/td>\n<\/tr>\n
1. User Setup<\/a><\/td>\n<\/tr>\n
2. Human Resource Setup<\/a><\/td>\n<\/tr>\n
3. Company Information Setup<\/a><\/td>\n<\/tr>\n
EMPLOYEE<\/a><\/td>\n<\/tr>\n
CREATING SKILL CLASS CODE<\/a><\/td>\n<\/tr>\n
PAYROLL REGISTER LEDGER ENTRIES<\/a><\/td>\n<\/tr>\n
IMPORTING\/EXPORTING THE DATA IN THE PAYROLL REGISTER LEDGER ENTRIES<\/a><\/td>\n<\/tr>\n
1. Manual Entry<\/a><\/td>\n<\/tr>\n
2. Import from Excel and Export to Excel<\/a><\/td>\n<\/tr>\n
3. Export to Excel Template<\/a><\/td>\n<\/tr>\n
CERTIFIED PAYROLL WH-347 REPORT<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

INTRODUCTION<\/b><\/p>\n

If any business works on federally funded projects as a contractor or a subcontractor, you\u2019re required to submit a weekly payroll report. You submit this report, also known as Certified Payroll Report, to the U.S. Department of Labor.<\/p>\n

Certified Payroll is a federal payroll report. Government contractors submit Federal Form WH-347 weekly to the agency overseeing the government contract. The form lists every employee, their wages, their benefits, the type of work they did, and the hours they worked. It also shows withholdings and gross wages and includes a statement of compliance.<\/p>\n

SETUPS<\/b><\/p>\n

1. User Setup<\/b><\/p>\n

To use this functionality user must be permitted with the permission \u201cAllow CPR Functionality\u201d on the User Setup page.<\/p>\n

\"null\"<\/p>\n

2. Human Resource Setup<\/b><\/p>\n

On Human Resource Setup page user need to set up some of the fields under \u201cProjectPro \u2013 Certified Payroll\u201d fast tab as below:<\/p>\n

\"null\"<\/p>\n

    \n
  • Payroll Week Ending Date – <\/b>The is mentioned in the Payroll Register Ledger Entry page, which means this date would be the ending date of the week for which we are preparing the data and the same is also necessary to run the report since it is required to mention the \u201cPeriod End Date\u201d on the request page of the report.<\/li>\n
  • WH 347 Signatory Party – <\/b>This mandatory field defines the \u201cName of the Signatory Party\u201d on the report.<\/li>\n
  • WH 347 Title – <\/b>Mention the Title of the signatory party here, which will be printed on the report.<\/li>\n
  • WH 347 Contractor Name – <\/b>Mention the Contractor Name of the contract to be printed on the report.<\/li>\n
  • WH 347 Address 1 – <\/b>The Address mentioned in this field will be the Address of the Contractor on the report.<\/li>\n
  • WH 347 Address 2 – <\/b>This is the long address of the contractor in continuation with the Address 1 field.<\/li>\n
  • OMB No. – <\/b>OMB stands for \u201cOffice of Management and Budget\u201d. An OMB No. is assigned with an expiration date to each government form.<\/li>\n
  • Expires – <\/b>This is the Expiry date for OMB No. allotted by the government.<\/li>\n
  • Company ID – <\/b>Mention the Company ID for the company which will be printed on the report against each employee working.<\/li>\n
  • Picture – <\/b>This is the logo of the Contractor company which will be printed on the report.<\/li>\n<\/ul>\n

    3. Company Information Setup<\/b><\/p>\n

    On the Company Information page, the details of the Company need to be mentioned like.<\/p>\n

      \n
    • Name of the Company<\/b><\/li>\n
    • Address of the Company<\/b><\/li>\n
    • City<\/b><\/li>\n
    • Zip Code<\/b><\/li>\n
    • Country\/Region Code<\/b><\/li>\n<\/ul>\n

      This information will be printed on the report which will tell the company\u2019s information.<\/p>\n

      EMPLOYEE<\/b><\/p>\n

      We need to create the employees in our System so that the Employees who are working and mentioned in the \u201cPayroll Register Ledger Entry\u201d page will be matched to each other and the data for them could be filled. To create the Employees user need to search Employee in the global search and click on the result.<\/p>\n

      \"null\"<\/p>\n

      Once we click on the Employees the Employee List page will open here, we need to click on the \u201cNew\u201d button.<\/p>\n

      \"null\"<\/p>\n

      When we click on New the Employee card will get opened and here, we need to fill in the basic details of the employee like Employee No., First Name, Middle Name, Last Name, etc. we are filling in just some of the details Employee card users can fill in as per their requirements.<\/p>\n

      Note:<\/b> The user needs to keep in mind that Employee No. and Employee Name must be the same as we are mentioning in the \u201cPayroll Register Ledger Entry\u201d page small difference will create errors while importing and exporting the data in the ledger entry page.<\/i><\/p>\n

      CREATING SKILL CLASS CODE<\/b><\/p>\n

      As we noticed that in Payroll Register Ledger Entry page there is a field \u201cSkill Class\u201d which denotes the skill of an individual employee.<\/p>\n

      To create the Skill Class user need to search the word \u201cSkill Class\u201d in Global Search and click on the result.<\/p>\n

      \"null\"<\/p>\n

      Once the user clicks on Skill Classes the list page will open and the user needs to click on \u201cNew\u201d. Fill in the \u201cCode\u201d field and \u201cDescription\u201d field and click OK.<\/p>\n

      \"null\"<\/p>\n

      Note:<\/b> The user needs to keep in mind that the \u201cSkill Class\u201d must be the same as we are mentioning in the Payroll Register Ledger Entry page, small difference will create errors while importing and exporting the data in the ledger entry page.<\/i><\/p>\n

      PAYROLL REGISTER LEDGER ENTRIES<\/b><\/p>\n

      To open the \u201cPayroll Register Ledger Entries\u201d page, user need to click on \u201cPayroll Interface \u2192 Payroll Register Ledger Entries\u201d on the ProjectPro Manager Role Centre.<\/p>\n

      \"null\"<\/p>\n

      Once we click on the same, then the \u201cPayroll Register Ledger Entries\u201d page will open.<\/p>\n

      \"null\"<\/p>\n

      \"null\"<\/p>\n

      In the above screenshots, a sample data has been created for 4 different Employees.<\/p>\n

      IMPORTING\/EXPORTING THE DATA IN THE PAYROLL REGISTER LEDGER ENTRIES<\/b><\/p>\n

      The data in the \u201cPayroll Register Ledger Entries\u201d page can be created both manually and by importing the data in an Excel file. Similarly, data can also be exported to an Excel file.<\/p>\n

      1. Manual Entry<\/b><\/p>\n

      Users can create the data manually by clicking either \u201cNew\u201d or \u201cEdit List\u201d option on the ribbon and filling in the details manually in the \u201cPayroll Register Ledger Entries\u201d page lines.<\/p>\n

      2. Import from Excel and Export to Excel<\/b><\/p>\n

      To enter bulk data employees, user can use \u201cImport from Excel\u201d function.<\/p>\n

      To review and make editions to the data, users can use \u201cExport to Excel Function\u201d as well. Once the data is reviewed, edited, or added new entries into the existing one, user can import the file again into the system using the Import function.<\/p>\n

      \"null\"<\/p>\n

      3. Export to Excel Template<\/b><\/p>\n

      In case, user do not have a template available to them, they can use the \u201cExport to Excel Template\u201d function. This will export a blank template in Excel format where they can add data and import the same by the import function.<\/p>\n

      \"null\"<\/p>\n

      Once the user clicks on the \u201cExport to Excel Template\u201d button the data which is already available on the \u201cPayroll Register Ledger Entry\u201d page will also get downloaded in Excel format and can add more data to it easily, if required.<\/p>\n

      \"null\"<\/p>\n

      CERTIFIED PAYROLL WH-347 REPORT<\/b><\/p>\n

      Click on the \u201cCertified Payroll WH-347 Report\u201d to print the report.<\/p>\n

      \"null\"<\/p>\n

      On the report request page, enter the \u201cPeriod End Date\u201d and the \u201cProject No\u201d. for which the report needs to run as per the data entered in the \u201cPayroll Register Ledger Entries\u201d.<\/p>\n

      \"null\"<\/p>\n

      Once we click on the Preview button the report will be previewed.<\/p>\n

      Page 1<\/u><\/p>\n

      \"null\"<\/p>\n

      Page 2<\/u><\/p>\n

      \"null\"<\/p>\n

      Page 3<\/u><\/p>\n

      \"null\"<\/p>\n

      Note:<\/b> The data on Page 3 is coming from the fields which we have filled on the \u201cHuman Resource Setup\u201d under the \u201cProjectPro – Certified Payroll\u201d fast tab.<\/i><\/p>\n

      \"null\"<\/p>\n<\/p>\n