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:B91282CBA8 USD
2022-12-02 * "buystock" "[B91282CBA8] US Treasury"
Assets:Brokers:Etrade:B91282CBA8 1000 B91282CBA8 {95.55127 USD}
Assets:Brokers:Etrade:USD -95551.27 USD
2022-12-15 * "INT - UNITED STATES TREASURY NOTE - REG INT ON 100000 BND"
"[B91282CBA8]
"
Assets:Brokers:Etrade:USD 62.5 USD
Income:Interest:Etrade:B91282CBA8 -62.5 USD
2023-12-15 * "DEPOSIT - US TSY NOTE 012523DE15 REDEMPTION OF MATURED BOND"
Assets:Brokers:Etrade:Cash 100000 USD
Assets:Brokers:Etrade:B91282CBA8 -1000 B91282CBA8 {95.55127 USD} @ 100 USD
Income:Capital-Gains:Etrade:B91282CBA8
On Monday, February 19, 2024 at 8:56:10 AM UTC-5 [email protected] wrote:
> 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 and ends at the
> face value, with transactions for coupons in between) or
> - if you also want to be precise and account for the accrued interest and
> discounted value portions separately on acquisition.
> Anyhow, I'll try to post one of these here or to a doc as an example once
> I do mine.
>
>
>
> On Mon, Feb 19, 2024 at 8:12 AM CDT <[email protected]> wrote:
>
>> 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 how is the interest counted 30 days later? Is there a way to do that?
>>
>> Also, you can let each month roll over into a new bond, so in cases like
>> that the $1100 would come due but you would get a refund for the new bond
>> that is discounted.
>>
>> I'm just confused how these things would be registered in Beancount.
>>
>> From the treasury direct website...
>>
>> A refund payment from a Treasury bill is the difference between the face
>> value and the price paid when purchased at original issue. Treasury
>> bills are sold at a discount or at par (face value). When the bill
>> matures, the buyer is paid its face value.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/beancount/a74715d8-96ec-41fa-8ee2-9312fe917ed6n%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/beancount/a74715d8-96ec-41fa-8ee2-9312fe917ed6n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/a23fd4c2-d092-465a-9205-6c9873d52c97n%40googlegroups.com.
