Professional tax return xls utility - macro
This query is : Resolved
Rashmi Jagger
(Querist)
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
- Tax on Amount transferred in HUF Account
- Nursery business
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- Working on Gold wastage during Melting of old gold jewellery
- TDS on Dashcam rent and allied services
- Intimation under section 245
- Gift to nri relatives residing in usa
- GST input credit on commercial property
- Section 269ST applicability for capital introduced by partner to his partnership firm
- GSTR-9C filing
- Royalty payments to the Mining Department for procurement of murum - GST input
- HOW TO ADJUST CREDIT NOTE AMOUNT ?
- Import Order Cancelled.
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
