turbotax icon
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Close icon
Do you have a TurboTax Online account?

We'll help you get started or pick up where you left off.

x
Do you have an Intuit account?

Do you have an Intuit account?

You'll need to sign in or create an account to connect with an expert.

JRM1115
Returning Member

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

The website was just what I needed.  Thanks.

 

Grace and Peace,

Jerry

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

To be honest, I read through the whole thread a few times, especially Jack10000's post. However, I still don't quite get it. 

 

I only purchased a few shares, and I was charged less than $1 per month for the management fee for 10 months last year. 

 

Can I just write the cost basis as $0 and the purchase date as the date when the fee is collected to make my life easier? Do I have to adjust the cost basis of the GLD shares that I sold? My hunch is that the cost basis should be lower but I couldn't care about those few dollars if any. 

 

By doing so, I think I am paying a little bit more tax, but that would save me tons of time. However, I do want to make sure that by doing so, I do pay MORE tax than needed. I don't want to own IRS a single penny 🙂

 

Please advise. 

 

 

JRM1115
Returning Member

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

I have no idea what to tell you.  Sorry.

JulieS
Expert Alumni

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

Yes, it is perfectly fine to report your cost basis as $0, if you don't want to do the calculation to find the correct cost basis. 

 

The only important thing to the IRS is that you report the gross proceeds on your tax return.

@czhang4

 

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

@JulieS Thank you very much for the quick reply! Saved me from hours of headache 🙂 

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

I think the person who answered above did not understand your question. 

You could adjust your cost basis of all the shares you own to zero, but then you are paying tax on the entire proceeds.  If you don't care, go for it.  I prefer to pay what I owe, not more than owed. 😉

There is an answer just below here (permalink is not copying for some reason) that provides a short cut (does the calculation, but then you have to know what to do with the numbers).  Look at the table generated by the program and read the explanation below and you'll know how to report the answers on your return: 

 

The web based program links for GLD/SLV (not my program and author doesn't state his/her credentials so user beware, but the numbers I checked for the first few months of one lot were correct) are here... 

 

https://ttlc.intuit.com/community/retirement/discussion/re-what-is-the-proper-way-to-adjust-the-cost...

 

Here's the explanation: 


If you want to know what you actually owe, I restated what I did for the special case of the TD Ameritrade 1099 tables with Cost Basis Factors (CBFs).  The method below is from scratch without the use of the CBFs.  Schwab told me today they don't provide them, despite buying TD Ameritrade.

Click the link to the ETF (GLD or SLV) you are dealing with at the base of this post and read my explanation as you look at the FIRST TABLE (2nd tab at bottom of Excel file).  They provide and example on the SECOND TABLE (Click 3rd tab at bottom of Excel file).

What you get at the end of this for EACH Lot of GLD or SLV:
1. Cost basis of gold/silver sold for that lot for the number of times fees were charged (once a month) added together.
2. Proceeds of gold/silver sold for that lot, also once a month, added together.

3. At the end of the year, you adjust the Cost Basis of the original purchase by the amount in step 1.
4. At the end of the year you adjust the gold/silver held by the amount sold.  Yes, you track the amount of metal you actually own in the trust.  That allows you to do the cost basis calculation for the next tax year.

5. You report the capital gains or losses, long and short term, depending on the dates on the lot purchases (Step 2 minus Step 1 above).  Any gains within a year would be short term, while over a year would be long term (one year plus one or more days).
 
There are TWO major things (THING ONE and THING TWO below) you have to track/report and I lay out each step.  

THING ONE: Crazy but true... You are required to report the capital loss or gain involved in each monthly sale of the ETF (it's the proceeds minus the cost basis of the gold (GLD) or silver (for SLV) sold to pay the fees.  It's crazy yes, but that's the law.  If you have an error of up to about $10 in your return, they probably won't care per one CPA I've spoken to, but I report every dollar just to avoid the hassle.  

STEPS for THING ONE (Cap Gain/Loss Calcs.):
1. The calculation of the cost basis of gold/silver sold is noted below.  Once you have that number, you subtract (the proceeds per share X Number of shares) to get the total proceeds in dollars.  (See the links below to get the gold/silver sold per share and proceeds per share in dollars at the end of each month)
2. Find out if you have a gain or loss:  Proceeds MINUS Cost Basis of gold/silver sold = Capital Gain or Loss, Long Term or short vs. the date of you original buy. 
You have to report long and short term gains/losses separately in Schedule D.

 

Per the spreadsheet instructions (This is from the SLV file, but would be the same for GLD): "Shareholders with several purchases should calculate gain, loss and adjusted basis separately for each purchased lot and then sum up the results of each lot to arrive at the net reportable gain or loss."  You can lump all the cost basis amounts together and all the proceeds together but you have to do it for each lot separately.  Otherwise you may be lumping long term and short term gains.  

THING TWO (Cost Basis Calculation and Carry Forward to Next Year for Each Lot [see addendum at bottom]):

For EACH LOT you buy you can lump the proceeds from the sales together to get a total for the entire year and subtract the sum of all the cost basis amounts to get a net gain/loss and then count that net as a Long term or short term gain/loss.  
 
The second part is that you have to reduce your ORIGINAL cost basis for each lot (total you paid for GLD or SLV) by the amount of gold/silver sold.  That INCREASES your eventual tax due, because the net asset value goes down every time they sell gold/silver to pay the fees for you.  Reducing cost basis increases any gain reported.  

 

STEPS:
1. You calculate the amount of metal you bought originally using the tax info from the website (shares times the metal amount each share represented on that exact day; it's in the table they provide).  (This is doing it from scratch vs. using the cost basis factor shown in the TD Ameritrade 1099; see my earlier post on that above) 
2. You calculate the amount of metal sold for the fees for the given month.  (shares times the oz per share they sold for fees shown in the table at the END OF EVERY MONTH). 
3. You then calculate the FRACTION of your Original Cost Basis the metal in ounces sold for fees represents and multiply that by the ORIGINAL COST BASIS of your shares.  (Metal sold for fees/Metal owned prior to fees) X Original Cost Basis = Cost Basis of that sold for fees).  That's how much you then reduce your cost basis by and it's ALSO the cost basis of shares sold (See above where you subtract that from the proceeds to tell if you had a gain or loss).
4. Original Cost Basis - Cost Basis adjustment in step #3 = New Cost Basis that becomes your new cost basis for the following year.

 

You can report:
1. Short term gains together (use Various for times bought and sold)
2. Long term gains together (same as above).
3. Adjust the cost basis of your position and the ounces of silver and gold you still hold by the amount sold. 

You have fewer ounces of metal left and a lower cost basis every month, but you can use the total per year for each lot.  You have to track that year to year for any lots that you will eventually want to report separately.  What you cannot do it mix long term and short term gain lots.  

Note that that INCREASES your tax due when you sell; it doesn't lower it as I believe you seem to think.  Is it crazy the SEC did not work this out with the brokers and the ETF managers to make this easier?  Yes!  It's crazy they want us to do this, but the above is the way you do it.  

You can find an actual example for GLD and SLV on the iShares website (links below; click on the 2021 Gross Proceeds File. I also shared the way to use the TD Ameritrade "Cost Basis Factors" (in their 1099) in my prior post above.

 

GLD: https://www.ishares.com/us/literature/tax-information/ishares-gold-tax-data-12-31-21.xls

SLV https://www.ishares.com/us/literature/tax-information/slv-trust-letter-2010.pdf 

Don't be confused when they say "no tax is owed by the trust."  You owe it, they don't.  Here is the clearer statement [The ETF (GLD/SLV)] is a "grantor trust for U.S. federal income tax purposes. As a result, the Trust itself is not subject to U.S. federal income tax. Instead, the Trust’s income and expenses “flow through” to the Shareholders. "  It flows to us! Not the way it should be, but the way it is. 

If that helps those without the TD Ameritrade CBFs, please let me know.  😉  The spreadsheet without the TD data is harder to reproduce here than it was for my prior post, because the TD Am. summary eliminates a lot of the calculations.  They tell you the proceeds and cost basis factor, so it makes it much simpler.  

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

@JulieS In my opinion, your answer is incomplete. Please see what I wrote just above.  Thanks. 

By the way, you should improve the way posts appear in these threads.  Sometimes you cannot tell who is replying to whom. 😉

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

You can save yourself a lot of calculations and just use the tools at www.costbasistools.com.  Go to https://www.costbasistools.com/silver/SLV.php for SLV or https://www.costbasistools.com/gold/GLD.php for GLD to determine the cost basis and capital gain/loss for each of the monthly sales transactions, then just enter/edit the information in Turbotax as needed.   These tools will also tell you what the adjusted cost basis is for your shares after subtracting out all of the previous sales.  Much easier than doing all of the calculations yourself.

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

Thanks for posting that, but has it been verified as acceptable to the IRS or vetted by accountants?  There is zero information at the website identifying the credentials of the author etc.  Thanks.  (Norton does say the website is safe, but that's a separate issue.)  I did check the first few lines of the report that came back for an SLV buy I made this year, and they were accurate.  

You do have to understand the process explained in my post above and use the cost basis for the month preceding your sale to calculate the gain/loss on a given lot and how to report the capital gains and losses on the fees.  They need to be reported separately from the gains and losses on shares.

I have only used 2021 data, so I'll have to see how it handles long term vs. short term gains. Does it identify the difference between the two for lots held less than one year for part of the year and over one year for part of the year for example?

Also, I did not see anywhere to enter sales of shares during the year.  Where is that located?  There is nothing in the program for cost basis calculations for SLV for example.  I guess they just expect you to run the program twice if you have one sale and 3 times if you have two sales etc. using a different share number each time (you'd have to treat each sale and the remaining shares separately)?  

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

@Jack100000 

 

Thanks for the detailed explanation! Luckily I used TD ameritrade, so the 1099 B does come with cost factors, though it is probably not perfect.  Can you please help me to check whether what I am thinking below is correct?

 

Assume I bought 100 shares in 02/2021, I paid my first expense on 3/3/2021.  The CBF is 0.three zeros and 339295, the proceed for selling the underlying gold is $5.4, the cost basis I calculated using CBF*(my cost) is close to $5.59, so I actually should report a loss of -$0.19 here. 

 

On 4/7 I paid my second expense. The CBF is 0.three zeros and 344745, so the cost is $5.68, while the reported proceed is $5.6, so again, I claim a loss of -$0.08 here. 

 

Then when I sold these 100 shares in 04/2021, I should deduct that $5.59+$5.68 from the money I paid to make the real cost basis. 

 

Technically, it is a moot action for short term trade, isn't it?

 

The SPDR spec says I need to pro-rate to date, the above calculation did not. The error margin is quite small based on the calculation.

 

 

 

 

 

 

 

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

@Jack100000 

The calculator works with one lot and assumes a buy and hold scenario, so if you have sold some of your holdings along the way, I think you would need to deal with the remaining shares as a new lot.  It doesn't cover complex situations, but I think it could help out a lot of people who still own their original lot and just want to figure out how to report the monthly sales for covering the fund expenses.

It's up to each individual to decide if they want to trust the calculations or not, but I checked them against the calculations that I put together using the documents from the funds in past years and found that they matched, so I'm comfortable with using them for my taxes.

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

hi Jack,

I have 2 questions:

1. if i don't LOWER the cost basis, does it cause me to pay MORE tax?

2. if I have to lower, is it the correct place to do it?

3. say if the fee is $100, then i need to enter -100. Correct?

 

thanks

 

Adjustment.PNG

 

 
GeorgeM777
Expert Alumni

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

We need a little more information about what you are trying to enter.  This is a very long thread, and a previous post concerned a situation where a shareholder bough and held SLV for all of 2021, however, SLV sold silver to pay trust expenses.  The question was then how does the sale of silver affect the cost basis for existing shareholders and how do the existing shareholders report gains/losses, if any, given that the trust sold silver.  

 

Did you buy and hold SLV for all of 2021?  And, are you trying to report the sale of silver by SLV to cover trust expenses?   

 

@craftindo

 

 

 

 

 

 

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

I'm trying to figure this out. What a pain! I imported data from Vanguard and all these under $1 transactions are listed as gross proceeds and asking for a cost basis and date acquired. It's a total of about $9.00. My Fidelity account did the transactions and there are no issues like the one in Vanguard. I'm never holding this SLV ETF again! Anyway, how can I easily deal with this? 

GeorgeM777
Expert Alumni

What is the proper way to adjust the cost basis for the SLV / GLD ETFs that are structured as trusts, and have monthly expenses that show up on your 1099-B?

The following information was obtained from the iShares website and it relates to the iShares Silver Trust (SLV ETF).  The following statement from iShares indicates that trust sale proceeds are not required to be reported.  Sales of this type apparently relate to trust expenses which the trust pays with funds obtained by selling a pro rata share of silver from each trust holder's account.  

Items of Gross Income: The Trust meets the general de minimis test of Reg. §1.671-5(c)(2)(iv)(D). Under this de minimis test, trust sales proceeds must only be reported if distributed to a beneficial owner.  All trust sales proceeds for the calendar year were used to meet trust expenses.  Accordingly, no trust sales proceeds are required to be reported. The Trust had no other items of gross income for the calendar year.

Here is a link to the webpage from which the above information was obtained.

 

iShares Silver Trust

 

@sgbloss 

**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Mark as Best Answer"
message box icon

Get more help

Ask questions and learn more about your taxes and finances.

Post your Question