New PF logic Configuration as per System?
As per govt rule currently we have built in different logics in our System
Normal New pf logic
- a) If Earned Basic is greater than 15000 then pf will deduct on Earned Basic flat 12%
- b) If Earned Basic is less than 15000 then will add gross payheads earned value, If the Addition of Earned Basic & Earned value of Gross payheads is greater than 15000 then the system will restrict the amount to 15000 and will capture as 15000 PF base.
- c) If Earned basic is less than 15000 then will add gross payheads earned value If the Addition of Earned Basic & Earned value of Gross payheads is less than 15000 then the system will Deduct on Sum of Earned Basic & Earned value of Gross payheads.
To Set the Above logic would need the configuration to be done in system
- 1) Make “PFAPP “ true on Basic+gross payhead through Compensation & Benefits Screen / Payhead Master Template.
- 2) Make “Exempt App” true on Basic payhead
- 3) Map “HRA BasicDA Exemption” through Payhead Master Template
Note :- Basic payhead Exempt App-True and Exempt Section =“HRA BasicDA Exemption” are mandatory
- Ø Additional requirement as per few client requirements we need Basic + another payhead to check limit 15000 on first step
For which you need make Exempt App-True and map Exempt Section =“HRA BasicDA Exemption” so that 15000 limit is checked (Earning basic+Another payhead)
Example :-
Basic Rate 20000
- 1. Days worked -30/31
Basic > 15000 Then Basic*12%
20000>15000 Then 20000*20/100 =2400
- 2. Days worked =25
Basic <15000 then adding gross payhead Basic + Da +spl + training
Basic < 15000 and Basic + Da +spl + training > 15000 then restrict 15000 else
Basic + Da +spl + training
13333 <15000 Then 13333 +2000+1000+6000
13000 < 15000 and 22333 > 15000 Then 15000 PF = 1800
- 3. Days worked =10
6666<15000 Then 6666+1000+500+3000
13000 < 15000 and 11666 > 15000 Then 15000 Else 11666 PF = 1339
Normal logic But check basic actual value
- l If Actual Basic is greater than 15000 then pf will deduct on Earned Basic flat 12%
- l If Actual Basic is less than 15000 then will add Earned Gross Payhead on which Basic+Gross is greater than 15000 then system will restrict 15000 and update only 15000 as pf base.
- l If Actual basic is less than 15000 then will add Earned Gross Payhead on which Basic+Gross is less than 15000 then system will deduct on basic+gross as PF Base.
- l If Actual basic above 15000 but due to LOP Earned basic is less than 15000 then Pf will deduct on Earned Basic *12%
For Above logic configuration required in the system
First make “PFAPP “ true on Basic+gross payhead from compensation & benefits screen / payhead master template.
Make “Exempt App” true on Basic payhead and map “HRA BasicDA Exemption” this is to be done from payhead master template.
Note :- Basic payhead Exempt App-True and Exempt Section =“HRA BasicDA Exemption” are mandatory
One more additional requirement some client need Basic + Another payhead to check limit 15000 on first step
For which please make Exempt App-True and map Exempt Section =“HRA BasicDA Exemption” so that will check 15000 limit on Earned basic+Another payheads
Note: You need raise query to activate pf base with actual basic configuration
Example :-
Basic Rate 20000
- 4. Days worked -30/31
Act Basic > 15000 Then Basic*12%
20000>15000 Then 20000*20/100 =2400
- 5. Days worked =30/31
Act Basic <15000 then adding gross payhead Basic + Da +spl + training
Act Basic < 15000 and Basic + Da +spl + training > 15000 then restrict 15000 else
Basic + Da +spl + training
13333 > 15000 Then 13333 +2000+1000+6000
13000 < 15000 and 22333 > 15000 Then 15000 PF = 1800
- 6. Days worked =10
20000 > 15000 Then 6666 *12/100 PF=799
l PF logic with pf calculation prorate basis
In this logic for employee need to be set pfbaselimit as 15000 for prorate
Rest all configuration logic will not change.
- l If Actual Basic is greater than 15000 then pf is deducted on Earned Basic flat 12%
- l If Actual basic is less than 15000 then will add Gross Earned Value,If Basic+Gross is greater than 15000 then system will restricted 15000 and update only 15000 pf base.
- l If Actual basic is less than 15000 then will add Gross Earned Value,If Basic+Gross is less than 15000 then system will deduct on basic+gross as PF base
- l If Actual basic above 15000 but due to lop earning basic is less than 15000 then pf will deduct on Earning basic *12%
Note: You need raise query to activate PFcalculationprorate Configuration
For Above logic configuration required in system
First make “PFAPP “ true on Basic+gross payhead from compensation & benefits screen / payhead master template
Make “Exempt App” true on Basic payhead then map “HRA BasicDA Exemption” this exemption from payhead master template
Days worked :-30/31
Basic =25000
Pfbaselimit =15000
Pf ded =1800
Days worked =20
Act Basic =25000
Pfbaselimit=15000
Earning Basic :-16666
PF ded=1800/30*20 =1200