Go Back   Team-BHP > Around the Corner > Shifting gears > Gadgets, Computers & Software


Reply
 
Thread Tools Search this Thread
Old 16th February 2009, 15:28   #1
BHPian
 
simonkayar's Avatar
 
Join Date: Sep 2007
Location: Bangalore
Posts: 158
Thanked: 71 Times
Thumbs up Tax Planner - Calculator for Financial Year 2008-2009

Hi Friends,
I discovered Team-BHP couple of years back and have been vastly benefited by it. I am no car expert and have little to give back to this community. So I thought, why not share a tool that I have designed and created.

The Tax Planner/Calculator
This Tax Planner allows you to plan your tax savings and also aids in computing taxes based on your salary details. It also has calculators for finding EMI, value of PPF, how to become crorepathi etc. Please give your suggestions. I hope it is useful to atleast a few here.

File Type/Size
Easy to Use Excel Sheet of 75 KB

Direct Download Link
You can Right Click and Save Target As

You can also use the file attached with this post tax_planner_2008-2009_ver3.0.xls

Suggestions on using the Tax Planner

1. There are three sheets in the Excel file.
  • First one is the "Planner" and it is empty for you to use.
  • The Second one is called "Sample Tax Calculation" where I have shown a sample for you.
  • The Third sheet is very useful with 'Handy Calculators' for EMI, returns and How to become crorepathi.
2. Input your Sex by Selecting either 'Male' or 'Female' in the drop down combo box and also supply your age as this will affect the tax calculations
3. Input your salary and investment data in the 'Yellow' coloured cells only. The others cells are disabled to aid you better. If you want you can unprotect the sheet and edit any cell you wish. There is no password for the protection
4. You can change your investment details to see the immediate effects in your tax calculations. for example if you are planning to buy a house, you can input the 'Principal' and 'Interest' you will pay per year and see how that will save you tax.

Screenshots of the Tax Planner/Calculator

1. The Tax Planner Sheet (There will 2 sheets like this, one for you and one with sample calculation)
Name:  taxcalcver3.0planner.JPG
Views: 3725
Size:  30.4 KB

2. The Various calculators like EMI, PPF, Crorepathi etc
Name:  taxcalcver3.0calculatorsnew.JPG
Views: 2042
Size:  39.3 KB
simonkayar is offline   Reply With Quote
Old 16th February 2009, 15:46   #2
Team-BHP Support
 
Eddy's Avatar
 
Join Date: Apr 2007
Location: Delhi
Posts: 7,268
Thanked: 4,423 Times
Default

Does anyone have anything for tracking daily expenses too ?
Eddy is offline   Reply With Quote
Old 16th February 2009, 15:53   #3
BHPian
 
simonkayar's Avatar
 
Join Date: Sep 2007
Location: Bangalore
Posts: 158
Thanked: 71 Times
Default

Hi Eddy,
I am completing that tonight. I thought I would post that next (As a different topic tomorrow). For now you can check the old version here
simonkayar is offline   Reply With Quote
Old 16th February 2009, 15:56   #4
BHPian
 
Join Date: Oct 2005
Location: @ Driver's Seat @
Posts: 679
Thanked: 57 Times
Default

Believe Ynithya developed the IT calculator. Looks are similar. Might be wrong from my end.

Quote:
Originally Posted by Eddy View Post
Does anyone have anything for tracking daily expenses too ?
Eddy, have fun with the attached file for your reference. Recd it in e-mail
Attached Files
File Type: xls Budget_Planner.xls (251.0 KB, 346 views)
lambuhere1 is offline   Reply With Quote
Old 16th February 2009, 16:04   #5
BHPian
 
simonkayar's Avatar
 
Join Date: Sep 2007
Location: Bangalore
Posts: 158
Thanked: 71 Times
Default

Hi lambuhere,
I have also seen ynithya's. It is much more comprehensive and detailed and probably perfect. The one I had done was initially for my own use and later modified for others slightly and is meant to be extremely simple to use. No offense meant, but I don't see anything similar between the two sheets except for too much yellow in both of them.
simonkayar is offline   Reply With Quote
Old 16th February 2009, 16:39   #6
BHPian
 
woof's Avatar
 
Join Date: Jul 2007
Location: Delhi
Posts: 126
Thanked: 8 Times
Default

Quote:
Originally Posted by Eddy View Post
Does anyone have anything for tracking daily expenses too ?
For tracking Daily expenses, I use Google Docs - very simple, and easy to use. You just need to follow these steps (only the first time):

1. Go to Google Docs, and create a new Spreadsheet


2. Go to the Form menu, click on 'Create a form'.
Tax Planner - Calculator for Financial Year 2008-2009-one.jpg

3. Add questions to your form - For eg. I have added the following to my spreadsheet:
    • Date of Transaction
    • Amount
    • Payment method (Cash/Credit card etc).
    • Spending Category (Phone/Car/Clothes/Travel etc)
    • Description
Tax Planner - Calculator for Financial Year 2008-2009-two.jpg

Tax Planner - Calculator for Financial Year 2008-2009-three.jpg

4. Once you are done with the questions, save the form, and email the form to yourself. Don't forget to include 'Include form in the email' checkbox.
Tax Planner - Calculator for Financial Year 2008-2009-four.jpg

5. Bookmark the link for the form in your browser. It will be something like this: http://spreadsheets.google.com/viewform?key=xxxxxxxxxx. You can also add the link to the form via quick link in your gmail inbox.
Tax Planner - Calculator for Financial Year 2008-2009-five.jpg

6. So, now whenever you want to make an entry just fire this link in your browser, and enter in the values.
Tax Planner - Calculator for Financial Year 2008-2009-six.jpg

These values will automatically get stored on the google doc spreadsheet you had created. Just open this sheet in your google docs account to have a look at your expenses. Depending upon your needs, you can create custom reports using these stats.
Tax Planner - Calculator for Financial Year 2008-2009-seven.jpg

I like this method of tracking one's expenses because:
- Can assess the form/spreadsheet through my mobile or laptop - either way.
- Can customize according to my needs.
woof is offline   Reply With Quote
Old 16th February 2009, 18:38   #7
Senior - BHPian
 
Join Date: Sep 2006
Location: zxc
Posts: 3,392
Thanked: 654 Times
Default

thanks man and your website is great.
SirAlec is offline   Reply With Quote
Old 17th February 2009, 13:14   #8
BHPian
 
simonkayar's Avatar
 
Join Date: Sep 2007
Location: Bangalore
Posts: 158
Thanked: 71 Times
Default

Thanks SirAlec and the Expense Organizer is also up now
simonkayar is offline   Reply With Quote
Old 17th February 2009, 14:04   #9
BHPian
 
Proxima's Avatar
 
Join Date: Jul 2006
Location: Chennai
Posts: 801
Thanked: 3 Times
Default

Great threads, Simon.

How do I find out what is the maximum amount of HRA that I can claim?
Proxima is offline   Reply With Quote
Old 17th February 2009, 14:14   #10
Senior - BHPian
 
ashthedivx's Avatar
 
Join Date: Feb 2007
Location: Delhi
Posts: 1,351
Thanked: 22 Times
Default

Indeed a great work !! Congrats Simon and do keep posted with such great work !!

PS: A small alignment issue. In Handy Calculators - Fill up PPF Amount with 70000, the final amount will not be able to displayed properly i.e. #######
ashthedivx is offline   Reply With Quote
Old 17th February 2009, 14:57   #11
Senior - BHPian
 
Spitfire's Avatar
 
Join Date: Jul 2006
Location: Panaji - Goa/Bangalore - Karnataka
Posts: 3,240
Thanked: 600 Times
Default

Quote:
Originally Posted by ashthedivx View Post
PS: A small alignment issue. In Handy Calculators - Fill up PPF Amount with 70000, the final amount will not be able to displayed properly i.e. #######
Rs 2,052,700.

Hover your mouse pointer over it. The calculated figure is more then the locked cells size.
Spitfire is offline   Reply With Quote
Old 17th February 2009, 14:58   #12
BHPian
 
simonkayar's Avatar
 
Join Date: Sep 2007
Location: Bangalore
Posts: 158
Thanked: 71 Times
Default

Hi ashthedivx, Yes, found that problem after uploading (at 35k it starts). If you are a bit familiar with excel, You can unprotect the sheet "Tools->Protection->Unprotect Sheet" and slightly increase the width of the cell (column) to solve it (or remove the bold setting).
Will fix it in next revision :-)
simonkayar is offline   Reply With Quote
Old 18th February 2009, 10:51   #13
Senior - BHPian
 
ashthedivx's Avatar
 
Join Date: Feb 2007
Location: Delhi
Posts: 1,351
Thanked: 22 Times
Default

Quote:
Originally Posted by simonkayar View Post
Hi ashthedivx, Yes, found that problem after uploading (at 35k it starts). If you are a bit familiar with excel, You can unprotect the sheet "Tools->Protection->Unprotect Sheet" and slightly increase the width of the cell (column) to solve it (or remove the bold setting).
Will fix it in next revision :-)
I had already done that mate, just wanted to get it fixed for a non-familiars one

I am too working on such a project for billing stuff on weekends for a friend.


Cheers
ashthedivx is offline   Reply With Quote
Old 18th February 2009, 10:55   #14
BHPian
 
mail4loys's Avatar
 
Join Date: Nov 2006
Location: San Antonio, TX
Posts: 375
Thanked: 6 Times
Default

Quote:
Originally Posted by Eddy View Post
Does anyone have anything for tracking daily expenses too ?
I currently use GnuCash for tracking my day-to-day expenses, it has some nice features with reports and comes for free!
mail4loys is offline   Reply With Quote
Old 18th February 2009, 16:52   #15
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 46,539
Thanked: 80,286 Times
Default

Quote:
Originally Posted by simonkayar View Post
I discovered Team-BHP couple of years back and have been vastly benefited by it. I am no car expert and have little to give back to this community. So I thought, why not share a tool that I have designed and created.
It is this spirit that fuels Team-BHP. Thanks!

Quote:
Originally Posted by Eddy
Does anyone have anything for tracking daily expenses too ?
Related thread
GTO is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tax on Tax? Road tax should be calculated on ex-factory price (not ex-showroom)! SILVERWOOD The Indian Car Scene 88 30th July 2017 12:39
Road Trip Planner !!!! karan561 Route / Travel Queries 12 26th April 2007 19:54
Tax Calculator (excel) required protege Shifting gears 4 30th July 2006 22:40
Cars gonna cost a bomb in Maharashtra in the next Financial year EVO6 The Indian Car Scene 7 25th March 2006 20:34


All times are GMT +5.5. The time now is 05:15.

Copyright 2000 - 2017, Team-BHP.com
Proudly powered by E2E Networks