But that's the thing: my income *wasn't* 1015.34 GBP, it was 977.88 GBP. That is the difference between the amount of 482.60 GBP that was debited from my account when I bought the shares, and the amount of 1467.08 GBP that was credited to my account when I sold the shares.
So something else is amiss. But I can't work out what. (Unless it's totally incorrect exchange rates from my broker. But their web interface shows the same figures as the CSV from which I extracted the above data, and I'm loath to 'massage' the rates just to make the numbers fit, without actually understanding what's wrong.) On Saturday, 1 May 2021 at 20:18:53 UTC+1 [email protected] wrote: > 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/4d36b92d-1251-424e-874b-6c687f8aa0e5n%40googlegroups.com.
