Sugar Labs

Changes

Finance (view source)

Revision as of 12:38, 7 October 2017

8,207 bytes added ,  12:38, 7 October 2017
no edit summary
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 [http://sfconservancy.org/about/filings/ Software Freedom Conservancy (SFC)] manages finances for Sugar Labs, and provides snapshots to Sugar Labs' [[Oversight Board]] on request.  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.
+
The [http://sfconservancy.org/about/filings/ Software Freedom Conservancy (SFC)] manages finances for Sugar Labs, and provides snapshots to Sugar Labs' [[Oversight Board]] on request.
 +
 
 +
== 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>
Holt
579

edits

Retrieved from "https://wiki.sugarlabs.org/go/Special:MobileDiff/100913"