- Home
- Skills
- Workflow Automation
- File My ITR
File My ITR
Automated Indian ITR data extraction, reconciliation, and formatted Excel workbook generation for ITR-1 to ITR-4.
Free
Works with the AI Agents you already use
File My ITR
Example session with this skill installed
I've uploaded my Form 16, AIS, and Zerodha P&L. File my ITR and prepare the workbook for the new regime.
- Read your context and instructions
- Compiled the file my itr
I have processed your tax documents for FY 2025-26 (AY 2026-27). I reconciled the dividend income from your AIS and Zerodha statement, identified two STCG 111A transactions, and applied the standard deduction for the new regime. ## Tax Return Data Summary | Schedule | Amount (₹) | Source | | :--- | :--- | :--- | | **Salaries (Sch S)** | 1,825,000 | Form 16 (Section 17(1)) | | **Capital Gains (Sch CG)** | 42,500 | Zerodha Tax P&L (STCG 111A) | | **Other Sources (Sch OS)** | 12,400 | Union of AIS & Bank Interest | | **Gross Total Income** | 1,879,900 | | | **TDS Claimed** | 210,450 | Form 26AS Ledger | | **Net Tax Payable** | 18,220 | Indicative (before 234C) | I have generated the `ITR-Data.xlsx` workbook using the deterministic generator. You can find the breakdown of quarterly accruals for your capital gains in the '234C Quarterly Accrual' tab, which is required for the ITR-2 utility. **Next steps** 1. Download `ITR-Data.xlsx` and verify the 'Notes & Assumptions' tab for flagged AIS discrepancies. 2. Confirm the Quarterly Accrual buckets match your trade execution dates. 3. Provide your last year's ITR if you wish to reconcile carry-forward losses.
Connects securely to your tools. The creator never sees your data.
About this skill
Filing Indian Income Tax Returns involves aggregating data from fragmented sources like Form 16, AIS/TIS, broker P&L statements, and crypto reports. This skill automates the extraction, reconciliation, and formatting of tax data into a clean, audit-ready workbook for ITR-1, ITR-2, ITR-3, and ITR-4. ## What it does - **Multi-source extraction** parses PDFs and spreadsheets from employers, banks, stock brokers (Zerodha, Groww, Vested), and crypto exchanges. - **Cross-document reconciliation** compares dividend and capital gains data across broker P&L, AIS/TIS, and Form 26AS to find the authoritative union. - **Automated workbook generation** runs a bundled Python generator to produce a formatted `ITR-Data.xlsx` with schedules for Salary, HP, CG, VDA, and Foreign Assets. - **Quarterly accrual mapping** buckets capital gains and dividends into the five mandatory periods for Schedule 234C compliance. - **JSON validation** audits existing ITR JSON files for common errors like missing perquisite descriptions, stale carryovers, or 194S TDS misclassification. ## How it works 1. **Inventory**: Point the agent to a folder containing your tax documents (Form 16, AIS, Broker P&L). 2. **Reconcile**: The agent extracts data points and flags discrepancies between depository SFTs and actual broker statements. 3. **Generate**: It writes a `values.json` and executes `scripts/build_workbook.py` to create the final spreadsheet. 4. **Validate**: A final check ensures the chain from Schedule CG through Part B-TTI is consistent and error-free. ## Frameworks & tools Uses `pdfplumber` for document extraction, `openpyxl` for spreadsheet manipulation, and a custom Python generator for deterministic workbook output. ## Why this beats prompting it yourself Manual prompting often fails at quarterly gain bucketing and consistent schedule formatting. This skill uses a hardened Python script to ensure the final Excel output is mathematically correct and formatted exactly for ITR utility compatibility every time. ## Use cases - Reconciling foreign equity gains from Vested or INDmoney for Schedule FA reporting. - Aggregating multi-exchange crypto trades into the 30% flat tax VDA schedule. - Preparing freelancing or F&O business income for ITR-3 filing. ## Known limitations Does not provide tax advice. Requires a local Python environment to run the workbook generator script. Current rates are set for AY 2026-27 (FY 2025-26).
Requires local Python for build_workbook.py. Tax rates default to AY 2026-27. Does not provide tax advice. Requires manual CA review.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 6 days ago
- Free with an Agensi account