1 - list too long. Treasury Direct, unlike Legacy Treasury Direct, handles
reinvestments of T-Bills as completely separate transactions: maturation of
one unique security, purchase of another. (Which, of course, is what a
reinvetment is). I figure there's no need to identify each one as
unique --at the end of a year, I would have 20+ unique securities and 40+
unique capital transactions. Why clutter up Money with such data? So, I use
the generic approach. (FWIW, I used to track the bills separately).
2. Your approach works well -- personally, I wouldn't do it (most of my
transactions are reinvestments: money coming into and out of my checking
account on the same day), but everyone's different.
3. I export capital transactions from Money to TaxCut and here's where Money
has a problem with T-Bills. You're quite right that the "gain" on a T-Bills
is interest exempt from local taxation. But Money see it as a short-term
capital gain.
(http://support.microsoft.com/default...b;en-us;823031 documents
the problem, but the resolution I suggest there doesn't work). So I exclude
my Treasury Direct account from the export to Taxcut and enter the 1099
interest directly. But, in order to track the income throughout the year,
I've setup an Excel spreadsheet; for each purchae, I enter the discount rate
and it computes the price and therefore the income. It also computes the
coupon-equivalent yield, which it gets wrong in leap years..........

Hope this helps.

--
Michael Gordon


"ed" <mr.warmth[at]gmail.com> wrote in message
news:cqgki.4104$ZO4.185[at]trndny05...
- quote -

Michael Gordon wrote:
- quote -

Michael Gordon wrote:
- quote -


Hi... Thanks for the answer. I understand what you're saying. I agree
that if Money forces you to keep track of this stuff in Excel means its
support for this stuff is pretty bad. I have a few followups to what you
said:

1. You mentioned that the list gets too long. Do you mean the list of
investments shown inside of the Treasury Direct account? If so - how bad
does it get - how many active bills/notes do you have going on at the
same time? Or do you mean some other list, like the overall list of your
investments that can be seen on the front page?

2. It's true that you can't schedule the purchase in Money since you
don't know what the price will be. What I do is I create a transfer from
my checking account into the TD account at the par value, and add a
Followup Flag to it to alert me of the auction date. On the auction
date, i void or delete the transfer and enter the purchase. The reason I
do this is to make sure the checking acct. reflect the pending
withdrawal. By valuating the initial transfer at par, I make sure to err
on the side of caution - ie it makes it look like there will be less
money in the acct. than there actually would be.

3. Can you please share your methodology of keeping tabs on the taxable
components of this stuff? I never used Money to keep track of tax stuff
(never saw a reason to - my tax data is summed up by the W2 + 1099s and
computed by TaxCut - what do you get out of money that helps with this
process?) And what's the complication - I thought that the bills/notes
are simply exempt from city and state tax? That being said this is the
first year I am doing treasury investment so I've never dealt w. the tax
aspects. Any insight would be great!

Thanks

Coming in late, I stopped identifying individual t-bills for two reasons: 1)
list became too long. 2) Money does such a bad job with the taxable
components of t-bills that I decided I don't need the precision. So, I have
a generic 28-day t-bill (called, unimaginately, "4-week T-bill" that I reuse
for all appropriate transactions. I schedule the purchases in advance via
Treasury Direct, obviously can't schedule the purchases as I don't know the
price, and keep track of maturities and -- most importantly -- taxable
consequences in Excel.
Hope this helps

--
Michael Gordon


"ed" <mr.warmth[at]gmail.com> wrote in message news:9Vzji.21$V35.6[at]trndny03...
- quote -

"ed" <mr.warmth[at]gmail.com> wrote in message
news:u%Vji.373$CJ4.329[at]trndny08...
- quote -


If it were possible to schedule a future investment sale, rather than
just investment purchases, that might serve the purpose. Alas, you
cannot.
--
Chris Cowles
Gainesville, FL

Chris Cowles wrote:
- quote -

Thanks! Not exactly what I was looking for - I don't want to enter all
the dates twice and manage the Advisor FYI date list in paralel with the
bonds, but I was never aware of this set of alert settings - so that's
great. THANKS!

"ed" <mr.warmth[at]gmail.com> wrote in message
news:wUNji.89$CJ4.24[at]trndny08...
- quote -

While not linked directly to the investment, consider use of "Important
Dates" in "Advisor FYI". Look up the latter term in Money Help for
details.
--
Chris Cowles
Gainesville, FL

Concerning your Fidelity account. I have several accounts and treated them
in differing manners. On the Netbenifits side of Fidelity there does not
appear to be a sweep account and the cash account is truly a cash account.
Fidelity Netbenifits does not allow cash in that account and upon a deposit,
it automatically is distributed. I found this to be true of an in plan roll
over from another fund family.

On the commercial side of the house my I have found in my roll over IRA and
also my Roth IRA that if I simply have a comment that the cash is in a
particular fund that Fidelity down loads do not require that Money 2007 have
claimed the money is in the cash account or the shares. The result is that
since it is in cash, Money can not tell me the ROI for that portion of the
investment. Thus if I have a large percentage in the sweep fund as I do on
my stock account, I enter the bond fund then I enter the manual entries to
move the money out of the cash fund and into the bond fund.

Thus it is your choice concerning how you want to use the records of the
sweep fund as to whether you treat it as the cash component of the account
or a separate mutual fund whose performance you want to track.
Art

"ed" <mr.warmth[at]gmail.com> wrote in message news:9Vzji.21$V35.6[at]trndny03...
- quote -

L Cramer wrote:
- quote -

Sorry, it's 2007...

- quote -

Sorry to make confusion - I actually means bills as in 'treasury bills'
not like the gas bill. What I meant is that say I buy a 26 week bill and
specify its maturity to Money. At the end of the 26 weeks, I want to be
reminded that this bill is coming to maturity.

Since you don't keep track of maturities in MS Money i suspect you don't
have the answer to this one, but I thought I'd clarify.

Thanks for your answers!

It would help if you included the version of Money you're using. Some
answers may depend on your version.

1. Treasurys. If you enter them as bonds, simply include the duration and
maturity in the name of the bill/note. I've used "T-Note 2y 10-08," for
example. However, if you rollover many short-term bills, as I do, your list
of matured Treasurys will eventually get mighty long. I've chosen to enter
bills as CDs, with a separate CD for each duration. Then I just buy and
sell them as they rollover. Of course, this won't give you a list by
maturity date. I track that separately.

2. I don't use Money for billing paying or tracking, except for a couple of
things. On the Home page of M2004 one of the custom features you can choose
to display is "Bills and Deposits." It will list upcoming bills (and I
guess deposits) and those recently "auto-entered."

3. The simple answer is no, at least in M2004. I have the same issue with
Vanguard. They tie brokerage accounts to a money market fund. Money
insists on having a separate cash account for each. It makes for additional
manual entries.




"ed" <mr.warmth[at]gmail.com> wrote in message news:9Vzji.21$V35.6[at]trndny03...
- quote -

I have a few unrelated questions:

1. I invest in treasury bills and notes of different maturities. is it
possible to enter investments in Money such that all the bills have the
name T-Bill but each match has its own maturity, and have these
different maturities show up as separate entries in the account?
Alternatively, what's the right way to manage this?

2. I don't think Money takes any steps to alert me that some of my bills
are approaching or in fact are past maturity. Is that a setting
somewhere? It would seem like a reasonable thing to do.

3. I have accounts with Fidelity, where any un-invested cash is kept at
a money market fund (i think this is called a sweep). When I connect to
synch with Fidelity, it know about that fund and it shows on my account.
However, money is also showing a Cash entry in the account. So for
example when I transfer money from a checking account at my bank into
Fidelity, on fidelity's side it shows as an increase in the mmkt fund,
but on Money side the transfer increases the Cash line. It works out in
the end because when i make the purchase of securities, money subtracts
it from cash while fidelity subtracts from the fund, and assuming the
purchase = cash xfer, it nets out. the main inconvenience: when i earn
interest on the mmkt fund, money decides to deposit the dividend into
the cash acct, and u always have to adjust manually. is there a way to
designate the mmkt fund as the cash line for this acct and avoid having
the cash line?

thx