Case study · Tax, TDS & Compliance Tools

Foreign Stock (ESPP / RSU) Capital Gains Workpapers

Broker statements parsed and lot-matched to produce Indian capital gains workpapers for ESPP and RSU holders.

The challenge

Employees holding foreign company shares receive broker statements as dense PDFs and spreadsheets, and computing Indian capital gains from them - lot-wise costs, vesting dates, exchange rates, broker charges - is slow and error-prone.

What we built

We built tools that parse the broker statements, match every sale to its acquisition lots, apply the correct exchange rate per lot, allocate transfer charges to the right transactions, and produce a clean capital gains workpaper formatted for Indian tax filing. Computations that took hours per client are now generated in seconds, with consistent treatment year after year.

The result

Before: hours per client. Now: seconds.

Related case studies

Tax, TDS & Compliance Tools

Consolidated TDS Statement to Excel (26Q and 24Q)

Chartered accountants and TDS filing agents

TRACES consolidated TDS files opened as a three-sheet Excel workbook - deductor, challans and deductees - in one double-click.

Beforerecord-by-record review
→
Nowa few seconds
Tax, TDS & Compliance Tools

eTDS Correction Return Preparation and File Format Checker

Chartered accountants and TDS filing agents

TDS correction returns prepared from a marked-up Excel, plus a 100+ rule checker against Income Tax Department file formats.

Beforerepeated rejection round trips
→
Nowclean first time
Tax, TDS & Compliance Tools

TDS Return Notice Forecaster (Pre-Filing Check)

Chartered accountants and finance teams filing quarterly TDS returns for several deductors

Reads 26Q and 27Q return files before filing and forecasts likely TRACES defaults, so corrections happen first.

Beforedefaults found after filing
→
Nowfiled clean first time

← Search all 60 case studies

Have a process like this on your desk?

Tell us how the work is done today. We will show you what can be automated - usually a working version within days.