Download All in One Automated Income Tax Calculator for Government and Non-Government

 Employees | Include a new section 115 BAC in the 2020 budget for the fiscal year 2022-23. This

 section 115BAC contains an option that allows you to continue the old tax regime with any income tax

 exemption as of the financial year 2021-22 and opt for the new tax regime apart from any income tax

 exemption as of the last fiscal year. Current. 2019-20 as clearly indicated in Budget 2020 U/s 115BAC.

According to the budget, a new U/s tax label has been specified under 115BAC which was introduced in the 2020 Budget.

 At the same time, it is also clear that according to Article 115BAC (New Tax Regime) there is no exemption for the elderly in the new tax plan.

Download Automated IncomeTax Preparation Excel-Based Software All in One for the Government andNon-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 Arrears Relief Calculator U/s 89(1) with Form 10E from the F.Y.2000-01 to F.Y.2021-22 (Updated Version)

 

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

 

5) Individual Salary Structure as per the Govt and 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 into the in-words without any Excel Formula

On December 13, 2022 by www.taxexcel.net

Share It

No Comments

Read More

  

Download and prepare at a time 100 Employees Form 16 Part B for the Financial Year 2022-23. This Excel Utility can prepare at a time 100 Employees Form 16 Part B in revised Format for the Financial Year 2022-23 and Assessment Year 2023-24

Download Automated Income Tax Form 16 Part B for the Financial Year .2022-23

Feature of this Excel Utility:-

1) This Excel Utility can prepare at a time 100 Employees Form 16 Part B as per the Budget 2022-23

2) This Utility can use by both Government and Non-Government Concerned

3) Automatically calculate your income tax as per New and Old Tax Regime

4) This Excel Utility has all the Income Tax Sections as per the Income Tax Act.

5) This Excel utility can use just like as an Excel File

6) This Excel Utility can be used by anyone it is most easy to use.

On December 12, 2022 by www.taxexcel.net

Share It

No Comments

Read More

 

 Download Automated Income Tax Preparation Software in Excel | Calculation of income tax for

 employees of a private company in 2022: The annual CTC of a person working in a private company

 consists of several components. These include LTA, HRA, pension fund contributions and tips,

 entertainment reimbursements, phone bills, transportation, books and periodicals, and more. While the

 names of CTC components may vary from company to company, the applicable tax rules remain the

 same. For proper tax planning, it is important to understand the tax implications of the various

 components of the CTC.

Here we look at how Tips, Reserve Fund, Rental Housing Allowance (HRA), LTA and Refunds are taxed.

 

Some components of wages are fully taxable and some are completely exempt. Some components are partially exempt from income tax.

 

Income Tax at HRA

HRA is an important part of the CTC, providing tax credits to workers who live in rented housing. The HRA is taxable if the employee does not live off the rent.

Subject to Section 10(13A), a minimum of the following may be exempt from tax:

 

(i) Actual amount received

 

(ii) 50% of salary if you reside in metropolitan areas (ie Mumbai, Delhi, Chennai and Kolkata) and 40% of salary otherwise.

 

(iii) Rent above 10% of wages

 

Income tax refund

Companies provide various subsidies for transportation, books and periodicals, entertainment, telephone and internet, etc.

Under section 10(14) of the Income Tax Law, subsidies given to employees are tax-deductible if such expenses are actually incurred.

The transport discount is released in the amount of the costs incurred.

Telephone/mobile and internet reimbursements are also exempt from regulation 3(7)(ix) of the Income Tax Law.

Reimbursement for books and periodicals may be claimed as an exemption under Section 10(14).

The entertainment allowance is fully taxable in the case of private employees. However, this may be claimed as an exemption if hospitality expenses are incurred for the company's business purposes.

To receive tax credits for reimbursement, employees must pay initial expense invoices.

Pension fund income tax

Contributions to the Reserve Fund are deductible under section 80C of the Income Tax Act.

Income tax on tips

Bonus earned while working is fully taxable. You can take advantage of the tip tax credit when you retire if your employer is covered by the Tips Act. Under section 10(10) of the Income Tax Law, at least the following persons are exempt:

one. Actual amount received

B. 20 thousand reais

h. 15 days' salary based on the last salary withheld for each full year of service or part of it exceeding 6 months

For the calculation of remuneration, salary means base salary + charity allowance.

If the employer is not subject to the Free Payments Act, at least one of the following exceptions:

one. Actual amount received

B. RJU CAN'T. 20 00 000

h. Half of the monthly salary for each full year of service. (i.e. ½ * average wage in the afternoon.

Income tax under LTA

The following conditions must be met in order to apply for a travel allowance tax exemption:

One. The actual trip is carried out by the taxpayer

B. Only domestic trips are counted

h. The exemption is granted to the employee alone or together with the family, including the employee's spouse, children, dependent parents, and siblings. However, the exemption does not apply to more than 2 children born after October 1, 1998.

Download Automated Income Tax Preparation Excel-Based Software All in One for the Government and Non-Government (Private) Employees for the Financial Year 2022-23 and Assessment Year 2023-24 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 2022

 

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

 

4) Individual Salary Structure as per the Private Concern’s Salary Pattern

 

5) Individual Salary Sheet

 

6) Individual Tax Computed Sheet

 

6) Automated Income Tax Revised Form 16 Part A&B for the F.Y.2022-23

 

7) Automated Income Tax Revised Form 16 Part B for the F.Y.2022-23

On November 26, 2022 by www.taxexcel.net

Share It

No Comments

Read More

  Arrears Salary Relief Calculator A.Y 2023-24 for claiming relief u/s 89(1) in Excel|A.Y 2023-24 (F.Y

 2022-23) Calculator of arrears of pay for claiming deduction under section 89(1) of the Income Tax

 Act 1961-Download

 

In accordance with Section 89(1) of the Income Tax Act, a reduction in income tax was granted in 1961 when an employee receives an overdue or prepaid salary during the financial year. UnderRule 21AA of the Income Tax Rules, 1962, Form 10-E is filed for claiming the deduction.

 

According to the Act, if the employee is a government employee or is an employee of a society, cooperative, local government, university, institution, or body association, to claim exemption, the employee can submit his Form 10E her his responsible employer of payment of compensation as provided in Article 192, first paragraph, of the Income Tax Act, 1961

 

In all other cases, the valuer requesting the exemption requests it on Form 10E from his tax advisor. Relief under Section 89, paragraph 1, is allowed in the assessment year in which the employee receives arrears or advances.

 

Especially in the public sector, pay revisions have become more common. Since independence, six pay committees have been formed by the government so far. The retroactive recommendations of the committee have all resulted in salary delays. The rationale behind granting this exemption under section 89 is that as a result of payment of arrears or advances received by him in a particular financial year, the income of the employee for that financial year increases due to the amount of arrears or advances . . . . As a result, the employee's income is taxed at a higher rate than the income would have been taxed if no such advances or expenses had been incurred.

 

The steps involved in calculating the Article 89(1) exemption are essentially as follows:

 

First, expand the amount of arrears or advances received to the specific relevant financial year and recalculate the income tax for each year if the arrears were incurred in the same relevant financial year.

 

Then calculate the income tax for each of the fiscal years irrespective of arrears or advances received.

 

Third - removal of total income tax arrived at the 2nd stage of stage-1.

 

Fourth, you calculate the income tax for the financial year incurred by the arrears, including arrears/advances.

 

Fifth: compute the income tax for the financial year in which the arrears were collected, less arrears/advances.

 

Income tax of the sixth deduction reached stage 5 of income tax reached stage-4

 

Sixth - deduction of income tax reached stage-3 of income tax reached stage-6

 

The amount so entered is the amount of the deduction under section 89 (1).

DownloadAutomated Income Tax Arrears Relief Calculator U/s 89(1) along with Form 10E from the Financial Year 2000-01 to Financial Year 2022-23 (Up-to-date Version)

On November 25, 2022 by www.taxexcel.net

Share It

No Comments

Read More

  Leave Travel Allowance [Sec. 10(5) AND RULE 2B] | LTA is compensation paid by an employer for

 an employee’s domestic travel while on family or personal holiday.

 

LTA waiver can be claimed when the employer grants LTA to the employees for leave to any place in India taken by the employee and their family.

 

Such deductions are limited to the amount of travel expenses actually incurred by the employee. Total holiday costs are not covered, only travel costs are covered.

 

 

Required to travel within India and overseas destinations are not included in this exemption.

 

For example, if the employer offers an MJA of Rs.25,000, but the employee spends only Rs 20,000 on travel expenses, the deduction is limited to Rs 20,000.

 

 

For the purposes of the exemption, ‘family’ is understood as spouse and children and parents, brothers and sisters who are wholly or substantially related to you.

 

The exemption does not apply to more than two children of a person born after October 1, 1998. In the case of a second birth after the birth of one child, this limitation also does not apply to this restriction.

 

 

The tax rules only provide an exemption for two trips in a block of four calendar years. This block is scheduled for the current calendar year 2018-21.

 

The exemption is allowed only if the person claiming the deduction is also traveling. If the family is traveling alone, deduction is not allowed.

 

 

Assignment of Unclaimed MJA: If an employee did not claim an MJA in the current last block or claimed it only once, it may request one more MJA in the next block of calendar years under the employee’s eligible allocation concession rules and request an MJA -reduction to 3 trips made in the current block of years. However, in order to avail of the transfer concession scheme, one LTA exemption must be applied in respect of travel in the first calendar year of the following block.

 

Travel to multiple destinations: If an employee travels to multiple destinations during the same leave, the deduction can be granted only for eligible travel expenses from the point of origin to the remote destination of the holiday by the shortest possible route.

 

 

Number removed:

Travel undertaken by Air - Economy Short-haul domestic carrier airfare or amount incurred, whichever is less, shall be exempt

 

 

Travel by Rail - First Class Train Travel by A.C. by a shortcut or the amount incurred, whichever is less, is not free.

 

 

Point of origin and destination Position of travel connected by rail, but traveled by other modes of transport - A.C. First class rail fare according to the shortest route or the cost incurred, whichever is less.

 

 

The origin and destination are not connected (partially/full) by rail, but are connected by another recognized public transport system - First class or luxury class fare depending on the route or shortest fare used, which is small.

 

 

Place of origin and destination not connected (partial/complete) by train or other recognized public transport system - AC first class rail fare by the shortest route (because the journey was made by train) or the actual cost, whichever is less.

Download Automated Income Tax Preparation Excel-Based Software All in One for the Government & Non-Government (Private) Employees for the F.Y.2022-23 and A.Y.2023-24

 

Feature of this Excel Utility:-

 

1) This Excel utility prepares and calculates 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 a New or Old Tax Regime

 

3) This Excel Utility has a unique Salary Structure for Government and Non-Government Employees 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.2022-23 (Update Version)

 

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

 

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

On November 23, 2022 by www.taxexcel.net

Share It

No Comments

Read More

  Where the tax payable by a person exceeds Rs 10,000 after deducting the original TDS it comes into

 play. Challan280 has been cleared by the IT department for early payment of taxes. It can be paid

 online using the link https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp and click on

 Challan no./ITNS 280 tab.

 

Download the Automated Income Tax Challan 280 in Excel 

Advance taxes are paid by those who have a source of income other than their salary. Individuals who earn from rentals, capital gains from shares, fixed income, lottery winnings, etc., can pay taxes early. Advance taxes are also known as ‘Pay as you earn schemes and can be paid online or through certain banks. Tax is payable if your taxable turnover exceeds Rs 10,000 in a single financial year. As per law, taxes must be paid in the same year the money is received.

Expiration date:

- 15% of the prepaid tax must be paid on or before June 15 of the financial year.

 

- 45% of the prepaid tax (minus prepaid taxes) is due on or before September 15th.

- 75% of prepaid taxes (less prepaid taxes) are due on or before December 15th.

- 100% of prepaid taxes (minus prepaid taxes) are due on or before March 15th.

In the case of taxpayers who opted for the presumptive tax scheme, 100% of the advance tax is due on or before March 15 of the financial year.

Download Automated Income Tax Arrears Relief Calculator U/s 89(1) with Form 10E for the Financial Year 2022-23

Where the tax payable by a person exceeds Rs 10,000 after deducting the original TDS it comes into play. If the advance tax is not paid within the due date, interest is chargeable to tax in accordance with the provisions of the IT Act.

 

How do you pay?

 

Challan 280 has been cleared by the IT department for early payment of taxes. It can be paid online using the link https://onlineservices. tin.egov-nsdl.com/etaxnew/tdsnontds.jsp and click on Challan tab no./ITNS 280. Next, select the “advance tax” option and pay through net banking or debit card. After the payment, the tax receipt is displayed on the screen. Download and save it with you for future reference.

 

Who should pay taxes early?

The eligibility criteria for paying taxes early are:

• Your tax credit must be Rs 10,000 and above.

• Income generated through capital gains on shares.

• Interest earned on deposits.

• A victory gained from a lottery.

• Rent or income received on household goods

Download Automated Income Tax Preparation Software in Excel for the Non-Government Employees for the Financial Year 2022-23

On November 21, 2022 by www.taxexcel.net

Share It

No Comments

Read More

  Section 80DDB | Who can claim deductions under Section 80DDB?

 

Section 80DDB is Income Tax Rules 11DD. Under the Income Tax Act, of 1961, taxpayers can claim deductions for certain specified benefits for themselves or their dependents. This type of exemption is covered under Chapter VIA of the Income Tax Act, 1961. Individuals and HUFs who are residents of India can claim an exemption under this section. In other words, this means that a tax deduction can be claimed, if the relevant entity resided in the country during that tax year and the medical-related expenses are incurred for themselves or a family member, such as a spouse, parent, or dependent brother or sister.

 

How many deductions can be claimed under section80DDB?

 

Deductions corresponding to the following amounts can be claimed under section 80DDB:

For the financial year 2021-22 (the review year 2022-23)

• A person is eligible for a tax of Rupees 40,000/-(Forty Thousand) or the amount actually paid, whichever is less.

• Senior citizens, above 60 years of age, are eligible for a tax deduction of Rupees 60,000/-(Sixty Thousand) or the amount actually paid, whichever is less.

From the fiscal year 2022-23 (the tax year 2023-24)

 

• A Person is eligible for a tax of Rupees 40,000/-(Forty Thousand) or the actual medical expenses, whichever is less.

• Senior citizens between 60 and 80 years of age can claim tax exemption of Rupees 60,000/-(Sixty Thousand) or the actual amount spent on health care, whichever is less.

 

• Super seniors, above 80 years of age, are eligible for tax exemption of Rupees 80,000/-(Eighty Thousand) or the actual medical expenses, whichever is less.

From the financial year 2018-19 (The assessment year 2019-20)

 

• A Person is eligible for a tax of Rupees 40,000/-(Forty Thousand) or the amount actually paid, whichever is less.

• Senior citizens, above 60 years of age, are eligible for a tax deduction of Rupees 100,000/-(One Lakh) or the amount actually paid, whichever is less.

 

Diseases or medical conditions specified in section 80DDB

 

According to the Income Tax Department, the following diseases or circumstances may require tax exemption under Section 80DDB:

 

(1) Neurological disease, whose disability level is 40% and greater -.

• Dementia

• Dystonia Musculorum Deforms

• Aphasia

• Motor neuron diseases

• Ataxia

• chorée

• Hemiballism

• Parkinson’s disease

(2) Malignant cancers

(3) Entirely acquired immunodeficiency syndrome (AIDS).

(4) Chronic renal failure

(5) Hematologic disorders

Haemophilia

Thalassemia of the body

 

Papers are required for claiming deductions under Section 80DDB

 

To claim deductions under section 80DDB of the Income Tax Act, 1961, the assessee has to furnish evidence that medical treatment has actually been provided. It is mandatory to obtain a certificate from the prescribed authority, who has benefited from the medical treatment if a person wants to claim a deduction under this section.

Download Automated Income Tax Preparation Excel-Based Software All in One for the Government & Non-Government (Private) Employees for the F.Y.2022-23 and A.Y.2023-24

 

Feature of this Excel Utility:-

 

1) This Excel utility prepares and calculates 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 a New or Old Tax Regime

 

3) This Excel Utility has a unique Salary Structure for Government and Non-Government Employees 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.2022-23 (Update Version)

 

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

 

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

On November 18, 2022 by www.taxexcel.net

Share It

No Comments

Read More