Salary Statement _ Pay Slip_June_2020

Spreadsheet1.1 MBEnglishspreadsheet

Added 14 Sept 2026, 16:31 · Salary Statement _ Pay Slip_June_2020.xlsx

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

1 page

100%

[Summary] Tamurakoma & Co., Ltd. Statement of Salary & Allowances For the month of June 2020 Sl.No. | Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance 01 | Ashma Akter | QC Adviser | 10/1/19 | 105,300 | 25,000 | 2,500 | 10,000 | 32,700 | 175,500 | 30 | 30 | - | 175,500 | - | - | 175,500 | Tax has been Re-vised. 02 | Mohammad Azizul | QC | 9/1/19 | 34,200 | 17,100 | 2,280 | 3,420 | - | 57,000 | 30 | 30 | - | 57,000 | - | - | 57,000 03 | Mohammad Shafiqul | QC | 9/1/19 | 30,000 | 15,000 | 2,000 | 3,000 | - | 50,000 | 30 | 30 | - | 50,000 | 250 | - | 49,750 04 | Shakil Ahmed | QC | 10/1/19 | 39,000 | 19,500 | 2,600 | 3,900 | - | 65,000 | 30 | 30 | - | 65,000 | - | - | 65,000 05 | Mohammad Ismail Hossain | - | 10/1/19 | 21,000 | 10,500 | 1,400 | 2,100 | - | 35,000 | 30 | 30 | - | 35,000 | - | - | 35,000 06 | Md. Khurshed Alam | Merchandiser | 20/11/2019 | 33,900 | 16,950 | 2,260 | 3,390 | - | 56,500 | 30 | 30 | 56,500 | - | - | 56,500 07 | Yeasir Arafat | QC | 21/3/2020 | 31,500 | 15,750 | 2,100 | 3,150 | - | 52,500 | 30 | 30 | 52,500 | - | - | 52,500 08 | Md. Rafel Mahamud | - | 7,500 | 3,750 | 500 | 750 | - | 12,500 | 30 | 30 | - | 12,500 | - | - | 12,500 Total | 302,400 | 123,550 | 15,640 | 29,710 | 32,700 | 504,000 | 240 | 240 | - | 504,000 | 250 | - | 503,750 3) TDS on salary have been shown as Tax & Duty Expenses Account head Prepared By | Approved By | Received By [PS-Ashma] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Ashma Akter | QC Adviser | 10/1/19 | 105,300 | 25,000 | 2,500 | 10,000 | 32,700 | 175,500 | 30 | 30 | - | 175,500 | - | - | 175,500 Total | 105,300 | 25,000 | 2,500 | 10,000 | 32,700 | 175,500 | 30 | 30 | - | 175,500 | - | - | 175,500 | - In words- One Lac Seventy Five Thousand Five Hundred Only. Prepared By | Approved By | Received By [PS-Azizul.] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Mohammad Azizul | QC | 9/1/19 | 34,200 | 17,100 | 2,280 | 3,420 | - | 57,000 | 30 | 30 | - | 57,000 | - | - | 57,000 Total | 34,200 | 17,100 | 2,280 | 3,420 | - | 57,000 | 30 | 30 | - | 57,000 | - | - | 57,000 | - In words- Fifty Seven Thousand Only Prepared By | Approved By | Received By [PS-Shafiq.] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Mohammad Shafiqul | QC | 9/1/19 | 30,000 | 15,000 | 2,000 | 3,000 | - | 50,000 | 30 | 30 | - | 50,000 | 250 | - | 49,750 Total | 30,000 | 15,000 | 2,000 | 3,000 | - | 50,000 | 30 | 30 | - | 50,000 | 250 | - | 49,750 | - In words- Forty Nine Thousand Seven Hundred and Fifty Only Prepared By | Approved By | Received By [PS-Shakil] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Shakil Ahmed | QC | 10/1/19 | 39,000 | 19,500 | 2,600 | 3,900 | - | 65,000 | 30 | 30 | - | 65,000 | - | - | 65,000 Total | 39,000 | 19,500 | 2,600 | 3,900 | - | 65,000 | 30 | 30 | - | 65,000 | - | - | 65,000 | - In words- Sixty Five Thousands Only Prepared By | Approved By | Received By [PS-Ismail] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Mohammad Ismail Hossain | 0 | 10/1/19 | 21,000 | 10,500 | 1,400 | 2,100 | - | 35,000 | 30 | 30 | - | 35,000 | - | - | 35,000 Total | 21,000 | 10,500 | 1,400 | 2,100 | - | 35,000 | 30 | 30 | - | 35,000 | - | - | 35,000 | - In words- Thirty Five Thousands Only Prepared By | Approved By | Received By [PS-Khurshed] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Md. Khurshed Alam | Merchandiser | 20/11/2019 | 33,900 | 16,950 | 2,260 | 3,390 | - | 56,500 | 30 | 30 | - | 56,500 | - | - | 56,500 Total | 33,900 | 16,950 | 2,260 | 3,390 | - | 56,500 | 30 | 30 | - | 56,500 | - | - | 56,500 | - In words- Fifty Six Thousands Five Hundred Only Prepared By | Approved By | Received By [PS-Yasir] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Yeasir Arafat | QC | 21/3/2020 | 31,500 | 15,750 | 2,100 | 3,150 | - | 52,500 | 30 | 30 | - | 52,500 | - | - | 52,500 Total | 31,500 | 15,750 | 2,100 | 3,150 | - | 52,500 | 30 | 30 | - | 52,500 | - | - | 52,500 | - In words- Fifty Two Thousands Five Hundred Only Prepared By | Approved By | Received By [PS-Rafel ] Tamurakoma & Co., Ltd. PAY SLIP Statement of Salary & Allowances For the month of June 2020 Name | Designation | Joining Date | Basic Salary | House Rent | Conveyance | Medical Allowance | Performance Bonus | Gross Salary | Days of Month | Worked Day | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Advance Md. Rafel Mahamud | 0 | - | 7,500 | 3,750 | 500 | 750 | - | 12,500 | 30 | 30 | - | 12,500 | - | - | 12,500 Total | 7,500 | 3,750 | 500 | 750 | - | 12,500 | 30 | 30 | - | 12,500 | - | - | 12,500 | - In words- Twelve Thousands Five Hundred Only Prepared By | Approved By | Received By [Revised_Tax Calculation] Tamurakoma & Co., Ltd. Computation of Income and Tax Liability Income year: 2019-2020 Assessmnet year: 2020-2021 Particulars | Ashma Akter | Md Azmin | MD SHAFIQUL ISLAM | Md Sakil Ahmed Patwary | MD. ISMAIL HOSSAIN | Md. Khurshed Alam TIN Number | 562153404033 | 284615444557 | 180602425295 | 715079788641 | 159499780840 | 799908533617 Income from Salary: Basic Salary (For the month from October'19-June'20) | 947,700 | 342,000 | 300,000 | 330,600 | 189,000 | 249,730 House rent allowance | 225,000 | 171,000 | 150,000 | 165,300 | 94,500 | 124,865 Less: Exempt (50% of basic) or (Tk. 25,000 per month) whichever is lower | 225,000 | 171,000 | 150,000 | 165,300 | 94,500 | 124,865 - | - | - | - | - | - Conveyance allowance | 22,500 | 22,800 | 20,000 | 22,040 | 12,600 | 16,649 Less: Exempt up to 30,000 | 22,500 | 22,800 | 20,000 | 22,040 | 12,600 | 16,649 - | - | - | - | - | - Medical allowance | 90,000 | 34,200 | 30,000 | 33,060 | 18,900 | 24,973 Less: Exempt (10% of basic) or Tk. 120,000 whichever is lower | 90,000 | 34,200 | 30,000 | 33,060 | 18,900 | 24,973 - | - | - | - | - | - Performance bonus | 294,300 | - | - | - | - | - Festival Bonus | 170,000 | 23,987 | 21,041 | 52,000 | 13,003 | 16,253 | 296,284 Other Allowance | - | - | - | - | - | - Total Taxable Income of Salary | 1,412,000 | 365,987 | 321,041 | 382,600 | 202,003 | 265,983 Taxability Check | TRUE | TRUE | TRUE | TRUE | FALSE | FALSE Tax Calculation: On 1st | Tk. | 300,000 | @ | Nil | - | - | - | - | - | - On next | Tk. | 100,000 | @ | 5% | 5,000 | 3,299 | 1,052 | 4,130 | - | - On next | Tk. | 300,000 | @ | 10% | 30,000 | - | - | - | - | - On next | Tk. | 400,000 | @ | 15% | 60,000 | - | - | - | - | - On next | Tk. | 500,000 | @ | 20% | 52,400 | - | - | - | - | - On next | Tk. | Balance Amount | @ | 25% | - | - | - | - | - | - | ` A. Gross tax liability | 147,400 | 3,299 | 1,052 | 4,130 | - | - Rebate on Investment Allowance: 25% of total income Tk. | 353,000 | 91,497 | 80,260 | 95,650 | 50,501 | 66,496 or Actual investment Tk. | 0% | 500,000 | - | - | - | - | - | Investment Allowane: or Tk. 15,000,000 | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | 1.5 Crore | Total income | up to | 1,500,000 | 15% | on eligible amount Maximum Limit (Whichever is lower) | 353,000 | - | - | - | - | - | Total income | Above | 1,500,000 | 10% | on eligible amount Base test of Investment Allowance (U/S - 44) | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE B. Investment Tax Rebate (15% or 10%) | 52,950 | - | - | - | - | - C. Net Tax Liability (A-B) | 94,450 | 3,299 | 1,052 | 4,130 | - | - Unpaid Tax /Due Tax | 94,450 | 5,000 | 5,000 | 5,000 | - | - D. Tax already Paid | 58,030 | 6,310 | 4,000 | 6,200 | - | 2,142 | 76,682 Unpaid Tax /Due Tax for 09 months | 36,420 | (1,310) | 1,000 | (1,200) | - | (2,142) Calculating Month | 4 | - | 4 | - | - | - Per Month | 9,105 | 250 | 9,355 Note: | 01. Tax has been calculated on the basis of Appointment Letter; 02. Minimum Tax is 5000 for Dhaka (North & South) City corporation; 03. Financial Year: 2019-20; 04. Performance bonus is solely of Net Tax Amount; 05. If salary amount will change the tax also will change accordingly.

← Back to Payroll Formats