[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
[Sheet1]
Basic Salary | House Rent | Performance Bonus | Conveyance | Medical Allowance | Other Allowance | Gross Salary
Md.Abidur Rahman | 175,000
Robin Barua | 130,000
Mohammad Asaduzzaman Khan | 63,000
Md.Mosaddequl Haque | 30,000 | 15000 | 2,000 | 3000 | 50,000
Md.Jamal Hossain | 27,000 | 13500 | 1,800 | 2700 | 45,000
Didarul Alom | 24,600 | 12300 | 1,640 | 2460 | 41,000
Sihab Ahmed | 25,200 | 12600 | 1,680 | 2520 | 42,000
Md.Kamrul Hasan | 18,600 | 9300 | 1,240 | 1860 | 31,000
Muhammad Eftakhar Uddin | 37,800 | 18900 | 2,520 | 3780 | 63,000
Md.Moshiur Rahman | 25,000 | 12,500 | - | 2,500 | 2,500 | 500 | 43,000
[Changed Tax Calculation]
TOYOSHIMA & CO., LTD.
Computation of Income and Tax Liability
Income year 2020-2021
Assessmnet year 2021 - 2022 | 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 | Total | Reconcile Area
TIN Number
Income from Salary:
Basic salary:
For the month from Jul '20 - Jun '21 | 1,260,000 | 936,000 | 453,600 | 360,000 | 324,000 | 295,200 | 302,400 | 223,200 | 453,600 | 4,608,000 | 4,608,000 | -
House rent allowance | 360,000 | 360,000 | 226,800 | 180,000 | 162,000 | 147,600 | 151,200 | 111,600 | 226,800 | 1,926,000 | 1,926,000 | -
Less: Exempt (50% of basic) or (Tk. 25,000 per month) whichever is lower | 300,000 | 300,000 | 226,800 | 180,000 | 162,000 | 147,600 | 151,200 | 111,600 | 226,800 | 1,806,000
60,000 | 60,000 | - | - | - | - | - | - | - | 120,000
Conveyance allowance | 33,600 | 60,000 | 30,240 | 24,000 | 21,600 | 19,680 | 20,160 | 14,880 | 30,240 | 254,400 | 254,400 | -
Less: Exempt | 30,000 | 30,000 | 30,000 | 24,000 | 21,600 | 19,680 | 20,160 | 14,880 | 30,000 | 220,320
3,600 | 30,000 | 240 | - | - | - | - | - | 240 | 34,080
Medical allowance | 126,000 | 93,600 | 45,360 | 36,000 | 32,400 | 29,520 | 30,240 | 22,320 | 45,360 | 460,800 | 460,800 | -
Less: Exempt (10% of basic) or Tk. 120,000 whichever is lower | 120,000 | 93,600 | 45,360 | 36,000 | 32,400 | 29,520 | 30,240 | 22,320 | 409,440
6,000 | - | - | - | - | - | - | - | 45,360 | 51,360
Performance Bonus | 320,400 | 110,400 | - | - | - | - | - | - | - | 430,800 | 430,800 | -
Festival Bonus | 350,000 | 156,000 | 75,600 | 60,000 | 54,000 | 49,200 | 50,400 | 37,200 | 75,600 | 908,000 | 908,000 | -
Total Taxable Income of Salary | 2,000,000 | 1,292,400 | 529,440 | 420,000 | 378,000 | 344,400 | 352,800 | 260,400 | 574,800 | 6,152,240
Taxability Check | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | TRUE | FALSE | TRUE
Tax Calculation:
On 1st | Tk. | 300,000 | @ | Nil | - | - | - | - | - | - | - | - | - | -
On next | Tk. | 100,000 | @ | 5% | 5,000 | 5,000 | 5,000 | 5,000 | 3,900 | 2,220 | 2,640 | 5,000 | 33,760
On next | Tk. | 300,000 | @ | 10% | 30,000 | 30,000 | 12,944 | 2,000 | 17,480 | 92,424
On next | Tk. | 400,000 | @ | 15% | 60,000 | 60,000 | 120,000
On next | Tk. | 500,000 | @ | 20% | 100,000 | 38,480 | 138,480
On next | Tk. | Balance Amount | @ | 25% | 100,000 | 100,000
Gross tax liability | 295,000 | 133,480 | 17,944 | 7,000 | 3,900 | 2,220 | 2,640 | - | 22,480 | 484,664
Rebate on Investment Allowance:
(25% of total income Tk. | 500,000 | 323,100 | 132,360 | 105,000 | 94,500 | 86,100 | 88,200 | 65,100 | 143,700 | 1,538,060
or actual investment Tk. | 100% | 500,000 | 323,100 | 132,360 | 105,000 | 94,500 | 86,100 | 88,200 | 65,100 | 143,700 | 1,538,060
or Tk. 15,000,000 | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore
Whichever is lower | 500,000 | 323,100 | 132,360 | 105,000 | 94,500 | 86,100 | 88,200 | 65,100 | 143,700 | 1,538,060
Base test of Investment Allowance (U/S - 44)
whichever is lower X 15% or 10% | 50,000 | 48,465 | 19,854 | 15,750 | 14,175 | 12,915 | 13,230 | 9,765 | 21,555 | 205,709
Net Tax Liability | 245,000 | 85,015 | (1,910) | (8,750) | (10,275) | (10,695) | (10,590) | (9,765) | 925 | 278,955
Unpaid Tax /Due Tax | 245,000 | 85,015 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 360,015
TDS already Paid
Unpaid Tax /Due Tax for 12 Months payable from July 2020 to June 2021 | 245,000 | 85,015 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | - | 5,000 | 360,015
Calculating Month | 12 | Month | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Monthly deducted by Company | 20,417 | 7,085 | 417 | 417 | 417 | 417 | 417 | 417 | 30,004
Note:
01. Minimum Tax Is 5000 for Dhaka (North & South) City corporation.
02. Financial Year: 2020-2021
03. Other Allowance is solely of Net Tax Amount.
360,015