Finance: Difference between revisions
Remove broken link and make the instructions match what actually happens a bit better (more work to be done in the future) Tag: visualeditor-switched |
|||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 6: | Line 6: | ||
(We hope you'll also help us figure out how to get more resources as well!) | (We hope you'll also help us figure out how to get more resources as well!) | ||
The [ | The Treasurer manages finances for Sugar Labs. | ||
== 2023 == | |||
[[Finance/2023]] | |||
== 2022 == | |||
[[Finance/2022]] | |||
== 2021 == | |||
[[Finance/2021]] | |||
== 2020 == | |||
[[Finance/2020]] | |||
== 2019 == | |||
[[Finance/2019]] | |||
== 2018 == | |||
(Not yet documented) | |||
== 2017-01-01 to 2017-10-06 == | |||
<font size="1"> | |||
<pre> | |||
$ ledger -V -s -S T -d "T&l<=2" -f sugar.ledger bal '/^(Income|Expenses).*Sugar/' | |||
$ -305,599.52 Income:Sugar | |||
$ 230,231.80 Expenses:Sugar | |||
-------------------- | |||
$ -75,367.72 SUGAR LABS ASSETS AS OF 2017-10-06 (ignore the minus sign) | |||
</pre> | |||
<pre> | |||
2017 complete financials (until 2017-10-06) from SFConservancy's Sugar/Ledger/sugar.ledger and associated files: | |||
2017-01-26 from 2016-10-09 Expedia.ca - Artemis Papert - Flight - Budget From Search: $1,039 - Turtle Art Day PY 2016 - 1387.78 | |||
2017-02-13 from 2017-01-17 from 2016-12-23 from 2016-11-03? REV WIRE OUT - EDGAR QUISPE CHAMBI - Undefined Transaction (for Aymara translation) - 600.00 | |||
2017-04-10 from 2017-03-28 MARTIN DANIEL OESTERREICH WEIBERLEN - Domestic Wire Funds - Debit (for Guarani translation) - 900.00 | |||
2017-05-05 from 2017-04-13 PAYONEER INC - PAYMENT - ACH Credit - Google, Inc. - GCI 2017 Funds - 7000.00 (6300.00 after SFC's 10% deducted) | |||
2017-06-21 Outreachy - 2017-05 Sponsorship - 6500.00 | |||
Ignacio Rodríguez - GCI 2016, 2017-06-05 to 2017-06-08 - 2017-08-16 transaction (1942) to Walter Bender - 1550.96 (covers 2 below) | |||
2017-07-02 Ignacio Rodríguez - American Airlines (MVD-SFO) - Budget from search: $1,451 - GCI 2016 - 1350.96 | |||
2017-07-02 Ignacio Rodríguez - M&IE Per Diem - Max $230 - GCI 2016 - 200.00 | |||
Samson Goddy - GSoC Mentor Summit 2017-10-13 to 2017-10-15 - 3166.99 (covers 8 below) | |||
2017-09-29 Samson Goddy - JetBlue (LAX-BOS) - Paid by (SFC's) Brett Smith - Sub-budget from search: $242 - Budget from search: $2,748 - Budget from Project: $2,000 - GSoC Mentor Summit 2017 161.20 | |||
2017-10-04 from 2017-09-26 Samson Goddy - Emirates (LOS-SFO, BOS-LOS, official books contain typo "Ethiad") - Paid by (SFC's) Brett Smith - Sub-budget from search: $1,400 - Budget from search: $2,748 - Budget from Project: $2,000 - GSoC Mentor Summit 2017 - 1279.14 | |||
2017-10-04 from 2017-10-03 SAMSON SAMUEL GODDY - Domestic Wire Funds - Debit (550 + 347.73 via Walter Bender = 202.27 + 695.46) - 897.73 | |||
2017-10-04 from 2017-08-14 hnaylor@igc.org - Hilary Naylor - PayPal payment (for Samson Goddy) - 708.00 ($8 fee + covers 4 below) | |||
2017-08-16 Visa - Samson Goddy - GSoC Mentor Summit 2017 - 176.56 | |||
2017-08-16 Visa Agent - Samson Goddy - GSoC Mentor Summit 2017 - 138.08 | |||
2017-09-10 Grand Ibro Hotel - Samson Goddy - GSoC Mentor Summit 2017 - 55.33 | |||
2017-09-11 Samson Goddy - M&IE Per Diem - Max: $367.50 - GSoC Mentor Summit 2017 Visa - 330.03 | |||
2017-10-05 from 2017-09-29 Samson Goddy - Arik (PHC-LOS) - Paid by Walter Bender - Sub-budget from search: $257 - Budget from search: $2,748 - Budget from Project: $2,000 - GSoC Mentor Summit 2017 - 120.92 | |||
2017 INCOME TO DATE (2017-10-06) *ESTIMATED* FROM ABOVE: $6300.00 | |||
2017 EXPENSES TO DATE (2017-10-06) *ESTIMATED* FROM ABOVE: $14105.73 | |||
Which do not match the more official numbers below due to various issues like transactions posting in a different financial year, conflicting exchange rates, etc: | |||
$ ledger -V -s -S T -d "T&l<=2" -f sugar.ledger bal '/^(Income|Expenses).*Sugar/' -b 2017 | |||
$ -6,300.00 Income:Sugar | |||
$ 11,953.67 Expenses:Sugar | |||
-------------------- | |||
$ 5,653.67 | |||
</pre> | |||
</font> | |||
== 2016-01-01 to 2016-12-31 == | |||
<font size="1"> | |||
<pre> | |||
2016 complete financials from SFConservancy's Sugar/Ledger/sugar.ledger and associated files: | |||
Walter Bender - Thailand Conference 2016-02-01 to 2016-02-05 - 2016-04-13 transaction (1808) 1389.29 (covers 6 below) | |||
2015-12-23 Turkish Airlines - Walter Bender - Constructionism 2016 - Flight (BOX-BKK) - 807.22 | |||
2015-12-24 King Mongkut's University of Technology Thonburi - Walter Bender - Constructionism 2016 - Conference Registration - 250.00 | |||
2016-02-01 Uber - Walter Bender - Constructionism 2016 - Ground Transportation - 30.21 | |||
2016-02-01 Hellconia House - Walter Bender - Constructionism 2016 - Hotel - 168.60 | |||
2016-02-06 Boston Logan International Airport - Walter Bender - Constructionism 2016 - Parking - 3.00 | |||
2016-02-07 ME&I Per Diem - Walter Bender - Constructionism 2016 - 130.26 | |||
Devin Ulibarri - Thailand Conference 2016-02-01 to 2016-02-05 - 3656.67 (covers 5 below) | |||
2016-02-01 Hellconia House - Devin Ulibarri - Constructionism 2016 - Hotel - 168.60 | |||
2016-02-02 King Mongkut's University of Technology Thonburi - Devin Ulibarri - Constructionism 2016 - Conference Registration - 380.00 | |||
2016-02-07 ME&I Per Diem - Devin Ulibarri - Constructionism 2016 - 354.48 | |||
2016-04-22 from 2015-12-23 Turkish Airlines (BOS-BKK) - Devin Ulibarri - purchased by Walter Bender - Constructionism 2016 - Flight - 787.31 | |||
2016-05-26 for 2016-05-13 Devin Ulibarri - Constructionism 2016 - Consulting Work - 500.00 | |||
2016-02-05 from 2015-12-14 GOOGLE INC - BP SETTLE - ACH - CREDIT - 1914.55 (apparently this does not count as 2016 income?) | |||
2016-04-22 from 2016-03-20 EDGAR QUISPE CHAMBI - DOMESTIC WIRE FUNDS - DEBIT (for Aymara translation) - 200.00 | |||
2016-05-06 from 2016-02-13 GOOGLE INC - BP SETTLE - ACH CREDIT - 7000.00 (6300.00 after SFC's 10% deducted) | |||
Edgar Quispe Chambi - 2016-05-12 DOMESTIC WIRE FUNDS - DEBIT (Conferences:Simposio Internacial) - 161.88 (covers 6 below) | |||
2016-03-20 Cruz Del Sur - Edgar Quispe Chambi - Bus Transport - 26.66 | |||
2016-03-20 Cruz Del Sur - Edgar Quispe Chambi - Bus Transport - 17.48 | |||
2016-03-21 Jian Hotel - Edgar Quispe Chambi - Hotel - Partial Reimbursement Per Request - 20.66 | |||
2016-03-22 Expresso - Edgar Quispe Chambi - Bus Transport - 5.86 | |||
2016-03-22 Cruz Del Sur - Edgar Quispe Chambi - Bus Transport - 32.25 | |||
2016-03-22 ME&I Per Diem - Edgar Quispe Chambi - 58.97 | |||
Mariah Noelle Villarreal - GCI 2016-06-11 to 2016-06-15 - Flight - transaction 2016-06-13 from 2016-05-09 Jet Blue (BOS-SFO) - 563.20 | |||
Samson Goddy - for Yoruba translation - 4000.00 (covers 2 below) | |||
2016-07-01 OGONDA SOLOMON - DOMESTIC WIRE FUNDS - DEBIT - 350.00 | |||
2016-10-07 OGONDA SOLOMON - for Samson Goddy - DOMESTIC WIRE FUNDS - DEBIT - 3650.00 | |||
2016-08-31 Transfer from Sugar Vanguard to new Treasury Money Market (neither income nor expenditure) - 59972.88 | |||
2016-09-12 Google - GSoC 2016 - Sugar Mentor Funds (credit) - 6300.00 (5670.00 after SFC's 10% deducted) | |||
Lionel Laske - GSoc Mentor Summit 2016-10-28 to 2016-10-30 - transaction 2016-11-28 - 824.83 (covers 3 below) | |||
2016-10-24 Aéroports de Paris - Lionel Laské - Parking - GSoC Mentor Summit 2016 - 75.12 | |||
2016-10-28 South and East Bay Airport Suttle - Lionel Laské - Ground Transportation - GSoC Mentor Summit 2016 - 40.00 | |||
2016-11-28 from 2016-09-09 Expedia.fr (CDG-SFO) - Lionel Laské - Flight - Budget From Search: UNKNOWN - GSoC Mentor Summit 2016 (incl 21.90 currency conversion) - 709.71 | |||
Michaël Ohayon - GSoc Mentor Summit 2016-10-28 to 2016-10-30 - 706.26 (covers 2 below) | |||
2016-11-25 from 2016-08-24 United Airlines (CDG-SFO) - Michaël Ohayon - Flight - Budget From Search: $671 - GSoC Mentor Summit 2016 - 670.73 | |||
2016-11-25 from 2016-11-01 ME&I Per Diem - Michaël Ohayon - 4 days - Max: $224 - GSoC Mentor Summit 2016 - 35.53 | |||
Andrea Vasquez Guerra - 2016-11-28 - Domestic Wire Funds - Debit - 559.00 (covers 3 below) | |||
2016-10-16 Sky Airline (SCL-MVD) - Andrea Vasquez Guerra - Flight - Budget From Search: $412 - Turtle Art Day UY 2016 - 340.00 | |||
2016-10-26 despagar.com - Andrea Vasquez Guerra - Hotel, 2 nights - Avg: $94/night, Max: $160/night - Turtle Art Day UY 2016 - 187.40 | |||
2016-11-03 ME&I Per Diem - Andrea Vasquez Guerra - 3 days - Max: $230 - Turtle Art Day UY 2016 - 31.60 | |||
2016-11-30 from 2016-01-29 onwards - Dividend (credit) - 208.75 (187.88 after SFC 10% deducted; dividend payments do not appear after 2016-11-30, as of 2017-10-06) | |||
2016 INCOME *ESTIMATED* FROM ABOVE: $12178.75 | |||
2016 EXPENSES *ESTIMATED* FROM ABOVE: $12061.13 | |||
Which do not match the more official numbers below due to various issues like transactions posting in a different financial year, conflicting exchange rates, etc: | |||
$ ledger -V -s -S T -d "T&l<=2" -f sugar.ledger bal '/^(Income|Expenses).*Sugar/' -b 2016 -e 2017 | |||
$ -12,200.34 Income:Sugar | |||
$ 10,738.09 Expenses:Sugar | |||
-------------------- | |||
$ -1,462.25 | |||
</pre> | |||
</font> | |||
== Fiscal Year 2015 (1 March 2015 - 29 February 2016) == | == Fiscal Year 2015 (1 March 2015 - 29 February 2016) == | ||
Four fiscal years (2012, 2013, 2014, 2015) are summarized below by Adam Holt, after the Oversight Board received extensive accounting files from SFC late evening of 11 February 2016. | |||
<pre> | <pre> | ||
| Line 15: | Line 152: | ||
Income:Conservancy:Donations 900.00 | Income:Conservancy:Donations 900.00 | ||
Income:Sugar:Donations | Income:Sugar:Donations 8,100.00 | ||
Total Donations 9,000.00 | Total Donations 9,000.00 | ||
Total Interest Income 28.56 | Total Interest Income 28.56 | ||
| Line 21: | Line 158: | ||
Expenses:Sugar:Development 550.00 | Expenses:Sugar:Development 550.00 | ||
Expenses:Sugar:Conferences:Travel | Expenses:Sugar:Conferences:Travel 4,610.46 | ||
Expenses:Sugar:Conferences:Travel:Per Diem 30.65 | Expenses:Sugar:Conferences:Travel:Per Diem 30.65 | ||
Expenses:Sugar:Trademark:Registration 700.00 | Expenses:Sugar:Trademark:Registration 700.00 | ||
| Line 27: | Line 164: | ||
Cash 101,375.99 | Cash 101,375.99 | ||
Accounts Receivable | Accounts Receivable 1,914.55 | ||
TOTAL ASSETS 103,290.54 | TOTAL ASSETS 103,290.54 | ||
| Line 41: | Line 178: | ||
<pre> | <pre> | ||
Income:Conservancy:Donations | Income:Conservancy:Donations 4,962.00 | ||
Income:Sugar:Donations | Income:Sugar:Donations 44,658.01 | ||
Total Donations 49,620.01 | Total Donations 49,620.01 | ||
Total Interest Income 2.17 | Total Interest Income 2.17 | ||
TOTAL INCOME 49,622.18 | TOTAL INCOME 49,622.18 | ||
Expenses:Sugar:Conferences:Food | Expenses:Sugar:Conferences:Food 2,176.27 | ||
Expenses:Sugar:Conferences:Materials 49.00 | Expenses:Sugar:Conferences:Materials 49.00 | ||
Expenses:Sugar:Conferences:Travel | Expenses:Sugar:Conferences:Travel 1,991.90 | ||
Expenses:Sugar:Conferences:Travel:Per Diem 31.65 | Expenses:Sugar:Conferences:Travel:Per Diem 31.65 | ||
Expenses:Sugar:Conferences:Venue 124.00 | Expenses:Sugar:Conferences:Venue 124.00 | ||
| Line 56: | Line 193: | ||
Cash 99,453.09 | Cash 99,453.09 | ||
Accounts Receivable 0.00 | Accounts Receivable (0.00) | ||
TOTAL ASSETS 99,453.09 | TOTAL ASSETS 99,453.09 | ||
| Line 70: | Line 207: | ||
<pre> | <pre> | ||
Income:Conservancy:Donations | Income:Conservancy:Donations 4,911.00 | ||
Income:Sugar:Donations | Income:Sugar:Donations 44,199.00 | ||
Total Donations 49,110.00 | Total Donations 49,110.00 | ||
Total Interest Income 4.09 | Total Interest Income 4.09 | ||
| Line 78: | Line 215: | ||
Expenses:Sugar:Development 825.00 | Expenses:Sugar:Development 825.00 | ||
Expenses:Sugar:Conferences:Food | Expenses:Sugar:Conferences:Food 1,400.00 | ||
Expenses:Sugar:Conferences:Travel | Expenses:Sugar:Conferences:Travel 11,160.72 | ||
Expenses:Sugar:Conferences:Travel:Per Diem 121.43 | Expenses:Sugar:Conferences:Travel:Per Diem 121.43 | ||
Expenses:Sugar:Currency Conversion 38.39 | Expenses:Sugar:Currency Conversion 38.39 | ||
| Line 99: | Line 236: | ||
<pre> | <pre> | ||
Income:Conservancy:Donations | Income:Conservancy:Donations 1,907.02 (same number appears below as OUTGOING donation, weird) | ||
Income:Sugar:Donations -1706.02 (what is a negative donation? SFC will know?) | Income:Sugar:Donations -1706.02 (what is a negative donation? SFC will know?) | ||
Total Donations 201.00 | Total Donations 201.00 | ||
| Line 105: | Line 242: | ||
TOTAL INCOME 208.26 | TOTAL INCOME 208.26 | ||
Expenses:Sugar:Conferences:Travel | Expenses:Sugar:Conferences:Travel 2,317.64 | ||
Expenses:Sugar:Banking Fees 5.22 | Expenses:Sugar:Banking Fees 5.22 | ||
Expenses:Sugar:Currency Conversion 13.41 | Expenses:Sugar:Currency Conversion 13.41 | ||
Expenses:Sugar:Promotional | Expenses:Sugar:Promotional 2,390.00 | ||
Expenses:Sugar:Computer Equipment | Expenses:Sugar:Computer Equipment 4,699.29 | ||
Expenses:Sugar:Hosting 25.00 | Expenses:Sugar:Hosting 25.00 | ||
TOTAL EXPENSES 9,450.56 | TOTAL EXPENSES 9,450.56 | ||
| Line 117: | Line 254: | ||
TOTAL ASSETS 17,409.35 | TOTAL ASSETS 17,409.35 | ||
Accounts Payable | Accounts Payable (0.00) | ||
Liabilities, Credit Cards 6,829.53 | Liabilities, Credit Cards 6,829.53 | ||
Donated To [Software Freedom] Conservancy 1,907.02 | Donated To [Software Freedom] Conservancy 1,907.02 | ||
| Line 137: | Line 274: | ||
** $8,614.92 USD unrestricted (available for future grants) | ** $8,614.92 USD unrestricted (available for future grants) | ||
''[[User:Robert|Robert Fadel]] | ''[[User:Robert|Robert Fadel]] (was) providing monthly income and expense details.'' | ||
''Balance information is based on a ledger account reconciliation completed on February 24, 2012.'' | ''Balance information is based on a ledger account reconciliation completed on February 24, 2012.'' | ||
| Line 161: | Line 298: | ||
A request can be filled out in 10 minutes or less. We're trying to make this process as easy as possible! | A request can be filled out in 10 minutes or less. We're trying to make this process as easy as possible! | ||
# | # Send an email to the Sugar Labs executive director at devin@sugarlabs.org | ||
# Answer the [[#What we need to know]] questions in the description field of your ticket. | # Answer the [[#What we need to know]] questions in the description field of your ticket. | ||
# Once the ticket has been filed, Send an email to [http://lists.sugarlabs.org/listinfo/iaep iaep] (for transparency) and [http://lists.sugarlabs.org/listinfo/slobs slobs] (as the decision-making body) with the subject line "New Finance Request: <short summary of the item requested>," where <short summary of the item requested> is replaced by... well, a short summary of what you're asking for money for, and a link to the ticket in the body of your email. '''This is important. If you do not email both lists, nobody will know you've submitted a budget request!''' | # Once the ticket has been filed, Send an email to [http://lists.sugarlabs.org/listinfo/iaep iaep] (for transparency) and [http://lists.sugarlabs.org/listinfo/slobs slobs] (as the decision-making body) with the subject line "New Finance Request: <short summary of the item requested>," where <short summary of the item requested> is replaced by... well, a short summary of what you're asking for money for, and a link to the ticket in the body of your email. '''This is important. If you do not email both lists, nobody will know you've submitted a budget request!''' | ||
At this point, you should wait to hear back from SLOBs. If nobody's responded to your request within a week, feel free to ping both mailing lists again. | At this point, you should wait to hear back from SLOBs. If nobody's responded to your request within a week, feel free to ping both mailing lists again. | ||
=== What we need to know === | === What we need to know === | ||
| Line 176: | Line 310: | ||
==== For funding travel ==== | ==== For funding travel ==== | ||
Travel funding is subject to the '''[https://sfconservancy.org/projects/policies/conservancy-travel-policy.html Software Freedom Conservancy Travel and Reimbursable Expense Policy.]''' | |||
Please read the policy to understand if you are eligible to ask for funds to cover a trip. Here's a handy shortlist of summary questions: | |||
# '''Where are you going''' (location and event)? | # '''Where are you going''' (location and event)? | ||
| Line 194: | Line 330: | ||
* Specific: Write a working module for Web App Q that creates a service queue for Team X to do Task Z more efficiently. | * Specific: Write a working module for Web App Q that creates a service queue for Team X to do Task Z more efficiently. | ||
* Specific: Agree on and publish a complete plan, schedule, and milestones for Project W. | * Specific: Agree on and publish a complete plan, schedule, and milestones for Project W. | ||
Sugar Labs can book flights direct, but will need the following info to do so: | |||
* Exact itinerary, including specific flights, airports and time, and be sure the total is within the travel policy requirements. | |||
* Passport Information | |||
** Full Name, as it appears on the Passport | |||
** Issue Date | |||
** Expiration date | |||
** Country of Issue | |||
** Gender | |||
** Date of Birth | |||
* Mobile number (For flight change alters, if you want them) | |||
* Frequent flyer numbers for major airlines (if you want the miles credited) | |||
* Seat Preference (either specific seats, or "Aisle vs. Window" preference) | |||
* Meal Preference (if a meal is included in the coach flight) | |||
==== For purchasing things ==== | ==== For purchasing things ==== | ||