|
#7
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| "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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| 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? |
| | |||
| |||
| 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
| |||
| |||
| 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 | |
| |