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

Step 1

Make a copy of the Outgoing Transactions CSV Template

Step 2

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)

Step 3

Within Google Sheets navigate to File > Download > Comma-separated values to save this template as a CSV file

Step 4

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.

Did this answer your question?