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:
o Element Entry
o Element Eligibility
o Element
o 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:
o 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
Post a Comment