Skip to main content
POST
/
it
/
calculator
/
tax-pnl
/
real-estate
/it/calculator/real-estate/tax-pnl
curl --request POST \
  --url https://api.sandbox.co.in/it/calculator/tax-pnl/real-estate \
  --header 'Authorization: <authorization>' \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <x-api-key>' \
  --data '
{
  "name": "real_estate_tradewise_settlement_workbook",
  "@entity": "workbook",
  "sheets": [
    {
      "name": "tradewise_settlement_sheet",
      "@entity": "sheet",
      "blocks": [
        {
          "name": "tradewise_settlement_table",
          "@entity": "table",
          "header": [
            "serial_number",
            "asset_type",
            "property_name",
            "country",
            "curency",
            "buy_date",
            "buy_price",
            "cost_of_acquisition",
            "sell_date",
            "sell_price",
            "transfer_expenses"
          ],
          "rows": [
            [
              "6abba3b3-d061-45f5-a947-c6a944663605",
              "residential_property",
              "RESID 1",
              "India",
              "INR",
              1696185000000,
              15000000,
              0,
              1712255400000,
              17500000,
              10000
            ],
            [
              "592994fb-3b14-4ec7-9203-502cd8927bec",
              "commercial_property",
              "COM ",
              "India",
              "INR",
              1011175420000,
              8590000,
              0,
              1712169000000,
              245000000,
              17000
            ],
            [
              "991d604c-989f-4530-948b-fa2e609c2d56",
              "non_agricultural_land",
              "NA ",
              "India",
              "EUR",
              1286649000000,
              8590000,
              0,
              1712169000000,
              24582000,
              17000
            ],
            [
              "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
              "agricultural_land",
              "UA",
              "India",
              "USD",
              1697740200000,
              230303,
              0,
              1712169000000,
              309000,
              12400
            ]
          ]
        },
        {
          "name": "cost_of_improvement_table",
          "@entity": "table",
          "header": [
            "settlement_serial_number",
            "financial_year",
            "cost",
            "indexed_cost"
          ],
          "rows": [
            [
              "592994fb-3b14-4ec7-9203-502cd8927bec",
              "FY 2010-11",
              250000,
              null
            ],
            [
              "991d604c-989f-4530-948b-fa2e609c2d56",
              "FY 2012-13",
              250000,
              null
            ],
            [
              "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
              "FY 2023-24",
              1330,
              null
            ]
          ]
        }
      ]
    }
  ]
}
'
{
  "code": 200,
  "data": {
    "name": "tradewise_tax_pnl_workbook",
    "@entity": "workbook",
    "sheets": [
      {
        "name": "tax_pnl_summary_sheet",
        "@entity": "sheet",
        "blocks": [
          {
            "name": "asset_wise_summary_table",
            "@entity": "table",
            "header": [
              "asset_class",
              "asset_type",
              "income_head",
              "income_sub_head",
              "tax_rate",
              "section",
              "holding_period",
              "turnover",
              "turnover_inr",
              "buy_value",
              "buy_value_inr",
              "cost_of_acquisition",
              "cost_of_acquisition_inr",
              "sell_value",
              "sell_value_inr",
              "realized_pnl",
              "realized_pnl_inr",
              "transfer_expenses",
              "transfer_expenses_inr",
              "net_realized_pnl",
              "net_realize_pnl_inr",
              "taxable_pnl",
              "taxable_pnl_inr"
            ],
            "rows": [
              [
                "real_estate",
                "residential_property",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                17833300,
                17833300,
                15694300,
                15694300,
                15694300,
                15694300,
                17833300,
                17833300,
                2139000,
                2139000,
                33000,
                33000,
                2106000,
                2106000,
                2104100,
                2104100
              ],
              [
                "real_estate",
                "residential_property",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                32000000,
                32000000,
                40630000,
                40630000,
                145799449.54,
                145799449.54,
                32000000,
                32000000,
                -8630000,
                -8630000,
                40500,
                40500,
                -8670500,
                -8670500,
                -114069949.54,
                -114069949.54
              ],
              [
                "real_estate",
                "commercial_property",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                346300,
                346300,
                10056000,
                10056000,
                10056000,
                10056000,
                346300,
                346300,
                -9709700,
                -9709700,
                18500,
                18500,
                -9728200,
                -9728200,
                -9741750,
                -9741750
              ],
              [
                "real_estate",
                "commercial_property",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                25100000,
                25100000,
                9490000,
                9490000,
                21463984.34,
                21463984.34,
                25100000,
                25100000,
                15610000,
                15610000,
                25900,
                25900,
                15584100,
                15584100,
                3354715.66,
                3354715.66
              ],
              [
                "real_estate",
                "non_agricultural_land",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                12104000,
                12104000,
                18700000,
                18700000,
                18700000,
                18700000,
                12104000,
                12104000,
                -6596000,
                -6596000,
                26500,
                26500,
                -6622500,
                -6622500,
                -6645355,
                -6645355
              ],
              [
                "real_estate",
                "non_agricultural_land",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                34582000,
                34582000,
                23590000,
                23590000,
                65210138.19,
                65210138.19,
                34582000,
                34582000,
                10992000,
                10992000,
                52000,
                52000,
                10940000,
                10940000,
                -30970138.19,
                -30970138.19
              ],
              [
                "real_estate",
                "rural_agricultural_land",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                413000,
                413000,
                11130303,
                11130303,
                11130303,
                11130303,
                413000,
                413000,
                -10717303,
                -10717303,
                24900,
                24900,
                -10742203,
                -10742203,
                0,
                0
              ],
              [
                "real_estate",
                "rural_agricultural_land",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                24737050,
                24737050,
                6795000,
                6795000,
                14440270.42,
                14440270.42,
                24737050,
                24737050,
                17942050,
                17942050,
                29400,
                29400,
                17912650,
                17912650,
                0,
                0
              ],
              [
                "real_estate",
                "urban_agricultural_land",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                413000,
                413000,
                10901000,
                10901000,
                10901000,
                10901000,
                413000,
                413000,
                -10488000,
                -10488000,
                24900,
                24900,
                -10512900,
                -10512900,
                -10540970,
                -10540970
              ],
              [
                "real_estate",
                "urban_agricultural_land",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                34582000,
                34582000,
                23150000,
                23150000,
                66631744.2,
                66631744.2,
                34582000,
                34582000,
                11432000,
                11432000,
                52000,
                52000,
                11380000,
                11380000,
                -32391744.2,
                -32391744.2
              ]
            ]
          },
          {
            "name": "quarter_wise_tax_pnl_summary_table",
            "@entity": "table",
            "header": [
              "asset_class",
              "asset_type",
              "quarter",
              "income_head",
              "income_sub_head",
              "tax_rate",
              "section",
              "holding_period",
              "turnover",
              "turnover_inr",
              "buy_value",
              "buy_value_inr",
              "cost_of_acquisition",
              "cost_of_acquisition_inr",
              "sell_value",
              "sell_value_inr",
              "realized_pnl",
              "realized_pnl_inr",
              "transfer_expenses",
              "transfer_expenses_inr",
              "net_realized_pnl",
              "net_realized_pnl_inr",
              "taxable_pnl",
              "taxable_pnl_inr"
            ],
            "rows": [
              [
                "real_estate",
                "residential_property",
                "1",
                "capital_gains",
                "real_estate",
                "slab_rate",
                null,
                "short_term",
                31109600,
                31109600,
                66481603,
                66481603,
                66481603,
                66481603,
                31109600,
                31109600,
                -35372003,
                -35372003,
                127800,
                127800,
                -35499803,
                -35499803,
                -24823975,
                -24823975
              ],
              [
                "real_estate",
                "residential_property",
                "1",
                "capital_gains",
                "real_estate",
                "20",
                null,
                "long_term",
                151001050,
                151001050,
                103655000,
                103655000,
                313545586.69,
                313545586.69,
                151001050,
                151001050,
                47346050,
                47346050,
                199800,
                199800,
                47146250,
                47146250,
                -174077116.27,
                -174077116.27
              ]
            ]
          },
          {
            "name": "tax_pnl_summary_table",
            "@entity": "table",
            "header": [
              "serial_number",
              "asset_type",
              "property_name",
              "holding_period",
              "tax_rate",
              "turnover",
              "turnover_inr",
              "buy_date",
              "buy_value",
              "buy_value_inr",
              "cost_of_acquisition",
              "cost_of_acquisition_inr",
              "sell_date",
              "sell_value",
              "sell_value_inr",
              "total_cost_of_improvement",
              "total_cost_of_improvement_inr",
              "country",
              "realized_pnl",
              "realized_pnl_inr",
              "transfer_expenses",
              "transfer_expenses_inr",
              "net_realized_pnl",
              "net_realized_pnl_inr",
              "taxable_pnl",
              "taxable_pnl_inr"
            ],
            "rows": [
              [
                "6abba3b3-d061-45f5-a947-c6a944663605",
                "residential_property",
                "RESID 1",
                "short_term",
                "slab_rate",
                17500000,
                17500000,
                1696185000000,
                15000000,
                15000000,
                15000000,
                15000000,
                1712255400000,
                17500000,
                17500000,
                0,
                0,
                "India",
                2500000,
                2500000,
                10000,
                10000,
                2490000,
                2490000,
                2490000,
                2490000
              ],
              [
                "5053d42f-48e2-49de-bcb8-192c65dbb0e8",
                "residential_property",
                "RESID 2",
                "long_term",
                "20",
                12000000,
                12000000,
                989001000000,
                35000000,
                35000000,
                127050000,
                127050000,
                1712169000000,
                12000000,
                12000000,
                50000,
                50000,
                "India",
                -23000000,
                -23000000,
                33000,
                33000,
                -23033000,
                -23033000,
                -115133000,
                -115133000
              ],
              [
                "6eda97c5-29da-4a9e-a897-e40573a214d3",
                "residential_property",
                "RESID 3",
                "short_term",
                "slab_rate",
                333300,
                333300,
                1709058600000,
                694300,
                694300,
                694300,
                694300,
                1712169000000,
                333300,
                333300,
                1900,
                1900,
                "India",
                -361000,
                -361000,
                23000,
                23000,
                -384000,
                -384000,
                -385900,
                -385900
              ],
              [
                "27a82fdd-8a27-40da-99c3-0047f802c8d9",
                "residential_property",
                "RESID 4",
                "long_term",
                "20",
                20000000,
                20000000,
                1079980200000,
                5630000,
                5630000,
                18749449.54,
                18749449.54,
                1712169000000,
                20000000,
                20000000,
                180000,
                180000,
                "India",
                14370000,
                14370000,
                7500,
                7500,
                14362500,
                14362500,
                1063050.46,
                1063050.46
              ],
              [
                "abcc4d1c-d60f-4e94-9d87-9f49ba264dfd",
                "commercial_property",
                "COM 1",
                "short_term",
                "slab_rate",
                245300,
                245300,
                1698863400000,
                156000,
                156000,
                156000,
                156000,
                1712169000000,
                245300,
                245300,
                1250,
                1250,
                "India",
                89300,
                89300,
                6000,
                6000,
                83300,
                83300,
                82050,
                82050
              ],
              [
                "5fb652a9-579a-4aa5-8d44-aa860c327a80",
                "commercial_property",
                "COM 2",
                "long_term",
                "20",
                600000,
                600000,
                1134325800000,
                900000,
                900000,
                2792307.69,
                2792307.69,
                1712169000000,
                600000,
                600000,
                5400,
                5400,
                "India",
                -300000,
                -300000,
                8900,
                8900,
                -308900,
                -308900,
                -2206607.69,
                -2206607.69
              ],
              [
                "61b18521-8ad2-46c0-91e0-548522415527",
                "commercial_property",
                "COM 3",
                "short_term",
                "slab_rate",
                101000,
                101000,
                1705170600000,
                9900000,
                9900000,
                9900000,
                9900000,
                1712169000000,
                101000,
                101000,
                12300,
                12300,
                "India",
                -9799000,
                -9799000,
                12500,
                12500,
                -9811500,
                -9811500,
                -9823800,
                -9823800
              ],
              [
                "592994fb-3b14-4ec7-9203-502cd8927bec",
                "commercial_property",
                "COM 4",
                "long_term",
                "20",
                24500000,
                24500000,
                1286649000000,
                8590000,
                8590000,
                18671676.65,
                18671676.65,
                1712169000000,
                24500000,
                24500000,
                250000,
                250000,
                "India",
                15910000,
                15910000,
                17000,
                17000,
                15893000,
                15893000,
                5561323.35,
                5561323.35
              ],
              [
                "97a96c85-0915-425d-ab8d-028ffa87c87f",
                "non_agricultural_land",
                "NA 1",
                "short_term",
                "slab_rate",
                12000000,
                12000000,
                1690050600000,
                9000000,
                9000000,
                9000000,
                9000000,
                1712169000000,
                12000000,
                12000000,
                10555,
                10555,
                "India",
                3000000,
                3000000,
                14000,
                14000,
                2986000,
                2986000,
                2975445,
                2975445
              ],
              [
                "6832ec27-3ca8-47bd-96d9-715df757c5f0",
                "non_agricultural_land",
                "NA 2",
                "short_term",
                "slab_rate",
                104000,
                104000,
                1705170600000,
                9700000,
                9700000,
                9700000,
                9700000,
                1712169000000,
                104000,
                104000,
                12300,
                12300,
                "India",
                -9596000,
                -9596000,
                12500,
                12500,
                -9608500,
                -9608500,
                -9620800,
                -9620800
              ],
              [
                "22f50de5-5671-4154-b9ba-f9b80a2f2298",
                "non_agricultural_land",
                "NA 3",
                "long_term",
                "20",
                10000000,
                10000000,
                1139509800000,
                15000000,
                15000000,
                46538461.54,
                46538461.54,
                1712169000000,
                10000000,
                10000000,
                40000,
                40000,
                "India",
                -5000000,
                -5000000,
                35000,
                35000,
                -5035000,
                -5035000,
                -36613461.54,
                -36613461.54
              ],
              [
                "991d604c-989f-4530-948b-fa2e609c2d56",
                "non_agricultural_land",
                "NA 4",
                "long_term",
                "20",
                24582000,
                24582000,
                1286649000000,
                8590000,
                8590000,
                18671676.65,
                18671676.65,
                1712169000000,
                24582000,
                24582000,
                250000,
                250000,
                "India",
                15992000,
                15992000,
                17000,
                17000,
                15975000,
                15975000,
                5643323.35,
                5643323.35
              ],
              [
                "5cc0a35e-0067-4ab4-b8ac-fffb5f167851",
                "urban_agricultural_land",
                "UA 1",
                "short_term",
                "slab_rate",
                309000,
                309000,
                1697740200000,
                201000,
                201000,
                201000,
                201000,
                1712169000000,
                309000,
                309000,
                15770,
                15770,
                "India",
                108000,
                108000,
                12400,
                12400,
                95600,
                95600,
                79830,
                79830
              ],
              [
                "8d0840bf-7b78-4414-8fdc-383063d0b38f",
                "urban_agricultural_land",
                "UA 2",
                "short_term",
                "slab_rate",
                104000,
                104000,
                1705170600000,
                10700000,
                10700000,
                10700000,
                10700000,
                1712169000000,
                104000,
                104000,
                12300,
                12300,
                "India",
                -10596000,
                -10596000,
                12500,
                12500,
                -10608500,
                -10608500,
                -10620800,
                -10620800
              ],
              [
                "11691108-f6db-458e-bef8-fef3d9474cfc",
                "urban_agricultural_land",
                "UA 3",
                "long_term",
                "20",
                24582000,
                24582000,
                1286649000000,
                5590000,
                5590000,
                12150718.56,
                12150718.56,
                1712169000000,
                24582000,
                24582000,
                250000,
                250000,
                "India",
                18992000,
                18992000,
                17000,
                17000,
                18975000,
                18975000,
                12164281.44,
                12164281.44
              ],
              [
                "7a9e34f7-11eb-4faa-a6e3-434626379f7b",
                "urban_agricultural_land",
                "UA 4",
                "long_term",
                "20",
                10000000,
                10000000,
                1139509800000,
                17560000,
                17560000,
                54481025.64,
                54481025.64,
                1712169000000,
                10000000,
                10000000,
                40000,
                40000,
                "India",
                -7560000,
                -7560000,
                35000,
                35000,
                -7595000,
                -7595000,
                -44556025.64,
                -44556025.64
              ],
              [
                "380e091f-1d9b-47c4-b9a8-9447e65529b4",
                "rural_agricultural_land",
                "RA 2",
                "long_term",
                "20",
                24582000,
                24582000,
                1286649000000,
                6594000,
                6594000,
                13740790.42,
                13740790.42,
                1711823400000,
                24582000,
                24582000,
                250000,
                250000,
                "India",
                17988000,
                17988000,
                17000,
                17000,
                17971000,
                17971000,
                0,
                0
              ],
              [
                "25448851-2156-42ba-9812-4bd23e441cb9",
                "rural_agricultural_land",
                "RA 4",
                "short_term",
                "slab_rate",
                104000,
                104000,
                1705170600000,
                10900000,
                10900000,
                10900000,
                10900000,
                1711823400000,
                104000,
                104000,
                12300,
                12300,
                "India",
                -10796000,
                -10796000,
                12500,
                12500,
                -10808500,
                -10808500,
                0,
                0
              ],
              [
                "0e027d00-5c76-46e7-b164-38746bfa2bf5",
                "rural_agricultural_land",
                "RA 1",
                "long_term",
                "20",
                155050,
                155050,
                1003516200000,
                201000,
                201000,
                699480,
                699480,
                1705084200000,
                155050,
                155050,
                15770,
                15770,
                "India",
                -45950,
                -45950,
                12400,
                12400,
                -58350,
                -58350,
                0,
                0
              ],
              [
                "cfb66c3b-ae78-4559-9755-ee83ba1f5540",
                "rural_agricultural_land",
                "RA 3",
                "short_term",
                "slab_rate",
                309000,
                309000,
                1697740200000,
                230303,
                230303,
                230303,
                230303,
                1705084200000,
                309000,
                309000,
                1330,
                1330,
                "India",
                78697,
                78697,
                12400,
                12400,
                66297,
                66297,
                0,
                0
              ]
            ]
          },
          {
            "name": "cost_of_improvement_table",
            "@entity": "table",
            "header": [
              "settlement_serial_number",
              "financial_year",
              "cost",
              "indexed_cost"
            ]
          },
          {
            "name": "capital_gains_income_adjustment_table",
            "@entity": "table",
            "header": [
              "tax_rate",
              "holding_period",
              "section",
              "taxable_income",
              "income_setoff_against_15_percent",
              "income_setoff_against_30_percent",
              "income_setoff_against_slab_rate",
              "income_setoff_against_10_percent",
              "income_setoff_against_20_percent",
              "net_taxable_income"
            ],
            "rows": [
              [
                "15",
                "short_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "30",
                "short_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "slab_rate",
                "short_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "10",
                "long_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "10",
                "long_term",
                "10(11A)",
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "20",
                "long_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ]
            ]
          },
          {
            "name": "capital_gains_loss_adjustment_table",
            "@entity": "table",
            "header": [
              "tax_rate",
              "holding_period",
              "section",
              "taxable_loss",
              "loss_setoff_against_15_percent",
              "loss_setoff_against_30_percent",
              "loss_setoff_against_slab_rate",
              "loss_setoff_against_10_percent",
              "loss_setoff_against_20_percent",
              "total_losses_setoff",
              "losses_remaining"
            ],
            "rows": [
              [
                "15",
                "short_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "30",
                "short_term",
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "slab_rate",
                "short_term",
                null,
                162744336,
                0,
                0,
                0,
                0,
                0,
                0,
                162744336
              ],
              [
                "10",
                "long_term",
                null,
                null,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "20",
                "long_term",
                null,
                35499803,
                0,
                0,
                0,
                0,
                0,
                0,
                35499803
              ]
            ]
          },
          {
            "name": "current_year_income_adjustment_table",
            "@entity": "table",
            "header": [
              "tax_rate",
              "holding_period",
              "section",
              "taxable_income",
              "income_setoff_against_15_percent",
              "income_setoff_against_30_percent",
              "income_setoff_against_slab_rate",
              "income_setoff_against_10_percent",
              "income_setoff_against_20_percent",
              "net_taxable_income"
            ],
            "rows": [
              [
                "business_and_profession",
                "non_speculative",
                null,
                null,
                null,
                0,
                0,
                0,
                0
              ],
              [
                "business_and_profession",
                "speculative",
                null,
                null,
                null,
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "15",
                "short_term",
                null,
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "30",
                "short_term",
                null,
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "slab_rate",
                "short_term",
                null,
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "10",
                "long_term",
                null,
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "10",
                "long_term",
                "10(11A)",
                0,
                0,
                0,
                0
              ],
              [
                "capital_gains",
                "securities",
                "20",
                "long_term",
                null,
                0,
                0,
                0,
                0
              ]
            ]
          },
          {
            "name": "current_year_loss_adjustment_table",
            "@entity": "table",
            "header": [
              "tax_rate",
              "holding_period",
              "section",
              "taxable_loss",
              "loss_setoff_against_15_percent",
              "loss_setoff_against_30_percent",
              "loss_setoff_against_slab_rate",
              "loss_setoff_against_10_percent",
              "loss_setoff_against_20_percent",
              "total_losses_setoff",
              "losses_remaining"
            ],
            "rows": [
              [
                "business_and_profession",
                "non_speculative",
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ],
              [
                "other",
                "other_exempt_income",
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0,
                0
              ]
            ]
          }
        ]
      }
    ]
  }
}

Headers

Authorization
string
required

Bearer token for user-level authorization.

x-api-key
string
required

Your API key used to authenticate and authorize the request.

Query Parameters

financial_year
string

Body

application/json
name
string
@entity
string
sheets
object[]

Response

200 - application/json

200 OK

code
integer
data
object