Bybit Trading Journal - Import Crypto Trades

Bybit traders can import spot, inverse perpetual, and USDT linear perpetual trades into JournalPlus using CSV export — no API key required. Because Bybit splits trade execution data and funding fee data across two separate export files, accurate PnL journaling requires uploading both. JournalPlus is built to handle this dual-file workflow, automatically reconciling funding charges against trade fills to surface the net realized PnL that raw Bybit exports obscure.

Key Features

Dual CSV Import with Funding Fee Reconciliation

Bybit’s trade history CSV records fill prices, quantities, and commissions — but funding fees are stored in a separate funding history file. A trader long BTCUSDT perpetual for 18 hours crosses two funding windows (at 08:00 and 16:00 UTC). At a 0.01% funding rate on a 0.5 BTC position worth $31,000 notional, each cycle costs $3.10 — small per window, but material over multi-day holds. JournalPlus ingests both CSVs together, matches each funding debit or credit to the correct open position using timestamp proximity, and displays net realized PnL. In the example above: $1,250 gross trade profit minus $12.40 in funding = $1,237.60 net, a 39.9% return on the $3,100 margin posted.

Inverse Contract PnL Conversion

BTC/USD inverse perpetuals — Bybit’s original flagship product — are denominated and settled in BTC, not dollars. One contract represents $1 face value, and profit is calculated as: contracts × ($1/entry_price − $1/exit_price). This creates convex PnL behavior: gains grow faster in BTC terms when price rises from a low base. JournalPlus applies this formula on import and converts the BTC result to USD at the exit price, so inverse and linear contracts appear on the same dollar-denominated P&L dashboard without manual conversion.

Unified Trading Account Segmentation

Bybit’s Unified Trading Account, launched in 2022, consolidates margin across spot, USDT linear derivatives, USDC linear derivatives, and inverse derivatives into a single balance pool. The combined export reflects this structure — a single CSV can contain rows for spot BTCUSDT, a USDT-margined ETHUSDT perpetual, and a BTC-margined BTC/USD inverse perpetual side by side. JournalPlus reads the contract type column from each row and segments trades into discrete categories, keeping futures analytics separate from spot performance so neither distorts the other.

Liquidation Event Logging

When a Bybit position is liquidated, the event appears in the trade history export as a forced close with a distinct order type flag. JournalPlus imports these as tagged liquidation entries rather than ordinary closed trades. Traders can filter the journal to view only liquidation events, measure average loss per forced close (useful for evaluating leverage discipline), and compare liquidation frequency against voluntary exit performance over time.

Funding Rate Cost Tracking

During the March 2024 BTC rally to $73,000, funding rates on Bybit BTC-perp spiked above 0.1% per 8-hour cycle — roughly 110% annualized for long holders. A trader long 10 BTC-perp contracts at that rate paid approximately $100 per funding window in carry costs. JournalPlus aggregates total funding paid or received per position and surfaces it as a funding drag metric, making it straightforward to see whether a trade’s edge survived its holding period.

How to Connect Bybit

Step 1: Export Trade History from Bybit

Log into Bybit and navigate to Orders > Order History. Use the contract type filter to select Derivatives (for perpetuals and futures), Spot, or Options — run a separate export for each if your account trades multiple types. Set the date range (Bybit currently allows up to 3 months per export) and click Export to download the trade history CSV. This file contains execution timestamps, symbols, order sides, fill quantities, average fill prices, and commissions.

Step 2: Export Funding History from Bybit

From the same Orders menu, navigate to Funding Fee > Funding History. Apply the identical date range used in Step 1 and export the funding fee CSV. Each row contains the asset, funding rate, contract quantity, and fee amount charged or credited. Without this file, any position held through a funding window will show inflated PnL in JournalPlus.

Step 3: Open JournalPlus CSV Import

In JournalPlus, go to Import > Broker Import and select Bybit from the broker list. The Bybit importer accepts both CSVs in a single session — drag the trade history file and the funding history file into the upload panel simultaneously. JournalPlus detects each file type automatically based on column headers.

Step 4: Review the Reconciliation Preview

Before committing the import, JournalPlus displays a reconciliation preview table. Each position row shows: gross trade PnL (from the trade history file), matched funding charges or credits (from the funding history file), net realized PnL, and contract type. Verify that the net figures align with your Bybit account statement before confirming.

Step 5: Confirm and Tag Trades

Confirm the import. JournalPlus populates the journal with all trades, auto-tagged by contract type. Spot, USDT linear, USDC linear, and inverse trades appear in separate filterable views. Add setup tags, session notes, or emotional state ratings to individual entries to build a searchable trade database over time. For a walkthrough of the CSV import process, see the CSV upload guide.

What Gets Imported

Data Field	Description
Trade Date and Time	Exact execution timestamp in UTC
Symbol	Ticker pair (e.g., BTCUSDT, BTC/USD)
Contract Type	Inverse, USDT linear, USDC linear, or spot
Side	Buy / Sell / Long / Short
Quantity	Number of contracts or base asset units
Average Fill Price	Weighted execution price
Commissions	Maker or taker fees per fill
Realized PnL	Gross PnL from trade history CSV
Funding Fee	Charge or credit from funding history CSV
Order Type	Limit, market, or liquidation

Data requiring manual entry: trade rationale, setup name, emotional state rating, and pre-trade bias. These are entered directly in JournalPlus after import and stored alongside the imported trade data.

Analytics and Insights

Once Bybit trades are imported, JournalPlus calculates a full performance breakdown segmented by contract type. Inverse contract trades show realized PnL in both BTC and USD, along with the BTC price at close used for conversion. USDT and USDC linear trades are dollar-denominated throughout, making comparison straightforward. The P&L calendar view highlights profitable and losing days across the full imported date range, making drawdown periods immediately visible — see the crypto trading journal for an overview of how these metrics apply to crypto-specific trading patterns.

Funding cost analytics surface over multi-day holds. JournalPlus tracks total funding paid versus total funding received per asset, and displays funding drag as a percentage of gross PnL. For traders running long-biased perpetual strategies during high-funding environments, this figure often accounts for 5-15% of gross profit on holds exceeding 48 hours. The data feeds directly into the trade-by-trade P&L breakdown so funding is never hidden inside a gross number.

Liquidation events are flagged separately in performance reports. JournalPlus computes average loss per liquidation, liquidation frequency as a percentage of total closed trades, and compares forced-close losses to voluntary exit performance. This breakdown is particularly useful for futures traders assessing whether their position sizing rules are functioning as intended under leverage.

Frequently Asked Questions

How do I import Bybit trades into a trading journal?

Export two separate CSV files from Bybit — trade history from Orders > Order History and funding history from Orders > Funding Fee > Funding History. Upload both to JournalPlus in a single import session. The importer reconciles them automatically to produce net PnL per position.

Does JournalPlus support Bybit inverse perpetuals like BTC/USD?

Yes. JournalPlus handles BTC-settled inverse contracts using the correct PnL formula and converts realized gains to USD at the exit price. The converted USD figure appears alongside the raw BTC PnL in your journal dashboard.

Why does my Bybit PnL look different in JournalPlus versus the Bybit app?

Bybit’s in-app PnL display and trade history CSV typically show gross trade PnL before funding fees. JournalPlus nets funding charges against trade PnL using the funding history CSV, producing a lower but more accurate net realized PnL figure.

How are funding fees handled when importing Bybit perpetual trades?

Bybit charges funding every 8 hours at 00:00, 08:00, and 16:00 UTC. JournalPlus matches each funding entry to the open position active at that timestamp and adjusts the position’s running PnL accordingly. The final net PnL reflects all funding costs accumulated over the life of the trade.

Can JournalPlus handle Bybit’s Unified Trading Account exports?

Yes. The UTA export includes rows for spot, USDT linear, USDC linear, and inverse derivatives in a single file. JournalPlus reads the contract type column and segments trades accordingly, keeping futures and spot analytics separate so neither distorts the other.