Does anybody use Quicken to track purchases made through Treasury Direct? It doesn't look like there is a way to download transactions from TD. Any advice or tips?I do, and it's pretty much a PITA. There's no way to download from TD, so you have to make manual entries. I've tried several approaches, and here's the best that I've come up with. I made an asset account called TreasuryDirect. When I make a purchase, say a 6-month T-bill, I enter the date, the last three characters of the CUSIP (in the ref field), put "6 month T-bill" in the payee field, and in the memo field I put the date of maturity and the investment yield. The purchase price goes in the increase field. The PITA part is that at maturity, six months later, you have to make two additional entries: one showing the interest (which, of course, is the difference between the purchase price and the value at maturity), and one showing the redemption. So - three entries for each treasury: purchase, interest, redemption. And while I think the notion of a Zero-Percent C of I is kind of goofy, it does simplify things a bit: I also set up a cash flow account called "Zero C of I", and use that as source and destination, both at TD and in Quicken. I have a ladder of 6-month bills, and transfer the residual amount in the C of I account to my interest-bearing bank account after each redemption and reinvestment. (If you come up with something simpler, I'd be most interested in hearing about it!)Lorenzo
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Ma