Download Automated Income Tax Preparation Software in Excel. for the Non-Government (Private) Employees for the F.Y.2022-23

 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 IncomeTax Preparation Excel-Based Software All in One for the Government andNon-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

Read More

Income Tax Section 16 - Standard Deduction, Entertainment Allowance With Automated Income Tax Preparation Excel Based Software All in One for the Non-Govt Employees for the F.Y.2022-23

 Income Tax Section 16 of the Income Tax Act 1961 provides for a deduction from taxable income

 under the wage line. Provides deductions for the standard deduction, entertainment allowance, and

 labour tax. With this deduction, the taxpayer can reduce the taxable wage income that is subject to tax.

 

Also, with the recent changes to the flat-rate deduction, the benefit under this section extends to a larger amount. Plus, there's no problem providing travel and medical expenses, which makes it pretty straightforward.

 

In this article, we will look at each of the deductions in Section 16 along with the illustrations of the calculation.

You may also like- Automated Income Tax Form 16 Part B for the Financial Year 2021-22[This Excel Utility can prepare at a time 50 Employees Form 16 Part B]

Standard pay deduction under section 16 (ia)

 

A standard deduction is allowed under section 16ia of the Income Tax Act. The standard deduction replaced the transportation allowance of Rs 19,200 and the medical reimbursement of Rs 15,000. The 2018 budget, it was introduced by our finance minister, Jaitley.

 

The 2018 budget includes a standard deduction of Rs 40,000 in lieu of travel and medical expenses. This deduction of Rs 40,000 does not require the taxpayer to submit invoices or proof of expense. It provides for a fixed deduction of Rs 40,000.

 

Subsequently, in the provisional budget for 2019, the deduction was increased from Rs 40,000 to Rs 50,000. Therefore, the deduction for the 2018-2019 financial year was Rs 40,000 and from the 2019-20 financial year, the deduction will be Rs 50,000.

 

The ordinary deduction is also available for retirees. The CDTC has issued a clarification clarifying the applicability of the standard deduction to retirees. The pension received by the taxpayer from his former employer will be taxed under "salary". Since the pension received is taxed in the payroll section, the deduction will also be available to retirees under section 16.

You may also like- Automated Income Tax Form 16 Part A&B for the Financial Year 2021-22[This Excel Utility can prepare at a time 50 Employees Form 16 Part A&B]

 

The maximum deduction will be available U/s 16 for the standard deduction is:

Salary received

OR

50000 rupees

Whatever it is below

Remember that the standard deduction has nothing to do with u / s 80C deduction or any other section of the EIA chapter.

 

Illustration for the calculation of the standard deduction

Entertainment allowance under Section 16 (ii)

Entertainment allowance is first included in wage income and then deducted according to various criteria. The allowance must be an allowance specifically granted by the employer to the taxpayer as an entertainment allowance.

Entertainment allowance for government employees

 

For central and state government employees, the available deduction is the lower of the following:

 

20% of the basic salary

5000 rupees

Amount provided as an entertainment allowance in the fiscal year

You may also like- Automated Income Tax Form 16 Part B for the Financial Year 2021-22[This Excel Utility can prepare at a time 100 Employees Form 16 Part B]

 

To determine the amount of the allowance, the taxpayer must ensure that the following conditions are met:

 

The salary must not include any other allowances, employer benefits, or privileges received. Basically, the salary should be the gross amount received with no other benefits.

 

Never include the actual amount spent in the entertainment allowance received by the employer.

 

Entertainment allowance for a non-state employee

The entertainment allowance deduction is not available for non-state employees. Only central or state government employees are eligible for the deduction. Furthermore, employees of local and public bodies are not entitled to the deduction.

You may also like- Automated Income Tax Form 16 Part A&B for the Financial Year 2021-22[This Excel Utility can prepare at a time 100 Employees Form 16 Part A&B]

 

Employee tax under Section 16 (iii)

An employee's tax deduction is allowed under section 16iii of the Income Tax Act. The amount paid by the taxpayer for the labour tax or the professional tax is allowed as a deduction pursuant to article 16. Here, the labour tax is provided for by section 276, paragraph 2, of the Constitution.

 

When calculating professional tax deductions, the following points should be taken into account:

The taxpayer must request the deduction only in the fiscal year in which the professional tax is actually paid to the State.

 

Tax paid by the employer on behalf of an employee is also deductible. In this case, the amount paid by the employer as labour tax will first be included as a mandatory condition in the total salary. Thereafter, an equal amount will be allowed as a deduction under section 16.

 

 Under Section 16 of the Income Tax Act, there is no upper or lower deduction limit. The deduction depends exclusively on the actual amount of the business tax. However, the government of any state cannot charge more than 2,500 rupees per year as a business tax. Only tax paid is deductible, not interest or penalties for late or non-payment of labour tax.

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

 

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 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.2022-23

 

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

 

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

Read More