I have prepared an excel utility to calculate income tax for Financial Year 2013-14 (Assessment Year 2014-15). Kindly let me know how you find the same and how can I improve it further. Vivek Sang
From India, Buldana
Acknowledge(3)
Amend(0)
65From India, Buldana
Acknowledge(3)Amend(0)
Thank you, members, for your suggestions. I have incorporated the points suggested by you. Kindly download the latest file attached herewith and let me have your feedback. One has to mention the monthly gross salary and TDS deducted, and it will recalculate the remaining tax liability after taking into account the exempted value of savings.
Regards,
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
Regards,
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
HI, ATTACHED TAX CALCULATOR FOR F.Y. 2013-14 FROM SIMPLE TAX INDIA. HOPE YOU WILL FIND THIS USEFUL. Regards, Ramesh G
From India, Chennai
Acknowledge(3)
Amend(0)
From India, Chennai
Acknowledge(3)Amend(0)
hi attached a calculation sheet & note on let out property. hope this will be helpful. regards ramesh G
From India, Chennai
Acknowledge(0)Amend(0)
From India, Chennai
Acknowledge(0)Amend(0)
Dear Ramsri, you can input the saving figures like 10,000, 20,000, etc., or any other amount and see the tax reduction instantly in the right panel. This way, you can check how much savings you need for tax-free income.
From India, Buldana
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
New updated file 17-06-2013 for Income tax calculation for Assessment year 2013-14
From India, Buldana
Acknowledge(0)Amend(0)
From India, Buldana
Acknowledge(0)Amend(0)
Income Tax Calculator uploaded earlier now Updated on 20-07-2013.
From India, Buldana
Acknowledge(1)Amend(0)
From India, Buldana
Acknowledge(1)Amend(0)
ramesh, two things that i wanted provision in the calculator was 1. tds deducted on the deposits by the bank 2. advance tax paid on other income can you pls. provide that.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
This was macro-enabled, so we cannot edit this. The only option available is to enter other income in the salary of a particular month itself and TDS information in the TDS part of that particular month. Otherwise, you have to write to the developer (email: [Email Removed For Privacy Reasons]).
Regards,
Ramesh G
From India, Chennai
Acknowledge(0)Amend(0)
Regards,
Ramesh G
From India, Chennai
Acknowledge(0)Amend(0)
First, add interest on FDR and any other income, then copy the amount into the cell against any other income in the D6 cell.
Regarding the TDS Part
Add TDS deducted on the deposits by the bank and advance tax paid on other income. Fill the combined amount in the TDS paid in the month it is actually paid.
I hope this will solve your purpose.
Regards,
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
Regarding the TDS Part
Add TDS deducted on the deposits by the bank and advance tax paid on other income. Fill the combined amount in the TDS paid in the month it is actually paid.
I hope this will solve your purpose.
Regards,
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
I have prepared an excel utility to calculate income tax for Financial Year 2013-14 (Assessment Year 2014-15). plz cheque Column E30 & D30.U have not added E31 & E32 In E33.in it calculation Sheet
From India, Patna
Acknowledge(0)Amend(0)
From India, Patna
Acknowledge(0)Amend(0)
[QUOTE=padmanava; 2089760]
[QUOTE=vivek sang; 2046744]
I have prepared an Excel utility to calculate income tax for the Financial Year 2013-14 (Assessment Year 2014-15). Please check Column E30 & D30. You have not added E31 & E32 in E33 on the calculation sheet.
There is nothing in E31, E32, and E33 cells. The TDS - Paid column is from D24 to D35. Kindly explain the problem you are facing so that I can resolve the same.
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)
[QUOTE=vivek sang; 2046744]
I have prepared an Excel utility to calculate income tax for the Financial Year 2013-14 (Assessment Year 2014-15). Please check Column E30 & D30. You have not added E31 & E32 in E33 on the calculation sheet.
There is nothing in E31, E32, and E33 cells. The TDS - Paid column is from D24 to D35. Kindly explain the problem you are facing so that I can resolve the same.
Vivek Sang
From India, Buldana
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Income Tax Calculator.xls