View source for ALV December 2020/Financial report 2019 candidate

== 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:

{| class="wikitable"
|+ 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
|}

{| class="wikitable"
|+ 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:

{| class="wikitable"
|+ 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:

{| class="wikitable"
|+ 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.

{| class="wikitable"
|+ 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.

{| class="wikitable"
|+ 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 ==

{| class="wikitable"
|+ 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 ===


{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}

{| class="wikitable"
|+ 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'''
|}