close x


Tax Calculation in Excel Sheet


Dear Friends,

Last week I have submitted this file to file section but still it is not appearing ,

so atttached herewith  this excel file with tax computation having 3 sheets.

1. Declaration form by Employee.

2. Salary Statement sheet from Payslip.

3. Tax Computation.

Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary.

It also caculate interest u/s 234 A B C

 

When you open file provide proper file name to save.(with .xls format)



Attached File : 39 salary tds tax calci for f y 10 11.zip downloaded 5970 times

Total thanks : 1 times

 
Reply   
 

If anyone have problem opening this file in excel-2007 or 2010, report here with screenshoot.

 
Reply   
 



Friends,

Atttached herewith  one excel file (in zip format) with tax computation having 3 sheets for F.Y. 2011-12 works in Excel-2007( service pack 2)  only.

1. Declaration form by Employee.

2. Salary Statement sheet from Payslip.

3. Tax Computation.

Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary.

It also caculate interest u/s 234 A B C

When you open file select enable macro to work this file.

If anyone have problem opening this file in excel-2007, report here with screenshoot.

Exshail



Attached File : 58368 944475 exshail 2007 salary tds working for 11 12.zip downloaded 2440 times

Total thanks : 1 times

 
Reply   
 
Professional


Originally posted by : Exshail

Friends,

Atttached herewith  one excel file (in zip format) with tax computation having 3 sheets for F.Y. 2011-12 works in Excel-2007( service pack 2)  only.

1. Declaration form by Employee.

2. Salary Statement sheet from Payslip.

3. Tax Computation.

Fill declaration form received from Employee, Fill 2nd sheet for salary working from payslip & other details in yallow highlited cells.You can enter remaining month to know tds per month to deduct from salary.

It also caculate interest u/s 234 A B C

When you open file select enable macro to work this file.

If anyone have problem opening this file in excel-2007, report here with screenshoot.

Exshail


Thanks once again.
 


Total thanks : 1 times

 
Reply   
 
Chartered Accountant In Practice

Please follow the below link :

http://www.cabcshettyco.com/OtherpageTheme6.aspx?TYPE=HORIZONTAL&CompanyID=0&PAGENAME=cal_Income_Tax&Parent=Calculators&Current=Tax%20Calculator

 
Reply   
 

Originally posted by : B C Shetty

Please follow the below link :

http://www.cabcshettyco.com/OtherpageTheme6.aspx?TYPE=HORIZONTAL&CompanyID=0&PAGENAME=cal_Income_Tax&Parent=Calculators&Current=Tax%20Calculator


Thanks for the link.

 

For simple & quick calculation of Tax for next F.Y. 2012-13 (A.Y. 2013-14), visit out govt. site:

http://law.incometaxindia.gov.in/DIT/Xtras/taxcalc.aspx

From above link one can calculate Tax from A.Y. 2003-04 to  A.Y. 2013-14 for any type of assesse  i.e individual (men, woman, senior citizen ), huf, firms, company,etc..

So bookmark above link.

 
Reply   
 

LEAVE A REPLY



    

Your are not logged in . Please login to post replies

Click here to login   Click here to Register



 



Share on :