Skip to main content

Income Tax Report APIs

The Income Tax Report APIs provide comprehensive reporting capabilities for investment analysis, tax planning, and compliance. Generate detailed profit & loss reports, capital gains statements, and tax analysis across multiple asset classes using job-based async processing.

Key Features

Tax P&L Reports

Generate comprehensive profit & loss reports with tax implications:

Capital Gains Reports

Create detailed capital gains statements for tax compliance:

Asset Classes Supported

Securities (Domestic & Foreign)

  • Equity Shares: Delivery and intraday trading with holding period classification
  • Mutual Funds: SIPs, lump-sum investments, redemptions with indexation benefits
  • Derivatives: Futures, options, and other derivative instruments
  • Currency Impact: Foreign securities with automatic currency conversion and gains

Investment Portfolios

  • Multi-Asset: Combined reporting across different asset classes
  • Tax Regimes: Support for both old and new tax regimes
  • Holding Periods: Automatic STCG/LTCG classification
  • Indexation: Cost inflation adjustment for long-term gains

Async Job Processing

All report generation uses job-based asynchronous processing for scalability:
1

Submit Report Job

POST request with report parameters → Receive job_id and processing confirmation
2

Upload Transaction Data (if required)

For large datasets, upload transaction data via provided S3 presigned URLs
3

Monitor Job Status

Poll job status endpoint with job_id to track processing progress
4

Retrieve Results

Download completed reports in Excel/JSON format once processing is finished

Job Status Flow

{
  "status": "processing", // created → processing → completed/failed
  "progress": 75,        // Percentage completion
  "message": "Processing 750 of 1000 transactions",
  "result_url": "https://..." // Available when completed
}

Report Formats

Excel Reports (.xlsx)

  • Detailed breakdowns by asset class and transaction type
  • Tax calculations with STCG/LTCG classification
  • Summary sheets with portfolio-level analytics
  • Annexures with transaction-level details

JSON Reports

  • Structured data for programmatic processing
  • API integration ready format
  • Real-time access to report data
  • Custom filtering and analysis capabilities

Tax Compliance Features

  • Automatic classification: STCG (Short-term) vs LTCG (Long-term) gains
  • Indexation benefits: Cost inflation adjustment for domestic securities
  • Currency gains: Foreign exchange impact on international investments
  • Tax regime support: Old and new tax regime calculations
  • Carry forward losses: Capital loss tracking and utilization

Integration Options

  • REST APIs: Standard HTTP endpoints for all report operations
  • Postman Collections: Pre-configured API testing environments
  • Webhook Support: Real-time notifications for job completion
  • Batch Processing: Handle thousands of transactions efficiently

Performance & Limits

  • Job Queue: Unlimited job submissions with concurrent processing
  • Data Processing: Handle up to 50,000 transactions per job
  • Report Generation: Excel reports up to 10MB in size
  • Retention: Job results available for 30 days
  • Rate Limits: 100 requests per minute per API key

Use Cases

Tax Planning & Filing

  • ITR Preparation: Generate data for Income Tax Return filing
  • Tax Optimization: Identify tax-saving opportunities
  • Compliance Reporting: Meet regulatory reporting requirements

Portfolio Analysis

  • Performance Review: Analyze investment performance with tax impact
  • Rebalancing: Optimize portfolio based on tax implications
  • Reporting: Generate client-ready investment reports

Financial Planning

  • Tax Liability: Estimate future tax obligations
  • Capital Gains Planning: Plan asset sales for optimal tax outcomes
  • Wealth Management: Comprehensive tax-aware portfolio management

Support & Resources

  • API Reference: Complete endpoint documentation with examples
  • Postman Collection: Import ready-to-use API tests
  • Sample Data: Pre-formatted transaction data for testing
  • Annexures: Detailed schema documentation for data formats
For technical support or integration assistance, refer to the API Reference or contact Sandbox support.