How do I account for different mutual funds with different percentages of income derived from my state using a consolidated 1099-DIV from my broker?

[gcdc67]

In the past I received separate 1099-DIVs for each fund and TurboTax had me manually divide the information into "NY State" and "All other" sources to get the right answers.

[RobertB4444]

You will probably have to separate it manually it into the same two that you had done previously - New York State and all other.

[gcdc67]

Thanks Robert, the problem is that Vanguard no longer supplies separate 1099-DIVs for each mutual fund, they only provide a single 1099-DIV with all of the data consolidated.

I was hoping the answer would be "TurboTax knows how to use the Document Number to read all the data from Vanguard behind the scenes and magically figure it all out so you don't have to" but I guess that was too much to hope for.

I guess I have to go to Vanguard and ask them how the heck I can either de-consolidate the data or find some hidden way of getting separate 1099-DIVs for the two funds I have where it matters for my NY Taxes.

[FangxiaL]

This file may be of help to answer your questions.

Vanguard TE Interest Dividends by State.

@gcdc67

[gcdc67]

Thank you, they did provide that information, which is part of what you'd need to know to do what I ultimately need to do. But what they are no longer providing is the dollars involved for each fund! It used to be I would just take the dollars of income in Box 1 and split it between NY and non-NY, it took 2 seconds. But they no longer break out the Box 1 information for each fund, they just added all the Box 1 figures for all of my 7 Vanguard mutual funds into one consolidated 1099-DIV. I now realize that this is not a question of how TurboTax can deal with this problem, it can't.

The problem is that Vanguard smashed a bunch of data together which may be fine for filling in your Federal tax forms, but is not specific enough to successfully fill in my NY tax forms. I will have to go to Vanguard to get the 1099-DIV details I need for each fund separately.

[FangxiaL]

If you are looking for tax-exempt interest income, it should be in Box 11 of Form 1099-DIV. On the detail for dividends and distributions pages, you should be able to find the specific amount from each individual fund. Box 1 amount might include some dividends from Treasury obligations, which is deductible from state taxable income. 

@gcdc67

[gcdc67]

Thank you!