Please Wait ..

Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.


Discussion > Income Tax > Others >

Tax Calculation in Excel Sheet

    Post New Topic
Pages : 1





Software

[ Scorecard : 832]
Posted On 27 February 2011 at 21:19 Report Abuse

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

Total thanks : 1 times

Online classes for CA CS CMA



Exshail
Software

[ Scorecard : 832]
Posted On 27 March 2011 at 09:35

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





Exshail
Software

[ Scorecard : 832]
Posted On 08 March 2012 at 12:18

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

Total thanks : 1 times



Kaushik
Professional

[ Scorecard : 363]
Posted On 09 March 2012 at 13:17

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



bcshettyco
Chartered Accountant In Practice

[ Scorecard : 65]
Posted On 20 March 2012 at 19:54

Please follow the below link :

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




Exshail
Software

[ Scorecard : 832]
Posted On 22 March 2012 at 21:15

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.



There are 5 Replies to this message








Related Files








Related Threads


Post your reply for Tax Calculation in Excel Sheet



Your are not logged in . Please login to post replies

Click here to login


Not a member yet ?? Click here to signup

Message







    

  • Use thank button to convey your appreciation.
  • Maintain professionalism while posting and replying to topics.
  • Try to add value with your each post.



Forum Home | Forum Portal | Member Control Center | Who is Where | Popular Threads | Today's Topic | Recent Posts | Today's Posts | Post New Topic | Thread With Files | Top Threads This Month | Forum Stats | Unreplied Threads

back to the top