Skip to content
futuresignalshub.online / Resources
Practical market worksheet

Actual Funding Payment Ledger

Reconcile recorded funding payments separately for each settlement currency.

Your inputsBrowser calculationCSV export

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.

What this helps you check

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.

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.

Your worksheet

No account connection required

Inputs are processed in your browser by this calculator. There is no quote lookup or file upload for the calculation. Site measurement and consent are handled separately by the site's privacy and consent controls.

CSV schema: settlement_id (text), timestamp (iso8601), currency (text), amount_signed (number). Header required; comma delimiter. Numeric fields use decimal points. Timestamps require Z or a numeric UTC offset. The original input remains unchanged.

Comma-separated CSV with a header. Maximum 500 rows and 200,000 characters.

Interactive calculation requires JavaScript. The method and hypothetical worked example below remain readable.

Hypothetical worked example

Check the example by hand

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.

Accepted payments
3
Duplicate settlement IDs
0
Paid USD
5USD
Received USD
1USD
Net USD
-4USD
Exact example inputs
{
  "csv": "settlement_id,timestamp,currency,amount_signed\na,2026-01-01T00:00:00Z,USD,-2\nb,2026-01-01T08:00:00Z,USD,1\nc,2026-01-01T16:00:00Z,USD,-3"
}

The example is invented to demonstrate the method. It is not a current market quote, a provider's fee schedule or verified trading performance.

How the worksheet works

  1. Negative amount_signed means actual cash paid; positive means cash received.
  2. Keep first valid settlement_id; later IDs duplicated within the file are excluded and explicitly counted/warned.
  3. Per currency: paid=sum(abs(negative amounts)); received=sum(positive amounts); net=received-paid.
  4. Do not add amounts in different currencies; show separate currency rows and warning if more than one.

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.

Boundaries to keep in view

  • Use actual payment records, not funding-rate forecasts or estimated interval counts.
  • No automatic settlement schedule, current rates or currency conversion.
  • Trading fees and transfers must not be mislabeled as funding payments.

Compare resources for this task

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.

10 Resources for Funding-Payment Records

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.