Skip to main content

Oncost Calculation for Payroll

Written by Denisa Arjoca
Updated over 3 weeks ago

SureStart Configuration – Oncost to GL

  1. Pay Items

Pay Items are records that contain information about how an entry on an employee payslip is calculated. Pay items can hold hours and dollars, be used in the calculation of other values, determine what appears on a payslip and where it appears, and can be used to determine what GL accounts are used during the payroll process.

Pay Items are not Company specific and must be included in a sequence which in then associated with selected employees. Pay items are associated with Earning Categories for wages, Pay Calculations for fringes and deductions.

Current pay items for leave costed to a specific GL.

2. Earning Categories

An Earning category is an item of income that makes up an employee’s pay. Earning Categories summarise types of pay into categories which can then be reported on and also allows for different methods of payment.

You will also define if the earning category is taxable, have super payable and where is appears on the payment summary. If oncost are to be calculate when used how this calculation occurs is define against each earning category. An earning category must have a corresponding Pay Item, or it will not be processed in the pay run.

Eg. HOL – Annual Leave

Apportion oncost for an earning category can occur in three methods.

  1. Timecard – oncost associated (SGC, PTAX, WC) to a earning category (eg HOL annual leave)  will be costed against what has been entered on the timecard for HOL

  2. Employee GL – oncost associated to the earning category will be costed to the default GL assigned on the Employee Maintenance form.

  3. None – no oncost calculated at all.

Default cost code refers to what cost method is used for the earning category when processed via timesheets.

4. None - no costing

5. Employee - will use the default costing assigned to the employee on the ‘Employee Maintenance’ form

6. Employee GL - will use the GL assigned to the employee on the ‘Employee Maintenance’ form

7. Pay Item - will use the costing method assign to the Pay Item

3. Timesheet Entry

When a timesheet entry is completed for the Earning Category, COINs will refer to the configuration to establish how the cost is assigned.

4. Costing Workbench

Once a payrun is calculated, the transactions associated with an employee timecard are visible in the costing workbench.

All oncost associated to an earning category are costed as per the configuration define against that particular earning category.

Using sub accounts on the debit entry for the oncost allows for reconciliation of all oncost which fall part of the total burden cost to GL.

Employee

Item

Description

Input

Value

Method-Label

Analysis

Account

Post-Label

BUT01

300

Super S/Sacrifice

0

50

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

401

Super Priv Contrib

0

25

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

600

Super Guarantee

0

25.45

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

602

Annual Leave Accrual

0

22.48

GL

99.71110.TOTAL

99.71110.TOTAL

Credit

BUT01

603

LSL Accrual

0

4.15

GL

99.71120.TOTAL

99.71120.TOTAL

Credit

BUT01

605

Personel Leave Accrual

0

9.57

GL

99.71130.TOTAL

99.71130.TOTAL

Credit

BUT01

619

Nett Pay

0

173.75

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

653

Workers Comp Accrual

0

2.34

GL

99.71180.TOTAL

99.71180.TOTAL

Credit

BUT01

739

Payroll Tax Accrual

0

13.68

GL

99.71170.TOTAL

99.71170.TOTAL

Credit

BUT01

767

Payroll Burden

0

22.48

GL

99.71130.ANNLV

99.71130.ANNLV

Debit

BUT01

767

Payroll Burden

0

4.15

GL

99.71130.LSLVE

99.71130.LSLVE

Debit

BUT01

767

Payroll Burden

0

9.57

GL

99.71130.PERLV

99.71130.PERLV

Debit

BUT01

767

Payroll Burden

0

25.45

GL

99.71130.SUPER

99.71130.SUPER

Debit

BUT01

767

Payroll Burden

0

2.34

GL

99.71130.WCOMP

99.71130.WCOMP

Debit

BUT01

767

Payroll Burden

0

13.68

GL

99.71130.PRTAX

99.71130.PRTAX

Debit

BUT01

767

Payroll Burden

0

-77.67

GL

99.71130.TOTAL

99.71130.TOTAL

Debit

BUT01

767

Payroll Burden

7.6

326.42

GL

99.71130.TOTAL

99.71130.TOTAL

Debit

Option B – Oncost costed to Timecard

  1. Pay Items

All of the Pay Items associated with the cost of Labor are rolled up into a single pay item, defined as Total Burdened and Allocated Costs, for expense purposes. When posting to Contract Status or the General Ledger, costs are summarised at the Analysis (Contract or GL) level for each payroll period for each Unit (hour) measured.

All earnings, employer burdens, payroll tax, and workers comp are rolled up into a single Pay Item 767. The costing will be a DEBIT to accrue the expenses. The General Ledger entry will come from the cost code portion of contract analysis entered on each timecard.

2. Earning Category

The only change to an earning category for this option would be to the default cost as the Pay Item holds no costing therefore setting the default cost to ‘Employee’.

Apportion cost will remain as Timecard as all oncost will be apportioned as per what is entered on an employee’s timesheet

3. Employee Maintenance

All employees will hold Default costing against their individual record. All defaults can be overridden on a timesheet entry.

4. Timesheet Entry

When a timesheet entry is completed for the Earning Category, COINs will refer to the configuration to establish how the cost is assigned.

5. Costing Workbench

Once a payrun is calculated, the transactions associated with an employee timecard are visible in the costing workbench.

All oncost associated to an earning category are costed as per the configuration define against that particular earning category, in this example costed to the contract C1.22000

Employee

Item

Description

Input

Value

Method-Label

Analysis

Account

Post-Label

BUT01

300

Super Salary Sacrifice

0

50

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

401

Super Priv Contrib

0

25

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

600

Super Guarantee

0

26.79

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

602

Annual Leave Accrual

0

23.66

GL

99.71110.TOTAL

99.71110.TOTAL

Credit

BUT01

603

LSL Accrual

0

4.36

GL

99.71120.TOTAL

99.71120.TOTAL

Credit

BUT01

605

Personel Leave Accrual

0

10.07

GL

99.71130.TOTAL

99.71130.TOTAL

Credit

BUT01

619

Nett Pay

0

186.84

GL

99.71100.TOTAL

99.71100.TOTAL

Credit

BUT01

653

Workers Comp Accrual

0

2.46

GL

99.71180.TOTAL

99.71180.TOTAL

Credit

BUT01

739

Payroll Tax Accrual

0

14.4

GL

99.71170.TOTAL

99.71170.TOTAL

Credit

BUT01

767

Payroll Burden

0

23.66

GL

C1.22000.ANNLV

C1.22000.ANNLV

Debit

BUT01

767

Payroll Burden

0

4.36

GL

C1.22000.LSLVE

C1.22000.LSLVE

Debit

BUT01

767

Payroll Burden

0

10.07

GL

C1.22000.PERLV

C1.22000.PERLV

Debit

BUT01

767

Payroll Burden

0

26.79

GL

C1.22000.SUPER

C1.22000.SUPER

Debit

BUT01

767

Payroll Burden

0

2.46

GL

C1.22000.WCOMP

C1.22000.WCOMP

Debit

BUT01

767

Payroll Burden

0

14.4

GL

C1.22000.PRTAX

C1.22000.PRTAX

Debit

BUT01

767

Payroll Burden

0

-81.74

GL

C1.22000.TOTAL

C1.22000.TOTAL

Debit

BUT01

767

Payroll Burden

8

343.58

Contract

C102.22000.L

C1.22000.TOTAL

Debit

Leave Accrual Inflation

COINs can calculated all leave accrual cost associated with an employee. Surestart configuration will have rules defined for Annual Leave, Long Service Leave and Sick Leave.

COINs standard calculation is as follows:

Employee hourly rate in COINs: 32.73

Accrual Rate for leave: HOL 0.076923

LSL 0.016667

SIC 0.038462

Hours worked in one week 38

  1. Calculations for leave provision

SureStart calculation for leave accrual in provision accounts

HOLA

(38 * 0.076923) *32.73

=

95.67

LSLA

(38 * 0.016667) *32.73

=

20.73

SICA

(38 *0.038462) *32.73

=

47.84

2. Pay Calculation

Pay calculations define deductions from an employee’s individual pay or an oncost calculation on a pay.

On a pay calculation, you can define the method of calculation, the rate or amount, the maximum amount to deduct, where it appears on a payment summary and whether it is taxable.

COINs has the ability to assign an inflated percentage to increase the provision for leave to accommodation on cost being costed to the provision account during postings.

3. Payroll Calculation

Once a payrun is calculated, the provision can be viewed in the costing workbench or on the individual employee timecard.

The below example displays the new inflated HOLA dollar value which will be credited to the provisional account.

HOLA

(38 * 0.076923) *32.73

*119%

113.85

Oncost not included in Apportioning

  1. Pay Items

All the Pay Items associated with the cost of Labour are rolled up into a single pay item, defined as Total Burdened and Allocated Costs, for expense purposes. When posting to Contract Status or the General Ledger, costs are summarised at the Analysis (Contract or GL) level for each payroll period for each Unit (hour) measured.

All earnings, employer burdens, payroll tax, and workers comp are rolled up into a single Pay Item 767. The costing will be a DEBIT to accrue the expenses. The General Ledger entry will come from the cost code portion of contract analysis entered on each timecard.

There are oncost that are not required to be apportioned across the timecards and costed against all contracts or GL. For example oncost only to a specific employee for a specific reason. E.g. ICT or Rental Bonds

2. Pay Calculations

Pay calculations define deductions from an employee’s individual pay or an oncost calculation on a pay.

On a pay calculation, you can define the method of calculation, the rate or amount, the maximum amount to deduct, where it appears on a payment summary and whether it is taxable.

COINs has the ability to assign a flat rate on a Fringe not included in pay for cost being costed to the provision account during postings.

To ensure the oncost is not including in the apportioning across employee timecards there is a tickbox to exclude the Fringe from being included in the calculations.

3. Employee Maintenance – Pay Calculations

The individual oncost can be allocated to an employee on their master record which will be populated once the timecard is generated.

4. Period Maintenance

Once the calculation process has occurred there is the ability to view the employee pay details via the period maintenance.

To establish if the oncost is NOT being apportion the employee normal pay without BONDFO has the following oncost

ONCOST NORMAL

ONCOST WITH FO

HOLA

246.15

246.15

LSLA

53.35

53.35

SICA

122.88

122.88

SUPG

304

304

BONDFO

0

750

726.38

1476.38

5. Employee Pay Components Report

The report will allow you to view the complete break down of employee pay and see the Fringe not included with other oncost.

Extra Accrual for Leave Oncost

Surestart provisions for Annual Leave, Sick Leave and LSL are configured to accrue and credit a specific provision account. When entitlements are paid to employee via a timecard, these will debit the provision account. However, oncost are calculated on leave taken therefore reducing the provision account by all oncost associated to leave thus resulting in the taken amount to be greater than what was accrued in the provision account.

To allow for the accrual of oncost on leave types when the leaves are being accrued, a parameter will need to be configured. The parameter must contain the leave types that need to accrue additional oncost to compensation for reconciliation of accounts.

  1. Parameter

PR > Global Setup > Parameters

Label

Description

Value

PR-LEAVE-ONCOSTACCRUE

List of Earnings of leaves of ‘FO’ types which needs to accrue oncost on itself

HOL,SIC,LSL

The above would indicate that that when the leaves HOL, SIC and LSL are being accrued, the oncosts that normally occur when they are “TAKEN” needs to be “calculated” and added to this LEAVE Type and the “debit” side to go to the “other contracts or timecards” on the timesheet when this LEAVE is being accrued

2. Pay Items

All the Pay Items associated with the cost of Labour are rolled up into a single pay item, defined as Total Burdened and Allocated Costs, for expense purposes. When posting to Contract Status or the General Ledger, costs are summarised at the Analysis (Contract or GL) level for each payroll period for each Unit (hour) measured.

All earnings, employer burdens, payroll tax, and workers comp are rolled up into a single Pay Item 767. The costing will be a DEBIT to accrue the expenses. The General Ledger entry will come from the cost code portion of contract analysis entered on each timecard.

Surestart leave taken and leave accrued will be costed to specific provision accounts for the specific leave

An earning category that has the costing configuration on the Pay Item to debit a provision account will have “suppress GL posting” selected. This is because the total burden (767) has the full cost of the transaction to the contract or general.

3. Costing Workbench

Once a payrun is calculated, the transactions associated with an employee timecard are visible in the costing workbench.

All oncost associated to an earning category are costed as per the configuration define against that particular earning category.

Employee

Item

Description

Input

Value

Costing

Analysis

Post-Label

Post-Label

WALGEO

619

AUS Nett Pay

0

2191

GL

01.00.110301

Credit

Credit

WALGEO

653

AUS Workers Comp Accrual

0

64

GL

09.12.310329.GEN

Credit

Credit

WALGEO

694

AUS PAYG Tax

0

1009

GL

09.12.310304

Credit

Credit

WALGEO

737

AUS Super Guarantee

0

304

GL

09.12.850101.GEN

Credit

Credit

WALGEO

739

AUS Payroll Tax Accrual

0

99.12

GL

09.12.310307.GEN

Credit

Credit

WALGEO

755

AUS Holiday Leave Accrual

0

265.08

GL

09.12.320100.GEN

Credit

Credit

WALGEO

756

AUS Sick Leave Accrual

0

127.6

GL

09.12.320600.GEN

Credit

Credit

WALGEO

757

AUS Long Serv Leave Accrual

0

54.24

GL

09.12.420100.GEN

Credit

Credit

WALGEO

767

AUS Payroll Burden

0

246.15

GL

03.01.810901.ALV

Debit

Debit

WALGEO

767

AUS Payroll Burden

0

53.35

GL

03.01.810901.LSL

Debit

Debit

WALGEO

767

AUS Payroll Burden

0

122.88

GL

03.01.810901.SLV

Debit

Debit

WALGEO

767

AUS Payroll Burden

0

64

GL

03.01.810901.WCA

Debit

Debit

WALGEO

767

AUS Payroll Burden

0

-585.5

GL

03.01.810901.GEN

Debit

Debit

WALGEO

767

AUS Payroll Burden

0

99.12

GL

03.01.810901.PTX

Debit

Debit

WALGEO

767

AUS Payroll Burden

40

4114.04

Contract

AUS001.0102200.LA

Debit

Debit

WALGEO

645

AUS Normal Time

40

3200

Contract

AUS001.0102200.LA

None

None

Total CR 4114.04

Total DR 4114.04

4. Accrual Rate for Leave Type

The oncost for the leave accrual is calculated by using employee base rate X employee hours per pay period X the accrual rate for the benefit.

DR

CR

EXTRA TO CR

HOLA

246.15

265.08

18.93

LSLA

53.35

54.24

0.89

SICA

122.88

127.6

4.72

422.38

446.92

24.54

Leave hours accrued for employee are calculated using leave accrual rate for the benefit * the hours for the period.

WALGEO BASE RATE

$80

HOURS FOR PERIOD

40

$

HRS

ACCRUAL RATE HOLA

0.076923

246.1536

3.07692

BALANCES $ AND HRS

ACCRUAL RATE LSLA

0.016673

53.3536

0.66692

BALANCES $ AND HRS

ACCRUAL RATE SICA

0.0384

122.88

1.536

BALANCES $ AND HRS

Employee Component Report

NO PARA

WITH PARA

DIFF

PTAX

99.12

99.12

0

WC

64

64

0

SUPG

304

304

0

HOLA

246.15

265.08

18.93

LSLA

53.35

54.24

0.89

SICA

122.88

127.6

4.72

TOTAL ONCOST

889.5

914.04

24.54

COSTED TO JOB

4114.04

(TOTAL ONCOST + TOTAL AMOUNT)

EXTRA IS COSTED TO JOB

5. Reconciliation of EXTRA Accrual

WALGEO BASE RATE

$80

HOURS FOR PERIOD

40

$

HRS

ACCRUAL RATE HOLA

0.076923

246.1536

3.07692

ACCRUAL RATE LSLA

0.016673

53.3536

0.66692

ACCRUAL RATE SICA

0.0384

122.88

1.536

When a timecard is calculated using the accrual hour rate for the benefit type the debit entry for the oncost should reconcile back to the extra accrual being credited to the provision account.

Timecard entered for LSL 0.66692 hours

WALGEO

767

AUS Payroll Burden

0

4.12

WALGEO

767

AUS Payroll Burden

0

-8.14

WALGEO

767

AUS Payroll Burden

0.67

67.24

WALGEO

767

AUS Payroll Burden

0

0.89

WALGEO

767

AUS Payroll Burden

0

2.06

WALGEO

767

AUS Payroll Burden

0

1.07

LSLA 0.89

Extra oncost being shown on the employee component report 0.89

HOLA - Timecard entered for HOL 3.07692 (TIMECARD ROUNDS TO 3.08, UNABLE TO CHANGE THIS)

WALGEO

767

AUS Payroll Burden

0

18.95

WALGEO

767

AUS Payroll Burden

0

-37.45

WALGEO

767

AUS Payroll Burden

3.08

352.27

WALGEO

767

AUS Payroll Burden

0

4.11

WALGEO

767

AUS Payroll Burden

0

9.46

WALGEO

767

AUS Payroll Burden

0

4.93

HOLA 18.95

Extra oncost being shown on the employee component report 18.93 (Variation .02)

SICA -Timecard entered for SIC 1.536 (AGAIN TIMECARD ROUNGS TO 1.54, UNABLE TO CHANGE THIS)

WALGEO

767

AUS Payroll Burden

0

9.48

WALGEO

767

AUS Payroll Burden

0

-18.72

WALGEO

767

AUS Payroll Burden

1.54

154.56

WALGEO

767

AUS Payroll Burden

0

2.05

WALGEO

767

AUS Payroll Burden

0

4.73

WALGEO

767

AUS Payroll Burden

0

2.46

SICA 4.73

Extra oncost being shown on the employee component report 4.72 (Variation 0.01).

Did this answer your question?