246x Filetype XLSX File size 0.06 MB Source: msofficegeek.com
Sheet 1: Employee Register
www.MSOfficeGeek.com | ||||||||||||||||||||||||
Salary Certificate Template (Excel, OpenOffice Calc, Google Sheet, Word, OpenOffice Writer, Google Doc and PDF) | ||||||||||||||||||||||||
Company Name: | Sundar Technoligies Ltd | |||||||||||||||||||||||
Address: | 123, Elite Enclave, Cybercity, Magarpatta - Pune | |||||||||||||||||||||||
Phone & Email: | Phone: 020-7896543 Email: Info@STL.com | |||||||||||||||||||||||
Authority: | Mr. Ronnie D'souza | Designation: | General Manager - HR | |||||||||||||||||||||
Sr.No | Employee UID | Prefix | Employee Name | Designation | Department | Location | CTC per Annum | CTC Monthly | Basic | Allowances | Gross Salary | Deductions | Net Salary | Additional Information | ||||||||||
House Rent Allowance | Conveyance Allowance | Medical Allowance | Special Allowance | Total Allowances | Insurance | Profess-ional Tax | TDS Rate | TDS | EPF | Total Deductions | Letter Purpose | |||||||||||||
1 | AS2101 | Mrs. | Astha Puri | Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | ₹ 15,000 | ₹ 6,000 | ₹ 1,200 | ₹ 1,250 | ₹ 1,550 | ₹ 10,000 | ₹ 25,000 | ₹ 1,250 | ₹ 200 | 10% | ₹ 0 | ₹ 3,000 | ₹ 4,450 | ₹ 20,550 | to open a bank account | |
2 | AS2102 | Ms | Bijal Pande | Graphic Designer | Development | Pune | ₹ 180,000 | ₹ 15,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a personal loan | |
3 | AS2103 | Mr. | Chirag Sharma | Sr. Developer | Development | Pune | ₹ 216,000 | ₹ 18,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 150 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | |
4 | AS2104 | Ms | Divya Soni | Graphic Designer | Development | Pune | ₹ 174,000 | ₹ 14,500 | #NAME? | #NAME? | ₹ 1,200 | ₹ 800 | #NAME? | #NAME? | #NAME? | ₹ 800 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | |
5 | AS2105 | Mrs. | Erum Rastogi | Office Admin | Automation | Pune | ₹ 182,400 | ₹ 15,200 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,200 | #NAME? | #NAME? | #NAME? | ₹ 1,200 | ₹ 150 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | |
6 | AS2106 | Mr. | Farhan Patel | Developer | Development | Pune | ₹ 216,000 | ₹ 18,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 1,250 | ₹ 150 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | |
7 | AS2107 | Ms | Geet Sahu | Sr. Accountant | Accounts | Pune | ₹ 600,000 | ₹ 50,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 1,250 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | |
8 | AS2108 | Mr. | Himesh Surya | Jr. Accountant | Accounts | Pune | ₹ 420,000 | ₹ 35,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | |
9 | AS2109 | Mr. | Imran Abha | Graphic Designer | Development | Pune | ₹ 180,000 | ₹ 15,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 150 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | |
10 | AS2110 | Mr. | Jitendra Pande | HR Head | Human Resource | Pune | ₹ 162,000 | ₹ 13,500 | #NAME? | #NAME? | ₹ 1,200 | ₹ 800 | #NAME? | #NAME? | #NAME? | ₹ 800 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | |
11 | AS2111 | Mr. | Kailash Rane | Manager | Sales | Pune | ₹ 336,000 | ₹ 28,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,200 | #NAME? | #NAME? | #NAME? | ₹ 1,200 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | |
12 | AS2112 | Mr. | Luv Patel | Delivery Boy | AUtomation | Pune | ₹ 132,000 | ₹ 11,000 | #NAME? | #NAME? | ₹ 1,250 | ₹ 0 | #NAME? | #NAME? | #NAME? | ₹ 0 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | |
13 | AS2113 | Mr. | Manoj Bhide | Peon | Automation | Pune | ₹ 132,000 | ₹ 11,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 0 | #NAME? | #NAME? | #NAME? | ₹ 0 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | |
14 | AS2114 | Ms | Nancy Pastor | Graphic Designer | Development | Pune | ₹ 216,000 | ₹ 18,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 150 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | |
15 | AS2115 | Mr. | Omar Shaikh | Sr. Developer | Development | Pune | ₹ 312,000 | ₹ 26,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | |
16 | AS2116 | Mr. | Preetam Chavla | Developer | Development | Pune | ₹ 264,000 | ₹ 22,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 800 | #NAME? | #NAME? | #NAME? | ₹ 800 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | |
17 | AS2117 | Mr. | Ram Vihaan | Graphic Designer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,200 | #NAME? | #NAME? | #NAME? | ₹ 1,200 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | |
18 | AS2118 | Mr. | Sunil Upadhay | Developer | Development | Pune | ₹ 150,000 | ₹ 12,500 | #NAME? | #NAME? | ₹ 1,200 | ₹ 0 | #NAME? | #NAME? | #NAME? | ₹ 0 | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | |
19 | AS2119 | Mr. | Tirth Chobe | Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 1,250 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | |
20 | AS2120 | Mr. | Umesh Bajrang | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | |
21 | AS2121 | Mr. | VV | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,000 | #NAME? | #NAME? | #NAME? | ₹ 1,000 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | |
22 | AS2122 | Mr. | WW | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 800 | #NAME? | #NAME? | #NAME? | ₹ 800 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | |
23 | AS2123 | Mr. | XX | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,200 | #NAME? | #NAME? | #NAME? | ₹ 1,200 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | |
24 | AS2124 | Mr. | YY | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 1,250 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | |
25 | AS2125 | Mr. | ZZ | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 1,250 | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | |
26 | AS2126 | Mr. | Sr. Developer | Development | Pune | ₹ 300,000 | ₹ 25,000 | #NAME? | #NAME? | ₹ 1,200 | ₹ 1,250 | #NAME? | #NAME? | #NAME? | ₹ 200 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | |||
27 | AS2127 | Mr. | AA | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | ||||||||
28 | AS2128 | Mr. | AB | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | ||||||||
29 | AS2129 | Mr. | AC | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | ||||||||
30 | AS2130 | Mr. | AD | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | ||||||||
31 | AS2131 | Mr. | AE | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | ||||||||
32 | AS2132 | Mr. | AF | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | ||||||||
33 | AS2133 | Mr. | AG | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | ||||||||
34 | AS2134 | Mr. | AH | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | ||||||||
35 | AS2135 | Mr. | AI | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | ||||||||
36 | AS2136 | Mr. | AJ | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | ||||||||
37 | AS2137 | Mr. | AK | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | ||||||||
38 | AS2138 | Mr. | AL | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | ||||||||
39 | AS2139 | Mr. | AM | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | ||||||||
40 | AS2140 | Mr. | AN | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | ||||||||
41 | AS2141 | Mr. | AO | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | ||||||||
42 | AS2142 | Mr. | AP | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | ||||||||
43 | AS2143 | Mr. | AQ | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | ||||||||
44 | AS2144 | Mr. | AR | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | ||||||||
45 | AS2145 | Mr. | AS | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | ||||||||
46 | AS2146 | Mr. | AT | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to open a bank account | ||||||||
47 | AS2147 | Mr. | AU | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | apply for a personal loan | ||||||||
48 | AS2148 | Mr. | AV | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for two-wheeler loan | ||||||||
49 | AS2149 | Mr. | AW | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for a car loan | ||||||||
50 | AS2150 | Mr. | AX | ₹ 0 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ₹ 0 | 10% | #NAME? | #NAME? | #NAME? | #NAME? | to apply for mortgage loan | ||||||||
Total Salary Amount | ₹ 0 | #NAME? | #NAME? | ₹ 31,250 | ₹ 24,750 | #NAME? | #NAME? | ₹ 572,700 | ₹ 3,750 | ₹ 0 | #NAME? | #NAME? | ₹ 470,226 | |||||||||||
Company Logo | Sundar Technoligies Ltd | Employee ID | ||||||||||
123, Elite Enclave, Cybercity, Magarpatta - Pune | AS2102 | |||||||||||
Phone: 020-7896543 Email: Info@STL.com | ||||||||||||
Date: | Tuesday, August 09, 2022 | |||||||||||
Employee Photo | ||||||||||||
Salary Certificate | to apply for a personal loan | . | ||||||||||
TO WHOM IT MAY CONCERN | ||||||||||||
This is to certify that | Ms Bijal Pande | is working | ||||||||||
with our organization in our | Development | department as | Graphic Designer | |||||||||
posted at | Pune | location. | ||||||||||
Employee ID: | AS2102 | . | ||||||||||
Current Monthly Salary: | ₹ 12,200 | |||||||||||
Annual CTC: | ₹ 180,000 | |||||||||||
The above-mentioned details are correct as per our records. We are | ||||||||||||
issuing this letter on specific request of the employee without accepting any liability | ||||||||||||
on behalf/part of this letter on our company. | ||||||||||||
Thank you | ||||||||||||
For, | Sundar Technoligies Ltd | |||||||||||
Mr. Ronnie D'souza | ||||||||||||
General Manager - HR | ||||||||||||
Date: | Tuesday, August 09, 2022 | |||||||||||
Employee Photo | ||||||||||||
Salary Certificate | to apply for a personal loan | |||||||||||
TO WHOM IT MAY CONCERN | ||||||||||||
This is to certify that | Ms Bijal Pande | is working | ||||||||||
with our organization in our | Development | department as | Graphic Designer | |||||||||
posted at | Pune | location. | ||||||||||
Employee ID: | AS2102 | . | ||||||||||
Current Monthly Salary: | ₹ 2,800 | |||||||||||
Annual CTC: | ₹ 180,000 | |||||||||||
The above-mentioned details are correct as per our records. We are | ||||||||||||
issuing this letter on specific request of the employee without accepting any liability | ||||||||||||
on behalf/part of this letter on our company. | ||||||||||||
Thank you | ||||||||||||
For, | Sundar Technoligies Ltd | |||||||||||
Mr. Ronnie D'souza | ||||||||||||
General Manager - HR | ||||||||||||
Company Logo | Sundar Technoligies Ltd | |||||||||||
123, Elite Enclave, Cybercity, Magarpatta - Pune | ||||||||||||
Phone: 020-7896543 Email: Info@STL.com | ||||||||||||
Date: | Tuesday, August 09, 2022 | |||||||||||
Salary Certificate | to apply for a personal loan | |||||||||||
TO WHOM IT MAY CONCERN | ||||||||||||
This is to certify that | Ms Bijal Pande | is working | ||||||||||
with our organization in our | Development | department as | Graphic Designer | |||||||||
posted at | Pune | location. | ||||||||||
Employee ID: | AS2102 | . | ||||||||||
Current Monthly Salary: | ₹ 2,800 | |||||||||||
Annual CTC: | ₹ 180,000 | |||||||||||
The above-mentioned details are correct as per our records. We are | ||||||||||||
issuing this letter on specific request of the employee without accepting any liability | ||||||||||||
on behalf/part of this letter on our company. | ||||||||||||
Thank you | ||||||||||||
For, | Sundar Technoligies Ltd | |||||||||||
Mr. Ronnie D'souza | ||||||||||||
General Manager - HR | ||||||||||||
Date: | Tuesday, August 09, 2022 | |||||||||||
Salary Certificate | to apply for a personal loan | |||||||||||
TO WHOM IT MAY CONCERN | ||||||||||||
This is to certify that | Ms Bijal Pande | is working | ||||||||||
with our organization in our | Development | department as | Graphic Designer | |||||||||
posted at | Pune | location. | ||||||||||
Employee ID: | AS2102 | . | ||||||||||
Current Monthly Salary: | ₹ 2,800 | |||||||||||
Annual CTC: | ₹ 180,000 | |||||||||||
The above-mentioned details are correct as per our records. We are | ||||||||||||
issuing this letter on specific request of the employee without accepting any liability | ||||||||||||
on behalf/part of this letter on our company. | ||||||||||||
Thank you | ||||||||||||
For, | Sundar Technoligies Ltd | |||||||||||
Mr. Ronnie D'souza | ||||||||||||
General Manager - HR |
no reviews yet
Please Login to review.