Reconciling a crypto portfolio means explaining how its balances changed between two dates. This becomes necessary when multiple wallets, exchanges and protocols produce different records. One tool may show a nonexistent loss because a purchase is missing; another may overstate contributions by counting a personal transfer twice.
The goal is not to force the accounts to balance. It is to link movements to evidence, keep uncertainties visible and distinguish a data anomaly from a genuine loss. This guide presents an economic and documentary reconciliation method. It does not replace a tax calculation tailored to a specific jurisdiction or expert advice when a transaction remains legally or technically ambiguous.
In brief
- Quantities should be reconciled before commenting on changes in value.
- A transfer between accounts belonging to the same person is not a new contribution to overall wealth.
- An unexplained difference should remain flagged, never be erased with an invented transaction.
Crypto portfolio reconciliation starts with defining the scope
A multi-wallet strategy can separate different uses, but a wealth statement must bring them back together. The inventory should include the platforms, sub-accounts, addresses, networks and products used during the period. Omitting an account emptied during the year can remove the purchases or transfers that still explain the assets held today.
Setting a start date and an end date, using a common time zone, helps avoid false discrepancies at the boundaries of reporting periods. A late transaction may appear on a different day depending on the interface. The reconciliation should preserve the source timestamp and the chosen convention, rather than arbitrarily moving a transaction into the correct month.
The economic scope matters as much as the technical inventory. Are you reconciling a single exchange or all of one person’s holdings? In the first case, a deposit from that person’s wallet is an inflow to the account. In the second, it may simply be an internal movement. The classification changes with the level of analysis, even though the underlying facts do not.
The inventory must not contain a seed phrase or private key. An address and an account identifier may help with tracking, but can still be sensitive when they link an identity to wealth. Protecting this register like a financial document reduces the risk that accounting work becomes a source of information for fraudsters.
Collect the right records, not just order histories
The differences between Kraken’s ledger transaction history and trade history illustrate a common problem: multiple exports describe complementary dimensions. An order file does not necessarily contain every balance movement. The scope of each source must be identified before building an overall calculation.
Collect all available deposits, withdrawals, executions, fees, rewards and internal transfers. Keep the original files, then work from copies. Downloads should cover the same dates and products. Importing a complete history followed by a second partial export for the same period can create duplicates if the tool does not recognize the identifiers.
Kraken’s documentation also specifies that some ledger exports do not include blockchain addresses or hashes. Additional information must then be retrieved from the deposit or withdrawal details. An internal accounting identifier should not be presented as proof of a public transaction.
For wallets, retain the network, address, token contract and relevant transaction data. The symbol alone can be ambiguous. Two assets with the same ticker may have different contracts, while a wrapped asset may represent a distinct right from the native token. Precise identification must therefore come before adding up quantities.
Reconcile quantities before valuing them in euros
The basic check follows an equation: opening quantity, plus inflows, minus outflows, equals closing quantity. Purchases, sales, fees and rewards must be assigned to these categories without double counting. This asset-by-asset approach helps isolate movement errors before price changes are added, which can make a discrepancy harder to interpret.
Consider a completely fictional example. An account starts with 1 ETH, receives 0.5 ETH and sends 0.4 ETH, with an additional 0.01 ETH fee actually deducted. It should end with 1.09 ETH. If it shows 1.08 ETH, a 0.01 ETH discrepancy remains. Converting it immediately into euros does not explain it; a movement, fee or misunderstood convention must be identified.
Fees may be included in an amount or shown separately, depending on the source. Deducting a fee twice when it has already been deducted artificially lowers the reconstructed balance. Conversely, ignoring a fee paid in another token may reconcile the traded asset while leaving an anomaly in the asset used for payment.
The guide to Ethereum gas fees helps distinguish network costs from the amount transferred. A transaction can move a token while consuming the native asset to pay the fee. The reconciliation must therefore examine every associated change, not just the line bearing the name of the token the user intended to send.
Match transfers without treating them as income
A withdrawal from an exchange to a personal wallet normally has two sides within overall wealth: an outflow and an inflow. Matching them prevents the inflow from being counted as a new contribution and the outflow as a permanent expense. The amount received may differ from the amount debited because of fees; that difference should be preserved as such.
Matching can use the hash, network, addresses, time and quantity. No single criterion is sufficient in every case. Two identical withdrawals made close together may be separate transactions, while one transfer may appear as several accounting entries. The level of certainty should be recorded when a match is based on indications rather than a shared identifier.
Blockchain bridges require a more detailed review. An outflow on one network and an inflow on another may correspond to the same economic transaction, with a different quantity or asset type. Transactions on both sides and the related fees must be retained, rather than automatically classifying the receipt as new income.
A deposit still pending at the closing date can explain a discrepancy between accounts. In that case, documenting an in-transit movement preserves continuity without creating an imaginary additional asset. The reconciliation should be updated when the transaction succeeds or fails, while retaining a record of the status observed on the chosen date.
Classify complex transactions without inventing their nature
A swap generally involves an outflow of one asset and an inflow of another, plus costs. Providing liquidity may produce a token or a position representing rights in a protocol. A token disappearing from a wallet does not therefore always mean it was lost; it may have been committed to another form of position that must be inventoried.
Rewards and distributions should be documented with their quantity, date and mechanism. Any potential tax treatment is a separate analysis. For reconciliation purposes, the immediate task is to explain how the units appeared. Automatically classifying all of them as available profit or assigning them a zero cost basis can later distort performance and acquisition-cost calculations.
Kraken’s ledger-field documentation shows that internal movements may correspond to product changes or technical operations. A debit followed by a credit is not always a sale followed by a purchase. The meaning of each entry type must be understood before applying an automatic classification across all accounts.
When the tool cannot process a transaction, keep an anomaly record with the source, quantities and hypothesis under review. Do not add a manual transaction solely to erase the discrepancy. A documented correction should be reproducible by another person and reversible if new information shows that the interpretation was incorrect.
Value the portfolio and maintain an audit trail
Once quantities have been reconciled, choose a consistent valuation method: currency, time, price source and treatment of assets without a reliable market. Valuing an illiquid token at its last traded price may inflate wealth without any corresponding ability to sell. The lack of a reliable price should remain visible as a limitation, rather than being silently replaced with a flattering estimate.
The BrefCrypto glossary helps distinguish holdings, unit prices and market capitalization. For a portfolio, the closing value should also account for locked positions, claims and assets that are actually accessible. These categories should not be combined without highlighting differences in availability and risk.
Keep a short report covering the scope, sources, reconciliations performed and unresolved discrepancies. Copies of the exports, a correspondence table and a list of corrections are often enough to make the work reusable. The file should explain why a line was changed without relying on the author’s memory.
A successful reconciliation produces more than a final figure. It provides a verifiable explanation of the wealth position and a stronger basis for measuring performance, preparing supporting documents and making a sale decision. When a discrepancy remains, the honest result includes that discrepancy. Transparent accounting is more valuable than a perfectly adjusted total built on hidden assumptions.