Finances

From syn2cat - HackerSpace.lu
(Difference between revisions)
Jump to: navigation, search
(Automated finances commit)
 
(36 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
* [[Finances 2013|2013]]
+
 
+
== 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==
+
 
+
=== 2014-01===
+
{| class="wikitable sortable" style="width:80%"
+
|+ Transactions for month 2014-01
+
 
|-
 
|-
! Date !! Payee !! Category !! Amount
+
|
 
|-
 
|-
| 2014-01-02 || Anonymized || Membership fee || 9.5
+
| Income
 
|-
 
|-
| 2014-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
 
|-
 
|-
| 2014-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
 
|-
 
|-
| 2014-01-02 || Anonymized || [Split Transaction] || 10.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
 
|-
 
|-
| 2014-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
 
|-
 
|-
| 2014-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
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 9.5
+
| 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
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 114.0
+
|  
 
|-
 
|-
| 2014-01-03 || Anonymized || [Split Transaction] || 256.0
+
| Expense
 
|-
 
|-
| 2014-01-07 || Anonymized || Food & Drinks || 200.0
+
| Account Management || 0.00 || 0.00 || 2.50 || 0.00 || 0.00 || 2.50 || 0.75 || 2.25 || 2.50 || 10.50
 
|-
 
|-
| 2014-01-09 || Anonymized || Membership fee || 9.5
+
| Administrative Expenses || 0.00 || 0.00 || 24.82 || 0.00 || 0.00 || 0.00 || 0.00 || 0.00 || 0.00 || 24.82
 
|-
 
|-
| 2014-01-13 || Anonymized || [Split Transaction] || 100.0
+
| 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
 
|-
 
|-
| 2014-01-16 || Anonymized || [Split Transaction] || 10.0
+
| Food &amp; Drinks || 0.00 || 279.13 || 605.66 || 0.00 || 578.33 || 0.00 || 515.02 || 0.00 || 64.32 || 2,042.46
 
|-
 
|-
| 2014-01-17 || Anonymized || Membership fee || 114.0
+
| Infrastructure || 0.00 || 0.00 || 475.37 || 0.00 || 26.49 || 35.56 || 80.45 || 123.41 || 0.00 || 741.28
 
|-
 
|-
| 2014-01-27 || Anonymized || Membership fee || 9.5
+
| Insurance || 0.00 || 0.00 || 0.00  || 0.00 || 0.00  || 0.00  || 160.85 || 0.00 || 0.00 || 160.85
 
|-
 
|-
| 2014-01-27 || Anonymized || [Split Transaction] || 24.5
+
| LetzHack Radioshow || 0.00 || 0.00 || 105.00 || 70.00 || 0.00 || 70.00 || 0.00 || 70.00 || 0.00 || 315.00
 
|-
 
|-
| 2014-01-28 || Anonymized || Membership fee || 9.5
+
| 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
 
|-
 
|-
| 2014-01-29 || Anonymized || Membership fee || 9.5
+
 +
|
 
|-
 
|-
| 2014-01-30 || 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
|-
+
| 2014-01-30 || Anonymized || [Split Transaction] || 35.0
+
|-
+
! colspan="3" | Total || 968.0
+
 
|}
 
|}
  
 
+
== food & drinks cashbox ==
=== 2014-02===
+
'''transfered to bank account'''
{| class="wikitable sortable" style="width:80%"
+
{| class="wikitable" style="text-align:right;"
|+ Transactions for month 2014-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
 
|-
 
|-
| 2014-02-03 || Anonymized || Membership fee || 9.5
+
| 09.04.16 || 37.00
 
|-
 
|-
| 2014-02-03 || Anonymized || Membership fee || 9.5
+
| 19.04.16 || 36,30
 
|-
 
|-
| 2014-02-03 || Anonymized || Membership fee || 9.5
+
| 28.05.16 || 10,35
 
|-
 
|-
| 2014-02-03 || Anonymized || Membership fee || 9.5
+
| 20.06.16 || 201,36
 
|-
 
|-
| 2014-02-03 || Anonymized || [Split Transaction] || 10.0
+
| 02.07.16 || 85,02
 
|-
 
|-
| 2014-02-04 || Anonymized || Membership fee || 9.5
+
| 11.07.16 || 17,61
 
|-
 
|-
| 2014-02-05 || Anonymized || Membership fee || 57.0
+
| 17.07.16 || 107,67
 
|-
 
|-
| 2014-02-06 || Anonymized || Membership fee || 9.5
+
| 29.08.16 || 34,52
 
|-
 
|-
| 2014-02-06 || Anonymized || Membership fee || 114.0
+
| 24.09.16 || 40,00
 
|-
 
|-
| 2014-02-10 || Anonymized || Membership fee || 9.5
+
| 01.10.16 || 50,00
 
|-
 
|-
| 2014-02-14 || Fonds National De La Recherche || Events: SciFe 2013 || 400.0
+
| 22.10.16 || 13,93
 
|-
 
|-
| 2014-02-17 || Anonymized || [Split Transaction] || 10.0
+
| 22.10.16 || 133,15 || hack.lu
 
|-
 
|-
| 2014-02-26 || Anonymized || [Split Transaction] || 24.5
+
| 12.11.16 || 64,6
 
|-
 
|-
| 2014-02-28 || Anonymized || Membership fee || 9.5
+
| 29.11.16 || 5,02
 
|-
 
|-
! colspan="3" | Total || 691.5
+
|
 +
|-
 +
| Total || 1405,43
 
|}
 
|}
  
 
+
'''bills paid'''
=== 2014-03===
+
{| class="wikitable" style="text-align:right;"
{| class="wikitable sortable" style="width:80%"
+
| date || amount || shop
|+ Transactions for month 2014-03
+
 
|-
 
|-
! Date !! Payee !! Category !! Amount
+
| 06.02.16 || 63.35 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || Membership fee || 9.5
+
| 12.03.16 || 26.96 || Colruyt (ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || Membership fee || 9.5
+
| 28.04.16 || 121,86 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || Membership fee || 9.5
+
| 18.05.16 || 16,10 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || Membership fee || 9.5
+
| 26.05.16 || 10,20 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || Membership fee || 9.5
+
| 26.05.16 || 33,96|| Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || [Split Transaction] || 10.0
+
| 07.07.16 || 29,09 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-03 || Anonymized || [Split Transaction] || 35.0
+
| 22.09.16 || 54,54 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-04 || Anonymized || Membership fee || 9.5
+
| 24.11.16 || 91,51 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-05 || Anonymized || Membership fee || 9.5
+
| 22.12.16 || 46,16 || ? (candys)
 
|-
 
|-
| 2014-03-10 || Anonymized || Food & Drinks || 275.0
+
| 29.12.16 || 24,53 || Colruyt (snacks/ice-cream)
 
|-
 
|-
| 2014-03-10 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -36.2
 
 
|-
 
|-
| 2014-03-10 || Anonymized || Infrastructure: Domains || style="color:red;" | -16.79
+
| Total || 518,26
|-
+
| 2014-03-10 || Commune de Strassen || Administrative Expenses || style="color:red;" | -66.0
+
|-
+
| 2014-03-11 || Anonymized || Membership fee || 114.0
+
|-
+
| 2014-03-17 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2014-03-19 || Anonymized || LetzHack Radioshow || style="color:red;" | -314.0
+
|-
+
| 2014-03-21 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -403.04
+
|-
+
| 2014-03-26 || Anonymized || [Split Transaction] || 24.5
+
|-
+
| 2014-03-28 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-03-31 || BCEE || Account management || style="color:red;" | -2.5
+
|-
+
| 2014-03-31 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-03-31 || Anonymized || [Split Transaction] || 35.0
+
|-
+
| 2014-03-31 || Anonymized || [Split Transaction] || 120.0
+
|-
+
! colspan="3" | Total || style="color:red;" | -129.53
+
 
|}
 
|}
  
 
+
== Archives ==
=== 2014-04===
+
* [[Finances 2012|2012]]
{| class="wikitable sortable" style="width:80%"
+
* [[Finances 2013|2013]]
|+ Transactions for month 2014-04
+
* [[Finances 2014|2014]]
|-
+
! Date !! Payee !! Category !! Amount
+
|-
+
| 2014-04-01 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-01 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-01 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-01 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2014-04-02 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-03 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-08 || Anonymized || Membership fee || 9.5
+
|-
+
| 2014-04-16 || Anonymized || [Split Transaction] || 10.0
+
|-
+
| 2014-04-19 || Anonymized || Infrastructure: General Infrastructure || style="color:red;" | -262.69
+
|-
+
! colspan="3" | Total || style="color:red;" | -185.69
+
|}
+

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