[Salary Calculation]
Toyoshima & Co., Ltd. (Bangladesh Liaison Office)
Statement of Salary & Allowances
For the month of June 2021
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 | 105,000 | 30,000 | 26,700 | 2,800 | 10,500 | 20,417 | 195,417 | 30 | 195,417 | 20,417 | 175,000 | Tax has been Re-vised.
02 | Robin Barua | Assistant Manager | 01/10/2018 | 78,000 | 30,000 | 9,200 | 5,000 | 7,800 | 7,085 | 137,085 | 30 | 137,085 | 7,085 | 130,000
03 | Mohammad Asaduzzaman Khan | Staff | 01/10/2018 | 37,800 | 18,900 | 2,520 | 3,780 | 417 | 63,417 | 30 | 63,417 | 417 | 63,000
04 | Md.Mosaddequl Haque | Assistant | 01/10/2018 | 30,000 | 15,000 | 2,000 | 3,000 | 417 | 50,417 | 30 | 50,417 | 417 | 50,000
05 | Md.Jamal Hossain | Quality Management | 01/10/2018 | 27,000 | 13,500 | 1,800 | 2,700 | 417 | 45,417 | 30 | 45,417 | 417 | 45,000
06 | Didarul Alom | Quality Management | 01/10/2018 | 24,600 | 12,300 | 1,640 | 2,460 | 417 | 41,417 | 30 | 41,417 | 417 | 41,000
07 | Sihab Ahmed | Quality Management | 01/10/2018 | 25,200 | 12,600 | 1,680 | 2,520 | 417 | 42,417 | 30 | 42,417 | 417 | 42,000
08 | Md.Kamrul Hasan | Quality Management | 01/10/2018 | 18,600 | 9,300 | 1,240 | 1,860 | - | 31,000 | 30 | 31,000 | - | 31,000
09. | Muhammad Eftakhar Uddin | Production Coordinator | 01/09/2019 | 37,800 | 18,900 | 2,520 | 3,780 | 417 | 63,417 | 30 | 63,417 | 417 | 63,000
10 | Md.Moshiur Rahman | Quality Assurance officer | 20/5/2021 | 25,000 | 12,500 | 2,500 | 2,500 | 500 | 43,000 | 30 | 43,000 | - | 43,000
Total | 409,000 | 173,000 | 35,900 | 23,700 | 40,900 | 30,504 | 713,004 | - | 713,004 | 30,004 | - | 683,000
Note: 1) Month has been considered from 1st June 2021 to 30th June 2021.
________________________
Prepared By | Checked By | Approved By
105000
78000
37800
30000
27000
24600
25200
18600
105000 | 78000 | 37800 | 30000 | 27000 | 24600 | 25200 | 18600
[Updated Summary of Salary]
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 | 50,000
90,000 | 90,000
Mr. Rajib kumar Saha | 90,000 | 45,000 | 3,500 | 2,500 | 9000 | 150000 | 90,000
Per Month | 515,200 | 257,600 | 10,680 | 24,500 | 51,520 | 500 | 860,000 | 976200
Yearly | 6,182,400 | 3091200 | 128160 | 294000 | 618240 | 6000 | 10320000
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
11 | Mr. Rajib kumar Saha | 450,000 | 225,000 | 17,500 | 12,500 | 45,000 | - | 750,000
5,552,400 | 2,776,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 | 11 | 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 | Mr. Rajib kumar Saha | 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 | 450,000 | 5,552,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 | 225,000 | 2,776,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 | 125,000 | 2,153,000
348,000 | 175,200 | - | - | - | - | - | - | - | - | 100,000 | 523,200
Conveyance allowance | 33,600 | 30,000 | 32,160 | 25,440 | 22,560 | 20,640 | 21,120 | 16,800 | 31,680 | 30,000 | 12,500 | 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 | 12,500 | 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 | 45,000 | 555,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 | 45,000 | 545,640
9,600 | - | - | - | - | - | - | - | - | - | - | 9,600
Other Allowance | 6,000 | 6,000
Performance Bonus | 52,800 | 33,360 | - | - | - | - | - | - | - | - | 17,500 | 103,660 | 86,160 | -
Festival Bonus | 355,000 | 157,200 | 78,000 | 61,800 | 55,200 | 50,400 | 51,600 | 39,600 | 77,400 | 50,000 | 90,000 | 1,066,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 | 657,500 | 7,368,500 | 9,490,200
Taxability Check | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | FALSE | TRUE | 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 | 5,000 | 33,760
On next | Tk. | 300,000 | @ | 10% | 30,000 | 30,000 | 16,256 | 4,340 | 15,428 | 25,750 | 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 | 30,750 | 545,156
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 | 164,375 | -
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 | 164,375 | -
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 | 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 | 164,375 | 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 | 24,656
Net Tax Liability | 259,625 | 88,876 | 160 | (7,288) | (10,080) | (10,500) | (10,395) | (10,935) | (295) | (10,325) | 6,094
Unpaid Tax /Due Tax | 259,625 | 88,876 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 5,000 | 6,094
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 | 6,094 | 383,501
Calculating Month | 12 | Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 5 | 12
Monthly deducted by Company | 21,635 | 7,406 | 417 | 417 | 417 | 417 | 417 | - | 417 | 417 | 1,219 | 33,177
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
[new salary sheet ]
NAME | FROM JULY 2021 (PAYMENT FROM AUGUST )
ABIDUR RAHMAN | BDT 180,000
ROBIN BARUA | BDT 132,000
ASADUZZAMAN KHAN | BDT 67,000
MOSADDEQUL HIMU | BDT 53,000
SHAHRIAR EFTEKHAR | BDT 66,000
JAMAL HOSSAIN | BDT 47,000
DIDAR ALAM | BDT 43,000
SIHAB AHMED | BDT 44,000
KAMRUL HASAN | BDT 35,000
MOSHIUR RAHMAN | BDT 43,000
TOTAL | BDT 710,000