Scribd
Upload
62 views4 pages

Calc

The documents contain payroll information for multiple employees including earnings from basic pay, allowances and deductions. The details include amounts for PF contribution, tax deducted, net salary and totals. Another document provides projected salary figures over multiple years with increments.

Uploaded by

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

Calc

The documents contain payroll information for multiple employees including earnings from basic pay, allowances and deductions. The details include amounts for PF contribution, tax deducted, net salary and totals. Another document provides projected salary figures over multiple years with increments.

Uploaded by

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

Paid Unpaid

38050 18369 19681 EPF 2204


19030 9187 9843 EPF 954
6500 3138 3362 EPS 1250
19999 9655 10344 Superannuation 5754
31705 15306 16399 0
4566 2204 2362 Tax 6500
3170 1530 1640
0 0 0
6675 3222 3453
3805 1836 1969

129695 62611 67084 16662 45949

133500 64447 69053


67084 113033

Total Superannuation 50257


Total Tax Deducted 105423

155680
basic 34,138.00
House Rent Allowance 17,069.00
Special Allowance 8,897.00
Conveyance 1,252.00 48415
Other Allowance 372 90000 35100
Medical Allowance 1,707.00 94500 36855
Uniform Allowance 455 99225 38698
Superannuation Allowance 5,121.00 104186.25 40633
Pre-Employment Medical Test 5,000.00 109395.5625 42664
Total 74,011.00
PF Contri 4097
Net Salary 69,914
basic 90,000 1,080,000
House Rent Allowance 45,000 540,000
Special Allowance 23,457 281,484
Conveyance 3,300 39,600
469615 Other Allowance 980 11,760
442260 950618 Medical Allowance 4,500 54,000
464373 1493417 Uniform Allowance 1,200 14,400
487592 2104216 PF Employee 10,800 129,600
511971 2789785 Superannuation Allowance 13,500 162,000
LTA 11,250 135,000
2375811 413974 Exgratia 180 2,160
Short Notice Compensation 28,538 0
Travel Expense 6,178 0

204,167 2,450,004

PF Employee 10,800 129,600


PF Employer 10,800 129,600
Superannuation Allowance 13,500 162,000
LTA 11,250 135,000
Exgratia 180 2,160
Total 46,530 558,360

157,637 1,891,644

46,350 556,200
Mar-24 Apr-24 25-26
97,200 90,000 90,000 97,200 104,976 113,374
48,600 45,000 45,000 48,600 52,488 56,687
25,334 23,457 23,457 25,334 27,360 29,549
3,564 3,300 3,300 3,564 3,849 4,157
1,058 980 980 1,058 1,143 1,235
4,860 4,500 4,500 4,860 5,249 5,669
1,296 1,200 1,200 1,296 1,400 1,512
11,664 0 10,800 11,664 12,597 13,605
14,580 13,500 13,500 14,580 15,746 17,006
12,150 6,750 11,250 12,150 13,122 14,172
0 0 180 194 210 227
0
0

220,306 188,687 204,167 220,500 238,140 257,192


208,642 177,887 2,450,004 2,646,004 2,857,685 3,086,299
196,000 211,680 228,615 636,295
10,800 10,800 11,664 12,597 13,605
10,800 11,664 12,597 13,605
11,664 13,500 14,580 15,746 17,006
12,150 11,250 11,250 12,150 13,122 14,172
191 180 180 194 210 227
24,005 22,230 46,530 50,252 54,273 58,614

244,311 210,917 157,637 170,248 183,868 198,577

9,458 113,499 35,100 46,350 50,058 54,063 58,388

You might also like