Submit a ticket

Standard Report - Certified Payroll

Updated on Follow
0 out of 0 found this helpful

Report Description

This report is used as review of certified payroll records. Certified Payroll records are required to be submitted by contractors on a weekly basis on all contracts. This report will only list the records for Customers listed in Certified Payroll.

 

Customer Service Info > Is Certified Payroll = True

 

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.

CertifiedPayroll.png

 

CertifiedPayroll2.png

 

 

 

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.

 

 

 

 

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

  • 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

 

  • 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


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.