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/9128a0f7-629d-4efa-8c5c-0973deba8fa1n%40googlegroups.com.
