No. of Recommendations: 1
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!)

Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.