Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Authentication
digital resources
257x 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.
