Re: T-bills through Treasury Direct - How to Record?

Here's an article on how I do it and why . On Wednesday, February 21, 2024 at 9:29:09 AM UTC-8 CDT wrote: > Another wrinkle in this puzzle... > > My understanding is that t-bills are not taxed a

Re: T-bills through Treasury Direct - How to Record?

Usual solution for that is to use different income accounts. On Wed, Feb 21, 2024, 12:29 PM CDT wrote: > Another wrinkle in this puzzle... > > My understanding is that t-bills are not taxed as capital gains but as > interest income on 1099-INT. > Also, they are NOT taxed at the state level only

Re: T-bills through Treasury Direct - How to Record?

Another wrinkle in this puzzle... My understanding is that t-bills are not taxed as capital gains but as interest income on 1099-INT. Also, they are NOT taxed at the state level only at the Federal level. So I'm wondering how that could be recorded in such a way as to separate the different ty

Re: T-bills through Treasury Direct - How to Record?

*What about the forward dated items? Will the reporting be correct or do I have to do something special to remove any forward dated items?* I think this will be fine. I don't believe beancount knows what day is today. It just adds everything up, or you can use the bean-query to extract info fr

Re: T-bills through Treasury Direct - How to Record?

In Treasury Direct, I don't think you can trade in and out. You can in brokerage accounts like etrade or Schwab, but not in Treasury Direct (from my understanding - I could be wrong). Also, in treasury direct there is a sort of holding account called CofI where you can park your money before b

Re: T-bills through Treasury Direct - How to Record?

In your example, why wouldn't you expire the position at $1000 instead? You are holding Bills in USD commodity, but that doesn't quite match what they are. Those Bills have USD values that can fluctuate. You don't have to hold them to maturity either. You could trade in and out of those, so I

Re: T-bills through Treasury Direct - How to Record?

What about this as a format?... 2024-01-16 * "Treasury Direct" "Security Issued" interestrate: "5.390%" cusip: "912797JD0" Assets:US:TreasuryDirect:T-bills 995.89 USD Assets:US:TreasuryDirect:CofI -995.89 USD 2024-02-13 * "Treasury Direct" "Interest Payment" cusip: "912797JD

Re: T-bills through Treasury Direct - How to Record?

I treat these just like stocks, this is an example. I have to prepend "B" to the cusip number for these. 2022-05-01 commodity B91282CBA8 2022-05-01 open Assets:Brokers:Etrade:B91282CBA8 B91282CBA8 2022-05-01 open Income:Interest:Etrade:B91282CBA8 USD 2022-05-01 open Income:Capital-Gains:Etrade:B9

Re: T-bills through Treasury Direct - How to Record?

I have a bunch of these now too, I haven't converted to Beancount yet, but I think it'll be straightforward. I think there is a choice to make about whether you want to - just account for the cash flows (which should be really easy, book as a new commodity with a price that begins at what you paid

T-bills through Treasury Direct - How to Record?

What is the best way to post entries for t-bills? When you purchase a 30 day t-bill on Treasury Direct, you purchase at a discount, so if it's $1100 face value bill, and the interest rate is 5.4%, you get a 5.4% ($4.53) discount and only pay $1,095.47. In 30 days the face value is $1100. So ho