Tax P&L Report

Prepare Tax P&L Report for Crypto Income/loss and Generate JSON


Important Links

API Guide  Free Trial


Request Body Example

{
    "@entity": "workbook",
    "name": "tradebook_workbook",
    "sheets": [
        {
            "name": "crypto_currency_tradebook_sheet",
            "metadata": {},
            "blocks": [
                {
                    "name": "crypto_currency_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "id",
                        "date",
                        "transaction_type",
                        "label",
                        "received_currency",
                        "received_quantity",
                        "price",
                        "price_currency",
                        "price_in_inr",
                        "sent_currency",
                        "sent_quantity",
                        "fees_currency",
                        "fees_amount",
                        "fee_in_inr"
                    ],
                    "rows": [
                        [
                            "32",
                            1677683000000,
                            "buy",
                            null,
                            "CELR",
                            123394.795000000000,
                            227570.920000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "34",
                            1677683460000,
                            "sell",
                            null,
                            null,
                            null,
                            234616.000000000000,
                            "INR",
                            null,
                            "BTC",
                            0.093949513402,
                            null,
                            null,
                            null
                        ],
                        [
                            "35",
                            1677683460000,
                            "buy",
                            null,
                            "BTC",
                            0.093949513402,
                            232269.840000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "36",
                            1677683460000,
                            "sell",
                            null,
                            null,
                            null,
                            227827.570000000000,
                            "INR",
                            null,
                            "CELR",
                            119327.159700000000,
                            null,
                            null,
                            null
                        ],
                        [
                            "37",
                            1677683460000,
                            "buy",
                            null,
                            "USDT",
                            2840.909090909091,
                            250000.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "38",
                            1677683460000,
                            "sell",
                            null,
                            null,
                            null,
                            250000.000000000000,
                            "INR",
                            null,
                            "USDT",
                            2840.909090909091,
                            null,
                            null,
                            null
                        ],
                        [
                            "39",
                            1677683460000,
                            "buy",
                            null,
                            "LTC",
                            32.573217000000,
                            250000.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "40",
                            1677689340000,
                            "buy",
                            null,
                            "BTC",
                            0.167500000000,
                            236282.310000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "41",
                            1677689340000,
                            "sell",
                            null,
                            null,
                            null,
                            238669.000000000000,
                            "INR",
                            null,
                            "BTC",
                            0.167500000000,
                            null,
                            null,
                            null
                        ],
                        [
                            "42",
                            1677689340000,
                            "buy",
                            null,
                            "ZIL",
                            109438.812500000000,
                            250000.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "43",
                            1677683460000,
                            "buy",
                            null,
                            "ICP",
                            513.867215000000,
                            250000.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "44",
                            1677683460000,
                            "sell",
                            null,
                            null,
                            null,
                            174738.000000000000,
                            "INR",
                            null,
                            "USDT",
                            2051.299170616114,
                            null,
                            null,
                            null
                        ],
                        [
                            "45",
                            1677683460000,
                            "buy",
                            null,
                            "USDT",
                            2051.299170616114,
                            172990.620000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "46",
                            1677683460000,
                            "sell",
                            null,
                            null,
                            null,
                            173129.650000000000,
                            "INR",
                            null,
                            "ZIL",
                            74553.897500000000,
                            null,
                            null,
                            null
                        ],
                        [
                            "48",
                            1677683460000,
                            "buy",
                            null,
                            "LUNA2",
                            2202.990000000000,
                            264808.209960000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "50",
                            1677628800000,
                            "receive",
                            "other_income",
                            "BTC",
                            0.000020180000,
                            2300000.84,
                            "INR",
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "51",
                            1677628800000,
                            "receive",
                            null,
                            "BTC",
                            0.000001640000,
                            4.016442000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "52",
                            1677628800000,
                            "receive",
                            "gift",
                            "BTC",
                            0.000152260000,
                            2500000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "53",
                            1677628800000,
                            "receive",
                            "airdrop",
                            "LUNA2",
                            0.000069648000,
                            0.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "54",
                            1677628800000,
                            "receive",
                            "staking_reward",
                            "ADA",
                            0.013368138318,
                            0.000000000000,
                            "INR",
                            null,
                            null,
                            null,
                            null,
                            null
                        ],
                        [
                            "54",
                            1677628800000,
                            "send",
                            "staking",
                            null,
                            null,
                            0.000000000000,
                            "INR",
                            null,
                            "ADA",
                            0.013368138318,
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "crypto_currency_last_traded_price_list",
                    "@entity": "list",
                    "items": [
                        [
                            "BTC",
                            1250888
                        ],
                        [
                            "LUNA2",
                            500
                        ],
                        [
                            "CELR",
                            89
                        ],
                        [
                            "ICP",
                            111
                        ],
                        [
                            "LTC",
                            11000
                        ],
                        [
                            "ZIL",
                            98
                        ]
                    ]
                }
            ]
        }
    ]
}
Language
Click Try It! to start a request and see the response here!