As featured in The Wall Street Journal, Money Magazine, and more!

How to Track Gold and Silver Bullion in Quicken

This article was written by in Investing. 12 comments.

Despite the convenience of for tracking personal finances, it’s not flexible and in-depth for my needs. I’ve stuck with Quicken as a desktop program for many years. It’s unlikely I’ll move my data to the “cloud” until or a similar service provides all the functions included in Quicken.

Even the desktop version of Quicken isn’t as complete as I’d like. While it is the best overall software for tracking investments, there are a few areas where it still falls short of the ideal tracker. There is no way to track bullion investments. With silver and gold spot prices hitting highs recently and volatility in the dollar, more people are turning to precious metals to stabilize their wealth and protect against inflation.

Banking Deal: Earn 1.75% APY on an FDIC-insured money market account at CIT Bank.

I don’t think now is a great time to invest in gold or silver — the best time would have been when the values were at their lows. Nevertheless, holding bullion in round or bar form is a common investment, and it’s pretty much ignored by Quicken.

Configuring your precious metals account

It’s not too difficult to get around this, though. Start by adding a new investment account, held at a brokerage. Choose the brokerage option even if your gold and silver is kept in a safe in your home, in a safe at a bank, or at a private investment firm. For the name of your brokerage, you can use whatever you like, because your holdings will not be downloaded automatically into Quicken; any changes need to be made manually. I chose “Precious Metals,” but you may choose “Safe at Wells Fargo” or “Harry’s Private Investments and Fine Shoes.”

Give your account a name. I also chose the uninspired “Precious Metals” for the name of my account, but you may be more creative.

I entered a starting date of the beginning of the year for the account, and started with a cash balance of zero. This will allow my purchase of a metal — and in my case, silver — become a transfer into this account.

After entering the starting balance, Quicken asks for investments. In order to track prices, I suggest using ETFs. Even though you are not owning the ETF, you’re owning the underlying investment, using the ETF to track values will save you a lot of effort. Otherwise, whenever you wanted to analyze your net worth, you would need to manually enter gold and silver spot prices. This is one of the situations where the programmers behind Quicken should consider improving the software. Because you can’t define custom investment classes and automatically download prices for metals, the workarounds include using a regular brokerage account and ETF prices.

Enter GLD and SLV if you intend on owning gold and silver. For the security names, enter “Gold – One-Tenth Ounce” and “Silver – One Ounce.” Using these names will help distinguish your investment from other investments you may have in these exchange-traded funds.

The SLV exchange-traded fund tracks the price of one ounce of silver, so you do not need to make any further adjustments. On the other hand, GLD tracks the price of one tenth an ounce of gold, so when you enter your investments, you’ll need to multiply your quantity by ten. For example, if you buy two ounces of gold, you would enter this as a purchase of 20 shares rather than two.

In order to continue configuring the account in Quicken, you’ll need to choose “other” on the next screen to indicate the investments of GLD and SLV are neither stocks nor funds. Indicate that this account will not be a “single mutual fund” account. This will complete the account set-up.

Entering your first transaction

There may be additional fees to consider when you buy gold or silver, and to be complete, all of this information should be recorded in Quicken. If you were to purchase silver from APMEX rather than from your local dealer on foot, you will have to pay for shipping. Once you make the purchase, create a new transaction in your payment account for Quicken. For example, enter a new transaction in your checking account. Split the categories so that the shipping charges are an expense and the remainder is a transfer into your Precious Metals account. By keeping the shipping charge separate, you can more accurate track the performance of your investment. In this example, I transferred $91.86 for the purchase of two one-ounce American Silver Eagles.

Now view your Precious Metals account in Quicken and enter the investment transaction. This is a “Buy – Shares Bought” transaction. Choose the purchase date, the metal, the total ounces, and enter your total price. Make sure to include any investment fees if there are any. I don’t consider the spread between the bid and ask prices fees — this will just be part of your cost basis.

Note: If there is no shipping fee, and the total you pay is the price of the metal like it may be for an in-store purchase, you could skip the transfer from your checking or credit card account and when you enter the purchase in the brokerage account, you could choose to use the cash directly from your other account, making this what Quicken calls a “BoughtX” transaction.

As soon as I entered my transaction, my immediate loss was apparent. Because the price of silver is less than the price I paid per ounce, my $91.86 was reduced to a book value of $76.60. Verifying the most recent spot price on Kitco, an ounce of silver is $39.17, so the downloaded value of the ETF is pretty close. Just by purchasing the silver, I’ve experienced a 16.61% immediate loss. Consider this when you buy your investment. It could take a long time to make up that 16.61%.

One of the reasons for this loss is the high price I paid for the silver. Since I chose American Silver Eagles rather than cheaper silver rounds, I paid a hefty premium over the spot price. When you invest in silver or gold, the main concern should be getting a price as close to spot as possible. That’s possible with APMEX, particularly if you’re willing to buy in bulk.

Before investing in gold and silver, ensure you’re not attracted to metals due to recent hype. While precious metals can be an important part of a portfolio, understand the risks — which, for commodities, often include the opportunity cost of missing out on better performing investments.

See also:

Updated October 16, 2015 and originally published April 5, 2011.

Email Email Print Print
About the author

Luke Landes is the founder of Consumerism Commentary. He has been blogging and writing for the internet since 1995 and has been building online communities since 1991. Find out more about Luke Landes and follow him on Twitter. View all articles by .

{ 12 comments… read them below or add one }

avatar 1 wylerassociate

interesting article, thanks flexo.

Reply to this comment

avatar 2 skylog

good post flexo! i went through something similar a few years ago with microsoft money. i did a few things differently as i simply could not find an accurate ticker symbol for gold or silver. i update them manually. i am also torn on the shipping costs. while they are tallied so i can take them out if i wanted to, i decided to include them into the cost of the investment.

Reply to this comment

avatar 3 Anonymous

American Eagles really suck…..they were intended to be a low cost way for
Americans to own silver or gold, but it seems to me as though you can’t buy them
without paying a hefty NUMISMATIC premium. Dealers are selling them as
proof coins, MS 69 or 70, and swearing up and down that their numismatic value
will skyrocket with high demand….all I want is silver, I don’t care if it’s MS-70,
and neither will the guy you’re trying to buy bread from in a Mad Max world.

Reply to this comment

avatar 4 skylog

you can certainly purchase them ungraded. they will have a slight premium over, say, single ounce bars, but not much. they will also carry that premium upon sale. the premium is also decreased when purchase more per order.

Reply to this comment

avatar 5 Anonymous

Stop trying to buy from dealers. buy directly from the US Mint when the AEs are issued.

Reply to this comment

avatar 6 rewards

What are the reasons to buy more than a small amount in person over buying GLD or SLV? It seems that storing it under the mattress is not an investment but rather an emergency supply like extra water and food.

Reply to this comment

avatar 7 Anonymous

I prefer to create an asset account within quicken and track the value of my coins via an excel spreadsheet. I update the price within Quicken every so often.

Keep in mind the sell price will be less than GLD or SLV. So it’s even worse than you described in the article. There’s a markup when buying and a mark down when selling (transactional fee). In most cases 4-5% the spot price. I prefer to monitoring the sell price of my coins than the buy price since that’s what they are worth on the open market. APMEX shows that info on their web site.

Reply to this comment

avatar 8 Anonymous

Oh also if you are really to be accurate you should include the taxes you have to pay to the government in your profit margin. coins are considered collectables which are taxed at a flat 20%.

Reply to this comment

avatar 9 Anonymous

What category would you use for a positive or negative adjustment?

Reply to this comment

avatar 10 Anonymous

GLD isn’t 1/10 the spot price, in fact it’s much lower than that. For example.. Current spot price for a 1oz AGE is $1668. GLD is priced at ~$162. So you’d be comparing $1620 GLD to $1668.

And as other have pointed out, that’s spot and not taking into account the premium.. It’s bothersome that there is no way for a layman to pull the spot price of gold. Sure, I can look at a chart or pull the price from apmex or or any of hundreds of other places. But that requires taking the time to look it up and enter it and eliminates the ability to create charts and use the data to run different algorithms, etc.

Reply to this comment

avatar 11 Gordon

Please, Please fix Quicken to allow for tracking of bullion prices. You’re already using yahoo stock quotes yet we can’t use the bullion look-up. Please correct this.

Reply to this comment

avatar 12 Bill

Yep, SLV and GLD hasn’t worked in years. I have quicken looking into it right now. I’ll post what we’ve determined to work.

Reply to this comment

Leave a Comment

Note: Use your name or a unique handle, not the name of a website or business. No deep links or business URLs are allowed. Spam, including promotional linking to a company website, will be deleted. By submitting your comment you are agreeing to these terms and conditions.