Hi all,

I’m wondering if Airtable is a good fit for managing our student share flat expenses. Currently we use icloud numbers, to enter raw values and show, but it is cumbersome and manual. This is what I have in mind:

• 
  

  People Table: All people are stored here and cross referenced. Sometimes people move in and out, or go away for holiday, so don’t need to pay power bill for example.

  
  


• 
  

  Powerbill Table: Our powerbill is calculated everyday automatically. We have an app which shows how much power was used for each day and input into the airtable. For each day I can enter the $ value of a day. This is then divided into payees of two sorts, heat users, non-hear users, depending on if you use electric blanket that day. The issue I have right now is that I do not know how to tie that back to the person, as an outstanding fee.

  
  

Thanks for following through that and hopefully it wasn’t too confusing or abstract. Appreciate any opinions!