Finances

From syn2cat - HackerSpace.lu
(Difference between revisions)
Jump to: navigation, search
(Automated finances commit)
 
(70 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{TOCright}}
+
== Income and expenses ==
This page is maintained automatically by the Treasurer-bot. This bot parses and anonymizes the data before turning it from csv into wiki syntax to be uploaded to the wiki through the mediawiki API.
+
  
== Archives ==
+
{| class="wikitable" style="text-align:right;"
* [[Finances 2012|2012]]
+
| Account || Jan || Feb || Mar || Apr || May || Jun || Jul || Aug || Sep || Total
 
+
== Legend ==
+
* '''[Split transaction]''' - means that a single transaction has been split into multiple categories. These are mostly (99%) membership fees split into the minimum fee and additional "donations".
+
* '''Anonymized''' - all transactions that are not explicitly de-anonymized will be published anonymously.
+
 
+
<!-- bot fills below here -->
+
==Detail==
+
 
+
=== 2013-01===
+
{| class="wikitable sortable" style="width:80%"
+
|+ Transactions for month 2013-01
+
 
|-
 
|-
! Date !! Payee !! Category !! Amount
+
|
 
|-
 
|-
| 2013-01-02 || Anonymized || Membership fee || 9.5
+
| Income
 
|-
 
|-
| 2013-01-02 || Anonymized || Membership fee || 9.5
+
| Donation || 599.45 || 103.95 || 90.95 || 122.95 || 87,45 || 72,45 || 62,54 || 59,45 || 200,45 || 1399,64
 
|-
 
|-
| 2013-01-02 || Anonymized || Membership fee || 9.5
+
| Events || 16.00 || 16.00 || 2,397.00 || 1,891.00 || 1,651.00 || 461.00 || 106.00 || 871.60 || 16.00 || 7,425.60
 
|-
 
|-
| 2013-01-02 || Anonymized || Food & Drinks || 370.0
+
| Food &amp; Drinks || 185.00 || 263.01 || 120.89 || 73.30 || 10.35 || 201.36 || 210.30 || 34.52 || 40.00 || 1,138.73
 
|-
 
|-
| 2013-01-03 || Anonymized || Membership fee || 9.5
+
| Membership fee || 1,082.00 || 683.00 || 901.50 || 588.00 || 502.50 || 407.50 || 463.50 || 351.50 || 494.00 || 5,473.50
 
|-
 
|-
| 2013-01-03 || Anonymized || Membership fee || 9.5
+
| Projects || 74.42 || 70.00 || 20.00 || 0.00 || 0,00 || 40,00 || 27,70 || 0.0 || 0.0 || 232.12
 
|-
 
|-
| 2013-01-03 || Anonymized || [Split Transaction] || 256.0
+
| Total Income || 1,956.87 || 1,135.96 || 3,530.34 || 2,675.25 || 2,251.30 || 1,182.31 || 870.04 || 1,317.07 || 750.45 || 15,669.59
 
|-
 
|-
| 2013-01-03 || Anonymized || Donation || 50.0
+
|  
 
|-
 
|-
| 2013-01-15 || Anonymized || Infrastructure: Machinery || style="color:red;" | -203.18
+
| Expense
 
|-
 
|-
| 2013-01-16 || Anonymized || Events outgoing: Haxogreen: Material || style="color:red;" | -152.38
+
| Account Management || 0.00 || 0.00 || 2.50 || 0.00 || 0.00 || 2.50 || 0.75 || 2.25 || 2.50 || 10.50
 
|-
 
|-
| 2013-01-16 || InterNetworX Ltd. + Co. KG || Infrastructure: Domains || style="color:red;" | -22.9
+
| Administrative Expenses || 0.00 || 0.00 || 24.82 || 0.00 || 0.00 || 0.00 || 0.00 || 0.00 || 0.00 || 24.82
 
|-
 
|-
| 2013-01-18 || Anonymized || Membership fee || 9.5
+
| Events outgoing || 0.00 || 0.00 || 0.00 || 0.00 || 297.94 || 690.00 || 4,514.08 || 4,226.60 || 316.55 || 10,045.17
 
|-
 
|-
| 2013-01-27 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -427.99
+
| Food &amp; Drinks || 0.00 || 279.13 || 605.66 || 0.00 || 578.33 || 0.00 || 515.02 || 0.00 || 64.32 || 2,042.46
 
|-
 
|-
| 2013-01-27 || Anonymized || Events outgoing: Haxogreen: Material || style="color:red;" | -47.64
+
| Infrastructure || 0.00 || 0.00 || 475.37 || 0.00 || 26.49 || 35.56 || 80.45 || 123.41 || 0.00 || 741.28
 
|-
 
|-
| 2013-01-28 || Anonymized || Electronics outgoing || style="color:red;" | -58.02
+
| Insurance || 0.00 || 0.00 || 0.00  || 0.00 || 0.00  || 0.00  || 160.85 || 0.00 || 0.00 || 160.85
 
|-
 
|-
| 2013-01-28 || Anonymized || Electronics outgoing || style="color:red;" | -20.2
+
| LetzHack Radioshow || 0.00 || 0.00 || 105.00 || 70.00 || 0.00 || 70.00 || 0.00 || 70.00 || 0.00 || 315.00
 
|-
 
|-
| 2013-01-28 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -14.98
+
| Level2 Rent || 400.00 || 400.00 || 400.00 || 400.00 || 400.00 || 400.00 || 400.00 || 400.00 || 400.00 || 3,600.00
 +
|-  
 +
| Total Expense || 400.00 || 679.13 || 1,613.35 || 470.00 || 1302,76 || 1.198,06 || 5,671.15 || 4,822.26 || 783.37 || 16,940.08
 
|-
 
|-
| 2013-01-28 || Anonymized || Electronics outgoing || style="color:red;" | -10.49
+
 +
|
 
|-
 
|-
| 2013-01-28 || Anonymized || Membership fee || 9.5
+
| Grand Total || 1556.87 || 456.83 || 1919,49 || 2205.25 || 948,54 || -15,75 || -4,801.11 || -3,505.19 || -32.92 || -1,270.49
|-
+
| 2013-01-28 || Anonymized || [Split Transaction] || 24.5
+
|-
+
| 2013-01-29 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-01-30 || Anonymized || [Split Transaction] || 35.0
+
|-
+
! colspan="3" | Total || style="color:red;" | -146.28
+
 
|}
 
|}
  
 
+
== food & drinks cashbox ==
=== 2013-02===
+
'''transfered to bank account'''
{| class="wikitable sortable" style="width:80%"
+
{| class="wikitable" style="text-align:right;"
|+ Transactions for month 2013-02
+
| date || amount
 
|-
 
|-
! Date !! Payee !! Category !! Amount
+
| 04.01.16 || 100.00
 +
|-
 +
| 16.01.16 || 85.00
 +
|-
 +
| 01.02.16 || 100.00
 +
|-
 +
| 13.02.16 || 27.64
 +
|-
 +
| 20.02.16 || 80.00
 +
|-
 +
| 27.02.16 || 55.37
 +
|-
 +
| 05.03.16 || 2.46
 +
|-
 +
| 12.03.16 || 74.88
 +
|-
 +
| 26.03.16 || 43.55
 
|-
 
|-
| 2013-02-01 || Anonymized || Membership fee || 9.5
+
| 09.04.16 || 37.00
 
|-
 
|-
| 2013-02-01 || Anonymized || Membership fee || 9.5
+
| 19.04.16 || 36,30
 
|-
 
|-
| 2013-02-01 || Anonymized || Membership fee || 9.5
+
| 28.05.16 || 10,35
 
|-
 
|-
| 2013-02-01 || Anonymized || [Split Transaction] || 10.0
+
| 20.06.16 || 201,36
 
|-
 
|-
| 2013-02-02 || Anonymized || Membership fee || 114.0
+
| 02.07.16 || 85,02
 
|-
 
|-
| 2013-02-04 || Anonymized || Membership fee || 9.5
+
| 11.07.16 || 17,61
 
|-
 
|-
| 2013-02-04 || Anonymized || Membership fee || 9.5
+
| 17.07.16 || 107,67
 
|-
 
|-
| 2013-02-06 || Anonymized || Membership fee || 9.5
+
| 29.08.16 || 34,52
 
|-
 
|-
| 2013-02-11 || Anonymized || Membership fee || 9.5
+
| 24.09.16 || 40,00
 
|-
 
|-
| 2013-02-11 || Anonymized || Infrastructure: Media || style="color:red;" | -24.15
+
| 01.10.16 || 50,00
 
|-
 
|-
| 2013-02-12 || Anonymized || Membership fee || 57.0
+
| 22.10.16 || 13,93
 
|-
 
|-
| 2013-02-12 || Anonymized || Membership fee || 114.0
+
| 22.10.16 || 133,15 || hack.lu
 
|-
 
|-
| 2013-02-16 || Anonymized || Events outgoing: Haxogreen: Promotion material || style="color:red;" | -102.99
+
| 12.11.16 || 64,6
 
|-
 
|-
| 2013-02-18 || Anonymized || [Split Transaction] || 45.0
+
| 29.11.16 || 5,02
 
|-
 
|-
| 2013-02-20 || Anonymized || [Split Transaction] || 10.0
+
|
 
|-
 
|-
| 2013-02-20 || Anonymized || [Split Transaction] || 10.5
+
| Total || 1405,43
|-
+
| 2013-02-22 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -98.9
+
|-
+
| 2013-02-23 || Anonymized || Membership fee || 57.0
+
|-
+
| 2013-02-26 || Anonymized || [Split Transaction] || 24.5
+
|-
+
| 2013-02-26 || syn2cat asbl || Events: Haxogreen: Food & Drinks || 330.0
+
|-
+
| 2013-02-28 || Anonymized || [Split Transaction] || 38.0
+
|-
+
| 2013-02-28 || Anonymized || Membership fee || 114.0
+
|-
+
| 2013-02-28 || Anonymized || Membership fee || 9.5
+
|-
+
! colspan="3" | Total || 773.96
+
 
|}
 
|}
  
 
+
'''bills paid'''
=== 2013-03===
+
{| class="wikitable" style="text-align:right;"
{| class="wikitable sortable" style="width:80%"
+
| date || amount || shop
|+ Transactions for month 2013-03
+
 
|-
 
|-
! Date !! Payee !! Category !! Amount
+
| 06.02.16 || 63.35 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || Membership fee || 9.5
+
| 12.03.16 || 26.96 || Colruyt (ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || Membership fee || 9.5
+
| 28.04.16 || 121,86 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || Membership fee || 9.5
+
| 18.05.16 || 16,10 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || Membership fee || 9.5
+
| 26.05.16 || 10,20 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || [Split Transaction] || 10.0
+
| 26.05.16 || 33,96|| Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-01 || Anonymized || [Split Transaction] || 35.0
+
| 07.07.16 || 29,09 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-04 || Anonymized || Membership fee || 9.5
+
| 22.09.16 || 54,54 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-04 || Anonymized || Membership fee || 9.5
+
| 24.11.16 || 91,51 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-06 || Anonymized || [Split Transaction] || 150.0
+
| 22.12.16 || 46,16 || ? (candys)
 
|-
 
|-
| 2013-03-07 || Anonymized || Membership fee || 9.5
+
| 29.12.16 || 24,53 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2013-03-11 || Anonymized || Membership fee || 9.5
 
 
|-
 
|-
| 2013-03-11 || Anonymized || Membership fee || 114.0
+
| Total || 518,26
|-
+
| 2013-03-18 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2013-03-18 || Anonymized || Food & Drinks || 250.0
+
|-
+
| 2013-03-20 || Anonymized || [Split Transaction] || 512.0
+
|-
+
| 2013-03-26 || Anonymized || [Split Transaction] || 24.5
+
|-
+
| 2013-03-27 || Anonymized || Membership fee || 114.0
+
|-
+
| 2013-03-28 || BCEE || Account management || style="color:red;" | -2.0
+
|-
+
| 2013-03-28 || Anonymized || Membership fee || 9.5
+
|-
+
! colspan="3" | Total || 1303.0
+
 
|}
 
|}
  
 
+
== Archives ==
=== 2013-04===
+
* [[Finances 2012|2012]]
{| class="wikitable sortable" style="width:80%"
+
* [[Finances 2013|2013]]
|+ Transactions for month 2013-04
+
* [[Finances 2014|2014]]
|-
+
! Date !! Payee !! Category !! Amount
+
|-
+
| 2013-04-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-02 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2013-04-02 || Anonymized || [Split Transaction] || 35.0
+
|-
+
| 2013-04-03 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-03 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-04 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-08 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2013-04-09 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-15 || Commune de Strassen || Administrative Expenses || style="color:red;" | -66.0
+
|-
+
| 2013-04-15 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -38.0
+
|-
+
| 2013-04-15 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -200.73
+
|-
+
| 2013-04-15 || Anonymized || Infrastructure: Machinery || style="color:red;" | -172.55
+
|-
+
| 2013-04-15 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -16.5
+
|-
+
| 2013-04-15 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -65.12
+
|-
+
| 2013-04-15 || Anonymized || [Split Transaction] || 65.12
+
|-
+
| 2013-04-16 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2013-04-22 || Anonymized || [Split Transaction] || 200.18
+
|-
+
| 2013-04-26 || Anonymized || [Split Transaction] || 24.5
+
|-
+
| 2013-04-29 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-29 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-04-30 || Anonymized || [Split Transaction] || 35.0
+
|-
+
! colspan="3" | Total || style="color:red;" | -74.1
+
|}
+
 
+
 
+
=== 2013-05===
+
{| class="wikitable sortable" style="width:80%"
+
|+ Transactions for month 2013-05
+
|-
+
! Date !! Payee !! Category !! Amount
+
|-
+
| 2013-05-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-02 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2013-05-03 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-03 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-06 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -151.93
+
|-
+
| 2013-05-06 || InterNetworX Ltd. + Co. KG || Infrastructure: Domains || style="color:red;" | -22.9
+
|-
+
| 2013-05-06 || Anonymized || [Split Transaction] || 140.0
+
|-
+
| 2013-05-07 || Anonymized || Membership fee || 9.5
+
|-
+
| 2013-05-07 || Anonymized || Membership fee || 28.5
+
|-
+
! colspan="3" | Total || 60.67
+
|}
+

Latest revision as of 16:59, 21 January 2017

[edit] Income and expenses

Account Jan Feb Mar Apr May Jun Jul Aug Sep Total
Income
Donation 599.45 103.95 90.95 122.95 87,45 72,45 62,54 59,45 200,45 1399,64
Events 16.00 16.00 2,397.00 1,891.00 1,651.00 461.00 106.00 871.60 16.00 7,425.60
Food & Drinks 185.00 263.01 120.89 73.30 10.35 201.36 210.30 34.52 40.00 1,138.73
Membership fee 1,082.00 683.00 901.50 588.00 502.50 407.50 463.50 351.50 494.00 5,473.50
Projects 74.42 70.00 20.00 0.00 0,00 40,00 27,70 0.0 0.0 232.12
Total Income 1,956.87 1,135.96 3,530.34 2,675.25 2,251.30 1,182.31 870.04 1,317.07 750.45 15,669.59
Expense
Account Management 0.00 0.00 2.50 0.00 0.00 2.50 0.75 2.25 2.50 10.50
Administrative Expenses 0.00 0.00 24.82 0.00 0.00 0.00 0.00 0.00 0.00 24.82
Events outgoing 0.00 0.00 0.00 0.00 297.94 690.00 4,514.08 4,226.60 316.55 10,045.17
Food & Drinks 0.00 279.13 605.66 0.00 578.33 0.00 515.02 0.00 64.32 2,042.46
Infrastructure 0.00 0.00 475.37 0.00 26.49 35.56 80.45 123.41 0.00 741.28
Insurance 0.00 0.00 0.00 0.00 0.00 0.00 160.85 0.00 0.00 160.85
LetzHack Radioshow 0.00 0.00 105.00 70.00 0.00 70.00 0.00 70.00 0.00 315.00
Level2 Rent 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 3,600.00
Total Expense 400.00 679.13 1,613.35 470.00 1302,76 1.198,06 5,671.15 4,822.26 783.37 16,940.08
Grand Total 1556.87 456.83 1919,49 2205.25 948,54 -15,75 -4,801.11 -3,505.19 -32.92 -1,270.49

[edit] food & drinks cashbox

transfered to bank account

date amount
04.01.16 100.00
16.01.16 85.00
01.02.16 100.00
13.02.16 27.64
20.02.16 80.00
27.02.16 55.37
05.03.16 2.46
12.03.16 74.88
26.03.16 43.55
09.04.16 37.00
19.04.16 36,30
28.05.16 10,35
20.06.16 201,36
02.07.16 85,02
11.07.16 17,61
17.07.16 107,67
29.08.16 34,52
24.09.16 40,00
01.10.16 50,00
22.10.16 13,93
22.10.16 133,15 hack.lu
12.11.16 64,6
29.11.16 5,02
Total 1405,43

bills paid

date amount shop
06.02.16 63.35 Colruyt (snacks/ice-cream)
12.03.16 26.96 Colruyt (ice-cream)
28.04.16 121,86 Colruyt (snacks/ice-cream)
18.05.16 16,10 Colruyt (snacks/ice-cream)
26.05.16 10,20 Colruyt (snacks/ice-cream)
26.05.16 33,96 Colruyt (snacks/ice-cream)
07.07.16 29,09 Colruyt (snacks/ice-cream)
22.09.16 54,54 Colruyt (snacks/ice-cream)
24.11.16 91,51 Colruyt (snacks/ice-cream)
22.12.16 46,16  ? (candys)
29.12.16 24,53 Colruyt (snacks/ice-cream)
Total 518,26

[edit] Archives

Personal tools
Namespaces

Variants
Actions
Navigation
syn2cat
Hackerspace
Activities
Initiatives
Community
Tools
Tools