交易流程

Perpetual execution & PnL reconciliation worksheet

A standardized multi-venue trade accounting ledger to reconcile Binance, Bybit, and Hyperliquid fills, separating gross PnL, fees, and funding carry.

Use the free tool

FREE CALCULATOR · RUNS IN YOUR BROWSER

Net P&L reconciliation

Check that gross trading P&L, fees and funding explain the actual balance change after deposits and withdrawals.

Result

Turn on JavaScript to calculate. Nothing you type is sent to SuperQuant.

Math. Net P&L = Gross − Fees ± Funding ± Other. Observed change = End − Start − Deposits + Withdrawals. Any difference is unexplained and points at a missing event.

INTERACTIVE WORKSHEET

您的研究工作表

Type straight into the page. Answers save automatically in this browser only, and a share link carries them in the link itself, never through our servers. Keep account IDs, wallet addresses and keys out of shared links.

Nothing filled in yet

Blank standardized audit worksheet for multi-exchange perpetual trade accounting. Educational use only; it is not financial advice or a trade recommendation. Keep private API keys, credentials, and confidential personal data out of this file.

1. Trade session overview

Audit batch ID / reconciliation date (UTC):

Accounting period:

Venues audited: Binance USDⓈ-M / Bybit Linear / Hyperliquid L1
Primary settlement currency: USD / USDC / USDT

Exchange fee discount tokens active (e.g., BNB balance deduction):

2. Standardized execution ledger

Venue	Timestamp (UTC)	Order ID / CLOID	Symbol	Side (B/A)	Fill Qty	Fill Price	Role (Maker/Taker)	Fee Paid	Fee Asset	Realized Price PnL	Notes
Binance	2026-10-17 12:00:00	ORD-1001	BTCUSDT	BUY	0.500	65,000.00	Taker	16.25	USDT	0.00	Entry fill
Hyperliquid	2026-10-17 14:30:00	0x3f1a...	SOL	SELL	25.000	180.00	Maker	-0.09	USDC	+125.00	Take profit limit

3. Dedicated funding & carry ledger

Venue	Timestamp (UTC)	Symbol	Position Notional	Funding Rate	Interval	Direction (Paid/Received)	Cash Settlement Amount	Reconciled with Balance?
Bybit	2026-10-17 16:00:00	ETHUSDT	15,000.00	+0.0100%	8h	Paid (Long)	-1.50 USDT	Confirmed
Hyperliquid	2026-10-17 15:00:00	SOL	4,500.00	-0.0035%	1h	Received (Long)	+0.16 USDC	Confirmed

4. Net performance reconciliation formula

Gross Price PnL: sum(Realized Price PnL)
Total Exchange Fees: sum(Maker/Taker Fees converted to USD)
Total Settled Funding: sum(Funding Cash Flows)
Net Trading PnL = Gross Price PnL - Total Fees + Total Settled Funding

Account Starting Balance:

Account Ending Balance:

Discrepancy (Unexplained Variance):

5. Audit sign-off & validation checklist

All timestamps converted to standardized UTC ISO 8601 strings.
Fee deductions in secondary tokens (e.g., BNB) marked to USD spot at execution timestamp.
Funding payments segregated completely from price trade gains/losses.
Maker rebate credits accounted for separately from standard debit fees.
No unexplained balance leakage across withdrawal/deposit transfers.

Strategy, venue and ledger version: Prepared by / date (UTC): Limitations and next review date:

For product-specific limits, read SuperQuant research methodology. This worksheet contains no live venue rates or account results.

Multi-venue perpetual accounting standards

Binance, Bybit, and Hyperliquid use conflicting naming conventions, fee tokens, and funding intervals. Standardizing trade records into an isolated relational format prevents miscalculating net strategy edge. Read the companion guide: How to Reconcile Binance, Bybit, and Hyperliquid Perpetual Fills and PnL.

Three-to-one schema normalization pipeline translating Hyperliquid userFills, Binance userTrades, and Bybit execution/list fields into a canonical audit record. 教学示意图 · 非实时市场数据

Component	Reconciliation rule	Why it matters
Execution fills	Record fill price, exact executed quantity, liquidity role, and timestamp in UTC	Separates maker rebate benefits from taker drag
Fee token valuation	Isolate secondary fee deductions (e.g., BNB) and convert to USD at execution time	Prevents collateral balance distortion
Funding carry	Log every discrete settlement event separately from trade closed PnL	Isolates directional alpha from passive carry yield
Cash reconciliation	Verify: Net PnL = Gross PnL − Fees ± Funding = Δ Balance	Detects unexpected slippage or liquidation penalties

How to reconcile a multi-venue ledger

Export raw fill and transaction histories from each exchange REST API or CSV exporter.
Normalize client identifiers, symbols, and side flags into universal schema.
Convert token-denominated fees into USD reference values.
Sum gross trade PnL, maker/taker fees, and funding settlements separately.
Audit account ending equity against starting equity plus net cash flow.

The worksheet below gives you the same structured ledger to fill in directly on this page.

HOW TO USE THIS RECONCILIATION SHEET

Export fill and cash flow reports from Binance, Bybit, and Hyperliquid into separate files. Map trade timestamps to UTC, convert fee token deductions to USD spot values, and segregate discrete funding events from realized trade PnL.

What does this worksheet include?

Standardized execution fill table, dedicated funding carry ledger, net performance formula checks, and an audit sign-off checklist, all editable on this page. It contains no private keys or live API connections.

This resource is educational, not individualized financial advice. Calculator inputs stay in your browser. Check your venue's current contract, margin and fee documentation.