No Tags Found!

analyst1012
Hi All,
I am enclosing our salary structure sheet for the group members to comment on. We are a pvt. ltd company and this salary structure is for working whole time directors. Your comments will help us a lot in designing a tax efficient break. in the enclosed sheet i have also included a tentative tax calculation.
look forward to receiving your comments. thank you for the attention and feedback.
best wishes

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls salaryStructure_citehr.xls (43.5 KB, 553 views)

Ed Llarena, Jr.
89

Hi!

What you have made in the XL sheet is not a salary structure. It's a presentation of the list that comprises the salary component in your ccompany. I am curious what made you say that it is a salary structure.

A salary structure is a design of the overall compensation plan in an organization. It is composed of three (3) critical parts, namely: Job Grades, Positions Covered, and Salary Rates Structure.

A salary structure is designed like a curve and encompases range structures that may be either of the following schemes: no overlap, moderate overlap, & substantial overlap. It normally shows the following information: minimum rate, midpoint rate, maximum rate, the overlaps, the range spread, and mid-point progression.

In designing a salary structure, you need to decide on the following aspects: range spread, degree of overlap, and payline policy.

I think your organization needs urgent professional help.

Call us if you have budget: 00632-787-0423/

Best wishes.

Ed Llarena, Jr.
Managing Partner
Emilla Consulting


From Philippines, Parañaque
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.

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

Download:Free File Hosting & Video Downloads, Free File Sharing, Online Friends Network - Ziddu

From India, New Delhi
Chiefandy
Mr Parmar,
I just downloaded your program, I must comment that I have not used it as yet, but by the looks of it, you have done a very wonderful job. Secondly, I looove XL ;-)
It sure will be helpful to a lot of small business's like ours. Thanks for the good job
Andrew James

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