Oracle Fusion Payroll :: Distributed Costing Calculation

 ✅ Distributed Costing – Implementation Checklist

---

�� Phase 1: Define Business Requirement

✔ Identify distributed elements (e.g., employer tax, benefit liability, overhead)
✔ Decide which earning elements will receive distributed costs:

· Regular Salary

· Overtime

· Shift Allowance

✔ Confirm:

· Distribution should be proportional (ratio-based)

· Whether multi-assignment allocation is required

---

�� Phase 2: Create Distribution Group

✔ Group target elements that will receive distributed costs
✔ Ensure:

· All elements generate run results

· Elements belong to correct payroll relationships/assignments

---

�� Phase 3: Configure Costing Setup

✔ Enable costing for:

· Distributed element (e.g., employer liability)

· Distribution group elements

✔ Validate:

· Costing defined at correct levels:

o Payroll

o Element Eligibility

o Element Entry (if needed)

---

�� Phase 4: Configure Cost Hierarchy Rules

✔ Verify cost hierarchy (lowest to highest):

1. Element Entry

2. Element Eligibility

3. Payroll

✔ Ensure:

· System derives account segments correctly at each level

---

�� Phase 5: Define Account Derivation Logic

✔ Case 1: Costing Exists at Element Eligibility Level

· Use distributed element account segments

· Overrides distribution group element segments

✔ Case 2: No Costing at Element Eligibility Level

· Use distribution group element account segments

---

�� Phase 6: Configure Natural Account Handling

✔ Decide behavior for natural account segment:

Example:

· Overtime → 5130

· Distributed Element → 5220

✔ Validate:

· With costing → Use distributed element (5220)

· Without costing → Retain original element (5130)

---

�� Phase 7: Ratio-Based Distribution Setup

✔ Ensure system distributes based on:

Element Amount / Total of Distribution Group

✔ Validate:

· If one element has no run result → exclude it

· Remaining elements receive proportional allocation

---

�� Phase 8: Multi-Assignment Cost Distribution

✔ Validate for employees with multiple assignments:

· Costs split based on earnings ratio per assignment

Example:

· Manager → 5000

· Analyst → 200

· Distributed element = 100

�� Allocation:

· Manager gets higher proportion

· Analyst gets smaller proportion

✔ Verify assignment details appear in:

· Costing Results Page

· Run Payroll Cost Results Report

---

�� Phase 9: Offset Account Distribution

✔ Confirm:

· Offset entries also split across assignments

✔ Validate:

· Even in single assignment, assignment details are displayed

---

�� Phase 10: Control Offset Splitting Behavior

✔ Configure parameter: Date used to split distributed cost in offset account

· Default: 01-Jan-2023

Behavior:

Scenario	Result
After date	Offset is split across assignments
Before date	Offset is NOT split

✔ Note:

· Offset is always split if cost account differs

---

�� Phase 11: Testing Scenarios

✔ Run payroll and validate:

Test Cases:

· Single assignment distribution

· Multiple assignment distribution

· Missing run results in group

· Different account segment behavior

· Offset splitting logic

---

�� Phase 12: Validation & Reconciliation

✔ Validate:

· Total distributed cost = original distributed element cost

· Correct ratio applied

· Correct account segments used

✔ Verify:

· GL accounts match expectation

· Assignment-level details are accurate

---

✅ Final Validation Checklist

✅ Distribution group correctly defined
✅ Ratio-based allocation working
✅ Account derivation rules validated
✅ Natural account handling verified
✅ Multi-assignment allocation correct
✅ Offset splitting configured
✅ Reports show correct assignment details

 

 

Here’s a clear numerical walkthrough of your scenario, so you can fully understand how distributed costing is calculated step by step.

✅ Scenario Summary

· Total Gross Pay = 30,000 USD 

o Regular Wages = 20,000

o Bonus = 10,000

· Total Income Tax = 8,517 USD

· Goal: Distribute Income Tax across earnings elements proportionally

---

�� Step-by-Step Calculation

�� Step 1: Identify Distribution Base

Total of distribution group (earnings elements):

Regular Wages = 20,000

Bonus = 10,000

--------------------

Total = 30,000

---

�� Step 2: Calculate Ratio (Proportion)

Regular Wages Ratio

20,000 / 30,000 = 66.67%

Bonus Ratio

10,000 / 30,000 = 33.33%

---

�� Step 3: Distribute Income Tax (8,517)

Regular Wages Share

8,517 × 66.67% = 5,678

Bonus Share

8,517 × 33.33% = 2,839

✅ Check:

5,678 + 2,839 = 8,517 ✔

---

�� Step 4: Accounting Entries Explained

�� Original Income Tax Entry

Account	Debit	Credit
Income Tax Liability	8,517	—

---

�� Distributed Credit Entries

Element	Credit	Explanation
Regular Wages	5,678	Tax allocated based on ratio
Bonus	2,839	Tax allocated based on ratio

---

�� Final Accounting Flow (Simplified)

Earnings (Original)

· Debit Salary Expense → 20,000

· Debit Bonus Expense → 10,000

Tax

· Debit Tax Expense → 8,517

Distributed Offsets

· Credit Salary Account → 5,678

· Credit Bonus Account → 2,839

---

⚙️ Important System Behavior (From Your Scenario)

✅ Key Rules Applied

✔ Distribution is always ratio-based (not equal split)
✔ If element eligibility costing exists:

· System uses distributed element account

✔ If not:

· System keeps original element account

---

✅ Segment Derivation Logic

· Missing account segments are:

o Derived using ratio distribution

o Completed using distribution group element setup

---

�� Final Distribution View (Your Table Simplified)

Element	Debit	Credit
Regular Wages	20,000	—
Bonus	10,000	—
Income Tax	8,517	—
Regular Wages (Tax Allocated)	—	5,678
Bonus (Tax Allocated)	—	2,839

 

Element Name	Distributed element	Input Value	Distributed Input Value	Account	Debit (USD)	Credit (USD)
Regular Wages	NA	Earnings Calculated	NA	4310.1010.1010.3710.1010.6530.51200.100003.	20,000	NA
Regular Wages (Offset)	NA	Earnings Calculated	NA	4310.1010.1010.3710.1010.6530.51200.100004	NA	20,000
Bonus	NA	Earnings Calculated	NA	4310.1010.1010.3710.1010.6530.51200.100001	10,000	NA
Bonus (Offset)	NA	Earnings Calculated	NA	4310.1010.1010.3710.1010.6530.51200.100002	NA	10,000
Income Tax	Income Tax	Tax Calculated	Tax Calculated	4310.1010.1010.3710.1010.6530.51200.100007	8,517	NA
Regular Wages	Income Tax	Earnings Calculated	Tax Calculated	4310.1010.1010.3710.1010.6530.51200.100003	NA	5,678
Bonus	Income Tax	Earnings Calculated	Tax Calculated	4310.1010.1010.3710.1010.6530.51200.100001	NA	2,839