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/CANRuw3y6PsTLBsjNfh_%3DOZiY15XRTRQcXuSAn4Mvs7FX1bWfVg%40mail.gmail.com.
