CRYPTODECLARE DERIVATIVES IMPORT GUIDE Supported reporting bases 1. Bybit net Closed P&L CSV Required columns (case-insensitive): category,symbol,orderId,closedPnl,updatedTime Optional: currency,openFee,closeFee,execType Use one record per exported closed-P&L entry. category must be linear or inverse. Use the actual net closedPnl and closing/settlement updatedTime, not cumulative realised-P&L snapshots copied from the position screen. Valid UTC timestamps and Unix millisecond timestamps are supported. Keep unique original order IDs. If a closed-P&L API response stores category outside its list of records, add that same verified response category to each record when exporting it to CSV. Do not guess the category. This supports the specified flattened V5 schema, not every native Bybit order-history layout. Net Closed P&L already includes allocated trading and funding fees. Optional openFee/closeFee amounts are not deducted again. The separate component breakdown is unavailable in this basis. Do not combine net Closed P&L with a separate Bybit funding/component log in the same report. 2. Bybit V5 derivatives transaction-log CSV Required columns (case-insensitive): id,transactionTime,category,symbol,currency,type,cashFlow,funding,fee,change category: linear, inverse or option. type: TRADE, SETTLEMENT or DELIVERY. Include opening-fee records as well as closing and settlement records. currency is the actual settlement currency. Inverse BTCUSD settles in BTC, not USD. Supported USDC option symbols must use USDC settlement. cashFlow excludes trading and funding fees. Positive funding is received; negative funding is paid. Positive fee is an expense; negative fee is a rebate. Every record must satisfy: change = cashFlow + funding - fee. Only the Bybit funding field may be empty for a documented no-funding event. Empty P&L, trading fee or net change is not replaced with zero. Non-zero bonus changes, position moves, additional fee components, spot, transfers, loans and other financial events are not supported by this path. Do not remove unsupported rows from a mixed export to make it appear complete. Provide an appropriate complete derivatives export and separate supported spot histories, or contact support for a dedicated account-ledger review. 3. Exchange-neutral derivatives component CSV Required columns: date,exchange,event,market,settlement_currency,gross_pnl,funding,trading_fee,net_change,record_id event: close, settlement, funding, fee or delivery. Amounts are denominated in settlement_currency, not automatically CHF. net_change = gross_pnl + funding - trading_fee. funding and trading_fee use the same signed conventions described above. Funding-only rows require gross_pnl=0 and trading_fee=0. Fee-only rows require gross_pnl=0 and funding=0. Keep unique, original source record IDs. These are user-prepared values, not an authenticated original exchange export. Prepare this file only from complete, verified settlement records; never invent missing quantities or P&L. 4. Binance futures income history and account-history settlements Flattened income-history CSV columns (case-insensitive): symbol,incomeType,income,asset,time,tranId,tradeId symbol/tradeId may be empty where Binance does not supply them. Original tranId is required and preserved as text, including long numeric IDs. A spaced layout using Time, Symbol, Income Type, Income, Asset, Transaction ID is also recognised. This does not claim every Binance download uses this schema. Supported incomeType values: REALIZED_PNL, FUNDING_FEE, COMMISSION, INSURANCE_CLEAR, COMMISSION_REBATE, FEE_RETURN, DELIVERED_SETTELMENT, TRANSFER and INTERNAL_TRANSFER. Other operations require review; they are not silently discarded. Income is a signed amount in the explicitly exported asset. A negative commission is an expense, a positive commission/rebate a credit. No trading fees are deducted a second time from these separate income events. COIN-M settlement amounts are valued in their actual exported coin, not USDT. For the supported full account-history layout, rows whose Account identifies Futures are recognised for Realized Profit and Loss, Funding Fee, Commission, Fee and the corresponding income-operation spellings above. Transfer Between Main and Futures Wallet is retained from either account. Margin borrowing and repayment, unknown operations, bonuses and conversions still need review. Collateral transfers remain in the ledger with their signed amount, but have zero P&L and do not create spot acquisitions. They do not prove a closing balance or completeness. Where no market symbol is exported the report labels the market BINANCE-FUTURES, rather than inventing a contract. Choose ONE complete Binance derivatives source format. Do not combine futures income history with account-history futures rows, legacy P&L or a manually prepared Binance component template. These may represent the same events. Include all P&L, fee and funding records, not a download filtered to profit only. The Binance income-history API may have a short history window; a successful CSV import is not proof that earlier years have been retrieved in full. Report scope Contract quantities never become spot coin holdings. Derivatives results and available components are shown separately in the PDF. Original settlement currencies, source IDs and signed values remain in the ledger CSV. These are economic results, not an automatic taxable-income or capital-gain exemption. Collateral balances, liabilities and open-position valuations require complete account statements. The overall wealth total is unavailable from P&L records alone, including when combined with supported spot imports. Unverified trade-fill, unified-account and legacy files may still be rejected. Options are supported only through the specified component-log/template basis, not the futures Closed P&L API layout. No claim is made that every futures, margin or options export works automatically. Official documentation: https://developers.binance.com/docs/derivatives/usds-margined-futures/account/rest-api/Get-Income-History https://developers.binance.com/docs/derivatives/coin-margined-futures/account/rest-api/Get-Income-History https://bybit-exchange.github.io/docs/v5/position/close-pnl https://bybit-exchange.github.io/docs/v5/account/transaction-log https://www.bybit.com/en/help-center/article/Profit-Loss-calculations-USDT-Contract