Scribd
Upload
4 views1 page

Excel

The document provides a payroll summary for employees, including details such as Employee ID, Name, Basic Pay, various allowances, Income Tax, Provident Fund, Gross Pay, and Net Pay. Each employee's financial information is listed, showing their earnings and deductions. The data covers a range of salaries and allowances for a total of 15 employees.

Uploaded by

saumyatanugantait
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Excel

The document provides a payroll summary for employees, including details such as Employee ID, Name, Basic Pay, various allowances, Income Tax, Provident Fund, Gross Pay, and Net Pay. Each employee's financial information is listed, showing their earnings and deductions. The data covers a range of salaries and allowances for a total of 15 employees.

Uploaded by

saumyatanugantait
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Employee ID Employee Name Basic Pay(BP) Travlling Allowance (TA) Deraness Allowance(DA) Houce Rent Allowence(HRA) Incam Tax

nt Allowence(HRA) Incam Tax (IT) Provide Found(PF) Gross Pay(GP) Net Pay(NP)
1001 Soham 25000 4375 7500 5000 3750 3125 41875 35000
1002 Sandip 50000 8750 15000 10000 7500 6250 83750 70000
1003 Subhadip 24000 4200 7200 4800 3600 3000 40200 33600
1004 KALIPADA 20000 3500 6000 4000 3000 2500 33500 28000
1005 Kalinath 15000 2625 4500 3000 2250 1875 25125 21000
1006 Sudip 30000 5250 9000 6000 4500 3750 50250 42000
1007 Nilanjon 50000 8750 15000 10000 7500 6250 83750 70000
1008 Sumanta 20000 3500 6000 4000 3000 2500 33500 28000
1009 Sougata 22000 3850 6600 4400 3300 2750 36850 30800
1010 Abhalash 35000 6125 10500 7000 5250 4375 58625 49000
1011 Abhasek 40000 7000 12000 8000 6000 5000 67000 56000
1012 Abhijit 33000 5775 9900 6600 4950 4125 55275 46200
1013 Aniket 25000 4375 7500 5000 3750 3125 41875 35000
1014 Arpan 35000 6125 10500 7000 5250 4375 58625 49000
1015 Saumya 40000 7000 12000 8000 6000 5000 67000 56000

You might also like