Keeping OKX futures records straight: separating funding, fees and realised results

Spot records are fairly simple: you buy, you sell, you pay a fee. Futures records are messier. A single perpetual position can generate an opening fee, several funding payments in both directions, partial closes, a closing fee and a realised result, all on different dates. If everything is lumped into one column, the monthly total may look right while hiding the fact that funding quietly erased a good trade, or that fees were the largest cost of the month. This guide shows how to export OKX futures history and arrange it into a few clear categories that stay readable months later.

Export the bills, not only the trades

The trade history shows fills, but funding payments and some adjustments appear in the account bill or statement records. Export both for the same period and keep them together. Note the time zone used in each file so that payments around midnight land in the right month. Save the raw files unchanged in a dated folder before editing anything, so you can always return to the original if a formula goes wrong.

Use four columns for every position

For each closed position, record four amounts: realised price result, trading fees, funding received and funding paid. Keep funding received and paid separate rather than netting them, because the pattern matters; a strategy that pays funding every day behaves differently from one that receives it. Add the contract, direction, opening date and closing date. This layout makes it easy to see whether a position was profitable on price but unprofitable after costs.

Reconcile with the account balance

At the end of each month, compare the total of your four columns with the change in your futures account balance, adjusting for deposits and transfers in and out. Small differences often come from rounding or open positions; large ones usually mean a missing export or a transfer you forgot to record. Fix the difference while the month is still fresh in your memory, because reconciling a whole year at once is far harder.

Write a short monthly note

Below the numbers, write two or three sentences: which positions drove the result, how large fees and funding were compared with the realised result, and anything unusual, such as a liquidation or a long hold through high funding. These notes turn the spreadsheet into a record you can learn from and make annual summaries much quicker to prepare.

Risk boundary: OKX Trading Guide

Digital assets are volatile and derivatives can amplify losses. This website has no login, wallet connection, deposit form or customer-support chat. A referral link only records attribution; it does not guarantee access, pricing, rewards, approval or investment results. Availability can differ by residence, legal entity and product, so no regional access is assumed from language or branding alone.

Scenario checkpoint

• Export both the OKX trade history and the bill records covering funding for each month.
• Record realised result, fees, funding received and funding paid in separate columns.
• Reconcile the monthly totals with the futures balance change after transfers in and out.
• Add a short written note explaining what drove each month's futures result.