Difference between revisions of "Money Matters"

From TAMI
Jump to navigationJump to search
(adding link to last donation round)
 
(148 intermediate revisions by 9 users not shown)
Line 1: Line 1:
= What this page is about =
+
= About =
TAMI is supported by you and me, Our only source of income are membership dues.<br>
+
This page is dedicated to TAMI finance matters. The following resources exists for this purpose:
tami is a registered [[Amuta]] (as of 2014)<br>
 
in this page you can see where the money comes from and where it goes to.
 
  
= How to pay =
+
* TAMI ethercalc budget spreadsheet - https://ethercalc.net/=y5u4nvxzwe
 +
* auto-updating discourse thread (down as of 2019-10) with current bank balance, etc - see https://discourse.telavivmakers.org/t/bank-status-automatically-generated/499
 +
* code to automatically pull bank account info, see https://github.com/telavivmakers/arewerichyet
 +
* '''arnona calculations''' spreadsheet - [[https://docs.google.com/spreadsheets/d/e/2PACX-1vTpiZ7PxhYgtIF17WcVs2z3Bs_rma8_ThH3IPQjZy924An_RCBQWfEadCE6qYH8csVj9LZEYn3fNnY5/pubhtml]]
 +
* there were once accounting scripts under https://gitorious.org/tami/accounting but as of 2019-10 they seem lost.
  
as of 2014, tami is an [[Amuta]], and has a dedicated bank account,its the best way for us to accept money. <br>
+
= Current Status =
as most bills come out of this account and less transaction fees then in case of paypal.<br>
+
As of Jan. 2020 TAMI could '''really''' use additional members, with covid-19 causing major disruption of activity. Current recommended donation sum is approx. 300 ILS/month, the amount needed to cover current expenses (~6k/month) by active members - for more info check out the budged spreadsheet link above.
currently paypal donations go to [[User:AlonLevy]] account which he then transfers to [[amuta]] bank account<br>
 
 
 
== Bank Account Transfer ==
 
U-Bank Account http://u-bank.net
 
 
 
bank number:    26
 
 
 
branch number:  288
 
 
 
account number: 409-429511
 
 
 
account name:  תל אביב מייקרס (ע"ר) 580582278
 
 
 
== Bitcoin ==
 
We don't accept them right now because Alon's wallet is taking too much cpu.
 
 
 
== Paypal ==
 
 
 
{{#widget:TamiPayPal}}
 
  
 +
Last donation round thread which ended on 2019-12 can be found [https://discourse.telavivmakers.org/t/your-annual-s-o-s/791 here].
  
 +
= Membership & Donations =
 +
* TAMI is supported by you and me, Our source of income are donations.
 +
* Recommended membership fees are 200 NIS per month.
 +
* TAMI supports a variety of money transfer options - check the <span style="background: gold; padding: 5px">[[Donate|donations]]</span> page for more info
  
 
= Expenses Overview =
 
= Expenses Overview =
== Rent & Arnona ==
+
For current expense values visit the budget spreadsheet - https://docs.google.com/spreadsheets/d/1ecgCkPMcbQqmYCKitAA2N0yfDn3_-v5iGNHdjmmHoUw
* Rent: 4680 / mo
 
* Arnona: 3000 / mo (109 m^2 non-residential, 60 m^2 residential, area B if I'm not mistaken - see [http://www.tel-aviv.gov.il/Download/%D7%97%D7%95%D7%91%D7%A8%D7%AA%20%D7%A6%D7%95%20%D7%94%D7%90%D7%A8%D7%A0%D7%95%D7%A0%D7%94%20%D7%9C%D7%A9%D7%A0%D7%AA%202011.pdf arnona 2011 tel aviv pdf])
 
Telavivmakers is located in kibutz galuyut 45, we pay a rent of 4680 nis / mo for the whole space,, the arnona of 3000 nis/mo is mostly for the hackerspace area.
 
  
== Others ==
+
* Rent: nn the 6th year of our contract.
* Electricity: ~645 nis / mo (lease no. 5330209) [http://i.imgur.com/3ThiUcM.png pic]
+
* Arnona - see [[Arnona]].
 +
* Electricity: ~1000 / mo, lease no. 5330209 [http://i.imgur.com/3ThiUcM.png pic]
 
* Vaad Bait: 443 / mo (goes to superintendents, Hanan and the other guy, elevators, no idea what else)
 
* Vaad Bait: 443 / mo (goes to superintendents, Hanan and the other guy, elevators, no idea what else)
* Internet: 190 / mo for [[Network|WAN uplink]]
+
* Internet: donated [[Network|WAN uplink]]
* Water?
+
* Water: פקס אביבים 035222306 חוזה מים 10812275
 
 
Any renovation expenses are not included here - paint, hardware (i.e. nails, screws), tools. I think all the tools in the space are either donated or lent for an unspecified period, except small exceptions.
 
 
 
== Sum ==
 
'''Around: 8089''' = 4666+1800+1000+180+443
 
 
 
(due water not being taken into account, plus expendables like trash bags, supposing we buy those occasionally and don't get them as donations).
 
 
 
= Summaries =
 
== 2014 ==
 
=== July ===
 
Total In:
 
 
 
Special:
 
 
 
Cash:
 
* 300 - Amitai
 
 
 
Oscilloscope:
 
* 100 - Yehuda
 
 
 
Paypal:
 
* 192 - ('''new''') Ilan Erlichman
 
 
 
=== June ===
 
Bank account balance:
 
* 7,576.80 (2.7.2014)
 
 
 
Total In: (not including oscilloscope fund, which is separate - as a rule the 'money matters' is about survival, i.e. rent, taxes, amenities. build your own scopes!)
 
* 6674.8
 
Note: this is less then the output, but the previous month we got more, so this is ok for now)
 
 
 
Special:
 
 
 
Cash: (750)
 
* 200 Daniel - no receipt
 
* 400 Frank
 
* 150 - anonymous donations following the pirate party openwrt workshop (16.6.2014).
 
 
 
Oscilloscope (not technically tami but logging it here):
 
* 100 Elad
 
* 100 Alice
 
* 100 Bob
 
* Hungry Scope Box (Noam)
 
 
 
Bank Transfers: (Amuta account) (5400)
 
* 250 Guy
 
* 250 Tzvika
 
* 3000 Alon
 
* 200 Yuval A.
 
* 1500 Yair
 
* 200 Ronen
 
 
 
Paypal: (524.8) (money transfered later to bank account via transfer from Alon as a bulk transfer to avoid transfer costs. Receipts need to be written for everyone individually)
 
* 192 Kobi
 
* 95.4 Tal
 
* 94.9 Paul
 
* 95.4 Jonathan
 
* 47.1 Yuri
 
 
 
Total Out:
 
 
 
=== May ===
 
Total In:
 
* 8816
 
 
 
Special:
 
 
 
Cash:
 
* 200 Daniel - no receipt
 
 
 
Bank Transfers: 7900
 
* 200 Tamar
 
* 3200 Jeremy
 
* 3000 Alon
 
* 250 Tzvika
 
* 250 Guy
 
* 400 Jacob
 
* 600 Daniel K.
 
 
 
Paypal: (716.8)
 
* 95.4 Kfir
 
* 94.9 Paul
 
* 192 Kobi
 
* 95.4 Jonathan
 
* 192 Omri
 
* 47.1 Yuri
 
 
 
Total Out:
 
 
 
=== April ===
 
Total In:
 
* 4566.8
 
 
 
Special:
 
 
 
Cash: (400)
 
* 200 Ronen - no receipt
 
* 200 Daniel - no receipt
 
 
 
Bank transfers: (3450)
 
* 200 Tamar
 
* 3000 Alon
 
* 250 Guy
 
 
 
Paypal: (716.8)
 
* 95.4 Kfir
 
* 94.9 Paul
 
* 192.0 Kobi
 
* 95.4 Jonathan
 
* 192.0 Omri
 
* 47.1 Yuri
 
 
 
Total Out:
 
 
 
Special:
 
25.04.14 Jeremy 800nis more shelves from מקור העמוד ומדף
 
 
 
=== March ===
 
Note: from March 2014 onward the calculation includes only bank transfers to the new Amuta bank account at U-Bank. Paypal is still Alon's and Alon does a transfer that should be written as "paypal tami <month>" for each month (transfer charge on Alon of 1.6 nis). So the fact this month's sum is larger is a lie, it is actually smaller then the previous month's since it includes 3000 nis from Alon which previous month's did not take into account (the amount payed by Alon from now on will be tallied exactly, previous months can be calculated as the difference between the expenses and the income).
 
 
 
Total: 4404.2
 
 
 
Special:
 
 
 
Cash:
 
* 200 Ronen
 
 
 
Bank transfers: (3200)
 
* 3000 Alon
 
* 200 Tamar
 
 
 
Paypal: (1004.2)
 
* Kfir 95.40
 
* Paul 94.90
 
* Kobi 384.00
 
* Jonathan 95.40
 
* Frank 95.40
 
* Omri 192.00
 
* Yuri 47.10
 
 
 
=== February ===
 
Total: 3255.65
 
 
 
Special:
 
* 1880 nis Jeremy for metal shelves.
 
 
 
Cash:
 
* 200 Ronen
 
* 200 Amitai
 
 
 
Bank transfers: 1900
 
* 250 Yaki
 
* 250 - Tzvika
 
* 200 - 3217325
 
* 1200 - Paul, Yonatan, Vitaly
 
 
 
Paypal: 955.65
 
* Omri - 192
 
* Kobi - 192
 
* Kobi - 47.1
 
* Frank - 95.4
 
* Yair - 192
 
* Ariel - 46.85
 
* Paul H. - 94.9
 
* Kfir - 95.4
 
 
 
=== January ===
 
Total: 4815.65
 
 
 
Special:
 
* 1000 nis (900/100 Alon/Moti) for 2 harddrives meant for the server (2 Tera each, Red Western Digital)
 
* 600 nis Alon to Galski for welding table
 
* Alon electric welding mask, don't recall the sum
 
* 340 Jeremy epoxy + bins + nuts & bolts
 
 
 
Cash: 1810
 
* 240 from Donation jar.
 
* 100 Guy M
 
* 200 Daniel
 
* 200 Dan
 
* 270 Amir
 
* 100 Ben G
 
* 300 Uri G
 
* 400 Amitai
 
 
 
Bank transfers: 2050
 
* 400 - Yaki
 
* 200 - 3217325
 
* 250 - Tzvika
 
* 1200 - Paul, Yonatan, Vitaly.
 
 
 
Paypal: 955.65 (after commission - not only a function of the amount!)
 
* 200 - Omri (192)
 
* 200 - Kobi (192)
 
* 50 - Kobi (47.1)
 
* 100 - Frank (95.40)
 
* 200 - Yair (192)
 
* 50 - Ariel (46.85)
 
* 100 - Paul H. (94.90)
 
* 100 - Kfir (95.40)
 
 
 
== 2013 ==
 
=== December ===
 
3300 nis via paypal and bank account this month, not including the Vaad from Yair, Internet via Yual, and electricity via yair, plus arnona not sure what the status is (must phone), and I payed via bank transfer the rent this time, need to make cheques from the amuta that we just got non existent bank account!
 
 
 
I don't have records for any off the books money for December, either I forgot to write or no one brought any.
 
 
 
And bitcoin is right now down - that is I still have my wallet, but I'm not running a bitcoin p2p client.
 
 
 
So:
 
* Bank: 1900
 
** Tzvika, Guy, Ronen, Paul, Yonatan, and one more: 300, 100, 250, 200, 1050
 
* Paypal: 1400
 
** Omri, Kfir, Paul, Ariel, Kobi, Yair, Frank, Ronen: 200, 100, 100, 50, 50, 200, 100, 200, 200, 200
 
 
 
=== November ===
 
#2nd floor renovations
 
amitai: 1500+nis for metal sheets and beam
 
yair: 1000nis for wood boards and beams
 
 
 
Cash: Amitai(200), Uri(400 - technically for last month, but accounted on this month), Ben(100)
 
 
 
=== October ===
 
Total: 3830 nis for october, (4630 including 800 for previous months from Amitai) (~ -4% paypal tax for 1300):
 
# cash: 1030 (1830 counting back payments from Amitai)
 
## 19.10.2013 200 nis from guy mador. welcome guy!
 
## 16.10.2013 200 nis from anonymous coward.
 
## 10.10.2013 305.30 nis from people who came to udi finklstein's talk. thanks everyone! special thanks to udi!
 
## 10.10.2013 250 nis from ehud
 
## 7.10.2013 1000 nis amitai (400 + 400 + 200 now)
 
## 1.10.2013 150 nis from uri
 
# direct bank transfer: 1500 (Paul & Yonatan & Guy Ovadia) (Todo: automate bank leumi over vashav & mail)
 
# paypal: 1300 (Ronen Shouker, Ilan Graicer, Omri Lotan, frank bolton, kobi kaminitz, yair reshef, kobi kaminitz, Ariel Beery, Kfir Bar am)
 
 
 
Expenses
 
# rent: 4680
 
# arnona: 3000~ (TODO: have I actually payed it? scan it here)
 
 
 
Other (payed directly by non-alon-members):
 
# Electricity: ~1000 (Yair - TODO - get the bill, it's bi monthly maybe so this per month makes no sense?)
 
# Vaad Bait: 443 (Yair)
 
# Internet: 190 (Yuval)
 
 
 
= Update Instructions =
 
Update instructions for month cache income (non bank transfer, anything going in the Expense_Transactions_logs section):
 
* get accounting [https://gitorious.org/tami/accounting scripts] localy
 
* cash income
 
** run ./money_matters_summary.py
 
** remove anything that isn't actually a payment from output
 
* paypal
 
** save all paypal messages via thunderbird to a bunch of eml files in /tmp/paypal/*.eml (use filter, ctrl-A, save)
 
** run ./decode_paypal.py /tmp/paypal/ and copy paste output here.