Finances

From syn2cat - HackerSpace.lu
(Difference between revisions)
Jump to: navigation, search
(Automated finances commit)
 
(45 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
 +
|-
 +
|
 +
|-
 +
| 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
 +
|}
  
== Legend ==
+
== food & drinks cashbox ==
* '''[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".
+
'''transfered to bank account'''
* '''Anonymized''' - all transactions that are not explicitly de-anonymized will be published anonymously.
+
{| class="wikitable" style="text-align:right;"
 
+
| date || amount
<!-- bot fills below here -->
+
==Detail==
+
 
+
=== 2014-01===
+
{| class="wikitable sortable" style="width:80%"
+
|+ Transactions for month 2014-01
+
 
|-
 
|-
! 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-01-02 || Anonymized || Membership fee || 9.5
+
| 09.04.16 || 37.00
 
|-
 
|-
| 2014-01-02 || Anonymized || Membership fee || 9.5
+
| 19.04.16 || 36,30
 
|-
 
|-
| 2014-01-02 || Anonymized || Membership fee || 9.5
+
| 28.05.16 || 10,35
 
|-
 
|-
| 2014-01-02 || Anonymized || [Split Transaction] || 10.0
+
| 20.06.16 || 201,36
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 9.5
+
| 02.07.16 || 85,02
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 9.5
+
| 11.07.16 || 17,61
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 9.5
+
| 17.07.16 || 107,67
 
|-
 
|-
| 2014-01-03 || Anonymized || Membership fee || 114.0
+
| 29.08.16 || 34,52
 
|-
 
|-
| 2014-01-03 || Anonymized || [Split Transaction] || 256.0
+
| 24.09.16 || 40,00
 
|-
 
|-
| 2014-01-07 || Anonymized || Food & Drinks || 200.0
+
| 01.10.16 || 50,00
 
|-
 
|-
| 2014-01-09 || Anonymized || Membership fee || 9.5
+
| 22.10.16 || 13,93
 
|-
 
|-
| 2014-01-13 || Anonymized || [Split Transaction] || 100.0
+
| 22.10.16 || 133,15 || hack.lu
 
|-
 
|-
| 2014-01-16 || Anonymized || [Split Transaction] || 10.0
+
| 12.11.16 || 64,6
 
|-
 
|-
| 2014-01-17 || Anonymized || Membership fee || 114.0
+
| 29.11.16 || 5,02
 
|-
 
|-
! colspan="3" | Total || 870.5
+
|
 +
|-
 +
| Total || 1405,43
 
|}
 
|}
 +
 +
'''bills paid'''
 +
{| class="wikitable" style="text-align:right;"
 +
| 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
 +
|}
 +
 +
== Archives ==
 +
* [[Finances 2012|2012]]
 +
* [[Finances 2013|2013]]
 +
* [[Finances 2014|2014]]

Latest revision as of 17: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