AY 2026–27 · India · IBKR Activity Statements

Turn IBKR statements into reviewable ITR working papers.

Prepare draft Capital Gains, Schedule FA, FSI, and TR working papers in your browser—with prescribed-date conversions, visible assumptions, and an audit trail your CA can review.

Import IBKR statements See the calculation model

No sign-up
No broker credentials
No statement uploads

Disposals 12 2 need review

Foreign income ₹42,830 Illustrative

Network requests for your files Everything runs in browser memory

01 Local by design

Your statements never leave this browser.

02 Evidence before totals

Every draft row stays tied to its source section.

03 Honest boundaries

Unsupported cases are flagged, never silently guessed.

Working preview · v0.2

Build a CA-review packet in four steps.

Start with synthetic data, or use your own IBKR Activity Statement CSVs. Files are parsed locally and discarded when the page closes.

Private browser workspace Import statements, confirm assumptions, preview every schedule, then export.

Check methodology

Step 1 of 4

Import Activity Statements

Local-only

Export CSV statements from IBKR for the financial year and the relevant calendar year. Overlapping statement rows are de-duplicated.

Drop IBKR statement CSVs here or choose files from this device · multiple files supported Nothing is sent to a server

Choose CSVs or load the synthetic demo to begin.

How to export the right IBKR statement

In Client Portal, open Performance & Reports → Statements.
Run an Activity Statement with trades, dividends, withholding, positions, and transfers.
Choose CSV and include both FY and calendar-year coverage when available.

Step 2 of 4

Confirm filing assumptions

Needs confirmation

These choices control which working papers are relevant. OpenTax Ledger does not collect your PAN, Aadhaar, name, or broker password.

Assessment year FY 2025–26 for AY 2026–27 Residential status FA / FSI treatment depends on this Likely return form This is a working assumption, not form selection advice Broker base currency IBKR conversions are not treated as Rule 115 evidence Assumed marginal tax rate (AY slab rate) Used only to preview the per-country FTC cap DTAA section Used for FTC computation grouping

Local reference pack

Check the source before using the number

No provider calls

USD exchange-rate reference

SBI FX RateKeeper community archive

Loading bundled USD table…

Open-source archive Current official SBI PDF

Company reference provider

SEC EDGAR ticker associations

Loading offline company snapshot…

Official SEC source

Company names only; no prices, issuer-country inference, or live lookup.

Use your own retained SBI reference CSV Download bundled USD CSV

Using the bundled, pinned community USD reference table.

Derived prescribed-date ledger

Automatic Rule 115 date summary

Dates are derived from reviewed schedule rows after reference enrichment. The statutory date is retained; if that calendar date has no observation, the latest available SBI observation on or before it is used within the evidence window and shown.

Load a statement or the synthetic demo to see required conversion dates.

Latest 12 usable USD observations in the bundled table
Published at	TT BUY (INR)	Evidence

Community data is not an official historical SBI feed

Rule 115 and Rule 26 point to SBI’s TT buying rate. Verify material dates against retained primary evidence. Matched row conversions populate draft INR previews; missing, prior-observation, or conflicting evidence remains visible.

Step 3 of 4

Review the evidence, not just the total

Draft

Values from IBKR are source references. Indian classification, lot treatment, Rule 115 conversion, and FTC eligibility still require review.

Review console Resolve flagged assumptions before downloading the handoff pack.

Preview first · export after confirmation

STCGWaiting

— Load a statement to review

LTCGWaiting

— Load a statement to review

DividendsWaiting

— Exact-date INR preview

InterestWaiting

— Exact-date INR preview

Foreign tax paidWaiting

— Rule 128 conversion preview

FTC candidateWaiting

— Eligibility is not computed

HoldingsWaiting

— Source closing value

Load a statement or the synthetic demo to preview review tables.

Validation register

What still needs a human decision

0 checks

No review model loaded.

Step 4 of 4

Package the working papers

Local download

The review pack is a handoff artifact—not an ITR submission and not proof that a return has been filed.

HTML

CA review report

A print-ready offline report with assumptions, schedule previews, validation findings, and source counts.

JSON

Audit data

Machine-readable normalized draft data for reproducibility and community testing.

CSV

Schedule tables

A combined Capital Gains, FSI, TR, and FA working table that opens in spreadsheet software.

Portal CSV

Schedule FA A3 portal CSV

Available after review confirmation.

Enter portal-ready metadata once per filing entity. The values are applied to each acquisition lot in the generated A3 CSV.

Load a statement or the synthetic demo to prepare portal metadata.

Before filing

Confirm residential status and return form. Supply and retain authoritative TT buying rates. Resolve transfers, corporate actions, and unsupported assets. Reconcile foreign tax evidence and Form 67 timing. Have a qualified CA review the final figures.

Transparent by default

A calculation model you can challenge.

The product separates broker facts, tax assumptions, and unresolved judgments so a reviewer can see where each number came from.

Input

Broker evidence

Activity Statement CSVs: trades, positions, dividends, withholding, interest, transfers.

Original values retained in browser memory

Normalize

Auditable ledger

Known IBKR sections are mapped into typed records with source file and row references.

Duplicates removed · unsupported rows flagged

Review

Draft schedules

CG, FSI, TR, and FA working tables are assembled without hiding missing evidence.

CA review required before filing

Included in v0.2

Conservative first scope

IBKR Activity Statement CSV section parsing
Foreign-listed equity and ETF source rows
Dividends, withholding, interest, and open positions
Draft CG / FSI / TR / FA review tables
Pinned community USD TT BUY table and local CSV override
Automatic Rule 115 / Rule 128 prescribed-date derivation and INR previews
Offline SEC company, ticker, exchange, and CIK associations
Validation findings and source audit counts

Flagged, not guessed

Outside the current engine

Direct ITR or Form 67 submission
Options, futures, shorts, bonds, forex, or business-income classification
Corporate actions and transferred-in lots with missing basis
An official historical SBI archive or silent nearest-date rate substitution
Final tax liability or professional advice

AGPL-3.0 open source

Tax software deserves public scrutiny.

Parsing logic, rule assumptions, synthetic fixtures, and validation tests live together. Contributions should improve traceability before they add automation.

GitHub repository Read supported scope →

open-tax-ledger

lib/
  ibkr.js
  export.js
  reference-data.js
public/
  app.mjs
  data/
fixtures/
  demo-activity.csv     # synthetic
docs/
  data-sources.md
  methodology.md
  threat-model.md
.github/workflows/
  pages.yml
tests/
  parser.test.mjs
  reference-data.test.mjs

License: AGPL-3.0-only
Network calls: none