How Payroll Cost Results are Calculated

  End-to-End Costing & Offset Processing Checklist


�� Step 1: Payroll Run Generates Results

 System calculates:

· Earnings (salary, bonus)

· Deductions (tax, benefits)

 Each run result becomes costable input


�� Step 2: Cost Calculation (Cost Account)

 System Builds Cost Account Segments

For each run result, the system:

1. Starts from lowest level of hierarchy

2. Checks:

Element Entry

Element Eligibility

Element

Payroll


 Costing Types Considered

· Costed → normal costing

· Distributed costing → ratio-based allocation

· Fixed costing → fixed account segments


 Allocation Handling

If cost is split across accounts:

Plain Text

Example:

70% → Dept A

30% → Dept B

Show more lines

 System:

· Calculates cost for each account

· Allocates proportionally


 Handling Unallocated Amounts

Scenario

System Action

Unallocated %

Goes to default account

Invalid account

Goes to suspense account


 Handling Missing Segments

Segment Type

Result

Optional

Remains blank

Required + Suspense exists

Goes to suspense account

Required + No suspense

ERROR


�� Step 3: Distributed Costing (If Applicable)

 If element is distributed:

· Cost is spread across distribution group

· Based on:

Element value / Total group value

 Result:

· Cost added proportionally to each element


�� Step 4: Debit / Credit Determination

 Based on element classification:

Element Type

Entry

Earnings

Debit Expense

Liability / Deduction

Credit Liability


�� Step 5: Priority Account Handling

 If priority account defined:

· System uses that account first

 Remaining %:

· Calculated using standard costing logic


�� Step 6: Offset Account Calculation

 Offset balances the costing entry

Logic:

· Use Offset Account defined at element eligibility

· If segment is blank:

Derive from cost account segment

 Example:

Plain Text

Cost Account → 4310.XXX.XXX

Offset Account → Liability (derived/defined)

Show more lines


�� Step 7: Payment-Related Accounts

 Payroll Liability

· Derived from payment source setup

 Cash Clearing Account

· Used during payment processing

 Cash Account

· Used after reconciliation

�� All come from:

· Payment Source Page configuration


�� End-to-End Example Flow

Step 1: Salary Run

Salary = 20,000

Step 2: Cost Entry

Dr Salary Expense → 20,000

Cr Payroll Liability → 20,000


Step 3: Payment

Dr Payroll Liability → 20,000

Cr Cash Clearing → 20,000


Step 4: Bank Reconciliation

Dr Cash Clearing → 20,000

Cr Cash → 20,000


 Key Controls to Validate

 Cost accounts correctly derived
 Offset accounts properly mapped
 Suspense account configured (to avoid errors)
 Distributed costing working as expected
 Payment source accounts correctly mapped


⚠️ Common Implementation Issues

 Missing account segments → causes errors
 No suspense account  process fails
 Wrong hierarchy setup → incorrect costing
 Offset not derived correctly  imbalance


�� Key Insight (Important)

· Cost = where expense is booked

· Offset = how it is balanced (liability/cash)

�� Every costing entry ALWAYS has:

Debit (Cost) = Credit (Offset)

Comments

Popular posts from this blog

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

Query to get Salary Change details in Fusion HCM

πŸ€– Benefits Analyst: Oracle’s AI Assistant for Employee Benefits Clarity