Outgoing transactions are necessary to account for any crypto that you disposed of outside of trading activity. This includes crypto payments to merchants, paying back interest in crypto, or giving crypto away as a gift to other individuals.
Transfers between wallets should not be entered as outgoing transactions (as you are not disposing of this crypto, you are just moving it around).
Important Note: Use Google Sheets to fill out this template for best results. Excel often formats timestamps incorrectly
Make a copy of the Outgoing Transactions CSV Template
Fill out the template with your outgoing transaction data (All columns are required).
Coin: They ticker symbol of the coin
Amount: The amount of the coin sent in the transaction
Type: The type of outgoing transaction.
Can be either: Payment, Gift, Interest Payment
Timestamp: The UTC timestamp of your transaction
This should be in the format of: mm/dd/yyyy hh:mm:ss
(VERY IMPORTANT to convert your local timestamps to UTC)
Within Google Sheets navigate to File > Download > Comma-separated values to save this template as a CSV file
Within CoinLedger, navigate to 1. Import stage and click Add Account + to open a new Other Account tab. Then, select Upload File and drag the CSV file you just created into the outlined box.
Note - If your formatted spreadsheet is failing to import, please take a look at this troubleshooting help guide.