Showing posts with label Income Tax Form 12 BA in Excel Format. Show all posts
Showing posts with label Income Tax Form 12 BA in Excel Format. Show all posts

Thursday, 15 March 2018

Understanding Income Tax Form 12 BA with Automated Master of Form 16 Part B with Form 12 BA for Financial Year 2017-18

For a person earning income from Salary, documents Form 16, and Form 12 BA  are provided by an employer which has details about his salary, perquisites, and tax deducted at source(TDS) by his employer. These are used while calculating Tax liability. Tax on income we looked into details of Form 16. Form 12 BA give details of Perquisites given by the employer to employee. In Perquisites, we 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 Prerequisite, Allowance and Fringe benefit. In this article, we shall see how Form 12 BA shows the information about perquisites.

Form 12 BA

Form 12BA is the statement showing particulars of perquisites, other fringe benefits or amenities and profits in lieu of salary with value thereof. It comes under the Section 26A, subsection 2 point B.
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.

Please don’t confuse Form 12BA with Form 12B, the difference is more than just the one letter. Form 12B comes into picture when people change job in the middle of the Financial year. 
Details of previous employment to the new employer are provided by the employee in Form 12B.  Changing jobs often leads to a situation where an individual gets tax exemptions twice than what is due to him—from his earlier employer as well as from his new employer.  The income earned from the previous job has to be clubbed with the income from the new job to compute the total tax payable for the year. Changing Jobs: Take Care Of Bank Account, Tax Liability discusses it in detail.


According to section 192, it is the option/discretion of the employee whether or not to file Form No 12B. The current employer can’t insist on the filing of Form No 12B. If the employee chooses not to file, then employers’ obligation is limited to compute TDS on salary payable by him.

If Form 12B is filed, then the current employer can deduct the TDS on salary paid by the previous employer (in case no TDS was deducted by the previous employer). And if the TDS was deducted by the previous employer, any excess or shortfall can also be adjusted.

It is always in the interest of an employee to furnish such details because otherwise there can be the duplication of exemptions and deductions and there can be a shortfall in tax deduction and as a result, the employee would become liable to deposit advance tax.


Click to download Automated Master of Form 16 Part B with Form 12 BA for the FY 2017-18 [ This Excel Based Utility can prepare at a time 50 employees Form 16 Part B with 12 BA]




Tuesday, 10 October 2017

Income Tax preparation All in One Excel Based Software ( Prepare at a time Tax Compute sheet +Individual Salary Structure+ HRA Exemption +Form 16 Part B +Form 16 Part A&B) for only Non - Govt employees for F.Y 2017-18

The Central Finance Budget has already passed by the Parliament for the Financial Year 2017-18 and also some changes have made in this Finance Budge, The Section 87A will be continue and reduce Tax Rebate From Rs. 5,000/ to 2,500 and U/s 80 TTA (the Savings Bank Interest also entitled in this Financial Year 2017-18), K.V.P. has introduce , P.P.F. Limit has increase up to Rs. 1,50,000/- & Pension Fund U/S 80CC Max Rs.1.5 Lakh.

For below 60 years Age Salaried Persons can get the maximum Tax Relief up to Rs. 2,50,000/- and the Section 80C has also sane as to Rs. 1,50,000/-
The below given Excel based Software which can prepare at a time Income Tax Computed Sheet + Automatic House Rent Exemption calculation + In built Salary Structure for Non Govt employees which can prepared on the basis of Salary Pattern of each Non Govt concerned + Automated Form 16 Part A&B + Automated Form 16 Part B for the Financial Year 2017-18 and Assessment Year 2018-19.

Click here to Download the Automated All in One TDS on Salary for Non-Govt employees for the Financial Year 2017-18 and Assessment Year 2018-19 ( This Excel Based Utility Can prepare at a time Income Tax Calculation Sheet + Individual Salary Sheet + Automatic HRA Calculation + Form 16 Part A&B and Form 16 Part B + Form 12 BA Only for Non Govt employees)

It is most hazard to calculate individually HRA Calculation separately a another sheet. 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.

This Excel Based Software Can prepare more than 500 employees Tax Computed One by One.

Feature of this Utility:-

·                Automatic Calculate Income Tax with Tax Computed sheet individually

·                  Individual Salary Structure for calculating the Gross Salary Income 

·                 Salary Structure have prepare on the Basis of Non Govt Salary Pattern

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

·              Automated Form 16 Part A&B

·             Automated Form 16 Part B

·           Automatic Convert the Amount in to In Words

·        All the New Feature of Central Budget have in this Excel Utility and this utility prepare as per the New Central Budget 2017-18 with new Tax Slab.

Wednesday, 5 July 2017

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

Download Automated Master of Form 16 Part B with Form 12 BA FY 2016-17 [ This Excel Utility can prepare at a time 50 employees Form 16 Part B with 12 BA for Financial Year 2016-17]

For the person earning income from Salary, documents Form 16, and Form12BA  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.