Thank you for your input. I am more interested in tracking effective kWh and m^3 of water for betetr accountability in case of dispute with the other owners.
Also the EUR value, the electricity bill is on my house meter (we have a dedicated meter on the well pump line) and I have a solar power grid. It is very possible that during summer time the power will just came from the solar grid and the other 2 owners buy it from me. So we will be using my power bill just as a reference for the energy price on that month, but it will be not connected to my personal expense. Alessio On Tuesday, June 11, 2024 at 10:07:52 AM UTC+2 [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/1e1f2354-eb0c-497a-8264-5e9889ce9662n%40googlegroups.com.
