Reconciling Funding Rate Payments Against Your Position History

Funding payments on perpetual contracts arrive quietly. A small debit or credit appears at each funding interval, and over weeks of holding a position those amounts can add up to something you did not plan for. The problem is not that funding exists; it is that most traders never reconcile it. They look at the running profit and loss figure, assume it already includes everything, and move on. When they later try to explain the result, the funding line is the part they cannot reconstruct. This guide sets out a repeatable reconciliation routine that works on Binance, OKX, Bybit and Bitget. It does not tell you what funding rates will be, and it does not tell you whether holding a perpetual position is a good idea. It shows you how to pull the official records, build your own log, match the two, and know when a discrepancy is worth escalating. You will need your position history, your transaction or funding history, and a simple spreadsheet. Treat the exchange's own pages as the source of truth and your log as the thing you are testing against them.

Why funding payments are easy to lose track of

Funding is not a trade. No order appears in your order history, no fill price is recorded, and nothing shows up in the same list as your entry and exit. It is a periodic transfer between long and short holders of a perpetual contract, settled at intervals set by the venue, and it is applied to your position automatically. Because it is automatic, it is also easy to ignore. The balance simply changes. If you only ever look at the unrealised profit and loss figure on the position panel, funding is already baked in and invisible as a separate number.

The second reason it slips is timing. A position opened shortly before a funding timestamp may owe or receive a payment almost immediately, while a position opened just after waits a full interval. If you opened and closed within one interval, you may have paid nothing at all, which itself is worth confirming rather than assuming. Positions that are held across many intervals accumulate many small entries, and small entries are exactly the kind that get skipped when you are scrolling.

Reconciliation matters because funding is a real cost or credit that belongs in your record of how a position performed. Without it, your own notes will disagree with the account, and you will not know which one is wrong. The routine below is deliberately boring: export, log, compare, investigate only what fails to match.

Gather the official records before you build anything

Start inside the exchange rather than in your own spreadsheet. Each venue publishes product documentation and a help centre that explain how funding is calculated and when it is charged, and each provides a transaction or funding history you can filter by contract and date range. On Binance, OKX, Bybit and Bitget, look for the funding fee or transaction history section of the derivatives interface, and check the help centre for the article describing funding mechanics for the specific contract type you traded. Read that article before you interpret any number, because the sign convention and the settlement timing are defined there, not by intuition.

Export or download the funding history for the exact period you want to reconcile. If the interface offers a date filter, set it to cover the full life of the position plus a little margin on both ends, so a payment near the boundary is not cut off. If there is a download option, use it; otherwise copy the rows into a sheet carefully, keeping the timestamp, the contract, the amount and its sign, and any identifier the venue provides. Do not retype amounts by hand if you can avoid it.

Alongside the funding history, collect the position history for the same contract: when it opened, when it closed, size, direction and leverage. Funding applies to open positions, so your log needs to know when the position existed. If you also want to check trading fees at the same time, the official fee schedule for the venue is the right reference, and it is a separate exercise from funding. Keep the two reconciliations apart so a mismatch in one does not confuse the other.

Build a log you can actually compare against

Create one row per funding settlement, not one row per day. Columns should include the settlement timestamp exactly as the venue records it, the contract, your position direction, the position size at that moment, the funding amount with its sign, and a short note on where the figure came from. Add a column for the venue's own record identifier if one exists, and a column for your running total. The running total is the single most useful number in the whole sheet, because it turns a long list of small entries into one figure you can hold against the account.

Next to the venue's figures, add your own independently calculated expectation. You do not need to reproduce the venue's formula exactly to be useful; you need a second number derived from your own inputs. Record the position size you believe was open at that timestamp, the direction, and the rate you observed for that settlement from the venue's published funding information. If your own inputs and the venue's record disagree, that disagreement is the finding, and it is worth writing down before you try to explain it.

Keep the log in a format you will still be able to read months later. A single sheet per contract, with a clear header row and no merged cells, survives far better than notes scattered across a phone. If you trade several contracts, keep them separate and total them at the end rather than mixing rows. The goal is a record that a second person could follow without your help.

Compare, investigate, and know when to stop

Reconcile in this order. First, check that the number of settlements in your log matches the number of settlements in the venue's history for the same period. A missing row is the most common discrepancy and the easiest to fix. Second, check the sign of each amount: a credit recorded as a debit will throw the total off by twice the amount, which is a large and recognisable error. Third, check the timestamps against the periods when your position was actually open. A payment dated when you held nothing is a signal to look again at when the position closed.

Only after those three checks should you compare totals. If the totals differ, work backwards through the largest single entries first, since a few large settlements explain most mismatches. Common causes are a position that was partially closed before a settlement, a hedge leg that you forgot was open, or a contract you rolled from one expiry or pair to another. Write down the cause you find, even when it is your own bookkeeping error, because the same mistake tends to repeat.

Set a stop condition in advance. If the remaining difference is small relative to the total funding over the period, and you have already traced the large entries, note it and move on rather than spending hours on rounding. If the difference is material, or if a settlement appears that you cannot connect to any position you held, stop adjusting your own sheet and prepare a clear question. Include the contract, the timestamp, the amount, the identifier and your own calculation, and ask through the venue's official support channel. Do not keep editing the log to force a match; that destroys the evidence you need.

Risk boundary: Crypto Fees Hub

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 the funding or transaction history for the full life of the position, with a date range that extends slightly past both the open and the close.
• Read the venue's help centre article on funding mechanics for the exact contract type before interpreting signs or timing.
• Log one row per settlement with timestamp, contract, direction, size, signed amount, source and a running total.
• Count settlements, verify signs, and check timestamps against the periods the position was actually open before comparing totals.
• Trace the largest entries first and record the cause of every mismatch, including your own bookkeeping errors.
• If a material difference remains, stop editing and raise it with official support using the contract, timestamp, amount, identifier and your own calculation.