Sale 11 175.81 1,933.91
Cost 11 54.135 595.49
1,338.43
Proceeds 1467.08 1.3182 1,933.90
PnL (1,015.34) 1.3182 (1,338.43)
595.48
So you should have -1015.34 GBP as your Income, not -977.88
Of course, you would need an additional posting to absorb rounding errors.
On Wednesday, April 28, 2021 at 5:14:40 PM UTC-7 [email protected]
wrote:
> 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/6308bd91-360f-46cc-9453-9bd605bea922n%40googlegroups.com.
