[DRAFT] Treasurer's report for 2021-12

Lists: spi-general
From: Martin Michlmayr <tbm(at)cyrius(dot)com>
To: spi-general(at)lists(dot)spi-inc(dot)org
Subject: [DRAFT] Treasurer's report for 2021-12
Date: 2022-02-28 10:45:04
Message-ID: YhynsNehApTKCQ3o@jirafa.cyrius.com
Views: Raw Message | Whole Thread | Download mbox
Lists: spi-general

This is a *draft* treasurer's report for 2021-12.

= Monthly report 2021-12-01 - 2022-01-01 =

== Overall SPI 2021-12-01 - 2022-01-01 ==

debit credit total
--------------------------------------------
403774.39 USD 383874.40 USD 19899.99 USD Assets
0 37339.04 USD -37339.04 USD Accumulated-Depreciation
1.92 USD 0 1.92 USD Ameriprise Cash Mgmt Acct
0 1739.19 USD -1739.19 USD Bank of America Business Advantage Checking
0.09 USD 0 0.09 USD Chase Business Select High Yield Savings
14529.37 USD 239.92 USD 14289.45 USD Chase Performance Business Checking
4812.46 USD 25000.00 USD -20187.54 USD Fifth Third Business Elite Checking (Debian)
6311.62 USD 80689.11 USD -74377.49 USD Fifth Third Business Elite Checking (SPI)
112631.77 USD 34068.24 USD 78563.53 USD Fifth Third Business Elite Checking Wiretransfer
0.25 USD 0 0.25 USD Fifth Third Business Money Market 128
15.14 USD 0 15.14 USD Key Business Gold Money Market Savings
43347.29 USD 853.72 USD 42493.57 USD Key Business Reward Checking
7877.45 USD 150.00 USD 7727.45 USD Merrill Lynch EMA
12519.13 USD 5414.61 USD 7104.52 USD PaypalDebian
24150.83 USD 7064.96 USD 17085.87 USD PaypalSPI
60763.88 USD 74502.42 USD -13738.54 USD Receivable
116813.19 USD 116813.19 USD 0 Transfers
71184.10 USD 53.04 USD 71131.06 USD Expenses
1980.00 USD 0 1980.00 USD Accounting
2393.98 USD 0.67 USD 2393.31 USD Bank-Fees
3938.12 USD 0 3938.12 USD Conferences
1500.00 USD 0 1500.00 USD Services
2438.12 USD 0 2438.12 USD Venue
37339.04 USD 0 37339.04 USD Depreciation
12679.53 USD 52.37 USD 12627.16 USD IT
34.98 USD 0 34.98 USD Domains
856.96 USD 0 856.96 USD Hardware
4587.59 USD 52.37 USD 4535.22 USD Hosting
7200.00 USD 0 7200.00 USD Services
6500.00 USD 0 6500.00 USD Legal
130.44 USD 0 130.44 USD Office:Postal
6222.99 USD 0 6222.99 USD Software-Development
4258.61 USD 100695.70 USD -96437.09 USD Income
0 1.81 USD -1.81 USD Capital-Gain
3943.55 USD 92085.79 USD -88142.24 USD Donations
0 16.64 USD -16.64 USD Interest
0 400.00 USD -400.00 USD Sponsorship
315.06 USD 8191.46 USD -7876.40 USD Unrealized-Gain
34048.24 USD 28642.20 USD 5406.04 USD Liabilities:Payable
--------------------------------------------
513265.34 USD 513265.34 USD 0

== Per project summaries 2021-12-01 - 2022-01-01 ==

Per project donations have a debit amount specified, which is the SPI
5% contribution from the project towards the SPI general fund. Thus
total donation amount is net of this contribution.

Unlike ledger defaults, totals in the per-project summaries are
inverted. Meaning that expenses are negative and equity is
positive. This way projects that have funds, i.e. are in credit, are
shown as a positive amount.

=== 0ad ===

debit credit total
--------------------------------------------
72.82 USD 0 -72.82 USD Expenses
17.74 USD 0 -17.74 USD Bank-Fees
55.08 USD 0 -55.08 USD IT:Hosting
11.66 USD 233.20 USD 221.54 USD Income:Donations
--------------------------------------------
84.48 USD 233.20 USD 148.72 USD

=== archlinux ===

debit credit total
--------------------------------------------
1366.33 USD 0 -1366.33 USD Expenses
267.38 USD 0 -267.38 USD Bank-Fees
1098.95 USD 0 -1098.95 USD IT
657.24 USD 0 -657.24 USD Hardware
441.71 USD 0 -441.71 USD Hosting
317.03 USD 6340.15 USD 6023.12 USD Income:Donations
--------------------------------------------
1683.36 USD 6340.15 USD 4656.79 USD

=== ardupilot ===

debit credit total
--------------------------------------------
3999.48 USD 0 -3999.48 USD Expenses
65.18 USD 0 -65.18 USD Bank-Fees
534.30 USD 0 -534.30 USD IT:Hosting
3400.00 USD 0 -3400.00 USD Software-Development
204.00 USD 4080.00 USD 3876.00 USD Income
204.00 USD 3680.00 USD 3476.00 USD Donations
0 400.00 USD 400.00 USD Sponsorship
--------------------------------------------
4203.48 USD 4080.00 USD -123.48 USD

=== chakra ===

debit credit total
--------------------------------------------
0.56 USD 52.37 USD 51.81 USD Expenses:IT:Hosting

=== debconf21 ===

debit credit total
--------------------------------------------
7.16 USD 0 -7.16 USD Expenses:Bank-Fees
8.90 USD 178.00 USD 169.10 USD Income:Donations
--------------------------------------------
16.06 USD 178.00 USD 161.94 USD

=== debconf22 ===

debit credit total
--------------------------------------------
15.00 USD 0 -15.00 USD Expenses:Bank-Fees

=== debian ===

debit credit total
--------------------------------------------
821.82 USD 0.67 USD -821.15 USD Expenses:Bank-Fees
1507.19 USD 30118.83 USD 28611.64 USD Income
1192.13 USD 23817.71 USD 22625.58 USD Donations
315.06 USD 6301.12 USD 5986.06 USD Unrealized-Gain
--------------------------------------------
2329.01 USD 30119.50 USD 27790.49 USD

=== ffmpeg ===

debit credit total
--------------------------------------------
231.03 USD 0 -231.03 USD Expenses:Bank-Fees
568.94 USD 11378.94 USD 10810.00 USD Income:Donations
--------------------------------------------
799.97 USD 11378.94 USD 10578.97 USD

=== haskell ===

debit credit total
--------------------------------------------
38.50 USD 0 -38.50 USD Expenses:Bank-Fees
50.90 USD 1018.00 USD 967.10 USD Income:Donations
--------------------------------------------
89.40 USD 1018.00 USD 928.60 USD

=== libreoffice ===

debit credit total
--------------------------------------------
82.51 USD 0 -82.51 USD Expenses:Bank-Fees
183.67 USD 3673.47 USD 3489.80 USD Income:Donations
--------------------------------------------
266.18 USD 3673.47 USD 3407.29 USD

=== ntpsec ===

debit credit total
--------------------------------------------
0.52 USD 0 -0.52 USD Expenses:Bank-Fees
11.05 USD 221.00 USD 209.95 USD Income:Donations
--------------------------------------------
11.57 USD 221.00 USD 209.43 USD

=== openbioinformatics ===

debit credit total
--------------------------------------------
2712.74 USD 0 -2712.74 USD Expenses
2438.12 USD 0 -2438.12 USD Conferences:Venue
274.62 USD 0 -274.62 USD IT
34.98 USD 0 -34.98 USD Domains
199.72 USD 0 -199.72 USD Hardware
39.92 USD 0 -39.92 USD Hosting
--------------------------------------------
2712.74 USD 0 -2712.74 USD

=== openembedded ===

debit credit total
--------------------------------------------
14.06 USD 0 -14.06 USD Expenses:Bank-Fees
131.00 USD 2620.00 USD 2489.00 USD Income:Donations
--------------------------------------------
145.06 USD 2620.00 USD 2474.94 USD

=== openvoting ===

debit credit total
--------------------------------------------
2.00 USD 40.00 USD 38.00 USD Income:Donations

=== openwrt ===

debit credit total
--------------------------------------------
1.90 USD 0 -1.90 USD Expenses:Bank-Fees
1.05 USD 21.00 USD 19.95 USD Income:Donations
--------------------------------------------
2.95 USD 21.00 USD 18.05 USD

=== openzfs ===

debit credit total
--------------------------------------------
1795.71 USD 0 -1795.71 USD Expenses
50.55 USD 0 -50.55 USD Bank-Fees
1500.00 USD 0 -1500.00 USD Conferences:Services
112.66 USD 0 -112.66 USD IT:Hosting
132.50 USD 0 -132.50 USD Software-Development
89.00 USD 1780.00 USD 1691.00 USD Income:Donations
--------------------------------------------
1884.71 USD 1780.00 USD -104.71 USD

=== postgresql ===

debit credit total
--------------------------------------------
2795.65 USD 0 -2795.65 USD Expenses
305.16 USD 0 -305.16 USD Bank-Fees
2490.49 USD 0 -2490.49 USD Software-Development
1088.49 USD 21769.87 USD 20681.38 USD Income:Donations
--------------------------------------------
3884.14 USD 21769.87 USD 17885.73 USD

=== privoxy ===

debit credit total
--------------------------------------------
2001.87 USD 0 -2001.87 USD Expenses
10.96 USD 0 -10.96 USD Bank-Fees
1990.91 USD 0 -1990.91 USD IT:Hosting
45.00 USD 900.00 USD 855.00 USD Income:Donations
--------------------------------------------
2046.87 USD 900.00 USD -1146.87 USD

=== spi ===

debit credit total
--------------------------------------------
53774.15 USD 0 -53774.15 USD Expenses
1980.00 USD 0 -1980.00 USD Accounting
448.59 USD 0 -448.59 USD Bank-Fees
37339.04 USD 0 -37339.04 USD Depreciation
7376.08 USD 0 -7376.08 USD IT
176.08 USD 0 -176.08 USD Hosting
7200.00 USD 0 -7200.00 USD Services
6500.00 USD 0 -6500.00 USD Legal
130.44 USD 0 -130.44 USD Office:Postal
0.08 USD 15550.24 USD 15550.16 USD Income
0 1.81 USD 1.81 USD Capital-Gain
0.08 USD 13641.45 USD 13641.37 USD Donations
0 16.64 USD 16.64 USD Interest
0 1890.34 USD 1890.34 USD Unrealized-Gain
--------------------------------------------
53774.23 USD 15550.24 USD -38223.99 USD

=== systemd ===

debit credit total
--------------------------------------------
1.29 USD 0 -1.29 USD Expenses:Bank-Fees
1.05 USD 21.00 USD 19.95 USD Income:Donations
--------------------------------------------
2.34 USD 21.00 USD 18.66 USD

=== texmacs ===

debit credit total
--------------------------------------------
2.06 USD 0 -2.06 USD Expenses:Bank-Fees
2.00 USD 40.00 USD 38.00 USD Income:Donations
--------------------------------------------
4.06 USD 40.00 USD 35.94 USD

=== translatewiki.net ===

debit credit total
--------------------------------------------
1.64 USD 0 -1.64 USD Expenses:Bank-Fees
1.50 USD 30.00 USD 28.50 USD Income:Donations
--------------------------------------------
3.14 USD 30.00 USD 26.86 USD

=== tux4kids ===

debit credit total
--------------------------------------------
12.50 USD 250.00 USD 237.50 USD Income:Donations

=== xorg ===

debit credit total
--------------------------------------------
1447.30 USD 0 -1447.30 USD Expenses
10.93 USD 0 -10.93 USD Bank-Fees
1236.37 USD 0 -1236.37 USD IT:Hosting
200.00 USD 0 -200.00 USD Software-Development
21.60 USD 432.00 USD 410.40 USD Income:Donations
--------------------------------------------
1468.90 USD 432.00 USD -1036.90 USD

= 2021 year to date report, ending 2022-01-01 =

== Overall SPI 2021 year to date, ending 2022-01-01 ==

debit credit total
--------------------------------------------
4737474.28 USD 1640265.58 USD 3097208.70 USD Assets
0 80645.99 USD -80645.99 USD Accumulated-Depreciation
13916.15 USD 0 13916.15 USD Ameriprise Cash Mgmt Acct
126589.58 USD 97244.07 USD 29345.51 USD Bank of America Business Advantage Checking
5345.72 USD 0 5345.72 USD Chase Business Select High Yield Savings
236056.42 USD 1570.12 USD 234486.30 USD Chase Performance Business Checking
69293.38 USD 67572.45 USD 1720.93 USD Fifth Third Business Elite Checking (Debian)
155044.83 USD 154044.83 USD 1000.00 USD Fifth Third Business Elite Checking (SPI)
397060.25 USD 288336.01 USD 108724.24 USD Fifth Third Business Elite Checking Wiretransfer
29959.79 USD 47.00 USD 29912.79 USD Fifth Third Business Money Market 128
207045.53 USD 0 207045.53 USD Fixed-Assets
1781749.12 USD 0 1781749.12 USD Key Business Gold Money Market Savings
393450.76 USD 14940.89 USD 378509.87 USD Key Business Reward Checking
1000.00 USD 0 1000.00 USD KeyBank Basic Business Checking
317143.20 USD 12297.52 USD 304845.68 USD Merrill Lynch EMA
51202.14 USD 39633.96 USD 11568.18 USD PaypalDebian
120697.78 USD 100239.52 USD 20458.26 USD PaypalSPI
100.00 USD 72.20 USD 27.80 USD Prepaid-Expenses
478672.07 USD 430473.46 USD 48198.61 USD Receivable
353147.56 USD 353147.56 USD 0 Transfers
0 2963646.02 USD -2963646.02 USD Equity:Net-Assets
0 2413897.65 USD -2413897.65 USD Restricted
0 549748.37 USD -549748.37 USD Unrestricted
473766.89 USD 66526.29 USD 407240.60 USD Expenses
33260.98 USD 0 33260.98 USD Accounting
12093.45 USD 38.62 USD 12054.83 USD Bank-Fees
20966.03 USD 0 20966.03 USD Conferences
181.53 USD 0 181.53 USD Dining
4192.12 USD 0 4192.12 USD Materials
554.26 USD 0 554.26 USD Registration
13600.00 USD 0 13600.00 USD Services
2438.12 USD 0 2438.12 USD Venue
576.28 USD 0 576.28 USD Currency-Exchange
37339.04 USD 0 37339.04 USD Depreciation
64450.68 USD 64450.68 USD 0 Disassociation
125586.61 USD 1551.09 USD 124035.52 USD IT
882.06 USD 0 882.06 USD Domains
23764.76 USD 0 23764.76 USD Hardware
52169.66 USD 52.37 USD 52117.29 USD Hosting
48770.13 USD 1498.72 USD 47271.41 USD Services
2670.00 USD 0 2670.00 USD Insurance
28700.00 USD 0 28700.00 USD Internships
44032.89 USD 0 44032.89 USD Legal
1088.00 USD 0 1088.00 USD Marketing
1461.76 USD 0 1461.76 USD Office:Postal
810.00 USD 0 810.00 USD Project-Management
87676.33 USD 0 87676.33 USD Software-Development
421.42 USD 0 421.42 USD Training
12633.42 USD 485.90 USD 12147.52 USD Unrealized-Loss
25166.51 USD 561663.80 USD -536497.29 USD Income
0 1.81 USD -1.81 USD Capital-Gain
0 977.99 USD -977.99 USD Currency-Exchange
22957.68 USD 498457.67 USD -475499.99 USD Donations
66.28 USD 2050.45 USD -1984.17 USD Interest
0 4600.00 USD -4600.00 USD Sponsorship
2142.55 USD 55575.88 USD -53433.33 USD Unrealized-Gain
530125.61 USD 534431.60 USD -4305.99 USD Liabilities:Payable
--------------------------------------------
5766533.29 USD 5766533.29 USD 0

== Per project summaries 2021 year to date, ending 2022-01-01 ==

=== 0ad ===

debit credit total
--------------------------------------------
0 37798.42 USD 37798.42 USD Equity:Net-Assets:Restricted
1061.96 USD 0 -1061.96 USD Expenses
315.93 USD 0 -315.93 USD Bank-Fees
0.63 USD 0 -0.63 USD Currency-Exchange
745.40 USD 0 -745.40 USD IT:Hosting
276.68 USD 5533.17 USD 5256.49 USD Income:Donations
--------------------------------------------
1338.64 USD 43331.59 USD 41992.95 USD

=== adelielinux ===

debit credit total
--------------------------------------------
1.93 USD 0 -1.93 USD Expenses:Bank-Fees
1.79 USD 35.87 USD 34.08 USD Income:Donations
--------------------------------------------
3.72 USD 35.87 USD 32.15 USD

=== ankur ===

debit credit total
--------------------------------------------
0 2819.84 USD 2819.84 USD Equity:Net-Assets:Restricted

=== aptosid ===

debit credit total
--------------------------------------------
0 503.76 USD 503.76 USD Equity:Net-Assets:Restricted

=== archlinux ===

debit credit total
--------------------------------------------
0 367130.88 USD 367130.88 USD Equity:Net-Assets:Restricted
14233.27 USD 0 -14233.27 USD Expenses
1669.58 USD 0 -1669.58 USD Bank-Fees
10092.28 USD 0 -10092.28 USD IT
657.24 USD 0 -657.24 USD Hardware
9435.04 USD 0 -9435.04 USD Hosting
2471.41 USD 0 -2471.41 USD Legal
2067.31 USD 41353.80 USD 39286.49 USD Income
0 10.44 USD 10.44 USD Currency-Exchange
2067.31 USD 41343.36 USD 39276.05 USD Donations
--------------------------------------------
16300.58 USD 408484.68 USD 392184.10 USD

=== archlinux32 ===

debit credit total
--------------------------------------------
0 17.96 USD 17.96 USD Equity:Net-Assets:Restricted

=== ardupilot ===

debit credit total
--------------------------------------------
0 117877.13 USD 117877.13 USD Equity:Net-Assets:Restricted
52430.28 USD 0 -52430.28 USD Expenses
1573.17 USD 0 -1573.17 USD Bank-Fees
212.80 USD 0 -212.80 USD Currency-Exchange
11094.31 USD 0 -11094.31 USD IT
4199.38 USD 0 -4199.38 USD Hardware
6894.93 USD 0 -6894.93 USD Hosting
39550.00 USD 0 -39550.00 USD Software-Development
2434.75 USD 48955.98 USD 46521.23 USD Income
0 260.98 USD 260.98 USD Currency-Exchange
2434.75 USD 44095.00 USD 41660.25 USD Donations
0 4600.00 USD 4600.00 USD Sponsorship
--------------------------------------------
54865.03 USD 166833.11 USD 111968.08 USD

=== chakra ===

debit credit total
--------------------------------------------
0 169.41 USD 169.41 USD Equity:Net-Assets:Restricted
326.28 USD 52.37 USD -273.91 USD Expenses
7.31 USD 0 -7.31 USD Bank-Fees
1.48 USD 0 -1.48 USD Currency-Exchange
317.49 USD 52.37 USD -265.12 USD IT:Hosting
5.50 USD 110.00 USD 104.50 USD Income:Donations
--------------------------------------------
331.78 USD 331.78 USD 0

=== debconf20 ===

debit credit total
--------------------------------------------
0 1634.54 USD 1634.54 USD Equity:Net-Assets:Restricted

=== debconf21 ===

debit credit total
--------------------------------------------
0 24727.26 USD 24727.26 USD Equity:Net-Assets:Restricted
27562.50 USD 0 -27562.50 USD Expenses
53.80 USD 0 -53.80 USD Bank-Fees
3749.82 USD 0 -3749.82 USD Conferences:Materials
8.88 USD 0 -8.88 USD Currency-Exchange
23750.00 USD 0 -23750.00 USD Disassociation
586.90 USD 11743.14 USD 11156.24 USD Income
0 5.14 USD 5.14 USD Currency-Exchange
586.90 USD 11738.00 USD 11151.10 USD Donations
--------------------------------------------
28149.40 USD 36470.40 USD 8321.00 USD

=== debconf22 ===

debit credit total
--------------------------------------------
15.00 USD 19000.00 USD 18985.00 USD Expenses
15.00 USD 0 -15.00 USD Bank-Fees
0 19000.00 USD 19000.00 USD Disassociation
300.00 USD 6000.00 USD 5700.00 USD Income:Donations
--------------------------------------------
315.00 USD 25000.00 USD 24685.00 USD

=== debconf23 ===

debit credit total
--------------------------------------------
0 4750.00 USD 4750.00 USD Expenses:Disassociation

=== debian ===

debit credit total
--------------------------------------------
0 807407.74 USD 807407.74 USD Equity:Net-Assets:Restricted
123592.05 USD 510.14 USD -123081.91 USD Expenses
3256.09 USD 24.24 USD -3231.85 USD Bank-Fees
623.83 USD 0 -623.83 USD Conferences
181.53 USD 0 -181.53 USD Dining
442.30 USD 0 -442.30 USD Materials
66.93 USD 0 -66.93 USD Currency-Exchange
40700.68 USD 0 -40700.68 USD Disassociation
13827.47 USD 0 -13827.47 USD IT
140.00 USD 0 -140.00 USD Domains
9875.67 USD 0 -9875.67 USD Hardware
3811.80 USD 0 -3811.80 USD Hosting
26000.00 USD 0 -26000.00 USD Internships
29399.03 USD 0 -29399.03 USD Legal
9718.02 USD 485.90 USD -9232.12 USD Unrealized-Loss
6134.77 USD 110115.59 USD 103980.82 USD Income
0 142.84 USD 142.84 USD Currency-Exchange
3925.94 USD 65796.11 USD 61870.17 USD Donations
66.28 USD 1325.77 USD 1259.49 USD Interest
2142.55 USD 42850.87 USD 40708.32 USD Unrealized-Gain
--------------------------------------------
129726.82 USD 918033.47 USD 788306.65 USD

=== ffmpeg ===

debit credit total
--------------------------------------------
0 130587.17 USD 130587.17 USD Equity:Net-Assets:Restricted
12271.85 USD 0 -12271.85 USD Expenses
696.50 USD 0 -696.50 USD Bank-Fees
72.59 USD 0 -72.59 USD Currency-Exchange
8802.76 USD 0 -8802.76 USD IT:Hardware
2700.00 USD 0 -2700.00 USD Internships
1113.33 USD 22377.16 USD 21263.83 USD Income
0 191.42 USD 191.42 USD Currency-Exchange
1113.33 USD 22185.74 USD 21072.41 USD Donations
--------------------------------------------
13385.18 USD 152964.33 USD 139579.15 USD

=== fluxbox ===

debit credit total
--------------------------------------------
0 1046.33 USD 1046.33 USD Equity:Net-Assets:Restricted

=== gallery ===

debit credit total
--------------------------------------------
5.00 USD 100.00 USD 95.00 USD Income:Donations

=== ganeti ===

debit credit total
--------------------------------------------
0 131.46 USD 131.46 USD Equity:Net-Assets:Restricted
2.74 USD 54.89 USD 52.15 USD Income:Donations
--------------------------------------------
2.74 USD 186.35 USD 183.61 USD

=== glucosio ===

debit credit total
--------------------------------------------
0 39.84 USD 39.84 USD Equity:Net-Assets:Restricted

=== gnustep ===

debit credit total
--------------------------------------------
0 180.50 USD 180.50 USD Equity:Net-Assets:Restricted

=== haskell ===

debit credit total
--------------------------------------------
0 16611.73 USD 16611.73 USD Equity:Net-Assets:Restricted
38.91 USD 0 -38.91 USD Expenses:Bank-Fees
51.40 USD 1028.00 USD 976.60 USD Income:Donations
--------------------------------------------
90.31 USD 17639.73 USD 17549.42 USD

=== jenkins ===

debit credit total
--------------------------------------------
0 9380.96 USD 9380.96 USD Equity:Net-Assets:Restricted

=== libreoffice ===

debit credit total
--------------------------------------------
0 75934.10 USD 75934.10 USD Equity:Net-Assets:Restricted
191.97 USD 0 -191.97 USD Expenses:Bank-Fees
1998.95 USD 39977.53 USD 37978.58 USD Income:Donations
--------------------------------------------
2190.92 USD 115911.63 USD 113720.71 USD

=== mingw ===

debit credit total
--------------------------------------------
0 4709.42 USD 4709.42 USD Equity:Net-Assets:Restricted
4.16 USD 0 -4.16 USD Expenses:Bank-Fees
5.20 USD 104.00 USD 98.80 USD Income:Donations
--------------------------------------------
9.36 USD 4813.42 USD 4804.06 USD

=== ns-3 ===

debit credit total
--------------------------------------------
60.00 USD 1200.00 USD 1140.00 USD Income:Donations

=== ntpsec ===

debit credit total
--------------------------------------------
0 134219.78 USD 134219.78 USD Equity:Net-Assets:Restricted
6.20 USD 0 -6.20 USD Expenses:Bank-Fees
15.45 USD 309.00 USD 293.55 USD Income:Donations
--------------------------------------------
21.65 USD 134528.78 USD 134507.13 USD

=== oftc ===

debit credit total
--------------------------------------------
0 38.00 USD 38.00 USD Equity:Net-Assets:Restricted

=== openbioinformatics ===

debit credit total
--------------------------------------------
0 112353.06 USD 112353.06 USD Equity:Net-Assets:Restricted
5352.65 USD 0 -5352.65 USD Expenses
184.23 USD 0 -184.23 USD Bank-Fees
2992.38 USD 0 -2992.38 USD Conferences
554.26 USD 0 -554.26 USD Registration
2438.12 USD 0 -2438.12 USD Venue
1458.61 USD 0 -1458.61 USD IT
121.93 USD 0 -121.93 USD Domains
229.71 USD 0 -229.71 USD Hardware
1106.97 USD 0 -1106.97 USD Hosting
717.43 USD 0 -717.43 USD Software-Development
990.25 USD 19815.54 USD 18825.29 USD Income
0 10.54 USD 10.54 USD Currency-Exchange
990.25 USD 19805.00 USD 18814.75 USD Donations
--------------------------------------------
6342.90 USD 132168.60 USD 125825.70 USD

=== openembedded ===

debit credit total
--------------------------------------------
0 13555.31 USD 13555.31 USD Equity:Net-Assets:Restricted
217.06 USD 0 -217.06 USD Expenses:Bank-Fees
395.25 USD 7905.00 USD 7509.75 USD Income:Donations
--------------------------------------------
612.31 USD 21460.31 USD 20848.00 USD

=== openmpi ===

debit credit total
--------------------------------------------
0 658.92 USD 658.92 USD Equity:Net-Assets:Restricted

=== opensaf ===

debit credit total
--------------------------------------------
0 2445.86 USD 2445.86 USD Equity:Net-Assets:Restricted

=== openvas ===

debit credit total
--------------------------------------------
0 113.29 USD 113.29 USD Equity:Net-Assets:Restricted

=== openvoting ===

debit credit total
--------------------------------------------
0 1244.31 USD 1244.31 USD Equity:Net-Assets:Restricted
0.40 USD 0 -0.40 USD Expenses:Bank-Fees
28.50 USD 570.00 USD 541.50 USD Income:Donations
--------------------------------------------
28.90 USD 1814.31 USD 1785.41 USD

=== openwrt ===

debit credit total
--------------------------------------------
0 12730.53 USD 12730.53 USD Equity:Net-Assets:Restricted
51.94 USD 0 -51.94 USD Expenses:Bank-Fees
54.84 USD 1096.81 USD 1041.97 USD Income:Donations
--------------------------------------------
106.78 USD 13827.34 USD 13720.56 USD

=== openzfs ===

debit credit total
--------------------------------------------
0 25537.75 USD 25537.75 USD Equity:Net-Assets:Restricted
16325.76 USD 0 -16325.76 USD Expenses
376.71 USD 0 -376.71 USD Bank-Fees
13600.00 USD 0 -13600.00 USD Conferences:Services
1310.96 USD 0 -1310.96 USD IT:Hosting
350.00 USD 0 -350.00 USD Insurance
688.09 USD 0 -688.09 USD Software-Development
1708.27 USD 34165.33 USD 32457.06 USD Income:Donations
--------------------------------------------
18034.03 USD 59703.08 USD 41669.05 USD

=== pcp ===

debit credit total
--------------------------------------------
0 11310.84 USD 11310.84 USD Equity:Net-Assets:Restricted
11332.46 USD 0 -11332.46 USD Expenses
2.55 USD 0 -2.55 USD Bank-Fees
138.15 USD 0 -138.15 USD IT:Hosting
11191.76 USD 0 -11191.76 USD Software-Development
1.00 USD 22.62 USD 21.62 USD Income
0 2.62 USD 2.62 USD Currency-Exchange
1.00 USD 20.00 USD 19.00 USD Donations
--------------------------------------------
11333.46 USD 11333.46 USD 0

=== pmix ===

debit credit total
--------------------------------------------
0.98 USD 0 -0.98 USD Expenses:Bank-Fees
1.55 USD 30.98 USD 29.43 USD Income:Donations
--------------------------------------------
2.53 USD 30.98 USD 28.45 USD

=== postgresql ===

debit credit total
--------------------------------------------
0 148579.95 USD 148579.95 USD Equity:Net-Assets:Restricted
7236.94 USD 0 -7236.94 USD Expenses
818.74 USD 0 -818.74 USD Bank-Fees
1.15 USD 0 -1.15 USD Currency-Exchange
1088.00 USD 0 -1088.00 USD Marketing
5329.05 USD 0 -5329.05 USD Software-Development
2930.00 USD 58600.33 USD 55670.33 USD Income
0 0.22 USD 0.22 USD Currency-Exchange
2930.00 USD 58600.11 USD 55670.11 USD Donations
--------------------------------------------
10166.94 USD 207180.28 USD 197013.34 USD

=== privoxy ===

debit credit total
--------------------------------------------
0 8294.64 USD 8294.64 USD Equity:Net-Assets:Restricted
2005.94 USD 0 -2005.94 USD Expenses
15.03 USD 0 -15.03 USD Bank-Fees
1990.91 USD 0 -1990.91 USD IT:Hosting
51.75 USD 1035.00 USD 983.25 USD Income:Donations
--------------------------------------------
2057.69 USD 9329.64 USD 7271.95 USD

=== smc ===

debit credit total
--------------------------------------------
0 5924.04 USD 5924.04 USD Equity:Net-Assets:Restricted
5.46 USD 0 -5.46 USD Expenses:Bank-Fees
3.00 USD 60.00 USD 57.00 USD Income:Donations
--------------------------------------------
8.46 USD 5984.04 USD 5975.58 USD

=== spi ===

debit credit total
--------------------------------------------
0 549748.37 USD 549748.37 USD Equity:Net-Assets:Unrestricted
150045.76 USD 42213.78 USD -107831.98 USD Expenses
33260.98 USD 0 -33260.98 USD Accounting
2096.34 USD 14.38 USD -2081.96 USD Bank-Fees
53.33 USD 0 -53.33 USD Currency-Exchange
37339.04 USD 0 -37339.04 USD Depreciation
0 40700.68 USD 40700.68 USD Disassociation
57205.04 USD 1498.72 USD -55706.32 USD IT
534.03 USD 0 -534.03 USD Domains
9235.63 USD 0 -9235.63 USD Hosting
47435.38 USD 1498.72 USD -45936.66 USD Services
2320.00 USD 0 -2320.00 USD Insurance
12162.45 USD 0 -12162.45 USD Legal
1461.76 USD 0 -1461.76 USD Office:Postal
810.00 USD 0 -810.00 USD Project-Management
421.42 USD 0 -421.42 USD Training
2915.40 USD 0 -2915.40 USD Unrealized-Loss
32.10 USD 70853.32 USD 70821.22 USD Income
0 1.81 USD 1.81 USD Capital-Gain
0 47.70 USD 47.70 USD Currency-Exchange
32.10 USD 57354.12 USD 57322.02 USD Donations
0 724.68 USD 724.68 USD Interest
0 12725.01 USD 12725.01 USD Unrealized-Gain
--------------------------------------------
150077.86 USD 662815.47 USD 512737.61 USD

=== systemd ===

debit credit total
--------------------------------------------
0 203197.91 USD 203197.91 USD Equity:Net-Assets:Restricted
30333.21 USD 0 -30333.21 USD Expenses
174.72 USD 0 -174.72 USD Bank-Fees
158.49 USD 0 -158.49 USD Currency-Exchange
30000.00 USD 0 -30000.00 USD Software-Development
5.20 USD 409.58 USD 404.38 USD Income
0 305.58 USD 305.58 USD Currency-Exchange
5.20 USD 104.00 USD 98.80 USD Donations
--------------------------------------------
30338.41 USD 203607.49 USD 173269.08 USD

=== texmacs ===

debit credit total
--------------------------------------------
0 2156.42 USD 2156.42 USD Equity:Net-Assets:Restricted
20.25 USD 0 -20.25 USD Expenses:Bank-Fees
20.50 USD 410.00 USD 389.50 USD Income:Donations
--------------------------------------------
40.75 USD 2566.42 USD 2525.67 USD

=== tmw ===

debit credit total
--------------------------------------------
0 38.57 USD 38.57 USD Equity:Net-Assets:Restricted

=== translatewiki.net ===

debit credit total
--------------------------------------------
0 50.32 USD 50.32 USD Equity:Net-Assets:Restricted
8.33 USD 0 -8.33 USD Expenses:Bank-Fees
4.20 USD 84.00 USD 79.80 USD Income:Donations
--------------------------------------------
12.53 USD 134.32 USD 121.79 USD

=== tux4kids ===

debit credit total
--------------------------------------------
0 16687.49 USD 16687.49 USD Equity:Net-Assets:Restricted
59.43 USD 0 -59.43 USD Expenses
1.73 USD 0 -1.73 USD Bank-Fees
57.70 USD 0 -57.70 USD IT:Domains
12.50 USD 250.00 USD 237.50 USD Income:Donations
--------------------------------------------
71.93 USD 16937.49 USD 16865.56 USD

=== xorg ===

debit credit total
--------------------------------------------
0 110603.71 USD 110603.71 USD Equity:Net-Assets:Restricted
19033.96 USD 0 -19033.96 USD Expenses
288.43 USD 0 -288.43 USD Bank-Fees
18545.53 USD 0 -18545.53 USD IT
28.40 USD 0 -28.40 USD Domains
17182.38 USD 0 -17182.38 USD Hosting
1334.75 USD 0 -1334.75 USD Services
200.00 USD 0 -200.00 USD Software-Development
3867.83 USD 77357.16 USD 73489.33 USD Income
0 0.51 USD 0.51 USD Currency-Exchange
3867.83 USD 77356.65 USD 73488.82 USD Donations
--------------------------------------------
22901.79 USD 187960.87 USD 165059.08 USD

=== yafaray ===

debit credit total
--------------------------------------------
0 5448.50 USD 5448.50 USD Equity:Net-Assets:Restricted

--
Martin Michlmayr
https://www.cyrius.com/


From: Martin Michlmayr <tbm(at)spi-inc(dot)org>
To: spi-general(at)lists(dot)spi-inc(dot)org
Subject: Re: [DRAFT] Treasurer's report for 2021-12
Date: 2022-03-14 11:02:55
Message-ID: Yi8g31tsHBKsEkeg@jirafa.cyrius.com
Views: Raw Message | Whole Thread | Download mbox
Lists: spi-general

There was one problem in the 2021-12 report regarding the openzfs
earmark: a payment (for an outstanding receivable) was flagged as
a donation. Therefore, donations and A/R were overstated.

This also means the opening balance in the draft 2022-01 for openzfs
is incorrect (by $950).

I've fixed this in the books. We have a number of systems in place to
avoid such mistakes, but this unfortunately got through:

* Most A/R payments are automatically recognized in our import
scripts now, but not all payments methods are hooked into that
mechanism yet. (Even if it were, we can't recognize everything
automatically, although the level of automation has increased
substantially since the migration to beancount.)
* I run A/R checks periodically (and especially at year end before
creating opening balances for the next year), but I am behind
with certain year ends procedures. (I had limited time for SPI
recently but this will change as of next week.)
* I review donations over a certain size via PayPal manually
(to identify potential payments and other transactions to be
aware of) but I don't do the same for Click & Pledge. I will
add this check to the procedures.
* I was actually aware of this payment but forgot about it when
I imported the transactions (see first bullet point so we don't
need to rely on my brain).

--
Martin Michlmayr
Contractor, Software in the Public Interest, Inc.