Keep a common reporting unit without losing the original trade

Choose a reporting unit for comparisons and retain the original asset amounts underneath it. A common unit makes a cost worksheet readable; it does not change what was spent, received or charged.

Keep fields for the market identifier, fill time, base quantity, quote quantity, fee amount and fee asset. Add a separate reporting-value field with the valuation source and observation time. Preserve the original export so a later reviewer can reproduce the conversion instead of trusting a rounded total.

A BTC-quoted purchase spends BTC. Its reporting value needs an explicit conversion reference before it can be compared with a USDT-quoted purchase. If the fee was charged in another asset, retain that asset too. Renaming every quote amount as dollars would erase information required to explain the result.

Match the worksheet to the fills and balance movements. Separate execution effects from changes introduced by your valuation time. If the original fill price already captures the execution difference, adding a separate slippage estimate to that same actual spend can double count it.

Use the Bitget hub as the venue context. For a Gate account, the Gate hub provides a separate review starting point. Missing valuation evidence stays blank.