[Salary Calculation]
Toyoshima & Co., Ltd. (Bangladesh Liaison Office)
Statement of Salary & Allowances
For the month of January' 2022
Sl.No. | Name | Designation | Joining Date | Basic Salary | House Rent | Performance Bonus | Conveyance | Medical Allowance | Other Allowance | Gross Salary | Days of Month | Eid Bonus | Total Payable | Deduction | Net Payable | Remarks
Tax | Increment/Adjustment
01 | Md.Abidur Rahman | Manager | 01/10/2018 | 120,000 | 60,000 | 5,500 | 2,500 | 12,000 | 27,469 | 227,469 | 31 | 227,469 | 27,469 | 200,000 | Tax has been Re-vised.
02 | Robin Barua | Assistant Manager | 01/10/2018 | 79,200 | 39,600 | 2,780 | 2,500 | 7,920 | 7,406 | 139,406 | 31 | 139,406 | 7,406 | 132,000
03 | Mohammad Asaduzzaman Khan | Staff | 01/10/2018 | 40,200 | 20,100 | 2,680 | 4,020 | 417 | 67,417 | 31 | 67,417 | 417 | 67,000
04 | Md.Mosaddequl Haque | Assistant | 01/10/2018 | 31,800 | 15,900 | 2,120 | 3,180 | 417 | 53,417 | 31 | 53,417 | 417 | 53,000
05 | Md.Jamal Hossain | Quality Management | 01/10/2018 | 28,200 | 14,100 | 1,880 | 2,820 | 417 | 47,417 | 31 | 47,417 | 417 | 47,000
06 | Didarul Alom | Quality Management | 01/10/2018 | 25,800 | 12,900 | 1,720 | 2,580 | 417 | 43,417 | 31 | 43,417 | 417 | 43,000
07 | Sihab Ahmed | Quality Management | 01/10/2018 | 26,400 | 13,200 | 1,760 | 2,640 | 417 | 44,417 | 31 | 44,417 | 417 | 44,000
08 | Md.Kamrul Hasan | Quality Management | 01/10/2018 | 21,000 | 10,500 | 1,400 | 2,100 | - | 35,000 | 31 | 35,000 | - | 35,000
09. | Muhammad Eftakhar Uddin | Production Coordinator | 01/09/2019 | 39,600 | 19,800 | 2,640 | 3,960 | 417 | 66,417 | 31 | 66,417 | 417 | 66,000
10 | Md.Moshiur Rahman | Quality Assurance officer | 20/5/2021 | 25,000 | 12,500 | 2,500 | 2,500 | 917 | 43,417 | 31 | 43,417 | 417 | 43,000
Total | 437,200 | 218,600 | 8,280 | 21,700 | 43,720 | 38,294 | 767,794 | - | 767,794 | 37,794 | - | 730,000
Note: 1) Month has been considered from 1st January 2022 to 31th January 2022.
________________________
Prepared By | Checked By | Approved By
105000
78000
37800
30000
27000
24600
25200
18600
105000 | 78000 | 37800 | 30000 | 27000 | 24600 | 25200 | 18600
[Sheet1]
20-21
Basic Salary | House Rent | Performance Bonus | Conveyance | Medical Allowance | Other Allowance | Gross Salary
Md.Abidur Rahman | 175,000 | 180000
Robin Barua | 130,000 | 132000
Mohammad Asaduzzaman Khan | 63,000 | 67000
Md.Mosaddequl Haque | 30,000 | 15000 | 2,000 | 3000 | 50,000 | 53000
Md.Jamal Hossain | 27,000 | 13500 | 1,800 | 2700 | 45,000 | 47000
Didarul Alom | 24,600 | 12300 | 1,640 | 2460 | 41,000 | 43000
Sihab Ahmed | 25,200 | 12600 | 1,680 | 2520 | 42,000 | 44000
Md.Kamrul Hasan | 18,600 | 9300 | 1,240 | 1860 | 31,000 | 35000
Muhammad Eftakhar Uddin | 37,800 | 18900 | 2,520 | 3780 | 63,000 | 66000
Md.Moshiur Rahman | 25,000 | 12,500 | - | 2,500 | 2,500 | 500 | 43,000 | 43000
21-22( Per Month salary)
Basic Salary | House Rent | Performance Bonus | Conveyance | Medical Allowance | Other Allowance | Gross Salary | Bonus
Name
1 | Md.Abidur Rahman | 108,000 | 54000 | 4400 | 2,800 | 10800 | 180000 | 180,000 | 175000 | 180000 | 355000 | Gross Salary
2 | Robin Barua | 79,200 | 39600 | 2780 | 2,500 | 7920 | 132000 | 132,000 | 78000 | 79,200 | 157200 | Basic Salary
3 | Mohammad Asaduzzaman Khan | 40,200 | 20100 | 2,680 | 4020 | 67000 | 67,000 | 37,800 | 40,200 | 78000
4 | Md.Mosaddequl Haque | 31,800 | 15900 | 2,120 | 3180 | 53000 | 53,000 | 30,000 | 31,800 | 61800
5 | Md.Jamal Hossain | 28,200 | 14100 | 1,880 | 2820 | 47000 | 47,000 | 27,000 | 28,200 | 55200
6 | Didarul Alom | 25,800 | 12900 | 1,720 | 2580 | 43000 | 43,000 | 24,600 | 25,800 | 50400
7 | Sihab Ahmed | 26,400 | 13200 | 1,760 | 2640 | 44000 | 44,000 | 25,200 | 26,400 | 51600
8 | Md.Kamrul Hasan | 21,000 | 10500 | 1,400 | 2100 | 35000 | 35,000 | 18,600 | 21,000 | 39600
9 | Muhammad Eftakhar Uddin | 39,600 | 19800 | 2,640 | 3960 | 66000 | 66,000 | 37,800 | 39,600 | 77400
10 | Md.Moshiur Rahman | 25,000 | 12,500 | - | 2,500 | 2500 | 500 | 43000 | 43,000 | 25,000 | 25,000 | 50000
Per Month | 425,200 | 212600 | 7180 | 22000 | 42520 | 500 | 710000 | 976200
Yearly | 5,102,400 | 2551200 | 86160 | 264000 | 510240 | 6000 | 8520000
Yearly: IY 21-22 | Annual Basic Salary | Annual House Rent | Annual Performance Bonus | Annual Conveyance | Annual Medical Allowance | Annual Other Allowance | Annual Gross Salary
SL No | Name
1 | Md.Abidur Rahman | 1,296,000 | 648,000 | 52,800 | 33,600 | 129,600 | - | 2,160,000
2 | Robin Barua | 950,400 | 475,200 | 33,360 | 30,000 | 95,040 | - | 1,584,000
3 | Mohammad Asaduzzaman Khan | 482,400 | 241,200 | - | 32,160 | 48,240 | - | 804,000
4 | Md.Mosaddequl Haque | 381,600 | 190,800 | - | 25,440 | 38,160 | - | 636,000
5 | Md.Jamal Hossain | 338,400 | 169,200 | - | 22,560 | 33,840 | - | 564,000
6 | Didarul Alom | 309,600 | 154,800 | - | 20,640 | 30,960 | - | 516,000
7 | Sihab Ahmed | 316,800 | 158,400 | - | 21,120 | 31,680 | - | 528,000
8 | Md.Kamrul Hasan | 252,000 | 126,000 | - | 16,800 | 25,200 | - | 420,000
9 | Muhammad Eftakhar Uddin | 475,200 | 237,600 | - | 31,680 | 47,520 | - | 792,000
10 | Md.Moshiur Rahman | 300,000 | 150,000 | - | 30,000 | 30,000 | 6,000 | 516,000
5,102,400 | 2,551,200 | 86,160 | 264,000 | 510,240 | 6,000 | 8,520,000
[Changed Tax Calculation]
TOYOSHIMA & CO., LTD.
Computation of Income and Tax Liability
Income year 2021-2022
Assessmnet year 2022 - 2023 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Name of Employees | Md.Abidur Rahman | Robin Barua | Mohammad Asaduzzaman Khan | Md.Mosaddequl Haque | Md.Jamal Hossain | Didarul Alom | Sihab Ahmed | Md.Kamrul Hasan | Muhammad Eftakhar Uddin | Md.Moshiur Rahman | Total | Reconcile Area
TIN Number
Income from Salary:
Basic salary:
For the month from Jul '21 - Jun '22 | 1,296,000 | 950,400 | 482,400 | 381,600 | 338,400 | 309,600 | 316,800 | 252,000 | 475,200 | 300,000 | 5,102,400 | 5,102,400 | -
House rent allowance | 648,000 | 475,200 | 241,200 | 190,800 | 169,200 | 154,800 | 158,400 | 126,000 | 237,600 | 150,000 | 2,551,200 | 2,551,200 | -
Less: Exempt (50% of basic) or (Tk. 25,000 per month) whichever is lower | 300,000 | 300,000 | 241,200 | 190,800 | 169,200 | 154,800 | 158,400 | 126,000 | 237,600 | 150,000 | 2,028,000
348,000 | 175,200 | - | - | - | - | - | - | - | - | 523,200
Conveyance allowance | 33,600 | 30,000 | 32,160 | 25,440 | 22,560 | 20,640 | 21,120 | 16,800 | 31,680 | 30,000 | 264,000 | 264,000 | -
Less: Exempt | 30,000 | 30,000 | 30,000 | 25,440 | 22,560 | 20,640 | 21,120 | 16,800 | 30,000 | 30,000 | 256,560
3,600 | - | 2,160 | - | - | - | - | - | 1,680 | - | 7,440
Medical allowance | 129,600 | 95,040 | 48,240 | 38,160 | 33,840 | 30,960 | 31,680 | 25,200 | 47,520 | 30,000 | 510,240 | 510,240 | -
Less: Exempt (10% of basic) or Tk. 120,000 whichever is lower | 120,000 | 95,040 | 48,240 | 38,160 | 33,840 | 30,960 | 31,680 | 25,200 | 47,520 | 30,000 | 500,640
9,600 | - | - | - | - | - | - | - | - | - | 9,600
Other Allowance | 6,000 | 6,000
Performance Bonus | 52,800 | 33,360 | - | - | - | - | - | - | - | - | 86,160 | 86,160 | -
Festival Bonus | 355,000 | 157,200 | 78,000 | 61,800 | 55,200 | 50,400 | 51,600 | 39,600 | 77,400 | 50,000 | 976,200 | 976,200 | -
Total Taxable Income of Salary | 2,065,000 | 1,316,160 | 562,560 | 443,400 | 393,600 | 360,000 | 368,400 | 291,600 | 554,280 | 356,000 | 6,711,000 | 9,490,200
Taxability Check | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | FALSE | TRUE | TRUE | TRUE
Tax Calculation: | 9,496,200
On 1st | Tk. | 300,000 | @ | Nil | - | - | - | - | - | - | - | - | - | - | - | 6,000
On next | Tk. | 100,000 | @ | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 4,680 | 3,000 | 3,420 | 5,000 | 2,800 | 33,760
On next | Tk. | 300,000 | @ | 10% | 30,000 | 30,000 | 16,256 | 4,340 | 15,428 | 92,424
On next | Tk. | 400,000 | @ | 15% | 60,000 | 60,000 | 120,000
On next | Tk. | 500,000 | @ | 20% | 100,000 | 43,232 | 138,480
On next | Tk. | Balance Amount | @ | 25% | 116,250 | - | 100,000
Gross tax liability | 311,250 | 138,232 | 21,256 | 9,340 | 4,680 | 3,000 | 3,420 | - | 20,428 | 2,800 | 514,406
Rebate on Investment Allowance:
(25% of total income Tk. | 516,250 | 329,040 | 140,640 | 110,850 | 98,400 | 90,000 | 92,100 | 72,900 | 138,570 | 89,000 | -
or actual investment Tk. | 100% | 516,250 | 329,040 | 140,640 | 110,850 | 98,400 | 90,000 | 92,100 | 72,900 | 138,150 | 87,500 | -
or Tk. 10,000,000 | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore | 1.0 Crore
Whichever is lower | 516,250 | 329,040 | 140,640 | 110,850 | 98,400 | 90,000 | 92,100 | 72,900 | 138,150 | 87,500 | 1,675,830
Base test of Investment Allowance (U/S - 44)
whichever is lower X 15% or 10% | 51,625 | 49,356 | 21,096 | 16,628 | 14,760 | 13,500 | 13,815 | 10,935 | 20,723 | 13,125
Net Tax Liability | 259,625 | 88,876 | 160 | (7,288) | (10,080) | (10,500) | (10,395) | (10,935) | (295) | (10,325)
Unpaid Tax /Due Tax | 259,625 | 88,876 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 5,000
TDS already Paid
Unpaid Tax /Due Tax for 12 Months payable from July 2021 to June 2022 | 259,625 | 88,876 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 5,000 | 383,501
Calculating Month | 12 | Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Monthly deducted by Company | 21,635 | 7,406 | 417 | 417 | 417 | 417 | 417 | - | 417 | 417 | 31,958
Note:
01. Minimum Tax Is 5000 for Dhaka (North & South) City corporation.
02. Financial Year: 2021-2022
03. Other Allowance is solely of Net Tax Amount.
360,015