Difference between revisions of "ALV December 2020/Financial report 2019 candidate"

From Technologia Incognita
Jump to: navigation, search
(Created page with "== THIS IS A PROVISIONAL REPORT AND NOT APPROVED YET BY THE KAS COMMISSIE == = Financial Report 2019 = This is the financial report of Vereniging Technologia Incognita for 2...")
 
m (Qguv moved page Financial report 2019 to ALV December 2020/Financial report 2019 candidate without leaving a redirect: not the official report, just a candidate that was rejected)
 
(2 intermediate revisions by 2 users not shown)
Line 7: Line 7:
 
== Balances overview ==
 
== Balances overview ==
  
At the start and end of the year, our bank accounts held the following
+
At the start and end of the year, our bank accounts held the following amounts:
amounts:
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|+ 2019 account balances
 
|+ 2019 account balances
 
! Account
 
! Account
 +
! 2019-01-01
 
! 2019-12-31
 
! 2019-12-31
! 2019-01-01
 
 
! Change
 
! Change
 
|-
 
|-
| ABN AMRO (membership) || €9092.53 || €10453.49 || €-1360.96
+
| ABN AMRO (membership) || €10453.49 || €9092.53 || €-1360.96
 
|-
 
|-
 
| ABN AMRO (savings) || €583.04 || €583.04 || €0.00
 
| ABN AMRO (savings) || €583.04 || €583.04 || €0.00
 
|-
 
|-
| Triodos (drinks) || €664.29 || €628.61 || €35.68
+
| Triodos (drinks) || €628.61 || €664.29 || €35.68
 
|-
 
|-
 
| '''Total''' || €11665.14 || €10339.86 || €-1325.28
 
| '''Total''' || €11665.14 || €10339.86 || €-1325.28
Line 29: Line 28:
 
|+ Balance for 2019
 
|+ Balance for 2019
 
! Activa/assets
 
! Activa/assets
 +
! 2019-01-01
 
! 2019-12-31
 
! 2019-12-31
 +
! Passiva/Liabilities
 
! 2019-01-01
 
! 2019-01-01
! Passiva/Liabilities
 
 
! 2019-12-31
 
! 2019-12-31
! 2019-01-01
 
 
|-
 
|-
| '''Checking''' || €9092.53 || €10453.49 || '''Equity''' || €9262.07 ||
+
| '''Current assets''' || || || '''Equity''' || ||
€11586.02
+
|-
 +
| Owed member contributions ||  || €0.00 || Expendable assets (Besteedbaar vermogen) || €11586.02 || €9417.21
 +
|-
 +
| Outstanding Triodos deposits ||  || €139,00 || || ||
 +
|-
 +
| Ahead of time paid rent || €0.00 || €0.00  || || ||
 +
|-
 +
| Stock (drinks) ||  €0.00  ||  €0.00  || || ||
 +
|-
 +
| '''Liquid assets''' || || || '''Short term debt''' ||
 +
|-
 +
| Checking || €10453.49 || €9092.53 || Credits in drinks || €0.00 || €73.86
 
|-
 
|-
| '''Savings''' || €583.04 || €583.04 || '''AoT-member-payment''' ||
+
| Savings || €583.04 || €583.04 || AoT-member-payment || €1153.33 || €1632.00
€1632.00 || €1153.33
 
 
|-
 
|-
| '''Triodos''' || €664.29 || €628.61 || '''Fob-deposit''' || €1908.00
+
| Triodos || €628.61 || €664.29 || Fob-deposit || €1728.00 || €1818.00  
|| €1728.00
 
 
|-
 
|-
| '''Collateral''' || €2802.21 || €2802.21 || '''3d-printer-pledge''' ||
+
| Rent Deposit (previously called Collateral) || €2802.21 || €2802.21 || 3d-printer-pledge || €0.00 || €340.00  
€340.00 || €0.00
 
 
|-
 
|-
| '''AOT-Rent''' || €0.00 || €0.00 || || ||
+
| AOT-Rent || €0.00 || €0.00 || || ||
 
|-
 
|-
| '''Total''' || '''€13142.07''' || '''€14467.35''' || '''Total'''  ||
+
| '''Total''' || '''€14467.35''' || '''€13281.07'''|| '''Total'''  || '''€14467.35''' || '''€13281.07'''
€13142.07 || €14467.35
 
 
|}
 
|}
  
'''Notes:'''
+
The loss of '''€1186.28''' can be attributed to us paying more in
 +
rent than we received in member income. Some of this could be offset by putting
 +
a number on the "Owed member contributions", which is currently set to zero,
 +
since it is currently hard to get an accurate representation of how much money
 +
the members owed us at the time - the number is easier to calculate for the
 +
current day, but harder going back. For the 2020 report, we would have an
 +
estimate for a write-off for the past, and the 2021 report would have accurate
 +
numbers. If one adds '''€139.00''' to that number, we get the '''€1325.28''', which is the difference between our bank accounts at start
 +
and end of the year.
 +
 
 +
The difference between our equity at the start and end of the year, minus the
 +
'''€1186.28''' and '''€139.00''' is '''€843.52''',
 +
which is the sum of the difference in the '''Short term debt''' section. So
 +
because we have a larger AOT member payment, a credit in drinks, more fob
 +
deposits and a 3d printer pledge that (at the end of the year) had to be paid,
 +
our equity decrease more than just the difference in our bank accounts.
 +
 
 +
The collateral of '''€2802.21''' is the deposit that the association
 +
has paid to our landlord.
 +
 
 +
The '''€73.86''' in "Credits in drinks" are receipts that had been
 +
provided to us but had not yet been paid to the person in question in 2019;
 +
this has since been rectified.
 +
 
 +
The '''€139.00''' in "Outstanding Triodos deposits" is an amount that we
 +
expected to have had deposited into our account, but has not actually been
 +
deposited. In total 264 euro does not seem to fully match specific deposits,
 +
but on the other hand 125 euro has been deposited that also does not match any
 +
specific deposit requests. So we are stating 139 euro as "unaccounted" for. It
 +
is also possible that this number simply exists because of typo in the emails
 +
that were sent (and are the only trace of) counting the money from the safe.
 +
 
 +
The '''€1818.00''' is based on the people that were a member
 +
at the end of the year and had a fob.
 +
 
 +
The '''€1632.00''' is the amount of money that was paid in advance by
 +
members, that is, membership for 2020 that was paid ahead of time. This number
 +
is a rough estimate, based on what we expect members to pay.
 +
 
 +
AOT (ahead-of-time) rent refers to rent payments made by the association in
 +
year X for year X+1. We did not do this in 2019, but for consistency with
 +
previous reports in years where this was done, we include the entry here.
 +
 
 +
== Misc notes ==
  
* AOT (ahead-of-time) member payments refer to dues pre-paid for future
+
We discovered 65 euro worth of drinks payment transfered to the association account, rather than the drinks account.
months by some members, as a consequence of paying a batch of months at
 
a time.
 
* AOT (ahead-of-time) rent refers to rent payments made by the
 
association in year X for year X+1. We did not do this in 2019, but for
 
consistency with previous reports in years where this was done, we
 
include the entry here.
 
* We discovered when looking at the financial administration that the
 
treasurer transfered 8 euro to little to the association account. This
 
will be fixed in the 2020 report.
 
* We discovered 65 euro worth of drinks payment transfered to the
 
association account, rather than the drinks account.
 
  
== Transactions overview ==
+
== Income ==
  
Total income over 2019 was '''€19046.78''', comprised of the following
+
Total income over 2019 was '''€21606.84''', comprised of the following income categories:
income categories:
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|+ 2019 income
 
|+ 2019 income
 
! Category
 
! Category
! Amount
+
! Paid into ABN
 +
! Paid into Triodos
 +
! Total
 +
|-
 +
| member || €16640.98 || €0.00 || €16640.98
 +
|-
 +
| drinks || €65.00 || €2595.74 || €2660.74
 +
|-
 +
| service_costs_returned || €1601.12 || €0.00 || €1601.12
 
|-
 
|-
| member || €18451.10
+
| income_3dprinter || €340.00 || €0.00 || €340.00
 
|-
 
|-
| income_3dprinter || €340.00
+
| donation || €174.00 || €0.00 || €174.00
 
|-
 
|-
| donation || €120.00
+
| prop_sales || €100.00 || €0.00 || €100.00
 
|-
 
|-
| prop_sales || €100.00
+
| fob_deposit || €90.00 || €0.00 || €90.00
 
|-
 
|-
| '''Total''' || €19046.78
+
| '''Total''' || €19011.10 || €2595.74 || €21606.84
 
|}
 
|}
  
Total expenses over 2019 add up to '''€-20372.06''', comprised of the
+
Total expenses over 2019 add up to '''€-22932.12''', comprised of the following expense categories:
following expense categories:
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|+ 2019 expenses
 
|+ 2019 expenses
 
! Category
 
! Category
 +
! Paid from ABN
 +
! Paid from Triodos
 
! Total
 
! Total
 
|-
 
|-
| rent || €-18949.80
+
| rent || €-18949.80 || €0.00 || €-18949.80
 
|-
 
|-
| server_disk_purchase || €-322.29
+
| drinks || €0.00 || €-2378.66 || €-2378.66
 
|-
 
|-
| new_fob_purchase || €-217.80
+
| server_disk_purchase || €-322.29 || €0.00 || €-322.29
 
|-
 
|-
| knoxbox_purchase || €-169.00
+
| fee || €-126.00 || €-181.40 || €-307.40
 
|-
 
|-
| web || €-144.48
+
| new_fob_purchase || €-217.80 || €0.00 || €-217.80
 
|-
 
|-
| fee || €-126.00
+
| knoxbox_purchase || €-169.00 || €0.00 || €-169.00
 
|-
 
|-
| circuit_breaker_purchase || €-117.49
+
| web || €-144.48 || €0.00 || €-144.48
 
|-
 
|-
| ikea_purchase || €-106.47
+
| circuit_breaker_purchase || €-117.49 || €0.00 || €-117.49
 
|-
 
|-
| storage_organizers_purchase || €-58.94
+
| samla_purchase || €-106.47 || €0.00 || €-106.47
 
|-
 
|-
| domains || €-44.75
+
| storage_organizers_purchase || €-58.94 || €0.00 || €-58.94
 
|-
 
|-
| feeding_volunteers || €-41.50
+
| domains || €-44.75 || €0.00 || €-44.75
 
|-
 
|-
| fob_return || €-36.00
+
| feeding_volunteers || €-41.50 || €0.00 || €-41.50
 
|-
 
|-
| squares_purchase || €-22.62
+
| fob_return || €-36.00 || €0.00 || €-36.00
 
|-
 
|-
| rulers_purchase || €-7.59
+
| squares_purchase || €-22.62 || €0.00 || €-22.62
 
|-
 
|-
| ecotools_purchase || €-7.32
+
| rulers_purchase || €-7.59 || €0.00 || €-7.59
 
|-
 
|-
| tiny_payment_to_reestablish_contact || €-0.01
+
| ecotools_purchase || €-7.32 || €0.00 || €-7.32
 
|-
 
|-
| '''Total''' || €-20372.06
+
| tiny_payment_to_reestablish_contact || €-0.01 || €0.00 || €-0.01
 +
|-
 +
| '''Total''' || €-20372.06 || €-2560.06 || €-22932.12
 
|}
 
|}
  
The difference of our income and our expenses gives the amount we gained
+
The difference of our income and our expenses gives the amount we gained or lost for the year. '''In the case of 2019, we lost €1325.28.'''
or lost for the year. '''In the case of 2019, we lost €1325.28.'''
 
  
 
'''Notes:'''
 
'''Notes:'''
  
* We used a 0.01 cent transaction to seek communication with a member
+
* The board used a €0.01 transaction to seek communication with a member who didn't have a form
who we didn't had a form for.
+
* samla_purchase are IKEA purchases for SAMLA plastic organizers (and some ziploc bags)
* Ikea purchases are the samla storage boxes.
+
* storage_organizers_purchase is a purchase of plastic boxes for storage and transport of electronic waste (WEEE)
* Fee are our banking costs of both ABN Amro and Triodos
+
* fee are our banking costs of ABN-AMRO and Triodos
 +
* fob_purchase is when members buy fobs from the space
 +
* new_fob_purchase is when the space buys fobs from our landlord
 +
* fob_return is when we repay members when they return their fobs
 +
* service_costs_returned represents a refund from our landlord for the service costs (included in our rent) that were overestimated and that we therefore overpaid
 +
* squares_purchase was a purchase of try-squares (winkelhaken), a measuring tool for the dirty room
 +
* knoxbox_purchase was a purchase of a safe
 +
* ecotools_purchase was a purchase of torx 10 bit and a magnetic bitholder
  
 
== Data integrity checks ==
 
== Data integrity checks ==
Line 146: Line 200:
 
All the following values should be equal:
 
All the following values should be equal:
  
* Our reported loss of €1325.28, expressed with the appropriate sign:
+
* Our reported loss of €1325.28, expressed with the appropriate sign: €-1325.28
€-1325.28
+
* The sum of the balance changes over all accounts: €-1360.96 + €0.00 + €35.68 == €-1325.28
* The sum of the balance changes over all accounts: €-1360.96 + €0.00 +
+
* The difference of our income and our expenses: €21606.84 + €-22932.12 == €-1325.28
€35.68 == €-1325.28
+
* The difference between activa at the end of the year and activa at the beginning of the year, with the "outstanding triodos deposits" subtracted out (as they are "virtual" and not liquid): €13281.07 - €14467.35 - €139.00 == €-1325.28
* The difference of our income and our expenses: €19046.78 + €-20372.06
+
* The difference between passiva at the end of the year and passiva at the beginning of the year, with the "outstanding triodos deposits" subtracted out (as they are "virtual" and not liquid): €13281.07 - €14467.35 - €139.00 == €-1325.28
== €-1325.28
 
  
 
== New members ==
 
== New members ==
  
 
In 2019, '''24 new members joined'''.
 
In 2019, '''24 new members joined'''.
Before 2020, board tooling did not track the date that former members
+
Before 2020, board tooling did not track the date that former members deactivate their membership, so it's not clear how many people ended their membership in 2019.
deactivate their membership, so it's not clear how many people ended
 
their membership in 2019.
 
  
 
== Membership pre-payment ==
 
== Membership pre-payment ==
  
Some members pre-pay several months of membership fees at a time. This
+
Some members pre-pay several months of membership fees at a time. This affects our forecasting, since these payments should not be counted on for monthly income during the period that was pre-paid.
affects our forecasting, since these payments should not be counted on
 
for monthly income during the period that was pre-paid.
 
  
Before 2020, board tooling didn't keep track of expected membership dues
+
Before 2020, board tooling didn't keep track of expected membership dues per member, so the unit for these numbers is simply "number of months pre-paid" instead of "amount of money pre-paid".
per member, so the unit for these numbers is simply "number of months
+
However, in the balance we have a good indicator of how much that ends up being.
pre-paid" instead of "amount of money pre-paid".
 
However, in the balance we have a good indicator of how much that ends
 
up being.
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 210: Line 256:
 
== Rent payment ==
 
== Rent payment ==
  
Rent was paid 12 times in 2019. There was no ahead-of-time rent payment
+
Rent was paid 12 times in 2019. There was no ahead-of-time rent payment in 2018 nor was there any pre-payment for 2020.
in 2018 nor was there any pre-payment for 2020.
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 246: Line 291:
 
|}
 
|}
  
Due to a banking glitch at ABN Amro,, rent was paid twice on 2019-01-02.
+
Due to a banking glitch at ABN Amro,, rent was paid twice on 2019-01-02. This was discovered in 2019-05 when the 2019-06 rent was being paid. The treasurer requested for the duplicate payment to be applied to rent for 2019-06, which Urban Resort (our landlord) did. We paid rent twice in September as we forgot to pay rent in August.
This was discovered in 2019-05 when the 2019-06 rent was being paid. The
 
treasurer requested for the duplicate payment to be applied to rent for
 
2019-06, which Urban Resort (our landlord) did. We paid rent twice in
 
September as we forgot to pay rent in August.
 
  
 
== Monthly breakdown ==
 
== Monthly breakdown ==
Line 261: Line 302:
 
! Change
 
! Change
 
|-
 
|-
| 2019-01 || €1723.00 || €-4712.99 || €-2989.99
+
| 2019-01 || €2058.00 || €-5189.68 || €-3131.68
 
|-
 
|-
| 2019-02 || €1210.00 || €-590.30 || €619.70
+
| 2019-02 || €1402.30 || €-610.30 || €792.00
 
|-
 
|-
| 2019-03 || €1780.00 || €-3442.05 || €-1662.05
+
| 2019-03 || €2113.50 || €-3690.98 || €-1577.48
 
|-
 
|-
| 2019-04 || €1240.00 || €-1604.02 || €-364.02
+
| 2019-04 || €1641.00 || €-1756.53 || €-115.53
 
|-
 
|-
| 2019-05 || €2130.00 || €-22.54 || €2107.46
+
| 2019-05 || €2356.50 || €-412.38 || €1944.12
 
|-
 
|-
| 2019-06 || €1398.00 || €-22.54 || €1375.46
+
| 2019-06 || €1500.79 || €-124.93 || €1375.86
 
|-
 
|-
| 2019-07 || €1425.00 || €-3429.98 || €-2004.98
+
| 2019-07 || €1712.40 || €-3756.21 || €-2043.81
 
|-
 
|-
| 2019-08 || €1200.00 || €-22.54 || €1177.46
+
| 2019-08 || €1240.00 || €-37.54 || €1202.46
 
|-
 
|-
| 2019-09 || €1321.00 || €-3230.31 || €-1909.31
+
| 2019-09 || €1575.95 || €-3555.70 || €-1979.75
 
|-
 
|-
| 2019-10 || €1265.01 || €-22.54 || €1242.47
+
| 2019-10 || €1368.01 || €-443.72 || €924.29
 
|-
 
|-
| 2019-11 || €1473.01 || €-1654.89 || €-181.88
+
| 2019-11 || €1671.66 || €-1712.79 || €-41.13
 
|-
 
|-
| 2019-12 || €2846.08 || €-1617.36 || €1228.72
+
| 2019-12 || €2966.73 || €-1641.36 || €1325.37
 
|-
 
|-
| '''Total 2019''' || '''€19046.78''' || '''€-20372.06''' || '''€-1325.28'''
+
| '''Total 2019''' || '''€21606.84''' || '''€-22932.12''' || '''€-1325.28'''
 
|}
 
|}
  
Line 298: Line 339:
 
! Total
 
! Total
 
|-
 
|-
| rent || €0.00 || €-4690.44 || €-4690.44
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| member || €1665.00 || €0.00 || €1665.00
 
|-
 
|-
| member || €1723.00 || €0.00 || €1723.00
+
| fob_deposit || €54.00 || €0.00 || €54.00
 
|-
 
|-
 
| tiny_payment_to_reestablish_contact || €0.00 || €-0.01 || €-0.01
 
| tiny_payment_to_reestablish_contact || €0.00 || €-0.01 || €-0.01
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| fee || €0.00 || €-37.63 || €-37.63
 +
|-
 +
| drinks || €335.00 || €-449.56 || €-114.56
 +
|-
 +
| donation || €4.00 || €0.00 || €4.00
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| rent || €0.00 || €-4690.44 || €-4690.44
 
|-
 
|-
| '''Total 2019-01''' || '''€1723.00''' || '''€-4712.99''' ||
+
| '''Total 2019-01''' || '''€2058.00''' || '''€-5189.68''' || '''€-3131.68'''
'''€-2989.99'''
 
 
|}
 
|}
  
Line 319: Line 365:
 
! Total
 
! Total
 
|-
 
|-
| ikea_purchase || €0.00 || €-49.85 || €-49.85
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| domains || €0.00 || €-26.62 || €-26.62
 +
|-
 +
| fee || €0.00 || €-30.50 || €-30.50
 
|-
 
|-
 
| member || €1210.00 || €0.00 || €1210.00
 
| member || €1210.00 || €0.00 || €1210.00
 +
|-
 +
| drinks || €192.30 || €0.00 || €192.30
 
|-
 
|-
 
| server_disk_purchase || €0.00 || €-322.29 || €-322.29
 
| server_disk_purchase || €0.00 || €-322.29 || €-322.29
 +
|-
 +
| samla_purchase || €0.00 || €-49.85 || €-49.85
 
|-
 
|-
 
| knoxbox_purchase || €0.00 || €-169.00 || €-169.00
 
| knoxbox_purchase || €0.00 || €-169.00 || €-169.00
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| '''Total 2019-02''' || '''€1402.30''' || '''€-610.30''' || '''€792.00'''
|-
 
| domains || €0.00 || €-26.62 || €-26.62
 
|-
 
| web || €0.00 || €-12.04 || €-12.04
 
|-
 
| '''Total 2019-02''' || '''€1210.00''' || '''€-590.30''' || '''€619.70'''
 
 
|}
 
|}
  
Line 343: Line 391:
 
! Total
 
! Total
 
|-
 
|-
| ikea_purchase || €0.00 || €-56.62 || €-56.62
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| member || €1715.00 || €0.00 || €1715.00
 +
|-
 +
| storage_organizers_purchase || €0.00 || €-58.94 || €-58.94
 
|-
 
|-
| rent || €0.00 || €-3126.96 || €-3126.96
+
| fee || €0.00 || €-10.50 || €-10.50
 
|-
 
|-
| member || €1780.00 || €0.00 || €1780.00
+
| feeding_volunteers || €0.00 || €-41.50 || €-41.50
 
|-
 
|-
| fob_return || €0.00 || €-18.00 || €-18.00
+
| samla_purchase || €0.00 || €-56.62 || €-56.62
 
|-
 
|-
| storage_organizers_purchase || €0.00 || €-58.94 || €-58.94
+
| drinks || €398.50 || €-248.93 || €149.57
 
|-
 
|-
 
| circuit_breaker_purchase || €0.00 || €-117.49 || €-117.49
 
| circuit_breaker_purchase || €0.00 || €-117.49 || €-117.49
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| fob_return || €0.00 || €-18.00 || €-18.00
 
|-
 
|-
| feeding_volunteers || €0.00 || €-41.50 || €-41.50
+
| rent || €0.00 || €-3126.96 || €-3126.96
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-03''' || '''€2113.50''' || '''€-3690.98''' || '''€-1577.48'''
|-
 
| '''Total 2019-03''' || '''€1780.00''' || '''€-3442.05''' ||
 
'''€-1662.05'''
 
 
|}
 
|}
  
Line 372: Line 421:
 
! Total
 
! Total
 
|-
 
|-
| rent || €0.00 || €-1563.48 || €-1563.48
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| fob_return || €0.00 || €-18.00 || €-18.00
 
|-
 
|-
 
| member || €1220.00 || €0.00 || €1220.00
 
| member || €1220.00 || €0.00 || €1220.00
 
|-
 
|-
| fob_return || €0.00 || €-18.00 || €-18.00
+
| fee || €0.00 || €-41.76 || €-41.76
 +
|-
 +
| drinks || €401.00 || €-121.25 || €279.75
 
|-
 
|-
 
| donation || €20.00 || €0.00 || €20.00
 
| donation || €20.00 || €0.00 || €20.00
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| rent || €0.00 || €-1563.48 || €-1563.48
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-04''' || '''€1641.00''' || '''€-1756.53''' || '''€-115.53'''
|-
 
| '''Total 2019-04''' || '''€1240.00''' || '''€-1604.02''' || '''€-364.02'''
 
 
|}
 
|}
  
Line 394: Line 445:
 
! Total
 
! Total
 
|-
 
|-
| member || €2130.00 || €0.00 || €2130.00
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| drinks || €226.50 || €-389.84 || €-163.34
 +
|-
 +
| member || €2120.00 || €0.00 || €2120.00
 +
|-
 +
| donation || €10.00 || €0.00 || €10.00
 
|-
 
|-
 
| fee || €0.00 || €-10.50 || €-10.50
 
| fee || €0.00 || €-10.50 || €-10.50
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-05''' || '''€2356.50''' || '''€-412.38''' || '''€1944.12'''
|-
 
| '''Total 2019-05''' || '''€2130.00''' || '''€-22.54''' || '''€2107.46'''
 
 
|}
 
|}
  
Line 410: Line 465:
 
! Total
 
! Total
 
|-
 
|-
| member || €1398.00 || €0.00 || €1398.00
+
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| drinks || €102.79 || €-102.39 || €0.40
 +
|-
 +
| member || €1380.00 || €0.00 || €1380.00
 +
|-
 +
| fob_deposit || €18.00 || €0.00 || €18.00
 
|-
 
|-
 
| fee || €0.00 || €-10.50 || €-10.50
 
| fee || €0.00 || €-10.50 || €-10.50
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-06''' || '''€1500.79''' || '''€-124.93''' || '''€1375.86'''
|-
 
| '''Total 2019-06''' || '''€1398.00''' || '''€-22.54''' || '''€1375.46'''
 
 
|}
 
|}
  
Line 428: Line 487:
 
| web || €0.00 || €-12.04 || €-12.04
 
| web || €0.00 || €-12.04 || €-12.04
 
|-
 
|-
| rent || €0.00 || €-3189.64 || €-3189.64
+
| fob_deposit || €18.00 || €0.00 || €18.00
 +
|-
 +
| member || €1367.00 || €0.00 || €1367.00
 +
|-
 +
| new_fob_purchase || €0.00 || €-217.80 || €-217.80
 +
|-
 +
| fee || €0.00 || €-42.65 || €-42.65
 
|-
 
|-
| member || €1425.00 || €0.00 || €1425.00
+
| drinks || €287.40 || €-294.08 || €-6.68
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| donation || €40.00 || €0.00 || €40.00
 
|-
 
|-
| new_fob_purchase || €0.00 || €-217.80 || €-217.80
+
| rent || €0.00 || €-3189.64 || €-3189.64
 
|-
 
|-
| '''Total 2019-07''' || '''€1425.00''' || '''€-3429.98''' ||
+
| '''Total 2019-07''' || '''€1712.40''' || '''€-3756.21''' || '''€-2043.81'''
'''€-2004.98'''
 
 
|}
 
|}
  
Line 446: Line 510:
 
! Expenses
 
! Expenses
 
! Total
 
! Total
 +
|-
 +
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| drinks || €40.00 || €-15.00 || €25.00
 
|-
 
|-
 
| member || €1200.00 || €0.00 || €1200.00
 
| member || €1200.00 || €0.00 || €1200.00
Line 451: Line 519:
 
| fee || €0.00 || €-10.50 || €-10.50
 
| fee || €0.00 || €-10.50 || €-10.50
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-08''' || '''€1240.00''' || '''€-37.54''' || '''€1202.46'''
|-
 
| '''Total 2019-08''' || '''€1200.00''' || '''€-22.54''' || '''€1177.46'''
 
 
|}
 
|}
  
Line 463: Line 529:
 
! Total
 
! Total
 
|-
 
|-
| rent || €0.00 || €-3189.64 || €-3189.64
+
| web || €0.00 || €-12.04 || €-12.04
 
|-
 
|-
 
| member || €1221.00 || €0.00 || €1221.00
 
| member || €1221.00 || €0.00 || €1221.00
 
|-
 
|-
| donation || €100.00 || €0.00 || €100.00
+
| fee || €0.00 || €-50.50 || €-50.50
 +
|-
 +
| domains || €0.00 || €-18.13 || €-18.13
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| drinks || €254.95 || €-285.39 || €-30.44
 
|-
 
|-
| domains || €0.00 || €-18.13 || €-18.13
+
| donation || €100.00 || €0.00 || €100.00
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| rent || €0.00 || €-3189.64 || €-3189.64
 
|-
 
|-
| '''Total 2019-09''' || '''€1321.00''' || '''€-3230.31''' ||
+
| '''Total 2019-09''' || '''€1575.95''' || '''€-3555.70''' || '''€-1979.75'''
'''€-1909.31'''
 
 
|}
 
|}
  
Line 485: Line 552:
 
! Expenses
 
! Expenses
 
! Total
 
! Total
 +
|-
 +
| web || €0.00 || €-12.04 || €-12.04
 +
|-
 +
| drinks || €103.00 || €-390.32 || €-287.32
 
|-
 
|-
 
| member || €1110.01 || €0.00 || €1110.01
 
| member || €1110.01 || €0.00 || €1110.01
|-
 
| fee || €0.00 || €-10.50 || €-10.50
 
 
|-
 
|-
 
| income_3dprinter || €155.00 || €0.00 || €155.00
 
| income_3dprinter || €155.00 || €0.00 || €155.00
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| fee || €0.00 || €-41.36 || €-41.36
 
|-
 
|-
| '''Total 2019-10''' || '''€1265.01''' || '''€-22.54''' || '''€1242.47'''
+
| '''Total 2019-10''' || '''€1368.01''' || '''€-443.72''' || '''€924.29'''
 
|}
 
|}
  
Line 504: Line 573:
 
! Total
 
! Total
 
|-
 
|-
| ecotools_purchase || €0.00 || €-7.32 || €-7.32
+
| prop_sales || €100.00 || €0.00 || €100.00
 
|-
 
|-
| rulers_purchase || €0.00 || €-7.59 || €-7.59
+
| web || €0.00 || €-12.04 || €-12.04
 
|-
 
|-
| rent || €0.00 || €-1594.82 || €-1594.82
+
| squares_purchase || €0.00 || €-22.62 || €-22.62
 
|-
 
|-
 
| member || €1223.01 || €0.00 || €1223.01
 
| member || €1223.01 || €0.00 || €1223.01
 
|-
 
|-
| squares_purchase || €0.00 || €-22.62 || €-22.62
+
| fee || €0.00 || €-10.50 || €-10.50
 +
|-
 +
| drinks || €198.65 || €-57.90 || €140.75
 +
|-
 +
| rent || €0.00 || €-1594.82 || €-1594.82
 
|-
 
|-
| prop_sales || €100.00 || €0.00 || €100.00
+
| rulers_purchase || €0.00 || €-7.59 || €-7.59
 
|-
 
|-
| fee || €0.00 || €-10.50 || €-10.50
+
| ecotools_purchase || €0.00 || €-7.32 || €-7.32
 
|-
 
|-
 
| income_3dprinter || €150.00 || €0.00 || €150.00
 
| income_3dprinter || €150.00 || €0.00 || €150.00
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| '''Total 2019-11''' || '''€1671.66''' || '''€-1712.79''' || '''€-41.13'''
|-
 
| '''Total 2019-11''' || '''€1473.01''' || '''€-1654.89''' || '''€-181.88'''
 
 
|}
 
|}
  
Line 532: Line 603:
 
! Total
 
! Total
 
|-
 
|-
| rent || €0.00 || €-1594.82 || €-1594.82
+
| web || €0.00 || €-12.04 || €-12.04
 
|-
 
|-
| member || €2811.08 || €0.00 || €2811.08
+
| member || €1209.96 || €0.00 || €1209.96
 
|-
 
|-
 
| fee || €0.00 || €-10.50 || €-10.50
 
| fee || €0.00 || €-10.50 || €-10.50
 +
|-
 +
| drinks || €120.65 || €-24.00 || €96.65
 +
|-
 +
| service_costs_returned || €1601.12 || €0.00 || €1601.12
 
|-
 
|-
 
| income_3dprinter || €35.00 || €0.00 || €35.00
 
| income_3dprinter || €35.00 || €0.00 || €35.00
 
|-
 
|-
| web || €0.00 || €-12.04 || €-12.04
+
| rent || €0.00 || €-1594.82 || €-1594.82
 
|-
 
|-
| '''Total 2019-12''' || '''€2846.08''' || '''€-1617.36''' || '''€1228.72'''
+
| '''Total 2019-12''' || '''€2966.73''' || '''€-1641.36''' || '''€1325.37'''
 
|}
 
|}

Latest revision as of 15:52, 31 December 2020

THIS IS A PROVISIONAL REPORT AND NOT APPROVED YET BY THE KAS COMMISSIE

Financial Report 2019

This is the financial report of Vereniging Technologia Incognita for 2019.

Balances overview

At the start and end of the year, our bank accounts held the following amounts:

2019 account balances
Account 2019-01-01 2019-12-31 Change
ABN AMRO (membership) €10453.49 €9092.53 €-1360.96
ABN AMRO (savings) €583.04 €583.04 €0.00
Triodos (drinks) €628.61 €664.29 €35.68
Total €11665.14 €10339.86 €-1325.28
Balance for 2019
Activa/assets 2019-01-01 2019-12-31 Passiva/Liabilities 2019-01-01 2019-12-31
Current assets Equity
Owed member contributions €0.00 Expendable assets (Besteedbaar vermogen) €11586.02 €9417.21
Outstanding Triodos deposits €139,00
Ahead of time paid rent €0.00 €0.00
Stock (drinks) €0.00 €0.00
Liquid assets Short term debt
Checking €10453.49 €9092.53 Credits in drinks €0.00 €73.86
Savings €583.04 €583.04 AoT-member-payment €1153.33 €1632.00
Triodos €628.61 €664.29 Fob-deposit €1728.00 €1818.00
Rent Deposit (previously called Collateral) €2802.21 €2802.21 3d-printer-pledge €0.00 €340.00
AOT-Rent €0.00 €0.00
Total €14467.35 €13281.07 Total €14467.35 €13281.07

The loss of €1186.28 can be attributed to us paying more in rent than we received in member income. Some of this could be offset by putting a number on the "Owed member contributions", which is currently set to zero, since it is currently hard to get an accurate representation of how much money the members owed us at the time - the number is easier to calculate for the current day, but harder going back. For the 2020 report, we would have an estimate for a write-off for the past, and the 2021 report would have accurate numbers. If one adds €139.00 to that number, we get the €1325.28, which is the difference between our bank accounts at start and end of the year.

The difference between our equity at the start and end of the year, minus the €1186.28 and €139.00 is €843.52, which is the sum of the difference in the Short term debt section. So because we have a larger AOT member payment, a credit in drinks, more fob deposits and a 3d printer pledge that (at the end of the year) had to be paid, our equity decrease more than just the difference in our bank accounts.

The collateral of €2802.21 is the deposit that the association has paid to our landlord.

The €73.86 in "Credits in drinks" are receipts that had been provided to us but had not yet been paid to the person in question in 2019; this has since been rectified.

The €139.00 in "Outstanding Triodos deposits" is an amount that we expected to have had deposited into our account, but has not actually been deposited. In total 264 euro does not seem to fully match specific deposits, but on the other hand 125 euro has been deposited that also does not match any specific deposit requests. So we are stating 139 euro as "unaccounted" for. It is also possible that this number simply exists because of typo in the emails that were sent (and are the only trace of) counting the money from the safe.

The €1818.00 is based on the people that were a member at the end of the year and had a fob.

The €1632.00 is the amount of money that was paid in advance by members, that is, membership for 2020 that was paid ahead of time. This number is a rough estimate, based on what we expect members to pay.

AOT (ahead-of-time) rent refers to rent payments made by the association in year X for year X+1. We did not do this in 2019, but for consistency with previous reports in years where this was done, we include the entry here.

Misc notes

We discovered 65 euro worth of drinks payment transfered to the association account, rather than the drinks account.

Income

Total income over 2019 was €21606.84, comprised of the following income categories:

2019 income
Category Paid into ABN Paid into Triodos Total
member €16640.98 €0.00 €16640.98
drinks €65.00 €2595.74 €2660.74
service_costs_returned €1601.12 €0.00 €1601.12
income_3dprinter €340.00 €0.00 €340.00
donation €174.00 €0.00 €174.00
prop_sales €100.00 €0.00 €100.00
fob_deposit €90.00 €0.00 €90.00
Total €19011.10 €2595.74 €21606.84

Total expenses over 2019 add up to €-22932.12, comprised of the following expense categories:

2019 expenses
Category Paid from ABN Paid from Triodos Total
rent €-18949.80 €0.00 €-18949.80
drinks €0.00 €-2378.66 €-2378.66
server_disk_purchase €-322.29 €0.00 €-322.29
fee €-126.00 €-181.40 €-307.40
new_fob_purchase €-217.80 €0.00 €-217.80
knoxbox_purchase €-169.00 €0.00 €-169.00
web €-144.48 €0.00 €-144.48
circuit_breaker_purchase €-117.49 €0.00 €-117.49
samla_purchase €-106.47 €0.00 €-106.47
storage_organizers_purchase €-58.94 €0.00 €-58.94
domains €-44.75 €0.00 €-44.75
feeding_volunteers €-41.50 €0.00 €-41.50
fob_return €-36.00 €0.00 €-36.00
squares_purchase €-22.62 €0.00 €-22.62
rulers_purchase €-7.59 €0.00 €-7.59
ecotools_purchase €-7.32 €0.00 €-7.32
tiny_payment_to_reestablish_contact €-0.01 €0.00 €-0.01
Total €-20372.06 €-2560.06 €-22932.12

The difference of our income and our expenses gives the amount we gained or lost for the year. In the case of 2019, we lost €1325.28.

Notes:

  • The board used a €0.01 transaction to seek communication with a member who didn't have a form
  • samla_purchase are IKEA purchases for SAMLA plastic organizers (and some ziploc bags)
  • storage_organizers_purchase is a purchase of plastic boxes for storage and transport of electronic waste (WEEE)
  • fee are our banking costs of ABN-AMRO and Triodos
  • fob_purchase is when members buy fobs from the space
  • new_fob_purchase is when the space buys fobs from our landlord
  • fob_return is when we repay members when they return their fobs
  • service_costs_returned represents a refund from our landlord for the service costs (included in our rent) that were overestimated and that we therefore overpaid
  • squares_purchase was a purchase of try-squares (winkelhaken), a measuring tool for the dirty room
  • knoxbox_purchase was a purchase of a safe
  • ecotools_purchase was a purchase of torx 10 bit and a magnetic bitholder

Data integrity checks

All the following values should be equal:

  • Our reported loss of €1325.28, expressed with the appropriate sign: €-1325.28
  • The sum of the balance changes over all accounts: €-1360.96 + €0.00 + €35.68 == €-1325.28
  • The difference of our income and our expenses: €21606.84 + €-22932.12 == €-1325.28
  • The difference between activa at the end of the year and activa at the beginning of the year, with the "outstanding triodos deposits" subtracted out (as they are "virtual" and not liquid): €13281.07 - €14467.35 - €139.00 == €-1325.28
  • The difference between passiva at the end of the year and passiva at the beginning of the year, with the "outstanding triodos deposits" subtracted out (as they are "virtual" and not liquid): €13281.07 - €14467.35 - €139.00 == €-1325.28

New members

In 2019, 24 new members joined. Before 2020, board tooling did not track the date that former members deactivate their membership, so it's not clear how many people ended their membership in 2019.

Membership pre-payment

Some members pre-pay several months of membership fees at a time. This affects our forecasting, since these payments should not be counted on for monthly income during the period that was pre-paid.

Before 2020, board tooling didn't keep track of expected membership dues per member, so the unit for these numbers is simply "number of months pre-paid" instead of "amount of money pre-paid". However, in the balance we have a good indicator of how much that ends up being.

2019 pre-paid dues
Date Number of months pre-paid as of this date
2018-12-31 104
2019-1-1 106
2019-2-1 115
2019-3-1 105
2019-4-1 111
2019-5-1 95
2019-6-1 120
2019-7-1 115
2019-8-1 116
2019-9-1 99
2019-10-1 92
2019-11-1 78
2019-12-1 83
2019-12-31 75
2020-1-1 77

Rent payment

Rent was paid 12 times in 2019. There was no ahead-of-time rent payment in 2018 nor was there any pre-payment for 2020.

2019 rent payments
Rent month Amount Paid date
2019-01 €-1563.48 2019-01-02
2019-02 €-1563.48 2019-01-27
2019-03 €-1563.48 2019-03-03
2019-04 €-1563.48 2019-03-27
2019-05 €-1563.48 2019-04-22
2019-06 €-1563.48 2019-01-27
2019-07 €-1594.82 2019-07-04
2019-08 €-1594.82 2019-07-31
2019-09 €-1594.82 2019-09-22
2019-10 €-1594.82 2019-09-22
2019-11 €-1594.82 2019-11-15
2019-12 €-1594.82 2019-12-12
Total 2019 €-18949.80

Due to a banking glitch at ABN Amro,, rent was paid twice on 2019-01-02. This was discovered in 2019-05 when the 2019-06 rent was being paid. The treasurer requested for the duplicate payment to be applied to rent for 2019-06, which Urban Resort (our landlord) did. We paid rent twice in September as we forgot to pay rent in August.

Monthly breakdown

2019 income and expenses by month
Month Income Expenses Change
2019-01 €2058.00 €-5189.68 €-3131.68
2019-02 €1402.30 €-610.30 €792.00
2019-03 €2113.50 €-3690.98 €-1577.48
2019-04 €1641.00 €-1756.53 €-115.53
2019-05 €2356.50 €-412.38 €1944.12
2019-06 €1500.79 €-124.93 €1375.86
2019-07 €1712.40 €-3756.21 €-2043.81
2019-08 €1240.00 €-37.54 €1202.46
2019-09 €1575.95 €-3555.70 €-1979.75
2019-10 €1368.01 €-443.72 €924.29
2019-11 €1671.66 €-1712.79 €-41.13
2019-12 €2966.73 €-1641.36 €1325.37
Total 2019 €21606.84 €-22932.12 €-1325.28

Category breakdown by month

2019-01 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
member €1665.00 €0.00 €1665.00
fob_deposit €54.00 €0.00 €54.00
tiny_payment_to_reestablish_contact €0.00 €-0.01 €-0.01
fee €0.00 €-37.63 €-37.63
drinks €335.00 €-449.56 €-114.56
donation €4.00 €0.00 €4.00
rent €0.00 €-4690.44 €-4690.44
Total 2019-01 €2058.00 €-5189.68 €-3131.68
2019-02 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
domains €0.00 €-26.62 €-26.62
fee €0.00 €-30.50 €-30.50
member €1210.00 €0.00 €1210.00
drinks €192.30 €0.00 €192.30
server_disk_purchase €0.00 €-322.29 €-322.29
samla_purchase €0.00 €-49.85 €-49.85
knoxbox_purchase €0.00 €-169.00 €-169.00
Total 2019-02 €1402.30 €-610.30 €792.00
2019-03 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
member €1715.00 €0.00 €1715.00
storage_organizers_purchase €0.00 €-58.94 €-58.94
fee €0.00 €-10.50 €-10.50
feeding_volunteers €0.00 €-41.50 €-41.50
samla_purchase €0.00 €-56.62 €-56.62
drinks €398.50 €-248.93 €149.57
circuit_breaker_purchase €0.00 €-117.49 €-117.49
fob_return €0.00 €-18.00 €-18.00
rent €0.00 €-3126.96 €-3126.96
Total 2019-03 €2113.50 €-3690.98 €-1577.48
2019-04 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
fob_return €0.00 €-18.00 €-18.00
member €1220.00 €0.00 €1220.00
fee €0.00 €-41.76 €-41.76
drinks €401.00 €-121.25 €279.75
donation €20.00 €0.00 €20.00
rent €0.00 €-1563.48 €-1563.48
Total 2019-04 €1641.00 €-1756.53 €-115.53
2019-05 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
drinks €226.50 €-389.84 €-163.34
member €2120.00 €0.00 €2120.00
donation €10.00 €0.00 €10.00
fee €0.00 €-10.50 €-10.50
Total 2019-05 €2356.50 €-412.38 €1944.12
2019-06 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
drinks €102.79 €-102.39 €0.40
member €1380.00 €0.00 €1380.00
fob_deposit €18.00 €0.00 €18.00
fee €0.00 €-10.50 €-10.50
Total 2019-06 €1500.79 €-124.93 €1375.86
2019-07 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
fob_deposit €18.00 €0.00 €18.00
member €1367.00 €0.00 €1367.00
new_fob_purchase €0.00 €-217.80 €-217.80
fee €0.00 €-42.65 €-42.65
drinks €287.40 €-294.08 €-6.68
donation €40.00 €0.00 €40.00
rent €0.00 €-3189.64 €-3189.64
Total 2019-07 €1712.40 €-3756.21 €-2043.81
2019-08 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
drinks €40.00 €-15.00 €25.00
member €1200.00 €0.00 €1200.00
fee €0.00 €-10.50 €-10.50
Total 2019-08 €1240.00 €-37.54 €1202.46
2019-09 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
member €1221.00 €0.00 €1221.00
fee €0.00 €-50.50 €-50.50
domains €0.00 €-18.13 €-18.13
drinks €254.95 €-285.39 €-30.44
donation €100.00 €0.00 €100.00
rent €0.00 €-3189.64 €-3189.64
Total 2019-09 €1575.95 €-3555.70 €-1979.75
2019-10 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
drinks €103.00 €-390.32 €-287.32
member €1110.01 €0.00 €1110.01
income_3dprinter €155.00 €0.00 €155.00
fee €0.00 €-41.36 €-41.36
Total 2019-10 €1368.01 €-443.72 €924.29
2019-11 income and expense categories
Category Income Expenses Total
prop_sales €100.00 €0.00 €100.00
web €0.00 €-12.04 €-12.04
squares_purchase €0.00 €-22.62 €-22.62
member €1223.01 €0.00 €1223.01
fee €0.00 €-10.50 €-10.50
drinks €198.65 €-57.90 €140.75
rent €0.00 €-1594.82 €-1594.82
rulers_purchase €0.00 €-7.59 €-7.59
ecotools_purchase €0.00 €-7.32 €-7.32
income_3dprinter €150.00 €0.00 €150.00
Total 2019-11 €1671.66 €-1712.79 €-41.13
2019-12 income and expense categories
Category Income Expenses Total
web €0.00 €-12.04 €-12.04
member €1209.96 €0.00 €1209.96
fee €0.00 €-10.50 €-10.50
drinks €120.65 €-24.00 €96.65
service_costs_returned €1601.12 €0.00 €1601.12
income_3dprinter €35.00 €0.00 €35.00
rent €0.00 €-1594.82 €-1594.82
Total 2019-12 €2966.73 €-1641.36 €1325.37