I have now updated the google collab with the option of using dedicated account for every well owner https://colab.research.google.com/drive/1KGGlmfeKpzTsphcO9P9Iizhv-cBqJIOw?usp=drive_link
On Tuesday, June 11, 2024 at 4:38:58 PM UTC+2 Chary Chary wrote: > I agree, that opening a dedicated account for each owner will give one > more control > > So, I think you example is better, than my > > On Tuesday, June 11, 2024 at 2:26:25 PM UTC+2 [email protected] wrote: > >> If you open dedicated accounts for each owner, then beancount will do >> more for you: >> 2024-01-01 open Assets:Receivable:Electricity:Owner1 ; open on move-in >> date >> 2024-01-01 open Assets:Receivable:Electricity:Owner2 >> 2024-01-01 open Assets:Receivable:Electricity:Owner3 >> >> Now: >> >> - You can't typo an owner's name >> - If an owner moves out, you can *close* their account and avoid >> accidentally charging them for future bills >> >> >> On Tue, Jun 11, 2024 at 4:07 AM Chary Chary <[email protected]> wrote: >> >>> Hello, >>> >>> what about something like this? >>> >>> 2024-02-01 * "Receiving electricity bill and splitting it with 3 well >>> owners" >>> Liabilities:Payable:Electricity -1000 EUR >>> Assets:Receivable:Electricity 200 EUR >>> well_owner: "owner1" >>> Assets:Receivable:Electricity 300 EUR >>> well_owner: "owner2" >>> Assets:Receivable:Electricity 500 EUR >>> well_owner: "owner3" >>> >>> >>> 2024-03-01 * "Paying to electrivity company" >>> Assets:BankAcc -1000 EUR >>> Liabilities:Payable:Electricity 1000 EUR >>> >>> 2024-03-03 * "Getting paid by well owner1" >>> Assets:BankAcc 200 EUR >>> Assets:Receivable:Electricity -200 EUR >>> well_owner: "owner1" >>> >>> 2024-03-04 * "Getting paid by well owner2" >>> Assets:BankAcc 300 EUR >>> Assets:Receivable:Electricity -300 EUR >>> well_owner: "owner2" >>> >>> ; 2024-03-05 * "Getting paid by well owner3" >>> ; Assets:BankAcc 500 EUR >>> ; Assets:Receivable:Electricity -500 EUR >>> ; well_owner: "owner3" >>> >>> you can then check for outstanding payments from well owners >>> >>> SELECT meta("well_owner") as outstanding, >>> sum(position) as outstanding >>> WHERE meta("well_owner") >>> GROUP BY >>> meta("well_owner") >>> HAVING not empty(sum(position)) >>> >>> you can experiment with it here: >>> >>> >>> https://colab.research.google.com/drive/1KGGlmfeKpzTsphcO9P9Iizhv-cBqJIOw?usp=drive_link >>> >>> >>> On Monday, June 10, 2024 at 7:41:54 PM UTC+2 [email protected] wrote: >>> >>>> Hello, >>>> >>>> I'm in charge of managing the expenses of a shared well with 3 >>>> buildings. >>>> >>>> The well has a single power meter and 3 water meters. Each month I >>>> record the power usage and split it according to the effective water usage >>>> based on the water meters. Then when I receive the electricity bill I >>>> extract the kWh price and assign an euro value to each owner. >>>> >>>> I was attempting to model this in beancount but could not wrap my head >>>> around it. >>>> >>>> Thank you very much, >>>> Alessio >>>> >>> -- >>> 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/49147181-c7c8-43c7-82a5-bd81dbfc5bdan%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/beancount/49147181-c7c8-43c7-82a5-bd81dbfc5bdan%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/0622c77b-4dff-4991-91a1-a590d8c1a8aen%40googlegroups.com.
