Bitcoin Forum
April 23, 2014, 07:04:04 PM *
News: Due to the OpenSSL heartbleed bug, changing your forum password is recommended.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Tracking BitCoin in Quicken  (Read 2377 times)
hawks5999
Full Member
***
Offline Offline

Activity: 154


I'll mine til my furnace makes me money...


View Profile

Ignore
June 07, 2011, 11:45:35 PM
 #1

If you like to keep track of all your financial instruments in one program, Quicken goes a long way in meeting that need. However, it can be a little tricky to set up a new instrument such as BitCoin (or physical metals for that matter).

Recently, I started accumulating BitCoin and setup my Quicken to track my purchases and their value. Here's how you can setup your Quicken (and likely other PFM software).

1) Add a new account - the important thing to do here is to setup a Brokerage account under Investing, not a Cash or other type of Spending account. While BTC has properties like Cash - to Quicken it looks like a security.
a) Enter the name of your Brokerage - eg BitCoin. Quicken will try to look up a brokerage but obviously won't find one. So just go with your manually entered name
b) Enter a cash balance and statement date as you might with any brokerage. If you are just getting started with BitCoin, set the date to just before your first purchase and your Cash balance to $0
c) When prompted for securities in the account, add a ticker symbol such as BTC$ (Quicken can't parse the bahtcoin symbol). Again, Quicken will try to look up and fail. Add it manually.
d) Indicate your number of coins. Again, if you are just getting started, put this at 0. We'll add them in later. If prompted, answer No to this being a single mutual fund account.
Done

2) Transfer money into your brokerage account - now for each purchase that make of BTC transfer from the account you purchased with into your Brokerage cash account. This is easy if you used PayPal and are tracking that account also in Quicken. You probably have the PayPal side of the transaction downloaded. Just make it a transfer into your BitCoin account. If you go through LibertyReserve, Dwolla, MoneyBookers, etc. into mt gox or other, just track the cash from your bank account into those accounts as though they are transferring to your BitCoin brokerage.

3) Buy "shares" of BTC - enter the transactions from whatever source where you purchased BTC. Each entry will ask for a share price and number purchased. Pretty straightforward there. You can go into the properties of the BitCoin security and add current pricing since downloads from mt. gox are probably not coming any time soon.

4) Analyze your portfolio - Setup in this fashion you can track the value and cost basis of your BTC.



Notes:

If you play any games of chance, like Double Trouble:http://forum.bitcoin.org/index.php?topic=12096.0 that could generate additional BTC in your portfolio without a purchase per se, you can track the winning using the ReinvDiv entry. Just enter the number of shares gained in the ReinvDiv transaction and it will increase your holdings without adjusting your cost basis.

If you start accumulating "Cash" in your Brokerage due to not having a clear tracking of fees. You can do a MiscExp and track with whatever category you may use. For example, I have a Bank Fee category that I use for such fees.


Hope this helps!

Private Internet Access™ - No logs, Unlimited Bandwidth, PC Magazine's Editor's Choice
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1398279844
Hero Member
*
Offline Offline

Posts: 1398279844

View Profile Personal Message (Offline)

Ignore
1398279844
Reply with quote  #2

1398279844
Report to moderator
1398279844
Hero Member
*
Offline Offline

Posts: 1398279844

View Profile Personal Message (Offline)

Ignore
1398279844
Reply with quote  #2

1398279844
Report to moderator
1398279844
Hero Member
*
Offline Offline

Posts: 1398279844

View Profile Personal Message (Offline)

Ignore
1398279844
Reply with quote  #2

1398279844
Report to moderator
1398279844
Hero Member
*
Offline Offline

Posts: 1398279844

View Profile Personal Message (Offline)

Ignore
1398279844
Reply with quote  #2

1398279844
Report to moderator
Andre Jensen (World Bitcoin Exchange)
Member
**
Offline Offline

Activity: 102



View Profile WWW

Ignore
July 31, 2011, 09:43:40 AM
 #2

If you like to keep track of all your financial instruments in one program, Quicken goes a long way in meeting that need. However, it can be a little tricky to set up a new instrument such as BitCoin (or physical metals for that matter).

Recently, I started accumulating BitCoin and setup my Quicken to track my purchases and their value. Here's how you can setup your Quicken (and likely other PFM software).

1) Add a new account - the important thing to do here is to setup a Brokerage account under Investing, not a Cash or other type of Spending account. While BTC has properties like Cash - to Quicken it looks like a security.
a) Enter the name of your Brokerage - eg BitCoin. Quicken will try to look up a brokerage but obviously won't find one. So just go with your manually entered name
b) Enter a cash balance and statement date as you might with any brokerage. If you are just getting started with BitCoin, set the date to just before your first purchase and your Cash balance to $0
c) When prompted for securities in the account, add a ticker symbol such as BTC$ (Quicken can't parse the bahtcoin symbol). Again, Quicken will try to look up and fail. Add it manually.
d) Indicate your number of coins. Again, if you are just getting started, put this at 0. We'll add them in later. If prompted, answer No to this being a single mutual fund account.
Done

2) Transfer money into your brokerage account - now for each purchase that make of BTC transfer from the account you purchased with into your Brokerage cash account. This is easy if you used PayPal and are tracking that account also in Quicken. You probably have the PayPal side of the transaction downloaded. Just make it a transfer into your BitCoin account. If you go through LibertyReserve, Dwolla, MoneyBookers, etc. into mt gox or other, just track the cash from your bank account into those accounts as though they are transferring to your BitCoin brokerage.

3) Buy "shares" of BTC - enter the transactions from whatever source where you purchased BTC. Each entry will ask for a share price and number purchased. Pretty straightforward there. You can go into the properties of the BitCoin security and add current pricing since downloads from mt. gox are probably not coming any time soon.

4) Analyze your portfolio - Setup in this fashion you can track the value and cost basis of your BTC.



Notes:

If you play any games of chance, like Double Trouble:http://forum.bitcoin.org/index.php?topic=12096.0 that could generate additional BTC in your portfolio without a purchase per se, you can track the winning using the ReinvDiv entry. Just enter the number of shares gained in the ReinvDiv transaction and it will increase your holdings without adjusting your cost basis.

If you start accumulating "Cash" in your Brokerage due to not having a clear tracking of fees. You can do a MiscExp and track with whatever category you may use. For example, I have a Bank Fee category that I use for such fees.


Hope this helps!

can i get this free
hawks5999
Full Member
***
Offline Offline

Activity: 154


I'll mine til my furnace makes me money...


View Profile

Ignore
July 31, 2011, 04:10:32 PM
 #3

Well, you have to buy Quicken or get it free from torrenting (I'm not endorsing this). But the process I describe is clearly free.

HowlingMad
Full Member
***
Offline Offline

Activity: 121


View Profile

Ignore
June 23, 2013, 09:34:51 AM
 #4

Hawks5999,

Thank you for the information.  This helps alot.

Additionally with precious metals this works out to be the same type of 'workaround' although instead of shares it is grams or troy ounces.  If you were to purchase metals in grams and ounces, you would want to setup each as a different stock and enter the prices individually, and not drive yourself insane performing gram/ounce conversions.

Thanks again

I can be found on BTCJam, CoinLenders, BTCT.co, CoinBase, Bitfunder and TripleMining.com

Look for HowlingMad.us later in the 2013! Dead project!
domob
Sr. Member
****
Offline Offline

Activity: 392


View Profile WWW

Ignore
June 23, 2013, 03:39:58 PM
 #5

can i get this free

You can try Gnucash, which is free (as in freedom) software.  It already has precious metals predefined (as all ISO currency codes) as XAU, XAG and co, and you can use bitcoins with some tricks, too.  It works very well for me, both for managing my "ordinary" finances and also keeping track of my bitcoin and PM assets.

Use your Namecoin identity as OpenID: https://nameid.org/
Donations: 1domobKsPZ5cWk2kXssD8p8ES1qffGUCm | ND6yWYKZS9NnMPnfN6C6yZHG8gRe3r69GR
BM-GtQnWM3vcdorfqpKXsmfHQ4rVYPG5pKS | GPG 0x04F7CF52
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!