Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 05-19-2007, 09:03 PM
Michael Gordon
Guest
 
Posts: n/a
Default Re: T-Bills in Money

It is a known problem and has been for quite a while now.
http://support.microsoft.com/default...b;en-us;823031 documents it,
but be aware that the workaround I suggested there doesn't work.

--
Michael Gordon


"Mimi" <Mimi[at]discussions.microsoft.com> wrote in message
news:05CD87BB-D3A7-457E-999A-2C4147B64FAD[at]microsoft.com...
- quote -

> Hello!
> I am having a terrible time handling fixed income securities. I am buying
> a
> lot of treasury bills and at their maturity they are considered as
> Investment
> income: Interest.
> I have found no way for the program to flag me for maturities.
> If Money cannot handle Treasury Bills and this is a known problem, Why
> don't they fix it?
> "George" wrote:
> > How does one record a T-Bill purchase and then a redemption in Money so
> > that
> > the interest shows up in the tax reports such as schedule B?



  #6  
Old 05-09-2007, 04:29 PM
Mimi
Guest
 
Posts: n/a
Default RE: T-Bills in Money

Hello!
I am having a terrible time handling fixed income securities. I am buying a
lot of treasury bills and at their maturity they are considered as Investment
income: Interest.
I have found no way for the program to flag me for maturities.
If Money cannot handle Treasury Bills and this is a known problem, Why
don't they fix it?



"George" wrote:

- quote -

> How does one record a T-Bill purchase and then a redemption in Money so that
> the interest shows up in the tax reports such as schedule B?

  #5  
Old 05-09-2007, 04:23 PM
Mimi
Guest
 
Posts: n/a
Default RE: T-Bills in Money



"George" wrote:

- quote -

> How does one record a T-Bill purchase and then a redemption in Money so that
> the interest shows up in the tax reports such as schedule B?

  #4  
Old 04-14-2007, 12:32 AM
Michael Gordon
Guest
 
Posts: n/a
Default Re: T-Bills in Money

this also works, but exporting to tax programs can be problematic as the
interest needs to be recognized as emanating from Treasury securities and,
therefore, free from state income taxes.

--
Michael Gordon


"L Cramer" <lzcraexcludemer[at]yahoo.com> wrote in message
news:sSBTh.3517$Xq6.1264[at]newsfe12.lga...
- quote -

> The interest will be recorded on Schedule B in the Tax Report if the
> T-bill
> is treated as a CD and the buy and sale/redemption entered at net cost.
> The
> interest should be entered as a separate transaction. I'm using M2004.
> "Michael Gordon" <gordonm[at]denison.edu> wrote in message
> news:e6qmw8VfHHA.4032[at]TK2MSFTNGP02.phx.gbl...
> > The short and sad answer is that you can't -- a known problem in Money
> > for
> > several years now. I recommend excluding the transactions from your tax
> > reports and entering the 1099-INT data manually on your tax form. There's
> > a KB article which documents the problem, but doesn't offer a solution.
> > > --

> > Michael Gordon
> > > > "George" <George[at]discussions.microsoft.com> wrote in message

> > news:65D44458-4BCD-4791-863C-8C5D1698E2FC[at]microsoft.com...
> > > How does one record a T-Bill purchase and then a redemption in Money so
> > > that
> > > the interest shows up in the tax reports such as schedule B?

> >


  #3  
Old 04-14-2007, 12:31 AM
Michael Gordon
Guest
 
Posts: n/a
Default Re: T-Bills in Money

Yes, it sees the interest as a st capital gain. You can tweak Money to get
the interest to appear as interest. The problem is that -- if you export to
a tax program -- it can appear as interest or st capital gains or (worst of
all) as both.

--
Michael Gordon


"George" <George[at]discussions.microsoft.com> wrote in message
news:B82514DC-0524-48DE-A554-18748CAEC9FE[at]microsoft.com...
- quote -

> Thanks, Michael. I found that KB article and changed my recording
> practice.
> I now enter the quantity such as 10000 into the Quantity box. I then enter
> the price as 99.5 for example. It appears that Money should calculate the
> accrued interest but doesn't. So I subtract 9,500 from 10,000 and enter
> 500
> into the Accrued Interest box. I also enter the investment name as
> someone
> else has suggested, such as T-Bill exp 04/05/07 912795ZA2. The interest
> now
> appears in reports as INTEREST. I think this will meet my needs although
> if
> I were downloading into a tax program, it might not. I have several
> different
> Treasury Direct accounts but cannot get the account name into the reports.
> Thus, I run a separate report for each account.
> Thanks,
> George
> "Michael Gordon" wrote:
> > The short and sad answer is that you can't -- a known problem in Money
> > for
> > several years now. I recommend excluding the transactions from your tax
> > reports and entering the 1099-INT data manually on your tax form. There's
> > a
> > KB article which documents the problem, but doesn't offer a solution.
> > > --

> > Michael Gordon
> > > > "George" <George[at]discussions.microsoft.com> wrote in message

> > news:65D44458-4BCD-4791-863C-8C5D1698E2FC[at]microsoft.com...
> > > How does one record a T-Bill purchase and then a redemption in Money so
> > > that
> > > the interest shows up in the tax reports such as schedule B?
> > >


  #2  
Old 04-13-2007, 02:48 AM
George
Guest
 
Posts: n/a
Default Re: T-Bills in Money

Thanks, Michael. I found that KB article and changed my recording practice.
I now enter the quantity such as 10000 into the Quantity box. I then enter
the price as 99.5 for example. It appears that Money should calculate the
accrued interest but doesn't. So I subtract 9,500 from 10,000 and enter 500
into the Accrued Interest box. I also enter the investment name as someone
else has suggested, such as T-Bill exp 04/05/07 912795ZA2. The interest now
appears in reports as INTEREST. I think this will meet my needs although if
I were downloading into a tax program, it might not. I have several different
Treasury Direct accounts but cannot get the account name into the reports.
Thus, I run a separate report for each account.
Thanks,
George

"Michael Gordon" wrote:

- quote -

> The short and sad answer is that you can't -- a known problem in Money for
> several years now. I recommend excluding the transactions from your tax
> reports and entering the 1099-INT data manually on your tax form. There's a
> KB article which documents the problem, but doesn't offer a solution.
> --
> Michael Gordon
> "George" <George[at]discussions.microsoft.com> wrote in message
> news:65D44458-4BCD-4791-863C-8C5D1698E2FC[at]microsoft.com...
> > How does one record a T-Bill purchase and then a redemption in Money so
> > that
> > the interest shows up in the tax reports such as schedule B?

  #1  
Old 04-13-2007, 02:25 AM
L Cramer
Guest
 
Posts: n/a
Default Re: T-Bills in Money

The interest will be recorded on Schedule B in the Tax Report if the T-bill
is treated as a CD and the buy and sale/redemption entered at net cost. The
interest should be entered as a separate transaction. I'm using M2004.


"Michael Gordon" <gordonm[at]denison.edu> wrote in message
news:e6qmw8VfHHA.4032[at]TK2MSFTNGP02.phx.gbl...
- quote -

> The short and sad answer is that you can't -- a known problem in Money for
> several years now. I recommend excluding the transactions from your tax
> reports and entering the 1099-INT data manually on your tax form. There's
> a KB article which documents the problem, but doesn't offer a solution.
> --
> Michael Gordon
> "George" <George[at]discussions.microsoft.com> wrote in message
> news:65D44458-4BCD-4791-863C-8C5D1698E2FC[at]microsoft.com...
> > How does one record a T-Bill purchase and then a redemption in Money so
> > that
> > the interest shows up in the tax reports such as schedule B?




 
Old 04-13-2007, 12:03 AM
Michael Gordon
Guest
 
Posts: n/a
Default Re: T-Bills in Money

The short and sad answer is that you can't -- a known problem in Money for
several years now. I recommend excluding the transactions from your tax
reports and entering the 1099-INT data manually on your tax form. There's a
KB article which documents the problem, but doesn't offer a solution.

--
Michael Gordon


"George" <George[at]discussions.microsoft.com> wrote in message
news:65D44458-4BCD-4791-863C-8C5D1698E2FC[at]microsoft.com...
- quote -

> How does one record a T-Bill purchase and then a redemption in Money so
> that
> the interest shows up in the tax reports such as schedule B?



  #-1  
Old 04-11-2007, 08:16 AM
George
Guest
 
Posts: n/a
Default T-Bills in Money

How does one record a T-Bill purchase and then a redemption in Money so that
the interest shows up in the tax reports such as schedule B?
 

Tags
money, tbills
Similar Threads
Thread Forum Replies Last Post
Bills & Deposits Now Names Bills - WHY?
Guilden_NL: I am a 15+ yr Quicken customer that just switched to Money 2006 last year and threw my hands up in the air over the poor Help and Knowledgebase for...
Microsoft Money 2 02-09-2007 02:14 PM
Money 2007 Bills
Windwake: One feature that was available in 2005 but removed in 2006 was the ability to highlight mulitiple bill entries which then showed the resulting...
Microsoft Money 12 07-29-2006 02:28 AM
Selecting multiple bills within Bills window
Matt: I had an older version of Money prior to upgrading to 2006. I used to be able to highlight multiple bills that would be paid by the same account...
Microsoft Money 6 10-12-2005 05:08 PM
Moving bills in "bills and accounts" into budget planner
: I just added all my monthly bills into "bills and accounts". I'm sure there is a way to import my monthly bills into "budge plannner" but can't...
Microsoft Money 1 12-20-2003 09:29 AM
Scheduled Bills & Deposits, MSN Bill Pay, e-Bills
Retired Coal Miner: I can't figure out how to get M03 to recognize a scheduled bill (setup in Scheduled Bills & Deposits), as being paid when I have the bill setup as...
Microsoft Money 2 07-21-2003 01:17 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 08:48 PM.