Just updated a couple of typos
; https://groups.google.com/g/beancount/c/FI1G9lF0kdw 2023-04-24 commodity HOUSE ; Tracking house as a commodity. ; This will allow us to track the value of the house over time as the market price changes and to ; reflect this in your balance sheet. ; Join accounts 2023-04-24 open Liabilities:Mortgage EUR 2023-04-24 open Assets:House HOUSE 2023-04-24 open Expenses:Mortgage-Interest EUR ; Partner A accounts 2023-04-24 open Equity:PartnerA:Initial-Cap EUR 2023-04-24 open Equity:PartnerA:Drawings EUR 2023-04-24 open Assets:PartnerA:Bank EUR 2023-04-24 open Income:PartnerA:Salary EUR ; Partner B accounts 2023-04-24 open Equity:PartnerB:Initial-Cap EUR 2023-04-24 open Equity:PartnerB:Drawings EUR 2023-04-24 open Assets:PartnerB:Bank EUR 2023-04-24 open Income:PartnerB:Salary EUR ; Initial capital 2023-04-24 * "Initial capital partner A, invested in household" Equity:PartnerA:Initial-Cap -100,000.00 EUR Assets:PartnerA:Bank ; *** Buyin the house 2023-04-24 price HOUSE 400,000.00 EUR ; you can tag the transaction with the mortgage account to make it easier to track the mortgage payments 2023-04-24 * "Buy House" ^mortgage Liabilities:Mortgage -300,000.00 EUR Assets:House 1 HOUSE @@ 400,000.00 EUR Assets:PartnerA:Bank -100,000.00 EUR ; You partners 100,000.00 EUR invested in the house is not your income, it is your partner's initial capital 2023-04-29 * "Partner A income" Assets:PartnerA:Bank 4,000.00 EUR Income:PartnerA:Salary 2023-04-29 * "Partner B income" Assets:PartnerB:Bank 3,000.00 EUR Income:PartnerB:Salary ; I do not think it is correct to write how much of every parner's payment goes to interest and how much goes to reduce mortgage. ; you just note how much each of you paid to the bank 2023-05-01 * "Bank" "Mortgage payment: 200,00; Interest: 400,00" ^mortgage Assets:PartnerA:Bank -400.00 EUR Assets:PartnerB:Bank -200.00 EUR Liabilities:Mortgage 200.00 EUR Expenses:Mortgage-Interest 400.00 EUR ; now market price of your house has increased. ; congratulations! 2024-01-01 price HOUSE 450,000.00 EUR ; you will see this when you run a balance sheet -like beanquery. e.g. ; ; """SELECT account, SUM(convert(position, 'EUR')) as amount WHERE account ~ 'Assets|Liabilities'""" On Wednesday, March 6, 2024 at 12:05:14 AM UTC+1 Chary Chary wrote: Hi, see my thoughts below *Assumptions:* You have a joint marriage-like household. I think the most correct way to treat such setup is like a small company with 2 owners. In such setup, the 100 K EUR paid by your partner as an initial payment for the house is not your income, this is your partner's initial investment In the same way, if you decide to split, what your partner will take in not your expenses, this is Equity:PartnerA:Drawings Think of it once again as a small business. If one partner leaves, the part of the business that partner takes will not go on expenses. Also in such setup some of the Assets, Liabilities and Expenses are joint ones, you just can't split them in the ledger. In the same way as in business you just can't split between partners expenses of the company. I also think that principle is to log information as simple as possible, but the query later on can be as complex as needed. The important thing is that all needed information is logged. Regarding how to determine how much of house each of you owns This question IMHO goes outside of beancount. The role of beancount IMHO is record things as simple as possible. The share of ownership will depend on your prior agreements, singed at notary or lawyer ad / or legislations of your country. The important thing is that you both agree in advance how to calculate it and document this. The standard decision in by a judge in most of the jurisdictions would be to split all jointly earned assets and liabilities 50% *I would consider fair for myself the following:* A Net Present Value <https://en.wikipedia.org/wiki/Net_present_value>of total payments of all partners is calculated. The relation between the value of NPVs determines the share of house ownership. I would probably not consider what part of each other's payment went to reduce mortgage and how much to pay bank interest. So, what do you think? 2023-04-24 commodity HOUSE ; Tracking house as a commodity. ; This will allow us to track the value of the house over time as the market price changes and to ; reflect this in your balance sheet. ; Join accounts 2023-04-24 open Liabilities:Mortgage EUR 2023-04-24 open Assets:House HOUSE 2023-04-24 open Expenses:Mortgage-Interest EUR ; Partner A accounts 2023-04-24 open Equity:PartnerA:Initial-Cap EUR 2023-04-24 open Equity:PartnerA:Drawings EUR 2023-04-24 open Assets:PartnerA:Bank EUR 2023-04-24 open Income:PartnerA:Salary EUR ; Partner B accounts 2023-04-24 open Equity:PartnerB:Initial-Cap EUR 2023-04-24 open Equity:PartnerB:Drawings EUR 2023-04-24 open Assets:PartnerA:Bank EUR 2023-04-24 open Income:PartnerA:Salary EUR ; Initial capital 2023-04-24 * "Initial capital partner A, invested in household" Equity:PartnerA:Initial-Cap -100,000.00 EUR Assets:PartnerA:Bank ; *** Buyin the house 2023-04-24 price HOUSE 400,000.00 EUR ; you can tag the transaction with the mortgage account to make it easier to track the mortgage payments 2023-04-24 * "Buy House" ^mortgage Liabilities:Mortgage -300,000.00 EUR Assets:House 1 HOUSE @@ 400,000.00 EUR Assets:PartnerA:Bank -100,000.00 EUR ; You partners 100,000.00 EUR invested in the house is not your income, it is your partner's initial capital 2023-04-29 * "Partner A income" Assets:PartnerA:Bank 4,000.00 EUR Income:PartnerA:Salary 2023-04-29 * "Partner B income" Assets:PartnerB:Bank 3,000.00 EUR Income:PartnerB:Salary ; I do not think it is correct to write how much of every parner's payment goes to interest and how much goes to reduce mortgage. ; you just note how much each of you paid to the bank 2023-05-01 * "Bank" "Mortgage payment: 200,00; Interest: 400,00" ^mortgage Assets:PartnerA:Bank -400.00 EUR Assets:PartnerB:Bank -200.00 EUR Liabilities:Mortgage 200.00 EUR Expenses:Mortgage-Interest 400.00 EUR ; now market price of your house has increased. ; congratulations! 2024-01-01 price HOUSE 450,000.00 EUR ; you will see this when you run a balance sheet -like beanqury. e.g. ; ; SELECT account, convert(position, 'EUR') as amount WHERE account ~ "Assets|Liabilities" On Monday, March 4, 2024 at 10:10:19 PM UTC+1 Tino de Bruijn wrote: > what is the price of your house, which the previous owner got paid. Is this 300,000.00 EUR or 400,000.00 EUR? 400k (which is also shown correctly on the balance). > Also, do you have any partnership agreement with your partner. How does it handle common property? Somewhat like that. You may assume it is set up in such a way that keeping track of who paid what makes sense, and as such, that's what I want to accomplish :). > I would probably do this a bit differently Keen to hear how you'd approach this! Thanks, Tino On Sunday 3 March 2024 at 20:42:39 UTC+1 Chary Chary wrote: I think also important to know what your mortgage and house buying contract says. I assumed you signed it together with your partner. Also, do you have any partnership agreement with your partner. How does it handle common property? On Sunday, March 3, 2024 at 8:17:03 PM UTC+1 Chary Chary wrote: Hi, I would probably do this a bit differently. But let me clarify one thing: what is the price of your house, which the previous owner got paid. Is this 300,000.00 EUR or 400,000.00 EUR? Regards. On Sunday, March 3, 2024 at 12:03:08 PM UTC+1 Tino de Bruijn wrote: I've been using Beancount for years to track both my business as well as a shared bank account with friends. However, now I'm trying to set up a way to track our mortgage, as well as how much each of us (my partner and me) "own" to the shared account, and I just can't figure out what setup or queries I should use. I now have a setup as follows: plugin "beancount.plugins.auto_accounts" 2023-04-24 * "Buy" "Mortage" Liabilities:Mortgage -300000.00 EUR Assets:House 2023-04-24 * "Buy" "Cash in" Income:Partner -100000.00 EUR Assets:House 2023-05-01 * "Bank" "Mortgage payment: 200,00; Interest: 400,00" Assets:Bank -600.00 EUR Liabilities:Mortgage:Me 133.333 EUR Liabilities:Mortgage:Partner 66.667 EUR Expenses:Mortgage:Interest:Me 266.667 EUR Expenses:Mortgage:Interest:Partner 133.333 EUR ; HOW TO DO THIS? ; 2023-05-01 * "Required payment" ; ???? -600.00 EUR ; ??????:Partner 250.00 EUR ; ??????:Me 350.00 EUR 2023-05-10 * "Bank" "Monthly Me" Assets:Bank 300.00 EUR ; Whoops, 50 too low Income:Me 2023-05-11 * "Bank" "Monthly Partner" Assets:Bank 250.00 EUR Income:Partner I'm wondering how to set up that "Required payment"? We split (non-50/50) and I want to set that up per month (will build a plugin probably), as it is based on the difference in income. In this (contrived) example, I paid the wrong amount, and I would like to see somewhere that I'm €50 short. And finally, we also want to track how much each of us owns of the house. As you can see my partner had cash from a previous house, whereas I pay more per month, so this balance changes. (This was recommended to tackle it this way by the notary, in case we ever separate.) How could I get accounts set up (Assets:House:Partner/Me? or a query?) to track this? Thanks! -- 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/0bfce935-58a0-493d-af7e-fab7ef452ed8n%40googlegroups.com.
