Hi there 👋
Want to add another file to Waltio cause your exchange platform or crypto wallet is not supported? Here are the steps to follow :
Summary:
Download the Waltio file format (.XSLX)
This is what it looks like:
💡 Here is a sample Waltio file containing transactions correctly populated, to provide you with a fair example by transaction type.
Here is how to fill it in column by column
Column A: Type
Please choose the type of transaction between :
Deposit
Exchange
Withdrawal
You can find the definitions of each transaction type at the end of this article.
Column B: Date
Choose the date in the specific format herebelow in column B (Date)
31/10/2008 00:00 |
Column C & D: Amount Received & Token Received
Select the amount and the token received in case of a deposit or exchange.
⚠️ Columns containing numbers must be achieved using commas, not periods.
Column E & F: Amount Sent & Token Sent
Choose the amount and token sent in case of withdrawal or exchange.
💡 Amounts sent must be net of fees:
Example: If you made a withdrawal of 10 BCH of which 0.1 are fees, you will need to fill in, 10-0.1 = 9.90 in the "Amount Sent” column and 0.1 in the “Fee” column.
Column G & H: Fees & Fee Token
Select the fee amount and fee token if applicable.
Column I: Exchange / Platform
Indicate the Exchange or Platform in uppercase (ex: BINANCE).
If there are two words, add an underscore(_) (ex: COINBASE_PRO).
👉 You will find the format for each platform in this table.
Column J & K: Description & Labels
Choose a description for your transaction and a Label. It is not mandatory to add this information, as you will be able to do so in your account.
Add it to your Waltio account
Choose “Services” at “My account” page :
Then “Waltio” :
📝 Some additional information about the Waltio file:
1️⃣ The data must be entered in a “raw” way, i.e. without using a calculation formula. When copying and pasting, paste “respecting the destination formatting”. If your file is not correctly read on Waltio, it is probably because of this.
2️⃣ In the Waltio format file, the time must be entered in GMT. In the Waltio interface, we display the time based on the location of your connection. Example: if you add a transaction on December 15, 2021 at 2pm via the Waltio template and are in Paris, in Waltio, it will appear at 1pm.
3️⃣ For margin trading type transactions, you should add a “deposit” if your long or short was profitable by assigning the label “Derivatives Gain”.
You should add a “withdrawal” if your long or short trade ended in a loss by assigning the label “Derivatives Loss”.
4️⃣ You can use Waltio advanced file format if you want to fill in more information (time zone, transaction hash, etc.) on your transactions.
5️⃣ The limit of transactions per file is 10,000. If you add more than 10k transactions to your file, they will not be read.
🪧 Here is the table regarding column I:
Name to be filled in column I |
AKT_IO |
ALGORAND |
ASCENDEX |
AVALANCHE |
BINANCE |
BITCOIN_AVENUE |
BITFINEX |
BITMART |
BITMEX |
BITPANDA |
BITSTAMP |
BITRUE |
BITTREX |
BITVAVO |
BLOCKFI |
BYBIT |
CAKEDEFI |
CELO |
CELSIUS |
CEX_IO |
COINBASE |
COINBASE_PRIME |
COINBASE_PRO |
COINBENE |
COINEX |
COINHOUSE |
COINLIST |
COINLIST_PRO |
COINMERCE |
COINMETRO |
COINTRACKING |
COINZOOM |
COSS |
COSMOSTATION |
CREX24 |
CRONOS |
CRYPTOPAY |
CRYPTO_COM |
ETORO |
FANTOM |
FEEL_MINING |
FTX |
GATE_IO |
HITBTC |
HOTBIT |
HUOBI |
JUST_MINING |
KRAKEN |
KUCOIN_FUTURES |
KUCOIN |
LEDGER_LIVE |
LIQUID |
LIVECOIN |
LYDIA |
MAIAR |
MOONBEAM |
MOONRIVER |
NEXO |
NICEHASH |
OKEX |
PAYEER |
PAYMIUM |
POLONIEX |
PROBIT |
RAINBOW |
REVOLUT |
SOLANA |
STACKINSAT |
SWISSBORG |
TEZOS |
UPHOLD |
VIRWOX |
WALLET_ACALA |
WALLET_ARBITRUM |
WALLET_ASTAR |
WALLET_BLOCKCHAIN_COM |
WALLET_BCH |
WALLET_BSC |
WALLET_BSV |
WALLET_BTC |
WALLET_CARDANO |
WALLET_CENTRIFUGE |
WALLET_CLOVERS |
WALLET_COSMOS |
WALLET_CRUST_SHADOW |
WALLET_DASH |
WALLET_DOGE |
WALLET_ECASH |
WALLET_ERD |
WALLET_ETH |
WALLET_EXODUS |
WALLET_GROESTLCOIN |
WALLET_HARMONY |
WALLET_HECO |
WALLET_KARURA |
WALLET_INTERLAY |
WALLET_KUSAMA |
WALLET_LTC |
WALLET_MATIC |
WALLET_MINA |
WALLET_NEAR |
WALLET_OPTIMISM |
WALLET_OSMOSIS |
WALLET_PARALLEL |
WALLET_PHALA |
WALLET_POLKADEX |
WALLET_POLKADOT |
WALLET_RIPPLE |
WALLET_RONIN |
WALLET_RSK |
WALLET_SAKURA |
WALLET_STELLAR |
WALLET_TERRA |
WALLET_TERRA_2 |
WALLET_TREZOR |
WALLET_TRON |
WALLET_TRUST |
WALLET_UNIQUE |
WALLET_VECHAIN |
WALLET_XDAI |
WALLET_YOROI |
WALLET_ZCASH |
WALLET_ZERION |
WALLET_ZKSYNC |
WIREX |
YIELD |
YOUHODLER |
ZAPPER |
ZEBITEX |
ZELCORE |
If you have any other questions, do not hesitate to contact us via the chat just at the bottom right of your screen! 💬
The Waltio Team