CTC Excel Sheet - Provident Fund
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

CTC Excel Sheet - Provident Fund

hiteshr Started The Discussion:

Hi All can anyone share the excel sheet or some program to calcuate CTC of an employee...... please help!!!.....its really urgent Regards Hitesh

Chetan W - Member Since: Jun 2007
HI CTC CALCULATION CHETAN


Attached FilesProvided by community member Chetan W. Join us to learn and grow with your peers.
File Type: xls pmast_264.xls (15.5 KB, 2061 views)
REESHMA - Member Since: Jun 2007
hi friends wots the reason i cant see the excel sheet or any other attacthments.please help me. regards reeshma

smitajoshi - Member Since: May 2007
HI Chetan Thanks for Excel Sheet .......but what is P.F AD 1.61% I don’t know anything about this can you explain it to me MY Emial ID is smital_05@rediffmail.com with Regards, Smita

rajini - Member Since: Jun 2007
HI Smita,

PF Ad mean if you have any additional Provident Fund other then...from your and company contribution assigned by the company.

You can contribute more on your PF if you want to...all you need to do is contact your accounts department. You will have to fill up a form or it should be available on your company intranet.

Check it out :)

Take care and have a nice day.

pacer-deepa - Member Since: Apr 2007
Hi, You can use the one attached below... I got this from Cite HR itself and its very useful.... Thanks to the author !! ( I dont recollect the name)... Rgds Deepa


Attached FilesProvided by community member pacer-deepa. Join us to learn and grow with your peers.
File Type: xls salary_break_up_calculator_262.xls (17.5 KB, 1106 views)
Monika Vaid - Member Since: Jan 2007
Hi Reeshma!!!

You must not b logged in at the time u were seeing the article .......... thats y u were not able to see the attachment............. firstly log in on cite HR n then u wud be able to see the attachment for sure


Hope it helps
Regards,
Monika

Monika Vaid - Member Since: Jan 2007
Hi Hitesh/Smita I m attaching a salary breakup format & excel sheet with formulats........... Hope u find it useful..... Regards Monika


Attached FilesProvided by community member Monika Vaid. Join us to learn and grow with your peers.
File Type: xls master_193.xls (400.0 KB, 839 views)
File Type: xls salary_break_up_format_195.xls (69.5 KB, 736 views)
jiguparmar - Member Since: Dec 2008
Please find new version of Salary Master with new Feactures..

Totally Usefriendly program.
You can enter your Company name,Address,Department,Designations
You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.
You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.

Program is Designed on Two mode
(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"
(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"
Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
7-Overtime Monitor.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
11-P.F Calculation
(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%
Second is 12% of Basic)
12-Pension Scheme (not more than 541 rs submission)
13-TDS Calculation
14-Annual Salary statement of Employee and Employer
15-Employer Monthly Salary statement
16-Income Tax Calculations
17-Generation of Form No-6 (For ESIC)
18-Generation of Form no-3A (PF)
19-Generation of Form no-6A(PF)

Limitation: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to deop Thanks...

Download:www.jiguparmar.com

Please chase the steps as per the given sequence.

First open "Company Detail Sheet"
1-Open "Company Detail Sheet"
2-Change Company name and Address.
3-Change Salary discriptions: By default I gave some categories for Fixed earning/Reimberancement/Other deductions. Change the Names of This Categories as per your reqirements.
4- As you enter detail mentions in step 3 name of the categories will appear in auto generation salary just below the Salary discription.
Enter percentage as per your company requirements to generate salary of all employees(By default I gave Basic= 25% of gross .You can change 25% and enter your %)
5-Enter % of ESI from Employee and Employer and For P.F Choose your Options.
6-For Professional tax Slab enter your criteria.
7- Enter Name of Departments/Designation of Employees of your Orgenizations.
8-Enter Tax Slab for man and Woman.

second open "Master Data Sheet"

1-Enter Employee name-gender-employee code.
2-select his/her designation-department
3-Enter Pan no-Bank A/C No-Bank name-P.F no-ESI No-DOB-DOJ-Location
4-Enter Employees Gross salary/Month
5-Here after If You choose Auto mode than Salary slip will be generated autonatically as per (%wise detail) data given by you in "Company detail sheet"(nomally for Regular Employees put Auto mode).But if You don't want to follow the rules enter by You in "Company detail sheet" put manual mode here You can Enter his/her Basic-Hra and all detail of salary manually.
6- Enter Amount of OT/Hr if Employee do OT
7- Enter leave detail,Previous Year Leave-This Year Leaves.
8-Enter Rentpaid by Employee for exemption under section 10&17
9-Enter Amount for section 80c and 80D for U/S VIA deduction.


Thrid open "Attendance sheet according to perticular Month"

1- Enter Attendance/Leave/Holiday of Employee
2- enter Overtime of The Employee.

Forth open "Payroll sheet according to perticular Month"

1- All salary detail and attendance will automatically carry forward. You have to enter only reimberance detail and other deduction detail only
2- Salry will generate as per your data.
3- Enter Salary Amount Which You have Paid.
4-Select Type of Payment.

Most of remaning sheet are monitoring or summary sheet.

Achetan Sen - Member Since: Jul 2010
Sir, ur sheet is not correct. Calculation of Leave Pay,PF looks confusing. Further DA should have been entered. Anyway think more & help us.



Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.




Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


1
LIKES

6527
VIEWS

11
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network