I've been using beancount for a while for my everyday transactions, but am
only recently getting around to trying to import my trading activity to my
ledger as it seems much more complex.
I'm having trouble with accounting for profit/loss on shares which are
priced in a currency different to the main currency of my trading account.
My trading account is in GBP, but I often buy shares priced in USD. My
broker handles the conversion, and charges me an FX fee as a percentage of
the value of the trade.
Here is an example:
2020-03-31 * "Buy 11 shares of Square"
Assets:GB:Freetrade:GIA:Cash -482.60 GBP @ 1.23390 USD
Assets:GB:Freetrade:GIA:SQ 11 S_SQ {54.13456 USD}
; ...
2020-11-16 * "Sell 11 shares of Square"
Assets:GB:Freetrade:GIA:Cash 1467.08 GBP @ 1.31820 USD
Assets:GB:Freetrade:GIA:SQ -11 S_SQ {54.13456 USD} @ 175.81000 USD
Assets:GB:Freetrade:GIA:Cash -6.60 GBP
Expenses:Financial:Fees 6.60 GBP
Income:Investments:PnL -977.88 GBP @ 1.31820 USD
All the figures are from my broker's reports, except for the profit
calculation.
For the profit I have simply subtracted the GBP purchase price from the GBP
sale price, as this is the actual amount of profit I made (the actual net
change in my account balance).
However, the second transaction does not balance:
Transaction does not balance: (49.3832800 USD)
I am struggling to understand where the extra 49.3832800 USD came from (or
went?), or how I can balance this transaction.
I'm quite new to this. Can anyone give me any tips?
--
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/CAMfsOg__vph_CmnF55dmUGrFAHOT-bM%2BKCKnXTdYF%3D%2BbFw6H2w%40mail.gmail.com.
