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
think it's better if they are their own commodity.
You could lump them all into one commodity if you prefer to simplify your
assets.
For ex.
2022-05-01 commodity BILLS
2022-05-01 open Assets:Brokers:Etrade:B91282CBA8 BILLS
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 BILLS {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 BILLS {95.55127 USD} @ 100 USD
Income:Capital-Gains:Etrade:B91282CBA8
On Tuesday, February 20, 2024 at 10:17:51 AM UTC-5 CDT wrote:
> 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/5c222659-251f-4789-bf17-b662016b2d98n%40googlegroups.com.
