Report PR Certified Payroll

Purpose:

This report is typically used if your firm has government jobs.

Setup Considerations:

Certified Payroll Report – Fringe column

If this column is to include other company paid fringe dollars, for example Health Insurance:

The employee “burden” can NOT include these estimated dollars AND a new burden amount would need to be established/setup.

To setup:  Add at least 1 new EarningsID for the fringe(s).   Type is  Fringe  and Check box:  JOB COST PR CHECK

Do not check Taxable, do not check Fringe on Check, do not check Accrue – set the GL Debit to be same GL Expense Acct from the JOB COST CATEGORY & set the GL Credit to be the same as the GL Debit account so it has no impact on GL

Add new JOB COST CATEGORY for FRINGE-XXX (XXX=type of fringe if you want to break out) and set the Cost Type as Labor,  Income account is left blank, GL Expense Account = COS-FRINGE-XXX(Direct) and assign the new Cost Cat to the Earnings Id.   

Note: when new labor is entered & the PR Check is posted, the system will create new JOB COST records for FRINGES (by Job/GLEntity), which are referenced as source ‘PR CHECK’. 

The JOB COST PR CHECK feature is only available on Earnings Type = Fringe.

 

If the column is to include:  Taxes where the ACTUAL Employer Tax Amounts are based on hours worked on the Job

The employee “burden” can NOT include estimated tax dollars AND a new burden amount must be established/setup without the estimated taxes.

To setup:  On Tax Authority Id’s for FUTA, FICA, SUTA – go to GL Tab and review GL Expense Accounts – see if this is going to 1 GL Expense account for “Indirect Payroll Taxes/Employer Paid” or to multiple GL Expense accounts by tax type.  If customer breaking out by type of tax, multiple JOB COST CATEGORIES will be needed for each tax type.   e.g. TAXES-FED (futa,fica), TAXES-STATE  (suta-va, sdi-nj,suta-md).

To turn on, on the GL Tab of the employer based Tax Authorities, check box:  JOB COST & add Job Cost Category for TAXES (For Job Cost Categories, set the Cost Types as Labor, Income account is left blank, GL Expense Account = COS-PAYROLL TAXES-(Direct/EMPLOYER PAID))

Note: when new is labor entered & the check is posted, the system will create new JOB COST history records for actual TAXES, which are referenced as source ‘PR CHECK’. 

 

If this fringe column is to include Workers Comp dollars:

The employee “burden” can NOT include estimated workers comp dollars AND a new burden amount must be established/setup.

To setup:  On each Worker Comp State Id’s, check box:  JOB COST & add JOB COST CATEGORY for WORKERS COMP and check the GL Debit account on the WC State to make sure this GL Expense account is for capturing ALL ‘indirect’ dollars, as direct comes from the new Cost Cat. (Note: admin vs. service is determined by using the GL Entity on Overhead Job’s Cost Code).  Re:  Job Cost Category set cost types as Labor,  Income account is left blank, GL Expense Account = COS-WORKERSCOMP(Direct).       

Note: when new labor entered & check is posted, the system will create new JOB COST history for actual WORKERS COMP costs by Job, which are referenced as source ‘PR CHECK’. 

 

Registry to Import PR Check Cost to the Work Order

All these new ‘PR CHECK’ costs can optionally be imported into the Workorder using a registry setting.

Registry Id:       sys-viewer-vwrkordr

Setting Key:      ImportPRCheckFromJCH

Setting Value:            true

These settings should be implemented in a TEST database, and labor entries posted to confirm the results are as desired.  Confirm the G/L is posting properly & nothing is double costing (can use REPORT PR GL REPORT to review G/L impact after test run of a check) & confirm the Certified PR report is now reporting fringes.

 

Additional Information:

Also read the following help sections regarding these features in Earnings, Tax Authority/GL tab & Workers Comp:

Earnings Viewer

Tax Authority Viewer

Worker's Comp Category Viewer