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