Actual Funding Payment Ledger Resources
Reconcile recorded funding payments separately for each settlement currency.
A funding rate is not an actual payment ledger. This worksheet adds recorded signed cash flows, separates paid from received amounts and flags repeated settlement IDs. It keeps currencies separate so a multi-asset record does not become a meaningless single total.
Actual Funding Payment Ledger
Sum paid and received funding rows in their original currencies and flag duplicate settlement IDs.
Three hypothetical USD records contain −2, +1 and −3. Paid funding totals 5 USD, received funding totals 1 USD and net funding is −4 USD. All three payment IDs are accepted. A later repeated settlement ID is excluded and counted, while a BTC payment would remain in a separate BTC total.
Open the worksheet10 Resources for Funding-Payment Records
Funding-payment records need settlement direction, currency, assessment time and complete ledger coverage. Contract and funding documentation provides context, while exports and spreadsheets help organize actual cash movements.
Compare documented roles using actual payments versus rates, settlement currency, assessment time, ledger coverage, duplicate records. The Telegram channel we promote is disclosed in the first entry.
Read the comparisonPrepare useful inputs
Use actual funding-payment records with distinct settlement IDs, explicit-offset timestamps and a currency for each row. Negative amount_signed means paid and positive means received. Do not relabel trading commissions, transfers or prospective rate calculations as settled funding.
Read results in their proper scope
These are totals of the supplied actual payments. They do not forecast the next rate or assume a permanent assessment schedule. A negative net means paid exceeded received within this file's currency and period; it is not a full trading P&L calculation.
The worked example and method can be read without JavaScript. Running the calculator requires JavaScript; its form values remain in the browser, with no account connection or quote lookup for calculation.
Official sources and scope
The sources document formats, mechanisms or record workflows. The arithmetic and editorial comparison on this page use the supplied worksheet definitions.
- OKX funding mechanism
Funding direction, actual assessments, instrument units and potentially changing intervals; region-specific conditions apply.
Reference checked 2026-10-01. Consult the source for current product rules. - Kraken account history export
Separate trades, ledger and balance exports.
Reference checked 2026-10-01. Consult the source for current product rules. - BitMEX perpetual payout types
Inverse, linear and quanto contracts have different payouts and multiplier units.
Reference checked 2026-10-01. Consult the source for current product rules. - Bybit inverse P&L
Inverse P&L in settlement coin uses reciprocal prices; fees are separate.
Reference checked 2026-10-01. Consult the source for current product rules.