Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Payroll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Please find the very basics of Accounting in Oracle HR and Payroll Module. 


 

Golden Rule of accounting from ORACLE PAYROLL

            Dr :- Actual Account

            Cr :- Balancing Account

 

When LD(Labour Distributions) comes into play, “Actual Account in Payroll” is
replaced by “Clearing Account in Payroll”.

 

Based on above golden rule, for Earning Elements, following account
entry takes place .

The payroll run result value is +ve for “XX_Custom Basic Salary”

Step

Credit

Debit

Element

How to recognise

Post from Payroll

Balancing Account

 

XX_Custom Basic Salary

Pickup Balancing entries for LD elements when in Credit

Post from Payroll

 

Clearing Account

XX_Custom Basic Salary

Ignore debit entries for LD elements

Post from LD

Clearing Account

 

XX_Custom Basic Salary

 

Post from LD

 

Actual Account

XX_Custom Basic Salary

 

 

 

For Rebate element, following accounting takes place

( golden rule is violated, as the original entries need to be either fully
or partially reversed). The payroll run result value is –ve for Rebate Element       

Step

Credit

Debit

Element

Post from Payroll

 

Balancing Account

NI Employers Rebate

Post from Payroll

Clearing Account

 

XX_Custom Basic Salary

Post from LD

 

Clearing Account

XX_Custom Basic Salary

Post from LD

Actual Account

 

XX_Custom Basic Salary

 

 

Conclusions( Not taking LD into account. These rules apply to costing entries in Payroll.) :-

1.        The golden rule applies only when run result values are Positive.

a.        If run result value is positive, then

v       Credit          Balancing Account

v       Debit           Actual Account

 

2.        The golden rule DOES NOT apply when run result values are Negative.

a.        If run result value is negative, then

v       Credit          Actual Account

v       Debit           Balancing Account

 

3.        The distributed element has a negative run result value then

a.        Debit entry is made against Actual Element ( i.e. “NI Employers Rebate” )

b.        Multiple Credit entries are made against elements in Distribution Set
 ( i.e. XXX_BASIC_SALARY, XXX_LONDON_ALLOWANCE etc)

NI Employers Rebate

2.25

Dr

Balancing Account

Basic Salary

2.15

Cr

Actual Account

London Allowance

0.1

Cr

Actual Account

 

 

4.        The distributed element has a positive run result value then

a.        Credit entry is made against Actual Element ( i.e. “NI Employer” )

b.        Multiple Debit entries are made against elements in Distribution Set
( i.e. XXX_BASIC_SALARY, XXX_LONDON_ALLOWANCE etc)

NI Employer

399.99

C

Balancing Account

Basic Salary

382.57

D

Actual Account

London Allowance

17.42

D

Actual Account

 


Anil Passi

Comments   

0 #1 Dilip 2006-11-03 00:00
Hi Anil,
Can I get some more basic information about Payroll.
Quote
0 #2 Dilip 2006-11-03 00:00
Hi Anil,
Can I get some more basic information about Payroll.
Quote
0 #3 Anil Passi 2006-11-15 00:00
Sure you can, but it is only logical to begin with HRMS first. I am covering HRMS topics for next couple of weeks. Some of those topics have been posted already

than ks
anil
Quote
0 #4 Anil Passi 2006-11-15 00:00
Sure you can, but it is only logical to begin with HRMS first. I am covering HRMS topics for next couple of weeks. Some of those topics have been posted already

than ks
anil
Quote
0 #5 ayman 2006-11-16 00:00
feefef
Quote
0 #6 ayman 2006-11-16 00:00
feefef
Quote
0 #7 Rinkesh 2006-12-12 00:00
Hi Anil,

I have found your site very informative and good for both Technical and functionals.I was working in Financials since last four yrs now i have got work in HRMS/PAYROLL.so i want to learn inouts of HRMS..functiona lity of hrms...if you have some student guide kind of stuff..or steps to learn HRMS/PAYROLL with table details that will great help for me.
Please mail me if you have this kind of document...i am refering your articles on your portal as well.

Thanks a Lot

Rinkesh
Quote
0 #8 Anil Passi 2006-12-12 00:00
Hi Rinkesh,

Con grats for having joined the HRMS/Payroll cub. This is one of my favourite modules.

I dont have a student guide I am afraid. But I will write something up on important Payroll tables.

Than ks
Anil Passi
Quote
0 #9 Rinkesh 2006-12-12 00:00
Hi Anil,

I have found your site very informative and good for both Technical and functionals.I was working in Financials since last four yrs now i have got work in HRMS/PAYROLL.so i want to learn inouts of HRMS..functiona lity of hrms...if you have some student guide kind of stuff..or steps to learn HRMS/PAYROLL with table details that will great help for me.
Please mail me if you have this kind of document...i am refering your articles on your portal as well.

Thanks a Lot

Rinkesh
Quote
0 #10 Anil Passi 2006-12-12 00:00
Hi Rinkesh,

Con grats for having joined the HRMS/Payroll cub. This is one of my favourite modules.

I dont have a student guide I am afraid. But I will write something up on important Payroll tables.

Than ks
Anil Passi
Quote
0 #11 kirankumar 2006-12-20 00:00
my question is can i get complete reference ob payroll 11i hrms
can u give some booknames
Quote
0 #12 kirankumar 2006-12-20 00:00
my question is can i get complete reference ob payroll 11i hrms
can u give some booknames
Quote
0 #13 Thanigaivelan 2007-04-03 00:00
Hi Anil, It would be great if you could throw some light on costing of payment methods. How can we achieve this if we are going to develop a customized process for payments processing (like bank transfer procedure) ?

Thanks and Regards,
S. Thanigaivelan
Quote
0 #14 Anil Passi 2007-04-04 00:00
Not sure if your question was in Payroll context or general Payables

Assuming you are refering to costs associated with payment methods like CHAPS, SWIFT etc.
These payments can costs from 1 to 10 USD, depending upon the correspondance bank structure in place.

A service provider that makes these transactions[i. e. sends our messages accross to SWIFT network] will be sending you lumpsump invoices.
You can put charge those invoices into a placeholder account.

nex t, you can run the custom monthly process that reads all the SWIFT payments on monthly basis, and apportions the transfer charges accross to different cost centres.
this custom process can post straight to GL [and it will credit the placehold account entries from AP]

Rules for apportioning can be discussed with your business analysts

Tha nks,
Anil Passi
Quote
0 #15 Kadhiresan L 2007-04-17 00:00
Hi,

Real useful stuff. Thanx.

Could you please pass on some step by step processing payroll docs.

this will be more useful.

Than x & Regards,
Kadhi resan L
Chennai
Quote
0 #16 Anil Passi 2007-04-20 00:00
Hi Hari

I have written step by step demo on fast formulas

ple ase see http://www.google.com/search?q=site:apps2fusion.com+oracle-hrms-payroll-training-3

Thanks,
An il Passi
Quote
0 #17 Kadhir 2007-05-03 00:00
Hi Anil,

This is my second time of contacting you to have very urgent help.

Kindly give some material or setup docs of OAB (Advanced Benefits). THIS WOULD BE GREAT HELP FROM YOU.

Thanx & Regards,
Kadhi resan L
09840260674
Quote
0 #18 SachinShirke 2007-08-28 03:56
hi anil,
this is ramesh,pls help me in getting API's in HRMS.and if possible any API inbound

Thanks & Regards
ramesh
Quote
0 #19 CK 2008-03-13 08:08
Hi Anil
I have enter costing element link level salary expense Account 0001 and Balanacing (payroll clearing) 9999. After payroll run costing summary shows Salary expense Debit and Payroll Clearing Credit. Please tell me how to i can reverse this entry or set off this liability. In other words what entry finance pass in against my Payroll entry. Please also tell me How AP will pay this payment
Many Thanks
CK
Quote
0 #20 Amar Chakraborty 2008-12-30 05:15
Hi,

Any document or link available to purge history records in Oracle Payroll ?

Thanks
Amar
Quote
0 #21 irfan 2014-10-16 13:17
I have one query regarding the SLA Customization in the payroll, please check if you can help me out…

the requirement is that we have cost allocation flexfield in the payroll with 7 segments similar like GL COA.

If segment account of Cost Allocation KFF (5th Segment) starting with value 1 or 2 then (segment4) cost Centre must be default to '0000' and location segment (2nd Segment) should be defaulted with ‘000’

Please let me know if we can achieve the above by ADR(Account derivation rule),

Thanks
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner