Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 04-11-2006, 02:46 AM
- Bobb -
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains, MMF buy/sell

Correct - Inv Type = Money Market
I'd attach a gif but I'd get yelled at by the hardliners.

bobb


"Cal Learner" <NoMailTnx[at]please.com> wrote in message
news:3rgl329fcp0stqrtte8ccffr6f57qm0r5t[at]4ax.com...
- quote -

> In microsoft.public.money, - Bobb - wrote:
> > > Yes - it showed all my dividends for past X years as buy/sells on the

> > D-1. Tax consequences were zero , but paperwork -wise it was a mess.
> > I just added a share back to confirm: FDLXX = MMF, but buy/sells =
> > taxable event.

> Just to re-re-confirm.... when you look at the details for FDLXX on
> the details page of Money it says "Money Market" and not "Mutual
> Fund"?


  #6  
Old 04-10-2006, 08:44 PM
Cal Learner
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains, MMF buy/sell

In microsoft.public.money, - Bobb - wrote:

- quote -

> Yes - it showed all my dividends for past X years as buy/sells on the
> D-1. Tax consequences were zero , but paperwork -wise it was a mess.
> I just added a share back to confirm: FDLXX = MMF, but buy/sells =
> taxable event.


Just to re-re-confirm.... when you look at the details for FDLXX on
the details page of Money it says "Money Market" and not "Mutual
Fund"?
  #5  
Old 04-10-2006, 03:54 PM
- Bobb -
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains, MMF buy/sell


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:reok32p530ob05u4s0hg0ib684jq5cpd6b[at]4ax.com...
- quote -

> In microsoft.public.money, - Bobb - wrote:
> > > Thanks as always for your help.

> > It was FDLXX and although a Money Market ( says so in Money
> > description
> > column) , it was always treated as a mutual fund - I don't know why. I
> > finally sold it all to sit as "Cash" in Money. BTW, along the way, I
> > did close it out and delete all records to it and the symbol/name.
> > Then
> > imported again from Fidelity - same thing - shows as money
> > market/cash
> > on Money screen- but not so in tax records, nor in summary screens, so
> > I
> > gave up on it last year. When I would generate a "group by type"
> > report,
> > it was always with the mutual funds, not in the Money Market section.
> > So
> > to know my allocation, would use a calculator to add it to the MMF
> > number.

> So when you went to the Details for the investment it said "Money
> Market" rather than Mutual fund too? Normally that is the clue that
> Money uses to not count Sells as CG. Having a bunch of MMF sales on
> your schedule D will not change your taxes, and in my reading is not
> 'wrong', it can make for some long D-1s.


Yes - it showed all my dividends for past X years as buy/sells on the
D-1. Tax consequences were zero , but paperwork -wise it was a mess.
I just added a share back to confirm: FDLXX = MMF, but buy/sells =
taxable event.

- quote -

> > > Although Cap gains weren't included yesterday when I generated that
> > Export-Tax file, by using Fidelity's downloaded data , I did my taxes
> > last night.

> Good. It was unusual that your broker had all of the data you
> needed for that.


I only had 5 sales and I track lots (for cost basis) with Fidelity, so I
purged my Money data file from TurboTax, told TTax to fetch the info
from Fidelity - entered my Fidelity info and it downloaded into
TurboTax just fine.

Bobb


  #4  
Old 04-10-2006, 01:55 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains reporting

In microsoft.public.money, - Bobb - wrote:

- quote -

> Thanks as always for your help.
> It was FDLXX and although a Money Market ( says so in Money description
> column) , it was always treated as a mutual fund - I don't know why. I
> finally sold it all to sit as "Cash" in Money. BTW, along the way, I
> did close it out and delete all records to it and the symbol/name. Then
> imported again from Fidelity - same thing - shows as money market/cash
> on Money screen- but not so in tax records, nor in summary screens, so I
> gave up on it last year. When I would generate a "group by type" report,
> it was always with the mutual funds, not in the Money Market section. So
> to know my allocation, would use a calculator to add it to the MMF
> number.


So when you went to the Details for the investment it said "Money
Market" rather than Mutual fund too? Normally that is the clue that
Money uses to not count Sells as CG. Having a bunch of MMF sales on
your schedule D will not change your taxes, and in my reading is not
'wrong', it can make for some long D-1s.

- quote -

> I just checked it in my file, and here's the comment I had put
> in the 'Details' of the fund: " Closed this out - showed up as mutual
> fund in records - not money market - Why ? ".


If you are not careful initially when you first download, it can be
treated as a mutual fund. That is because in OFX they are both
refereed to in ....MF tokens. You get one chance to get it right
with a non-default on the first download. It is messy to straighten
it later.


- quote -

> Although Cap gains weren't included yesterday when I generated that
> Export-Tax file, by using Fidelity's downloaded data , I did my taxes
> last night.


Good. It was unusually that your broker had all of the data you
needed for that.

The selection as to whether the long and short term CG are included
in the TFX file are at the bottom of the selection list, if I
remember correctly.

If there is some messiness to deal with, perhaps we can discuss some
of that late in the week.
  #3  
Old 04-10-2006, 01:08 PM
- Bobb -
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains reporting


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:fcij32lfjn72auf8gir02blh2idmln3amo[at]4ax.com...
- quote -

> In microsoft.public.money, - Bobb - wrote:
> > That did work but I had bogus data. Also I then noticed that all
> > sales
> > were reported - including a lot of money market sales. That made the
> > Grand total off by about $100,000 - pretty impressive , huh ? But if
> > you
> > move $10,000 between 5 money markets a few times a year, you might
> > even
> > be off by a million dollars by years end ! Report-wise you'd be a
> > millionaire. Fortunately, the IRS doesn't consider that a taxable
> > event,
> > so I don't know why Money cared.

> That would happen if your MMF was set up as a mutual fund in Money
> rather than an MMF.


Cal,

Thanks as always for your help.
It was FDLXX and although a Money Market ( says so in Money description
column) , it was always treated as a mutual fund - I don't know why. I
finally sold it all to sit as "Cash" in Money. BTW, along the way, I
did close it out and delete all records to it and the symbol/name. Then
imported again from Fidelity - same thing - shows as money market/cash
on Money screen- but not so in tax records, nor in summary screens, so I
gave up on it last year. When I would generate a "group by type" report,
it was always with the mutual funds, not in the Money Market section. So
to know my allocation, would use a calculator to add it to the MMF
number. I just checked it in my file, and here's the comment I had put
in the 'Details' of the fund: " Closed this out - showed up as mutual
fund in records - not money market - Why ? ".

Although Cap gains weren't included yesterday when I generated that
Export-Tax file, by using Fidelity's downloaded data , I did my taxes
last night.


Bobb

  #2  
Old 04-10-2006, 02:57 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains reporting

In microsoft.public.money, - Bobb - wrote:

- quote -

> That did work but I had bogus data. Also I then noticed that all sales
> were reported - including a lot of money market sales. That made the
> Grand total off by about $100,000 - pretty impressive , huh ? But if you
> move $10,000 between 5 money markets a few times a year, you might even
> be off by a million dollars by years end ! Report-wise you'd be a
> millionaire. Fortunately, the IRS doesn't consider that a taxable event,
> so I don't know why Money cared.


That would happen if your MMF was set up as a mutual fund in Money
rather than an MMF.
  #1  
Old 04-10-2006, 01:09 AM
- Bobb -
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains reporting


"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:7pvi32doc6fj4bqe4efuikeu36fgh3qafg[at]4ax.com...
- quote -

> In microsoft.public.money, - Bobb - wrote:
> > That screaming you here is me doing my taxes and looking for data from
> > Money 2004.
> > No cap gains show up on the "Tax-Related Transactions" summary, so I
> > checked categories and Capital Gains show under Investment Income -
> > and
> > I can't change anyhting about it ( boxes are greyed out). Why is it
> > UNDER Inv Income ? Is that something I did or comes that way ? I tried
> > to associate it with LT Cap Gains and Money says 'Nope - can't do
> > that'
> > ! Played a bit and then thought I'd align Cap Gains to Schedule D. My
> > only option to mess with the Schedule D has to do with " Form, Line #
> > ?
> > " Shows 4 options - collectibles, sale of a business, etc
> > > How do I get this program to tell me : HOW MUCH DID I HAVE in

> > Dividends
> > and Cap Gains last year ?

> For dividends, I suggest you use your 1099 data. The data you
> collected in Money is not going to identify what part of the
> dividends are "qualified" for example. I am not saying you should
> not be able to get your dividend data from Money. I am saying it
> would be unusual to have it complete.
> Capital gains info is a different story. That would be something
> everyone would want to get from Money.

=======
Exactly - but I couldn't get the Cap Gains info from Money on the " Tax
Report" page.
=======
- quote -

> For Money 2004, you would want to go to Taxes-> ExportToTaxCut.
> Select the completed year, continue.
> Next select which data to include. Continue.

========
THAT's where I couldn't get it to work properly
========
- quote -

> Then, if you are using TaxCut or TurboTax, *I* would select
> UseTaxSoftware-> ExportYourTaxInformationAsADataFile.... to produce
> the TXF. I would File-> Import that into the tax program.

=========
That did work but I had bogus data. Also I then noticed that all sales
were reported - including a lot of money market sales. That made the
Grand total off by about $100,000 - pretty impressive , huh ? But if you
move $10,000 between 5 money markets a few times a year, you might even
be off by a million dollars by years end ! Report-wise you'd be a
millionaire. Fortunately, the IRS doesn't consider that a taxable event,
so I don't know why Money cared.
=========

- quote -

> > And of that how much goes on Schedule B vs
> > Schedule D . So that I can compare my cost basis of my sales to
> > Fidelity's reporting. Why is Cap Gain income not even mentioned on
> > the
> > TAX REPORTS options in Money (2004 Deluxe) ? I checked report options.
> > > Anyone been here already ? Can you tell me simply - "don't bother -

> > not
> > worth it " or " here's how" ?

> The capital gains report should work for you too. You would need
> both that and the tax related transactions reports. Have you tried
> resetting them?


=========
I ended up purging the Money data from TurboTax when I saw that I had
the option to import directly from my broker. That worked fine and
matched to the penny the ' Sales proceeds ' from a simple " Capital Gain
report " in Money.

Bobb
=========

 
Old 04-09-2006, 11:57 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: M2004 - Cap gains reporting

In microsoft.public.money, - Bobb - wrote:

- quote -

> That screaming you here is me doing my taxes and looking for data from
> Money 2004.
> No cap gains show up on the "Tax-Related Transactions" summary, so I
> checked categories and Capital Gains show under Investment Income - and
> I can't change anyhting about it ( boxes are greyed out). Why is it
> UNDER Inv Income ? Is that something I did or comes that way ? I tried
> to associate it with LT Cap Gains and Money says 'Nope - can't do that'
> ! Played a bit and then thought I'd align Cap Gains to Schedule D. My
> only option to mess with the Schedule D has to do with " Form, Line # ?
> " Shows 4 options - collectibles, sale of a business, etc
> How do I get this program to tell me : HOW MUCH DID I HAVE in Dividends
> and Cap Gains last year ?


For dividends, I suggest you use your 1099 data. The data you
collected in Money is not going to identify what part of the
dividends are "qualified" for example. I am not saying you should
not be able to get your dividend data from Money. I am saying it
would be unusual to have it complete.

Capital gains info is a different story. That would be something
everyone would want to get from Money.


For Money 2004, you would want to go to Taxes-> ExportToTaxCut.
Select the completed year, continue.

Next select which data to include. Continue.

Then, if you are using TaxCut or TurboTax, *I* would select
UseTaxSoftware-> ExportYourTaxInformationAsADataFile.... to produce
the TXF. I would File-> Import that into the tax program.

Using another method, I would select FileByHand-> PrintAReport....



- quote -

> And of that how much goes on Schedule B vs
> Schedule D . So that I can compare my cost basis of my sales to
> Fidelity's reporting. Why is Cap Gain income not even mentioned on the
> TAX REPORTS options in Money (2004 Deluxe) ? I checked report options.
> Anyone been here already ? Can you tell me simply - "don't bother - not
> worth it " or " here's how" ?


The capital gains report should work for you too. You would need
both that and the tax related transactions reports. Have you tried
resetting them?
  #-1  
Old 04-09-2006, 07:40 PM
- Bobb -
Guest
 
Posts: n/a
Default M2004 - Cap gains reporting

That screaming you here is me doing my taxes and looking for data from
Money 2004.
No cap gains show up on the "Tax-Related Transactions" summary, so I
checked categories and Capital Gains show under Investment Income - and
I can't change anyhting about it ( boxes are greyed out). Why is it
UNDER Inv Income ? Is that something I did or comes that way ? I tried
to associate it with LT Cap Gains and Money says 'Nope - can't do that'
! Played a bit and then thought I'd align Cap Gains to Schedule D. My
only option to mess with the Schedule D has to do with " Form, Line # ?
" Shows 4 options - collectibles, sale of a business, etc

How do I get this program to tell me : HOW MUCH DID I HAVE in Dividends
and Cap Gains last year ? And of that how much goes on Schedule B vs
Schedule D . So that I can compare my cost basis of my sales to
Fidelity's reporting. Why is Cap Gain income not even mentioned on the
TAX REPORTS options in Money (2004 Deluxe) ? I checked report options.

Anyone been here already ? Can you tell me simply - "don't bother - not
worth it " or " here's how" ?

Thanks,
Bobb


 

Tags
cap, gains, m2004, reporting
Similar Threads
Thread Forum Replies Last Post
Capital Gains Reporting on Tax Deferred Accounts
cscsc: I am using Money 2004. When I produce an Income and Expense Report the Capital Gains from my tax deferred accounts are mixed in with the data from...
Microsoft Money 2 08-13-2005 12:04 AM
Capital Gains reporting error
btropea: I have Money 2004 and sold a mutual fund with long term gains, short term gains and reinvested dividends. I click reports--> taxes --> capital...
Microsoft Money 2 02-01-2005 04:35 AM
Reporting Bugs - Help
Doug: I've had it with dealing with MS Money support. I've identified an obvious bug in MS Money 2005 Small Business with printing checks. I'm 99%...
Microsoft Money 3 10-25-2004 01:58 PM
Investment Reporting
Paul Keller: Is there a standard report in 2004 or can a custom report be created to compare investment performance to an index?
Microsoft Money 1 02-08-2004 09:26 PM
reporting capital gains
tictoc: How do I get an investment accout to be included on the capital gains report? One transaction does not appear and i know you have to check...
Microsoft Money 1 11-22-2003 09:49 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:16 PM.