Here's an article on how I do it and why <https://reds-rants.netlify.app/personal-finance/organizing-your-account-hierarchy-for-tax-analysis/> .
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 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 types of interest received throughout the year. > > On Tuesday, February 20, 2024 at 11:41:45 AM UTC-5 mtb...@gmail.com wrote: > >> 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/883b31b3-fbea-4326-be3c-1b89c52054f8n%40googlegroups.com.