Desktop Application


Go Back   CiteHR Home > Human Resource Section > Forms, Formats & Questionnaires





 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old 06-11-2007, 02:59 PM
manojkumar01's Avatar
Join Date: Aug 2007
Location: gurgaon
Posts: 34
Default Re: PF calculation Sheet in Excel

hi

esic challan and calcul.for u

Attached Files
File Type: xls pf___esi_challan_and_calcu_299.xls (155.0 KB, 589 views)
Sponsors
  #12 (permalink)  
Old 06-11-2007, 06:17 PM
kasinaravikumar's Avatar
Join Date: Apr 2007
Location: Hyderabad
Posts: 79
Default Re: PF calculation Sheet in Excel

Dear Sir,


I've one doubt regarding pension. According to the formula the pension is calculated in this manner.

last drawn wages x no. of years of service / 70

But i would like to know about that 70.

Please clarify my doubt.

With Regards,


K. Ravi Kumar.
E-mail:
Ph: 09989111149
  #13 (permalink)  
Old 07-11-2007, 10:53 AM
Amith R Murthy's Avatar
Join Date: Sep 2007
Location: Mysore
Posts: 773
Default Re: PF calculation Sheet in Excel

Sorry Amit i had missed it..................

Regards
Amith R.
  #14 (permalink)  
Old 07-11-2007, 11:04 AM
payal80's Avatar
Join Date: Jun 2007
Location: India
Posts: 40
Default Re: PF calculation Sheet in Excel

Thanks for the sheet
  #15 (permalink)  
Old 07-11-2007, 11:16 AM
mili123's Avatar
Join Date: Oct 2007
Location: Mumbai
Posts: 132
Default Re: PF calculation Sheet in Excel

Dear Amit,

Its very useful to everyone.....


Regards
Milan
  #16 (permalink)  
Old 07-11-2007, 12:56 PM
Amitmhrm's Avatar
Join Date: Feb 2007
Location: Ahmedabad
Posts: 6,445
Default Re: PF calculation Sheet in Excel

Its ok Amith.. No issues.. wish you Happy Diwali..

Thank you Milan..

Regards,

Amit Seth.
  #17 (permalink)  
Old 07-11-2007, 03:48 PM
mili123's Avatar
Join Date: Oct 2007
Location: Mumbai
Posts: 132
Default Re: PF calculation Sheet in Excel

ok Amith,

Wish u the same Happy Diwali

Quote:
Originally Posted by Amitmhrm
Its ok Amith.. No issues.. wish you Happy Diwali..

Thank you Milan..

Regards,

Amit Seth.
  #18 (permalink)  
Old 10-11-2007, 02:42 PM
vinomba's Avatar
Join Date: Nov 2007
Location: chennai
Posts: 18
Default Re: PF calculation Sheet in Excel

Hi,

PF & ESI Calculation

PF 12% of the Basics for BOth (Employer & Employee)
PF Calculation upto 6500 Only above 6500 should not calulate for rest of the BASIC SALARY.
Basics PF 12% (Employee & Employer Contribution Equal Level)
5000 600

ESI
Empoyee Contribution= 1.75%
Employer Contribution= 4.75%

Gross Salary ESI 1.75%(Employee) 4.75% (Employer)
10000 175 475

Above 10000 Gross Salary
They are not eligible for ESI

Regards,
Vinoth.R
  #19 (permalink)  
Old 10-11-2007, 03:59 PM
MANOKAVIN's Avatar
Join Date: Jun 2007
Location: COIMBATORE
Posts: 23
Default Re: PF calculation Sheet in Excel

PF IS NOT CALCULATED ON GROSS SALARY
BASIC+DA IS A CALCULATION
CELING IS RS 6500
  #20 (permalink)  
Old 10-11-2007, 03:59 PM
MANOKAVIN's Avatar
Join Date: Jun 2007
Location: COIMBATORE
Posts: 23
Default Re: PF calculation Sheet in Excel

PF IS NOT CALCULATED ON GROSS SALARY
BASIC+DA IS A CALCULATION
CELING IS RS 6500

   Post New Thread  Reply

Similar Topics

Downloads

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Thread Tags
calculation, excel, sheet

All trademarks and copyrights held by respective owners. Member comments & attachments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service