|
#4
| |||
| |||
| 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
| |||
| |||
| "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
Cal's comments about an ETF being recorded as a stock notwithstanding,> 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. 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
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Dick Watson wrote: - quote - > Sounds potentially like three investment activity transactions. $0.13 per
I suspect the problem is he has the ETF defined as a stock, and> 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. 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? |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |