TDS Reconciler

The Problem

During quarterly TDS cycles at BetterInvest, one of the most time-consuming tasks was reconciling large volumes of Form 16A documents with internal TDS master records. These PDFs were scattered, unstructured, and numerous — manually extracting PAN numbers and TDS values for comparison across 2,000+ files was both repetitive and prone to oversight. A single missed PAN or wrong TDS value could create compliance exposure.

The Solution

I built an end-to-end TDS reconciliation workflow that processes the entire document set automatically. The script bulk-extracts PAN numbers and corresponding TDS values from every Form 16A PDF and matches them against the internal TDS master data. The output is a structured reconciliation summary that gives the team a clear picture of the entire investor set in one go.

For every investor, the output shows their PAN, the TDS amount as per Form 16A, the TDS amount as per the internal master, and a status — matched, mismatch, or variance. Any discrepancy is immediately flagged for review. The production house TDS filings are validated against BetterInvest's internal records for each investor across each asset.

Why It Matters

This transforms what was previously a heavy, manual verification task into a structured, repeatable, and dependable process. The accuracy improvement is equally important — the tool doesn't get tired or distracted at row 1,847. Every file gets the same level of scrutiny.

"It ensures cleaner, more reliable reconciliation and gives us confidence that production houses have filed the correct TDS amounts for each investor in line with our internal records."

Tools Used

A reconciliation template and step-by-step tutorial were prepared and shared with the team, so the workflow can be run by any team member without technical knowledge at every quarterly cycle.