No Tags Found!


Paresh Vyas
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

Trupti Haswar
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

From India, Mumbai
Deepsi22
1

Hey Sonia, Thanx a ton ya ! Plz also provide a formulated sheet to calculate basic , hra ,ctc ....
From India, New Delhi
klv.ramanan
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
From India, Madras
Kalyanrayi
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
From India, Hyderabad
jiguparmar
49

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

From India, New Delhi
jiguparmar
49

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

From India, New Delhi
keshavp
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.

From India, Mumbai
anisha.multani11
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

From India, Ahmadabad
nirmalaramesh
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

From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.