SureStart Configuration – Oncost to GL
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.
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
Employee GL – oncost associated to the earning category will be costed to the default GL assigned on the Employee Maintenance form.
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
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
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
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.
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).
