Automated All in One TDS on Salary for Govt. and Non-Govt Employees for F.Y.2017-18 and A.Y. 2018-19, Plus Income Tax Benefits on Joint Home Loan ?


All in One for Govt and Non – Govt employees For AY 2018-19 [ This Excel Utility can prepare at a time Tax Compute Sheet + Individual Salary Sheet + Individual Salary Structure as per Govt & Non-Govt Salary pattern + Automated H.R.A. Exemption Calculation + Automated Arrears Relief Calculation with Form 10E up to F.Y.2017-18 + Automated Form 16 Part A&B and Form 16 Part B for F.Y. 2017-18 as per the New Income Tax Slab ]

Govt-Non Govt Page 1Govt Non Govt Page 2Bihar Tax ComputeMaster Form 16 A&B Page 3Arrears Relief Page 1Arrears Relief Page 2Form 16 Part B

Income Tax Benefits to Own a House After Budget 2017,Plus Automated All in One TDS on Salary for Central and State employees for F.Y. 2017-18


Here are some of the exclusive income tax benefits to own a house as per the Finance Budget 2017-18

1 – House Loan Deduction under Section 80C

The very first tax benefit that comes to your mind is the house loan deduction. When you purchase a house for residential purpose and avail a loan for the same, the IT department gives you a deduction of INR 1, 50, 000 (upper cap) for loan repayment. This means that if you are paying a monthly installment of INR 10, 000 per month towards house loan, you would be getting a deduction of INR 1, 20, 000 while computing your payable tax. However, do make a note that the residential property should not be sold before 5 years from the date of possession, else the benefits would be reversed.

2 – Deduction for payment of Registration Chargers and Stamp Duty

Apart from availing deduction for repayment of house loan, the IT Department also lets you claim a deduction in respect of expenses such as registration charges, stamp duty, etc. This benefit is only available in the year of acquisition. The amount would be claimed under Section 80C and the upper cap would remain at INR 1, 50, 000.

3 – Deduction for interest paid on house loan [Section 24(b)]

Another opportunity lies in Section 24(b). Section 80C lets you grab a deduction in respect of repayment of house loan and Section 24(b) lets you claim a deduction for the interest paid on house loan. Unlike Section 80C, even if you sell your house within 5 years of its acquisition, there would be no tax reversal. An available deduction is INR 2, 00, 000.

4 – Benefit granted in Budget 2017

In the latest budget, the Finance Minister of India announced that an additional deduction of INR 50, 000 would be available to new house owners. Section 80EE would offer the additional deduction provided the cost of a house is not greater than INR 50, 00, 000 and the loan sanctioned amount is not more than INR 35, 00, 000. The deduction is only available if the loan is availed from a house finance company or a financial institute.

(Central and All State Govt employees)All in One TDS for A.Y 2018-2019[ This Excel Based Utility can prepare both of Central & State Govt employees Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure as per the Central & State Govt Employees Salary Pattern + Automatic Calculate the H.R.A. Exemption + Automatic Form 16 Part A&B and Form 16 Part B for F.Y.2017-18]Cental & State Page 1Cental & State Salary StructureGovt-Non Govt Page 3

How to save tax on salary income,With Automated 50 and 100 employees Form 16 Part B for F.Y.2016-17


The major concern for many of salaried is how to save tax on salary income. All are known few but fail to utilize to the maximum. In this post, We will try to list down all allowances and deductions which help you in saving tax.

What is the difference between Exemption and deduction?

If an income is exempt from tax, then it is not included in the computation of income. However, the deduction is given from income chargeable to tax. Exempt income will never exceed the amount of income. However, the deduct may be less than or equal to or more than the amount of income.

Read More

Save your tax as per the new budget 2016, With All in One TDS on Salary for Central and State Govt employees for F.Y.2016-17 and A.Y.2017-18


Things to save your tax as per the new budget, As 1st April 2016 is just about to come, we need to find out ways to save our tax deductions & also save our tax liability. This is the right time where we can pursue tax planning & save our tax from being deducted or make investments to save our tax liability.

Download Income Tax All in One TDS on Salary for Central Govt employees for Financial Year 2016-17 & Assessment Year 2017-18 as per Budget 2016 [ This Excel Utility can prepare at a time Tax Compute Sheet + Individual Salary Sheet + Individual Salary Structure + Automatic Calculation of H.R.A. Exemption + Automated Form 16 Part A&B and Form 16 Part B as per Amended by the Finance Budget 2016]

Here is a list of things you can do to make your money stay with you. This will not just get you tax saving, but also help you to multiply your money for the long term. You will not just be under burdened from paying tax, but will also have some savings for your retirement. Now check more details about “Last Minute Things to save your tax as per the new budget” from below….

Save your tax as per the new budget 2016

Here are the steps which you can follow:

Step 1: Calculate your projected income:

Be it Income from salary, Business or profession profits, house property income, capital gains or interest or dividend income, you need to sum it up. You can then calculate your tax liability on the same but make sure you calculate it keeping the recent slabs in mind. Also, if you are not sure of the exact amount, you can select a proportionate amount of interest, dividend, etc.

Step 2: Calculate your tax liability:

After finalizing your income, you need to calculate your tax liability. You need to consider the new budget and then consider the basic exemption slabs accordingly. In the recent budget, there are not many changes in the various slabs. Only the rebate under section 87A has been increased from 2000/- to 5000/- for the assesses having income below Rs. 5 Lacs.

Step 3: Check for your investments:

You might have made a few investments like PPF, LIC, etc. during the on-going year. You may also have an on-going housing loan in which you can claim interest & principal deductions. You also might have an education loan, on which you are paying installments, etc. so, now you need to make a list of all your investments & find out the totals.

Download All in One TDS on Salary for All State Govt employees For Financial Year 2016-17 & Assessment Year 2017-18 [ This Excel Utility can prepare at a time Tax Compute Sheet + Individual Salary Sheet + Individual Salary Structure + Automatic Calculation of H.R.A. Exemption + Automated Form 16 Part A&B and Form 16 Part B as per Amended by the Finance Budget 2016]

Step 4: Scope for investments:

Now, you need to find out the balance amount which is possible for you to invest & make sure you have the required funds to invest. You just have 4-5 days in hand, so you need to take steps at the earliest.

Possible Areas of Investment:

The place where you can make sure you have already invested or if you want to do now, you can go for that:

  1. PPF:You can contribute a max up to Rs. 150,000/- in this investment. The interest rate is between 7 – 8% for this investment.
  1.   FD:There are tax saver FDs for 5 years & 10 years available in which the amount you can invest is a minimum of Rs. 500/- & a max up to Rs. 150,000/-.
  1. Medi – Claim:Make sure you have a mediclaim insurance. It is not an investment basically, but you get deductions up to Rs. 25,000/- for < 60 Years and  Rs. 30,000/-for above 60 Year i.e. Sr.Citizen

LIC: You have two options here. There are cum bonus plan in which you get your LIC money back. Also, there are other plans which just provide a life cover

Download Automated Arrears Relief Calculator with Form 10E from F.Y.2001-02 to F.Y.2016-17 and Reduce tax liability on arrears relief calculator U/s 89(1),


When salary or other income arrears are received in any particular year, one’s tax liability for that year increases. Simply because one’s total income for that year has increased. Most salaried individuals will be able to identify with such situations. But having to pay a higher tax on account of arrears is unfair to the taxpayer. Had he originally received the money in the year(s) that he was supposed to receive it, the additional tax would have been staggered over this time, instead of converging in one year as a lump sum payment.

Our Income tax law has taken the same into consideration and allows a tax deduction under Section 89(1) for this additional tax burden on the tax payer. At times, the employee appraisal process (where the employee can expect a revised salary), takes longer than expected, and the actual payments are postponed. Also, commissions and other cash incentives for sales and marketing personnel, could be reconciled at a later date.

SECTION 89(1)
Basically, the relief under Section 89(1) is arithmetical. It involves ascertaining the two amounts of tax, the first is the amount of tax applicable to the total income, including the extra amount in the year of receipt. The second is calculating the amount of tax by adding the arrears to the total income of the years to which they relate. The difference between the two amounts is the deduction allowed.

In other words, if the taxpayer is required to pay any additional amount of tax (in the year of receipt) than what he would have otherwise paid, had he received the money in the year(s) he was supposed to receive it, such additional tax can be reduced from the tax payable.

Download Automated Arrears Relief Calculator with Form 10E From the Financial Year 2001-02 to Financial Year 2016-17 (Up to date Version) as per Finance Budget 2016.

Autofill Excel Based Form 16 Part B and Part A&B for the Financial Year 2015-16 & Assessment Year 2016-17


Download the Excel Based Automated Form 16 for Financial Year 2015-16 & Assessment Year 2016-17 from the below link


Main Feature of this Excel Utility are :-

  • Automatic calculate the Form 16 Part A&B and Part B
  • Automatic Calculate the Income Tax Liability 
  • Automatic Prepare the Form 16 after filling the employees data
  • Automatic Convert the Amount in to the In words
  • Easy generate the Utility
  • Easy install this utility more than One System and work from both System
  • All Amended Income Tax Section as per New Finance Budget 2015-16

1) Download the On by One Prepare Form 16 Part A&B and Part B( Prepare One by One Form 16 Part A&B and Part B for FY 15-16)

 

2)Download 50 employees Master of Form 16 Part A&B  ( This utility can prepare at a time 50 employees Form 16 Part A&B for FY 2015-16)

 

3)Download  100 employees Master of Form 16 Part A&B  ( This utility can prepare at a time 100 employees Form 16 Part A&B for FY 2014-15)

 

4)Download 50 Master of Form 16 Part B( This can prepare at a time 50 employees Form 16 Part B for FY 2015-16)

 

 5)Download 100 Master of Form 16 Part B( This can prepare at a time 50 employees Form 16 Part B for FY 2015-16)

 

6) Download the Master of Form 16 Part B with Form 12 BA ( This utility can prepare at a time 50 employees Form 16 Part B with 12 BA for FY 2015-16)

The Income Tax Department have notifies that the the Income Tax Form 16 Part A is now Mandatory to download from the Traces Portal (www.tdscpc.gov.in) by the all of deductors. But most of the deductor have not able to download the Form 16 Part A or they have not well known to how to download the Form 16 Part A from the TRACES Portal. Some of the Deductor yet not known about this new Notification of CBDT. It appears that the most of Deductor have not known that the new format of Form 16 and the Form 16 have in two parts Part A and Part B.Various Govt and Non Govt Concerned could not download the Form 16 Part A from the TRACES Portal. But the Form 16 must be distribute to their employees within this month positively, so they can fill the Income Tax return online or off line.

The Part A of Form 16 have only have the Quarter ended Income Tax deducted and deposited in to the Central Govt Account. and another Part of Form 16 Part B have the Details of employee’s Salary with the Tax liability of employee.

Any employee can view and download the Tax Deducted and Deposited through the view and download the 26A through the TRACES Portal ( www.tdscpc.gov.in). this 26A is like as the Form 16 Part A.

If you are not able to download the Form 16 Part A you can look the above given some Excel Based Form 16 preparation Software which can prepare both of Form 16 Part A&B and Part B for the financial Year 2013-14 and Assessment Year 2014-15.

Central Govt Employees All in One TDS on Salary ( Prepare at a time Tax Compute sheet+ Individual Salary Structure +Arrears Relief +HRA Exemption +Form 16 Part B +Form 16 Part A&B for FY 2015-16


The Limit of  some Tax Section has Increased by this Finance Budget 2015. The Section 80U have increased 75000/- P.A. and Rs. 125000/- P.A. for Blind persons. Traveling Allowances also raised up to 1600/- P.M. and Blind Person can avail Rs. 3200/- P.M. Section 80D Raised Rs. 25000/- and Sr.Citizen Rs. 30,000/-

It is necessary to calculate your Tax Liability for the Financial Year 2015-16 as the D.A. has also increased to the Govt employees time to time.

The below given Excel based Software Only for Central Govt Employees which can prepare at a time Income Tax Computed Sheet + Automatic Arrears Relief Calculator + Automatic House Rent Exemption calculation + In built Salary Structure for both Govt & Non Govt employees which prepared on the basis of Salary Pattern of each Govt and Non Govt concerned + Automated Form 16 Part A&B + Automated Form 16 Part B for the Financial Year 2014-15 and Assessment Year 2015-16.

It is most hazard to calculate individually HRA Calculation separately another sheet and also it is hazard to calculate the Arrears Relief Calculation from the financial Year 2000-01 to 2015-16. This Excel Utility can prepare all the calculation just a moment. Thus your time may reduce for calculating the actual Income Tax of each employee.

Feature of this Utility:-

·         Automatic Calculate Income Tax with Tax Computed sheet individually as per Central Govt Salary Pattern.

·         Individual Salary Structure for calculating the Gross Salary Income as per Central Govt employees

·         Automatic Calculate the House Rent Exemption Calculation U/s 10(13A)

·         Automatic Calculate the Arrears Relief Calculation with Form 10E since 2000-01 to 2015-16

·         Automated Form 16 Part A&B for F.Y.2015-16

·         Automated Form 16 Part B for F.Y.2015-16

·         Automatic Convert the Amount in to In Words

Click here to Download  CentralGovt Employees Excel Based Software [ This Excel based Utility can prepare at a time Tax Compute sheet+ Individual Salary Structure +Arrears Relief +HRA Exemption +Form 16 Part B +Form 16 Part A&B for FY 2015-16 ]