Professional tax return xls utility - macro
This query is : Resolved
02 September 2024
hello
have downloaded the xls Macro for PTRC return for FY 2023-24.
it is asking for TIN and TAN of employer. is it mandatory field?
The field for Employer name is not editable. how can we enable this?
thereafter, am not able to validate the file, the validate button is inactiv.
is it due to not filing of employer name?
please guide how to correct the macros and enable these buttons/ fileds
have downloaded the xls Macro for PTRC return for FY 2023-24.
it is asking for TIN and TAN of employer. is it mandatory field?
The field for Employer name is not editable. how can we enable this?
thereafter, am not able to validate the file, the validate button is inactiv.
is it due to not filing of employer name?
please guide how to correct the macros and enable these buttons/ fileds
12 August 2025
1. TIN and TAN Fields:
TIN (Taxpayer Identification Number) and TAN (Tax Deduction Account Number) are mandatory fields for PTRC filing as they identify the employer in the return.
Without entering valid TIN and TAN, the utility may not allow validation or submission.
2. Employer Name Field Not Editable:
Usually, the Employer Name field is auto-populated based on the TIN or TAN entered.
It is designed to be non-editable to avoid manual errors.
If it’s blank or not auto-filled, it may be due to:
Incorrect or invalid TIN/TAN entered
Macro settings or the data link not functioning properly
3. Validate Button Disabled:
The Validate button activates only when all mandatory fields (including TIN, TAN, and Employer Name) are correctly filled.
If Employer Name is blank (because TIN/TAN are wrong or missing), validation will be disabled.
Also, if macros are disabled in your Excel settings, buttons won’t work.
4. How to Fix / Enable Fields and Buttons:
Ensure Macros are Enabled:
Go to Excel Options > Trust Center > Trust Center Settings > Macro Settings → Enable all macros or enable with notification.
Correctly Enter TIN and TAN:
Use valid, registered TIN and TAN as per your state and employer details.
Check Data Source / Lookup:
Some utilities fetch Employer Name from an internal lookup sheet based on TIN/TAN.
Ensure lookup tables are intact and not corrupted.
Don’t delete or hide any sheets or cells.
Try Re-downloading the Utility:
Sometimes, utilities get corrupted. Download the latest official PTRC utility from the state government’s website again.
Avoid Manual Editing of Locked Fields:
Employer Name is usually locked for editing. Trying to unlock may corrupt the file.
TIN (Taxpayer Identification Number) and TAN (Tax Deduction Account Number) are mandatory fields for PTRC filing as they identify the employer in the return.
Without entering valid TIN and TAN, the utility may not allow validation or submission.
2. Employer Name Field Not Editable:
Usually, the Employer Name field is auto-populated based on the TIN or TAN entered.
It is designed to be non-editable to avoid manual errors.
If it’s blank or not auto-filled, it may be due to:
Incorrect or invalid TIN/TAN entered
Macro settings or the data link not functioning properly
3. Validate Button Disabled:
The Validate button activates only when all mandatory fields (including TIN, TAN, and Employer Name) are correctly filled.
If Employer Name is blank (because TIN/TAN are wrong or missing), validation will be disabled.
Also, if macros are disabled in your Excel settings, buttons won’t work.
4. How to Fix / Enable Fields and Buttons:
Ensure Macros are Enabled:
Go to Excel Options > Trust Center > Trust Center Settings > Macro Settings → Enable all macros or enable with notification.
Correctly Enter TIN and TAN:
Use valid, registered TIN and TAN as per your state and employer details.
Check Data Source / Lookup:
Some utilities fetch Employer Name from an internal lookup sheet based on TIN/TAN.
Ensure lookup tables are intact and not corrupted.
Don’t delete or hide any sheets or cells.
Try Re-downloading the Utility:
Sometimes, utilities get corrupted. Download the latest official PTRC utility from the state government’s website again.
Avoid Manual Editing of Locked Fields:
Employer Name is usually locked for editing. Trying to unlock may corrupt the file.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GSTR-1A How to update Invoice
- Excess salary payment.
- Capital gain from sale of house property
- Stamp Paper for partnership firm change new income tax 2025
- TDS on Purchase of Immovable Property by NRI from NRI
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- Value of property in capital gain
- Annual return in Gst
- When TDS on GST applied
- Before GSTAT- APL-02 Vs APL-04
- TDS APPLICABILITY......
- Copyright software
- Cash gift by grand mother to her grand daughter
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
