Bulk PAN Verification

TDS || Bulk Pan Verification Process

How to check the PAN number of the Deductee / Employee online

To Verify the PAN Number on Single Page, You need to first Create the Deductee / Employee Master (Master > Deductee Master / Employee Master).

            

Process 1:

To check the PAN number of the Deductee/Employee, please go to Master > Deductee Master/Employee Master option.

See at the bottom of the Deductee Master screen, Deductee Detail tab is given click on Arrow button and you will find PAN Verification option.

            

Select the PAN which you wish to validate and click on Add to Validation button. It will redirect to Bulk Pan Verification Page.
Click on Validate Button.

This will direct you to TRACES website and enter the User Name and Password, you can verify the selected PAN.

            

Once Validated Message shown as below.

            

After this once you click on OK Button, Data will Bifurcates in 2 Parts - Match and Unmatch

Match - Data shown for PAN - Active Cases with Same name on Department website and Invalid Status of PAN.
Unmatch - Data Shown for  PAN - Active Cases But Name on Website is Different.

In Matched cases, Simply Click on Update PAN Status Button to update the pan status in software database (Deductee Master or Employee Master).

            

In Unmatched Cases, First Click on Update Name and then Update PAN Status Button to update the pan status in software database (Deductee Master or Employee Master).

            

PAN Status is shown in your Master now.

            


Process 2:

To check the PAN number of the Deductee/Employee, please go to Tools > Bulk PAN Verification option.

            

Here, Select Employee Master or Deductee Master and then click on Validate Button.

            

This will direct you to TRACES website and enter the User Name and Password, you can verify the selected PAN.

            

Once Validated Message shown as below.

            

After this once you click on OK Button, Data will Bifurcates in 2 Parts - Match and Unmatch

Match - Data shown for PAN - Active Cases with Same name on Department website and Invalid Status of PAN.
Unmatch - Data Shown for  PAN - Active Cases But Name on Website is Different.

In Matched cases, Simply Click on Update PAN Status Button to update the pan status in software database (Deductee Master or Employee Master).

            

In Unmatched Cases, First Click on Update Name and then Update PAN Status Button to update the pan status in software database (Deductee Master or Employee Master).

            

PAN Status is shown in your Master now.

            


BULK PAN VERIFICATION : Through EXCEL File


For Bulk Pan Verification Through Excel file, First Export the Blank Template for PAN Verification.

Template Location : Tools >> Microsoft Excel Sheet >> Bulk PAN Verification

            

Export this sheet to your required Location, Fill Data in this template.
Then Go to Tools > Bulk PAN Verification option.

Now, First click on Excel Import Option in Upper Side. Then Same Button Highlighted in Down Side - Just Click on Excel Import Button.

            

Excel Details Getting reflected in front of you, Simply click on Validate Button.

            

This will direct you to TRACES website and enter the User Name and Password, you can verify the selected PAN.

            

Its shown the Result and Data will Bifurcates in 2 Parts - Match and Unmatch

In Matched and Unmatch data, You have to export the excel sheet with Result of PAN Status, through Excel Export Button.

            

Both Data shown in Excel like this - Matched Pan and Unmatched PAN.

            

Hope this helps.

    • Related Articles

    • Bulk PAN Verification in Express TDS?

      Login on https://www.expresstds.com/app/login Website. Select Company. Select the Return and Click - Work on this.              In Quick Links - Click on Bulk PAN Verification of all Deductees.              Enter Captcha Code.              Message ...

    • TDS Correction Excel Import "Error converting data type varchar to numeric"

      TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric Possible Resolution To solve this excel import issue, here are some suggestions are given below.  1. In the Excel template, it is to be checked that the ...

    • Express TDS- Correction process for TDS return

      Express TDS- Correction process for TDS return Process for offline correction for 24Q, 26Q, 27Q & 27EQ from TDS software >> The Correction from TDS software can be processed once you have the Consolidate file (.tds File). Select Respective Deductor , ...

    • Process for Form 16A Request e-TDS Software

      Process for Form 16A Request  e-TDS Software Form 16A is the certificate of deduction of tax at source and issued on deduction of tax by the Deductor. These certificates provide details of TDS / TCS for various transactions between deductor and ...

    • Process to generate TDS Return (Salary / Non Salary / Non Resident / TCS)

      TDS stands for tax deducted at source. As per the Income Tax Act, any company or person making a payment is required to deduct tax at source if the payment exceeds certain threshold limits. TDS has to be deducted at the rates prescribed by the tax ...