Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
i am p vyas i am working in small industries in this company differnt department & i want payroll with different department & also some pf & some without pf & daily wages plz send excel sheet for that
Dear Sonia,
I came across the payroll excel sheet posted by you, it was an excellent job.
Since I am new to this, I wonder if you could send me a sheet with the formulas use for calculating Basic, HRA, Conveyance.
Regards,
Trupti

Hey Sonia, Thanx a ton ya ! Plz also provide a formulated sheet to calculate basic , hra ,ctc ....
Hi Sonia, Good work. But Management contribution for PF is restricted to Rs.6,500/- which you have not considered. Regards Ramanan K L V
Hi Sonia, Am basically into recruitments since 2 yrs and hve got no idea abt payrolls... cn u pls let me know how to use the excel posted by you ? Rgds, Kalyan
Please find Following link for Excel base Payroll Sheet and Attendance Program
www.jiguparmar.com
Contains:
1-Attendance Register
2-Payroll Register
3-Generate Salary Slip
4-Print Out 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
For more Free Excel Cration For Home/Office and Free Books visit
Free Excel Programs-Softwares-Books-Novels

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.

Download link: www.jiguparmar.con

Hi.. every body.
Actually i m a fresher recentelly joined in a small co. employee strenth is 25.so any body can provide us payroll xle sheet which are helpful for calculating to payroll.
thanks & regards
keshav bats.

Dear All,
i am Anisha Multnai please help in PF Proceger...
i have dout regarding how to calculate PF Challan and Form No12A
on the besic of total amount of All the employee PF contrbution And as well as Employeer.
how to Calculate...please help me all
Regards.
Anisha

Hi sonia
I am RameshPerumal new person inthe citehr. So pls tell excel format for calculating salary. And then i want to complete Hr works also.
I am waiting for ur valuable information.
Thanks
Ramesh Perumal


This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™