Tax Calculation Sheet NItta San

Spreadsheet25 KBEnglishspreadsheet

Added 14 Sept 2026, 16:13 · Tax Calculation Sheet NItta San.xlsx

The original file is kept in the office. This is the text saved from it.

1 page

100%

[From July 2020 to June 2021] Computation of Total Income and Income Tax Liability: Name | : Mr. TOSHINORI TERAURA E-TIN | : 832204895436 Designation | : Country Manager Name of the employer | : Moririn Co., Ltd. Address | : Taher Shopping Center, Level # 11, Plot # 10, Dhaka, PO : 1212 Gulshan South, Gulshan-2, Dhaka-1212 Residential Status | : Resident Employment period | : 15 January 2021 to Till Now Income Year | : 2020-2021 | Day Basis : Assessment Year | : 2021-2022 | Particulars | Amount | Months | Days | Per day salary | Total Days | Gross Income Basic Salary | 170000 | 12 | 2040000 | 365 | 5589.041096 | 166 | 927781 Total Taxable Income Calculation | House Rent | 15,000 | 12 | 180000 | 365 | 493.1506849 | 166 | 81863 Conveyance Allowance | 2,000 | 12 | 24000 | 365 | 65.75342466 | 166 | 10915 A) Income form Salary in Bangladesh | Medical Allowance | 3,000 | 12 | 36000 | 365 | 98.63013699 | 166 | 16373 1036932 Particulars | Gross Income | Exempted Income | Taxable Income | Monthly Basis: | Jan | 16 Basic Salary | 927,781 | - | 927,781 | Particulars | Amount | Month | Feb | 28 House Rent | 81,863 | 81,863 | - | Basic Salary | 170,000 | 5.53 | 940,100 | Mar | 31 Conveyance Allowance | 10,915 | 10,915 | - | House Rent | 15,000 | 5.53 | 82,950 | Apr | 30 Medical Allowance | 16,373 | 16,373 | - | Conveyance Allowance | 2,000 | 5.53 | 11,060 | May | 31 Total | 1,036,932 | 109,151 | 927,781 | Medical Allowance | 3,000 | 5.53 | 16,590 | June | 30 1,050,700 | Total Days | 166 B) World Income | - | - | - Total | - | - | - 5.53 Grand Total | 1,036,932 | 109,151 | 927,781 Income Tax Calculation Particulars | Taxable Income | Tax rate | Income Tax On 1st | 300,000 | 0% | Nill On Second | 100,000 | 5% | 5,000 On Third | 300,000 | 10% | 30,000 On Fourth | 400,000 | 15% | 34,167 On Remaining | - | 20% | - - | 25% 1,100,000 | 69,167 Total tax liability for the year | 69,167 Total tax liability for the year | 69,167 Less: Tax already paid by challan | - Balance | 69,167 Tax liability per month (Payable through 03 Months from April'2021 to Jun'2021) | 23,056 [Resident ] Computation of Total Income and Income Tax Liability: Name | : Mr. TOSHINORI TERAURA E-TIN | : 832204895436 Designation | : Country Manager Name of the employer | : Moririn Co., Ltd. Address | : Taher Shopping Center, Level # 11, Plot # 10, Dhaka, PO : 1212 Gulshan South, Gulshan-2, Dhaka-1212 Residential Status | : Resident Employment period | : 15 January 2021 to Till Now Income Year | : 2020-2021 | Day Basis : Assessment Year | : 2021-2022 | Particulars | Amount | Months | Days | Per day salary | Total Days | Gross Income Basic Salary | 300000 | 12 | 3600000 | 365 | 9863.013699 | 182 | 1795068 Total Taxable Income Calculation | House Rent | 25,000 | 12 | 300000 | 365 | 821.9178082 | 182 | 149589 Conveyance Allowance | - | 12 | 0 | 365 | 0 | 182 | 0 A) Income form Salary in Bangladesh | Medical Allowance | 10,000 | 12 | 120000 | 365 | 328.7671233 | 182 | 59836 2004493 Particulars | Gross Income | Exempted Income | Taxable Income | Monthly Basis: | Jan | 16 Basic Salary | 3,092,400 | - | 3,092,400 | Particulars | Amount | Month | Feb | 28 House Rent | 300,000 | 300,000 | - | Basic Salary | 257,700 | 12 | 3,092,400 | Mar | 31 Conveyance Allowance | - | - | - | House Rent | 25,000 | 12 | 300,000 | Apr | 30 Medical Allowance | 120,000 | 120,000 | - | Conveyance Allowance | - | 12 | - | May | 31 Total | 3,512,400 | 420,000 | 3,092,400 | Medical Allowance | 10,000 | 12 | 120,000 | June | 30 292,700 | 3,512,400 | Total Days | 166 B) World Income | - | - | - Total | - | - | - Assumed as 182 days for Resident | 5.53 Grand Total | 3,512,400 | 420,000 | 3,092,400 340,042 Income Tax Calculation Particulars | Taxable Income | Tax rate | Income Tax On 1st | 300,000 | 0% | Nill | 338000 On Second | 100,000 | 5% | 5,000 On Third | 300,000 | 10% | 30,000 On Fourth | 400,000 | 15% | 60,000 On Remaining | 500,000 | 20% | 100,000 1,492,400 | 25% | 373,100 1,600,000 | 568,100 Total tax liability for the year | 568,100 Total tax liability for the year | 568,100 Less: Tax already paid by challan | - Balance | 568,100 Tax liability per month (Payable through 12 Months fromJuly'2021 to Jun'2021) | 47,342 [Non Resident ] Computation of Total Income and Income Tax Liability: Name | : Mr. TOSHINORI TERAURA E-TIN | : 832204895436 Designation | : Country Manager Name of the employer | : Moririn Co., Ltd. Address | : Taher Shopping Center, Level # 11, Plot # 10, Dhaka, PO : 1212 Gulshan South, Gulshan-2, Dhaka-1212 Residential Status | : Resident Employment period | : 15 January 2021 to Till Now Income Year | : 2020-2021 | Day Basis : Assessment Year | : 2021-2022 | Particulars | Amount | Months | Days | Per day salary | Total Days | Gross Income Basic Salary | 170000 | 12 | 2040000 | 365 | 5589.041096 | 166 | 927781 Total Taxable Income Calculation | House Rent | 15,000 | 12 | 180000 | 365 | 493.1506849 | 166 | 81863 Conveyance Allowance | 2,000 | 12 | 24000 | 365 | 65.75342466 | 166 | 10915 A) Income form Salary in Bangladesh | Medical Allowance | 3,000 | 12 | 36000 | 365 | 98.63013699 | 166 | 16373 1036932 Particulars | Gross Income | Exempted Income | Taxable Income | Monthly Basis: | Jan | 16 Basic Salary | 927,781 | - | 927,781 | Particulars | Amount | Month | Feb | 28 House Rent | 81,863 | - | 81,863 | Basic Salary | 170,000 | 5.53 | 940,100 | Mar | 31 Conveyance Allowance | 10,915 | - | 10,915 | House Rent | 15,000 | 5.53 | 82,950 | Apr | 30 Medical Allowance | 16,373 | - | 16,373 | Conveyance Allowance | 2,000 | 5.53 | 11,060 | May | 31 Total | 1,036,932 | - | 1,036,932 | Medical Allowance | 3,000 | 5.53 | 16,590 | June | 30 1,050,700 | Total Days | 166 B) World Income | - | - | - Total | - | - | - 5.53 Grand Total | 1,036,932 | - | 1,036,932 Income Tax Calculation Particulars | Taxable Income | Tax rate | Income Tax Tax Rate 30% | 1,036,932 | 30% | 311,079 1,036,932 | 311,079 Total tax liability for the year | 311,079 Total tax liability for the year | 311,079 Less: Tax already paid by challan | - Balance | 311,079 Tax liability per month (Payable through 03 Months from April'2021 to Jun'2021) | 103,693 | Additional | 0

← Back to Work Permit Formats