Tax excel utility
dear all . I need the tax calculation excel utility l. If someone has it please send me urgently . my email I'd is singhaniadevesh @ gmail.com best regards Devesh
Replies (4)
type in cell say d16
=IF(D15>=1000000,(D15-1000000)*0.3+125000,IF(D15>500000,(D15-500000)*0.2+25000,IF(D15>=250000,(D15-250000)*0.1-MIN((D15-250000)*0.1,2000),0)))
let D15 contain the taxable income
87A is taken care off here
I hope this helps and this is what you want.
Happy tax calculating
Thanks Mr Shiroor, but I missed to mention that we need utility for calculating interest (234abc) specifially. Pls send if you have.
for calculating that just download the excel utility of ITR-1/2/4 - as relevant to you
Offline - calculate the interest due to 234 a,b,c
You can take help for calculating interest under 234 a b c from this link
https://finotax.com/income-tax/intt234
Recent Topics :
- Bill-to-ship-to material at client site, project c
- Export previously now to be considered domestic sa
- Pan surrender via online
- EPFO Portal Issue – Unable to Save Employee
- Plant & Machinary
- ITC reversal after supplier amended the recipient
- GIFTS TO USEFUL CONTACTS ON FESTIVALS INCOME TAX
- INTEREST ON REFUND OF TDS
- Input tax claim related
- User not found in MCA portal
Related Topics :
CAclubindia
