Scribd
Upload
112 views8 pages

Salary Tax Calculation

The document appears to be a payroll spreadsheet containing employee names, salaries, bonuses, allowances, deductions, tax calculations, and other payroll-related fields. It includes notes about placing basic salary amounts, optional contributions to CIT for deductions, insurance limits, and rebates for single women. The spreadsheet calculates totals for assessable income, deductions, reductions, taxable salary, taxes owing, and net tax for three employees.

Uploaded by

Alisha Ganeju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
112 views8 pages

Salary Tax Calculation

The document appears to be a payroll spreadsheet containing employee names, salaries, bonuses, allowances, deductions, tax calculations, and other payroll-related fields. It includes notes about placing basic salary amounts, optional contributions to CIT for deductions, insurance limits, and rebates for single women. The spreadsheet calculates totals for assessable income, deductions, reductions, taxable salary, taxes owing, and net tax for three employees.

Uploaded by

Alisha Ganeju
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Dashain

Staff Name Basic Salary Months Total Salary Bonus Allowance PF 10%
ABC 12 - - -
MNO 12 - - -
XYZ 12 - - -

Note:
You have to place your basic salary in column B
You can contribute in CIT as per your choice in column J to take benefit of allowable deduction
Life Insurance and Health Insurance limit upto 25000 and 20000 respectively
You can choose your status in Column S dropbox
10% rebate is only for single woman
Deduction
Total Assessable Income 20% PF CIT Total Allowable Deductions Actual Deduction
- - - - -
- - - - -
- - - - -

ble deduction
Reduction
Life Insurance Health InsuranceIncapacitaed Total Reduct Taxable Salary Status SST 1%
- - Single -
- - Couple -
- - Couple -
10% 20% 30% 36% Total Tax 10% Rebate Net Tax
- - - - - - -
- - - - - - -
- - - - - - -
Dashain
Staff Name Basic Salary Months Total Salary Bonus Allowance SSF 20%
ABC 12 - - -
MNO 12 - - -
XYZ 12 - - -

Note:
You have to place your basic salary in column B
You can contribute in CIT as per your choice in column J to take benefit of allowable deduction
Life Insurance and Health Insurance limit upto 25000 and 20000 respectively
You can choose your status in Column S dropbox
10% rebate is only for single woman
Total Assessable Deduction
Income SSF 31% CIT Total Allowable Deductions Actual Deductions
- - - - -
- - - - -
- - - - -

e deduction
Reduction
Life Insurance Health Insurance Incapacitaed Total Reduction Taxable Salary
25,000 20,000 45,000 (45,000)
25,000 20,000 45,000 (45,000)
25,000 20,000 45,000 (45,000)
Status SST 1% 10% 20% 30% 36% Total Tax 10% Rebate Net Tax
- 10,000 40,000 375,000 - 425,000 425,000
- 10,000 40,000 375,000 - 425,000 425,000
- 10,000 40,000 375,000 - 425,000 425,000

You might also like