⁦Trading process⁩

⁦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.⁩

استخدم الأداة المجانية

حاسبة مجانية · تعمل في متصفحك

«تسوية صافي الربح والخسارة»

«تحقق من أن إجمالي الربح والخسارة من التداول، والرسوم، والتمويل تفسر التغير الفعلي في الرصيد بعد الإيداعات والسحوبات.»

النتيجة

قم بتشغيل JavaScript للحساب. لا يتم إرسال أي شيء تكتبه إلى SuperQuant.

الرياضيات. صافي الربح والخسارة = الإجمالي − الرسوم ± التمويل ± أخرى. التغير الملاحظ = النهاية − البداية − الإيداعات + السحوبات. أي فرق غير مفسر ويشير إلى حدث مفقود.

ورقة عمل تفاعلية

ورقة عمل البحث الخاصة بك

اكتب مباشرة في الصفحة. يتم حفظ الإجابات تلقائيًا في هذا المتصفح فقط، ويحمل رابط المشاركة هذه الإجابات في الرابط نفسه، وليس عبر خوادمنا أبدًا. حافظ على عدم تضمين معرفات الحسابات وعناوين المحافظ والمفاتيح في الروابط المشتركة.

لم يتم ملء أي شيء بعد

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.

هذا المصدر تعليمي، وليس نصيحة مالية فردية. تبقى مدخلات الآلة الحاسبة في متصفحك. تحقق من وثائق العقد والهامش والرسوم الحالية لمنصتك.