All in One Tax Preparation Excel Based Software for Non-Govt Employees for F.Y.2017-18

Prepare at a time Income Tax Computed Sheet + Automated Individual Salary Sheet + Salary Structure as per Private employees Salary Pattern + Automated H.R.A. Exemption Calculation + Automated Form 12 BA + Automated Form 16 Part A&B and Forn 16 Part B for F.Y.2017-18.

Click here to Download the Excel Based Software All in One for  Non-Govt Employees for F.Y.2017-18

Read More

Automated Excel based Arrears Relief calculator with Form 10E for A.Y 2018-19 for claiming rebate u/s 89(1)

As per section 89(1) of the Income Tax Act, 1961 relief for income tax has been provided when in a financial year an employee receives the salary in arrears or advance. As per Rule 21AA of the Income Tax Rules, 1962, Form 10-E has been prescribed for claiming the relief.

According to the said rule, in case the employee is a Government servant or is an employee of a company, cooperative society, local authority, university, institution or association of body, he/she may for claiming the relief submit the form 10E to his/her employer who is responsible for making the payment of the salary as referred to in subsection (1) of section 192 of the Income Tax Act, 1961

In all other cases, the assessee for claiming the relief should file an application in form 10E to his/her income tax assessing officer.   The relief under section 89(1) is allowable in the assessment year in which the arrears or the advance is received by the employee.

Pay revisions, particularly in Government Sector, has become common. Since independence six Pay Commissions have been set up by the Government so far. Recommendations of each commission with retrospective effect have resulted in arrears of salaries. The rationale behind giving this relief under section 89 is that due to the payment of arrear or advance salary received in a given financial year, the income of the employee for that financial year gets increased due to the amount of the arrears or advances. As a result, the income of the employee attracts taxation at a higher rate than that rate at which his income would have been taxed had there been no such arrears or advances. 

Click here to Download Automated Arrears Relief Calculator U/s 89(1) with Form 10E From the F.Y. 2000-01 to F.Y.2017-18

Read More

Automated Tax Computed +Arrears Relief +HRA Exemption +Form 16 Part B and Form 16 Part A&B for Govt and Non-Govt employees for the F.Y 2017-18 with New Income Tax Slab Rate for F.Y.2017-18

It is necessary as well as mandatory to download the Form 16 Part A from the TRACES Portal www.tdscpc.gov.in. But now at this time, it is necessary to calculate the Actual Taxable Income of each and every employee of Govt and Non-Govt employees.

Also, it is most and vital that the Perfect Calculation of Income Tax for the Financial Year 2017-18, as the Govt of India has already changed the Tax Slab Rate for the f.Y. 2017-18. Tax Rebate U/s 87 A where can get the extra Tax Benefits up to Rs. 2,500/- who's Taxable Income below Rs.3.5  lakh.

Most of the employee yet not well known to how to calculate the Income Tax and they have no concept of all of tax relief Section. Most of the employees only known to the Income Tax Section 80 C, but other than 80 C have much more Income Tax Section where can get the more Tax Relief. 

Below given the Automatic Preparation Excel Based Software which can prepare at a time your Tax Computed Sheet + Individual Salary Structure for calculating the Gross Salary Income + Automatic Arrears Calculation + Form 10E + Automatic HRA Calculation + Automatic Form 16 Part A and Form 16 Part A&B for the Financial Year 2017-18 and Assessment Year 2018-19.

The Arrears Calculation U/s 89(1) have in this utility which can calculate your Previous Financial Year 2000-201 to 2017-18 with the Form 10 E which is calculated automatically after feeding employee's salary data in Data input sheet.

Click here to Download the Automated All in One TDS on Salary for Government & Non-Government (Private) Employees for the Financial Year 2017-18 & A.Y.2018-19.

Feature of this Excel Utility

1) Automatic Prepare your Income Tax Compute Sheet as per new Tax Slab Rate

   For the Financial Year 2017-18

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

3) Inbuilt the Salary Structure as per the Govt & Non-Govt Concerned Salary

    Pattern.

4) Individual Salary Sheet

5) Individual Tax Compute Sheet

6) Automatic Arrears Relief Calculation with Form 10E U/s 89(1) for F.Y.2017-18

7) Automatic Form 16 Part A&B for f.Y.2017-18

8) Automatic Form 16 Part-B Form F.Y. 2017-18

Main Input Sheet for Deductor

Salary Structure with Tax Deduction Sheet

Income Tax Computed Sheet with New Tax Slab for F.Y.2017-18

Form 12 BA for Value of Perquisite

Automated Arrears Relief Calculation with Form 10E

Form 16 Part B

Click here to Download the Automated All in One TDS on Salary for Government & Non-Government (Private) Employees for the Financial Year 2017-18 & A.Y.2018-19.

Read More

Download Automatic TDS on Salary + Form 16 Part B + Salary Sheet for Govt & Non Govt Employees for Financial year 2017-18

Arrears Relief Calculation up to F.Y.2017-18

Prepare Automatic Income Tax for Govt  & Non-Govt employees for the Financial Year 2017-18 and Assessment Year 2018-19. This Excel Based Software can prepare at a time the Tax Computed Sheet + Individual Salary Structure for both of Govt & Non-Govt employees Salary pattern with the New Income Tax Slab and Amended Section as per the Central Finance Budget 2017-18.

Key Feature of this Excel Utility :-

• Automatic Calculate the Income Tax Liability
• In built the Salary Structure for Govt & Private Employees
• Automatic Calculate the House Rent Exemption
• Automatic Convert the Amount in to the In Words
• Automatic Calculation Arrears Relief U/s 89(1) with Form 10E
• Automated Form 16 Part A&B for F.Y.2017-18
• Automated Form 16 Part B for F.Y.2017-18

                        Click here to Download the utility

 

Read More

Download All in One Income Tax Preparation Excel Based Software for Central Govt Employees for F.Y.2017-18

Click here to download the All in One Income Tax Preparation Excel Based Software for Central Govt Employees for Financial Year 2017-18 & Ass Year 2018-19 with Automated Arrears Relief Calculation U/s 89(1) with Form 10E from F.Y.2000-01 to F.Y.2017-18

The feature of this Excel Utility:-

$ This Excel Utility prepare automatic Income Tax Calculation for F.Y.2017-18 as per New Tax Slab F.Y.2017-18

$ Individual Salary Structure as per the Central Govt Employees Salary Pattern

$ Individual Salary Sheet 

$ Individual Tax Computed Sheet as per New Tax Slab Rate F.Y.2017-18

$ Automated Arrears Relief Calculation U/s 89(1) with Form 10E from F.Y.2000-01 to F.Y.2017-18

$ Automated Income Tax Form 16 Part A&B for F.Y.2017-18

$ Automated Income Tax Form 16 Part B for F.Y.2017-18

$ Automatic House Rent Exemption Calculation U/s 10(13A)

$ Automatic Convert Amount to In-Words, without an Excel Formula 

Employee & Employer's Data Sheet

Salary Structure for Central Govt Employees

Income Tax Form 16 Part B 

Income Tax Form 16 Part A&B

Income Tax Computed Sheet

Data Input Sheet for Arrears Relief Calculator U/s 89(1) with Form 10E

Arrears Relief Calculator U/s 89(1)- Annexure-I

Read More

Download Automated All in One TDS on Salary for Central Govt Employees for F.Y.2017-18 with Form 10E

As the Central Govt has already passed the 7th Pay Commission & hike the Salary of the Each Central Govt Employees for the F.Y.2017-18. Also, the New Finance Budget has modified the Income Tax Slab Rate for F.Y.2017-18. The Finance Budget also reduced the Tax Rebate U/s 87A Rs. 2,500/- who's taxable Income Less than  3.5 Lakh.

New Income Tax Slab Rate for F.Y.2017-18 & A.Y.2018-19 is :-

As per the Central Govt employees Salary Pattern the below given Automated Income Tax Preparation Excel Based Software for the Financial Year 2017-18.

Click here to Download the Automated All in One Income Tax Preparation Excel Based Software for Central Govt Employees for F.Y.2017-18. 

[ This Excel Utility can prepare at a time Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure + Automatic 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 as per the new Income Tax Slab for F.Y.2017-18]

Deductor Details Sheet

C.G.Employees Salary Structure

Tax Computed Sheet

Form 16 Part B 

Arrears Relief input sheet U/s 89(1)

Arrears Relief Annexure-I

Read More

Get Tax Benefit on rent paid if not getting HRA in Section 80GG Deduction, with Automated All in One TDS on Salary for F.Y.2017-18

All salaried are very much familiar with HRA and how to get the benefit of the rent they pay. However, what about those who not get HRA in their salary or for self employed? Will they still get rent benefit? The answer to both the questions is Section 80GG of Income Tax.

Download Automated Govt & Non-Govt employees for F.Y.2017-18 [ This Excel Utility can prepare at a time your Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure + Automatic H.R.A. Exemption Calculation + Automated Arrears Relief Calculator with Form 10e From F.Y.2000-01 to F.Y.2017-18 + Automated Form 16 Part A&B and Form 16 Part B as per the new Income Tax Slab for F.Y.2017-18 ]

So as I said above this section only applies to those who have not availed HRA in their salary or not claiming the deduction on their rent in any of the other sections of income tax.  Below are a few conditions to avail the deduction under this section.

1. This section is only applicable to Individual or HUF.
2. Tax Payer may be either salaried or a self-employed. However, must not be getting HRA.
3. Tax Payer himself or spouse/Minor Child/HUF of which he is a member should not own any accommodation at a place where he is doing a job or business.
4. If Tax Payer owns house at a place other than the place noted above, then the concession in respect of self occupied property is not claimed by him [Under Section 23 (2) (a) or 23 (4) (a)].
5. Tax Payer has to file a declaration in Form No.10BA regarding the expenditure incurred by him towards the payment of rent.

Download Automated All in One TDS on Salary for Non-Govt Employees for F.Y.2017-18 [ This Excel Utility can prepare at a time your Tax Computed Sheet + Individual Salary Sheet + Individual Salary Structure as per Non-Govt Concerned salary pattern + Automatic H.R.A. Calculation U/s 10(13A) + Automated Form 12 BA + Automated Form 16 Part A&B and Form 16 Part B  for F.Y.2017-18 ]

How much amount of deduction one can avail under Sec. 80GG?

If the above five conditions are satisfied, the amount deductible under Section 80GG is LEAST OF THE FOLLOWING.

• Rs.5, 000 per month;
• 25% of total income of taxpayer for the year; or
• Rent Paid less 10% of total income (Rent Paid-10% of Total Income).

What is total income for the purpose of Sec. 80GG?

We can calculate it as below.

Total Income=Gross Total Income-LTCG-STCG-Income referred under the Sec.115A-Amount deductible under Sec.80C to 80U (except Section 80GG)

Let us try with one example-

Mr. X’s total income (calculated as per above formula) is Rs.4, 00,000. He pays an annual rent of Rs.1, 50,000. Then least of the below will be applicable for deduction under Sec. 80GG.

• Rs.60, 000 per year.
• Rent Paid-10% of Total Income=Rs. 1,50,000-Rs.40,000=Rs.1,10,000.
• 25% of Total Income i.e Rs.1, 00,000.

So least of the above will be Rs.60, 000, which one can claim under Section 80GG for that particular FY.

Read More