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
- House Property Reporting in ITR
- Refund Annexure-B
- TDS Claim year
- Liable to deduct tds and 44ADA
- Refund of 20%pre-deposit paid for stay application
- Rent lease agreement
- TDS Challan Code
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- Subscription paid to foreign customer
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- 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
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
