How can I currently track my cryptocurrency wallet in Quicken.

Safi
Safi Member ✭✭
edited July 2022 in Investing (Windows)
How can I currently track my cryptocurrency wallet in Quicken. Assume I have a wallet with more than five crypto. If quicken does not have this feature, what is the most current practical way in the current quicken version

Best Answer

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    Answer ✓
    I've set up a separate "Coinbase" Account for my crypto with a separate "security" for each coin.  I record my buys to the 6 digits of precision and use the correct "per share" amount for the full 8 digit purchase.  That typically gets me some fairly small dollar rounding error which I record as a cash adjustment + or - and I'll also note the correct 8 decimal place number in the memo.  The few sells I've done  I've recorded in a similar fashion.  Then each day I update the prices of each security.
    I have very few transactions in any given year and this works fine to give me an indication of the total holdings in dollars.  It certainly wouldn't work as well if you were very active and actually using the crypto as "currency", making many small purchases in various cryptos.  In that case it would make more sense to use one of the hardware or software wallets that are available. 

Answers

  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    Hi @Safi,

    Currently, Quicken does not support crypto currency, however it is one of a number of planned improvements that they are currently working on.  Here's a link to an Idea Post tht has additional information but unfortunately no specific date - LINK.

    Obviously, for now, you can track the investment manually and there are a number of websites from which you could download prices as part of your manual tracking.

    Frankx

                            Quicken Home, Business & Rental Property - Windows 10-Home Version

                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -

  • Safi
    Safi Member ✭✭
    Many thanks @Frankx
    If I am going to go manually, what will be the best practice to record in Quicken, assume I will be treating the all wallet of different crypto as one (ex: open one account). Do I just create an asset account and recorded the increase and decrease, or is there other way
  • splasher
    splasher SuperUser ✭✭✭✭✭
    One of the issues currently with trying to track crypto-currencies is that Quicken does not retain enough precision (number of decimal places) to track it accurately.

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Safi
    Safi Member ✭✭
    @splasher what will be the practical way to record cryptocurrencies in Quicken manually. Assume that I will treat multiple crypto in the wallet as one and just going to update my stand manually.
  • splasher
    splasher SuperUser ✭✭✭✭✭
    You could treat it like a cash account and just update the current balance by adding a deposit or a debit of recent changes.
    I'm not aware of any "great" way to track it in Quicken.

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    Answer ✓
    I've set up a separate "Coinbase" Account for my crypto with a separate "security" for each coin.  I record my buys to the 6 digits of precision and use the correct "per share" amount for the full 8 digit purchase.  That typically gets me some fairly small dollar rounding error which I record as a cash adjustment + or - and I'll also note the correct 8 decimal place number in the memo.  The few sells I've done  I've recorded in a similar fashion.  Then each day I update the prices of each security.
    I have very few transactions in any given year and this works fine to give me an indication of the total holdings in dollars.  It certainly wouldn't work as well if you were very active and actually using the crypto as "currency", making many small purchases in various cryptos.  In that case it would make more sense to use one of the hardware or software wallets that are available. 
  • Safi
    Safi Member ✭✭
    @Tom Young thanks for the info
  • LocoMoco10
    LocoMoco10 Member ✭✭
    edited August 2021
    [removed - no soliciting]
  • JeremyGNJ
    JeremyGNJ Member ✭✭
    I have created a way to effectively track crypto prices in quicken, and it's mostly automated once you get it it set up:
    https://github.com/JeremyGNJ/quicken
  • BillOKeefe
    BillOKeefe Member ✭✭
    Hi @JeremyGNJ. I tried your approach, but when I try to import the generated CSV file into Windows Quicken Deluxe (v40.21) it says "no valid prices found to import". I checked the file, and it looks to me like it aligns with the expected format according to Quicken Help, except the Help example shows just 2-digit dates (which suggests this was written a long-long time ago :smile: . So I tried that as well, but I get the same error. Any idea what the problem might be?
  • JeremyGNJ
    JeremyGNJ Member ✭✭
    > @BillOKeefe said:
    > Hi @JeremyGNJ. I tried your approach, but when I try to import the generated CSV file into Windows Quicken Deluxe (v40.21) it says "no valid prices found to import". I checked the file, and it looks to me like it aligns with the expected format according to Quicken Help, except the Help example shows just 2-digit dates (which suggests this was written a long-long time ago :smile: . So I tried that as well, but I get the same error. Any idea what the problem might be?

    Sorry I didnt see this til now.
    Not sure what to tell you. I JUST ran this and it worked for me. My CSV output look like this...do you see the same?

    zzzBTC,29864.04000000,6/4/2022
    zzzBTC,29700.21000000,6/3/2022
    zzzBTC,30452.62000000,6/2/2022


    Only thing I can think to suggest is that I've only run this particular script in powershell 7.x
This discussion has been closed.