House shared utility bills powered by Beancount

Go straight to the Balances section for:

• the amount of money you are owed or owing;
• your personal ledger.

Our ledger

Stuff shared by all

Read unfolded ledger by checking here -> 


$ bean-query house.beancount 'SELECT date,account,payee,position WHERE narration ~ "for all"'


   date             account            payee    position 
---------- ------------------------- --------- ----------
2023-09-01 Expenses:PaperTowel:Room1 Costco      6.77 CAD
2023-09-01 Expenses:PaperTowel:Room2 Costco      6.77 CAD
2023-09-01 Expenses:PaperTowel:Room3 Costco      6.77 CAD
2023-09-01 Expenses:PaperTowel:Room4 Costco      6.77 CAD
2023-09-01 Expenses:DishLiquid:Room1 Costco      4.23 CAD
2023-09-01 Expenses:DishLiquid:Room2 Costco      4.23 CAD
2023-09-01 Expenses:DishLiquid:Room3 Costco      4.23 CAD
2023-09-01 Expenses:DishLiquid:Room4 Costco      4.23 CAD
2023-09-01 Expenses:GarbageBag:Room1 Costco      4.52 CAD
2023-09-01 Expenses:GarbageBag:Room2 Costco      4.52 CAD
2023-09-01 Expenses:GarbageBag:Room3 Costco      4.52 CAD
2023-09-01 Expenses:GarbageBag:Room4 Costco      4.52 CAD
2023-09-01 Income:Room3              Costco    -62.12 CAD
2023-11-01 Expenses:Sponge:Room1     Dollarama   1.41 CAD
2023-11-01 Expenses:Sponge:Room2     Dollarama   1.41 CAD
2023-11-01 Expenses:Sponge:Room3     Dollarama   1.41 CAD
2023-11-01 Expenses:Sponge:Room4     Dollarama   1.41 CAD
2023-11-01 Expenses:Scourer:Room1    Dollarama   1.13 CAD
2023-11-01 Expenses:Scourer:Room2    Dollarama   1.13 CAD
2023-11-01 Expenses:Scourer:Room3    Dollarama   1.13 CAD
2023-11-01 Expenses:Scourer:Room4    Dollarama   1.13 CAD
2023-11-01 Income:Room4              Dollarama -10.16 CAD


   date             account            payee    position 
---------- ------------------------- --------- ----------
2023-09-01 Expenses:PaperTowel:*     Costco      6.77 CAD
2023-09-01 Expenses:DishLiquid:*     Costco      4.23 CAD
2023-09-01 Expenses:GarbageBag:*     Costco      4.52 CAD
2023-09-01 Income:Room3              Costco    -62.12 CAD
2023-11-01 Expenses:Sponge:*         Dollarama   1.41 CAD
2023-11-01 Expenses:Scourer:*        Dollarama   1.13 CAD
2023-11-01 Income:Room4              Dollarama -10.16 CAD

Stuff shared by some

Read unfolded ledger by checking here -> 


$ bean-query house.beancount 'SELECT date,account,payee,position WHERE narration ~ "&"'


   date             account             payee    position 
---------- -------------------------- --------- ----------
2023-10-15 Expenses:ToiletPaper:Room1 Costco     27.00 CAD
2023-10-15 Expenses:ToiletPaper:Room2 Costco     27.00 CAD
2023-10-15 Income:Room2               Costco    -54.00 CAD
2023-10-23 Expenses:BarSoap:Room1     Costco     20.33 CAD
2023-10-23 Expenses:BarSoap:Room2     Costco     20.33 CAD
2023-10-23 Income:Room2               Costco    -40.66 CAD
2023-11-10 Expenses:ToiletPaper:Room3 Dollarama   6.00 CAD
2023-11-10 Expenses:ToiletPaper:Room4 Dollarama   6.00 CAD
2023-11-10 Income:Room3               Dollarama -12.00 CAD


   date             account             payee    position 
---------- -------------------------- --------- ----------
2023-10-15 Expenses:ToiletPaper:*     Costco     27.00 CAD
2023-10-15 Income:Room2               Costco    -54.00 CAD
2023-10-23 Expenses:BarSoap:*         Costco     20.33 CAD
2023-10-23 Income:Room2               Costco    -40.66 CAD
2023-11-10 Expenses:ToiletPaper:*     Dollarama   6.00 CAD
2023-11-10 Income:Room3               Dollarama -12.00 CAD

Balances

A negative number means you are being owed!

Room 1

$ bean-query house.beancount 'SELECT sum(position) WHERE account ~ ":Room1$"'


   date             account             payee   position 
---------- -------------------------- --------- ---------
2023-09-01 Expenses:PaperTowel:Room1  Costco     6.77 CAD
2023-09-01 Expenses:DishLiquid:Room1  Costco     4.23 CAD
2023-09-01 Expenses:GarbageBag:Room1  Costco     4.52 CAD
2023-10-15 Expenses:ToiletPaper:Room1 Costco    27.00 CAD
2023-10-23 Expenses:BarSoap:Room1     Costco    20.33 CAD
2023-11-01 Expenses:Sponge:Room1      Dollarama  1.41 CAD
2023-11-01 Expenses:Scourer:Room1     Dollarama  1.13 CAD


 Balance
---------
65.40 CAD

Room 2

$ bean-query house.beancount 'SELECT sum(position) WHERE account ~ ":Room2$"'


   date             account             payee    position 
---------- -------------------------- --------- ----------
2023-09-01 Expenses:PaperTowel:Room2  Costco      6.77 CAD
2023-09-01 Expenses:DishLiquid:Room2  Costco      4.23 CAD
2023-09-01 Expenses:GarbageBag:Room2  Costco      4.52 CAD
2023-10-15 Expenses:ToiletPaper:Room2 Costco     27.00 CAD
2023-10-15 Income:Room2               Costco    -54.00 CAD
2023-10-23 Expenses:BarSoap:Room2     Costco     20.33 CAD
2023-10-23 Income:Room2               Costco    -40.66 CAD
2023-11-01 Expenses:Sponge:Room2      Dollarama   1.41 CAD
2023-11-01 Expenses:Scourer:Room2     Dollarama   1.13 CAD


 Balance
----------
-29.26 CAD

Room 3

$ bean-query house.beancount 'SELECT sum(position) WHERE account ~ ":Room3$"'


   date             account             payee    position 
---------- -------------------------- --------- ----------
2023-09-01 Expenses:PaperTowel:Room3  Costco      6.77 CAD
2023-09-01 Expenses:DishLiquid:Room3  Costco      4.23 CAD
2023-09-01 Expenses:GarbageBag:Room3  Costco      4.52 CAD
2023-09-01 Income:Room3               Costco    -62.12 CAD
2023-11-01 Expenses:Sponge:Room3      Dollarama   1.41 CAD
2023-11-01 Expenses:Scourer:Room3     Dollarama   1.13 CAD
2023-11-10 Expenses:ToiletPaper:Room3 Dollarama   6.00 CAD
2023-11-10 Income:Room3               Dollarama -12.00 CAD


 Balance
----------
-50.05 CAD

Room 4

$ bean-query house.beancount 'SELECT sum(position) WHERE account ~ ":Room4$"'


   date             account             payee    position 
---------- -------------------------- --------- ----------
2023-09-01 Expenses:PaperTowel:Room4  Costco      6.77 CAD
2023-09-01 Expenses:DishLiquid:Room4  Costco      4.23 CAD
2023-09-01 Expenses:GarbageBag:Room4  Costco      4.52 CAD
2023-11-01 Expenses:Sponge:Room4      Dollarama   1.41 CAD
2023-11-01 Expenses:Scourer:Room4     Dollarama   1.13 CAD
2023-11-01 Income:Room4               Dollarama -10.16 CAD
2023-11-10 Expenses:ToiletPaper:Room4 Dollarama   6.00 CAD


 Balance
---------
13.91 CAD

Beancount source file

Read full source file by checking here -> 


;; Ledger of shared utilities
;; Participants: Room 1,2,3,4 tenants

option "operating_currency" "CAD"

plugin "beancount.plugins.split_expenses" "Room1 Room2 Room3 Room4"
plugin "beancount.plugins.auto_accounts"

;==================== 2023 Fall =====================

;---------------------------------------------------------
2023-09-01 * "Costco" "for all"
  Expenses:PaperTowel                          27.10 CAD
  Expenses:DishLiquid                          16.94 CAD
  Expenses:GarbageBag                          18.08 CAD
  Income:Room3
2023-10-15 * "Costco" "for room 1 & 2"
  Expenses:ToiletPaper:Room1                   27.00 CAD
  Expenses:ToiletPaper:Room2                   27.00 CAD
  Income:Room2
2023-10-23 * "Costco" "for room 1 & 2"
  Expenses:BarSoap:Room1                       20.33 CAD
  Expenses:BarSoap:Room2                       20.33 CAD
  Income:Room2
2023-11-01 * "Dollarama" "for all"
  Expenses:Sponge                               5.64 CAD
  Expenses:Scourer                              4.52 CAD
  Income:Room4
2023-11-10 * "Dollarama" "for room 4 & 5"
  Expenses:ToiletPaper:Room3                    6.00 CAD
  Expenses:ToiletPaper:Room4                    6.00 CAD
  Income:Room3


...