Le mardi 19 décembre 2023 à 09:02:46 UTC-5, bl...@furius.ca a écrit :

On Tue, Dec 19, 2023 at 8:54 AM Damien R. <damien...@gmail.com> wrote:

Le lundi 18 décembre 2023 à 22:03:43 UTC-5, bl...@furius.ca a écrit :

On Mon, Dec 18, 2023 at 9:25 PM Damien R. <damien...@gmail.com> wrote:

Thank you! It seems pretty obvious now... sorry for the dumb question!


There are no dumb questions. Nothing to feel sorry about.

 

If they had decided to sell only 50% of the commodity, what would have been 
the best way to handle it in my ledger? Use a total match to sell 
everything and buy back 50% of that commodity?


No.
You would have declared selling -3151.6173/2 units of COMMA @ 9.361 CAD, 
the cash would be correspondingly half, and the inferred P/L would be half 
as well.

 
I did a few tries and when selling only part of the commodity, I get 
"ambiguous matches". I get that if I don't specify the cost basis beancount 
is not able to match the lot I want to sale, so I really don't know how I 
would write "sell 1000 COMMA, get 9361 in cash" in the context of a mutual 
fund.


Can you run "bean-doctor context" around that transaction?  It's possible I 
put a heuristic on the total amount to be matched.


Here goes. I've shortened the list of balances before and after 
transaction, lists were essentially the sames.

bean-doctor context accounts/broker/broker.beancount 2108
** Transaction Id --------------------------------

Hash:d9b1a802839532df6ff5a7fa90f3d538
Location: accounts/broker/broker.beancount:2108


** Balances before transaction --------------------------------

  Assets:CA:Broker:COMMA              5.3522 COMMA {9.342 CAD, 2018-03-15}
  Assets:CA:Broker:COMMA              1.1888 COMMA {9.337 CAD, 2018-03-28}
  [...]
  Assets:CA:Broker:COMMA             16.0548 COMMA {9.343 CAD, 2023-05-16}
  Assets:CA:Broker:COMMA              9.5853 COMMA {9.333 CAD, 2023-05-30}

  Assets:CA:Broker:Cash                                        -10000.00 CAD

  Income:CA:Broker:PnL


** Unbooked Transaction --------------------------------

2023-06-21 * "Selling COMMA"
  Assets:CA:Broker:COMMA  -1000.0000 COMMA {} @ 9.361 CAD  ;
  Assets:CA:Broker:Cash     9361.00 CAD                    ; 9361 CAD
  Income:CA:Broker:PnL                                     ;


** Transaction --------------------------------

2023-06-21 * "Selling COMMA"


** Residual and Tolerances --------------------------------



** Balances after transaction --------------------------------

  Assets:CA:Broker:COMMA              5.3522 COMMA {9.342 CAD, 2018-03-15}
  Assets:CA:Broker:COMMA              1.1888 COMMA {9.337 CAD, 2018-03-28}
  [...]
  Assets:CA:Broker:COMMA             16.0548 COMMA {9.343 CAD, 2023-05-16}
  Assets:CA:Broker:COMMA              9.5853 COMMA {9.333 CAD, 2023-05-30}

  Assets:CA:Broker:Cash                                        -10000.00 CAD

  Income:CA:Broker:PnL
 

 

Le lundi 18 décembre 2023 à 20:59:53 UTC-5, bl...@furius.ca a écrit :

When you sell something you need to account for P/L. 
You're missing an account posting for that P/L, the amount of which can be 
left to be automatically calculated by Beancount, for that $124.46

On Mon, Dec 18, 2023 at 8:57 PM Damien R. <damien...@gmail.com> wrote:

Hi,

I have an investment in a mutual fund that has been converted from one 
commodity to another. I'm trying to represent that in my ledger with a sale 
of the first commodity (it's a total match sale as everything is sold) and 
then a buy of the second one (that's how it appears on the statement):

    2023-06-21 * "Selling Commodity A"
       Assets:CA:Broker:COMMA  -3151.6173 COMMA {} @ 9.361 CAD
       Assets:CA:Broker:Cash       29502.29 CAD

Bean-check gives the following error:

    Transaction does not balance: (124.4641276 CAD)

I tried changing the tolerance for that commodity to 0.0001 but no luck 
with that. Any idea what is going on and what I should to to address it?

As I'm dealing with mutual fund issues right now, I'll piggy back on my 
first question and ask what's the state of the average booking method? From 
my understanding it's still not supported and from the documentation I 
couldn't find how I should deal with partial sales, if I want to sale 50% 
of one commodity for instance.


Thanks,
Damien

-- 
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 beancount+...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/88cc74be-3d56-4ab5-964a-53689d988663n%40googlegroups.com
 
<https://groups.google.com/d/msgid/beancount/88cc74be-3d56-4ab5-964a-53689d988663n%40googlegroups.com?utm_medium=email&utm_source=footer>
.

-- 
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 beancount+...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/ffcaac38-5c91-4c9f-a1b7-ddc695bf5886n%40googlegroups.com
 
<https://groups.google.com/d/msgid/beancount/ffcaac38-5c91-4c9f-a1b7-ddc695bf5886n%40googlegroups.com?utm_medium=email&utm_source=footer>
.

-- 
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 beancount+...@googlegroups.com.

To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/5e1ea8e6-01b5-4fed-8e8c-59c227fe6732n%40googlegroups.com
 
<https://groups.google.com/d/msgid/beancount/5e1ea8e6-01b5-4fed-8e8c-59c227fe6732n%40googlegroups.com?utm_medium=email&utm_source=footer>
.

-- 
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 beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/beancount/6ebd4d42-06c0-49a7-b239-970cd5beb3e2n%40googlegroups.com.

Reply via email to