From cc63416c4b0e035e3b9d13ffbaf20e635fef9dc6 Mon Sep 17 00:00:00 2001
From: =?utf8?q?L=C3=A6titia=20Avrot?= <laetitia.avrot@gmail.com>
Date: Mon, 25 Nov 2024 12:23:41 +0100
Subject: [PATCH] Adding financial report for GA 2024

---
 .../pages/about/ga/2024/financialreport.html  | 236 ++++++++++++++++++
 1 file changed, 236 insertions(+)
 create mode 100644 template/pages/about/ga/2024/financialreport.html

diff --git a/template/pages/about/ga/2024/financialreport.html b/template/pages/about/ga/2024/financialreport.html
new file mode 100644
index 0000000..efb4f58
--- /dev/null
+++ b/template/pages/about/ga/2024/financialreport.html
@@ -0,0 +1,236 @@
+{%extends "nav_about.html"%}
+{%block title%}2024 General Assembly - Financial report{%endblock%}
+{%block content%}
+<h1 id="general-assembly---financial-report">2024 General Assembly - Financial report</h1>
+<h2 id="assets">Assets</h2>
+<table border="1" cellpadding="2"><thead>
+  <tr>
+    <th>Accounts</th>
+    <th>2023-01-01</th>
+    <th>2023-12-31</th>
+    <th>Difference</th>
+  </tr></thead>
+<tbody>
+  <tr>
+    <td>Crédit Mutuel checking account</td>
+    <td>101 212.42</td>
+    <td>387 255.39</td>
+    <td>286 042.97</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 1</td>
+    <td>76 500.00</td>
+    <td>77 389.34</td>
+    <td>889.34</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 2</td>
+    <td>65 131.28</td>
+    <td>65 143.82</td>
+    <td>12.54</td>
+  </tr>
+  <tr>
+    <td>Paypal account</td>
+    <td>5 734.03</td>
+    <td>1 891.07</td>
+    <td>-3 842.96</td>
+  </tr>
+  <tr>
+    <td>Adyen account</td>
+    <td>25 500.00</td>
+    <td>30 500.00</td>
+    <td>5 000.00</td>
+  </tr>
+  <tr>
+    <td>Trustly account</td>
+    <td>2 779.17</td>
+    <td>5 909.14</td>
+    <td>3 129.97</td>
+  </tr>
+  <tr>
+    <td>TransferWise account</td>
+    <td>7 174.45</td>
+    <td>1 471.45</td>
+    <td>-5 703.00</td>
+  </tr>
+  <tr>
+    <td>Pending payments</td>
+    <td>9.00</td>
+    <td>119.00</td>
+    <td>110.00</td>
+  </tr>
+  <tr>
+    <td>Adyen pending income</td>
+    <td>9.28</td>
+    <td>- 0.50</td>
+    <td>- 9.78</td>
+  </tr>
+  <tr>
+    <td>TOTAL</td>
+    <td>284 049.63</td>
+    <td>569 678.71</td>
+    <td>285 629.08</td>
+  </tr>
+</tbody></table>
+<h2 id="major-items">Major items</h2>
+<h3 id="activities">Activities</h3>
+<p>Finances are good. We are on the way to work with the new accountants but are still bound to the old ones for the year 2023. We have to note that there were no legal fees this year. We have a comfortable buffer of money we can use to experiment with small events in different places.</p>
+<h3 id="incomeexpenses">Income/Expenses</h3>
+<p>The important items of 2023 are summarized here.</p>
+<p>Legal fees were less significant this year as it was Postgres Community
+Association of Canada's turn to take most of them and the issue was settled,
+therefore stopping our expenses for that category.</p>
+<p>Conferences were overall very profitable for the year 2023.</p>
+<table border="1" cellpadding="2"><thead>
+  <tr>
+    <th>Accounts</th>
+    <th>2023-01-01</th>
+    <th>2023-12-31</th>
+    <th>Difference</th>
+  </tr></thead>
+<tbody>
+  <tr>
+    <td>Crédit Mutuel checking account</td>
+    <td>101 212.42</td>
+    <td>387 255.39</td>
+    <td>286 042.97</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 1</td>
+    <td>76 500.00</td>
+    <td>77 389.34</td>
+    <td>889.34</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 2</td>
+    <td>65 131.28</td>
+    <td>65 143.82</td>
+    <td>12.54</td>
+  </tr>
+  <tr>
+    <td>Paypal account</td>
+    <td>5 734.03</td>
+    <td>1 891.07</td>
+    <td>-3 842.96</td>
+  </tr>
+  <tr>
+    <td>Adyen account</td>
+    <td>25 500.00</td>
+    <td>30 500.00</td>
+    <td>5 000.00</td>
+  </tr>
+  <tr>
+    <td>Trustly account</td>
+    <td>2 779.17</td>
+    <td>5 909.14</td>
+    <td>3 129.97</td>
+  </tr>
+  <tr>
+    <td>TransferWise account</td>
+    <td>7 174.45</td>
+    <td>1 471.45</td>
+    <td>-5 703.00</td>
+  </tr>
+  <tr>
+    <td>Pending payments</td>
+    <td>9.00</td>
+    <td>119.00</td>
+    <td>110.00</td>
+  </tr>
+  <tr>
+    <td>Adyen pending income</td>
+    <td>9.28</td>
+    <td>- 0.50</td>
+    <td>- 9.78</td>
+  </tr>
+  <tr>
+    <td>TOTAL</td>
+    <td>284 049.63</td>
+    <td>569 678.71</td>
+    <td>285 629.08</td>
+  </tr>
+</tbody></table>
+<p>The financial results for our events from 2023 can be seen broken down per
+event in the table below. Be aware that some of the numbers below include
+invoices or incomes from other years (2022 or 2024).</p>
+<p>PGDay Paris and PGDay/MED lost some money. There were not a lot of attendees
+to these events, certainly less than what we expected. We also got fewer
+sponsorships as expected for PGDay/MED.</p>
+<p>As usual, there was a deficit for FOSDEM PGDay but it should be seen more as
+a contribution to the community as the conference day at FOSDEM is free for
+attendance and without sponsorship.</p>
+<p>The column “Expenses” gathers all expenses we have to put the event in place
+(venue, food, speaker gifts and so on). The column “Other costs” gathers all
+banking costs (credit card fees and paypal fees) for ticket purchases.</p>
+<table border="1" cellpadding="2">
+<thead>
+  <tr>
+    <th>Accounts</th>
+    <th>2023-01-01</th>
+    <th>2023-12-31</th>
+    <th>Difference</th>
+  </tr></thead>
+<tbody>
+  <tr>
+    <td>Crédit Mutuel checking account</td>
+    <td>101 212.42</td>
+    <td>387 255.39</td>
+    <td>286 042.97</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 1</td>
+    <td>76 500.00</td>
+    <td>77 389.34</td>
+    <td>889.34</td>
+  </tr>
+  <tr>
+    <td>Crédit Mutuel saving account - 2</td>
+    <td>65 131.28</td>
+    <td>65 143.82</td>
+    <td>12.54</td>
+  </tr>
+  <tr>
+    <td>Paypal account</td>
+    <td>5 734.03</td>
+    <td>1 891.07</td>
+    <td>-3 842.96</td>
+  </tr>
+  <tr>
+    <td>Adyen account</td>
+    <td>25 500.00</td>
+    <td>30 500.00</td>
+    <td>5 000.00</td>
+  </tr>
+  <tr>
+    <td>Trustly account</td>
+    <td>2 779.17</td>
+    <td>5 909.14</td>
+    <td>3 129.97</td>
+  </tr>
+  <tr>
+    <td>TransferWise account</td>
+    <td>7 174.45</td>
+    <td>1 471.45</td>
+    <td>-5 703.00</td>
+  </tr>
+  <tr>
+    <td>Pending payments</td>
+    <td>9.00</td>
+    <td>119.00</td>
+    <td>110.00</td>
+  </tr>
+  <tr>
+    <td>Adyen pending income</td>
+    <td>9.28</td>
+    <td>- 0.50</td>
+    <td>- 9.78</td>
+  </tr>
+  <tr>
+    <td>TOTAL</td>
+    <td>284 049.63</td>
+    <td>569 678.71</td>
+    <td>285 629.08</td>
+  </tr>
+</tbody>
+</table>
+{%endblock%}
-- 
2.39.5