UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next
Author: lorenzo2 Big red star, 1000 posts Old School Fool Add to my Favorite Fools Ignore this person (you won't see their posts anymore) Number: of 10395  
Subject: Re: Treasury Direct & Quicken Date: 2/10/2007 8:30 PM
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
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!)

Lorenzo
Post New | Post Reply | Reply Later | Create Poll Report this Post | Recommend it!
Print the post  
UnThreaded | Threaded | Whole Thread (2) | Ignore Thread Prev | Next

Announcements

Foolanthropy 2014!
By working with young, first-time moms, Nurse-Family Partnership is able to truly change lives – for generations to come.
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.
Post of the Day:
Macro Economics

The Story Behind the Story
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and "#1 Media Company to Work For" (BusinessInsider 2011)! 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.
Advertisement