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: "912797JD0"
Assets:US:TreasuryDirect:CofI 4.11 USD
Income:US:TreasuryDirect:Interest -4.11 USD
Only issue is that the date on the interest is forwarded to the future
because that 4.11 isn't mine until that date.
Is there any way to make all of this in one transaction? Also how can I
have a date that might be in the future not register when I pull reports?
Also, I have it reinvested each month so how would you close the one
transaction and create a new one and let the old one go?
On Tuesday, February 20, 2024 at 9:26:23 AM UTC-5 mtb...@gmail.com wrote:
> 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 bl...@furius.ca 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 <doc...@gmail.com> 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 beancount+...@googlegroups.com.
>>> 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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/a1d8a458-6cea-4603-9b19-6475f2ddbcdcn%40googlegroups.com.
