Standard Report - Certified Payroll

October 02, 2026 17:32

The Certified Payroll report provides a review of certified payroll records for contractors and subcontractors required by Federal or Federally-aided construction-type contracts and subcontracts to submit weekly payrolls. This report generates records only for customers listed as Certified Payroll and displays detailed regular and overtime hours for each day of the working week, along with gross and net earnings and itemized deductions.

Report Description

The Certified Payroll report is used to review 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 generates records only for customers listed in Certified Payroll.

Certified Payroll shows detailed regular and overtime hours for each day of the working week. It also shows the gross and net amount earned by an employee and provides itemized deductions included in net pay.

Certified Payroll report example - page 1

Certified Payroll report example - page 2

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 to appear on the report.
Fringe Benefits - Paying Cash in Lieu?	Yes, No, Not Applicable	No: The system uses Fringe Reg (System Name = Fringe - Hourly Rate) and Fringe OT (System Name = Fringe - OT) transaction types. For OT, it sums the OT rate and Fringe OT rate. For standard lines, it generates the Reg rate and Fringe Reg rate separately. Box 4(a) is checked on the report. Yes: The system pulls only Reg and OT rate without fringe transaction types. Box 4(b) is checked on the report. Not Applicable: No change is 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 pulls from PO Management / Transaction Snapshot. If null, pulls from PO Number Extra (Category = CustomerOrderExtra, SystemName = InvoiceExtra1). Check whether Copy to Transaction is enabled. If still null, pulls from Project Number Extra, then from Transaction Extra > Project Number.
Name of Individual	Employee name
No. of Withholding Exemptions	Exemptions for Federal Tax from Employee Tax setup
Work Classification	Job title from order
Day and Date	Seven columns, one per day, showing regular and OT hours worked in the week. Column headers update dynamically based on the date selected in the parameter. The date and first letter of the weekday name display in the header. Example: If Week Worked = 9/3/2016, headers display as: S28 \| M29 \| T30 \| W31 \| T1 \| F2 \| S3
O	Daily OT hours
S	Daily regular (straight) hours
Total Hours	Total OT hours in O row; total regular hours in S row
Rate of Pay	When Fringe Benefits - Paying Cash in Lieu is set to No: Row S: Reg Pay Rate + Fringe Pay Rate (shown separately) Row O: OT Pay Rate + Fringe OT Pay Rate (combined)
Gross Amount Earned	Top row: Gross wage from transaction Bottom row: Gross amount from check
Deductions	Six deduction 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: username of user who ran the report Title: by default PayrollAdmin

Required Setup

Complete the following setup steps before running the Certified Payroll report. Setup is required for the report to generate correctly.

1. Transaction Type Setup

Add fringe rate transaction types in Admin Tools:

Fringe Reg — set System Name to Fringe - Hourly Rate
Fringe OT — set System Name to Fringe - OT

2. Config Choice Setup

Add Config Choice options in Admin Tools using the Config Choice Options guide.

Create the following Config Choice entries:

Project Number — set up under Customer Extra
- Category: CustomerOrderExtra
- SystemName: ProjectNumber
InvoiceExtra1 — used to pull PO Number from Transaction Extra
- Category: CustomerOrderExtra
- SystemName: InvoiceExtra1
Project Name — set up under Customer Extra
- Category: CustomerOrderExtra
- SystemName: ProjectName

Note: If using the AviontéBOLD integrated solution, the InvoiceExtra1 Config Choice is not needed. POs should be entered under the PO profile tab on the Company record. The job created should reflect the PO number in the Operations & Financials widget on the Job Details page.

Once a Config Choice has been created, add the SystemName under the ChoiceProperty tab:

Go to Admin Tools > System > Config Choice > ChoiceProperty.
Set Category to CustomerOrderExtra.
Under Select Branch, select any branch that needs access to this Config Choice.
Set ChoiceCode to ProjectName.
Under SystemName, enter: Project Name.
Check Apply changes to all Branches if needed.
Select Save.

3. Customer Setup

Enable Certified Payroll at the customer level.

Go to Main Menu > Customer (confirm you are on the correct customer office).
Select Sales & Service > Service Info.
Check the Certified Payroll box.
Tab off to save.

Note: Checking Certified Payroll automatically enables the Generate Daily Time Entry box, since Certified Payroll requires time to be entered daily in Card View. You can still generate paychecks on a weekly basis.

4. Job Order Setup

Certified Payroll must also be enabled at the job order level.

Go to Main Menu > Order > Search Order ID > Detail > More Info (right side menu tab).
Check the Certified Payroll box.
Tab off to save.

5. Project Name Setup (Job Order Level)

The Project Name must be added at the job order level for it to pull into the report correctly.

Go to Main Menu > Order > Extra.
Set Label to Certified Project Name.
Under Value, enter the project name.
Tab off to save.

Running the Certified Payroll Report

This completes the setup for Certified Payroll. Keep the following in mind when processing and running the report:

Certified Payroll transactions must be processed in a separate Time Entry and Payroll batch. If processed alongside non-Certified Payroll transactions, they will not pull into the report.
You do not need to post the Payroll Batch for data to appear — only process it.
When running the report, leave the Project Name field blank. Project Name data pulls from Job Order > Extra, along with any other job order extras added for Certified Payroll.

Note: Changes to Config Choices are not retroactive. If you update ChoiceProperties after a Time Entry Transaction has been created, the changes will not apply to existing transactions. To apply the changes, delete the existing transaction and create a new one.

For additional reference, see: https://www.dol.gov/whd/forms/wh347instr.htm

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