File My ITR

    1

    Automated Indian ITR data extraction, reconciliation, and formatted Excel workbook generation for ITR-1 to ITR-4.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    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

    ScheduleAmount (₹)Source
    Salaries (Sch S)1,825,000Form 16 (Section 17(1))
    Capital Gains (Sch CG)42,500Zerodha Tax P&L (STCG 111A)
    Other Sources (Sch OS)12,400Union of AIS & Bank Interest
    Gross Total Income1,879,900
    TDS Claimed210,450Form 26AS Ledger
    Net Tax Payable18,220Indicative (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).

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Workflow Automation.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    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 to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 6 days ago

    • Free with an Agensi account

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Listed6 days ago

    What's inside

    Frequently Asked Questions

    The skill supports documents for ITR-1 through ITR-4, including Form 16, AIS/TIS, 26AS, and P&L statements from major brokers like Zerodha and Groww, as well as crypto exchanges.

    Yes, the skill includes a specialized script to map capital gains and dividends into the five specific quarterly buckets required for Schedule 234C compliance.

    You receive the AI agent configuration for data extraction, a custom Python generator for Excel formatting, and pre-built validation scripts to audit your final tax data.

    You will need a local Python environment with the 'pdfplumber' and 'openpyxl' libraries installed to execute the final workbook generation and validation steps.

    The skill is currently updated with the tax rates and schedule formats for Assessment Year 2026-27 (Financial Year 2025-26).

    This skill uses a deterministic Python script to generate the Excel file, ensuring mathematical accuracy and consistent formatting that manual prompting often fails to achieve.

    New in Workflow Automation

    Free