Payroll Items

Modified on Fri, 14 Jun 2024 at 06:00 AM

TABLE OF CONTENTS


We use the Payroll Items reference to set up the earnings, deductions, and contributions that are used in your company.






Who have access to the reference

The Payroll Items reference is a system reference like the Cost Types. A regular user cannot create a new record, but can select items from the list in the Labor Cost Rates library to match with the required wage type and rate.


The reference is accessible to the “Administrators”user group.


Generally, the payroll items are configured by FCX according to your company's needs.






How to create a Payroll Item

Payroll Items should be synced from a payroll system. It is a key element to match payroll data correctly between FCX and payroll system. 

 





Payroll Item Configuration


1. Wage” checkbox is mainly configured by FCX.

It must be checked for any Payroll Item with Hours to calculate a Labor Rate Burden.


An unchecked “Wage” box indicates a non-wage payroll item. These payroll items are excluded from the Daily and Weekly Cost Rate calculations.

Note that “Unit” QTYs are for Non-Wage Items are not treated as hours here.


2. Vacation and Sick — filled in when synced from a payroll system. The checkboxes designate a payroll item as a vacation or sick item for further correct matching to a required cost type.


3. Addition Type impacts on cost rate calculation. Read more below.


4. Financial Account is used to record labor costs to the selected account for all Time Card hours assigned to the appropriate combination of Payroll Item + Wage Type + Cost Type + Employee Classification + State.

The FA in the payroll item predominates the FAs specified in a Cost Type, a WO Type and so on. Read more about how we calculate an FA in the Financial Distribution here.


5. Apply Job Costs to is used to map payroll items for job costing. For example, in FCX, you track all PW hours (regular, overtime, double time) on the “PW” payroll item. However, in your payroll system, these PW hours may be allocated to multiple payroll items on a check: PW Regular, PW OT.

To map payroll items, open the required items in FCX and specify the item that will accumulate all PW cost rates.


6. Allow Requests — to create a Miscellaneous request in the FCX Mobile App.


6. One Request per Day — specifies that an employee can only create one miscellaneous request for the current payroll item per day.


7. Use Non-Work WO for Requests — to use a Non-Work Work Order for a Misc request of the current payroll item.

The Non Work WO is calculated from the Employee's TK Configuration, otherwise it is set by the static value from the system constant.


8. Order — optional field. It is used to arrange the columns of the Payroll Items in the specified order on the Summary tab of the Payroll Periods dashboard.






Addition types of Payroll Items

Select an Addition Type for the Payroll Item which you want to include in Cost Rates calculation.




N/A

N/A describes hourly wage payroll item. It means no addition type for the payroll item. You must specify N/A for all payroll items that record Employees hours worked: regular pay, overtime rate, etc. It is a must to correctly calculate adjusted rates.




Ignore

“Ignore” addition clearly indicates that this payroll item is not used in Adjusted Cost Rates calculation. 

For instance, “Medicare Employee” Payroll Item includes a specified wage deduction. Inside FCX, we determine this Item with “Ignore” addition type. When we sync Cost Rates of paid payroll period from QB/Paylocity, the deduction amount isn't included into Adjusted Cost Rates calculation, nor it isn't written off to the financial distribution.




Proportional – Company Contribution

A Proportional Payroll Item is used to calculate an increase in the Employee Cost Rate that is allocated proportionally according to each rate of pay. The proportional increase is calculated by the ratio of the total of the proportional payroll items to the total of gross wages paid.



 

Example 


#EmployeePayroll ItemAddition TypeHoursRateAmountAdj. Rate
1John Mark Doe

Hourly Job Related Overtime
14.0251715.0254.82
2John Mark DoeHourly Job Related Time
80342720.0036.55
3John Mark DoeMedicare CompanyProportional

48.8
4John Mark DoeSocial Security CompanyProportional

208.67
5John Mark DoeHourly General Operations

34
36.55
6John Mark DoeHourly Holiday

34
36.55
7John Mark DoeHourly PTO

34
36.55
8John Mark DoeHourly General Operations OT

51
54.82
9John Mark Doe
Hourly Education


34
36.55

 


 


Fixed Each Payroll Period

Fixed Payroll Item is used to calculate an increase for a regularly applied (each payroll period) fixed allowance that is to be added to the Employee Cost Rate. The increase is allocated equally across each hour of labor.



Example 


#EmployeePayroll ItemAddition TypeHoursRateAmountAdj. Rate
1John Mark Doe

Hourly Job Related Overtime
14.0251715.0253.13
2John Mark DoeHourly Job Related Time
80342720.0036.13
3John Mark DoeAllowancesFixed

200.00
5John Mark DoeHourly General Operations

34
36.13
6John Mark DoeHourly Holiday

34
36.13
7John Mark DoeHourly PTO

34
36.13
8John Mark DoeHourly General Operations OT

51
53.13
9John Mark DoeHourly Education

34
36.13



Both proportional and fixed Payroll Items stipulate which are additions come with Employee Cost Rate. They can be used simultaneously. In such a case, we calculate each type of increase (proportional, fixed), then we sum the increases to the basic rate. 




AdHoc – Overhead

Overhead Type isn't included in Cost Rates calculation. We take payroll data for Adhoc - Overhead Payroll Items from a payroll system and write-off as a separate source type in Financial Distribution: Employee Payroll Period Overhead. It includes all payroll overhead expenses, and it's factored into the Corporate Overhead Build Plan.


The Financial Account for payroll overhead expenses and a Corporate Build Plan are defined in the Constants/Settings.




AdHoc – BP

We use 'AdHoc BP' payroll item when we can specify the Direct Cost Build Plan by contrast with AdHoc Overhead type of payroll item. 

AdHoc – BP payroll items are for the group of other payroll items in payroll system, for example, expense reimbursements, travel advances, and other additions to gross or net pay.    

 

This addition type of payroll item is used to calculate a non-wage item.

We sync the payroll item amount from a payroll system and divide it to the non-wage payroll item QTY  from the Time Card non-wage table.


During financial distribution calculation, the system multiples the rate to the QTY from Time Card and writes it off to the allocated Build Plan and a specific financial account. 

The financial account specified in a payroll item prevails over financial accounts from Work Order Type, Employee, and so on.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article