From 15723241f5ed816a36eb31a5f04a50a206fa8cd9 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Mon, 8 Jun 2020 22:34:30 +0200 Subject: [PATCH] Add 2020 financial and activities reports --- .../pages/about/ga/2020/activitiesreport.html | 122 ++++++++++ .../pages/about/ga/2020/financialreport.html | 217 ++++++++++++++++++ 2 files changed, 339 insertions(+) create mode 100644 template/pages/about/ga/2020/activitiesreport.html create mode 100644 template/pages/about/ga/2020/financialreport.html diff --git a/template/pages/about/ga/2020/activitiesreport.html b/template/pages/about/ga/2020/activitiesreport.html new file mode 100644 index 0000000..bbf15b9 --- /dev/null +++ b/template/pages/about/ga/2020/activitiesreport.html @@ -0,0 +1,122 @@ +{%extends "nav_about.html"%} +{%block title%}2020 General Assembly - Activities report{%endblock%} +{%block content%} +

2020 General Assembly - Activities report

+ +

What has been done

+ +

Financial/Administration

+ +

See the Financial report, section "Activities".

+ +

2019 Events

+

+2019 saw a large number of events which were either organized by, or +with the support from PostgreSQL Europe. In total, we had 1200 +registered attendees at this year's events which we are very happy +about. +

+ +

FOSDEM/PGDay

+

+The 7th annual one-track PGDay just before FOSDEM is still a +successful and well established event with 142 attendees. During +FOSDEM, we had lots of interest at our booth. As usual, our devroom +ended up completely full with far from everyone who wanted to attend +being able to get in. +

+ +

Nordic PGDay

+

+The sixth iteration of Nordic PGDay followed the same concept as the +four previous years, a single-day single-track conference. In 2019, it +was held in Copenhagen, Denmark with 130 attendees. +

+ +

pgDay Paris

+

+The fourth iteration of PGDay Paris supported by PostgreSQL Europe +followed the well proven one-day one-track model and attracted 176 +attendees. +

+ +

PGConf.DE

+

+PGConf.DE this year was in Leipzig. The conference had 192 attendees +and got very positive feedback. +

+ +

PGConf.EU

+

+PGConf.EU broke its attendance record once again. The conference, +which was held in Milan, Italy, had 560 attendees. +

+ +

2020 Events

+

+We are in the middle of 2020, and the situation for events around the world is not looking good. +

+ +

+PostgreSQL Europe held the regular FOSDEM PGDay in Brussels, with 124 attendees. +

+ +

+All other events in the spring, Nordic PGDay, pgDay.paris and +PGConf.DE have been canceled due to COVID-19, along with many other +PostgreSQL events around. +

+ +

+We still hope to be able to run PGConf.EU in Berlin in October, but a +firm decision will have to be made much closer to the event. + + +

Upcoming events

+

+As mentioned, PGConf.EU will hopefully be back this autumn in Berlin, Germany. +

+ +

+As always, we invite our members who are interested in working on a +regional PGDay to contact us if we can be of any assistance at all, +whether just in answering questions, or through organisational or +financial aid. More information can be found at +https://www.postgresql.eu/events/. +

+ + +

Miscellaneous

+ +

New board member

+ +

+We welcome Lætitia Avrot as our new board member. Her position is Treasurer. +

+ +

+We'd like to thank Guillaume Lelarge for many years of hard work as PostgreSQL Europe Treasurer. +

+ +

Ongoing work

+ +

New address

+ +

+We are working to change our address for snail mail. We actually end +up getting the mail quite late, and it can be quite inconvenient. So +we're trying to find a French company to get our mail and send it to +us on a timely fashion. We're looking for a French company because we +need an address in France as that is the country in which we are +registered. +

+ +

Tax representatives

+ +

+We still have major issues on foreign taxes. A solution might be to +get tax representatives in foreign countries. We are working on this +to resolve this issue. +

+ +{%endblock%} diff --git a/template/pages/about/ga/2020/financialreport.html b/template/pages/about/ga/2020/financialreport.html new file mode 100644 index 0000000..71a232e --- /dev/null +++ b/template/pages/about/ga/2020/financialreport.html @@ -0,0 +1,217 @@ +{%extends "nav_about.html"%} +{%block title%}2020 General Assembly - Financial report{%endblock%} +{%block content%} +

2020 General Assembly - Financial report

+ +

Assets

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
Accounts2019-01-012019-12-31Difference
Crédit Mutuel checking account127,127.23178,319.7151,192.48
Crédit Mutuel saving account - 162,207.0562,673.60466.55
Crédit Mutuel saving account - 210,041.9110,082.9241.01
Paypal account2,787.152,650.21-136.94
Adyen account1,500.001,500.000.00
Trustly account1,129.25595.17-534.08
Pending creditcard payments-22.75-187,99-165.24
Total204,769.84 258,298.00 32,315.93
+ +

Major items

+ +

Activities

+

+The two saving accounts have not been used during 2019 since all +events have generated satisfactory financial results (exceeding or +hitting budget) thanks to strong sponsor income. As the events grow +larger and the number of events increase, the importance of this +buffer remains. +

+ +

+Our administrative backend software, which powers both our financial reporting +as well as the events, was again further improved ensuring safe operation of +our events. +

+ +

+We are working to get tax representatives in foreign countries (foreign +meaning not-France). +

+ +

Income/Expenses

+ +

+ The important items of 2020 are summarized here. +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ItemsIncomeExpensesFinal results
Membership720.000720.00
Donations1,878.820.001,878.82
Book royalties452.940.00452.94
Conferences330,931.41-256,507.8974,423.52
Merchandise2,620.66-4,713.62-2,092.96
Financial507.56-5,398.02-4,890.46
Insurance0.00-760.91-760.91
Taxes0.00-8,403.00-8,403.00
Total61,327.95
+ + +

+The financial results for our events can be seen broken down per event +in the table below. As most events these days have income and expense +spanning multiple days, we include the numbers from the previous year +as well. Some events in 2020 have had income or expenses during 2019, +but are not included in this table, only events that were actually +held during 2019 is included. +

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
EventIncome 2018Expenses 2018Income 2019Expenses 2019Final results
FOSDEM/PGDay 20191,869.4010,547.513,235.332,030.85-7,523.63
Nordic PGDay 20198,700.00249.249,172.0014,373.903,248.86
PGConf.DE 20197,750.000.0018,780.0017,363.579,166.43
PGDay Paris 201911,245.007,841.3911,030.0212,480.341,953.29
PGConf.EU 20190,0017,756.78269,351.58143,525.87108,068.93
+ +{%endblock%} -- 2.39.5