Difference between revisions of "ALV December 2020/Financial report 2019 candidate"
(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...") |
(No difference)
|
Revision as of 15:51, 8 December 2020
Contents
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-12-31 | 2019-01-01 | Change |
|---|---|---|---|
| ABN AMRO (membership) | €9092.53 | €10453.49 | €-1360.96 |
| ABN AMRO (savings) | €583.04 | €583.04 | €0.00 |
| Triodos (drinks) | €664.29 | €628.61 | €35.68 |
| Total | €11665.14 | €10339.86 | €-1325.28 |
| Activa/assets | 2019-12-31 | 2019-01-01 | Passiva/Liabilities | 2019-12-31 | 2019-01-01 |
|---|---|---|---|---|---|
| Checking | €9092.53 | €10453.49 | Equity | €9262.07 |
€11586.02 |
| Savings | €583.04 | €583.04 | AoT-member-payment |
€1632.00 || €1153.33 | |
| Triodos | €664.29 | €628.61 | Fob-deposit | €1908.00 | €1728.00 |
| Collateral | €2802.21 | €2802.21 | 3d-printer-pledge |
€340.00 || €0.00 | |
| AOT-Rent | €0.00 | €0.00 | |||
| Total | €13142.07 | €14467.35 | Total |
€13142.07 || €14467.35 |
Notes:
- AOT (ahead-of-time) member payments refer to dues pre-paid for future
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
Total income over 2019 was €19046.78, comprised of the following income categories:
| Category | Amount |
|---|---|
| member | €18451.10 |
| income_3dprinter | €340.00 |
| donation | €120.00 |
| prop_sales | €100.00 |
| Total | €19046.78 |
Total expenses over 2019 add up to €-20372.06, comprised of the following expense categories:
| Category | Total |
|---|---|
| rent | €-18949.80 |
| server_disk_purchase | €-322.29 |
| new_fob_purchase | €-217.80 |
| knoxbox_purchase | €-169.00 |
| web | €-144.48 |
| fee | €-126.00 |
| circuit_breaker_purchase | €-117.49 |
| ikea_purchase | €-106.47 |
| storage_organizers_purchase | €-58.94 |
| domains | €-44.75 |
| feeding_volunteers | €-41.50 |
| fob_return | €-36.00 |
| squares_purchase | €-22.62 |
| rulers_purchase | €-7.59 |
| ecotools_purchase | €-7.32 |
| tiny_payment_to_reestablish_contact | €-0.01 |
| Total | €-20372.06 |
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:
- We used a 0.01 cent transaction to seek communication with a member
who we didn't had a form for.
- Ikea purchases are the samla storage boxes.
- Fee are our banking costs of both ABN Amro and Triodos
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: €19046.78 + €-20372.06
== €-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 | €1723.00 | €-4712.99 | €-2989.99 |
| 2019-02 | €1210.00 | €-590.30 | €619.70 |
| 2019-03 | €1780.00 | €-3442.05 | €-1662.05 |
| 2019-04 | €1240.00 | €-1604.02 | €-364.02 |
| 2019-05 | €2130.00 | €-22.54 | €2107.46 |
| 2019-06 | €1398.00 | €-22.54 | €1375.46 |
| 2019-07 | €1425.00 | €-3429.98 | €-2004.98 |
| 2019-08 | €1200.00 | €-22.54 | €1177.46 |
| 2019-09 | €1321.00 | €-3230.31 | €-1909.31 |
| 2019-10 | €1265.01 | €-22.54 | €1242.47 |
| 2019-11 | €1473.01 | €-1654.89 | €-181.88 |
| 2019-12 | €2846.08 | €-1617.36 | €1228.72 |
| Total 2019 | €19046.78 | €-20372.06 | €-1325.28 |
Category breakdown by month
| Category | Income | Expenses | Total |
|---|---|---|---|
| rent | €0.00 | €-4690.44 | €-4690.44 |
| member | €1723.00 | €0.00 | €1723.00 |
| tiny_payment_to_reestablish_contact | €0.00 | €-0.01 | €-0.01 |
| fee | €0.00 | €-10.50 | €-10.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-01 | €1723.00 | €-4712.99 |
€-2989.99 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| ikea_purchase | €0.00 | €-49.85 | €-49.85 |
| member | €1210.00 | €0.00 | €1210.00 |
| server_disk_purchase | €0.00 | €-322.29 | €-322.29 |
| knoxbox_purchase | €0.00 | €-169.00 | €-169.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| domains | €0.00 | €-26.62 | €-26.62 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-02 | €1210.00 | €-590.30 | €619.70 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| ikea_purchase | €0.00 | €-56.62 | €-56.62 |
| rent | €0.00 | €-3126.96 | €-3126.96 |
| member | €1780.00 | €0.00 | €1780.00 |
| fob_return | €0.00 | €-18.00 | €-18.00 |
| storage_organizers_purchase | €0.00 | €-58.94 | €-58.94 |
| circuit_breaker_purchase | €0.00 | €-117.49 | €-117.49 |
| fee | €0.00 | €-10.50 | €-10.50 |
| feeding_volunteers | €0.00 | €-41.50 | €-41.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-03 | €1780.00 | €-3442.05 |
€-1662.05 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| rent | €0.00 | €-1563.48 | €-1563.48 |
| member | €1220.00 | €0.00 | €1220.00 |
| fob_return | €0.00 | €-18.00 | €-18.00 |
| donation | €20.00 | €0.00 | €20.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-04 | €1240.00 | €-1604.02 | €-364.02 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| member | €2130.00 | €0.00 | €2130.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-05 | €2130.00 | €-22.54 | €2107.46 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| member | €1398.00 | €0.00 | €1398.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-06 | €1398.00 | €-22.54 | €1375.46 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| web | €0.00 | €-12.04 | €-12.04 |
| rent | €0.00 | €-3189.64 | €-3189.64 |
| member | €1425.00 | €0.00 | €1425.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| new_fob_purchase | €0.00 | €-217.80 | €-217.80 |
| Total 2019-07 | €1425.00 | €-3429.98 |
€-2004.98 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| member | €1200.00 | €0.00 | €1200.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-08 | €1200.00 | €-22.54 | €1177.46 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| rent | €0.00 | €-3189.64 | €-3189.64 |
| member | €1221.00 | €0.00 | €1221.00 |
| donation | €100.00 | €0.00 | €100.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| domains | €0.00 | €-18.13 | €-18.13 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-09 | €1321.00 | €-3230.31 |
€-1909.31 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| member | €1110.01 | €0.00 | €1110.01 |
| fee | €0.00 | €-10.50 | €-10.50 |
| income_3dprinter | €155.00 | €0.00 | €155.00 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-10 | €1265.01 | €-22.54 | €1242.47 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| ecotools_purchase | €0.00 | €-7.32 | €-7.32 |
| rulers_purchase | €0.00 | €-7.59 | €-7.59 |
| rent | €0.00 | €-1594.82 | €-1594.82 |
| member | €1223.01 | €0.00 | €1223.01 |
| squares_purchase | €0.00 | €-22.62 | €-22.62 |
| prop_sales | €100.00 | €0.00 | €100.00 |
| fee | €0.00 | €-10.50 | €-10.50 |
| income_3dprinter | €150.00 | €0.00 | €150.00 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-11 | €1473.01 | €-1654.89 | €-181.88 |
| Category | Income | Expenses | Total |
|---|---|---|---|
| rent | €0.00 | €-1594.82 | €-1594.82 |
| member | €2811.08 | €0.00 | €2811.08 |
| fee | €0.00 | €-10.50 | €-10.50 |
| income_3dprinter | €35.00 | €0.00 | €35.00 |
| web | €0.00 | €-12.04 | €-12.04 |
| Total 2019-12 | €2846.08 | €-1617.36 | €1228.72 |
