Showing posts with label Automated Income Tax Calculator for Non-Govt employees for F.Y.2019-20. Show all posts
Showing posts with label Automated Income Tax Calculator for Non-Govt employees for F.Y.2019-20. Show all posts

Thursday, 24 October 2019

Download Automated All in One TDS on Salary Non-Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021.


As per the Finance Budget 2019, some Important Income Tax Section and Income Tax Rebate has changed. The Major modification including the Income Tax Slab Rate for the F.Y. 2019-20 is given below.

1) Income Tax Slab for the Financial Year 2019-20 is Same as Previous F.Y.2018-19
2) Raised the Income Tax Rebate U/s 87A up to Rs. 12,500/- who's Taxable Income less than 5 Lakh.
3) Raised the Income Tax Standard Deduction U/s16(ia) from Rs. 40,000/- to  50,000/-

4) Raised the Tax Exemption from the Bank/Post Office Savings Interest from 10,000/- to 50,000/-
5) Introduce New Section 80EEA for New Home Loan Interest Rs.1.5 Lakh.

Download All in One TDS on Salary for Non-Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021 With New Format of Form 16 Part B.

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per Non-Govt (Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format

Tuesday, 10 September 2019

Download Automated All in One TDS on Salary for the Non-Govt (Private) Employees for F.Y. 2019-20 With Income Tax relief for AY 2020-21


The Interim Budget presented by the finance minister, Piyush Goyal, on February 01, 2019, made some major changes to the tax rates applicable to individuals. Effectively, the budget has made net taxable income free of tax up to Rs5 lakhs. But there is a catch here. The tax slabs have not been tinkered with. Instead, the tax on the lowest slab will be given as rebate to the assessee. For example, the Finance Bill envisages a maximum tax rebate of Rs12,500 under Section 87A of the Income Tax Act. What needs to be remembered is that these new rates of tax will be applicable from the financial year 2019-20 corresponding to the assessment year 2020-21. Let us understand this issue better as we go through the individual slabs for income tax applicable.

Applicable Income Tax Slab Rates for AY2020-21 for Individuals
The tax slabs will depend on whether the tax assessee falls in the category of a super senior citizen (above 80 years), senior citizen (60-80 years) or others (less than 60 years)
 

A.             Individual (resident or NRI), less than 60 years on the last day of the previous year:
Net income range
Income-Tax rate
Up to Rs2,50,000
Nil
Rs2,50,001 to Rs5,00,000
5%
Rs5,00,001 to Rs10,00,000
20%
Above Rs10,00,000
30% 
 

B.            Senior citizens, above 60 years but less than 80 years during the previous year:
Net income range
Income-Tax rate
Up to Rs3,00,000
Nil
Rs3,00,001 to Rs5,00,000
5%
Rs5,00,000 to Rs10,00,000
20%
Above Rs10,00,000
30%
 

C.            Super senior citizens, who are 80 years or more during the previous year:
Net income range
Income-Tax rate
Up to Rs 5,00,000
Nil
Rs. 5,00,001 to Rs10,00,000
20%
Above Rs10,00,000
30%
 
Additional levies over and above the basic slabs
 
The tax calculated as per the above slabs provides the basic tax payable. There are three adjustments to be made to this figure as under:
 
·                  Income Tax Act levies surcharge on higher income groups. If the net taxable income is more than Rs50 lakhs and up to Rs100 lakhs, a surcharge of 10% is levied. If the annual income is more than Rs100 lakhs, then a surcharge of 15% is applicable on that slab.
· While surcharge is subject to the income level, the health and education cess of 4% is chargeable to all assessees. In the case of higher-income groups, this cess is payable on 4% of the (sum of tax payable and surcharge).
· Rebate of 100% of tax payable will be provided under Section 87A, subject to a maximum of Rs12,500 per assessee. That makes any taxable income up to Rs5 lakh was entirely tax-free.
 ·                  The rate of standard deduction has been enhanced from Assessment Year 2020-21 to Rs50,000 per year from Rs40,000 currently. This is available as a flat deduction to all assessees in place of transport allowance and medical reimbursement.
Earn a million and pay zero tax
One of the advantages of the new tax slabs is that the rebate under Section 87A will be applicable if the net taxable income is up to Rs5 lakhs. This allows you to plan your taxes accordingly. You will be surprised but you can pay zero tax even if your total income is more than Rs10 lakh. Here is how!

Income and Investment particulars
Tax Calculation (AY 2020-21)
Gross Income
Rs10,25,000
Section 80C – PF, LIC
Rs1,50,000
Section 24 – Home Loan Interest
Rs2,00,000
Section 80E – Interest on Education Loan
Rs70,000
Section 80D – Health Insurance
Rs55,000
Total Deductions
Rs4,75,000
Net Income
Rs5,50,000
Standard Deduction
Rs50,000
Net Taxable Income
Rs5,00,000
Tax Payable
Rs.12,500
Rebate under Section 87A
Rs.12,500
Net Tax Payable for FY2019-20
Nil

As can be seen from the above table, you can actually pay zero tax even if you are earning more than a million during the year. With the new fiscal year has just begun, these considerations can go into your tax planning.

Download All in One TDS on Salary for Non-Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021 With Form 12 BA

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the All of Non-Govt(Private) employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
7) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format



8) Automated Form 12 BA

Thursday, 15 August 2019

Avail additional tax benefit on home loan interest U/s 80EEA for the F.Y.2019-20, With Automated Income Tax Software for the F.Y. 2019-20

The Budget 2019 India: The FM has proposed an extra deduction of Rs 1.5 lakh for the intrigue paid on the home advance for private house property. Be that as it may, there are sure conditions to be satisfied before you can guarantee it.
As per the Central Budget 2019 India: The FM has proposed an extra deduction of Rs 1.5 lakh for the interest paid on the home credit for private house property. As of now, the interest paid on home advance up to Rs 2 lakh in a year for a self-involved property fits the bill for reasoning under segment 24 of the I-T Act. The extra interest will fit the bill for a conclusion under the recently presented sector 80EEA. The aggregate sum of conclusion accessible to the citizen will, accordingly, become Rs 3.5 lakh a year. "This will convert into an advantage of around 7 lakh to the middle-class home-purchasers over their credit time of 15 years", said the FM in her Budget discourse.

Download Automated All in One TDS on Salaryfor The Govt & Non-Govt Employees for the Financial Year 2019-2020 andAssessment Year 20120-2021 With New Format of Form 16 Part B.

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the  Assam State Govt employees Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for the F.Y. 2019-20
7) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
8) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format

Be that as it may, recall there are sure conditions to be satisfied before you can guarantee reasonings under both the section.

(I) Loan to be sanctioned by the budgetary foundation during the period starting on the first April 2019 to 31st March 2020

What it implies: The tax cut won't be on a current credit taken before March 31, 2019.

(ii) The stamp duty estimation of house property ought not to surpass Rs 45 lakh

What it implies: The enlistment cost of the house is limited to Rs 45 lakh. Other than urban areas like Mumbai and so on, a 2bhk will be accessible in a few areas at this cost. In the event that you are hoping to purchase a home costing more than this sum, you won't be qualified to guarantee any finding under this area.

(iii) The assessee does not possess any private house property on the date of assent of credit

Download Automated All in One TDS on Salary for The Non-Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021 With New Format of Form 16 Part B.

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the  All the Private or Non - Govt employee’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
8) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
What it implies: It implies, the target of presenting this new tax cut is gone for new purchasers who don't have a home at this point.

(iv) If you have just profited a derivation under this section, same intrigue sum can't be benefited under some other area of the I-T Act

What it implies: It implies, tax reduction on a similar intrigue can't be guaranteed under section 24 and section 80EEA simultaneously. Be that as it may, for the sum surpassing the point of confinement, one can guarantee under the two section.

(v) You will be qualified for derivation under the section, if the rug region of your house isn't surpassing 60 square meters ( 645 sq ft) in metropolitan urban communities or 90 square meters (968 sq ft) in urban areas or towns other than metropolitan urban areas of Bengaluru, Chennai, Delhi National Capital Region (constrained to Delhi, Noida,Greater Noida, Ghaziabad, Gurgaon, Faridabad), Hyderabad, Kolkata and Mumbai (entire of Mumbai Metropolitan Region). Further, this definition will be compelling on or after the first day of September 2019.

Download Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E From the F.Y. 2000-01 to F.Y. 2019-20

What it implies: Carpet region is around 30 percent not exactly super rug region. On the off chance that you are searching for a greater house surpassing around 1000 sq ft in metropolitan urban areas or 1350 in different urban areas, this proposition may not help you much. The administration needs to loosen up as far as possible to make the proposition functional.

Additionally, imagine a scenario where an advance is taken in FY 2019-20 and the intriguing part surpasses Rs 1.5 lakh, would deduction be able to be profited in the two segments. "On the buy of a reasonable house, an individual can benefit a finding of Rs 2 lakh under area 24 of the annual duty act and furthermore, an extra conclusion of Rs 1.5 lakh under segment 80EEA, gave the credit is taken from any money related establishment. Subsequently, if a credit is taken for in FY 2019-20 however intrigue part surpasses Rs 1.5 lakh, the individual can guarantee benefits under both the segments for example 24 and 80EEA and take an all-out derivation to Rs 3.5L,"

Tuesday, 13 August 2019

Affordable housing: How to claim Income Tax deduction up to Rs 3.5 lakh on home loans, With Automated Income Tax Preparation Excel Based software for F.Y. 2019-20


In the Union Budget 2019, affordable housing got a further fillip with an increase in Income Tax deduction of Rs 1.5 lakh on home loans.
Finance Minister Nirmala Sitharaman said the interest paid on housing loans is currently allowed as a deduction to the extent of Rs 2 lakh under Section 24 B.
"To provide further impetus to affordable housing, an additional deduction of Rs 1.5 lakh will be given on interest paid on loans borrowed up to 31 March 2020 for purchase of house up to Rs 45 lakh. Therefore, a person purchasing an affordable house will now get an enhanced interest deduction up to Rs 3.5 lakh. This will translate into a benefit of around Rs 7 lakh to the middle-class home-buyers over their loan period of 15 years," Sitharaman had said.
The government has proposed to insert a new section 80EEA in the Act so as to provide a deduction Rs 1.50 lakh additional income tax deductions on loan is taken for residential house/property up to Rs 45 lakh from any financial institution.
To align the definition of affordable housing under the Income Tax Act with GST Acts, Sitharaman had proposed to increase the limit of carpet area from 30 square metres to 60 square metre in metropolitan regions and from 60 square metre to 90 square metre in non-metropolitan areas. The cost of the affordable house has been fixed at Rs 45 lakh and below.
Conditions for availing tax deduction
(i) The loan has to be sanctioned by a financial institution during the period beginning on 1 April 2019 to 31 March 2020
house property does not exceed Rs 45 lakh
(iii) The assessee does not own any residential house property on the date of sanction of loan
(iv) The loan must be taken from a financial institution or a housing finance company
(v) The taxpayer should not be eligible to claim deduction under the existing Section 80EE

Download Automated All in One TDS on Salary for The Govt & Non-Govt Employees for the Financial Year 2019-2020 and Assessment Year 20120-2021 With New Format of Form 16 Part B.

The feature of this Excel Utility is the following:-
1) This Excel Utility can prepare automatic Tax Calculation as per new Finance Budget 2019
2) The Salary Structure as per the  All the Private or Non - Govt employee’s and Govt Sector’s Salary Pattern
3) Automated Individually Salary Sheet for each Employee
4) Automated Income Tax Salary Sheet for each Employee 
5) This Excel Utility calculate your House Rent Exemption Calculation U/s 10(13A)
6) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10e from the F.Y. 2000-01 to F.Y. 2019-20
7) Automated Income Tax Form 16 Part A&B for F.Y. 2019-20 in New Format
8) Automated Income Tax Form 16 Part B for the F.Y. 2019-20 in New Format
How to claim deductions under Section 24 and Section 80EEA
Under Section 24, homeowners can claim a deduction for interest payments up to Rs 2 lakh on their home loan, if the owner or his family resides in the house property. The deduction of up to Rs 2 lakh applies even when the house is vacant. If you have rented out the property, the entire home loan interest is allowed as a deduction.
If you are able to satisfy the conditions of both Section 24 and Section 80EEA of the Income Tax Act, you can claim the benefits under both the sections.
First, exhaust your deductible limit under Section 24, which is Rs 2 lakh. Then, go on to claim the additional benefits under Section 80EEA. Therefore, this deduction is in addition to the Rs 2 lakh limit allowed under Section 24.