Form 16 is a certificate that consists of details of TDS (Tax Deducted at Source), other incomes, tax benefits, and tax calculations under section 203 of the income tax act 1961. Based on the data available in form 16 salaried employees can easily file their ITR (income tax returns).
Form 16 is also known as the income tax calculator and it consists of Two parts part A and part B. Form 16 will be issued once a year by the employer to the salaried employees.
Form 16 PDF Download
Difference between form 16 A and form 16B
Form 16 consists of two parts, they are part A and part B. The basic difference between part A and part B of form 16 is, part A consists of general information of employee and employer like their address, PAN & TAN details, etc.., whereas part B consists of salary and TDS details of the employee.
Income Tax Form in Excel 2025-26વર્ષ : 2025-2026 માટે ઈન્કમટેક્ષ ગણતરી ફાઇલ
💥 નાણાકીય વર્ષ 2025-'26 માટે જાત આકારણી પત્રક અને ફોર્મ 16 એક જ ફાઈલમાં ઉપલબ્ધ.
💥 ફાઈલમાં જરૂરી સુધારા હતા તે મુજબ ફાઈલ અપડેટ કરેલ છે. નાણાકીય વર્ષ 2025-'26 માટે જાત આકારણી પત્રક અને ફોર્મ 16 એક જ ફાઈલમાં ઉપલબ્ધ.
👉🏼 આ ફાઈલમાં આપ જુના અને નવા બંને રીઝીમ પ્રમાણે Tax ગણતરી જોઈ શકશો. ફાઈલમાં રહેલી વિગતોનો અભ્યાસ કરી જરૂરી વિગતો ભરવી.
👉🏼 ફાઈલની વિશેષતા એ છે કે આપને SAS પોર્ટલ મુજબ નું ગુજરાતી ફોર્મેટમાં જાત આકારણી પત્રક મળી રહેશે તથા તે સિવાય અંગ્રેજી ફોર્મેટમાં પણ આપ જાત આકારણી પત્રક પ્રિન્ટ કરી શકશો.
👉🏼 ફાઈલ મોબાઇલમાં બિલકુલ ઓપન કરવી નહીં અને મોબાઇલમાં એડિટ કરવા પ્રયત્ન કરવો નહીં જો ફાઇલ ક્રેક થશે તો પરિણામ સાચું ન પણ મળે.
👉🏼 ફાઈલનો ઉપયોગ કરતા જે જગ્યાએ ખ્યાલ ન આવે ત્યાં પહેલા ફાઇલનો અભ્યાસ કરી લેશો પછી નજીકના જાણકાર વ્યક્તિને પૂછી લેશો. ફોન કરવામાં બિલકુલ ઉતાવળ કરવી નહીં, મેસેજ કરી શકો છો સમય કાઢી જવાબ અવશ્ય આપીશ.
👉🏼 આ ફાઈલમાં આપ જુના અને નવા બંને રીઝીમ પ્રમાણે Tax ગણતરી જોઈ શકશો.ફાઈલમાં રહેલી વિગતોનો અભ્યાસ કરી જરૂરી વિગતો ભરવી.
મહત્વપૂર્ણ લિંક્સ
Income Tax Form in Excel 2025-26
◆◆ મહત્વપૂર્ણ લિંક (કમ્પ્યુટરમાં ઓપન કરવી) ◆◆.
👉 પગારદાર કર્મચારીઓ માટે ઇન્કમ ટેક્ષ બાબત 2025-26
🔥 ખૂબ જ ઉપયોગી માહિતી જાણો
● કોને કેટલો ઇન્કમટેક્ષ ભરવો તેની સંપૂર્ણ સમજ
👉 ઇન્કમટેક્સની સમજ માટે PDF ફાઈલ ડાઉનલોડ કરવા અહીં ક્લિક કરો
👉 ઈન્કમટેકસ બાબતે સળંગ નોકરી ગણતા જે કર્મચારીઓને પુરવણી બીલ મળ્યું છે તે કર્મચારીઓ એ 10E પત્રક ભરવું..પત્રક કેવી રીતે ભરવું એની સરળ સમજ આપતો વિડિયો જોવા માટે - CLICK HERE
👉 10E PATRAK EXCEL SEET DOWNLOAD કરવા માટે - CLICK HERE
Part A of form 16 consist of the following details
TDS Certificate number
Date up to which form 16 is updated
Name and address of employee and employer
PAN & TAN of the employer
PAN of the employee
Period of employment with the employer.
Assessment year for which TDS deducted.
Summary of TDS paid or credited quarterly
Part B of Form 16 consist following details
Gross salary of employee and allowances like house rent allowances, leave travel allowances, leave encashment and gratuity, etc..
Deductions under entertainment allowances and tax on employment.
Exemptions under section 80C, 80 CCC and 80 CCD such as investments in a provident fund such as EPF and PPF, payment towards life insurance premiums, equity-linked savings scheme (ELSS), payment towards home loan, payments towards Sukanya Samridhi Yojana scheme, National Savings Scheme, and Senior Citizens Savings Scheme. The maximum limit to get exemption under these sections is 1,50,000 Rs.
Other deductions under section 80D (health insurance premium for self, family, and parents), 80E (payment towards education loan), section 80G (donations to relief funds and charitable trusts)
Total taxable income
Tax on total income.
2% education cess, 1% higher education cess, and 1% health cess.
Relief under section 89 when the employee gets a salary in the form of arrears or advance.
Finally tax payable amount.
Changes in income tax rules for ay 2020-21
A rebate under section 87A has been increased to 12,500 Rs from 2500 Rs.
Standard deduction has increased to 50000 Rs, earlier it was 40000 Rs.
The limit of interest income for TDS has increased to 40000 Rs, earlier it was 10000 Rs.
The limit of rental income for TDS has increased to 2.4 Lakhs, earlier it was 1.8 Lakhs.
New Income Tax Slab Rates in India (Fy 2020-21)
Annual Income Tax Rate
Upto 2,50,000 Nil
2.50 Lakhs to 5 Lakhs 5%
5 lakhs – 7.5 Lakhs 10%
7.5 lakhs – 10 Lakhs 15%
10 Lakhs – 12.5 Lakhs 20%
12.5 Lakhs – 15 Lakhs 25%
Above 15 Lakhs 30%
Existing Income Tax Slab Rates In India for Fy 2020-21
Citizens Below 60 yrs Citizens Above 60 Yrs Citizens Above 80 Yrs
Annual Income Tax Rate Annual Income Tax Rate Annual Income Tax Rate
Upto 2.50 Lakhs Nil Upto 3 Lakhs Nil Upto 5 Lakhs Nil
2.50 Lakhs – 5 Lakhs 5% 3 Lakhs – 5 Lakhs 5% 5 Lakhs – 10 Lakhs 20%
5 Lakhs – 10 Lakhs 20% 5 Lakhs – 10 Lakhs 20% Above 10 Lakhs 30%
Above 10 Lakhs 30% Above 10 Lakhs 30%
How to Manually Fill Form 16 with Example
If you want to manually calculate how much tax you are liable to pay then use the above form 16 excel format for ay 2020-21 and enter your details as shown in the below images.
Sample Part A of Form 16 in Excel Format for Ay 2020-21
Form 16 part A excel format for ay 2020-21
Sample Part B of Form 16 in Excel Format for Ay 2020-21
Form 16 in excel format for ay 2019-20 free download
If you are still finding difficulties in calculating your net income tax amount then you can calculate it easily online at the income tax department web site of India. To calculate your income tax you need to select the assessment year, category of taxpayer, net taxable income, income tax after relief u/s 87A, surcharge, health, and education cess…
income tax calculation online
Calculate your income tax online
Form 16 Related Information
What is Form 16 Eligibility Salary
The eligibility salary limit to get form 16 is 2,50,000 Rs. If your annual income is 2,50,000 or above then you will fall in the income tax slab limit. In that case, you need to submit an investment declaration form to your employer.
Based on the details furnished on investment declaration form your employer will generate your form 16 after making TDS payment.
What is Investment declaration form
The investment declaration form is a declaration by the employee, based on the information provided on investment declaration form employers will calculate how much TDS should be deducted from the employee salary.
About TDS on salary
TDS is a part of income tax, and the full form of TDS is Tax Deduction at Source. TDS will be deducted on salary and interest on bank deposits etc.
TDS will be paid by the employer on behalf of employees. Based on the estimated earnings of a person the TDS will be calculated and the same amount will be paid to govt periodically i.e if the employer is paying salary every month then TDS will be deducted every month. ( If an employee falls under income tax slab limit).
Based on the amount paid towards TDS the employees can adjust their net income tax payable for every financial year.
If anyone pays excess TDS then the excess amount will be refunded to that person after filing IT returns.
How to get Form 16
What is Form 16 password
After downloading form 16, you need to enter a password to open it. The password to open form 16 is your 10 digits PAN followed by your date of birth. For example, if your PAN number is BUOPM1234X and date of birth is 24/05/1985 then the password is BUOPM1234X24051985
Last date to issue form 16
The last date to issue form 16 to employees by employers is 31st May of every year. By this date, every employer has to issue form 16 to employees from whom they are deducting TDS.
If TDS is not deducting from employee salary then there is no need to issue form 16.
Employer is not giving form 16
It is the right of the employee to get form 16 when he contributing to TDS. If your employer is not issuing form 16 then under section 272A(2)(g) of income tax they need to pay a penalty of 100 Rs till the date of issue.
Form 16 Uses
To file ITR: Form 16 is required to file IT returns and it acts a proof that you paid TDS.
Form 16 acts as a proof of income, and it is required to get loans.
Due date to file income tax returns for Ay 2020-21 (Fy 2025-26)
The actual due date to file IT returns for the financial year 2025-2026 (ay 2025-26) is 31 st July 2026, but due to lockdown in India, the due date is extended to 30 November 2020.
CategoriesDownloads, Income Tax
TagsFor 16 in Excel, Form 16 in Excel Format for AY 2025-26
Post navigation
What is Attestation through Previous Employer Means
Aadhaar Authentication Failed. Aadhaar Number, Name, DOB or Gender Mismatch with Registered Data.
17 thoughts on “Form 16 Excel Format for Ay 2025-26 (Fy 2025-26) Free Download”
અરજી ફોર્મ ભરતી વખતે ધ્યાનમાં રાખવાની સૂચનાનો Video
