Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 02-08-2008, 03:23 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: How to handle these ETF Transactions

But to record it, you need to deal with the valuation. If they are sitting
on the gains, it's still in the valuations being quoted. So, how to value
the transaction you want to record now without hosing up the portfolio value
if you ever enter a quote for the investment? If you record it now as going
to cash, intending in the future to change it to a reinvest, now you have
the cash and the valuation.

"Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
news:uD1s3ifaIHA.4180[at]TK2MSFTNGP06.phx.gbl...
- quote -

> Cal's comments about an ETF being recorded as a stock notwithstanding,
> shouldn't the transactions above should be pretty easy? Record the
> investment transaction as of the ex date. Record the reinvestment from the
> investment cash account as of the date it takes place. They're treating
> the cash as effectively being yours, even if they didn't give it to you.
> Memos are good.


  #3  
Old 02-08-2008, 01:16 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: How to handle these ETF Transactions

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:unD3lweaIHA.2000[at]TK2MSFTNGP05.phx.gbl...
- quote -

> The real problem you are probably raising implicitly is that the
> fund is passing them on to you as of last year's 1099 forms but will
> not actually distribute them until this year. This is just another
> case where Money can only do so much and cannot substitute for the
> data the FIs send out in the form of 1099s.


Cal's comments about an ETF being recorded as a stock notwithstanding,
shouldn't the transactions above should be pretty easy? Record the
investment transaction as of the ex date. Record the reinvestment from
the investment cash account as of the date it takes place. They're
treating the cash as effectively being yours, even if they didn't give
it to you.

Memos are good.
--
Chris Cowles
Gainesville, FL


  #2  
Old 02-08-2008, 01:06 AM
Miles
Guest
 
Posts: n/a
Default Re: How to handle these ETF Transactions

It is actually a Fund but I classify it as a stock because it lumped together
in Money with other stocks. So what I did is simply "Add Shares" and added 1
share, entered the date...put in a memo and then entered a Sell command as a
2nd transaction. Not how I would like it but I understand that I'm not
really following the rules here, so it will do.

I don't download from my broker into Money, so that's not an issue. You are
right that it is a 2007 1099 and a distribution that took place on in Jan 08.

Thanks for the ideas. I may try changing it to a Mutual Fund but I don't
have any other funds so I'm shying away from this for now.

Miles

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Dick Watson wrote:
> > Sounds potentially like three investment activity transactions. $0.13 per
> > share of Reinvest Dividends, $0.73 per share in Reinvest S-Term Cap Gains,
> > and $7.32 per share in Reinvest L-Term Cap Gains. (Assuming you are set to
> > reinvest distributions.) The real problem you are probably raising
> > implicitly is that the fund is passing them on to you as of last year's 1099
> > forms but will not actually distribute them until this year.

> I suspect the problem is he has the ETF defined as a stock, and
> those Cap Gains transactions are only permitted for funds.
> If he manually enters the transactions, he could change that
> security to be a fund instead of a stock.
> If he downloads then that may not work out. I think it depends on
> whether the ETF security is downloaded as a "stock" or "other".
> If it does not work out changing it to a fund, I would accept the
> distributions as downloaded (dividend probably) and maybe add a
> memo. I would use the 1099s to prepare taxes if this is a taxable
> account. I understand you would probably choose to discontinue
> online operations for the account and make the switch. But I suspect
> you probably would still use the 1099s to do your taxes instead of
> assuming that you could get it all in line even by hand.
> So if Miles decides to change the ETF to a mutual fund from stock,
> he should be ready to restore a backup in case he does not like the
> result. To change to a mutual fund from stock, go to the Details for
> the security. And there may well be no problem.
> > This is just
> > another case where Money can only do so much and cannot substitute for the
> > data the FIs send out in the form of 1099s. If you want to enter them now
> > you can, but since it sounds like they haven't actually paid out a dime or
> > changed their NAV to reflect this, I think your best bet is to do nothing in
> > Money based on this information alone. When they actually distribute
> > something, record what they distribute.
> > > "Miles" <Miles[at]discussions.microsoft.com> wrote in message

> > news:77A8A875-EACD-48A6-857A-1BB8FA0EB5F8[at]microsoft.com...
> > > I own an ETF called IFN and entered the purchase in MS Money Plus Premium.
> > > The details of a recent payout to shareholders is below. How should I
> > > enter
> > > these in MS Money Plus Premium?

>
  #1  
Old 02-08-2008, 12:18 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How to handle these ETF Transactions

In microsoft.public.money, Dick Watson wrote:

- quote -

> Sounds potentially like three investment activity transactions. $0.13 per
> share of Reinvest Dividends, $0.73 per share in Reinvest S-Term Cap Gains,
> and $7.32 per share in Reinvest L-Term Cap Gains. (Assuming you are set to
> reinvest distributions.) The real problem you are probably raising
> implicitly is that the fund is passing them on to you as of last year's 1099
> forms but will not actually distribute them until this year.


I suspect the problem is he has the ETF defined as a stock, and
those Cap Gains transactions are only permitted for funds.

If he manually enters the transactions, he could change that
security to be a fund instead of a stock.

If he downloads then that may not work out. I think it depends on
whether the ETF security is downloaded as a "stock" or "other".

If it does not work out changing it to a fund, I would accept the
distributions as downloaded (dividend probably) and maybe add a
memo. I would use the 1099s to prepare taxes if this is a taxable
account. I understand you would probably choose to discontinue
online operations for the account and make the switch. But I suspect
you probably would still use the 1099s to do your taxes instead of
assuming that you could get it all in line even by hand.

So if Miles decides to change the ETF to a mutual fund from stock,
he should be ready to restore a backup in case he does not like the
result. To change to a mutual fund from stock, go to the Details for
the security. And there may well be no problem.




- quote -

> This is just
> another case where Money can only do so much and cannot substitute for the
> data the FIs send out in the form of 1099s. If you want to enter them now
> you can, but since it sounds like they haven't actually paid out a dime or
> changed their NAV to reflect this, I think your best bet is to do nothing in
> Money based on this information alone. When they actually distribute
> something, record what they distribute.
> "Miles" <Miles[at]discussions.microsoft.com> wrote in message
> news:77A8A875-EACD-48A6-857A-1BB8FA0EB5F8[at]microsoft.com...
> > I own an ETF called IFN and entered the purchase in MS Money Plus Premium.
> > The details of a recent payout to shareholders is below. How should I
> > enter
> > these in MS Money Plus Premium?

 
Old 02-07-2008, 11:49 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How to handle these ETF Transactions

Sounds potentially like three investment activity transactions. $0.13 per
share of Reinvest Dividends, $0.73 per share in Reinvest S-Term Cap Gains,
and $7.32 per share in Reinvest L-Term Cap Gains. (Assuming you are set to
reinvest distributions.) The real problem you are probably raising
implicitly is that the fund is passing them on to you as of last year's 1099
forms but will not actually distribute them until this year. This is just
another case where Money can only do so much and cannot substitute for the
data the FIs send out in the form of 1099s. If you want to enter them now
you can, but since it sounds like they haven't actually paid out a dime or
changed their NAV to reflect this, I think your best bet is to do nothing in
Money based on this information alone. When they actually distribute
something, record what they distribute.

"Miles" <Miles[at]discussions.microsoft.com> wrote in message
news:77A8A875-EACD-48A6-857A-1BB8FA0EB5F8[at]microsoft.com...
- quote -

> I own an ETF called IFN and entered the purchase in MS Money Plus Premium.
> The details of a recent payout to shareholders is below. How should I
> enter
> these in MS Money Plus Premium?



  #-1  
Old 02-07-2008, 08:18 PM
Miles
Guest
 
Posts: n/a
Default How to handle these ETF Transactions

I own an ETF called IFN and entered the purchase in MS Money Plus Premium.
The details of a recent payout to shareholders is below. How should I enter
these in MS Money Plus Premium?

Thanks,

Miles

The India Fund, Inc. Distribution Announcement


NEW YORK, Dec 20, 2007 (BUSINESS WIRE) --
The India Fund, Inc. (NYSE: IFN; the "Fund") announced today that
it has declared a distribution of $8.18 per share payable in cash or
stock pursuant to the Fund's dividend reinvestment and cash purchase
plan on January 14, 2008 to the stockholders of record on December 31,
2007. The ex date of the distribution is December 27, 2007. The
distribution represents the Fund's estimated net investment income and
net capital gains for the 2007 calendar year. This distribution
includes $0.13 per share of net investment income, $0.73 per share in
short-term capital gains and $7.32 per share in long-term capital
gains. Although this distribution is payable in 2008, it will be
treated as having been paid by the Fund and received by the
stockholders as of December 31, 2007.
 

Tags
etf, handle, transactions
Similar Threads
Thread Forum Replies Last Post
How to handle transactions that are accrued monthly and paid annually?
C.W. Parker, Jr.: Does anyone know how to do transactions such as Homeowner's Insurance to pay the premiums in 12 equal payments but is paid when billed by the...
Microsoft Money 12 10-10-2005 10:25 PM
How do I handle this?
confused man: Hello all, I'm using Money 2004, and while I don't have any of my accounts linked via the internet... I do use the update feature every day to...
Microsoft Money 3 02-15-2005 12:21 AM
How to Handle Recording 401k Transactions
BrightGuy: 1. When I get a paycheck, I record it into Money using the Paycheck Deposit form - where you line-item Before and After Tax Deductions. There is a...
Microsoft Money 1 11-07-2004 03:48 AM
How best to handle this?
RHinNC: I make a purchase on a credit card account. I return the item and get a store credit. I then purchase an item using the store credit plus some cash....
Microsoft Money 2 04-23-2004 11:11 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 12:34 AM.