Home Page link  

Quicken - multiple mutual funds vs Sched B entries

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Quicken - multiple mutual funds vs Sched B entries P.Schuman 02-12-2008
Posted by P.Schuman on February 12, 2008, 4:54 pm
Please log in for more thread options
here's another little nugget... just for reference.

I have in Quicken - these mutual funds - Fidelity, T.Rowe, Vanguard
Fidelity - multiple funds are under one umbrella account
TRP - they force a single account per fund
Vanguard - multiple funds per account

Now - when Importing these over to TurboTax,
the question is:
Does the IRS want to see each fund listed on a single line vs a "total"
ie - the Fidelity & Vanguard entries are "totalled" vs the single lines of
TRP

I went with the line by line -
SO - had to remove/delete the Imported entries for Fidelity & Vanguard,
and then manually create each Sched B (DIV) form for each mutual fund.

--
----------------------------------
"If everything seems to be going well,
you have obviously overlooked something." - Steven Wright



Posted by Oilcan on February 12, 2008, 5:40 pm
Please log in for more thread options
It is always best to report what you receive on the paper - unless you have
a valid reason to breakout (for example a sale of Stock that has long-term
and short-term gains - you would likely receive 1 tax document, but you
would need to break it out).

I don't export data into a tax software. I run a Quicken Category report
and reconcile the paper to that.

Oilcan
> here's another little nugget... just for reference.
>
> I have in Quicken - these mutual funds - Fidelity, T.Rowe, Vanguard
> Fidelity - multiple funds are under one umbrella account
> TRP - they force a single account per fund
> Vanguard - multiple funds per account
>
> Now - when Importing these over to TurboTax,
> the question is:
> Does the IRS want to see each fund listed on a single line vs a "total"
> ie - the Fidelity & Vanguard entries are "totalled" vs the single lines of
> TRP
>
> I went with the line by line -
> SO - had to remove/delete the Imported entries for Fidelity & Vanguard,
> and then manually create each Sched B (DIV) form for each mutual fund.
>
> --
> ----------------------------------
> "If everything seems to be going well,
> you have obviously overlooked something." - Steven Wright
>
>


Posted by P.Schuman on February 12, 2008, 5:59 pm
Please log in for more thread options
My point was that the 1099's list each mutual fund on a separate line in the
account,
with no overall "total" for each columnar set of boxes,
therefore not sure what the IRS wants to see transacribed :
Fidelity total mutual funds - $1,000 div - $900 qual - $78 foreign
tax
or - Fidelty Value fund - $900 - $800 - $0
Fidelity Growth fund - $100 - $100 - $78
etc.....

SO - there is no total on 1099's... unless I manually calculate each
columnar set of boxes
and use that to compare with what Quicken shows... and has Imported into
TurboTax,
which we now know - is mostly wrong for TurboTax purposes.

Anyway - it's all here for future reference and searching via Deja / Google
Groups

Oilcan wrote:
> It is always best to report what you receive on the paper - unless
> you have a valid reason to breakout (for example a sale of Stock that
> has long-term and short-term gains - you would likely receive 1 tax
> document, but you would need to break it out).
>
> I don't export data into a tax software. I run a Quicken Category
> report and reconcile the paper to that.
>
> Oilcan
>> here's another little nugget... just for reference.
>>
>> I have in Quicken - these mutual funds - Fidelity, T.Rowe, Vanguard
>> Fidelity - multiple funds are under one umbrella account
>> TRP - they force a single account per fund
>> Vanguard - multiple funds per account
>>
>> Now - when Importing these over to TurboTax,
>> the question is:
>> Does the IRS want to see each fund listed on a single line vs a
>> "total" ie - the Fidelity & Vanguard entries are "totalled" vs the
>> single lines of TRP
>>
>> I went with the line by line -
>> SO - had to remove/delete the Imported entries for Fidelity &
>> Vanguard, and then manually create each Sched B (DIV) form for each
>> mutual fund. --
>> ----------------------------------
>> "If everything seems to be going well,
>> you have obviously overlooked something." - Steven Wright



Posted by Oilcan on February 12, 2008, 9:51 pm
Please log in for more thread options
Even when I get detail on 1099's, I always have to this point in time gotten
a total. I would call the issuer (if you think it is important) and ask how
it is being reported.

Oilcan

(notes: Fidelity complicates life) (smiles)
> My point was that the 1099's list each mutual fund on a separate line in
> the account,
> with no overall "total" for each columnar set of boxes,
> therefore not sure what the IRS wants to see transacribed :
> Fidelity total mutual funds - $1,000 div - $900 qual - $78 foreign
> tax
> or - Fidelty Value fund - $900 - $800 - $0
> Fidelity Growth fund - $100 - $100 - $78
> etc.....
>
> SO - there is no total on 1099's... unless I manually calculate each
> columnar set of boxes
> and use that to compare with what Quicken shows... and has Imported into
> TurboTax,
> which we now know - is mostly wrong for TurboTax purposes.
>
> Anyway - it's all here for future reference and searching via Deja /
> Google Groups
>
> Oilcan wrote:
>> It is always best to report what you receive on the paper - unless
>> you have a valid reason to breakout (for example a sale of Stock that
>> has long-term and short-term gains - you would likely receive 1 tax
>> document, but you would need to break it out).
>>
>> I don't export data into a tax software. I run a Quicken Category
>> report and reconcile the paper to that.
>>
>> Oilcan
>>> here's another little nugget... just for reference.
>>>
>>> I have in Quicken - these mutual funds - Fidelity, T.Rowe, Vanguard
>>> Fidelity - multiple funds are under one umbrella account
>>> TRP - they force a single account per fund
>>> Vanguard - multiple funds per account
>>>
>>> Now - when Importing these over to TurboTax,
>>> the question is:
>>> Does the IRS want to see each fund listed on a single line vs a
>>> "total" ie - the Fidelity & Vanguard entries are "totalled" vs the
>>> single lines of TRP
>>>
>>> I went with the line by line -
>>> SO - had to remove/delete the Imported entries for Fidelity &
>>> Vanguard, and then manually create each Sched B (DIV) form for each
>>> mutual fund. --
>>> ----------------------------------
>>> "If everything seems to be going well,
>>> you have obviously overlooked something." - Steven Wright
>
>


Posted by Andrew on February 12, 2008, 8:00 pm
Please log in for more thread options
P.Schuman wrote:
> here's another little nugget... just for reference.
>
> I have in Quicken - these mutual funds - Fidelity, T.Rowe, Vanguard
> Fidelity - multiple funds are under one umbrella account
> TRP - they force a single account per fund
> Vanguard - multiple funds per account
>
> Now - when Importing these over to TurboTax,
> the question is:
> Does the IRS want to see each fund listed on a single line vs a
> "total" ie - the Fidelity & Vanguard entries are "totalled" vs the
> single lines of TRP
>
> I went with the line by line -
> SO - had to remove/delete the Imported entries for Fidelity &
> Vanguard, and then manually create each Sched B (DIV) form for each
> mutual fund.

The solution to each of your 5 posts is, as I've said about that many times
also over the years, is simply enter the information from the 1099-DIV and
don't worry about imports from Quicken! You'll spend more time trying to
undo errors than if you simply did it manually. (PS: I would enter each
1099-DIV needs to be entered separately, not to "sum" them. Makes the
computer matching at the IRS much easier.)

Maybe the solution is to DOWNLOAD into Turbotax from Vanguard's website?
Might get the best of both worlds!

--
-------------------------------------------------------------
Regards -

- Andrew



Similar ThreadsPosted
Merge A Mutual Funds November 15, 2006, 7:04 pm
Mutual Funds Winning Guide July 18, 2007, 12:15 am
Mutual Funds Investment Guide August 9, 2007, 1:10 am
Qkn Premier 2006 - Comparing Mutual Funds June 13, 2006, 9:16 pm
Re: Manually posting prices of Mutual Funds April 18, 2008, 1:00 pm
Re: Manually posting prices of Mutual Funds April 18, 2008, 1:04 pm
Import Quicken data into TTax - Sched B & D February 12, 2008, 1:56 am
"Journal Entries" in Quicken April 25, 2006, 12:56 am
Year-end entries Quicken 2007 January 5, 2008, 12:25 am
Bringing Quicken entries up to date after absence January 28, 2008, 8:50 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap