TDS Return Preparation Services — Data Compilation, Rate Computation & RPU File Preparation
The upstream work that makes the quarterly return error-free: payment extraction, section-wise rate computation, PAN validation, OLTAS challan reconciliation and RPU file build
TDS Return Preparation — Where Accuracy Is Actually Decided
TDS return preparation is the critical upstream process that determines the accuracy of the quarterly TDS return filed on the TIN and TRACES portal. It encompasses extracting all TDS-applicable payment data from the deductor's books of account, computing TDS at the correct rate under each applicable section, validating deductee PANs, reconciling TDS challans with OLTAS (Online Tax Accounting System) records, and preparing the data in the Return Preparation Utility (RPU) format prescribed by NSDL — all before the actual portal filing. Errors in any of these upstream steps translate into TDS return defects that attract demand notices, penalties, and short deduction assessments.
At N D Savla & Associates, our tax compliance team in Mumbai provides dedicated TDS return preparation services — focusing on the data quality, rate accuracy, and format compliance that make the subsequent TDS return filing error-free. Our preparation service is particularly valuable for businesses with complex payment structures: multiple vendor categories with different TDS rates, large salary rolls with variable exemptions, payments to non-residents under multiple treaty provisions, and high-volume challan payment records that need meticulous reconciliation.
Whether you use our integrated service — preparation plus filing — or need preparation support for in-house filing, our team provides structured, documented TDS data packages that translate seamlessly into accurate quarterly returns, and into the Form 16 and 16A TDS certificates that your employees and vendors rely on for their own income tax compliance.
What TDS Return Preparation Involves
Payment Data Extraction and Classification
The foundation is a complete, accurate ledger of all TDS-applicable payments for the quarter. We extract vendor payments (contractor, professional, rent, interest, commission, royalty, advertising, transport), salary and perquisite payments, and non-resident remittances. Each payment is classified by section: 192, 194C, 194J, 194I, 194A, 194H, 194D, 195, and the many other applicable sections.
TDS Rate Determination
For each payment category we determine the correct rate, considering the base rate under the applicable section; Section 206AA enhancement for PAN non-availability (20% or twice the normal rate, whichever is higher); Section 206AB enhancement for specified non-ITR-filers; lower deduction certificates (Form 13) submitted by the deductee; and treaty rates for non-resident payments, which may be lower than Section 195 withholding rates.
PAN Validation
Each deductee's PAN is validated through the Income Tax Department's PAN verification API or the bulk verification facility on TRACES. Invalid or incorrectly quoted PANs are flagged immediately — deducting at the standard rate against an invalid PAN triggers a 20% deduction demand for the differential. We request valid PANs from deductees well before return preparation.
Section 206AB Status Check
For deductees receiving payments above the 206AB threshold, we check ITR filing status using the Compliance Check Facility on TRACES, available for bulk checks by TAN holders. Deductees identified as 'specified persons' are flagged and the higher TDS rate is applied in the return data.
Threshold Analysis
Many TDS sections have payment thresholds below which deduction is not required. We track cumulative payments to each party across the year — deducting TDS from the payment that first crosses the threshold, on the aggregate rather than only on the crossing amount.
Challan Preparation and OLTAS Reconciliation
After computing the quarter's TDS liability, we prepare the payment challans for each TDS type — separate challans for salary TDS, contractor TDS, professional fee TDS, and so on. After payment, each challan's BSR code, date, and serial number from the OLTAS record are reconciled against the RPU entry. This is the most error-prone step — any mismatch causes FVU validation failure. See our TDS Return Filing service for the subsequent portal filing process.
RPU Data Entry
All validated data — deductee details, payment details, TDS details, challan details — is entered into the NSDL Return Preparation Utility. The RPU generates the .fvu file after passing all in-built validations. We review the output for reasonableness, checking total TDS deducted against total TDS paid via challans for consistency.
For TDS on rent specifically — Section 194I for businesses or 194IB for individuals and HUFs — the rate, threshold, and filing process differ significantly. Our TDS on Rent service provides dedicated guidance. For property purchase TDS under Section 194IA, see our TDS on Purchase of Property service.
Section Thresholds We Monitor Across the Year
Thresholds are tested on cumulative payments to a party, not on a single invoice — which is why a party who was below the threshold in Q1 can require deduction on the aggregate by Q3.
| Section | Payment Type | Threshold | How It Is Tested |
|---|---|---|---|
| 194C | Contractor payments | ₹1 lakh aggregate per year per contractor | Cumulative across the financial year |
| 194J | Professional and technical fees | ₹30,000 per person per year | Cumulative across the financial year |
| 194I | Rent on land, building, plant or machinery | ₹2.4 lakh per year per landlord | Cumulative across the financial year |
Salary TDS Preparation (Form 24Q): Month by Month
Salary TDS preparation requires additional steps compared to non-salary returns: collecting Form 12BB from each employee at the start of the year and updating it as the year progresses; computing monthly TDS based on estimated annual income and deductions; applying Chapter VI-A deductions such as 80C, 80D, 80E and 80CCD(1B); computing Section 10 exemptions such as HRA, LTA and children's education allowance; and computing the final Q4 true-up based on actual declarations and investment proofs. The Q4 Annexure II requires full-year salary detail for every employee — the basis of Form 16 Part B.
Year-Start: Form 12BB Collection and Provisional TDS
At the start of each financial year in April, we collect Form 12BB investment declarations from all employees — covering projected 80C investments, HRA claim, LTA claim, Section 80D health insurance, and other deductions. Provisional annual TDS is computed for each employee based on estimated income and deductions, and monthly TDS is derived. Any increase or decrease in declarations mid-year triggers a recomputation.
Monthly TDS Computation and Deduction
Each month we recompute TDS on salary based on actual salary paid, leave travel allowance encashment, bonuses or special payments, stock option (ESOP) perquisite computations under Rule 3, and any mid-year changes in declaration. TDS is the monthly instalment covering the full annual liability — any under-deduction in earlier months is caught up in subsequent months.
Q4 True-Up and Final Computation
In Q4 we collect actual investment proof documents from employees — verifying LIC receipts, PPF statements, ELSS fund statements, home loan certificates, and medical insurance premium receipts. Final tax is computed on actual verified amounts and Q4 TDS is the true-up. The Q4 Annexure II of Form 24Q contains the full-year salary schedule for every employee, making this the most document-intensive preparation step of the year.
Historical Context: TDS Data Preparation Before and After TRACES
Before the introduction of TRACES in 2012-13, TDS return preparation was a largely manual process — data was compiled in spreadsheets and uploaded to the TIN portal through the NSDL Return Preparation Utility with limited automated validation. Errors were discovered only when returns were processed centrally, often months later, resulting in correction notices that required manual intervention.
TRACES transformed TDS compliance by providing real-time PAN verification, online challan status checking against OLTAS, online 26AS tax credit statements for deductees, and the ability to download correction statement workings. TRACES also enabled the AIS (Annual Information Statement) — a comprehensive tax profile for every taxpayer showing all TDS, TCS, SFT, and other data reported against their PAN. The AIS has significantly increased the Income Tax Department's ability to cross-verify TDS claims.
The Section 206AB regime, effective from July 2021, added a new data requirement to TDS preparation: checking each deductee's ITR filing compliance before applying rates. The TRACES Compliance Check Facility has made this practically manageable for deductors with large deductee bases, but the process requires systematic integration into the preparation workflow. Budget 2024 then rationalised rates across several sections — with merged rates and new sections effective from 1 October 2024 requiring preparation systems to apply different rates for payments in the same quarter, before and after that date. Our team maintains rate change calendars and implements effective-date rate changes precisely.
Why Choose N D Savla & Associates for TDS Return Preparation in Mumbai?
Multi-Section TDS Expertise
We handle TDS computation across all applicable sections simultaneously — 192, 194C, 194J, 194I, 194A, 194H, 194D, 194-O, 195, and others — in a single integrated preparation exercise for each quarter.
206AB Compliance Built In
Our preparation workflow includes a mandatory 206AB compliance check for all deductees above threshold — protecting you from higher TDS demands for overlooked non-ITR-filer deductees.
Threshold Monitoring Across Payments
We track cumulative payments to each party across the year — flagging threshold crossings in real time so deduction begins from the correct payment, preventing both under-deduction and over-deduction.
Challan Reconciliation Rigour
Our pre-FVU challan reconciliation eliminates the challan mismatch errors that are the most common cause of TDS return FVU failure. After preparation, the clean data feeds into our TDS Return Filing service for error-free portal submission.
Form 16A Generation Support
After return filing and TRACES processing, we generate Form 16A for non-salary deductees directly from the portal — ensuring the certificate matches the filed return exactly and is delivered within the statutory 15-day timeline.
Structured Onboarding Checklist
Our client onboarding checklist specifies the exact format for each data type — vendor ledgers, salary register, Form 12BB declarations, challan details, deductee PANs, and lower deduction certificates — so the first quarter runs as cleanly as the fourth.
Frequently Asked Questions — TDS Return Preparation
What accounting data do we need to share for TDS return preparation?
We need vendor payment ledgers covering all parties to whom TDS-applicable payments were made; the salary register for Form 24Q; Form 12BB employee declarations for salary TDS; TDS challan payment details from the bank or NSDL portal; PAN details of all deductees; and lower deduction certificates (Form 13) if any. Our client onboarding checklist specifies the exact format for each data type.
How does TDS return preparation differ from TDS return filing?
TDS return preparation is the upstream data and computation work — extracting payments, computing rates, validating PANs, reconciling challans, and building the RPU file. TDS return filing is the act of uploading the prepared RPU file to the TIN and TRACES portal. Our TDS Return Filing service handles the portal submission; this preparation service handles everything before that step. We offer both as an integrated service or separately.
What is Form 12BB and why is it important for TDS preparation?
Form 12BB, prescribed under Rule 26C, is the employee's declaration of investments and deductions that forms the basis of salary TDS computation by the employer. An employee who does not submit Form 12BB, or submits it with incorrect or incomplete information, will have excess TDS deducted — which then appears in their Form 26AS and must be claimed as a refund in their ITR. Systematic Form 12BB collection and updating through the year is a key deliverable of our salary TDS preparation service.
How is TDS computed on a payment that straddles different months or quarters?
TDS is deducted at the time of credit in the books of account or at the time of actual payment, whichever is earlier. For invoices booked in one period but paid in another, the TDS obligation crystallises at the booking date if the amount is credited to the vendor's account, even if cash is paid later. Our preparation captures the booking date as the TDS deduction date — preventing disputes about the timing of the obligation. For year-round TDS compliance on rent payments see our TDS on Rent service, and for buyers of property needing one-time compliance, our TDS on Purchase of Property service.
What is the impact of incorrect TDS rate application on the deductor?
Short deduction — applying a lower TDS rate than required — makes the deductor liable under Section 201(1), treating them as an 'assessee in default' for the shortfall. Interest under Section 201(1A) at 1.5% per month from the deduction date to the payment date, plus the principal shortfall, is recoverable from the deductor. The deductee can claim credit for TDS not deducted, creating a mismatch between the deductor's TDS certificate and the amount in the deductee's 26AS.
Get the Data Right Before the Return Goes Out
Payment extraction, section-wise rate computation, PAN and 206AB validation, threshold monitoring, challan reconciliation and RPU file preparation — for deductors across Mumbai, Thane, Navi Mumbai, Pune and pan-India.
- 📞 +91 98218 32683 | WhatsApp +91 98190 00511
- ✉ nainitsavla@savlagroup.in
- 📍 Suite No. 102, L1, Ashok Premises, Nicholas Road, Andheri East, Mumbai 400069
- 🕐 Monday–Saturday | 10:00 AM – 7:00 PM