Showing posts with label Calculators. Show all posts
Showing posts with label Calculators. Show all posts

Thursday, December 26, 2013

Income Tax :- Free Income Tax Individual Calculator

Friends,   In a organisation,  Excel Based Income Tax Calculator is required to calculate Income Tax of their each employee.   Before completing the financial year,  tax calculation is  required again and again due to saving of employees and receipt of arrears etc.  Keeping in view these things the following excel based calculator is provided totally free of cost.  In the following not only Tax Calculator but also calculator for calculating 89(1) relief for arrears is also provided. 

  • F.Y.2013-14, A.Y.2014-15 Income Tax Calculator with New Form 16 for individuals  (Download)

Wednesday, July 31, 2013

Chrome Calculator :- Do you know Chrome Calculator ?

Friends ,    Chrome is best browser and generally used by computer users.   It is easy and fast for web surfing etc.    But there are less users who know about the chrome calculator.   Location / Path  of calculator in chrome is given below :-

Customize and control Google Chrome > Tools > Developer Tools > Console > Calculator 

Simple calculations can be done here.   There is no doubt that windows has it's own calculators simple and scientific but knowledge of any thing stands its value. 


Tuesday, July 9, 2013

e-TDS :- New columns in RPU 3.5

Friends,  As it is already known that two new columns mentioned below have been inserted in RPU 3.5 for submition of  Quarter 4 salary return.
  1. Reported Taxable Amount on which tax is deducted by previous employer(s).
  2. Reported Amount of TDS by previous employer (income in respect of included in computing total taxable income in col 22)
           The above addition has been done in NSDL RPU.  To make convenient excel based individual calculator has also been updated accordingly.  Any person can calculate his amount of Income Tax for the Financial Year  2013-14 and plan accordingly for monthly deduction of TDS from his salary. 


To download updated Individual Excel Based Income Tax Calculator (Click Here)

Friday, May 17, 2013

Calculators (Completely Free)

Friends
Now excel based free calculators are available for registered readers. Enter your email id in below box and check your inbox or spam emails.  There is link of Feed Burner to accept the registration.








Enter your email address:


Delivered by FeedBurner




(Don't Use Space Bar in Excel to Blank any Cell)
(Only white cell are for entries)
Free Download of Excel Based Calculators for Registered users

Recommended Internet Explorer Firefox/Mozilla or Chrome


Forms

Software/Utility

  • Multiple FDR's Calculations in a single Excel Sheet (Download)
  • Form 27A software from FVU/TXT file (Instructions) (Download)
  • 89(1) Relief  or 10E Calculator for Assessment Year 2013-14 (Click Here)
  • 89(1) Relief  or 10E Calculator for Assessment Year 2012-13 (Click Here)
  • 89(1) Relief  or 10E Calculator for Assessment Year 2010-11 (Click Here)
  • Income Tax Calculator w.e.f. 1.4.05 to up to Date (Click Here)
  • Age Calculator Excel Based or Difference between two Dates (Click Here)
  • F.Y.2013-14, A.Y.2014-15 Income Tax Calculator with New Form 16 for individuals  (Download)
  • F.Y.2012-13, A.Y.2013-14 Income Tax Calculator with New Form 16 for individuals  (Online View)  (Download)
  • F.Y.2011-12, A.Y.2012-13 Income Tax Calculator with New Form 16 for individuals (Online View) (Download)
  • F.Y. 2010-11, A.Y. 2011-12 Income Tax Calculator with Form 16  for Individuals.(Online) (Download)
  • F.Y. 2009-10, A.Y. 2010-11 Income Tax Calculator for Individuals   (OnLine) (Off Line) (Excel Sheet with Storage)
  • Advance Tax Calculators (Click Here)
  • T.D.S. Calculator w.e.f. 01.10.09 (Click for Online Here) (Download)
  • Bootable USB Drive Creator Tool  (Click Here)
  • FDR (Fixed Deposit Receipt) Interest Calculator on Maturity/Pre-matured/Re-invest  (Click Here)
  • Debtor/Creditor List in Tally  with Partywise total (Click Here)
  • EPF (Employees Provident Fund) Software (Click Here)
  • Interest on Saving Bank Account Calculator (On Line)
  • House Rent Allowance Exemption Calculator (Click Here)
  • Post Office R.D. Interest (5 Years & 10 Years) Calculator (Click Here)
  • NSC Interest Calculator (Click Here)
  • On Line Excel Based Salary Statement (Click Here)
  • Disallowed Salary/Remuneration Calculator in case Partnership Firm (Download)
  • Depreciation Calculator (Download)
  • EMI Calcualtor (Download) (Online)
  • Bank Loan Interest Calculation Calculator (Download)
  • Income Tax Calculator F.Y. 2008-09, A.Y. 2009-10 (Download)



(further updation will be made after getting your response)

Wednesday, May 8, 2013

How can we calculate Electric Load ?

Friends
           Excel based Electric Load Checker calculator is ready for general use.   User can enter data only in white cells.  Editable fields are as under :-

  1. Name of Appliances. 
  2. Approx. Load (Watts)
  3. No's of Items.
  4. Hours / Day
  5. Rate Per Unit 
          Calculator calculates automatically the following fields :- 
  1. Unit consumption per day
  2. Unit consumption per month (on the basis of 30 days per month)
  3. Appliances wise Amount of consumption per day
  4. Appliances wise Amount of consumption per month.
  5. Total value of consumption per day.
  6. Total value of consumption per month. 





Download (Click Here)

Wednesday, May 1, 2013

Free Income Tax Calculator for Assessment Year 2014-15 or Financial Year 2013-14

Friends,  Excel based free income tax calculator has been prepared for the Financial Year 2013-14 or Assessment Year 2014-15.  Employee wise can be stored in this Excel File.  This calculator has been generated keeping in view of NSDL RPU.    Some fields like Women, Others, Senior Citizen or Super Senior Citizen are exactly same with the fields available in tds NSDL RPU.   

           Further new  deduction of Rs. 2000/- in Income Tax has also been updated in this calculator.   There is no need to remember whether an individual is eligible for deduction or not.   Calculator calculate income tax  itself.    This utility calculate and store income tax of 500 employees, but this limit can be increased on special request of user through email at easyjain@gmail.com.  Base of Income Tax slabs for this calculator is given below in detail :-


Income Tax Slabs for the Financial Year 2013-14 or Assessment Year 2014-15
(i)  In the case of every individual, being a resident in India, who is of the age of less than sixty years during the previous year:—
Up to Rs. 2,00,000                                                  Nil;
Rs. 2,00,001 to Rs. 5,00,000                         10 per cent.
Rs. 5,00,001 to Rs. 10,00,000                       20 per cent.
Above Rs.10,00,000                                      30 per cent.

(ii)  In the case of every individual, being a resident in India, who is of the age of sixty years or more but less than the age of eighty years at any time during the previous year:—
Up to Rs. 2,50,000                                                  Nil;
Rs. 2,50,001 to Rs. 5,00,000                         10 per cent.
Rs. 5,00,001 to Rs. 10,00,000                       20 per cent.
Above Rs. 10,00,000                                     30 per cent.

(iii) In the case of every individual, being a resident in India, who is of the age of eighty years or more at any time during the previous year:—
Up to Rs. 5,00,000                                                  Nil;
Rs. 5,00,001 to Rs. 10,00,000                       20 per cent.
Above Rs. 10,00,000                                     30 per cent.
The surcharge in cases of persons referred to in this paragraph, having income above one crore rupees shall be levied at the rate of ten per cent. Marginal relief will be provided.

           Rebate of Tax under section 87A worth Rs. 2000/- will also be provided to those whose taxable income it equal to 5,00,000.00 or less than 5,00,0000.

            We have tried to generate best calculations in this calculator, however if anyone feels that there is need of modification,  the same will be updated after our satisfaction  in best possible time. 


To view or download free above mentioned or Previous Year Calculators click here 


Thursday, April 25, 2013

FDR Interest Calculator on Maturity/Pre-matured/Re-Invest

Friends,  Nowadays, Interest rates on Bank Deposit/FDR are being changing time to time.  As an investor it is great problem to deposit his money in Bank etc.  As and when he Deposit money for a particular period i.e. 1 year, 2 year or 5 year etc.   Bank change interest rate in few days or increased interest rate.  In such position investor pre-matured his deposit for getting better interest on his money.   A great problem arised that  Pre-maturity  and invest on new Deposit Rate is better or not. 

                 Keeping in view this problem, a interest calculator has been prepared which calculates interest on
maturity and Pre-matured amount on particular Date and the investment in new rates of Pre-matured amount. 

Requirement of Software:-
                    Microsoft Office Excel-2007 or greater is required for running this software.

How to Install :-
                   Simply download zip file and run.  


How to use :-
  • Enter base data in only White cell.
  • Enter Rate of Interest, date of Investment and Date of Maturity.
  • By default, current date is equal to Pre-Mature Date. 
  • Date of pre-maturity is editable or changeable.
  • Reduction of Interest Rate depends upon different banks either 1% or 2% or 0%.
  • New FDR Interest Rate can be entered. 
  • Finally, it can be watched that  is there  any Benefit or Loss due to change in Interest rate. 
Tenure for Getting download link after making request :-
        Assured  time is 2  working days but expected at the earliest on confirmation of registered member.
                   
                             Excel Based FDR Interest Calculator workable in Office 2007 or further 



Free Download link will be provided through email to  only registered email at www.TdsTaxIndia.com.  Request can be done at email at easyjain@gmail.com
To read previous posts Click Here

Wednesday, April 3, 2013

Income Tax :- Latest Form No 15G or Form No. 15H or Form No. 15H-format-2

Friends,  Form 15G and Form 15H are important forms for non-deduction of TDS on income.   In case you have any interest income from any financial institutions or others, you may submit Form 15G or Form 15H as required with some conditions mentioned in notes in the forms.   Mainly an assessee who have income more than threshold limit can not submit these forms.  Income Tax Department has released new format of Form 15G, Form 15H or Form 15H-format -2 vide Notification No. 11/2013 [F.NO.142/31/2012-SO(TPL)]/SO 410(E) Dated 19.02.13 which is applicable w.e.f. financial year 2012-13 or assessment year 2013-14.

FORM NO. 15G is generally used as declaration under section 197A(1) and section 197A(1A) of the Income Tax Act,1961 by an individual or a person (not being a company or firm claiming certain receipts without deduction of tax.

FORM NO. 15H is used as declaration under section 197A(1C) of  the Income Tax Act,1961 by an individual who is of the age of sixty years or more claiming certain receipts without deduction of tax. 

Tuesday, April 2, 2013

How to replace Blank fields with Zero in Excel

Friends,   Many times we feel that zero is required in blank field in excel.   Blank fields are not accepted in software like as  while creating Tds return with NSDL software, if there is any blank field, software shows error.  In such case you have only two options, one is manual and second is with command.  Till today I was also using manual option, today I feel why it should not be done through command which will be simple and accurate.

Command = Select Area (as shown in First picture) > Press "Control+F"  and select "Replace" as shown in Second picture > use Replace All. 




In this way replacement of Blank fields with Zero is too much simple. 

Note :-  In complete blank sheet, above command will not work.  Some digit like Last cell in the selected area should be typed before applying this command.  

Friday, March 15, 2013

Liability to Pay Advance Tax Installment.

All  About Regarding Advance Tax
Advance Tax Calculator
        Apart from Deduction of Tax at source while making various payments, Advance Tax is compulsory for every assessee as per  Section 210 under Indian Income-Tax act.   In case tax on assessee's estimated income of current year  comes to Rs. 10,000 or more-, Advance Tax liability arises for each and every assessee.  Earlier or before 1.04.2009, this limit was Rs. 5,000.00.  Each and Every assessee should take care in the following months regarding Payment of Advance Income Tax.

  • June
  • September
  • December
  • March
  • Last day of March
To make more easy understanding regarding Advance Income Tax (Click here) to download the Advance Tax calculator. Complete Section 208, 209, 209A and  210 related to payment of Advance Tax is also given below for your ready record.


Section 208   78[Conditions of liability to pay advance tax.
208. Advance tax shall be payable during a financial year in every case where the amount of such tax payable by the assessee during that year, as computed in accordance with the provisions of this Chapter, is 79[ten thousand] rupees or more.]

Section 209 Computation of advance tax.
209. 80[(1) The amount of advance tax payable by an assessee in the financial year shall, subject to the provisions of sub-sections (2) and (3), be computed as follows, namely :—

             (a)   where the calculation is made by the assessee for the purposes of payment of advance tax under sub-section (1) or sub-section (2) or sub-section (5) or sub-section (6) of section 210, he shall first estimate his current income and income-tax thereon shall be calculated at the rates in force in the financial year;

             (b)   where the calculation is made by the Assessing Officer for the purpose of making an order under sub-section (3) of section 210, the total income of the latest previous year in respect of which the assessee has been assessed by way of regular assessment or the total income returned by the assessee in any return of income furnished by him for any subsequent previous year, whichever is higher, shall be taken and income-tax thereon shall be calculated at the rates in force in the financial year;

              (c)   where the calculation is made by the Assessing Officer for the purpose of making an amended order under sub-section (4) of section 210, the total income declared in the return furnished by the assessee for the later previous year, or, as the case may be, the total income in respect of which the regular assessment, referred to in that sub-section has been made, shall be taken and income-tax thereon shall be calculated at the rates in force in the financial year;

             (d)   the income-tax calculated under clause (a) or clause (b) or clause (c) shall, in each case, be reduced by the amount of income-tax which would be deductible 81[or collectible] at source during the said financial year under any provision of this Act from any income (as computed before allowing any deductions admissible under this Act) which has been taken into account in computing the current income or, as the case may be, the total income aforesaid; and the amount of income-tax as so reduced shall be the advance tax payable.]

82[(2) Where the Finance Act of the relevant year provides that, in the case of any class of assessees, net agricultural income (as defined in that Act) shall be taken into account for the purposes of computing advance tax, then, the net agricul-tural income to be taken into account in the case of any assessee falling in that class, shall be—

             (a)   in cases 83[where the Assessing Officer makes an order under sub-section (3) or sub-section (4) of section 210],—

         (i)   if the total income of the latest previous year in respect of which the assessee has been assessed by way of regular assessment forms the basis of computation of advance tax payable by him, the net agricultural income which has been taken into account for the purposes of charging income-tax for the assessment year relevant to that previous year; or

  84[(ii)   if the total income declared by the assessee for the later previous year referred to in sub-section (4) of section 210 forms the basis of computation of advance tax, the net agricultural income as returned by the assessee in the return of income for the assessment year relevant to such later previous year;]

        85[(b)   in cases where the advance tax is paid by the assessee on the basis of his estimate of his current income under sub-section (1) or sub-section (2) or sub-section (5) or sub-section (6) of section 210, the net agricultural income, as estimated by him, of the period which would be the previous year for the immediately following assessment year.]

(3) Where the Finance Act of the relevant year specifies any separate rate or rates for the purposes of computing advance tax in the case of every Hindu undivided family which has at least one member whose total income of the previous year exceeds the maximum amount not chargeable to income-tax in his case, then, the 86[Assessing] Officer shall, for making an order under 87[sub-section (3) or sub-section (4) of] section 210 in the case of any such Hindu undivided family, compute (subject to the provisions of section 164) the advance tax at such rate or rates—

             (a)   in a case where the total income of the latest previous year in respect of which the Hindu undivided family has been assessed by way of regular assessment forms the basis of computation of advance tax, if the total income of any member of the family for the assessment year relevant to such latest previous year exceeds the maximum amount not chargeable to income-tax in his case;

             (b)   in a case where the total income of the previous year 88[in respect of which a return of income is furnished by the Hindu undivided family under section 139 or in response to a notice under sub-section (1) of section 142] forms the basis of computation of advance tax, if the total income of any member of the family for the assessment year relevant to such previous year exceeds the maximum amount not chargeable to income-tax in his case.

Section -209A Computation and payment of advance tax by assessee.
89209A. [Omitted by the Direct Tax Laws (Amendment) Act, 1987, w.e.f. 1-4-1988. Original section was inserted by the Finance Act, 1978, w.e.f. 1-6-1978.]



Section -210 as per Indian Income Tax Act.
90[Payment of advance tax by the assessee of his own accord or in pursuance of order of Assessing Officer.

210. (1) Every person who is liable to pay advance tax under section 208 (whether or not he has been previously assessed by way of regular assessment) shall, of his own accord, pay, on or before each of the due dates specified in section 211, the appropriate percentage, specified in that section, of the advance tax on his current income, calculated in the manner laid down in section 209.

(2) A person who pays any instalment or instalments of advance tax under sub-section (1), may increase or reduce the amount of advance tax payable in the remaining instalment or instalments to accord with his estimate of his current income and the advance tax payable thereon, and make payment of the said amount in the remaining instalment or instalments accordingly.

(3) In the case of a person who has been already assessed by way of regular assessment in respect of the total income of any previous year 91[***], the Assessing Officer, if he is of opinion that such person is liable to pay advance tax, may, at any time during the financial year but not later than the last day of February, by order in writing, require such person to pay advance tax calculated in the manner laid down in section 209, and issue to such person a notice of demand under section 156 specifying the instalment or instalments in which such tax is to be paid.
(4) If, after the making of an order by the Assessing Officer under sub-section (3) and at any time before the 1st day of March, a return of income is furnished by the assessee under section 139 or in response to a notice under sub-section (1) of section 142, or a regular assessment of the assessee is made in respect of a previous year later than that referred to in sub-section (3), the Assessing Officer may make an amended order and issue to such assessee a notice of demand under section 156 requiring the assessee to pay, on or before the due date or each of the due dates specified in section 211 falling after the date of the amended order, the appropriate percentage, specified in section 211, of the advance tax computed on the basis of the total income declared in such return or in respect of which the regular assessment aforesaid has been made.

(5) A person who is served with an order of the Assessing Officer under sub-section (3) or an amended order under sub-section (4) may, if in his estimation the advance tax payable on his current income would be less than the amount of the advance tax specified in such order or amended order, send an intimation in the prescribed form92 to the Assessing Officer to that effect and pay such advance tax as accords with his estimate, calculated in the manner laid down in section 209, at the appropriate percentage thereof specified in section 211, on or before the due date or each of the due dates specified in section 211 falling after the date of such intimation.

(6) A person who is served with an order of the Assessing Officer under sub-section (3) or amended order under sub-section (4) shall, if in his estimation the advance tax payable on his current income would exceed the amount of advance tax specified in such order or amended order or intimated by him under sub-section (5), pay on or before the due date of the last instalment specified in section 211, the appropriate part or, as the case may be, the whole of such higher amount of advance tax as accords with his estimate, calculated in the manner laid down in section 209.]

Advance Tax Calculator (Excel Based)

Friends, 

               As due date for payment of Advance Tax is very much near for Company Case (corporate cases) & Individuals.   Calculate your income Tax and enter only estimated  income tax Amount.  Advance tax alongwith Due Dates will be automatically appear on your screen.  It is easy in use. 

In case you do not know your Income Tax, Calculate Your Income Tax amount First (Click Here)
  • Please Click Here in case non appearing of Advance Tax Calculator.


Friday, May 25, 2012

10 E form for the Assessment Year 2013-14 or Financial Year 2012-13

The persons who has received any salary arrears in the Financial Year 2012-13 and want to save Income Tax through claiming relief  under section 89(1).  Easy and Fast calculations are available for generating 10E form for the Assessment Year 2013-14.   

Only white cell are to be filed and calculator will generate 10E form automatically. 


Download 89(1) Calculator for Assessment Year 2013-14 (Click Here)




B.—Relief for income-tax]
69[Relief when salary, etc., is paid in arrears or in advance.
89. Where an assessee is in receipt of a sum in the nature of salary, being paid in arrears or in advance or is in receipt, in any one financial year, of salary for more than twelve months or a payment which under the provisions of clause (3) of section 17 is a profit in lieu of salary, or is in receipt of a sum in the nature of family pension as defined in the Explanation to clause (iia) of section 57, being paid in arrears, due to which his total income is assessed at a rate higher than that at which it would otherwise have been assessed, the Assessing Officer shall, on an application made to him in this behalf, grant such relief as may be prescribed70:]
71[Provided that no such relief shall be granted in respect of any amount received or receivable by an assessee on his voluntary retirement or termination of his service, in accordance with any scheme or schemes of voluntary retirement or in the case of a public sector company referred to in sub-clause (i) of clause (10C) ofsection 10, a scheme of voluntary separation, if an exemption in respect of any amount received or receivable on such voluntary retirement or termination of his service or voluntary separation has been claimed by the assessee under clause (10C) of section 10 in respect of such, or any other, assessment year.]

Thursday, May 24, 2012

Form 10E or Relief u/s 89(1) for Financial Year 2011-12 or Assessment Year 2012-13

The persons who has received any salary arrears in the Financial Year 2011-12 and want to save Income Tax while claiming relief  under section 89(1).  Easy and Fast calculations are available for generating 10E form for the Assessment Year 2012-13.   As Income Tax Returns forms are already ready to upload Salary Returns in Form ITR-1 (Sahaj) form.  

Only white cell are to be filed and calculator will generate 10E form automatically. 


Download 89(1) Calculator for Assessment Year 2012-13 (Click Here)


B.—Relief for income-tax]
69[Relief when salary, etc., is paid in arrears or in advance.
89. Where an assessee is in receipt of a sum in the nature of salary, being paid in arrears or in advance or is in receipt, in any one financial year, of salary for more than twelve months or a payment which under the provisions of clause (3) of section 17 is a profit in lieu of salary, or is in receipt of a sum in the nature of family pension as defined in the Explanation to clause (iia) of section 57, being paid in arrears, due to which his total income is assessed at a rate higher than that at which it would otherwise have been assessed, the Assessing Officer shall, on an application made to him in this behalf, grant such relief as may be prescribed70:]
71[Provided that no such relief shall be granted in respect of any amount received or receivable by an assessee on his voluntary retirement or termination of his service, in accordance with any scheme or schemes of voluntary retirement or in the case of a public sector company referred to in sub-clause (i) of clause (10C) ofsection 10, a scheme of voluntary separation, if an exemption in respect of any amount received or receivable on such voluntary retirement or termination of his service or voluntary separation has been claimed by the assessee under clause (10C) of section 10 in respect of such, or any other, assessment year.]

Thursday, April 19, 2012

Free TDS Calculator Excel Based

Friends,
Excel Based TDS Calculator 

                Simple online TDS calculator w.e.f. 01-Oct-2009 is available below.  Enter amount in white cell in which you want to calculate T.D.S. T.D.S. will be calculated automatically on all sections like as 194A, 194C,194H,194I,194J etc.



TDS Calculator w.e.f. 01.10.2009
Financial Year 2010-11 (Assessment Year 2011-12)
(for further updates visit at www.fastworking.blogspot.com)
Tax Deduction at Source (Rates)



Enter Bill Amount

515800



Section
Nature of Payment
Threshhold Limit
TDS %
TDS (Amount)


01-10-09 to 30-06-10
01-07-10 to onwards


194-A
Interest from Bank
10000
10000
10
51580
194-A
Interest Others
5000
5000
10
51580
194-B
Winning from Lotteries
5000
10000
30
154740
194-BB
Winning from Horse Races
2500
5000
30
154740
194-C
Contractor/Sub Contractor including Advertisor





     1) To Individual/H.U.F.
(a) 20000 as single   (b) 50000  in a year   
(a) 30000 as single    (b) 75000  in a year
1
5158

     2) To Other than Individual/H.U.F.
2
10316

     3) To Transporters (If Pan is Furnished)
0
0
194-D
Insurance Commission
5000
20000
10
51580
194-H
Commission or Brokerage
2500
5000
10
51580
194-I
Rent (1) Land,Building,Furniture or any Property
120000
180000
10
51580

        (2) Plant,Machinery & Equipment
120000
180000
2
10316
194-J
Profesional or Technical Services
20000
30000
10
51580












Note :- Surcharge and Education Cess has been removed w.e.f. 01.10.2009
Note :- If pan is not provided, 20% TDS will be deducted w.e.f. 01.04.10 u/s 206AA



In case non availability of calculator Click Here



Click here to download tds calculator in offline mode.

Know more regarding etds/etcs (Click Here)

Useful Calculator Free Download (Click Here)

Intense Debate Comments