If you only have one entry to make, use the Manual Entry tab. However, if you have several, read on and watch our informative video!

UPDATED 2/28/2020: HOW TO CREATE A CUSTOM CSV STEP-BY-STEP

Custom CSVs are a good way to get unsupported coins, unsupported wallets, or lost/stolen transactions into ZenLedger. If you have any questions after reading this article on when you would use a Custom CSV or manual entry, please let us know by clicking on the support chat!

Recommended editor: Microsoft Excel is NOT RECOMMENDED as it does some strange things with formatting cells, so we recommend using Google Sheets., a free CSV editing software similar to Excel and Mac Numbers.

You can always send us these files in the support chat or email to us at hello@zenledger.io if you get stuck, we're happy to help!

If you need to download a custom CSV template, you can do so here


Please keep in mind:

The IN and OUT are from the perspective of the wallet or account. So if I you are making a custom csv for a wallet and you send 1 BTC to the wallet from Coinbase and then 0.5 BTC out to Binance from your wallet- you would record “ 1.0 BTC IN 0.5 BTC OUT

Timestamp, Column 1:
Must be on UTC. Put this in 24 hr time and no "AM/PM". You will have your best luck doing this in Google Sheets, which has an automatic option for the right timestamp under Format>Number>Date time (see illustration below):

Type, Column 2:
These are the only category options for Column 2. Do not enter "Gift" or "Self Transfer". You can make those changes once the CSV is uploaded.

Types: 'buy', 'receive', 'incoming', 'staking', 'fork', 'airdrop', 'payment', 'mined', 'gift received', 'initial coin offering', 'masternode'
'sell', 'send', 'outgoing', 'gift sent', 'purchase', 'lost', 'stolen'

Did this answer your question?