On 28/11/2020 04.16, James Cook wrote:> Oh, that was at the bottom of my October 6 email: https://hub.darcs.net/falsifian/misc-pub/browse/beancount_plugins/falsifian/alt_value.py <https://hub.darcs.net/falsifian/misc-pub/browse/beancount_plugins/falsifian/alt_value.py>
Thank you!
Still, I'm curious what you mean. What you're saying sounds a bit like the following transaction, which I included in my original email; is that what you had in mind? (What "zero value" is being offset?) 2001-01-01 * "Income is in currency, silly" Income:Stock-as-cad -100 CAD Assets:Brokerage 1 ACME Equity:Trade (Note I've made the decision to use an explicit trading account, for better or for worse.)Like so: /At grant time:/ 2018-01-15 * "Grant XXXX" Income:Hooli:Grants -1695 HOOL.UNVEST Assets:Unvested:Hooli:XXXX 1695 HOOL.UNVEST /At vest time:/ 2018-07-15 * "Release event from grant XXXX" Assets:Unvested:Hooli:XXXX -212 HOOL.UNVEST Expenses:Vested:Hooli 212 HOOL.UNVEST Assets:Investments:Traditional:E-TRADE:Lot1 212 HOOL {191.33 USD} Assets:Investments:Traditional:E-TRADE:Lot1 -83 HOOL {191.33 USD}Interesting... can I infer from "Holi:XXXX" and "E-TRADE:Lot1" that you make a different account under Unvested for each grant, and a different account under e-TRADE for each release?
Correct inference. I have different accounts for each grant, so that I can budget the next year's grant income (pre-tax) separately. Now, the E-TRADE lot accounts, I could probably dispense with, but I like that having separate accounts keeps track of the correct lots and cost basis, before they move into Interactive Brokers (I only use E-TRADE to receive grants, not to trade, they are so behind IB that I would never bother).
Did the -83 HOOL get sold for tax withholding?
EXACTLY. Account goes UP 212 for the grant vesting, and down 83 for the withholding, so I can keep track of what has actually been withheld (granularity of stock sales means there is always a difference which effectively means you're getting an extra bit of "regular income").
Interestingly enough, the stock withholding is executed in dollars as you can see, but that amount is "corrected for" to the national currency in my next payslip, which means it ultimately becomes the national currency of the place I live in (at FOREX spot on the day the transaction happened, from what I can infer).
Income:Hooli:RSUs -40561.96 USD
Income:Investments:Dividends:HOOL-releases -288.32 USD
Expenses:Taxes:TY2018:Income 13333.53 USD
Expenses:Taxes:TY2018:Pension 2835.18 USD
/At sale time:/
2020-03-10 * "Close position HOOL at 280.49 USD"
Assets:Investments:Traditional:E-TRADE:Cash 280.49 USD
Assets:Investments:Traditional:E-TRADE:Cash -1.01 USD
Expenses:Financial:Trading-fees 1.01 USD
Assets:Investments:Traditional:E-TRADE:Lot1 -1 HOOL {191.33
USD, 2018-07-05} @ 280.49 USD
Income:Realized-gains:Traditional:E-TRADE (191.33 - 280.49) USD
This is probably more sensible than what I'm doing, at the very least
in the sense that it's less likely to confuse someone reading it later
(myself included).
Thanks. This is what I came up with, that was detail-oriented enough to compare to the yearly W-2 (-equivalent in my current country of residence, I am not a U.S. tax subject, thank all heavens) and spot any errors. So far it matches up perfectly, which I'm happy about. It evolved from my prior use of Ledger, year by year, to get to this point.
By the way, I would like to mention that being able to put
mathematical expressions in the transactions is a *huge* advantage
of Beancount.
Thanks; I forgot I could do that.
Yeah; it makes transaction entry easy and foolproof. It has effectively eliminated the use of spreadsheets on my side for transactional work — the only spreadsheets I keep now, are spreadsheets strictly devoted for analytic work.
Once you've committed to recording everything in this manner, you get a real sense of where your different income sources are coming from (in my case surprisingly a lot in stock, substantially more than the salary) and you also get a (pit-in-stomach feeling) sense of how much tax you actually pay. I wouldn't recommend this accounting strategy to most people -- it's a black pill. For me, it's advantageous to know that my personal expenses are always below my salary, and the rest is just savings. If you have the right account structure, it's easy to spot on the income/expense report (with Fava).
--
Rudd-O
http://rudd-o.com/
--
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/c0315b67-49b2-c47b-52ca-c56bd40e7423%40rudd-o.com.
OpenPGP_0x5C06F67A8BDEBA09_and_old_rev.asc
Description: application/pgp-keys
OpenPGP_signature
Description: OpenPGP digital signature
