Standard Report - Certified Payroll

Report Description

This report is used as review of certified payroll records.  Certified Payroll records are made available for contractors and subcontractors required by their Federal or Federally-aided construction-type contracts and subcontracts to submit weekly payrolls.  This report will only generate the records for Customers listed in Certified Payroll.

Certified Payroll shows detailed Reg and OT Hours for each day of the Working week. It also shows the Gross and Net amount earned by an Employee and also shows detailed deductions included in Net Pay.

Parameters

Parameter Name	Options	Explanation
Branch	All available branches
SSN		Filters results by Employee
Date Type	Accounting Period Date, Week End Date	Transaction Accounting Period Date or Week Worked
Date		Select Accounting Period Date or Week End Date
Project Name		Filters results by Project Name [Customer Extra>> Project Name copied onto Transaction Extra]
Payroll Number		Enter the payroll number that you wish to appear on the report.
Fringe Benefits - Paying Cash in Lieu?	Yes, No, Not Applicable	If No, the system will use the System Name "FringeReg" and "FringeOT" to find the transaction types and generate in the box below if the transactions have fringe Reg and OT rates. For OT, it will sum the OT rate and FringeOT rate. For the Standard lines, it will generate the Reg rate in the box and generate FringeOT rate behind it. Also, box 4(b) will be checked on the report If Yes is selected, don't need to look for fringe transaction types. Then on the report, box 4(a) will be checked on the report If Not Applicable is selected no change will be made to the report

Report Fields

Field Name	Explanation
Page 1
Contractor check box	By default unchecked
Subcontractor check box	By default checked
Name of Subcontractor	Staffing Company of Check received by employee
For Week Ending	Transaction Week Worked Date
Address	Full Address of Staffing Company of Check
OMB No.	By default '1235-0008'
Expires	By Default '02/28/2018'
Project and Location	Displays Project Name and Customer Worksite Address
Order ID	Order ID of Staffing order linked to Transaction
Project or Contract No.	First pull from PO management Pull from Transaction Snapshot If null then pull from PO Number Extra - this needs to be added if null, pull from Transaction Extra>PO Number. Please check if they have copied to transaction true for this or not. If that is still null pull from Project Number from extra as it is pulling now. if still null, pull from transaction extra>Project Number.
Name of Individual	Employee Name
No of Withholdings Exemptions	Exemptions for Federal Tax from Employee Tax setup
Work Classification	Job Title from Order
Day and Date	There are 7 columns, one for each day that shows Reg and OT hours worked by an individual in a week. Column header for these 7 columns will change dynamically according to the Date selected in the parameter. Date and First letter of Week Day name is shown in header. For eg. If Week Worked = 9/3/2016 is selected, then header will be as: S28 | M29 | T30 |  W31 | T1 | F2 | S3
O	This row will show daily OT Hours
S	This row will show daily Reg (straight) hours
Total Hours	Total OT Hours in O row and Total Reg Hours in S row
Rate of Pay	(Reg Pay Rate + Fringe Pay Rate ) for S row ; OT Pay Rate  from transaction
Gross Amount Earned	Top Row: Gross Wage from Transaction Bottom Row: Gross Amount from Check
Deductions	In Deductions, there are 6 columns: FICA = Total FICA tax deducted in check Withholding Tax = Total Federal Tax in check Med = Total Medicare tax in check State = Total State tax in check Other = Total Deduction amount in check
Total Deductions	FICA + Withholding Tax + Med + State + Other
Net Wages paid for Week	Net amount from check
Page 2
Date	Report Run Date
Name of Signature Party	Supplier property: CertifiedPayroll_UserName
Title	Supplier property: CertifiedPayroll_Title
Employed by…	Staffing Company Name
On the…	Customer Name
Commencing on the…	First and Last Day of the week
On behalf of said…	Staffing Company Name
Name and Title	Name: User Name of User who ran the report Title: By default PayrollAdmin

Required Setup

Set up is required to use this report.

Search for the customer that will be using Certified Payroll.  Under Customer > Sales & Service > Service Info tab, check the box next to Certified Payroll.  This will auto-check the Generate Daily Time Entry box since certified payroll requires time to be entered daily in Card View.

Note:  You can still generate paychecks on a weekly basis. 

Add Config Choice Options in Admin Tools using this guide:  Config Choice Options

• Project Number: Project Number choice code should be set up under Customer Extra
• Category = CustomerOrderExtra
• SystemName = ProjectNumber

• InvoiceExtra1: This choice code has been used to pull PO Number from Transaction Extra*
• Category = CustomerOrderExtra
• SystemName = InvoiceExtra1
• *Note:  If using the AviontéBOLD integrated solution, this choice code is not needed.  POs should be entered under the PO profile tab on the Company record.  The job created should reflect the PO# in the Operations & Financials widget on the Job Details page. 

• Project Name: Project Number choice code should be set up under Customer Extra
• Category = CustomerOrderExtra
• SystemName = ProjectName

More information in https://www.dol.gov/whd/forms/wh347instr.htm

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.