Income Tax Preparation Software in Excel All in One for the Non-Govt Employees for the F.Y.2022-23

 Income Tax Preparation Software in Excel All in One for the Non-Govt Employees for the F.Y.2022-23

 

Income tax tables and rates remain unchanged in the fiscal year 2022-2023. No changes to the Budget for Individual Taxpayers for 2022 have been announced. Taxpayers will be able to pay taxes under the old or new tax regime. Under the new Tax Regime, tax is levied on taxpayers at preferential rates, but significant tax deductions and exemptions are not allowed. However, income tax deductions and exemptions are available under the old tax system, but the tax rate is high. Individuals need to evaluate their tax liability under both tax systems in order to determine the ideal tax system for them. The old tax system can be beneficial for those interested in using most of the deductions and exemptions. Whereas, the new tax system could be ideal for middle-income groups with small, non-tax-oriented investments.

 

Budget 2022: key takeaways

The tax credit of up to Rs 12,500 under Section 87A is still available for individuals with taxable income up to Rs 5 lakh per annum. This means that individuals with an income of up to Rs 5 lacs will not incur any tax liability in the 2022-23 fiscal year and 2023-2024 valuation. A standard deduction of Rs 50,000 is also available under the old tax regime. Income tax deductions under sections 80C-80U are available under the old system for employees.

 

Employees can significantly reduce their tax liability by taking advantage of tax deductions under the old tax system for the fiscal year 2022-23. In fact, individuals with an income of up to Rs 13 lakh can qualify for full tax exemption by taking advantage of all eligible deductions for the 2022-23 financial year.

 

Income tax deduction and exemption up to Rs 1,50,000 is available for individuals under Section 80C. Section 80CCC and 80CCD (1) are included in Section 80C with an aggregate deductible ceiling of INR 1,50,000/-. Investments that qualify for deduction and exemption under Section 80C include investments in the Public Reserve Fund (PPF), the National Savings Certificate (NSC), the Equity Savings Scheme (mutual funds), Life Insurance and etc.

 

State Reserve Fund: One of the most popular small savings schemes among individuals. PPF offers guaranteed returns along with tax incentives. Interest is reported quarterly and interest accrues annually. Investments are provided with a fixed period of 15 years.

ELSS Funds: The equity savings scheme has the shortest lock-up period of 3 years. The investment is deductible under section 80C. Investments in mutual funds can bring higher returns than debt instruments. However, investments in the capital market are subject to volatility. Therefore, investors need to make an informed decision.

 

Best Equity Savings Scheme for Investment: EF 2022-23

National Savings Certificate (NSC): NSC has a 5-year blocking period. Investments are eligible for tax deductions. However, interest earned is taxable. Investment interest is announced quarterly.

 

Life insurance plans. Premiums paid on life insurance policies are also deductible under section 80C. The premium paid by self, spouse, dependent children and any member of an undivided Hindu family is eligible for a deduction. The post-maturity benefit is tax-free in most cases.

 

Senior Savings Scheme (SCSS): This scheme is designed specifically for seniors and offers the highest returns among small savings schemes. The duration of the program is 5 years with the possibility of extension up to 8 years. Under this scheme, persons over 60 years of age can make deposits.

 

Sukanya Samriddhi Yojana (SSY): The scheme aims at the welfare of the girl. A parent or guardian of a girl under the age of 10 is eligible to join the program. The regime applies to a maximum of 2 girls (3 in the case of twins). The maximum deduction under this scheme is Rs 1,50,000.

 

Income Tax Tariffs and Rates for Fiscal Year 2022-23

The mortgage principal repayment is also deductible along with the registration fee and stamp duty paid on the property. However, the allowance is capped at a maximum deduction limit of INR 150,000/-. Provided that the Individual does not transfer the property before the expiration of 5 years from the Fiscal year in which it was acquired. A registration fee and stamp duty deduction are also available for individuals who have not applied for a mortgage.

 

Income tax deductions U/S 80 CCD (1b)

Deposit up to Rs 50,000 - eligible for deduction under section. The deduction is greater than the available U.S. Section 80C deduction for deposits made in the National Pension Scheme (NPS) and Atal Pension Yojana (APY).

Individuals can invest in these pension schemes to qualify for tax deductions up to a maximum of Rs 50,000/-.

Download Automated Income Tax Preparation Excel-Based Software All in One for the Non-Government (Private) Employees for the Financial Year 2021-22 and Assessment Year 2022-23 U/s 115BAC

 

Feature of this Excel Utility:-

1) This Excel Utility Prepare Your Income Tax as per your option U/s 115BAC perfectly.

 

2) This Excel Utility has the all amended Income Tax Section as per Budget 2021

 

3) Automated Income Tax Form 12 BA

 

4) Automated Calculation Income Tax House Rent Exemption U/s 10(13A)

 

5) Individual Salary Structure as per the Non-Govt(Private) Concern’s Salary Pattern

 

6) Individual Salary Sheet

 

7) Individual Tax Computed Sheet

 

8) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2021-22

 

9) Automated Income Tax Revised Form 16 Part B for the F.Y.2021-22

 

10) Automatic Convert the amount in to the in-words without any Excel Formula

Read More

Benefits of U/s 80GG with Automated Income Tax All in One for the Govt & Non-Govt Employees for the F.Y.2020-21 with New and Old Tax Regime U/s 115 BAC.

 

Section 80GG is an uncommon arrangement under Chapter VI-A of the Income Tax Act, 1961, which gives tax respite to the individuals who don't benefit house rent stipend. To get qualified for tax derivation under this section, an individual must dwell in a rented property. Besides, his/her manager ought not to give home rent recompense (HRA) as a component of the month to month pay.

Section 80GG allowance is material to qualified salaried and independently employed experts. Hence, if an individual works a business, he/she is similarly as fit for claiming this specific tax allowance as the salaried partners may be.

 

Tax payers to Eligible to Claim Tax Deductions under Section 80GG?

 

As expressed beforehand, one must meet certain essentials to benefit tax derivations under this particular section of the ITA. Recorded beneath are a portion of the components that an individual must satisfy to claim Section 80GG allowance.

 

I.          Only individuals and Hindu Undivided Family (HUF) are qualified to claim these tax allowances. Organizations or different undertakings can't benefit a similar tax limits after paying rent in a given monetary year.

 

II.        Individuals who are either salaried experts or independently employed can exploit this arrangement. In the event that one has no income to talk about, he/she is excluded from looking for Section 80GG income tax benefits, regardless of whether he/she pays the rent.

 

III.       Those looking to profit this tax refund need to present a properly filled Form 10BA to the public authority already. This Form is an affirmation that the individual recording it doesn't claim profit by a self-involved property in any area.

 

IV.       Section 80GG of Income Tax Act is explicitly intended for who don't get home rent remittance from their managers. On the off chance that an individual's compensation incorporates HRA installment, he/she is ineligible to claim income tax discounts identified with lodging rent.

 

V.        If the yearly rent sum surpasses Rs.1 lakh, the taxpayer should present a duplicate of the mortgage holder's PAN card to claim tax benefits under Section 80GG of Income Tax Act. Remember that this PAN card must have a place with the property proprietor where one lives on rent.

 

VI.       An individual must not have claimed HRA whenever during the financial year for which he/she is claiming the tax advantage under Section 80GG. This is a vital point for the individuals who have changed managers in the most recent year. Regardless of whether one didn't get HRA for a significant bit of the year, getting the equivalent for simply a month excludes his/her from claiming this yearly relief.

 

Individuals dwelling with their parents in a property possessed by their parents are likewise qualified to claim Section 80GG advantages. To do this, one would need to consent to a rental arrangement with his/her parents. Also, the sum appeared as rent will be taxable when the parents document their yearly taxes.

 

How are Deductions Under Section 80GG Calculated?

 

Tax derivations under this section depend on Tax Rule 2A. According to Section 10(13A), minimal sum from the accompanying counts is viewed as a non-taxable income.

 

         Rs.5000 every month or Rs.60000 per year.

 

         The yearly rent sum short 10% of the taxpayer's changed all out income.

 

         25% of the changed all out income for a year.

 

least from them is viewed as the Section 80GG allowance material. Allude to the accompanying table to learn two particular instances of tax derivations dependent on different income and rent installments –

 

 

Form 10BA: How to Do It Correctly?

 

The Form 10 BA is basic for anyone hoping to get Section 80GG tax benefits. Here are a portion of the subtleties that one must fill in Form 10BA before accommodation –

 

         Full address with postal code

 

         Name and PAN of the assessee

 

         Mode of installment

 

         Tenure of residency in months

 

         Rental sum

 

         Address and name of the property proprietor

 

         Declaration expressing that the assessee, his/her life partner or minor kid don't possess some other private property

 

         PAN number of the rented property's proprietor is required if the measure of rent surpasses Rs.1 lakh in some random monetary year.

 

Download Automated Income Tax Preparation Excel Based Software All in One for the Government & Non-Govt (Private) Employees for the F.Y.2020-21 and A.Y.2021-22

 Feature of this Excel Utility:-

 

1) This Excel utility prepares and calculate your income tax as per the New Section 115 BAC (New and Old Tax Regime)

 

2) This Excel Utility has an option where you can choose your option as New or Old Tax Regime

 

3) This Excel Utility has a unique Salary Structure for Government and Non-Government Employee’s Salary Structure.

 

4) Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2020-21 (Update Version)

 

5) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2020-21

 

6) Automated Income Tax Revised Form 16 Part B for the F.Y.2020-21

 

7) Individual Salary Sheet

Read More

DOWNLOAD INCOME TAX TDS ON SALARY AUTOMATED ALL IN ONE FOR NON-GOVT EMPLOYEES FOR F.Y. 2017-18

Download the Automatic Income Tax Preparation Excel Based Software for only Non-Govt employees for the Financial Year 2017-18.

Main Feature of this Excel Utility :-

• Automatic Tax Calculate Sheet after filling main data
• Automatic House Rent Exemption Calculation U/s 10(13A)
• Individual Salary Sheet
• Individual Salary Structure as per all Private Concerned Salary Pattern
• Automatic prepare Form 12BA
• Automatic Form 16 Part A&B for F.Y.2017-18
• Automatic Form 16 Part B for F.Y.2017-18
• Easy to install in any computer
• Most easy to Generate
• Prepare more than 100 employees Income Tax Preparation including all calculation by this one Excel Utility

Main Deduction Sheet 

Non-Govt Salary Structure

Automated Tax Computed Sheet

Form 12 BA

Form 16 Part A&B

Form 16 Part B

Click to Download the Automated All in One TDS on Salary for Private ( Non-Govt) Employees for Financial Year 2017-18 & Ass Year 2018-19 as per new Tax Slab

Read More

Download Automated Master of Form 16 Part B with Form 12 BA for the Financial Year 2017-18

For the person earning income from Salary , documents Form 16, and Form 12BA  are provided by an employer which has details about his salary, perquisites and tax deducted at source(TDS) by his employer.Looked into details of Form 16. Form 12BA give details of Perquisites given by the employer to the employee had looked into what are perquisites, what income tax laws apply to it, about the valuation of perquisites and the taxation with an example, which perquisites are exempted from tax, Difference between Perquisite, Allowance, and Fringe benefit. In this article, we shall see how Form 12BA shows the information about perquisites.

Form 12BA

Form 12BA is a statement showing particulars of perquisites, other fringe benefits or amenities, and profits in lieu of salary with value thereof. 

Form No. 12BA, if the amount of salary paid or payable to the employee is more than one lakh and fifty thousand rupees, which shall accompany the return of income of the employee. [Explanation : “Salary” for the purposes of this rule shall have the same meaning as given in rule 3.] 

 Note:The limit has changed to one lakh and eight thousand (1,80,000) by circular in 2011.

Download Automated Master of Form 16 Part B with Form 12 BA FY 2017-18 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B with 12 BA for Assessment  Year 2018-19]

Read More