Posts tagged "Payroll"

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]

 

Click Here To Download Payroll Template

Be the first to comment - What do you think?
Posted by Hrformats - September 4, 2012 at 4:30 AM

Categories: HR   Tags: ,

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

2 comments - What do you think?
Posted by Hrformats - August 3, 2012 at 9:44 AM

Categories: HR   Tags: , , , ,

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)

 

Click Here To Download Payroll of An Employee Letter

Be the first to comment - What do you think?
Posted by Hrformats - April 20, 2012 at 9:48 AM

Categories: HR   Tags: , , , ,

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

Be the first to comment - What do you think?
Posted by Hrformats - February 6, 2012 at 9:24 AM

Categories: HR   Tags: , ,

Payroll

The attached xl sheet is my preparation of Payroll and Salary Slips.

Click Here To Download Payroll

2 comments - What do you think?
Posted by Hrformats - September 7, 2011 at 9:11 AM

Categories: Payroll Format   Tags:

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.

Click Here To Download Payroll Software

3 comments - What do you think?
Posted by Hrformats - August 29, 2011 at 10:21 AM

Categories: Payroll Format   Tags: ,

Payroll in Excel Sheet

Please find attach herewith Payroll in Excel Sheet.

Click Here To Download Salary Master Payroll

Be the first to comment - What do you think?
Posted by Hrformats - August 27, 2011 at 8:44 AM

Categories: Payroll Format   Tags:

Payroll Breakup on Excel

Uploading Payroll Breakup on Excel.

Click Here To Download Payroll

Be the first to comment - What do you think?
Posted by Hrformats - June 14, 2011 at 9:21 AM

Categories: Payroll Format   Tags:

Automating (Simplifying) Payroll SS

I have attached a sample salary spreadsheet which includes a payslip section.

Click Here To Download Payslip Generator

Be the first to comment - What do you think?
Posted by Hrformats - May 20, 2011 at 3:31 AM

Categories: Uncategorized   Tags: ,

Sap hr (Payroll)

Here are some of the Indian Payroll Steps in SAP HCM.

Click Here To Download Indian Payroll Steps

Be the first to comment - What do you think?
Posted by Hrformats - May 11, 2011 at 8:21 AM

Categories: HR, Payroll Format   Tags:

Next Page »