Data Entry
MACRO Enabled Process
How to enable macros for individual workbooks There are two ways to turn on macros for a certain file: directly from the workbook and through the Backstage view. Enable macros via security warning bar With the default macro settings, when you first ...
Process To Download CSI from IT
Process To Download CSI from ITD (Income Tax Department Portal) After the introduction of e-pay Tax option on New Income Tax portal, Taxpayer can deposit the Challans related to TDS/TCS in this option. The challans deposited through e-pay tax option ...
EXCEL EXPORT / IMPORT || Error in Loading DLL in excel export / Automation error - Library not registered
Error in Loading DLL in excel export / Automation error - Library not registered in Excel export Solution : NOTE : This is not Software Related issue. Usually error in loading dll Excel arise when due to the installation of any software the new DLL ...
TDS/TCS FVU Validation error - Invalid value in the field Deductee/Part records or value not as per file format
TDS/TCS FVU Validation error - Invalid value in the field Deductee/Part records or value not as per file format Possible Solution Usually this error comes when importing data from excel template and 'section code' and 'challan serial. no' is not ...
SQL SERVER Installation issue || There are validation errors on this page.
There are validation errors on this page. Click OK to close this dialog box. Review errors at the bottom Setup page, then provide valid parameters or click Help for more information. Cause : Issue occur due to files and folder are ...
TDS || 80CCD(2) Figure not coming in excel Import
Clint entered the 80CCD(2) amount in - 'Deduction U/s 80CCD(2)' column in 24Q Excel sheet and when he imports the same Amount is not coming in Salary Details Under 80CCD(2) Deduction. Section 80CCD (2) allows salaried individuals to ...
One TDS challan for Payment Under Different sections & Years
One TDS challan for Payment Under Different sections & Years Advisory to deductors making TDS payment through multiple challans in a month As we all are aware that, many times deductors used to pay TDS through multiple challans because of different ...
Interest Calculation - If challan paid via book entry
Interest Calculation - If challan paid via book-entry TDS Payment Due Date - If paid via book-entry- the same day on which TDS is deducted, When a part or whole amount of TDS is not paid then 1.5% per month interest is subject to TDS/TCS amount ...
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 ...
How to Verify Multiple challan through CSI File?
To Verify Multiple challan through CSI file, First you need to Download CSI file. How to DOWNLOAD CSI FILE ? To Download CSI File, Follow the Steps Below. Open TDS Software > Quarterly Return > e-Form (24Q / 26Q / 27Q / 27EQ) Here, Click ...
TDS Validation error - Invalid value provided under 'Count of PAN of the Landlord'
TDS Validation error - Invalid value provided under 'Count of PAN of the Landlord' Landlord’s PAN not needed to claim HRA if annual rent is below Rs 1 lakh and f rent paid exceeds Rs.1 lakh per annum, it is mandatory for the employee to report PAN of ...
How to check the connectivity of TDS database from LAN through Administrative tool ?
KDK Software products are Multi-user software products that can be used in the Network area. There might be few situations arising due to some network failure or configurations, where some software modules would respond properly and some would not. ...
Error In Spectrum - SQLServerManager10.msc >> "Cannot connect to WMI provider. You do not have permission or the server is unreachable."
If you receive the error "Cannot connect to WMI provider. You do not have permission or the server is unreachable." when attempting to launch the SQL Configuration Manager : SQL Server Configuration Manager use Window Management ...
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 ...
TDS & TCS Payment Deposit Due Dates for Govt & Non Government Deductor
TDS & TCS Payment Deposit Due Dates for Govt & Non Government Deductor The due date for depositing TCS is the 7th of next month Due dates for depositing TDS as under :- 1. For non - government Deductors - 7th of next month (except for the month of ...
TDS/TCS Return validation error regarding remark 'C' (higher deduction)
TDS/TCS Return validation error regarding remark 'C' (higher deduction) Solution As per NSDL guide line In case of deduction of tax at higher rate due to non-availability of PAN. TDS deducted amount in deductee details should not be less than 20% ...
TDS Validation error - Number of pan valid in batch cannot be less than 85 % of total deductee in batch
TDS Validation error - Number of pan valid in batch cannot be less than 85 % of total deductee in batch Solution As per nsdl guide line in a statement 85% of the deductee should have valid pan, If there are 100 deductee (transaction) in a ...
Section 194J – Fees for professional or technical services
Section 194J – Fees for professional or technical services New section codes 194J (a) and 194J (b) are added in Form 26Q, Same should be applicable for statements pertains to FY 2020-21 onwards 194J (A). The existing section code 194J (i.e. Fees ...
How to fill other exemption under section 10 details in salary detail
How to fill other allowances details in salary detail Form 16 Part (B)- (F) Amount of any other exemption under section 10 Open the e-TDS software, Go to Deductee entry → Salary detail → Tax Deducted u/s 192 Select the employee from the list > Now ...
TDS - Tax Calculation for Senior Citizens (Assessment Year 2021-22)
TDS - Tax Calculation for Senior Citizens Tax slab 2021-22 (Old tax regime slabs) (who is 60 years or more at any time during the previous year) Net Income Range Rate of Income-tax Assessment Year 2021-22 Assessment Year 2020-21 Up to Rs. 3,00,000 - ...
How to Add New BSR Code in TDS Software?
BSR Code, short form of Basic Statistical Return Code, is a seven-digit code provided to all the registered Indian banks by the RBI. While the first three digits identify the bank, the following four digits identifies the bank branch. Process to add ...
How to update TDS Software manually
Solution: In Case of Client is using Spectrum software and wants to update the Zen TDS only : To resolve the error please follow the steps provided below: 1. Go to Root location of the software - "C:\Program Files (x86)\K.D.K. Software\KDK Support" ...
Excel import - Tax Rate should be numeric
Excel import - Tax Rate should be numeric Solution This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...
Prerequisites for Leave Encashment in Excel format
Prerequisites for Leave Encashment in Excel format To export the Template Go into → Tools →Microsoft Excel Sheet → Form 24Q (Salary) Here the option is given in the Salary Detail sheet to enter the Leave Encashment Here put "Gross amount" and ...
TDS- Deductions under Section 80U
TDS- Deductions under Section 80U In computing the total income of an individual, being a resident, who, at any time during the previous year, is certified by the medical authority to be a person with disability, there shall be allowed a deduction of ...
TDS validation error regarding challan entry
TDS validation error regarding challan entry - "Date prior to immediate previous financial Year is not allow" Solution As per NSDL guideline single challan can be utilized across all forms (i.e. Form 24Q,26Q,27Q & 27EQ). Challan date can be any ...
TDS > While Deductee entry > Any Section not found (Not visible)
While doing the Deductee entry if you are not able to find any of the section or any section is not visible For example Not able to find Section - 6CL while doing the Deductee entry Solution : To resolve the issue Go to Master > Deductor ...
TDS - Standard deduction section 16(ia)
TDS - Standard deduction section 16(ia) Standard Deduction of Rs. 40,000 in Budget 2018, giving the salaried class something to rejoice about. It replaced the transport allowance Rs. 19200 and medical reimbursement of Rs. 15,000 per annum ...
TDS- 27 D request error
TDS- Form 27D (TCS) request error - "This statement has challan(s) with more valid PAN deductee rows than entered by you. Please enter details of such challan and corresponding deductee rows" Possible resolution - Guidelines for KYC • You are ...
Deductee entry error - Data of payment should with in financial year
Deductee entry error - Data of payment should with in financial year Solution This is an information message , it is informing you that "date of payment" and "date of payment credit" should be with in financial year. Example : You can see in ...
How to fill Annexure II (Salary) details in TDS software?
Solution: Please note that Salary detail data is mandatory for e-filing of Fourth Quarter for all the employees. You can enter the salary Income in Deductee Detail > Salary Detail feature given in menu bar. Now,double click on the ...
How and Where to enter PRN number?
Where to enter the PRN number for Form 16 generation and filling of next quarter return? Message while generating quarterly return. Please Update PRN No. of any last filed 24Q Quarterly return of the relevant statement. If you have not filed return ...
Invalid file format or BCP Utility error while importing consolidate file
SOLUTION: To resolve the "Invalid file format or BCP Utility error" error which generally occurs while importing txt\tds\fvu file please go to Tools > Option Settings, Here set default path in all Export Utility Path and then OK. Export Utility path ...
How to recover data through .kbt Files?
Data restoration through .kbt files. KBT Files contains the data for TDS Software. For restoration of data please follow the steps below: Step 1: Go to C Drive > Windows > Here check the files extension > .kbt Step 2: Copy .kbt file to ...
24 Q Correction validation error -RELATED SALARY DETAILS
24 Q Correction validation error -T-FV-4308 Invalid value provided under field "Total TDS by the current employer'"[aggregate of the amount in column 323 of annexure -I] Possible Resolution To solve this tds 24q correction validation error , here ...
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 ...
TDS Software - If Challan are shown in RED Color
What is the meaning if some challan entries are shown in RED Color? This generally means that challan is negative or we can say challan amount is less and you have deducted excess amount. As you can see in ...
24G Correction Statement - Duplicate Correction of same Month not allowed
24G Correction - Duplicate Correction of same Month not allowed Troubleshoot The reason for the error "Duplicate Correction of same Month not allowed " is that user importing the same file of the same month twice. user cannot import a fvu file of ...
While verifying Multiple Challans in TDS software shows error message
Solution: To resolve the error, you need to register the Validatecsi.dll file on your system, to do so please follow the instructions provided here: Step 1: Open Command prompt (Run as Administrator) . Step 2: Type the following command there ...
TDS > Error 13 - Type Mismatch
Solution: This issue is related to particular Client's database or Conso file issue. To resolve this please follow the steps below: Step 1: Please re-import the consolidate file through Export/Import – Import from Text/FVU/TDS file option and import ...
Next page