Scribd
Upload
68 views2 pages

Emp Monthly Pay Slip

The document contains a payroll list for employees including their ID, name, designation, date of joining, basic pay, and various allowances and deductions. It outlines the formulas for calculating total earnings, total deductions, and net salary. Additionally, it provides instructions for data validation and lookup functions in a spreadsheet format.

Uploaded by

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

Emp Monthly Pay Slip

The document contains a payroll list for employees including their ID, name, designation, date of joining, basic pay, and various allowances and deductions. It outlines the formulas for calculating total earnings, total deductions, and net salary. Additionally, it provides instructions for data validation and lookup functions in a spreadsheet format.

Uploaded by

chakrabortybittu642
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

EMP ID EMP NAME DESIGNATION DATE BASIC PAY DA HRA TA OVERTIME PF E.S.

I LOAN TAX NET SALARY


G001 tanmoy pal teacher 01-01-2023 25000 2500 2000
G002 somnath das driver 02-01-2023 12000 2100 3000
G003 rohit das carpenter 03-01-2023 10300 1700 1500
EMP ID EMP NAME
G004 pritam sarkar supervisor 04-01-2023 21000 2600 1900
G005 DESIGNATION
rahul nath teacher 05-01-2023 DATE
31000 1900 2000
G006 payel sarkar carpenter 06-01-2023 14500 700 3000
G007 soma pal accountent 07-01-2023 29500 1200 1700
G008 sujoy saha EARNING
watchman 08-01-2023 11200 DEDUCTION 1560 1500
G009 shibani BASIC
roy PAY
reciptonist 09-01-2023 PF
14500 2400 2500
G010 DA
ratul halder accountent 10-01-2023 ESI
29700 2900 2100
HRA LOAN
DA: TA TAX =BASIC*30% ENTER
HRA: OVERTIME =BASIC*30% ENTER
TA: TOTAL EARNING TOTAL DEDUCTION =BASIC*30% ENTER
PF: =BASIC*30% ENTER
NET SALARY
E.S.I: =PF/2 ENTER
TAX: =BASIC*2% ENTER
NET SALARY: =(BASIC+DA+HRA+TA+OVERTIME)-(PF+ESI+LOAN+TAX) ENTER
EMP ID:
Select cell>data menu>data validation>allow>list>scourse (select emp id list)>ok

EMP NAME,DESIGNATION,DATE,BASIC PAY,DA,HRA,TA,OVER TIME,PF,ESI,LOAN,TAX:


=Vlookup(lookup value,table array,col_index number,zero)enter

TOTAL EARNING: =sum(basic:overtime)enter


TOTAL DEDUCTION: =sum(pf:tax)enter
NET SALARY: =total earning-total deduction enter

You might also like