TurboTax will not import Charles Schwab year end tax 10999 information.

[capecoralbill]

I am using H&R blocks tax cut tax prep program, and I cannot import from Charles Schwab, however I did successfully import from etrade, and fidelity brokerage. Is anybody else having trouble, is at Charles schwab's problem,?
I telephoned Charles Schwab and they said it was turbotax's problem. I don't believe them. Anybody else have trouble only with Charles Schwab like I am?

[retiredguy123]

Huh? Are you using H&R Block or TurboTax? But, either way, why not just enter the data manually? It only takes a few minutes.

[fishon]

I don’t know about H&R Block. Turbo tax imported Charles Schwab 1099 with ease.

[Babubhat]

There should be an error reporting button within the program. You should be able to download the data and import it within the brokerage account tax form section

[MSchad]

Turbo Tax imported Charles Schwab fine for me.

[birdiebill]

As said above, enter it manually. I have used TurboTax for 20 years or more. I always have entered 1099's manually, but I enjoy doing that.

[rsmurano]

I had the same problem. I called and turbo tax told me there is a problem and will have to enter the data manually. I have used turbo tax for over 20 years and the last X years I used the automated method of turbo tax to populate all my investment info. Why enter it manually when turbo tax can enter the data? If they don’t fix this I probably won’t use turbo tax next year.

[capecoralbill]

Correct,
I am using the H&R block tax program. But I suspect TurboTax has the same problem. In any event I do some day trading, and my 1099-B statement has hundreds of transactions not practical to be entering them manually.
Thank you for your comments and if anybody has a solution, or another tax program that actually will import the 1099 from Schwab, please let me know.
I think I'll be transferring my stocks over to either etrade or fidelity since I had no problem importing those 1099s

[retiredguy123]

Correct,
I am using the H&R block tax program. But I suspect TurboTax has the same problem. In any event I do some day trading, and my 1099-B statement has hundreds of transactions not practical to be entering them manually.
Thank you for your comments and if anybody has a solution, or another tax program that actually will import the 1099 from Schwab, please let me know.
I think I'll be transferring my stocks over to either etrade or fidelity since I had no problem importing those 1099s
You don't need to enter every transaction. The 1099 totals and consolidates the data into about 5 different categories for the tax forms. The investment company sends you a statement which includes every transaction, but also sends a consolidated 1099, which is easy to enter the required data from manually. It only takes a few minutes to enter the required data.

[collie1228]

I use H&R Block software and it does not import Schwab information. I believe it's because the two parties failed to come to an agreement on the data importation, but don't know that for sure. All I know is that I was able to import the data in 2021 with no problem. Next year I'll look for software that does work. Manual data entry is so 1990.

[NY2TV]

Huh? Are you using H&R Block or TurboTax? But, either way, why not just enter the data manually? It only takes a few minutes.

It might take a few minutes for some people (albeit most people), but for others it is a nightmare to enter every transaction if there are enough of them.

[Bob Thompson]

It was a software issue that was corrected

[CoachKandSportsguy]

I am using H&R blocks tax cut tax prep program, and I cannot import from Charles Schwab, however I did successfully import from etrade, and fidelity brokerage. Is anybody else having trouble, is at Charles schwab's problem,?
I telephoned Charles Schwab and they said it was turbotax's problem. I don't believe them. Anybody else have trouble only with Charles Schwab like I am?

who cares how many years one has been using turbotax, one's experiences with each year's program is as unique as the tt program and the user. I have found bugs in the cloud version, so the software is not infallible. This year, I had to delete an entire return file, and redo it again because of a wrong check box in the review I could not get rid of anywhere. I could not file electronically with this box checked. Don't think that software is perfect or don't think that your experience will be the same for everyone.

I have done both, imported and done by hand. In the latest 2021 turbo tax, there is an option which I used this year, to enter the transaction summary, which retiredguy123 suggests, and then uploaded the pdf version of the year end tax return statement from your brokerage for backup. If they disagree, then they will review the financial document.

The one individual issue is that if you have any sales with no cost basis, which occasionally happens due to spin offs/transfers, etc, In this scenario, you need to enter all manually, or parse out that/those individual transaction(s) from the total and add that manually. you will need to either accept zero as the tax basis, (the IRS will never question that) or enter a cost. If the cost is missing from the brokerage account, then you do you best research for the price. Example would be an inherited stock which would have the price of the stock at the date of the death of the individual. Knowing that you can search for the price of the stock on that day, pick the highest of the day.

Also, the wash sale calculation is a grey area with a vague definition application in some cases. In this case, you may want to change the cost basis or wash sale indicator from the brokerage very conservative, tax compliant method. In this case, individual entry is required and adjustments made.

Good luck, and don't stress, you are a needle in the haystack, there are millions of tax returns, running on fortran or some ancient software.

finance guy

[capecoralbill]

I have done both, imported and done by hand. In the latest 2021 turbo tax, there is an option which I used this year, to enter the transaction summary, which retiredguy123 suggests, and then uploaded the pdf version of the year end tax return statement from your brokerage for backup. If they disagree, then they will review the financial document.

The one individual issue is that if you have any sales with no cost basis, which occasionally happens due to spin offs/transfers, etc, In this scenario, you need to enter all manually, or parse out that/those individual transaction(s) from the total and add that manually. you will need to either accept zero as the tax basis, (the IRS will never question that) or enter a cost. If the cost is missing from the brokerage account, then you do you best research for the price. Example would be an inherited stock which would have the price of the stock at the date of the death of the individual. Knowing that you can search for the price of the stock on that day, pick the highest of the day.

Also, the wash sale calculation is a grey area with a vague definition application in some cases. In this case, you may want to change the cost basis or wash sale indicator from the brokerage very conservative, tax compliant method. In this case, individual entry is required and adjustments made.

Good luck, and don't stress, you are a needle in the haystack, there are millions of tax returns, running on fortran or some ancient software.

finance guy

very helpful thank you.

[SPI_Rick]

I had the same problem. No help from either Turbo Tax or from Schwab. I spent a lot of time looking online at various forums and saw other people having the same problem. I tried several things that were suggested online and this is what finally worked for me:

Log onto the Schwab website.

Go to “Service” > “Security Center”

Scroll down to the place where you see “Third-Party Access to Account Information”

Select “Enable Third-Party Access”. Yes, it may already be selected if you use Quicken or some other application, but just make the selection and then click on “Save”.

See if the download is now working.

This is what worked for me. Some people found that this didn’t work and they needed to do the following also:

If download is still not working, then go back to the “Third-Party Access to Account Information” section and click on the “Disable Third-Party Access”. Click on “Save”. Now re-select “Enable Third-Party Access” again and click on “Save”. See if the download is now working.

[blueash]

..... Example would be an inherited stock which would have the price of the stock at the date of the death of the individual. Knowing that you can search for the price of the stock on that day, pick the highest of the day.

.....

finance guy

I am sure you know a WHOLE LOT more than I do about finance. I don't sign off as finance guy. But your advice on calculation of basis for inherited stock is per Mr Google wrong, and contrary to what I recalled being told when I dealt with an estate.

The correct technique seems not to pick the highest selling price of the date of death which would raise the basis and lower the gain, but rather you are to take the average of the highest and the lowest cost for the date of death, or if the death was on a holiday, calculate that figure for the open market day before and after the death.

google search using "How to determine a stock's date of death value (https://www.google.com/search?q=How+to+determine+a+stock%27s+date+of+deat h+value&sa=X&ved=2ahUKEwijnPiO_Mr2AhUKRzABHapsC4cQ1QJ6BAgpEAE)" has many hits giving this averaging requirement. I found none saying use the biggest number you can find. I did not see any hits to an IRS paper on the issue and perhaps they have not expressed an opinion. But if no opinion why do all the financial websites suggest the same averaging?

to calculate the value of the stock on the date of death, take the average of the highest selling price and the lowest selling price of the stock on that date.

[CoachKandSportsguy]

I am sure you know a WHOLE LOT more than I do about finance. I don't sign off as finance guy. But your advice on calculation of basis for inherited stock is per Mr Google wrong, and contrary to what I recalled being told when I dealt with an estate.

The correct technique seems not to pick the highest selling price of the date of death which would raise the basis and lower the gain, but rather you are to take the average of the highest and the lowest cost for the date of death, or if the death was on a holiday, calculate that figure for the open market day before and after the death.

google search using "How to determine a stock's date of death value (https://www.google.com/search?q=How+to+determine+a+stock%27s+date+of+deat h+value&sa=X&ved=2ahUKEwijnPiO_Mr2AhUKRzABHapsC4cQ1QJ6BAgpEAE)" has many hits giving this averaging requirement. I found none saying use the biggest number you can find. I did not see any hits to an IRS paper on the issue and perhaps they have not expressed an opinion. But if no opinion why do all the financial websites suggest the same averaging?

There are technical rules, and then there is practicality. Given that in most cases, the difference will be a dollar a share or less, the impact on taxes paid / owed will not be significantly questionable for an auditor to flag the issue as an audit issue for the average middle class non professional.

Since the filer is non considered a professional financial licensed and regulated individual, we are not held to the same standard of performance as a brokerage or a CPA, whose license can be at risk. That quote and level of performance is provided to the audience to which the professional and licensed individuals are held. Since the brokerage does not have a cost, its up to the individual.

The more typical scenario is a very long term hold of a dividend reinvested share purchased sale. There are 4 purchases a year with tiny amounts of shares over time, and to further complicate, can be a distribution from an ESOP, which my Wife has, and I have as well. The IRS requires a cost, with the option of various dates. The question is: how accurate will you be for records that may have been lost in the last 40 years. I have exxon stock which i purchased in 1981, dividends reinvested over X years with splits. I will do the best estimate I can if the custodian of the dividend reinvestment program can't provide the cost basis for me.

So here's the essence of my reply: there is always a grey area of what's an acceptable difference in quality between a professional and a non professional. There are differences in personality types for the level of judgmental, Briggs Myers ***J or fourth position, which is presented in the adherence to rules based logic and laws and black and white, binary decision making, as a generalization.

I am not a J, i am a P, or perceiver, and as such, look at all rules as not as absolutes, but as guidelines and if you aren't qualified as a professional you have some lee way in the quality of your work.

And finance is all about the future, and valuations done not based in past accounting, but in the future cash flows and growth projections from today. Totally subjective as the the future is always uncertain. If i signed off as CPA guy, or CFP guy, then i would be licensed and have a different level of care than a non professional.

does that explain the source of my response?
and your MB type must end in J, correct?

[blueash]

There are technical rules, and then there is practicality. Given that in most cases, the difference will be a dollar a share or less, the impact on taxes paid / owed will not be significantly questionable for an auditor to flag the issue as an audit issue for the average middle class non professional.

Since the filer is non considered a professional financial licensed and regulated individual, we are not held to the same standard of performance as a brokerage or a CPA, whose license can be at risk. That quote and level of performance is provided to the audience to which the professional and licensed individuals are held. Since the brokerage does not have a cost, its up to the individual.

The more typical scenario is a very long term hold of a dividend reinvested share purchased sale. There are 4 purchases a year with tiny amounts of shares over time, and to further complicate, can be a distribution from an ESOP, which my Wife has, and I have as well. The IRS requires a cost, with the option of various dates. The question is: how accurate will you be for records that may have been lost in the last 40 years. I have exxon stock which i purchased in 1981, dividends reinvested over X years with splits. I will do the best estimate I can if the custodian of the dividend reinvestment program can't provide the cost basis for me.

So here's the essence of my reply: there is always a grey area of what's an acceptable difference in quality between a professional and a non professional. There are differences in personality types for the level of judgmental, Briggs Myers ***J or fourth position, which is presented in the adherence to rules based logic and laws and black and white, binary decision making, as a generalization.

I am not a J, i am a P, or perceiver, and as such, look at all rules as not as absolutes, but as guidelines and if you aren't qualified as a professional you have some lee way in the quality of your work.

And finance is all about the future, and valuations done not based in past accounting, but in the future cash flows and growth projections from today. Totally subjective as the the future is always uncertain. If i signed off as CPA guy, or CFP guy, then i would be licensed and have a different level of care than a non professional.

does that explain the source of my response?
and your MB type must end in J, correct?

thank you for admitting you were wrong. You present as a professional here and your audience has just been told that you fudge around the edges and hope you don't get caught. Nonetheless, your advice to use the highest value of the day is wrong and an attempt to cheat the tax man and hope you get away with it.

I have absolutely no idea what the stuff about a J guy or a MB type means. I only came here to correct your wrong advice as "finance guy" If you are not a qualified CPA or tax lawyer maybe you should say so when you tell people how to do their taxes which is what you did in your post about a tax return problem. You even advised us that we should ignore the wash sale information the brokerage house sends us as you believe it is a grey area we can override. Pretty specific suggestion to ignore the experts from someone who now says he's not a professional in the field.

[CoachKandSportsguy]

thank you for admitting you were wrong. You present as a professional here and your audience has just been told that you fudge around the edges and hope you don't get caught. Nonetheless, your advice to use the highest value of the day is wrong and an attempt to cheat the tax man and hope you get away with it.

I have absolutely no idea what the stuff about a J guy or a MB type means. I only came here to correct your wrong advice as "finance guy" If you are not a qualified CPA or tax lawyer maybe you should say so when you tell people how to do their taxes which is what you did in your post about a tax return problem. You even advised us that we should ignore the wash sale information the brokerage house sends us as you believe it is a grey area we can override. Pretty specific suggestion to ignore the experts from someone who now says he's not a professional in the field.

no problem, its a free web site, you can type away as you wish.

Just because you may not have ever had to discuss the interpretations of an IRS guidelines and then had to apply it to various situations, doesn't mean that there aren't different interpretations of an IRS accounting rule. Those are legitimate debates which accounting professionals have made when preparing taxes, and not all of them are black and white. Yes, that short sales is a legitimate debate concerning what is or isn't a short sale. Doesn't mean that everything is correct when you are filing out your particular situations. I also didn't state that you should, I stated that there are various interpretations by CPAs and tax preparers, and if you need to because that situation applies to you, that is how you address the problem in turbo tax. Just because you can doesn't mean you that are required.

I have not misrepresented my self as a professional tax return preparation guy, I have merely stated what I have done, and if people don't understand the difference between an accountant, and finance, then that is on them not being professionals. I have associated with CPAs, I have worked with CPAs, I have used turbo tax to do many different types of returns, as others have said here. but I never stated I am a CPA. I also end my posts with various "guys" as the voice of the opinion of how is speaking, as hyperbole as to the quality of the post on the internet. I have often stated that this is an internet bbs and its all :blahblahblah: :blahblahblah: :blahblahblah: If you look at this board as 100% factual, then you might look at the world differently than I do.

You might find this interesting, as understanding the different personality types helps overcome the obvious differences in how each individual looks at the world around them. It will help you understand why individuals have different points of view, not necessarily wrong, but different. Your view of the world is yours, but not everyones.

The Myers & Briggs Foundation - Judging or Perceiving (https://www.myersbriggs.org/my-mbti-personality-type/mbti-basics/judging-or-perceiving.htm)

Its why i am in finance and not in accounting, as accounting is the process of putting all numbers into some proper box per the rules of accounting.

not accounting guy

[retiredguy123]

I would just point out that preparing taxes is not a professional job. You don't need to be a CPA, a tax lawyer, or even have a degree, certification, or license to prepare taxes and to charge a fee for doing it. You just need to get an IRS preparer tax ID number. Even a caveman can do it. In fact, I think that most paid tax preparers do not have any professional qualifications related to taxes. I occasionally do taxes, but I don't charge anything because I don't want to sign the tax return, which is required if you are a paid preparer.

[rsmurano]

FYI: you can import your Charles Schwab info into turbo tax, I just did it. You need to go into Schwab.com, under your name, go to security center, and then all the way down, enable 3rd party access for turbo tax. If it’s enabled, disable it, then enable it. That’s what I did. Then I would disable this function after you import your info into turbo tax.

[manaboutown]

If the cost is missing from the brokerage account, then you do you best research for the price. Example would be an inherited stock which would have the price of the stock at the date of the death of the individual. Knowing that you can search for the price of the stock on that day, pick the highest of the day.

finance guy

Or you could pick the Alternate Valuation Day to possibly pay less tax. It would depend on when the price of the stock was lower. You would still need to average the highest and lowest prices of record for the stock on whichever day you chose for valuation.

"The executor will have the option of valuing the estate on the date of death, or alternately, on the six-month anniversary of death – the latter is, fittingly, referred to as the “Alternate Valuation Date.”"

From: Estate Building Block: Understanding the Alternate Valuation Date (https://www.ellenbecker.com/resource-center/estate/estate-building-block-understanding-the-alternate-valuation-date)