Tax Calculation in Excel Sheet

Software

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 6081 times

Total likes : 1 times

 
Reply   
 
Software

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

 
Reply   
 


Software

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 2511 times

Total likes : 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 likes : 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   
 
Software

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 / Register  



 


Search Forum:





× Online Coaching My Enrolled Courses
Articles Forum News Experts Exams Share Files Income Tax Accounts Career Corporate Law Service Tax Video Judgements Rewards Top Members Events Albums Find Friends Featured Feed Scorecard Bookmarks Mock Test Poll Notification Knowledge Finder Coaching Institutes Trainee Corner Jobs
close x
  SHARE THIS