Payroll Template
I have Attached Payroll Template
Employee Payroll Information | ||||||||||||||
Updated 5/16/2010 | ||||||||||||||
ID | Name | SS# | Address | M/F | Occupation | Hire Date | Annual Salary |
Regular Hourly Rate |
Overtime Hourly Rate |
Exempt from Overtime |
Federal Allowances (W-4) |
401(k) Contrib. (%) |
Insurance Deduction ($) |
Other Deductions ($) |
1 | John Doe | ***-***-0000 | 123 Anystreet, Anytown, ST 87111 | M | Senior Engineer | 7/5/2010 | $ 45,250.00 | $ 21.75 | $ 32.63 | FALSE | 4 | 3.00% | $ 26.00 | |
Insert new rows above this line. | [42] |
Statutory Deductions Exemptions Perquisites Payroll
I Have Attached Statutory Deductions Exemptions Perquisites Payroll
Rules for Statutory Deductions, Exemptions on Allowances & Perquisites
Statutory Deductions:
1. EPF
12% on Basic + Wages + Stipend + Arrears
Condition: If Basic salary at the Date of joining is above 6,500 then
It is optional to Employee for PF Deduction. Else
If Basic salary at the Date of joining is below 6,500 then
PF Deduction is compulsory
Companies Contribution: 12% on Basic + Wages + Stipend + Arrears
2. ESIC
1.75% on Gross Salary.
Condition: If Gross Salary is below 10,000 then
ESIC is applicable and is deducted. Else
If Gross Salary is above 10,000 then
ESIC is not applicable and will not be deducted. Companies Contribution: 4.75% on Gross Salary.
3. MLWF
To Deduct MLWF @ Rs. 12 in June, and December for all the employees of
Maharashtra falling under the following grades: (C1 – C5, M1 – M5, S1 – S5, P1 – P#).
4. Profession Tax
To deduct Profession Tax as per the Profession Tax slab. Given below are the
Profession Tax slabs for the employees of Maharashtra
Profession Tax Slab For Maharashtra
Gross Salary Profession Tax Deduction
0-2500 0
2501-3500 60
3501-5000 120
5001-10000 175
10001-and above 200[300 Feb]
Exemption on Allowances:
1. HRA Exemption
HRA allowance received by the employee
Or
Actual rent paid – (10% of Basic + D.A.) Or
50% of (Basic + D.A.) incase the location is (Mumbai, Kolkata, Chennai, Delhi)
or 40% of (Basic + D.A.) incase of other cities.
Or
Which ever is less of the above three.
2. Conveyance Exemption
Maximum Exempted u/s 10 upto Rs.9600 p.a.
(i.e. @ Rs. 800 per month when paid along with the salary)
3. Medical Exemption
Maximum Exempted u/s 10 upto Rs.15000 p.a. based on the bills produced by the employee
(i.e. @ Rs. 1250 per month when paid along with the salary)
4. Education Exemption:
As per the slab mentioned below:
Child Education Exempt Hostel Expenses
0 0 0
1 100 300
2 200 600
Maximum Exempted u/s 10 upto Rs.2400 p.a. based on no of dependent children’s declared by the employee
(i.e. @ Rs. 200 per month when paid along with the salary)
5. Telephone Exemption:
Maximum Exempted u/s 10 upto Rs.18000 p.a. based on the bills produced by the employee
(i.e. @ Rs. 1500 per month when paid along with the salary)
6. Petrol and Vehicle Maintenance Exemption
For Car : Rs. 1200 p.m. * 12 months = 14,400
For Driver : Rs. 600 p.m. * 12 months = 7,200
Perquisites:
1. Company Accommodation / Furniture
15% of Basic + Bonus + Entertainment Allowance
+
10% of Cost of Furniture
–
Rent of accommodation paid by the company
= Value of Perquisite
2. Company Car / Driver
For Car : Rs. 1200 p.m. * 12 months = 14,400
For Driver : Rs. 600 p.m. * 12 months = 7,200
Exemption on Investments :
1. 80 C
Upto 1,00,000 under heads like PPF, LIC Premium, PF, Housing Loan Principal, NSC, ELSS, etc.
2. 80 D
Medical Insurance such as Mediclaim Premium is exempt upto 15,000 per year for self, spouse, and dependant children and additional Rs.15,000 is exempt towards premium for parents and a further Rs.5,000 if the parents are above the age of 65 years.
3. 80 E
Interest on Loan taken for higher education is completely allowed as a deduction.
4. And Other Sections
Like 80CCC, 80DD, Housing Loan Interest, etc.
Click Here to Download Statutory Deductions Exemptions Perquisites-Payroll
Categories: HR Tags: Deductions, Exemptions, Payroll, Perquisites, Statutory
Payroll of An Employee Letter
I have Attached Payroll of An Employee Letter
XYZ Group of Company (Mother Concern)
Address:
Date: 01.12.2010
Office Note
We propose to revise the salary of the following employee under the payroll of ABC Pvt. Ltd. (sister concern) to be effective from 01st December 2010.
SL.No | NAME | DESIGNATION | PRESENT GROSS SALARY | PROPOSED GROSS SALARY |
1. | Ms. Bhattacharya | Analyst | Rs. 40, 000 | Rs. 60, 000 |
Submitted for your necessary approval.
Trishnita Ghosh
(HR Dept.)
Mr. Sengupta
(CMD)
Muster cum payroll
I have Attached Muster cum payroll
Sr. No | Full Name | Sex | Age | Working Hours | Leave with wages | Date of Entry | Interval for Rest OR Meal | Designation | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | TOTAL DAYS WORKED | Rate per Month/Day | Earned Sal | Eaened HRA | Earned D.A | M All | Gross amt Payable | Adv | Loan | PF. | Fp. | ESI | PT | IT | LWF | Total Deduction | Net payable | Signature | |||||||||||||||||||||||||||||||
From | To | Balance | Enjoyed | From | To | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | ||||||||||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | ||||||||||||||||||||||||||||||||||||
1 | Space for Revnue stamp & signature | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 |
Click Here To Download Muster Cum Payroll
Sr. No | Full Name | Sex | Age | Working Hours | Leave with wages | Date of Entry | Interval for Rest OR Meal | Designation | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | TOTAL DAYS WORKED | Rate per Month/Day | Earned Sal | Eaened HRA | Earned D.A | M All | Gross amt Payable | Adv | Loan | PF. | Fp. | ESI | PT | IT | LWF | Total Deduction | Net payable | Signature | |||||||||||||||||||||||||||||||
From | To | Balance | Enjoyed | From | To | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | RS | Rs. | ||||||||||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | ||||||||||||||||||||||||||||||||||||
1 | Space for Revnue stamp & signature | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
5 |
Payroll
The attached xl sheet is my preparation of Payroll and Salary Slips.
Categories: Payroll Format Tags: Payroll
Pay Roll Software in Excel for W.B.Govt Employees
This Excel based Pay Roll Software is more useful to all West Bengal Govt employees or West Bengal Govt Concerned who are prepared the Pay Bill as manually. This Excel Based Pay Roll Software can Prepare at a time the Employees Pay Inner Sheet + Pay Outer Sheet + GPF Schedule + Bill Extract + all the Papers as required by the Treasury Office for payment of Salary of Govt Employees.
Categories: Payroll Format Tags: Payroll, Software
Payroll in Excel Sheet
Please find attach herewith Payroll in Excel Sheet.
Categories: Payroll Format Tags: Payroll
Categories: Payroll Format Tags: Payroll
Automating (Simplifying) Payroll SS
I have attached a sample salary spreadsheet which includes a payslip section.
Categories: Uncategorized Tags: Payroll, Payslip
Sap hr (Payroll)
Here are some of the Indian Payroll Steps in SAP HCM.
Categories: HR, Payroll Format Tags: Payroll