how to balance?

66 views
Skip to first unread message

Anthony BARKER

unread,
Jul 1, 2020, 5:00:34 PM7/1/20
to Beancount

I am buying a building with a friend AK and can't seem to do the journal entries correctly

2020-05-01 * "Aquisition lawyer AVOCAT"
    Expenses:Unit101:Acquisition:Legal             -5000.00 EUR
    Equity:AK            

 2020-06-20 * "payment "
    Assets:FR:Unit101:PropertyPrepay              +28000.00 EUR
    Equity:AB      

2020-05-19 * "payment"
    Assets:FR:Unit101:PropertyPrepay               +20000.00 EUR
    Equity:AK   


The Equity for AK looks like he only contributed 15000 not 25000

if I make equity positive it balances but there is a huge conversion.

Or do i have to double journal - equity to cash and then cash to expense?

Martin Blais

unread,
Jul 1, 2020, 5:24:06 PM7/1/20
to Beancount
Anthony,
We're going to need much more details.
First, there's only a single currency in your example, so no conversion is possible, surely you've got other transactions.
How are you planning to organize this?
Are planning to just track your own share of the shared investment, or are you going to create a shared ledger for it (the preferred way)?
How are you going to split expenses?





--
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/c6f0ce32-4e48-4020-9bab-f189bc12c82fn%40googlegroups.com.

Tuno Tunante

unread,
Jul 1, 2020, 5:29:45 PM7/1/20
to bean...@googlegroups.com
Hi Anthony,

I don't see any problem. Everything works fine. 
Just, if AK paid something for the lawyer fees, should be Expenses:.... +5000 EUR
if AK put money in a kind of PropertyPrepay go outside the pocket of AK so, Equity negative and Assets positive.

If I do the new file:

2020-05-01 * "Aquisition lawyer AVOCAT"
Expenses:Unit101:Acquisition:Legal 5000.00 EUR
Equity:AK

2020-06-20 * "payment "
Assets:FR:Unit101:PropertyPrepay +28000.00 EUR
Equity:AB

2020-05-19 * "payment"
Assets:FR:Unit101:PropertyPrepay +20000.00 EUR
Equity:AK

; now Equity:AK = -25000 EUR
; In Assets:FR:Unit101:PropertyPrepay you have 28000 EUR
;

--

Martin Blais

unread,
Jul 1, 2020, 5:33:26 PM7/1/20
to Beancount
One template for creating a shared project is described here:

Basically, a dedicated ledger is created for the project.
Contributions by each participation is accounted as income postings.
Expenses and Assets are implicitly shared.



Anthony BARKER

unread,
Jul 1, 2020, 7:01:54 PM7/1/20
to Beancount
Thanks for the fast replies and the example

Everything is euro
In your screenshot everything looks good
but in fava it looks a bit different
The plan is to keep everything simple and just charge equity so we know how much each of us put into buying the building.
Also we can see the details on the costs if we do another flip down the road.

Anthony BARKER

unread,
Jul 1, 2020, 7:02:32 PM7/1/20
to Beancount

Anthony BARKER

unread,
Jul 1, 2020, 7:05:21 PM7/1/20
to bean...@googlegroups.com
Trying again with the image on a text version in the event it doesn't work


  1. Assets48000.00

  2. Equity-43000.00

    1. AB-28000.00

    2. AK-15000.00

  3. Liabilities

  4. Expenses-5000.00



image.png


You received this message because you are subscribed to a topic in the Google Groups "Beancount" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/beancount/44kF3LABTIc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/b820d356-79e2-4230-b7b4-3814bc1a059cn%40googlegroups.com.


--

Anthony BARKER | Directeur Général TEMPO FRANCE | T: +33 01 44 83 94 28 | MFR: +33783596325 
89 BLVD MAGENTA PARIS | Keybase: antb123  | T



Anthony BARKER

unread,
Jul 1, 2020, 7:30:22 PM7/1/20
to bean...@googlegroups.com

Sorry for being so quick to respond again on fava

Changing it to a plus makes it balance but then net profit is positive

image.png

image.png

Tuno Tunante

unread,
Jul 2, 2020, 4:49:50 AM7/2/20
to bean...@googlegroups.com
OK... Now I understood a bit your problem and your error.
You cannot use Equity for what you are looking for. Income AK is what goes from you to the business. 

Your new file:

2020-05-01 * "Aquisition lawyer AVOCAT"
    Expenses:Unit101:Acquisition:Legal              5000.00 EUR
    Income:AK

 2020-06-20 * "payment "
    Assets:FR:Unit101:PropertyPrepay              28000.00 EUR
    Income:AB

2020-05-19 * "payment"
    Assets:FR:Unit101:PropertyPrepay               20000.00 EUR
    Income:AK

Now everything is OK... I hope! ;-)

Screen Shot 2020-07-02 at 10.45.40.png
Screen Shot 2020-07-02 at 10.45.31.png
Screen Shot 2020-07-02 at 10.45.21.png

Reply all
Reply to author
Forward
0 new messages