Skip to content
Practical market worksheet

Base, Quote and Third-Asset Fee Worksheet

See which balance actually changes when a fee is charged in base, quote or another asset.

Your inputsBrowser calculationCSV export

Buying 0.1 BTC at 50,000 USD per BTC costs 5,000 USD before fees. If the actual fee is 0.0001 BTC, the base balance increases by 0.0999 BTC and the quote balance decreases by 5,000 USD. The fee's equivalent at that fill price is 5 USD; it is not an additional 5 USD withdrawal.

What this helps you check

A fee quoted in dollars is not always deducted from your dollar balance. A buy can add less base asset, spend extra quote currency, or deduct a third asset. This single-fill worksheet separates those balance changes so an estimated fee value is not mistaken for a second cash deduction.

Separate asset rows are balance movements. The fee equivalent is a valuation for context. If a third-asset price is absent, its deduction remains visible and its quote equivalent says Not supplied. This keeps an unknown exchange rate from becoming a fabricated zero cost.

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.

Unit: base. Use a decimal point; do not use thousands separators.
Unit: quote per base. Use a decimal point; do not use thousands separators.
Unit: fee asset. Use a decimal point; do not use thousands separators.
Unit: quote per fee asset. Optional; blank means not supplied. Use a decimal point; do not use thousands separators.

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

Hypothetical worked example

Check the example by hand

Buying 0.1 BTC at 50,000 USD per BTC costs 5,000 USD before fees. If the actual fee is 0.0001 BTC, the base balance increases by 0.0999 BTC and the quote balance decreases by 5,000 USD. The fee's equivalent at that fill price is 5 USD; it is not an additional 5 USD withdrawal.

Base balance change
0.0999BTC
Quote balance change
-5000USD
Fee equivalent
5USD
Exact example inputs
{
  "side": "buy",
  "quantity": "0.1",
  "price": "50000",
  "fee_amount": "0.0001",
  "fee_currency": "base",
  "base_asset": "BTC",
  "quote_asset": "USD",
  "third_fee_asset": "BNB",
  "third_fee_quote_price": ""
}

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. Buy: base_delta=quantity, quote_delta=-quantity*price. Sell: base_delta=-quantity, quote_delta=quantity*price.
  2. Subtract fee_amount once from the selected fee asset.
  3. Fee equivalent=fee_amount*price if base; fee_amount if quote; fee_amount*third_fee_quote_price if third and a price was supplied.
  4. If third-asset rate is absent, display Fee equivalent as 'Not supplied' and warn; retain the third-asset deduction.

Separate asset rows are balance movements. The fee equivalent is a valuation for context. If a third-asset price is absent, its deduction remains visible and its quote equivalent says Not supplied. This keeps an unknown exchange rate from becoming a fabricated zero cost.

Boundaries to keep in view

  • Price is user supplied; no quote API.
  • This is a balance worksheet, not tax cost basis or a weighted-entry calculator.
  • Fee must be the actual fee, not a duplicate estimate already deducted in supplied net quantities.

Compare resources for this task

A useful fee record identifies the asset deducted, not just a percentage rate. The comparison focuses on the distinction between transaction and ledger records, base and quote units, and the optional valuation of third-asset fees.

10 Resources for Understanding Crypto Fee Currencies

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.

  • Kraken ledger versus trades

    Trade fee estimates differ from actual ledger deductions and currencies.

    Reference checked 2026-10-01. Consult the source for current product rules.
  • Delta transaction CSV template

    Base, quote and fee currencies and explicit time zone; this CSV does not support shorts/margin.

    Reference checked 2026-10-01. Consult the source for current product rules.
  • Koinly custom prices

    User-supplied dated rates; original assets and valuation currency remain distinct.

    Reference checked 2026-10-01. Consult the source for current product rules.

Worksheet definitions and reference review: 1 October 2026. Examples are hypothetical. The calculator processes supplied inputs locally; it does not verify records or fetch current market values.

Main site and channel offer · Learn resources