All Collections
Adding accounts
Fill in a Waltio file format
Fill in a Waltio file format

For an unsupported account, please find hereunder our template

Updated over a week ago

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

Did this answer your question?