Income Tax Calculation Sheet FY 2021-2022

[July 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000819 | 000012 | 000014 | 000117 | 000148 | 000116 | 000218 | 000301 | 000015 | 000036 | 000473 | 000038 | 000696 | 000286 | 000809 | 800003 | 800004 | 800005 Monthly basic Salary | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Jul'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Aug'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Sep'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Oct'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Nov'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Dec'19 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 16878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Jan'20 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 20878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Feb'20 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 20878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Mar'20 | 38,380 | 25,846 | 57,874 | 51,033 | 44,562 | 131,121 | 111,601 | 30,204 | 37700 | 23252 | 22706 | 17788 | 17788 | 20878 | 15927 | 14600 | 14545 | 18700 | 16125 | 15394 | 14689 Apr'20 | 42,218 | 27,138 | 63,661 | 53,585 | 49,018 | 137,677 | 117,181 | 31,714 | 41470 | 24415 | 23841 | 18677 | 19567 | 20878 | 17520 | 15330 | 16000 | 19635 | 16931 | 16164 | 15423 May'20 | 42,218 | 27,138 | 63,661 | 53,585 | 49,018 | 137,677 | 117,181 | 31,714 | 41470 | 24415 | 23841 | 18677 | 19567 | 20878 | 17520 | 15330 | 16000 | 19635 | 16931 | 16164 | 15423 Jun'20 | 42,218 | 27,138 | 63,661 | 53,585 | 49,018 | 137,677 | 117,181 | 31,714 | 41470 | 24415 | 23841 | 18677 | 19567 | 20878 | 17520 | 15330 | 16000 | 19635 | 16931 | 16164 | 15423 | 788,043 Basic Salary yearly | 472,074 | 209,352 | 711,849 | 620,052 | 548,112 | 1,593,120 | 1,355,952 | 366,978 | 463,710 | 282,513 | 275,877 | 216,123 | 218,793 | 226,536 | 195,903 | 177,390 | 178,905 | 227,205 | 195,918 | 187,038 | 178,470 | 8,901,870 House rent | 236,037 | 104,676 | 355,926 | 310,032 | 274,056 | 796,566 | 677,982 | 183,489 | 231,855 | 141,258 | 137,940 | 108,063 | 109,398 | 113,268 | 97,956 | 88,695 | 89,457 | 113,604 | 97,965 | 93,519 | 89,241 | 4,450,983 Less: exemption, A | (236,037) | (104,676) | (300,000) | (300,000) | (274,056) | (300,000) | (300,000) | (183,489) | (231,855) | (141,258) | (137,940) | (108,063) | (109,398) | (113,268) | (97,956) | (88,695) | (89,457) | (113,604) | (97,965) | (93,519) | (89,241) Medical allowance | 16,675 | 10,875 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 | 16,675 Less: exemption, B | (16,675) | (10,875) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) | (16,675) Telephone | 24,000 | 12,000 | 24,000 | 24,000 | 24,000 | 36,000 | 36,000 | 18,000 | 24,000 | 18,000 | 12,000 | 12,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 6,000 | 0 | 0 | 0 Less: exemption Conveyance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28,135 | 0 | 10,710 | 9,720 | 24,848 | 6,230 | 16,640 | 7,020 | 7,020 | 27,280 | 0 | 10,800 | 10,650 | 10,500 | 169,553 Less: exemption, C | - | - | - | - | - | - | - | (28,135) | - | (10,710) | (9,720) | (24,848) | (6,230) | (16,640) | (7,020) | (7,020) | (27,280) | - | (10,800) | (10,650) | (10,500) Bonus | 80,598 | 52,984 | 121,535 | 104,618 | 93,580 | 268,798 | 228,782 | 61,918 | 79,170 | 47,667 | 46,547 | 36,465 | 37,355 | 37,756 | 33,447 | 29,930 | 30,545 | 38,335 | 33,056 | 31,558 | 30,112 | 1,524,756 Overtime & deduction | 70,619 | 151,824 | 51,190 | (44,232) | 32,537 | 137,125 | 59,491 | 68,421 | 36,796 | 40,191 | 63,157 | 53,038 | 72,240 | 26,828 | 41,816 | 33,689 | 63,728 | (11,784) | 111,085 | 123,391 | 91,557 | 1,272,707 Provident Fund(July'19~June'20) | 3,517 | 2,153 | 5,303 | 4,464 | 4,083 | 11,468 | 9,761 | 2,642 | 3,454 | 2,034 | 1,986 | 1,556 | 1,630 | 1,739 | 1,459 | 1,277 | 1,333 | 1,636 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 10 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 39,324 | 17,332 | 59,298 | 43,149 | 45,657 | 132,702 | 112,947 | 30,570 | 38,622 | 23,535 | 22,977 | 18,006 | 18,228 | 18,870 | 16,320 | 14,775 | 14,907 | 18,930 | 16,317 | 15,576 | 14,871 | 732,913 Taxable income | 686,615 | 443,492 | 1,023,798 | 757,619 | 743,886 | 2,664,311 | 2,171,154 | 545,887 | 642,298 | 411,906 | 420,558 | 335,632 | 358,616 | 327,990 | 299,486 | 267,784 | 294,085 | 278,686 | 356,376 | 357,563 | 315,010 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,675 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 1,782 | 2,931 | 1,400 | (26) | (1,611) | (296) | (1,066) | 2,819 | 2,878 | 751 300,000 | 10% | 28,662 | - | 30,000 | 30,000 | 30,000 | 30,000 | 30,000 | 14,589 | 24,230 | 1,191 | 2,056 | - | - | - | - | - | - | - | - | - | - 400,000 | 15% | - | - | 48,570 | 1,143 | 6,583 | 60,000 | 60,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - 500,000 | 20% | - | - | - | - | - | 100,000 | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | - | 266,078 | 142,789 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 33,662 | 4,675 | 83,570 | 36,143 | 41,583 | 461,078 | 337,789 | 19,589 | 29,230 | 6,191 | 7,056 | 1,782 | 2,931 | 1,400 | (26) | (1,611) | (296) | (1,066) | 2,819 | 2,878 | 751 Allowable Investment 25% of Total Income | 171,654 | 110,873 | 255,950 | 189,405 | 185,972 | 666,078 | 542,789 | 136,472 | 160,575 | 102,977 | 105,140 | 83,908 | 89,654 | 81,998 | 74,872 | 66,946 | 73,521 | 69,672 | 89,094 | 89,391 | 78,753 Less: Investment Allowance, D | (25,748) | (16,631) | (38,392) | (28,411) | (27,896) | (66,608) | (54,279) | (20,471) | (24,086) | (15,446) | (15,771) | (12,586) | (13,448) | (12,300) | (11,231) | (10,042) | (11,028) | (10,451) | (13,364) | (13,409) | (11,813) Net Tax liability | 7,913 | (11,956) | 45,177 | 7,732 | 13,687 | 394,470 | 283,510 | (882) | 5,144 | (9,256) | (8,715) | (10,805) | (10,517) | (10,900) | (11,256) | (11,653) | (11,324) | (11,516) | (10,545) | (10,530) | (11,062) Net/ Minimum Tax liability | 7,913 | 4,000 | 45,177 | 7,732 | 13,687 | 394,470 | 283,510 | 4,000 | 5,144 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 797,633 Monthly tax deduction (avg. rate) | 659 | 333 | 3765 | 644 | 1141 | 32872 | 23626 | 333 | 429 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 Tax to be paid for July, 2020 | 659 | 333 | 3,765 | 644 | 1,141 | 32,872 | 23,626 | 333 | 429 | 333 | 333 | 333 | 333 | 333 | - | - | - | - | 333 | 333 | 333 | 66,466 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [August 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001218 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 41033 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 Sep'20 Oct'20 Nov'20 Dec'20 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 492,396 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,822,152 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 246,198 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,411,076 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (246,198) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 Less: exemption Conveyance | 0 | 0 | 0 | 0 | 0 | 24,848 | 6,230 | 7,020 | 7,020 | 0 | 0 | 28,135 | 10,710 | 27,280 | 9,720 | 16,640 | 7,020 | 7,020 | 0 | 0 | 10,800 | 10,800 | 10,800 | 10,800 | 10,650 | 10,500 | 215,993 Less: exemption, C | - | - | - | - | - | (24,848) | (6,230) | (7,020) | (7,020) | - | - | (28,135) | (10,710) | (27,280) | (9,720) | (16,640) | (7,020) | (7,020) | - | - | (10,800) | (10,800) | (10,800) | (10,800) | (10,650) | (10,500) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 82,066 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,803,692 Overtime & deduction | 800 | 28,693 | 0 | 0 | 0 | 0 | 0 | (161) | (84) | 0 | 0 | 0 | 0 | 0 | (315) | 3,713 | 0 | (152) | (45) | 0 | (80) | (11) | 3,853 | (1,029) | 2,127 | 1,388 | 38,697 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | - | - | - | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | - | - | - | 16,920 | 16,152 | 15,420 | 802,780 Taxable income | 658,056 | 444,713 | 1,060,856 | 759,248 | 2,627,156 | 292,150 | 305,498 | 248,439 | 274,704 | 646,028 | 2,196,752 | 493,700 | 384,218 | 245,996 | 369,291 | 334,873 | 264,942 | 241,792 | 300,477 | 840,340 | 598,382 | 293,789 | 302,315 | 252,925 | 244,575 | 232,730 | 14,913,945 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,736 | 5,000 | 5,000 | 5,000 | - | 275 | - | - | 5,000 | 5,000 | 5,000 | 4,211 | - | 3,465 | 1,744 | - | - | 24 | 5,000 | 5,000 | - | 116 | - | - | - 300,000 | 10% | 25,806 | - | 30,000 | 30,000 | 30,000 | - | - | - | - | 24,603 | 30,000 | 9,370 | - | - | - | - | - | - | - | 30,000 | 19,838 | - | - | - | - | - 400,000 | 15% | - | - | 54,128 | 8,887 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 13,551 | - | - | - | - | - | - 500,000 | 20% | - | - | - | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 256,789 | - | - | - | - | - | 149,188 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 30,806 | 4,736 | 89,128 | 43,887 | 451,789 | - | 275 | - | - | 29,603 | 344,188 | 14,370 | 4,211 | - | 3,465 | 1,744 | - | - | 24 | 48,551 | 24,838 | - | 116 | - | - | - Allowable Investment 25% of Total Income | 164,514 | 111,178 | 265,214 | 189,812 | 656,789 | 73,038 | 76,375 | 62,110 | 68,676 | 161,507 | 549,188 | 123,425 | 96,055 | 61,499 | 92,323 | 83,718 | 66,236 | 60,448 | 75,119 | 210,085 | 149,596 | 73,447 | 75,579 | 63,231 | 61,144 | 58,183 Less: Investment Allowance, D | (24,677) | (16,677) | (39,782) | (28,472) | (65,679) | (10,956) | (11,456) | (9,316) | (10,301) | (24,226) | (54,919) | (18,514) | (14,408) | (9,225) | (13,848) | (12,558) | (9,935) | (9,067) | (11,268) | (31,513) | (22,439) | (11,017) | (11,337) | (9,485) | (9,172) | (8,727) Net Tax liability | 6,129 | (11,941) | 49,346 | 15,415 | 386,110 | (10,956) | (11,181) | (9,316) | (10,301) | 5,377 | 289,269 | (4,144) | (10,197) | (9,225) | (10,384) | (10,814) | (9,935) | (9,067) | (11,244) | 17,038 | 2,399 | (11,017) | (11,221) | (9,485) | (9,172) | (8,727) Net/ Minimum Tax liability | 6,129 | 4,000 | 49,346 | 15,415 | 386,110 | - | 4,000 | 5,377 | 289,269 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 17,038 | 4,000 | - | 4,000 | - | - | - | 804,685 Monthly tax deduction (avg. rate) | 511 | 333 | 4112 | 1285 | 32176 | 0 | 333 | 448 | 24106 | 333 | 333 | 333 | 333 | 1420 | 333 | 0 | 333 | 0 | 0 | 0 Tax already paid on July 2020 | 659 | 333 | 3765 | 1141 | 32872 | 333 | 333 | 429 | 23626 | 333 | 333 | 333 | 333 | 644 | 0 | 0 | 0 | 333 | 333 | 333 | 66,466 Tax to be paid for August, 2020 | 497 | 333 | 4,144 | 1,298 | 32,113 | - | 333 | - | - | 450 | 24,149 | 333 | 333 | - | 333 | 333 | - | - | 364 | 1,490 | 364 | - | 364 | - | - | - | 67,231 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [September 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001218 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 41033 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 41033 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 Oct'20 Nov'20 Dec'20 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 492,396 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,822,152 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 246,198 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,411,076 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (246,198) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 414,000 Less: exemption Conveyance | 0 | 0 | 0 | 0 | 0 | 19,980 | 6,660 | 6,120 | 6,660 | 0 | 0 | 22,200 | 6,300 | 24,420 | 8,880 | 8,160 | 6,660 | 5,940 | 0 | 0 | 0 | 24,420 | 8,880 | 8,100 | 11,100 | 11,100 | 185,580 Less: exemption, C | - | - | - | - | - | (19,980) | (6,660) | (6,120) | (6,660) | - | - | (22,200) | (6,300) | (24,420) | (8,880) | (8,160) | (6,660) | (5,940) | - | - | - | (24,420) | (8,880) | (8,100) | (11,100) | (11,100) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 82,066 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,803,692 Overtime & deduction | 1,800 | 29,332 | 0 | 0 | 0 | 1,386 | 1,679 | 639 | 975 | 0 | 0 | 1,349 | 613 | 1,600 | 1,485 | 9,012 | 1,706 | 496 | 192 | (3,572) | (12,444) | 1,477 | 10,461 | 608 | 9,531 | 4,185 | 62,510 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | - | - | - | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | - | - | - | 16,920 | 16,152 | 15,420 | 802,780 Taxable income | 659,056 | 445,352 | 1,060,856 | 759,248 | 2,627,156 | 293,536 | 307,177 | 249,239 | 275,763 | 646,028 | 2,196,752 | 495,049 | 384,831 | 247,596 | 371,091 | 340,172 | 266,648 | 242,440 | 300,714 | 836,768 | 586,018 | 295,277 | 308,923 | 254,562 | 251,979 | 235,527 | 14,937,758 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,768 | 5,000 | 5,000 | 5,000 | - | 359 | - | - | 5,000 | 5,000 | 5,000 | 4,242 | - | 3,555 | 2,009 | - | - | 36 | 5,000 | 5,000 | - | 446 | - | - | - 300,000 | 10% | 25,906 | - | 30,000 | 30,000 | 30,000 | - | - | - | - | 24,603 | 30,000 | 9,505 | - | - | - | - | - | - | - | 30,000 | 18,602 | - | - | - | - | - 400,000 | 15% | - | - | 54,128 | 8,887 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 13,015 | - | - | - | - | - | - 500,000 | 20% | - | - | - | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 256,789 | - | - | - | - | - | 149,188 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 30,906 | 4,768 | 89,128 | 43,887 | 451,789 | - | 359 | - | - | 29,603 | 344,188 | 14,505 | 4,242 | - | 3,555 | 2,009 | - | - | 36 | 48,015 | 23,602 | - | 446 | - | - | - Allowable Investment 25% of Total Income | 164,764 | 111,338 | 265,214 | 189,812 | 656,789 | 73,384 | 76,794 | 62,310 | 68,941 | 161,507 | 549,188 | 123,762 | 96,208 | 61,899 | 92,773 | 85,043 | 66,662 | 60,610 | 75,179 | 209,192 | 146,505 | 73,819 | 77,231 | 63,641 | 62,995 | 58,882 Less: Investment Allowance, D | (24,715) | (16,701) | (39,782) | (28,472) | (65,679) | (11,008) | (11,519) | (9,346) | (10,341) | (24,226) | (54,919) | (18,564) | (14,431) | (9,285) | (13,916) | (12,756) | (9,999) | (9,092) | (11,277) | (31,379) | (21,976) | (11,073) | (11,585) | (9,546) | (9,449) | (8,832) Net Tax liability | 6,191 | (11,933) | 49,346 | 15,415 | 386,110 | (11,008) | (11,160) | (9,346) | (10,341) | 5,377 | 289,269 | (4,059) | (10,190) | (9,285) | (10,361) | (10,748) | (9,999) | (9,092) | (11,241) | 16,636 | 1,626 | (11,073) | (11,138) | (9,546) | (9,449) | (8,832) Net/ Minimum Tax liability | 6,191 | 4,000 | 49,346 | 15,415 | 386,110 | - | 4,000 | 5,377 | 289,269 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 16,636 | 4,000 | - | 4,000 | - | - | - | 804,345 Monthly tax deduction (avg. rate) | 516 | 333 | 4112 | 1285 | 32176 | 0 | 333 | 448 | 24106 | 333 | 333 | 333 | 333 | 1386 | 333 | 0 | 333 | 0 | 0 | 0 Tax already paid on August 2020 | 1156 | 666 | 7909 | 2439 | 64985 | 333 | 666 | 0 | 0 | 879 | 47775 | 666 | 666 | 0 | 666 | 666 | 0 | 0 | 364 | 2134 | 364 | 0 | 364 | 333 | 333 | 333 | 133,697 Tax to be paid for September, 2020 | 504 | 333 | 4,144 | 1,298 | 32,113 | - | 333 | - | - | 450 | 24,149 | 333 | 333 | - | 333 | 333 | - | - | 364 | 1,450 | 364 | - | 364 | - | - | - | 67,198 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [October 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 Nov'20 Dec'20 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | 0 | 0 | 0 | 0 | 0 | 19,800 | 6,600 | 6,240 | 6,600 | 0 | 0 | 17,600 | 6,120 | 24,200 | 8,800 | 8,320 | 6,600 | 6,120 | 0 | 0 | 23,760 | 8,800 | 9,000 | 11,000 | 11,000 | 180,560 Less: exemption, C | - | - | - | - | - | (19,800) | (6,600) | (6,240) | (6,600) | - | - | (17,600) | (6,120) | (24,200) | (8,800) | (8,320) | (6,600) | (6,120) | - | - | (23,760) | (8,800) | (9,000) | (11,000) | (11,000) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 2,000 | 29,181 | 0 | 0 | 0 | 2,102 | 2,479 | 1,639 | 2,112 | 0 | 0 | 1,349 | 613 | 2,600 | 2,285 | 11,226 | 6,163 | 1,216 | 1,192 | (5,358) | 1,467 | 15,487 | 1,717 | 16,223 | 6,669 | 102,362 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | - | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 12 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | - | 16,920 | 16,152 | 15,420 | 819,190 Taxable income | 659,256 | 445,201 | 1,060,856 | 759,248 | 2,627,156 | 294,252 | 307,977 | 250,239 | 276,900 | 646,028 | 2,196,752 | 495,049 | 384,831 | 248,596 | 371,891 | 342,386 | 271,105 | 243,160 | 301,714 | 834,982 | 311,677 | 313,949 | 255,671 | 258,671 | 238,011 | 14,395,558 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,760 | 5,000 | 5,000 | 5,000 | - | 399 | - | - | 5,000 | 5,000 | 5,000 | 4,242 | - | 3,595 | 2,119 | - | - | 86 | 5,000 | 584 | 697 | - | - | - 300,000 | 10% | 25,926 | - | 30,000 | 30,000 | 30,000 | - | - | - | - | 24,603 | 30,000 | 9,505 | - | - | - | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 54,128 | 8,887 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 12,747 | - | - | - | - | - 500,000 | 20% | - | - | - | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 256,789 | - | - | - | - | - | 149,188 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 30,926 | 4,760 | 89,128 | 43,887 | 451,789 | - | 399 | - | - | 29,603 | 344,188 | 14,505 | 4,242 | - | 3,595 | 2,119 | - | - | 86 | 47,747 | 584 | 697 | - | - | - Allowable Investment 25% of Total Income | 164,814 | 111,300 | 265,214 | 189,812 | 656,789 | 73,563 | 76,994 | 62,560 | 69,225 | 161,507 | 549,188 | 123,762 | 96,208 | 62,149 | 92,973 | 85,597 | 67,776 | 60,790 | 75,429 | 208,746 | 77,919 | 78,487 | 63,918 | 64,668 | 59,503 Less: Investment Allowance, D | (24,722) | (16,695) | (39,782) | (28,472) | (65,679) | (11,034) | (11,549) | (9,384) | (10,384) | (24,226) | (54,919) | (18,564) | (14,431) | (9,322) | (13,946) | (12,839) | (10,166) | (9,119) | (11,314) | (31,312) | (11,688) | (11,773) | (9,588) | (9,700) | (8,925) Net Tax liability | 6,204 | (11,935) | 49,346 | 15,415 | 386,110 | (11,034) | (11,150) | (9,384) | (10,384) | 5,377 | 289,269 | (4,059) | (10,190) | (9,322) | (10,351) | (10,720) | (10,166) | (9,119) | (11,229) | 16,435 | (11,104) | (11,076) | (9,588) | (9,700) | (8,925) Net/ Minimum Tax liability | 6,204 | 4,000 | 49,346 | 15,415 | 386,110 | - | 4,000 | 5,377 | 289,269 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 16,435 | 4,000 | 4,000 | - | - | - | 804,157 Monthly tax deduction (avg. rate) | 517 | 333 | 4112 | 1285 | 32176 | 0 | 333 | 448 | 24106 | 333 | 333 | 333 | 333 | 1370 | 333 | 333 | 0 | 0 | 0 Tax already paid on September 2020 | 1660 | 999 | 12053 | 3737 | 97098 | 333 | 999 | 0 | 0 | 1329 | 71924 | 999 | 999 | 0 | 999 | 999 | 0 | 0 | 728 | 3584 | 0 | 0 | 333 | 333 | 333 | 199,439 Tax to be paid for October, 2020 | 505 | 333 | 4,144 | 1,298 | 32,112 | - | 333 | - | - | 450 | 24,149 | 333 | 333 | - | 333 | 333 | - | - | 364 | 1,428 | 444 | 444 | - | - | - | 67,336 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [November 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 Dec'20 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 21,060 | 7,290 | 7,020 | 7,290 | - | - | 19,500 | 6,930 | 26,070 | 9,720 | 8,760 | 7,290 | 6,660 | 0 | 0 | 26,070 | 9,720 | 10,650 | 9,000 | 12,150 | 195,180 Less: exemption, C | - | - | - | - | - | (21,060) | (7,290) | (7,020) | (7,290) | - | - | (19,500) | (6,930) | (26,070) | (9,720) | (8,760) | (7,290) | (6,660) | - | - | (26,070) | (9,720) | (10,650) | (9,000) | (12,150) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 2,400 | 29,117 | 0 | 0 | 0 | 3,539 | 4,032 | 2,439 | 4,043 | 0 | 0 | 1,041 | 1,413 | 2,317 | 3,085 | 10,761 | 7,674 | (203) | 813 | (4,985) | 1,467 | 20,525 | 2,959 | 14,990 | 16,419 | 123,846 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 659,656 | 445,137 | 1,060,856 | 759,248 | 2,627,156 | 295,689 | 309,530 | 251,039 | 278,831 | 646,028 | 2,196,752 | 494,741 | 385,631 | 248,313 | 372,691 | 341,921 | 272,616 | 241,741 | 301,335 | 835,355 | 311,677 | 334,008 | 256,913 | 257,438 | 247,761 | 14,432,063 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,757 | 5,000 | 5,000 | 5,000 | - | 477 | - | - | 5,000 | 5,000 | 5,000 | 4,282 | - | 3,635 | 2,096 | - | - | 67 | 5,000 | 584 | 1,700 | - | - | - 300,000 | 10% | 25,966 | - | 30,000 | 30,000 | 30,000 | - | - | - | - | 24,603 | 30,000 | 9,474 | - | - | - | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 54,128 | 8,887 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 12,803 | - | - | - | - | - 500,000 | 20% | - | - | - | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 256,789 | - | - | - | - | - | 149,188 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 30,966 | 4,757 | 89,128 | 43,887 | 451,789 | - | 477 | - | - | 29,603 | 344,188 | 14,474 | 4,282 | - | 3,635 | 2,096 | - | - | 67 | 47,803 | 584 | 1,700 | - | - | - Allowable Investment 25% of Total Income | 164,914 | 111,284 | 265,214 | 189,812 | 656,789 | 73,922 | 77,383 | 62,760 | 69,708 | 161,507 | 549,188 | 123,685 | 96,408 | 62,078 | 93,173 | 85,480 | 68,154 | 60,435 | 75,334 | 208,839 | 77,919 | 83,502 | 64,228 | 64,360 | 61,940 Less: Investment Allowance, D | (24,737) | (16,693) | (39,782) | (28,472) | (65,679) | (11,088) | (11,607) | (9,414) | (10,456) | (24,226) | (54,919) | (18,553) | (14,461) | (9,312) | (13,976) | (12,822) | (10,223) | (9,065) | (11,300) | (31,326) | (11,688) | (12,525) | (9,634) | (9,654) | (9,291) Net Tax liability | 6,229 | (11,936) | 49,346 | 15,415 | 386,110 | (11,088) | (11,131) | (9,414) | (10,456) | 5,377 | 289,269 | (4,079) | (10,180) | (9,312) | (10,341) | (10,726) | (10,223) | (9,065) | (11,233) | 16,477 | (11,104) | (10,825) | (9,634) | (9,654) | (9,291) Net/ Minimum Tax liability | 6,229 | 4,000 | 49,346 | 15,415 | 386,110 | - | 4,000 | 5,377 | 289,269 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 16,477 | 4,000 | 4,000 | - | - | - | 804,224 Monthly tax deduction (avg. rate) | 519 | 333 | 4112 | 1285 | 32176 | 0 | 333 | 448 | 24106 | 333 | 333 | - | 333 | 333 | - | - | 1373 | 333 | 333 | - | - | - Tax already paid till October 2020 | 2165 | 1332 | 16197 | 5035 | 129210 | 333 | 1332 | 0 | 0 | 1779 | 96073 | 1332 | 1332 | 0 | 1332 | 1332 | 0 | 0 | 1092 | 5012 | 444 | 444 | 333 | 333 | 333 | 266,775 Tax to be paid for November, 2020 | 508 | 334 | 4,144 | 1,298 | 32,113 | - | 334 | - | - | 450 | 24,150 | 334 | 334 | - | 334 | 334 | - | - | 364 | 1,433 | 445 | 445 | - | - | - | 67,354 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [December 2020] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 22,248 | 7,632 | 7,272 | 7,632 | - | - | 21,360 | 7,344 | 27,456 | 9,984 | 8,928 | 7,488 | 7,128 | 0 | 0 | 27,456 | 10,176 | 11,160 | 10,200 | 12,240 | 205,704 Less: exemption, C | - | - | - | - | - | (22,248) | (7,632) | (7,272) | (7,632) | - | - | (21,360) | (7,344) | (27,456) | (9,984) | (8,928) | (7,488) | (7,128) | - | - | (27,456) | (10,176) | (11,160) | (10,200) | (12,240) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 2,800 | 30,117 | 0 | 0 | 0 | 4,144 | 4,832 | 2,439 | 5,517 | 0 | 0 | 942 | 2,213 | 3,109 | 3,085 | 12,544 | 7,774 | 597 | 1,813 | (1,358) | 2,267 | 36,206 | 7,448 | 26,738 | 19,948 | 173,175 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 660,056 | 446,137 | 1,060,856 | 759,248 | 2,627,156 | 296,294 | 310,330 | 251,039 | 280,305 | 646,028 | 2,196,752 | 494,642 | 386,431 | 249,105 | 372,691 | 343,704 | 272,716 | 242,541 | 302,335 | 838,982 | 312,477 | 349,689 | 261,402 | 269,186 | 251,290 | 14,481,392 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 4,807 | 5,000 | 5,000 | 5,000 | - | 517 | - | - | 5,000 | 5,000 | 5,000 | 4,322 | - | 3,635 | 2,185 | - | - | 117 | 5,000 | 624 | 2,484 | - | - | - 300,000 | 10% | 26,006 | - | 30,000 | 30,000 | 30,000 | - | - | - | - | 24,603 | 30,000 | 9,464 | - | - | - | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 54,128 | 8,887 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 13,347 | - | - | - | - | - 500,000 | 20% | - | - | - | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 256,789 | - | - | - | - | - | 149,188 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 31,006 | 4,807 | 89,128 | 43,887 | 451,789 | - | 517 | - | - | 29,603 | 344,188 | 14,464 | 4,322 | - | 3,635 | 2,185 | - | - | 117 | 48,347 | 624 | 2,484 | - | - | - Allowable Investment 25% of Total Income | 165,014 | 111,534 | 265,214 | 189,812 | 656,789 | 74,074 | 77,583 | 62,760 | 70,076 | 161,507 | 549,188 | 123,661 | 96,608 | 62,276 | 93,173 | 85,926 | 68,179 | 60,635 | 75,584 | 209,746 | 78,119 | 87,422 | 65,351 | 67,297 | 62,823 Less: Investment Allowance, D | (24,752) | (16,730) | (39,782) | (28,472) | (65,679) | (11,111) | (11,637) | (9,414) | (10,511) | (24,226) | (54,919) | (18,549) | (14,491) | (9,341) | (13,976) | (12,889) | (10,227) | (9,095) | (11,338) | (31,462) | (11,718) | (13,113) | (9,803) | (10,094) | (9,423) Net Tax liability | 6,254 | (11,923) | 49,346 | 15,415 | 386,110 | (11,111) | (11,121) | (9,414) | (10,511) | 5,377 | 289,269 | (4,085) | (10,170) | (9,341) | (10,341) | (10,704) | (10,227) | (9,095) | (11,221) | 16,885 | (11,094) | (10,629) | (9,803) | (10,094) | (9,423) Net/ Minimum Tax liability | 6,254 | 4,000 | 49,346 | 15,415 | 386,110 | - | 4,000 | 5,377 | 289,269 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 16,885 | 4,000 | 4,000 | - | - | - | 804,657 Monthly tax deduction (avg. rate) | 521 | 333 | 4112 | 1285 | 32176 | 0 | 333 | 448 | 24106 | 333 | 333 | - | 333 | 333 | - | - | 1407 | 333 | 333 | - | - | - Tax already paid till November 2020 | 2673 | 1666 | 20341 | 6333 | 161323 | 333 | 1666 | 0 | 0 | 2229 | 120223 | 1666 | 1666 | 0 | 1666 | 1666 | 0 | 0 | 1456 | 6445 | 889 | 889 | 333 | 333 | 333 | 334,129 Tax to be paid for December, 2020 | 512 | 333 | 4,144 | 1,297 | 32,112 | - | 333 | - | - | 450 | 24,149 | 333 | 333 | - | 333 | 333 | - | - | 363 | 1,491 | 444 | 444 | - | - | - | 67,404 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [January 2021] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Jan'21 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 22,860 | 7,800 | 7,500 | 7,680 | - | - | 22,400 | 7,380 | 28,160 | 10,240 | 9,280 | 7,620 | 6,960 | 0 | 0 | 27,280 | 10,080 | 11,700 | 10,700 | 12,600 | 210,240 Less: exemption, C | - | - | - | - | - | (22,860) | (7,800) | (7,500) | (7,680) | - | - | (22,400) | (7,380) | (28,160) | (10,240) | (9,280) | (7,620) | (6,960) | - | - | (27,280) | (10,080) | (11,700) | (10,700) | (12,600) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 38,255 | 58,836 | 60,188 | 40,344 | 111,902 | 22,851 | 28,810 | 19,402 | 24,883 | 36,886 | 117,366 | 17,174 | 29,003 | 21,817 | 28,846 | 25,943 | 10,412 | 27,142 | 18,527 | 4,079 | 2,267 | 39,288 | 14,463 | 34,324 | 31,440 | 864,448 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 695,511 | 474,856 | 1,121,044 | 799,592 | 2,739,058 | 315,001 | 334,308 | 268,002 | 299,671 | 682,914 | 2,314,118 | 510,874 | 413,221 | 267,813 | 398,452 | 357,103 | 275,354 | 269,086 | 319,049 | 844,419 | 312,477 | 352,771 | 268,417 | 276,772 | 262,782 | 15,172,665 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 750 | 1,715 | - | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 4,923 | 2,855 | - | - | 952 | 5,000 | 624 | 2,639 | - | - | - 300,000 | 10% | 29,551 | 2,486 | 30,000 | 30,000 | 30,000 | - | - | - | - | 28,291 | 30,000 | 11,087 | 1,322 | - | - | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 60,000 | 14,939 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 14,163 | - | - | - | - | - 500,000 | 20% | - | - | 4,209 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 284,765 | - | - | - | - | - | 178,530 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 34,551 | 7,486 | 99,209 | 49,939 | 479,765 | 750 | 1,715 | - | - | 33,291 | 373,530 | 16,087 | 6,322 | - | 4,923 | 2,855 | - | - | 952 | 49,163 | 624 | 2,639 | - | - | - Allowable Investment 25% of Total Income | 173,878 | 118,714 | 280,261 | 199,898 | 684,765 | 78,750 | 83,577 | 67,001 | 74,918 | 170,729 | 578,530 | 127,719 | 103,305 | 66,953 | 99,613 | 89,276 | 68,839 | 67,272 | 79,762 | 211,105 | 78,119 | 88,193 | 67,104 | 69,193 | 65,696 Less: Investment Allowance, D | (26,082) | (17,807) | (42,039) | (29,985) | (68,476) | (11,813) | (12,537) | (10,050) | (11,238) | (25,609) | (57,853) | (19,158) | (15,496) | (10,043) | (14,942) | (13,391) | (10,326) | (10,091) | (11,964) | (31,666) | (11,718) | (13,229) | (10,066) | (10,379) | (9,854) Net Tax liability | 8,469 | (10,321) | 57,170 | 19,954 | 411,288 | (11,062) | (10,821) | (10,050) | (11,238) | 7,682 | 315,677 | (3,070) | (9,174) | (10,043) | (10,019) | (10,536) | (10,326) | (10,091) | (11,012) | 17,497 | (11,094) | (10,590) | (10,066) | (10,379) | (9,854) Previous Tax Adjustment (Excess Paid) | (68,212) | (94,535) | (3,556) | (3,429) | (1,252) Net/ Minimum Tax liability | 8,469 | 4,000 | 57,170 | 19,954 | 343,076 | 4,000 | 4,000 | 7,682 | 221,142 | 4,000 | 4,000 | 4,000 | 4,000 | 571 | 17,497 | 4,000 | 2,748 | - | - | - | 710,309 Monthly tax deduction (avg. rate) | 706 | 333 | 4764 | 1663 | 28590 | 333 | 333 | 640 | 18428 | 333 | 333 | - | 333 | 333 | - | - | 1458 | 333 | 229 | - | - | - Tax already paid till December 2020 | 3185 | 1999 | 24485 | 7630 | 193435 | 333 | 1999 | 0 | 0 | 2679 | 144372 | 1999 | 1999 | 0 | 1999 | 1999 | 0 | 0 | 1819 | 7936 | 1333 | 1333 | 333 | 333 | 333 | 401,533 Tax to be paid for January, 2021 | 881 | 334 | 5,447 | 2,054 | 24,940 | 611 | 334 | - | - | 834 | 12,795 | 334 | 334 | - | 334 | 334 | - | - | - | 1,594 | 445 | 236 | 51,841 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [February 2021] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Jan'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Feb'21 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 22,860 | 7,800 | 7,500 | 7,680 | - | - | 22,400 | 7,380 | 28,160 | 10,240 | 9,280 | 7,620 | 6,960 | 0 | 0 | 27,280 | 10,080 | 11,700 | 10,700 | 12,600 | 210,240 Less: exemption, C | - | - | - | - | - | (22,860) | (7,800) | (7,500) | (7,680) | - | - | (22,400) | (7,380) | (28,160) | (10,240) | (9,280) | (7,620) | (6,960) | - | - | (27,280) | (10,080) | (11,700) | (10,700) | (12,600) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 38,855 | 58,819 | 60,188 | 40,344 | 111,902 | 29,908 | 32,176 | 19,845 | 27,436 | 36,886 | 117,366 | 19,796 | 33,912 | 22,817 | 32,715 | 28,891 | 10,318 | 29,350 | 18,527 | 7,170 | 2,624 | 42,014 | 24,563 | 47,520 | 37,133 | 931,075 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 696,111 | 474,839 | 1,121,044 | 799,592 | 2,739,058 | 322,058 | 337,674 | 268,445 | 302,224 | 682,914 | 2,314,118 | 513,496 | 418,130 | 268,813 | 402,321 | 360,051 | 275,260 | 271,294 | 319,049 | 847,510 | 312,834 | 355,497 | 278,517 | 289,968 | 268,475 | 15,239,292 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 1,103 | 1,884 | - | 111 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 3,003 | - | - | 952 | 5,000 | 642 | 2,775 | - | - | - 300,000 | 10% | 29,611 | 2,484 | 30,000 | 30,000 | 30,000 | - | - | - | - | 28,291 | 30,000 | 11,350 | 1,813 | - | 232 | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 60,000 | 14,939 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 14,627 | - | - | - | - | - 500,000 | 20% | - | - | 4,209 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 284,765 | - | - | - | - | - | 178,530 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 34,611 | 7,484 | 99,209 | 49,939 | 479,765 | 1,103 | 1,884 | - | 111 | 33,291 | 373,530 | 16,350 | 6,813 | - | 5,232 | 3,003 | - | - | 952 | 49,627 | 642 | 2,775 | - | - | - Allowable Investment 25% of Total Income | 174,028 | 118,710 | 280,261 | 199,898 | 684,765 | 80,515 | 84,419 | 67,111 | 75,556 | 170,729 | 578,530 | 128,374 | 104,533 | 67,203 | 100,580 | 90,013 | 68,815 | 67,824 | 79,762 | 211,878 | 78,209 | 88,874 | 69,629 | 72,492 | 67,119 Less: Investment Allowance, D | (26,104) | (17,806) | (42,039) | (29,985) | (68,476) | (12,077) | (12,663) | (10,067) | (11,333) | (25,609) | (57,853) | (19,256) | (15,680) | (10,080) | (15,087) | (13,502) | (10,322) | (10,174) | (11,964) | (31,782) | (11,731) | (13,331) | (10,444) | (10,874) | (10,068) Net Tax liability | 8,507 | (10,323) | 57,170 | 19,954 | 411,288 | (10,974) | (10,779) | (10,067) | (11,222) | 7,682 | 315,677 | (2,906) | (8,867) | (10,080) | (9,855) | (10,499) | (10,322) | (10,174) | (11,012) | 17,845 | (11,090) | (10,556) | (10,444) | (10,874) | (10,068) Previous Tax Adjustment (Excess Paid) | (68,212) | (94,535) | (3,556) | (3,429) | (1,252) Net/ Minimum Tax liability | 8,507 | 4,000 | 57,170 | 19,954 | 343,076 | 4,000 | 4,000 | 4,000 | 7,682 | 221,142 | 4,000 | 4,000 | 4,000 | 4,000 | 571 | 17,845 | 4,000 | 2,748 | - | - | - | 714,694 Monthly tax deduction (avg. rate) | 709 | 333 | 4764 | 1663 | 28590 | 333 | 333 | 333 | 640 | 18428 | 333 | 333 | - | 333 | 333 | - | - | 1487 | 333 | 229 | - | - | - Tax already paid till January 2021 | 4066 | 2333 | 29932 | 9684 | 218375 | 944 | 2333 | 0 | 0 | 3513 | 157167 | 2333 | 2333 | 0 | 2333 | 2333 | 0 | 0 | 1819 | 9530 | 1778 | 1569 | 333 | 333 | 333 | 453,374 Tax to be paid for February, 2021 | 888 | 333 | 5,448 | 2,054 | 24,940 | 611 | 333 | - | 800 | 834 | 12,795 | 333 | 333 | - | 333 | 333 | - | - | 1,663 | 444 | 236 | 52,711 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [March 2021] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Jan'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Feb'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Mar'21 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 23,895 | 8,100 | 7,875 | 7,875 | - | - | 24,000 | 7,740 | 29,370 | 10,560 | 9,660 | 11,355 | 7,470 | 0 | 0 | 28,380 | 10,560 | 12,075 | 11,775 | 12,900 | 223,590 Less: exemption, C | - | - | - | - | - | (23,895) | (8,100) | (7,875) | (7,875) | - | - | (24,000) | (7,740) | (29,370) | (10,560) | (9,660) | (11,355) | (7,470) | - | - | (28,380) | (10,560) | (12,075) | (11,775) | (12,900) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 39,255 | 58,819 | 60,788 | 40,344 | 111,902 | 30,662 | 32,718 | 20,699 | 27,222 | 36,886 | 117,366 | 19,311 | 33,556 | 23,817 | 33,169 | 30,653 | 10,522 | 30,064 | 18,061 | 10,231 | 2,348 | 46,196 | 27,305 | 54,794 | 41,041 | 957,729 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 696,511 | 474,839 | 1,121,644 | 799,592 | 2,739,058 | 322,812 | 338,216 | 269,299 | 302,010 | 682,914 | 2,314,118 | 513,011 | 417,774 | 269,813 | 402,775 | 361,813 | 275,464 | 272,008 | 318,583 | 850,571 | 312,558 | 359,679 | 281,259 | 297,242 | 272,383 | 15,265,946 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 1,141 | 1,911 | - | 101 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 3,091 | - | - | 929 | 5,000 | 628 | 2,984 | - | - | - 300,000 | 10% | 29,651 | 2,484 | 30,000 | 30,000 | 30,000 | - | - | - | - | 28,291 | 30,000 | 11,301 | 1,777 | - | 278 | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 60,000 | 14,939 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 15,086 | - | - | - | - | - 500,000 | 20% | - | - | 4,329 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 284,765 | - | - | - | - | - | 178,530 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 34,651 | 7,484 | 99,329 | 49,939 | 479,765 | 1,141 | 1,911 | - | 101 | 33,291 | 373,530 | 16,301 | 6,777 | - | 5,278 | 3,091 | - | - | 929 | 50,086 | 628 | 2,984 | - | - | - Allowable Investment 25% of Total Income | 174,128 | 118,710 | 280,411 | 199,898 | 684,765 | 80,703 | 84,554 | 67,325 | 75,503 | 170,729 | 578,530 | 128,253 | 104,444 | 67,453 | 100,694 | 90,453 | 68,866 | 68,002 | 79,646 | 212,643 | 78,140 | 89,920 | 70,315 | 74,311 | 68,096 Less: Investment Allowance, D | (26,119) | (17,806) | (42,062) | (29,985) | (68,476) | (12,105) | (12,683) | (10,099) | (11,325) | (25,609) | (57,853) | (19,238) | (15,667) | (10,118) | (15,104) | (13,568) | (10,330) | (10,200) | (11,947) | (31,896) | (11,721) | (13,488) | (10,547) | (11,147) | (10,214) Net Tax liability | 8,532 | (10,323) | 57,267 | 19,954 | 411,288 | (10,965) | (10,772) | (10,099) | (11,225) | 7,682 | 315,677 | (2,937) | (8,889) | (10,118) | (9,827) | (10,477) | (10,330) | (10,200) | (11,018) | 18,189 | (11,093) | (10,504) | (10,547) | (11,147) | (10,214) Previous Tax Adjustment (Excess Paid) | (68,212) | (94,535) | (3,556) | (3,429) | (1,252) Net/ Minimum Tax liability | 8,532 | 4,000 | 57,267 | 19,954 | 343,076 | 4,000 | 4,000 | 4,000 | 7,682 | 221,142 | 4,000 | 4,000 | 4,000 | 4,000 | 571 | 18,189 | 4,000 | 2,748 | - | - | - | 715,161 Monthly tax deduction (avg. rate) | 711 | 333 | 4772 | 1663 | 28590 | 333 | 333 | 333 | 640 | 18428 | 333 | 333 | - | 333 | 333 | - | - | 1516 | 333 | 229 | - | - | - Tax already paid till February 2021 | 4954 | 2666 | 35380 | 11738 | 243315 | 1555 | 2666 | 0 | 800 | 4347 | 169962 | 2666 | 2666 | 0 | 2666 | 2666 | 0 | 0 | 1819 | 11193 | 2222 | 1805 | 333 | 333 | 333 | 506,085 Tax to be paid for March, 2021 | 894 | 334 | 5,472 | 2,054 | 24,940 | 611 | 334 | 800 | 834 | 12,795 | 334 | 334 | 334 | 334 | 1,749 | 445 | 236 | 52,834 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [April 2021] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Jan'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Feb'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Mar'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 | 860,813 Apr'21 May'21 Jun'21 | - Basic Salary yearly | 506,616 | 325,656 | 763,932 | 588,216 | 1,652,124 | 224,124 | 234,804 | 194,088 | 210,240 | 497,640 | 1,406,172 | 380,568 | 292,980 | 192,000 | 286,092 | 250,536 | 202,356 | 183,960 | 235,620 | 643,020 | 236,400 | 240,396 | 203,172 | 193,968 | 185,076 | 10,329,756 House rent | 253,308 | 162,828 | 381,966 | 294,108 | 826,062 | 112,062 | 117,402 | 97,044 | 105,120 | 248,820 | 703,086 | 190,284 | 146,490 | 96,000 | 143,046 | 125,268 | 101,178 | 91,980 | 117,810 | 321,510 | 118,200 | 120,198 | 101,586 | 96,984 | 92,538 | 5,164,878 Less: exemption, A | (253,308) | (162,828) | (300,000) | (294,108) | (300,000) | (112,062) | (117,402) | (97,044) | (105,120) | (248,820) | (300,000) | (190,284) | (146,490) | (96,000) | (143,046) | (125,268) | (101,178) | (91,980) | (117,810) | (300,000) | (118,200) | (120,198) | (101,586) | (96,984) | (92,538) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 23,520 | 7,960 | 7,760 | 7,640 | - | - | 23,867 | 7,600 | 28,893 | 10,400 | 9,600 | 12,013 | 7,360 | 0 | 0 | 28,013 | 10,400 | 12,000 | 11,667 | 12,733 | 221,427 Less: exemption, C | - | - | - | - | - | (23,520) | (7,960) | (7,760) | (7,640) | - | - | (23,867) | (7,600) | (28,893) | (10,400) | (9,600) | (12,013) | (7,360) | - | - | (28,013) | (10,400) | (12,000) | (11,667) | (12,733) Bonus | 84,436 | 54,276 | 127,322 | 98,036 | 275,354 | 37,354 | 39,134 | 32,348 | 35,040 | 82,940 | 234,362 | 63,428 | 48,830 | 32,000 | 47,682 | 41,756 | 33,726 | 30,660 | 39,270 | 107,170 | 39,400 | 40,066 | 33,862 | 32,328 | 30,846 | 1,721,626 Overtime & deduction | 40,255 | 59,325 | 60,788 | 40,544 | 111,902 | 31,235 | 33,664 | 21,537 | 27,149 | 36,886 | 117,366 | 19,622 | 33,556 | 24,617 | 33,969 | 33,703 | 9,896 | 30,064 | 18,261 | 10,045 | 2,759 | 49,308 | 34,750 | 60,191 | 48,584 | 989,976 Provident Fund(July'19~June'20) | 3,517 | 2,261 | 5,303 | 4,083 | 11,468 | 1,556 | 1,630 | 1,347 | 1,459 | 3,454 | 9,761 | 2,642 | 2,034 | 1,333 | 1,986 | 1,739 | 1,405 | 1,277 | 1,636 | 4,464 | 1,641 | 1,669 | 1,410 | 1,346 | 1,285 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,204 | 18,088 | 63,636 | 48,996 | 137,616 | 18,672 | 19,560 | 16,164 | 17,508 | 41,448 | 117,132 | 31,704 | 24,408 | 15,996 | 23,832 | 20,868 | 16,860 | 15,324 | 19,632 | 44,640 | 16,410 | 15,021 | 16,920 | 16,152 | 15,420 | 834,211 Taxable income | 697,511 | 475,345 | 1,121,644 | 799,792 | 2,739,058 | 323,385 | 339,162 | 270,137 | 301,937 | 682,914 | 2,314,118 | 513,322 | 417,774 | 270,613 | 403,575 | 364,863 | 274,838 | 272,008 | 318,783 | 850,385 | 312,969 | 362,791 | 288,704 | 302,639 | 279,926 | 15,298,193 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 1,169 | 1,958 | - | 97 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 3,243 | - | - | 939 | 5,000 | 648 | 3,140 | - | 132 | - 300,000 | 10% | 29,751 | 2,535 | 30,000 | 30,000 | 30,000 | - | - | - | - | 28,291 | 30,000 | 11,332 | 1,777 | - | 358 | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | - | - | 60,000 | 14,969 | 60,000 | - | - | - | - | - | 60,000 | - | - | - | - | - | - | - | - | 15,058 | - | - | - | - | - 500,000 | 20% | - | - | 4,329 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 284,765 | - | - | - | - | - | 178,530 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 34,751 | 7,535 | 99,329 | 49,969 | 479,765 | 1,169 | 1,958 | - | 97 | 33,291 | 373,530 | 16,332 | 6,777 | - | 5,358 | 3,243 | - | - | 939 | 50,058 | 648 | 3,140 | - | 132 | - Allowable Investment 25% of Total Income | 174,378 | 118,836 | 280,411 | 199,948 | 684,765 | 80,846 | 84,791 | 67,534 | 75,484 | 170,729 | 578,530 | 128,331 | 104,444 | 67,653 | 100,894 | 91,216 | 68,710 | 68,002 | 79,696 | 212,596 | 78,242 | 90,698 | 72,176 | 75,660 | 69,982 Less: Investment Allowance, D | (26,157) | (17,825) | (42,062) | (29,992) | (68,476) | (12,127) | (12,719) | (10,130) | (11,323) | (25,609) | (57,853) | (19,250) | (15,667) | (10,148) | (15,134) | (13,682) | (10,306) | (10,200) | (11,954) | (31,889) | (11,736) | (13,605) | (10,826) | (11,349) | (10,497) Net Tax liability | 8,594 | (10,291) | 57,267 | 19,977 | 411,288 | (10,958) | (10,760) | (10,130) | (11,226) | 7,682 | 315,677 | (2,917) | (8,889) | (10,148) | (9,777) | (10,439) | (10,306) | (10,200) | (11,015) | 18,168 | (11,088) | (10,465) | (10,826) | (11,217) | (10,497) Previous Tax Adjustment (Excess Paid) | (68,212) | (94,535) | (3,556) | (3,429) | (1,252) Net/ Minimum Tax liability | 8,594 | 4,000 | 57,267 | 19,977 | 343,076 | 4,000 | 4,000 | 4,000 | 7,682 | 221,142 | 4,000 | 4,000 | 4,000 | 4,000 | 571 | 18,168 | 4,000 | 2,748 | - | 4,000 | - | 719,225 Monthly tax deduction (avg. rate) | 716 | 333 | 4772 | 1665 | 28590 | 333 | 333 | 333 | 640 | 18428 | 333 | 333 | - | 333 | 333 | - | - | 1514 | 333 | 229 | - | 333.00 | - Tax already paid till March 2021 | 5848 | 3000 | 40852 | 13792 | 268255 | 2166 | 3000 | 0 | 1600 | 5181 | 182757 | 3000 | 3000 | 0 | 3000 | 3000 | 0 | 0 | 1819 | 12942 | 2667 | 2041 | 333 | 333 | 333 | 558,919 Tax to be paid for April, 2021 | 915 | 333 | 5,472 | 2,062 | 24,940 | 611 | 333 | - | 800 | 834 | 12,795 | 333 | 333 | - | 333 | 333 | - | - | 1,742 | 444 | 236 | 1,222 | 54,071 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [June 2021] Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000696 | 000809 | 000819 | 001243 | 001257 | 800003 | 800004 | 800005 Monthly basic Salary Jul'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Aug'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Sep'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Oct'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Nov'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Dec'20 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Jan'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Feb'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 Mar'21 | 42,218 | 27,138 | 63,661 | 49,018 | 137,677 | 18677 | 19567 | 16174 | 17520 | 41470 | 117,181 | 31,714 | 24415 | 16000 | 23841 | 20878 | 16863 | 15330 | 19635 | 53,585 | 19700 | 20033 | 16931 | 16164 | 15423 | 860,813 Apr'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 18549 | 16863 | 20617 | 56,264 | 21670 | 21035 | 17778 | 16972 | 16194 | 907,234 May'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 18549 | 16863 | 20617 | 56,264 | 21670 | 21035 | 17778 | 16972 | 16194 Jun'21 | - Basic Salary yearly | 512,949 | 333,798 | 783,030 | 602,922 | 1,660,386 | 226,926 | 237,738 | 196,515 | 212,868 | 510,081 | 1,413,204 | 383,421 | 296,643 | 194,400 | 289,668 | 253,668 | 207,414 | 188,559 | 238,566 | 651,057 | 242,310 | 243,402 | 205,713 | 196,392 | 187,389 | 10,469,019 House rent | 256,475 | 166,899 | 391,515 | 301,461 | 830,193 | 113,463 | 118,869 | 98,258 | 106,434 | 255,041 | 706,602 | 191,711 | 148,322 | 97,200 | 144,834 | 126,834 | 103,707 | 94,280 | 119,283 | 325,529 | 121,155 | 121,701 | 102,857 | 98,196 | 93,695 | 5,234,510 Less: exemption, A | (256,475) | (166,899) | (300,000) | (300,000) | (300,000) | (113,463) | (118,869) | (98,258) | (106,434) | (255,041) | (300,000) | (191,711) | (148,322) | (97,200) | (144,834) | (126,834) | (103,707) | (94,280) | (119,283) | (300,000) | (121,155) | (121,701) | (102,857) | (98,196) | (93,695) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 0 | 0 | 0 | 390,000 Less: exemption Conveyance | - | - | - | - | - | 22,975 | 7,691 | 7,593 | 7,527 | - | - | 23,782 | 7,495 | 28,200 | 10,167 | 9,556 | 13,233 | 7,265 | 0 | 0 | 26,040 | 10,167 | 11,891 | 11,673 | 12,545 | 217,800 Less: exemption, C | - | - | - | - | - | (22,975) | (7,691) | (7,593) | (7,527) | - | - | (23,782) | (7,495) | (28,200) | (10,167) | (9,556) | (13,233) | (7,265) | - | - | (26,040) | (10,167) | (11,891) | (11,673) | (12,545) Bonus | 86,547 | 56,990 | 133,688 | 102,938 | 278,108 | 38,288 | 40,112 | 33,157 | 35,916 | 87,087 | 236,706 | 64,379 | 50,051 | 32,800 | 48,874 | 42,800 | 35,412 | 32,193 | 40,252 | 109,849 | 41,370 | 41,068 | 34,709 | 33,136 | 31,617 | 1,768,047 Overtime & deduction | 41,795 | 60,605 | 61,868 | 41,564 | 112,922 | 34,938 | 36,829 | 24,383 | 30,456 | 38,026 | 118,506 | 21,523 | 37,735 | 26,979 | 38,193 | 42,805 | 12,536 | 32,329 | 20,201 | 11,185 | 2,679 | 58,276 | 47,243 | 72,693 | 56,237 | 1,082,506 Provident Fund(July'20~June'21) | 3,693 | 2,487 | 5,833 | 4,492 | 11,698 | 1,634 | 1,711 | 1,415 | 1,532 | 3,800 | 9,956 | 2,721 | 2,135 | 1,399 | 2,085 | 1,826 | 1,545 | 1,405 | 1,717 | 4,687 | 1,805 | 1,752 | 1,481 | 1,414 | 1,349 | 75,572 Provident Fund Considering Month | 12 | 8 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 10 | 10 | 9 | 12 | 12 | 12 Provident Fund (Total) | 42,729 | 18,537 | 65,226 | 50,223 | 138,310 | 18,903 | 19,804 | 16,370 | 17,732 | 42,490 | 117,720 | 31,939 | 24,710 | 16,194 | 24,129 | 21,131 | 17,278 | 15,707 | 19,873 | 45,194 | 16,820 | 15,206 | 17,136 | 16,359 | 15,610 | 845,330 Taxable income | 708,020 | 487,930 | 1,159,327 | 823,108 | 2,755,919 | 331,055 | 346,483 | 276,425 | 308,972 | 701,684 | 2,328,738 | 519,262 | 427,139 | 276,373 | 412,864 | 378,404 | 284,640 | 280,788 | 324,892 | 866,814 | 321,179 | 375,952 | 304,801 | 318,580 | 290,853 | 15,610,202 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 1,553 | 2,324 | - | 449 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 3,920 | - | - | 1,245 | 5,000 | 1,059 | 3,798 | 240 | 929 | - 300,000 | 10% | 30,000 | 3,793 | 30,000 | 30,000 | 30,000 | - | - | - | - | 30,000 | 30,000 | 11,926 | 2,714 | - | 1,286 | - | - | - | - | 30,000 | - | - | - | - | - 400,000 | 15% | 1,203 | - | 60,000 | 18,466 | 60,000 | - | - | - | - | 253 | 60,000 | - | - | - | - | - | - | - | - | 17,522 | - | - | - | - | - 500,000 | 20% | - | - | 11,865 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 288,980 | - | - | - | - | - | 182,185 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 36,203 | 8,793 | 106,865 | 53,466 | 483,980 | 1,553 | 2,324 | - | 449 | 35,253 | 377,185 | 16,926 | 7,714 | - | 6,286 | 3,920 | - | - | 1,245 | 52,522 | 1,059 | 3,798 | 240 | 929 | - Allowable Investment 25% of Total Income | 177,005 | 121,982 | 289,832 | 205,777 | 688,980 | 82,764 | 86,621 | 69,106 | 77,243 | 175,421 | 582,185 | 129,816 | 106,785 | 69,093 | 103,216 | 94,601 | 71,160 | 70,197 | 81,223 | 216,703 | 80,295 | 93,988 | 76,200 | 79,645 | 72,713 Less: Investment Allowance, D | (26,551) | (18,297) | (43,475) | (30,867) | (68,898) | (12,415) | (12,993) | (10,366) | (11,586) | (26,313) | (58,218) | (19,472) | (16,018) | (10,364) | (15,482) | (14,190) | (10,674) | (10,530) | (12,183) | (32,506) | (12,044) | (14,098) | (11,430) | (11,947) | (10,907) Net Tax liability | 9,652 | (9,504) | 63,391 | 22,600 | 415,082 | (10,862) | (10,669) | (10,366) | (11,138) | 8,939 | 318,966 | (2,546) | (8,304) | (10,364) | (9,196) | (10,270) | (10,674) | (10,530) | (10,939) | 20,017 | (10,985) | (10,301) | (11,190) | (11,018) | (10,907) Previous Tax Adjustment (Excess Paid) | (4,957) | (15,679) | (68,212) | (94,535) | (3,556) | (3,429) | (1,252) Net/ Minimum Tax liability | 4,695 | 4,000 | 47,712 | 22,600 | 346,870 | 4,000 | 4,000 | 4,000 | 8,939 | 224,431 | 4,000 | 4,000 | 4,000 | 4,000 | 571 | 20,017 | 4,000 | 2,748 | 4,000 | 4,000 | - | 722,582 Monthly tax deduction (avg. rate) | 391 | 333 | 3976 | 1883 | 28906 | 333 | 333 | 333 | 745 | 18703 | 333 | 333 | - | 333 | 333 | - | - | 1668 | 333 | 229 | 333 | 333.00 | - Tax already paid till May 2021 | 6,763 | 3,667 | 44,223 | 19,190 | 319,965 | 3,389 | 3,667 | - | 3,200 | 7,437 | 209,911 | 3,667 | 3,667 | - | 3,667 | 3,667 | - | - | 1,819 | 17,310 | 3,556 | 2,513 | 333 | 2,778 | 333 | 664,722 Tax to be paid for June, 2021 | - | 333 | 3,489 | 3,410 | 26,905 | 611 | 333 | - | 800 | 1,502 | 14,520 | 333 | 333 | - | 333 | 333 | - | - | - | 2,707 | 444 | 235 | 3,667 | 1,222 | 61,510 TS Tech Bangladesh Limited. Assessment Year: 2020-2021 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [August 2021] Female | Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000809 | 000819 | 001243 | 001257 | 001326 | 800003 | 800004 | 800005 Monthly basic Salary Jul'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 18549 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 | 934,737 Aug'21 Sep'21 Oct'21 Nov'21 Dec'21 Jan'22 Feb'22 Mar'22 | - Apr'22 May'22 Jun'22 | - Basic Salary yearly | 531,948 | 358,224 | 840,324 | 647,040 | 1,685,172 | 235,332 | 246,540 | 203,796 | 220,752 | 547,404 | 1,434,300 | 391,980 | 307,632 | 201,600 | 300,396 | 263,064 | 222,588 | 247,404 | 675,168 | 260,040 | 252,420 | 532,392 | 213,336 | 203,664 | 194,328 | 11,216,844 House rent | 265,974 | 179,112 | 420,162 | 323,520 | 842,586 | 117,666 | 123,270 | 101,898 | 110,376 | 273,702 | 717,150 | 195,990 | 153,816 | 100,800 | 150,198 | 131,532 | 111,294 | 123,702 | 337,584 | 130,020 | 126,210 | 266,196 | 106,668 | 101,832 | 97,164 | 5,608,422 Less: exemption, A | (265,974) | (179,112) | (300,000) | (300,000) | (300,000) | (117,666) | (123,270) | (101,898) | (110,376) | (273,702) | (300,000) | (195,990) | (153,816) | (100,800) | (150,198) | (131,532) | (111,294) | (123,702) | (300,000) | (130,020) | (126,210) | (266,196) | (106,668) | (101,832) | (97,164) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 24,000 | 0 | 0 | 0 | 402,000 Less: exemption Conveyance | - | - | - | - | - | 20,520 | 6,840 | 6,840 | 4,680 | - | - | 22,800 | 6,840 | 25,080 | 9,120 | 8,640 | 17,280 | 0 | 0 | 25,080 | 9,120 | 0 | 11,400 | 0 | 0 | 174,240 Less: exemption, C | - | - | - | - | - | (20,520) | (6,840) | (6,840) | (4,680) | - | - | (22,800) | (6,840) | (25,080) | (9,120) | (8,640) | (17,280) | - | - | (25,080) | (9,120) | - | (11,400) | - | - Bonus | 88,658 | 59,704 | 140,054 | 107,840 | 280,862 | 39,222 | 41,090 | 33,966 | 36,792 | 91,234 | 239,050 | 65,330 | 51,272 | 33,600 | 50,066 | 43,844 | 37,098 | 41,234 | 112,528 | 43,340 | 42,070 | 88,732 | 35,556 | 33,944 | 32,388 | 1,869,474 Overtime & deduction | 200 | -15 | 0 | 0 | 0 | 1386 | 3863 | 1310 | 335 | 0 | 0 | 800 | 3079 | -159 | 912 | 1011 | -711 | 0 | -31 | -465 | 3227 | 800 | 4815 | -7355 | -7557 | 5,445 Provident Fund(July'21~June'22) | 3,693 | 2,487 | 5,833 | 4,492 | 11,698 | 1,634 | 1,711 | 1,415 | 1,532 | 3,800 | 9,956 | 2,721 | 2,135 | 1,399 | 2,085 | 1,826 | 1,545 | 1,717 | 4,687 | 1,805 | 1,752 | 3,696 | 1,481 | 1,414 | 1,349 | 77,863 Provident Fund Considering Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 44,311 | 29,840 | 69,999 | 53,898 | 140,375 | 19,603 | 20,537 | 16,976 | 18,389 | 45,599 | 119,477 | 32,652 | 25,626 | 16,793 | 25,023 | 21,913 | 18,542 | 20,609 | 56,241 | 21,661 | 21,027 | 44,348 | 17,771 | 16,965 | 16,188 | 934,363 Taxable income | 689,117 | 465,753 | 1,194,539 | 856,298 | 2,684,995 | 307,543 | 324,030 | 262,048 | 288,268 | 708,237 | 2,245,977 | 508,762 | 405,609 | 257,834 | 388,397 | 347,832 | 289,517 | 315,247 | 905,490 | 342,576 | 336,744 | 690,272 | 271,478 | 247,218 | 235,347 | 15,569,128 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,788 | 5,000 | 5,000 | 5,000 | 377 | 1,202 | - | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 4,420 | 2,392 | - | 762 | 5,000 | 2,129 | 1,837 | 5,000 | - | - | - 300,000 | 10% | 28,912 | 1,575 | 30,000 | 30,000 | 30,000 | - | - | - | 30,000 | 30,000 | 10,876 | 561 | - | - | - | - | 30,000 | - | - | 24,027 | - | - | - 400,000 | 15% | - | 60,000 | 23,445 | 60,000 | - | - | - | - | 1,236 | 60,000 | - | - | - | - | - | - | - | 23,324 | - | - | - | - | - | - 500,000 | 20% | - | - | 18,908 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 271,249 | - | - | - | - | - | 161,494 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 33,912 | 7,363 | 113,908 | 58,445 | 466,249 | 377 | 1,202 | - | - | 36,236 | 356,494 | 15,876 | 5,561 | - | 4,420 | 2,392 | - | 762 | 58,324 | 2,129 | 1,837 | 29,027 | - | - | - Allowable Investment 25% of Total Income | 172,279 | 116,438 | 298,635 | 214,075 | 671,249 | 76,886 | 81,008 | 65,512 | 72,067 | 177,059 | 561,494 | 127,191 | 101,402 | 64,459 | 97,099 | 86,958 | 72,379 | 78,812 | 226,373 | 85,644 | 84,186 | 172,568 | 67,870 | 61,805 | 58,837 Less: Investment Allowance, D | (25,842) | (17,466) | (44,795) | (32,111) | (67,125) | (11,533) | (12,151) | (9,827) | (10,810) | (26,559) | (56,149) | (19,079) | (15,210) | (9,669) | (14,565) | (13,044) | (10,857) | (11,822) | (33,956) | (12,847) | (12,628) | (25,885) | (10,180) | (9,271) | (8,826) Net Tax liability | 8,070 | (10,103) | 69,113 | 26,334 | 399,124 | (11,156) | (10,950) | (9,827) | (10,810) | 9,677 | 300,345 | (3,202) | (9,649) | (9,669) | (10,145) | (10,652) | (10,857) | (11,059) | 24,368 | (10,718) | (10,791) | 3,142 | (10,180) | (9,271) | (8,826) Previous Tax Adjustment (Excess Paid) | - Net/ Minimum Tax liability | 8,070 | 4,000 | 69,113 | 26,334 | 399,124 | 4,000 | 4,000 | - | 9,677 | 300,345 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 24,368 | 4,000 | 4,000 | 4,000 | - | - | - | 881,029 Monthly tax deduction (avg. rate) | 673 | 333 | 5,759 | 2,194 | 33,260 | 333 | 333 | - | - | 806 | 25,029 | 333 | 333 | - | 333 | 333 | - | 333 | 2,031 | 333 | 333 | 333 | - | - | - Tax already paid in July 2021 | 810 | 333 | 5,283 | 1,883 | 34,590 | 333 | 333 | - | 333 | 747 | 26,581 | 333 | 333 | - | 333 | 333 | - | 333 | 1,667 | 333 | 333 | - | 333 | 333 | - | 75,890 Tax to be paid for August, 2021 | 660 | 333 | 5,803 | 2,223 | 33,139 | 333 | 333 | - | - | 812 | 24,888 | 333 | 333 | - | 333 | 333 | - | 333 | 2,064 | 333 | 333 | 364 | - | - | - | 73,283 0 | 0 | 0 TS Tech Bangladesh Limited. Assessment Year: 2021-2022 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [September 2021] Female | Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000629 | 000809 | 000819 | 001243 | 001257 | 001326 | 800003 | 800004 | 800005 Monthly basic Salary Jul'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 18549 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Aug'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 18549 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 | 934,737 Sep'21 Oct'21 Nov'21 Dec'21 Jan'22 Feb'22 Mar'22 | - Apr'22 May'22 Jun'22 | - Basic Salary yearly | 531,948 | 358,224 | 840,324 | 647,040 | 1,685,172 | 235,332 | 246,540 | 203,796 | 220,752 | 547,404 | 1,434,300 | 391,980 | 307,632 | 201,600 | 300,396 | 263,064 | 222,588 | 247,404 | 675,168 | 260,040 | 252,420 | 532,392 | 213,336 | 203,664 | 194,328 | 11,216,844 House rent | 265,974 | 179,112 | 420,162 | 323,520 | 842,586 | 117,666 | 123,270 | 101,898 | 110,376 | 273,702 | 717,150 | 195,990 | 153,816 | 100,800 | 150,198 | 131,532 | 111,294 | 123,702 | 337,584 | 130,020 | 126,210 | 266,196 | 106,668 | 101,832 | 97,164 | 5,608,422 Less: exemption, A | (265,974) | (179,112) | (300,000) | (300,000) | (300,000) | (117,666) | (123,270) | (101,898) | (110,376) | (273,702) | (300,000) | (195,990) | (153,816) | (100,800) | (150,198) | (131,532) | (111,294) | (123,702) | (300,000) | (130,020) | (126,210) | (266,196) | (106,668) | (101,832) | (97,164) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 12,000 | 6,000 | 24,000 | 18,000 | 18,000 | 24,000 | - | - | - | 402,000 Less: exemption Conveyance | - | - | - | - | - | 21,060 | 7,020 | 6,660 | 5,940 | - | - | 22,200 | 7,020 | 24,420 | 9,120 | 8,400 | 8,640 | 0 | 0 | 24,420 | 8,880 | 0 | 8,100 | 5,400 | 5,100 | 172,380 Less: exemption, C | - | - | - | - | - | (21,060) | (7,020) | (6,660) | (5,940) | - | - | (22,200) | (7,020) | (24,420) | (9,120) | (8,400) | (8,640) | - | - | (24,420) | (8,880) | - | (8,100) | (5,400) | (5,100) Bonus | 88,658 | 59,704 | 140,054 | 107,840 | 280,862 | 39,222 | 41,090 | 33,966 | 36,792 | 91,234 | 239,050 | 65,330 | 51,272 | 33,600 | 50,066 | 43,844 | 18,549 | 41,234 | 112,528 | 43,340 | 42,070 | 88,732 | 35,556 | 33,944 | 32,388 | 1,850,925 Overtime & deduction | 800 | 477 | 0 | 0 | 0 | 1620 | 5058 | 3223 | 1252 | 0 | 0 | 800 | 3879 | -159 | 196 | 2177 | -9637 | -216 | -47 | -1237 | 5920 | 800 | 7541 | -4086 | -6835 | 11,526 Provident Fund(July'21~June'22) | 3,693 | 2,487 | 5,833 | 4,492 | 11,698 | 1,634 | 1,711 | 1,415 | 1,532 | 3,800 | 9,956 | 2,721 | 2,135 | 1,399 | 2,085 | 1,826 | 1,545 | 1,717 | 4,687 | 1,805 | 1,752 | 3,696 | 1,481 | 1,414 | 1,349 | 77,863 Provident Fund Considering Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 44,311 | 29,840 | 69,999 | 53,898 | 140,375 | 19,603 | 20,537 | 16,976 | 18,389 | 45,599 | 119,477 | 32,652 | 25,626 | 16,793 | 25,023 | 21,913 | 1,545 | 20,609 | 56,241 | 21,661 | 21,027 | 44,348 | 17,771 | 16,965 | 16,188 | 917,366 Taxable income | 689,717 | 466,245 | 1,194,539 | 856,298 | 2,684,995 | 307,777 | 325,225 | 263,961 | 289,185 | 708,237 | 2,245,977 | 508,762 | 406,409 | 257,834 | 387,681 | 348,998 | 245,045 | 315,031 | 905,474 | 341,804 | 339,437 | 690,272 | 274,204 | 250,487 | 236,069 | 15,539,663 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 389 | 1,261 | - | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 4,384 | 2,450 | - | 752 | 5,000 | 2,090 | 1,972 | 5,000 | - | - | - 300,000 | 10% | 28,972 | 1,625 | 30,000 | 30,000 | 30,000 | - | - | - | 30,000 | 30,000 | 10,876 | 641 | - | - | - | - | 30,000 | - | - | 24,027 | - | - | - 400,000 | 15% | - | 60,000 | 23,445 | 60,000 | - | - | - | - | 1,236 | 60,000 | - | - | - | - | - | - | - | 23,321 | - | - | - | - | - | - 500,000 | 20% | - | - | 18,908 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 271,249 | - | - | - | - | - | 161,494 | - | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 33,972 | 6,625 | 113,908 | 58,445 | 466,249 | 389 | 1,261 | - | - | 36,236 | 356,494 | 15,876 | 5,641 | - | 4,384 | 2,450 | - | 752 | 58,321 | 2,090 | 1,972 | 29,027 | - | - | - Allowable Investment 25% of Total Income | 172,429 | 116,561 | 298,635 | 214,075 | 671,249 | 76,944 | 81,306 | 65,990 | 72,296 | 177,059 | 561,494 | 127,191 | 101,602 | 64,459 | 96,920 | 87,250 | 61,261 | 78,758 | 226,369 | 85,451 | 84,859 | 172,568 | 68,551 | 62,622 | 59,017 Less: Investment Allowance, D | (25,864) | (17,484) | (44,795) | (32,111) | (67,125) | (11,542) | (12,196) | (9,899) | (10,844) | (26,559) | (56,149) | (19,079) | (15,240) | (9,669) | (14,538) | (13,087) | (9,189) | (11,814) | (33,955) | (12,818) | (12,729) | (25,885) | (10,283) | (9,393) | (8,853) Net Tax liability | 8,107 | (10,860) | 69,113 | 26,334 | 399,124 | (11,153) | (10,935) | (9,899) | (10,844) | 9,677 | 300,345 | (3,202) | (9,599) | (9,669) | (10,154) | (10,638) | (9,189) | (11,062) | 24,366 | (10,727) | (10,757) | 3,142 | (10,283) | (9,393) | (8,853) Previous Tax Adjustment (Excess Paid) | - Net/ Minimum Tax liability | 8,107 | 4,000 | 69,113 | 26,334 | 399,124 | 4,000 | 4,000 | - | 9,677 | 300,345 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 24,366 | 4,000 | 4,000 | 4,000 | - | - | - | 881,064 Monthly tax deduction (avg. rate) | 676 | 333 | 5,759 | 2,194 | 33,260 | 333 | 333 | - | - | 806 | 25,029 | 333 | 333 | - | 333 | 333 | - | 333 | 2,030 | 333 | 333 | 333 | - | - | - Tax already paid in August 2021 | 1,470 | 666 | 11,086 | 4,106 | 67,729 | 666 | 666 | - | 333 | 1,559 | 51,469 | 666 | 666 | - | 666 | 666 | - | 666 | 3,731 | 666 | 666 | 364 | 333 | 333 | - | 149,173 Tax to be paid for September, 2021 | 664 | 333 | 5,803 | 2,223 | 33,139 | 333 | 333 | - | - | 812 | 24,888 | 333 | 333 | - | 333 | 333 | - | 333 | 2,063 | 333 | 333 | 364 | - | - | - | 73,286 0 | 0 | 0 TS Tech Bangladesh Limited. Assessment Year: 2021-2022 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [October 2021] Female | Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000809 | 000819 | 001243 | 001257 | 001326 | 800003 | 800004 | 800005 Monthly basic Salary Jul'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Aug'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Sep'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 | 916,188 Oct'21 Nov'21 Dec'21 Jan'22 Feb'22 Mar'22 | - Apr'22 May'22 Jun'22 | - Basic Salary yearly | 531,948 | 358,224 | 840,324 | 647,040 | 1,685,172 | 235,332 | 246,540 | 203,796 | 220,752 | 547,404 | 1,434,300 | 391,980 | 307,632 | 201,600 | 300,396 | 263,064 | 247,404 | 675,168 | 260,040 | 252,420 | 532,392 | 213,336 | 203,664 | 194,328 | 10,994,256 House rent | 265,974 | 179,112 | 420,162 | 323,520 | 842,586 | 117,666 | 123,270 | 101,898 | 110,376 | 273,702 | 717,150 | 195,990 | 153,816 | 100,800 | 150,198 | 131,532 | 123,702 | 337,584 | 130,020 | 126,210 | 266,196 | 106,668 | 101,832 | 97,164 | 5,497,128 Less: exemption, A | (265,974) | (179,112) | (300,000) | (300,000) | (300,000) | (117,666) | (123,270) | (101,898) | (110,376) | (273,702) | (300,000) | (195,990) | (153,816) | (100,800) | (150,198) | (131,532) | (123,702) | (300,000) | (130,020) | (126,210) | (266,196) | (106,668) | (101,832) | (97,164) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 6,000 | 24,000 | 18,000 | 18,000 | 24,000 | - | - | - | 390,000 Less: exemption Conveyance | - | - | - | - | - | 21,240 | 7,680 | 7,080 | 6,960 | - | - | 24,000 | 7,680 | 26,400 | 9,760 | 9,120 | 0 | 0 | 25,960 | 9,600 | 0 | 9,400 | 8,600 | 8,400 | 181,880 Less: exemption, C | - | - | - | - | - | (21,240) | (7,680) | (7,080) | (6,960) | - | - | (24,000) | (7,680) | (26,400) | (9,760) | (9,120) | - | - | (25,960) | (9,600) | - | (9,400) | (8,600) | (8,400) Bonus | 88,658 | 59,704 | 140,054 | 107,840 | 280,862 | 39,222 | 41,090 | 33,966 | 36,792 | 91,234 | 239,050 | 65,330 | 51,272 | 33,600 | 50,066 | 43,844 | 41,234 | 112,528 | 43,340 | 42,070 | 88,732 | 35,556 | 33,944 | 32,388 | 1,832,376 Overtime & deduction | 800 | 473 | 0 | 200 | 0 | 1179 | 5321 | 2977 | 944 | 0 | 0 | 800 | 4679 | -159 | -890 | 2021 | 281 | 1527 | -1237 | 7125 | -78 | 11629 | 2621 | -1552 | 38,661 Provident Fund(July'21~June'22) | 3,693 | 2,487 | 5,833 | 4,492 | 11,698 | 1,634 | 1,711 | 1,415 | 1,532 | 3,800 | 9,956 | 2,721 | 2,135 | 1,399 | 2,085 | 1,826 | 1,717 | 4,687 | 1,805 | 1,752 | 3,696 | 1,481 | 1,414 | 1,349 | 76,318 Provident Fund Considering Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 44,311 | 29,840 | 69,999 | 53,898 | 140,375 | 19,603 | 20,537 | 16,976 | 18,389 | 45,599 | 119,477 | 32,652 | 25,626 | 16,793 | 25,023 | 21,913 | 20,609 | 56,241 | 21,661 | 21,027 | 44,348 | 17,771 | 16,965 | 16,188 | 915,821 Taxable income | 689,717 | 466,241 | 1,194,539 | 856,498 | 2,684,995 | 307,336 | 325,488 | 263,715 | 288,877 | 708,237 | 2,245,977 | 508,762 | 407,209 | 257,834 | 386,595 | 348,842 | 315,528 | 907,048 | 341,804 | 340,642 | 689,394 | 278,292 | 257,194 | 241,352 | 15,312,116 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 367 | 1,274 | - | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 4,330 | 2,442 | 776 | 5,000 | 2,090 | 2,032 | 5,000 | - | - | - 300,000 | 10% | 28,972 | 1,624 | 30,000 | 30,000 | 30,000 | - | - | - | 30,000 | 30,000 | 10,876 | 721 | - | - | - | 30,000 | - | - | 23,939 | - | - | - 400,000 | 15% | - | 60,000 | 23,475 | 60,000 | - | - | - | - | 1,236 | 60,000 | - | - | - | - | - | - | 23,557 | - | - | - | - | - | - 500,000 | 20% | - | - | 18,908 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 271,249 | - | - | - | - | - | 161,494 | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 33,972 | 6,624 | 113,908 | 58,475 | 466,249 | 367 | 1,274 | - | - | 36,236 | 356,494 | 15,876 | 5,721 | - | 4,330 | 2,442 | 776 | 58,557 | 2,090 | 2,032 | 28,939 | - | - | - Allowable Investment 25% of Total Income | 172,429 | 116,560 | 298,635 | 214,125 | 671,249 | 76,834 | 81,372 | 65,929 | 72,219 | 177,059 | 561,494 | 127,191 | 101,802 | 64,459 | 96,649 | 87,211 | 78,882 | 226,762 | 85,451 | 85,161 | 172,349 | 69,573 | 64,299 | 60,338 Less: Investment Allowance, D | (25,864) | (17,484) | (44,795) | (32,119) | (67,125) | (11,525) | (12,206) | (9,889) | (10,833) | (26,559) | (56,149) | (19,079) | (15,270) | (9,669) | (14,497) | (13,082) | (11,832) | (34,014) | (12,818) | (12,774) | (25,852) | (10,436) | (9,645) | (9,051) Net Tax liability | 8,107 | (10,860) | 69,113 | 26,356 | 399,124 | (11,158) | (10,931) | (9,889) | (10,833) | 9,677 | 300,345 | (3,202) | (9,549) | (9,669) | (10,168) | (10,639) | (11,056) | 24,543 | (10,727) | (10,742) | 3,087 | (10,436) | (9,645) | (9,051) Previous Tax Adjustment (Excess Paid) | - Net/ Minimum Tax liability | 8,107 | 4,000 | 69,113 | 26,356 | 399,124 | 4,000 | 4,000 | - | 9,677 | 300,345 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 24,543 | 4,000 | 4,000 | 4,000 | - | - | - | 881,264 Monthly tax deduction (avg. rate) | 676 | 333 | 5,759 | 2,196 | 33,260 | 333 | 333 | - | - | 806 | 25,029 | 333 | 333 | - | 333 | 333 | 333 | 2,045 | 333 | 333 | 333 | - | - | - Tax already paid in August 2021 | 2,134 | 999 | 16,889 | 6,329 | 100,868 | 999 | 999 | - | 333 | 2,371 | 76,357 | 999 | 999 | - | 999 | 999 | 999 | 5,794 | 999 | 999 | 728 | 333 | 333 | - | 222,459 Tax to be paid for September, 2021 | 664 | 333 | 5,803 | 2,225 | 33,140 | 333 | 333 | - | - | 812 | 24,888 | 333 | 333 | - | 333 | 333 | 333 | 2,083 | 333 | 333 | 364 | - | - | - | 73,309 0 | 0 | 0 TS Tech Bangladesh Limited. Assessment Year: 2021-2022 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [November 2021] Female | Female | Female Employees ID | 000002 | 000003 | 000011 | 000012 | 000014 | 000015 | 000036 | 000037 | 000038 | 000116 | 000117 | 000148 | 000218 | 000286 | 000301 | 000473 | 000809 | 000819 | 001243 | 001257 | 001326 | 800003 | 800004 | 800005 Monthly basic Salary Jul'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Aug'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Sep'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 Oct'21 | 44,329 | 29,852 | 70,027 | 53,920 | 140,431 | 19611 | 20545 | 16983 | 18396 | 45617 | 119,525 | 32,665 | 25636 | 16800 | 25033 | 21922 | 20617 | 56,264 | 21670 | 21035 | 44366 | 17778 | 16972 | 16194 | 916,188 Nov'21 Dec'21 Jan'22 Feb'22 Mar'22 | - Apr'22 May'22 Jun'22 | - Basic Salary yearly | 531,948 | 358,224 | 840,324 | 647,040 | 1,685,172 | 235,332 | 246,540 | 203,796 | 220,752 | 547,404 | 1,434,300 | 391,980 | 307,632 | 201,600 | 300,396 | 263,064 | 247,404 | 675,168 | 260,040 | 252,420 | 532,392 | 213,336 | 203,664 | 194,328 | 10,994,256 House rent | 265,974 | 179,112 | 420,162 | 323,520 | 842,586 | 117,666 | 123,270 | 101,898 | 110,376 | 273,702 | 717,150 | 195,990 | 153,816 | 100,800 | 150,198 | 131,532 | 123,702 | 337,584 | 130,020 | 126,210 | 266,196 | 106,668 | 101,832 | 97,164 | 5,497,128 Less: exemption, A | (265,974) | (179,112) | (300,000) | (300,000) | (300,000) | (117,666) | (123,270) | (101,898) | (110,376) | (273,702) | (300,000) | (195,990) | (153,816) | (100,800) | (150,198) | (131,532) | (123,702) | (300,000) | (130,020) | (126,210) | (266,196) | (106,668) | (101,832) | (97,164) Medical allowance | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 | 17,400 Less: exemption, B | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) | (17,400) Telephone | 24,000 | 18,000 | 24,000 | 24,000 | 36,000 | 12,000 | 12,000 | 6,000 | 12,000 | 24,000 | 36,000 | 18,000 | 18,000 | 6,000 | 12,000 | 18,000 | 6,000 | 24,000 | 18,000 | 18,000 | 24,000 | - | - | - | 390,000 Less: exemption Conveyance | - | - | - | - | - | 22,410 | 7,920 | 7,380 | 7,380 | - | - | 21,300 | 7,920 | 27,720 | 9,960 | 9,240 | 0 | 0 | 26,400 | 10,080 | 0 | 10,650 | 9,150 | 9,750 | 187,260 Less: exemption, C | - | - | - | - | - | (22,410) | (7,920) | (7,380) | (7,380) | - | - | (21,300) | (7,920) | (27,720) | (9,960) | (9,240) | - | - | (26,400) | (10,080) | - | (10,650) | (9,150) | (9,750) Bonus | 88,658 | 59,704 | 140,054 | 107,840 | 280,862 | 39,222 | 41,090 | 33,966 | 36,792 | 91,234 | 239,050 | 65,330 | 51,272 | 33,600 | 50,066 | 43,844 | 41,234 | 112,528 | 43,340 | 42,070 | 88,732 | 35,556 | 33,944 | 32,388 | 1,832,376 Overtime & deduction | 1400 | 1473 | 0 | 200 | 0 | 1979 | 6121 | 2817 | 1227 | 0 | 0 | 55256 | 5479 | 641 | -630 | 1516 | 727 | 2327 | -1319 | 7925 | -78 | 18008 | 5933 | 2094 | 113,096 Provident Fund(July'21~June'22) | 3,693 | 2,487 | 5,833 | 4,492 | 11,698 | 1,634 | 1,711 | 1,415 | 1,532 | 3,800 | 9,956 | 2,721 | 2,135 | 1,399 | 2,085 | 1,826 | 1,717 | 4,687 | 1,805 | 1,752 | 3,696 | 1,481 | 1,414 | 1,349 | 76,318 Provident Fund Considering Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 Provident Fund (Total) | 44,311 | 29,840 | 69,999 | 53,898 | 140,375 | 19,603 | 20,537 | 16,976 | 18,389 | 45,599 | 119,477 | 32,652 | 25,626 | 16,793 | 25,023 | 21,913 | 20,609 | 56,241 | 21,661 | 21,027 | 44,348 | 17,771 | 16,965 | 16,188 | 915,821 Taxable income | 690,317 | 467,241 | 1,194,539 | 856,498 | 2,684,995 | 308,136 | 326,288 | 263,555 | 289,160 | 708,237 | 2,245,977 | 563,218 | 408,009 | 258,634 | 386,855 | 348,337 | 315,974 | 907,848 | 341,722 | 341,442 | 689,394 | 284,671 | 260,506 | 244,998 | 15,386,551 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 407 | 1,314 | - | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 4,343 | 2,417 | 799 | 5,000 | 2,086 | 2,072 | 5,000 | - | - | - 300,000 | 10% | 29,032 | 1,724 | 30,000 | 30,000 | 30,000 | - | - | - | 30,000 | 30,000 | 16,322 | 801 | - | - | - | - | 30,000 | - | - | 23,939 | - | - | - 400,000 | 15% | - | - | 60,000 | 23,475 | 60,000 | - | - | - | - | 1,236 | 60,000 | - | - | - | - | - | - | 23,677 | - | - | - | - | - | - 500,000 | 20% | - | - | 18,908 | - | 100,000 | - | - | - | - | - | 100,000 | - | - | - | - | - | - | - | - | - | - | - | - | - Balance | 25% | - | - | - | - | 271,249 | - | - | - | - | - | 161,494 | - | - | - | - | - | - | - | - | - | - | - | - | - Total Tax liability | 34,032 | 6,724 | 113,908 | 58,475 | 466,249 | 407 | 1,314 | - | - | 36,236 | 356,494 | 21,322 | 5,801 | - | 4,343 | 2,417 | 799 | 58,677 | 2,086 | 2,072 | 28,939 | - | - | - Allowable Investment 25% of Total Income | 172,579 | 116,810 | 298,635 | 214,125 | 671,249 | 77,034 | 81,572 | 65,889 | 72,290 | 177,059 | 561,494 | 140,805 | 102,002 | 64,659 | 96,714 | 87,084 | 78,994 | 226,962 | 85,431 | 85,361 | 172,349 | 71,168 | 65,127 | 61,250 Less: Investment Allowance, D | (25,887) | (17,522) | (44,795) | (32,119) | (67,125) | (11,555) | (12,236) | (9,883) | (10,844) | (26,559) | (56,149) | (21,121) | (15,300) | (9,699) | (14,507) | (13,063) | (11,849) | (34,044) | (12,815) | (12,804) | (25,852) | (10,675) | (9,769) | (9,187) Net Tax liability | 8,145 | (10,797) | 69,113 | 26,356 | 399,124 | (11,148) | (10,921) | (9,883) | (10,844) | 9,677 | 300,345 | 201 | (9,499) | (9,699) | (10,164) | (10,646) | (11,050) | 24,633 | (10,728) | (10,732) | 3,087 | (10,675) | (9,769) | (9,187) Previous Tax Adjustment (Excess Paid) | - Net/ Minimum Tax liability | 8,145 | 4,000 | 69,113 | 26,356 | 399,124 | 4,000 | 4,000 | - | 9,677 | 300,345 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 24,633 | 4,000 | 4,000 | 4,000 | - | - | - | 881,392 Monthly tax deduction (avg. rate) | 679 | 333 | 5,759 | 2,196 | 33,260 | 333 | 333 | - | - | 806 | 25,029 | 333 | 333 | - | 333 | 333 | 333 | 2,053 | 333 | 333 | 333 | - | - | - Tax already paid till September 2021 | 2,798 | 1,332 | 22,692 | 8,554 | 134,008 | 1,332 | 1,332 | - | 333 | 3,183 | 101,245 | 1,332 | 1,332 | - | 1,332 | 1,332 | 1,332 | 7,877 | 1,332 | 1,332 | 1,092 | 333 | 333 | - | 295,768 Tax to be paid for October, 2021 | 668 | 334 | 5,803 | 2,225 | 33,139 | 334 | 334 | - | - | 812 | 24,887 | 334 | 334 | - | 334 | 334 | 334 | 2,094 | 334 | 334 | 364 | - | - | - | 73,332 0 | 0 | 0 TS Tech Bangladesh Limited. Assessment Year: 2022-2023 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment. [January 2022] Sl. No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 Female | Female | Female Name of the Employees | MD.TANZIR HOSSAIN | JAMIL MAHMUD | GOLAM MOSABBIR | MD. FOYSAL AHMED | MD EMRAN NUR | NUZAT TABASSUM HRIDY | AMDADUL HAQUE | NIRJOL BHAKTA | SYED RIYAD HOSEN | ABU KAOSAR | JAKIUL KARIM AMMAR | HABIBUL HAQUE | AMDADUL HOQUE MILON | AL AMRAN HABIB | ROMANUR ISLAM RONI | ROHIT NANDAN SINGH | VINODKUMAR GUPTA | MASRUBA RAHMAN | NAYMUL HAQUE | ESHWAR RAO KOTA | KAWSAR HAMID KOLLOL | UTPAL DEY | RAKIBUL HASAN | ARINDAM HALDAR | SABBIR HOSEN | RUBEL MIA | AVIZIT SUTRADHAR | SHUVJIT MONDAL | HASNATH MAHMUD | KOUSHIK SINGHA | ANKIT SARKAR | ZAHID HOSSAIN | BUSHRA TABASSUM | SUVASH CHANDRA BISWASH | MAHFUZUL HAQUE MARUF | HARPREETH SINGH | Waskuruni Shamim | Kakan Adhikari | Total Monthly basic Salary | Month Jul'21 | 37,050 | 19,200 | 62,100 | 39,600 | 24,000 | 9,000 | 33,000 | 24,000 | - | 33,000 | 73,200 | 58,200 | 36,000 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 24,000 | 90,000 | 12,000 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 9,000 | 15,000 | 98,900 | 100,500 | 23,925 | 24,000 | 51,000 | 1,271,285 Aug'21 | 37,050 | 19,200 | 62,100 | 39,600 | 24,000 | 12,000 | 33,000 | 24,000 | - | 33,000 | 73,200 | 58,200 | 36,000 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 24,000 | 90,000 | 12,000 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 98,900 | 100,500 | 23,925 | 24,000 | 51,000 | 1,277,285 Sep'21 | 37,050 | 19,200 | 62,100 | 39,600 | 24,000 | 12,000 | 33,000 | 24,000 | 13,200 | 33,000 | 73,200 | 58,200 | 36,000 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 12,000 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 98,900 | 100,500 | 23,925 | 24,000 | 51,000 | 1,294,085 Oct'21 | 37,050 | 19,200 | 62,100 | 39,600 | 24,000 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 58,200 | 36,000 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 12,000 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 98,900 | 103,500 | 23,925 | 24,000 | 51,000 | 1,303,085 Nov'21 | 37,050 | 19,200 | 62,100 | 39,600 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 58,200 | 36,000 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 12,000 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 98,900 | 103,500 | 23,925 | 24,000 | 51,000 | 96,000 | 1,413,485 Dec'21 | 37,050 | 24,000 | 62,100 | 39,600 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 58,200 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 24,000 | 51,000 | 96,000 | 1,498,935 Jan'22 | 37,050 | 24,000 | 62,100 | 44,429 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,368 | 53,468 | 96,000 | 18,000 | 12,000 Feb'22 | 37,050 | 24,000 | 62,100 | 45,144 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,600 | 56,100 | 96,000 | 18,000 | 12,000 Mar'22 | 37,050 | 24,000 | 62,100 | 45,144 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,600 | 56,100 | 96,000 | 18,000 | 12,000 Apr'22 | 37,050 | 24,000 | 62,100 | 45,144 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,600 | 56,100 | 96,000 | 18,000 | 12,000 May'22 | 37,050 | 24,000 | 62,100 | 45,144 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,600 | 56,100 | 96,000 | 18,000 | 12,000 Jun'22 | 37,050 | 24,000 | 62,100 | 45,144 | 26,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 73,200 | 66,600 | 39,600 | 15,000 | 23,400 | 90,000 | 86,000 | 19,800 | 27,600 | 90,000 | 16,800 | 72,250 | 20,160 | 21,600 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 72,250 | 98,900 | 103,500 | 23,925 | 27,600 | 56,100 | 96,000 | 18,000 | 12,000 Previous Gross Salary | 61,750 | 32,000 | 103,500 | 66,000 | 40,000 | 15,000 | 55,000 | 40,000 | 22,000 | 55,000 | 122,000 | 97,000 | 60,000 | 25,000 | 39,000 | 150,000 | 122,000 | 33,000 | 40,000 | 150,000 | 20,000 | 95,000 | 33,600 | 36,000 | 23,000 | 21,000 | 15,000 | 25,000 | 20,000 | 100,000 | 145,482 | 150,000 | 39,875 | 40,000 | 85,000 | 160,000 | 30,000 | 20,000 Latest Gross Salary | 61,750 | 40,000 | 103,500 | 66,000 | 44,000 | 20,000 | 60,000 | 45,000 | 22,000 | 55,000 | 122,000 | 111,000 | 66,000 | 25,000 | 39,000 | 150,000 | 122,000 | 33,000 | 46,000 | 150,000 | 28,000 | 95,000 | 33,600 | 36,000 | 23,000 | 21,000 | 20,000 | 25,000 | 20,000 | 100,000 | 145,482 | 172,500 | 39,875 | 46,000 | 93,500 | 160,000 | 30,000 | 20,000 | 2,490,207 Total Gross Salary | 741,000 | 440,000 | 1,242,000 | 666,025 | 512,000 | 235,000 | 705,000 | 525,000 | 264,000 | 660,000 | 1,464,000 | 1,248,000 | 762,000 | 300,000 | 468,000 | 1,800,000 | 1,464,000 | 396,000 | 540,000 | 1,800,000 | 296,000 | 1,140,000 | 403,200 | 432,000 | 276,000 | 252,000 | 235,000 | 300,000 | 160,000 | 700,000 | 1,745,784 | 2,002,500 | 478,500 | 515,640 | 1,066,580 | 1,280,000 | 180,000 | 120,000 Basic Salary yearly | 444,600 | 264,000 | 745,200 | 507,749 | 307,200 | 141,000 | 423,000 | 315,000 | 132,000 | 396,000 | 878,400 | 748,800 | 457,200 | 180,000 | 280,800 | 1,080,000 | 1,032,000 | 237,600 | 324,000 | 1,080,000 | 177,600 | 867,000 | 241,920 | 259,200 | 165,600 | 151,200 | 141,000 | 180,000 | 96,000 | 505,750 | 1,186,800 | 1,233,000 | 287,100 | 309,368 | 639,968 | 768,000 | 108,000 | 72,000 House rent | 222,300 | 132,000 | 372,600 | 253,875 | 153,600 | 70,500 | 211,500 | 157,500 | 66,000 | 198,000 | 439,200 | 374,400 | 228,600 | 90,000 | 140,400 | 540,000 | 300,000 | 118,800 | 162,000 | 540,000 | 88,800 | 180,000 | 120,960 | 129,600 | 82,800 | 75,600 | 70,500 | 90,000 | 48,000 | 140,000 | 371,304 | 616,500 | 143,550 | 154,684 | 319,984 | 384,000 | 54,000 | 36,000 Less: exemption, A | (222,300) | (132,000) | (300,000) | (253,875) | (153,600) | (70,500) | (211,500) | (157,500) | (66,000) | (198,000) | (300,000) | (300,000) | (228,600) | (90,000) | (140,400) | (300,000) | (300,000) | (118,800) | (162,000) | (300,000) | (88,800) | (180,000) | (120,960) | (129,600) | (82,800) | (75,600) | (70,500) | (90,000) | (48,000) | (140,000) | (300,000) | (300,000) | (143,550) | (154,684) | (300,000) | (300,000) | (54,000) | (36,000) Medical allowance | 44,460 | 26,400 | 74,520 | 50,775 | 30,720 | 14,100 | 42,300 | 31,500 | 13,200 | 39,600 | 87,840 | 74,880 | 45,720 | 18,000 | 28,080 | 108,000 | 102,000 | 23,760 | 32,400 | 108,000 | 17,760 | 69,000 | 24,192 | 25,920 | 16,560 | 15,120 | 14,100 | 18,000 | 9,600 | 35,000 | 118,680 | 123,300 | 28,710 | 30,937 | 63,997 | 76,800 | 10,800 | 7,200 Less: exemption, B | (44,460) | (26,400) | (74,520) | (50,775) | (30,720) | (14,100) | (42,300) | (31,500) | (13,200) | (39,600) | (87,840) | (74,880) | (45,720) | (18,000) | (28,080) | (108,000) | (102,000) | (23,760) | (32,400) | (108,000) | (17,760) | (69,000) | (24,192) | (25,920) | (16,560) | (15,120) | (14,100) | (18,000) | (9,600) | (35,000) | (118,680) | (120,000) | (28,710) | (30,937) | (63,997) | (76,800) | (10,800) | (7,200) Telephone & Mobile Less: exemption Conveyance | 29,640 | 17,600 | 49,680 | -146,373 | 20,480 | 9,400 | 28,200 | 21,000 | 52,800 | 26,400 | 58,560 | 49,920 | 30,480 | 12,000 | 18,720 | 72,000 | 30,000 | 15,840 | 21,600 | 72,000 | 11,840 | 24,000 | 16,128 | 17,280 | 11,040 | 10,080 | 9,400 | 12,000 | 6,400 | 19,250 | 69,000 | 29,700 | 19,140 | 20,651 | 42,631 | 51,200 | 7,200 | 4,800 Less: exemption, C | (29,640) | (17,600) | (30,000) | (30,000) | (20,480) | (9,400) | (28,200) | (21,000) | (30,000) | (26,400) | (30,000) | (30,000) | (30,000) | (12,000) | (18,720) | (30,000) | (30,000) | (15,840) | (21,600) | (30,000) | (11,840) | (24,000) | (16,128) | (17,280) | (11,040) | (10,080) | (9,400) | (12,000) | (6,400) | (19,250) | (30,000) | (29,700) | (19,140) | (20,651) | (30,000) | (30,000) | (7,200) | (4,800) Bonus | 74,100 | 47,040 | 124,200 | 92,664 | 50,400 | 12,000 | 36,000 | 27,000 | 13,200 | 33,000 | 146,400 | 124,800 | 75,600 | 15,000 | 23,400 | - | - | 37,950 | 54,000 | - | 30,000 | - | 20,160 | 32,400 | 13,800 | 12,600 | 12,000 | 15,000 | 12,000 | 304,500 | 50,243 | 51,600 | 107,100 | - | 18,000 | 12,000 Overtime & (Deductions) | - | 18,718 | - | - | (533) | (2,258) | 42,240 | 62,705 | 8,570 | 12,683 | - | - | 1,832 | 1,728 | - | - | 176,978 | 20,467 | 38,343 | 12,283 | 54,651 | 439,240 | 41,904 | 47,424 | 24,871 | 37,873 | 25,617 | 29,549 | 17,710 | 143,812 | 50,610 | (10,161) | 5,750 | 30,723 | 57,251 | 77,419 | 3,633 | - | 1,467,999 Taxable income | 518,700 | 329,758 | 961,680 | 424,040 | 357,067 | 150,742 | 501,240 | 404,705 | 176,570 | 441,683 | 1,192,560 | 967,920 | 535,112 | 196,728 | 304,200 | 1,362,000 | 1,208,978 | 296,017 | 416,343 | 1,374,283 | 262,251 | 1,306,240 | 303,984 | 339,024 | 204,271 | 201,673 | 178,617 | 224,549 | 125,710 | 649,562 | 1,347,714 | 1,847,139 | 343,093 | 391,691 | 836,934 | 950,619 | 129,633 | 84,000 Tax calculation 300,000 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - 100,000 | 5% | 5,000 | 1,488 | 5,000 | 5,000 | 2,853 | - | 5,000 | 5,000 | - | 5,000 | 5,000 | 5,000 | 5,000 | - | 210 | 5,000 | 5,000 | - | 5,000 | 5,000 | - | 5,000 | - | 1,951 | - | - | - | - | - | 5,000 | 5,000 | 5,000 | - | 4,585 | 5,000 | 5,000 | - | - 300,000 | 10% | 11,870 | - | 30,000 | 2,404 | - | - | 10,124 | 471 | - | 4,168 | 30,000 | 30,000 | 13,511 | - | - | 30,000 | 30,000 | - | 1,634 | 30,000 | - | 30,000 | - | - | - | - | - | - | - | 24,956 | 30,000 | 30,000 | - | - | 30,000 | 30,000 | - | - 400,000 | 15% | - | - | 39,252 | - | - | - | - | - | - | - | 60,000 | 40,188 | - | - | - | 60,000 | 76,347 | - | - | 60,000 | - | 60,000 | - | - | - | - | - | - | - | - | 60,000 | 60,000 | - | - | 20,540 | 37,593 | - | - 500,000 | 20% | - | - | - | - | - | - | - | - | - | - | 18,512 | - | - | - | - | 52,400 | - | - | - | 54,857 | - | 41,248 | - | - | - | - | - | - | - | - | 49,543 | 100,000 | - | - | - | - | - | - Balance | 25% | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 61,785 | - | - | - | - | - | - Total Tax liability | 16,870 | 1,488 | 74,252 | 7,404 | 2,853 | - | 15,124 | 5,471 | - | 9,168 | 113,512 | 75,188 | 18,511 | - | 210 | 147,400 | 111,347 | - | 6,634 | 149,857 | - | 136,248 | - | 1,951 | - | - | - | - | - | 29,956 | 144,543 | 256,785 | - | 4,585 | 55,540 | 72,593 | - | - Allowable Investment 25% of Total Income | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Less: Investment Allowance, D | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - Net Tax liability | 16,870 | 1,488 | 74,252 | 7,404 | 2,853 | - | 15,124 | 5,471 | - | 9,168 | 113,512 | 75,188 | 18,511 | - | 210 | 147,400 | 111,347 | - | 6,634 | 149,857 | - | 136,248 | - | 1,951 | - | - | - | - | - | 29,956 | 144,543 | 256,785 | - | 4,585 | 55,540 | 72,593 | - | - Previous Tax Adjustment (Excess Paid) | - Net/ Minimum Tax liability | 16,870 | 5,000 | 74,252 | 7,404 | 5,000 | - | 15,124 | 5,471 | - | 9,168 | 113,512 | 75,188 | 18,511 | - | 5,000 | 147,400 | 111,347 | - | 6,634 | 149,857 | - | 136,248 | - | 5,000 | - | - | - | - | - | 29,956 | 144,543 | 256,785 | - | 5,000 | 55,540 | 72,593 | - | - Tax already paid till December 2021 | 8,436 | 714 | 37,128 | 10,698 | 2,502 | 6,028 | 2,502 | 4,165 | 56,754 | 16,034 | 8,049 | 2,502 | 73,698 | 42,402 | 2,624 | 61,415 | 45,522 | 1,668 | 4,440 | 69,924 | 125,868 | 2,502 | 18,650 | 21,302 | - | - | 625,527 Tax to be paid for January 2022 | 1,406 | 714 | 6,187 | -549 | 416 | - | 1,516 | 495 | - | 834 | 9,460 | 9,859 | 1,744 | - | 416 | 12,284 | 11,491 | - | 668 | 14,740 | - | 15,121 | - | 555 | - | - | - | - | - | 4,253 | 12,436 | 21,819 | - | 416 | 6,148 | 8,548 | - | - Nippon Signal CO., Ltd. Assessment Year: 2022-2023 Note: the company should deduct monthly as above A = exemption (lower of 50% of basic or Tk. 300,000) B = exemption (lower of 10% of basic or Tk. 120,000) C = exemption upto Tk. 30,000 D = investment Allowance > 25% taxable income * (15% if total income under Tk. 1.5 Million, 10% if above 1.5 Million) Note: If the employees do not invest the respective fields that is mentioned in 6th Schedule Part-B of income tax ordinance, the employees have to pay tax, i.e the employees do not rebate for investment.