ATM Transaction that has Fee included in Total

2024-02-26 Thread CDT
I don't like to carry much cash when I travel for business, so from time to time I use my ATM card at a machine when I'm away and it charges a fee that is included in the total. ie - I get $500 cash but the full amount shows as one transaction of $507.99 (the fee isn't separated) I am trying

Re: Totals for a specific commodity

2024-02-25 Thread CDT
Thank you Dan. That worked. On Sunday, February 25, 2024 at 2:22:07 PM UTC-5 dan...@grinta.net wrote: > On 25/02/24 18:58, CDT wrote: > > This command gives me a list of the different purchases of that position > > at different prices. So if I bought some Filecoin at

Re: Totals for a specific commodity

2024-02-25 Thread CDT
gle.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/ > > > On Sun, Feb 25, 2024 at 12:18 PM CDT wrote: > >> I'm new to Python, coding and Beancount, so I don't mean to sound like a >> dunce when I ask - where do I use "SELECT sum(position) WHERE currency = >>

Re: Totals for a specific commodity

2024-02-25 Thread CDT
ry > > https://docs.google.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/ > > > On Sun, Feb 25, 2024 at 12:18 PM CDT wrote: > >> I'm new to Python, coding and Beancount, so I don't mean to sound like a >> dunce when I ask - where do I use "

Re: Totals for a specific commodity

2024-02-25 Thread CDT
at 3:25:34 PM UTC-5 bl...@furius.ca wrote: > Just SELECT sum(position) WHERE currency = 'BTC'? > > On Sat, Feb 24, 2024 at 2:46 PM CDT wrote: > >> I have some commodities (lets just use BTC as an example) spread out over >> many different accounts. >> >>

Totals for a specific commodity

2024-02-24 Thread CDT
I have some commodities (lets just use BTC as an example) spread out over many different accounts. Is there a command to get a grand total on a specific commodity (like BTC) regardless of the account hierarchy? I couldn't find anything on this. -- You received this message because you are

Re: Seeking beta-testers/devs for crypto tax tools

2024-02-24 Thread CDT
I'm relatively new to Python scripting and have been hand entering things while I'm learning, but this looks very interesting considering the volume of transactions that can occur with cryptos when the bull market heats up. How do I install this? (I'm using Windows 11 but I can use pip on

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

2024-02-21 Thread CDT
me:Interest:Etrade:B91282CBA8 -62.5 USD > > 2023-12-15 * "DEPOSIT - US TSY NOTE 012523DE15 REDEMPTION OF MATURED BOND" > Assets:Brokers:Etrade:Cash 10 USD > Assets:Brokers:Etrade:B91282CBA8 -1000 BILLS {95.55127 USD} @ 100 USD > Income:Capital-Gains:Etrade:B91282CBA8 >

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

2024-02-20 Thread CDT
USD > > 2023-12-15 * "DEPOSIT - US TSY NOTE 012523DE15 REDEMPTION OF MATURED BOND" > Assets:Brokers:Etrade:Cash 10 USD > Assets:Brokers:Etrade:B91282CBA8 -1000 BILLS {95.55127 USD} @ 100 USD > Income:Capital-Gains:Etrade:B91282CBA8 > > > On Tue

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

2024-02-20 Thread CDT
at 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

T-bills through Treasury Direct - How to Record?

2024-02-19 Thread CDT
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

Setting up first Beancount file - should I separate LLC partnership and personal finances

2024-02-16 Thread CDT
Hello, I'm setting up my first Beancount file and will start with 2024. Currently I have all of my ledgers in Gnucash but I will probably not export the existing items (yet). My wife and I have an LLC partnership for a property we rent and we have always kept that in our general Gnucash file