[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Fairly clueless treasurer needs assistance



  Months ago, people requested a google sheet with our finances.  There is 
no template for that in Sheets (what the heck, google?) so I have asked 
youtube, but some things I am doing are not right.
The first problem is that I don't know how to share it with everybody on 
the attendance spreadsheet list. This is the link to the numbers from the 
last 2.5 years. I hope.
https://docs.google.com/spreadsheets/d/15SZzAuxhWkPWrCHGyTsrSsW1Bp68eAqDrPG8YWw20I8/edit
  
I tried to put the formula =(g2-e3+f3)in cell g3, and it worked for that 
one line, but I can't figure out how to generalize. It seems possible that 
I should use a different formula and put negative signs in front of each 
expense number.  
   Somebody, please stop rolling your eyes and fix it, then share it. I 
made up an opening balance because it was a nice number and I'm a little 
queasy about telling the world how much money we actually have, but am 
happy to tell people privately. There will be two more entries almost 
immediately (June 4 wedding fee from newlyweds, wedding payment to 
ringers). I have many other money topics to discuss the next time we have 
a meeting. 
   If you're buying pounds it seems like a pretty good time. 

Laura Dickerson