Difference between revisions of "Financial report (Q3 2017–2018)"

From Wikimedia District of Columbia
Jump to: navigation, search
(Working)
 
(Working)
Line 27: Line 27:
 
| colspan="2" | Wikimedia Foundation grants
 
| colspan="2" | Wikimedia Foundation grants
 
| align="right" | $25,592.65
 
| align="right" | $25,592.65
| align="right" | 0.0%
+
| align="right" | 32.0%
 
| align="right" | $25,592.65
 
| align="right" | $25,592.65
| align="right" | 0.0%
+
| align="right" | 32.0%
 
| width="40%" | {{note|New grant funding for WikiConference North America 2018, less refunds of unspent grant funds from the 2016–17 SAPG, 2017 Strategy Salon, and 2017 USF SOLIS grants; includes grant funds subject to fiscal sponsorship agreements.}}
 
| width="40%" | {{note|New grant funding for WikiConference North America 2018, less refunds of unspent grant funds from the 2016–17 SAPG, 2017 Strategy Salon, and 2017 USF SOLIS grants; includes grant funds subject to fiscal sponsorship agreements.}}
 
|-
 
|-
Line 48: Line 48:
 
| colspan="2" | '''Total restricted revenue'''
 
| colspan="2" | '''Total restricted revenue'''
 
| align="right" | '''$25,592.65'''
 
| align="right" | '''$25,592.65'''
| align="right" | '''0.2%'''
+
| align="right" | '''11.1%'''
 
| align="right" | '''$25,969.42'''
 
| align="right" | '''$25,969.42'''
| align="right" | '''0.2%'''
+
| align="right" | '''11.3%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 70: Line 70:
 
| colspan="2" | Member dues and donations
 
| colspan="2" | Member dues and donations
 
| align="right" | $285.00
 
| align="right" | $285.00
| align="right" | 16.3%
+
| align="right" | 14.3%
 
| align="right" | $1,603.00
 
| align="right" | $1,603.00
| align="right" | 65.9%
+
| align="right" | 80.2%
 
| width="40%" | {{note|Membership dues and associated donations not exceeding $1,000 per member per year.}}
 
| width="40%" | {{note|Membership dues and associated donations not exceeding $1,000 per member per year.}}
 
|-
 
|-
 
| colspan="2" | Corporate donations
 
| colspan="2" | Corporate donations
 
| align="right" | $0.00
 
| align="right" | $0.00
| align="right" | 40.0%
+
| align="right" | 0.0%
 
| align="right" | $200.00
 
| align="right" | $200.00
 
| align="right" | 40.0%
 
| align="right" | 40.0%
Line 91: Line 91:
 
| colspan="2" | '''Total unrestricted revenue'''
 
| colspan="2" | '''Total unrestricted revenue'''
 
| align="right" | '''$308.62'''
 
| align="right" | '''$308.62'''
| align="right" | '''5.9%'''
+
| align="right" | '''1.8%'''
 
| align="right" | '''$77,354.14'''
 
| align="right" | '''$77,354.14'''
| align="right" | '''440.3%'''
+
| align="right" | '''442.0%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
 
| colspan="3" | '''Total revenue'''
 
| colspan="3" | '''Total revenue'''
 
| align="right" | '''$25,901.27'''
 
| align="right" | '''$25,901.27'''
| align="right" | '''0.6%'''
+
| align="right" | '''10.5%'''
 
| align="right" | '''$103,323.56'''
 
| align="right" | '''$103,323.56'''
| align="right" | '''31.3%'''
+
| align="right" | '''41.8%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 130: Line 130:
 
| Staff
 
| Staff
 
| align="right" | $15,673.84
 
| align="right" | $15,673.84
| align="right" | 23.1%
+
| align="right" | 26.9%
 
| align="right" | $44,782.40
 
| align="right" | $44,782.40
| align="right" | 50.0%
+
| align="right" | 76.9%
 
| width="40%" | {{note|Wages and fringe costs for one full-time staff position, the Institutional Partnerships Manager.}}
 
| width="40%" | {{note|Wages and fringe costs for one full-time staff position, the Institutional Partnerships Manager.}}
 
|-
 
|-
 
| Events
 
| Events
 
| align="right" | $666.66
 
| align="right" | $666.66
| align="right" | 40.8%
+
| align="right" | 9.9%
 
| align="right" | $4,718.64
 
| align="right" | $4,718.64
| align="right" | 60.0%
+
| align="right" | 69.9%
| width="40%" | {{note|Food, beverage, and incidental costs for 8 events.}}
+
| width="40%" | {{note|Food, beverage, and incidental costs for 3 events.}}
 
|-
 
|-
 
| '''Total institutional partnership costs'''
 
| '''Total institutional partnership costs'''
 
| align="right" | '''$16,340.50'''
 
| align="right" | '''$16,340.50'''
| align="right" | '''24.9%'''
+
| align="right" | '''25.2%'''
 
| align="right" | '''$49,501.04'''
 
| align="right" | '''$49,501.04'''
| align="right" | '''51.0%'''
+
| align="right" | '''76.2%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 188: Line 188:
 
| Boot Camp
 
| Boot Camp
 
| align="right" | $6,771.52
 
| align="right" | $6,771.52
| align="right" | 0.0%
+
| align="right" | 45.1%
 
| align="right" | $6,771.52
 
| align="right" | $6,771.52
| align="right" | 0.0%
+
| align="right" | 45.1%
 
| width="40%" | {{note|}}
 
| width="40%" | {{note|}}
 
|-
 
|-
 
| '''Total training and support costs'''
 
| '''Total training and support costs'''
 
| align="right" | '''$6,771.52'''
 
| align="right" | '''$6,771.52'''
| align="right" | '''0.0%'''
+
| align="right" | '''45.1%'''
 
| align="right" | '''$6,771.52'''
 
| align="right" | '''$6,771.52'''
| align="right" | '''0.0%'''
+
| align="right" | '''45.1%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 210: Line 210:
 
| Fiscal sponsorships
 
| Fiscal sponsorships
 
| align="right" | $89.40
 
| align="right" | $89.40
| align="right" | 2.1%
+
| align="right" | 0.1%
 
| align="right" | $17,129.86
 
| align="right" | $17,129.86
| align="right" | 13.6%
+
| align="right" | 13.7%
| width="40%" | {{note|Disbursements of grant funds administered under the Art+Feminism SAPG 2016-17 and WikiConference North America fiscal sponsorship agreements.}}
+
| width="40%" | {{note|Disbursements of grant funds administered under the WikiConference North America fiscal sponsorship agreements.}}
 
|-
 
|-
 
| Guided sponsorships
 
| Guided sponsorships
Line 224: Line 224:
 
| '''Total grantmaking and sponsorship costs'''
 
| '''Total grantmaking and sponsorship costs'''
 
| align="right" | '''$89.40'''
 
| align="right" | '''$89.40'''
| align="right" | '''1.8%'''
+
| align="right" | '''0.1%'''
 
| align="right" | '''$17,129.86'''
 
| align="right" | '''$17,129.86'''
 
| align="right" | '''11.4%'''
 
| align="right" | '''11.4%'''
Line 231: Line 231:
 
| colspan="2" | '''Total program costs'''
 
| colspan="2" | '''Total program costs'''
 
| align="right" | '''$23,201.42'''
 
| align="right" | '''$23,201.42'''
| align="right" | '''8.4%'''
+
| align="right" | '''9.8%'''
 
| align="right" | '''$74,402.42'''
 
| align="right" | '''$74,402.42'''
| align="right" | '''21.7%'''
+
| align="right" | '''31.5%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 256: Line 256:
 
| align="right" | 25%
 
| align="right" | 25%
 
| align="right" | $450.00
 
| align="right" | $450.00
| align="right" | 50%
+
| align="right" | 75%
 
| width="40%" | {{note|QuickBooks Online subscription.}}
 
| width="40%" | {{note|QuickBooks Online subscription.}}
 
|-
 
|-
 
| Payroll service
 
| Payroll service
 
| align="right" | $135.00
 
| align="right" | $135.00
| align="right" | 26.1%
+
| align="right" | 25.0%
 
| align="right" | $441.00
 
| align="right" | $441.00
| align="right" | 56.7%
+
| align="right" | 81.7%
 
| width="40%" | {{note|Gusto payroll service.}}
 
| width="40%" | {{note|Gusto payroll service.}}
 
|-
 
|-
 
| Transaction fees
 
| Transaction fees
 
| align="right" | $24.27
 
| align="right" | $24.27
| align="right" | 3.1%
+
| align="right" | 6.1%
 
| align="right" | $59.04
 
| align="right" | $59.04
| align="right" | 8.7%
+
| align="right" | 14.8%
 
| width="40%" | {{note|PayPal fees.}}
 
| width="40%" | {{note|PayPal fees.}}
 
|-
 
|-
 
| '''Total finance costs'''
 
| '''Total finance costs'''
 
| align="right" | '''$309.27'''
 
| align="right" | '''$309.27'''
| align="right" | '''19.7%'''
+
| align="right" | '''20.1%'''
 
| align="right" | '''$950.04'''
 
| align="right" | '''$950.04'''
| align="right" | '''41.6%'''
+
| align="right" | '''61.7%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
 
| colspan="2" | '''Insurance'''
 
| colspan="2" | '''Insurance'''
 
| align="right" | '''($219.51)'''
 
| align="right" | '''($219.51)'''
| align="right" | '''0.0%'''
+
| align="right" | ''''''
 
| align="right" | '''($219.51)'''
 
| align="right" | '''($219.51)'''
| align="right" | '''0.0%'''
+
| align="right" | ''''''
 
| width="40%" | {{note|Refund of insurance premium overpayment.}}
 
| width="40%" | {{note|Refund of insurance premium overpayment.}}
 
|-
 
|-
Line 297: Line 297:
 
| Filing fees
 
| Filing fees
 
| align="right" | $179.00
 
| align="right" | $179.00
| align="right" | 2.7%
+
| align="right" | 27.5%
 
| align="right" | $196.45
 
| align="right" | $196.45
| align="right" | 2.7%
+
| align="right" | 30.2%
 
| width="40%" | {{note|}}
 
| width="40%" | {{note|}}
 
|-
 
|-
 
| '''Total legal costs'''
 
| '''Total legal costs'''
 
| align="right" | '''$179.00'''
 
| align="right" | '''$179.00'''
| align="right" | '''2.7%'''
+
| align="right" | '''27.5%'''
 
| align="right" | '''$196.45'''
 
| align="right" | '''$196.45'''
| align="right" | '''2.7%'''
+
| align="right" | '''30.2%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 321: Line 321:
 
| align="right" | 25.0%
 
| align="right" | 25.0%
 
| align="right" | $540.00
 
| align="right" | $540.00
| align="right" | 50.0%
+
| align="right" | 75.0%
 
| width="40%" | {{note|Mail delivery service at Cove.}}
 
| width="40%" | {{note|Mail delivery service at Cove.}}
 
|-
 
|-
Line 333: Line 333:
 
| PO box
 
| PO box
 
| align="right" | $136.00
 
| align="right" | $136.00
| align="right" | 0.0%
+
| align="right" | 85.0%
 
| align="right" | $136.00
 
| align="right" | $136.00
| align="right" | 0.0%
+
| align="right" | 85.0%
 
| width="40%" | {{note|}}
 
| width="40%" | {{note|}}
 
|-
 
|-
 
| '''Total mailing costs'''
 
| '''Total mailing costs'''
 
| align="right" | '''$316.00'''
 
| align="right" | '''$316.00'''
| align="right" | '''16.0%'''
+
| align="right" | '''28.1%'''
 
| align="right" | '''$778.45'''
 
| align="right" | '''$778.45'''
| align="right" | '''41.1%'''
+
| align="right" | '''69.2%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 362: Line 362:
 
| Board meetings
 
| Board meetings
 
| align="right" | ($50.00)
 
| align="right" | ($50.00)
| align="right" | 44.4%
+
| align="right" |
 
| align="right" | $150.00
 
| align="right" | $150.00
| align="right" | 44.4%
+
| align="right" | 33.3%
 
| width="40%" | {{note|Refund of conference room rental overpayment.}}
 
| width="40%" | {{note|Refund of conference room rental overpayment.}}
 
|-
 
|-
Line 376: Line 376:
 
| '''Total meeting costs'''
 
| '''Total meeting costs'''
 
| align="right" | '''($50.00)'''
 
| align="right" | '''($50.00)'''
| align="right" | '''17.4%'''
+
| align="right" | ''''''
 
| align="right" | '''$760.00'''
 
| align="right" | '''$760.00'''
| align="right" | '''70.4%'''
+
| align="right" | '''66.1%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 399: Line 399:
 
| Business cards
 
| Business cards
 
| align="right" | $50.01
 
| align="right" | $50.01
| align="right" | 0.0%
+
| align="right" | 14.3%
 
| align="right" | $85.44
 
| align="right" | $85.44
| align="right" | 10.1%
+
| align="right" | 24.4%
 
| width="40%" | {{note|}}
 
| width="40%" | {{note|}}
 
|-
 
|-
 
| '''Total printing and publishing costs'''
 
| '''Total printing and publishing costs'''
 
| align="right" | '''$50.01'''
 
| align="right" | '''$50.01'''
| align="right" | '''0.0%'''
+
| align="right" | '''6.7%'''
 
| align="right" | '''$184.42'''
 
| align="right" | '''$184.42'''
| align="right" | '''17.9%'''
+
| align="right" | '''24.6%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
 
| colspan="2" | '''Technology'''
 
| colspan="2" | '''Technology'''
 
| align="right" | '''$141.60'''
 
| align="right" | '''$141.60'''
| align="right" | '''29.8%'''
+
| align="right" | '''11.3%'''
 
| align="right" | '''$689.24'''
 
| align="right" | '''$689.24'''
| align="right" | '''43.8%'''
+
| align="right" | '''55.1%'''
 
| width="40%" | {{note|}}
 
| width="40%" | {{note|}}
 
|-
 
|-
Line 449: Line 449:
 
| colspan="2" | '''Total administrative costs'''
 
| colspan="2" | '''Total administrative costs'''
 
| align="right" | '''$821.80'''
 
| align="right" | '''$821.80'''
| align="right" | '''7.2%'''
+
| align="right" | '''5.5%'''
 
| align="right" | '''$5,252.10'''
 
| align="right" | '''$5,252.10'''
| align="right" | '''29.6%'''
+
| align="right" | '''35.1%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
 
| colspan="3" | '''Total expenses'''
 
| colspan="3" | '''Total expenses'''
 
| align="right" | '''$24,023.22'''
 
| align="right" | '''$24,023.22'''
| align="right" | '''8.3%'''
+
| align="right" | '''9.6%'''
 
| align="right" | '''$79,654.52'''
 
| align="right" | '''$79,654.52'''
| align="right" | '''22.2%'''
+
| align="right" | '''31.7%'''
 
| width="40%" |  
 
| width="40%" |  
 
|-
 
|-
Line 522: Line 522:
 
| rowspan="2" style="width:10px;" |
 
| rowspan="2" style="width:10px;" |
 
| Unrestricted cash
 
| Unrestricted cash
| align="right" | $0.00
+
| align="right" | $49,180.39
 
| width="60%" |  
 
| width="60%" |  
 
|-
 
|-
 
| Restricted cash
 
| Restricted cash
| align="right" | $0.00
+
| align="right" | $58,378.43
| width="60%" | {{note|}}
+
| width="60%" | {{note|Restricted funds associated with the WikiConference North America, Women in Red, and Art+Feminism 2016–17 programs; includes grant funds subject to fiscal sponsorship agreements.}}
 
|-
 
|-
 
| colspan="2" | '''Non-current assets'''
 
| colspan="2" | '''Non-current assets'''
Line 547: Line 547:
 
|-
 
|-
 
| colspan="2" | '''Total assets'''
 
| colspan="2" | '''Total assets'''
| align="right" | '''$0.00'''
+
| align="right" | '''$107,558.82'''
 
| width="60%" |        
 
| width="60%" |        
 
|-
 
|-
Line 559: Line 559:
 
| style="width:10px;" |
 
| style="width:10px;" |
 
| Net accumulated surplus
 
| Net accumulated surplus
| align="right" | $0.00
+
| align="right" | $107,558.82
 
| width="60%" |  
 
| width="60%" |  
 
|-
 
|-
 
| colspan="2" | '''Total liabilities and net assets'''
 
| colspan="2" | '''Total liabilities and net assets'''
| align="right" | '''$0.00'''
+
| align="right" | '''$107,558.82'''
 
| width="60%" |  
 
| width="60%" |  
 
|}
 
|}

Revision as of 01:59, 21 August 2018

This report describes the financial activity of Wikimedia District of Columbia from April 1, 2018 through June 30, 2018.

Income Statement

The following statement reflects Wikimedia District of Columbia's income and expenses during the fiscal quarter starting April 1, 2018 and ending June 30, 2018, as well as fiscal year-to-date through June 30, 2018. For each income and expense category specified in the Annual Budget for Fiscal Year 2017–18, the statement indicates the percentage of the budgeted income or expense amount which was actually incurred during the fiscal quarter or fiscal year-to-date.

Revenue
Fiscal Quarter Revenue and Percentage of Annual Budget Fiscal Year-to-Date Revenue and Percentage of Annual Budget
Restricted revenue
Wikimedia Foundation grants $25,592.65 32.0% $25,592.65 32.0% New grant funding for WikiConference North America 2018, less refunds of unspent grant funds from the 2016–17 SAPG, 2017 Strategy Salon, and 2017 USF SOLIS grants; includes grant funds subject to fiscal sponsorship agreements.
Other grants $0.00 $0.00
Other restricted contributions $0.00 $376.77
Total restricted revenue $25,592.65 11.1% $25,969.42 11.3%
Unrestricted revenue
Individual donations $0.00 0.0% $75,000.00 500.0% Significant individual donations in excess of $1,000 per donor per year.
Member dues and donations $285.00 14.3% $1,603.00 80.2% Membership dues and associated donations not exceeding $1,000 per member per year.
Corporate donations $0.00 0.0% $200.00 40.0%
Affiliate programs $23.62 $551.14 AmazonSmile and Nonprofits on Facebook.
Total unrestricted revenue $308.62 1.8% $77,354.14 442.0%
Total revenue $25,901.27 10.5% $103,323.56 41.8%  
Expenses
Fiscal Quarter Expenses and Percentage of Annual Budget Fiscal Year-to-Date Expenses and Percentage of Annual Budget
Program costs
Institutional partnership
Staff $15,673.84 26.9% $44,782.40 76.9% Wages and fringe costs for one full-time staff position, the Institutional Partnerships Manager.
Events $666.66 9.9% $4,718.64 69.9% Food, beverage, and incidental costs for 3 events.
Total institutional partnership costs $16,340.50 25.2% $49,501.04 76.2%
Content development
Fellowships $0.00 0.0% $0.00 0.0%
Photography contests $0.00 100.0% $1,000.00 100.0%
Total content development costs $0.00 0.0% $1,000.00 16.7%
Training and support
Boot Camp $6,771.52 45.1% $6,771.52 45.1%
Total training and support costs $6,771.52 45.1% $6,771.52 45.1%
Grantmaking and sponsorship
Fiscal sponsorships $89.40 0.1% $17,129.86 13.7% Disbursements of grant funds administered under the WikiConference North America fiscal sponsorship agreements.
Guided sponsorships $0.00 0.0% $0.00 0.0%
Total grantmaking and sponsorship costs $89.40 0.1% $17,129.86 11.4%
Total program costs $23,201.42 9.8% $74,402.42 31.5%  
Administrative costs
Finance
Accounting software $150.00 25% $450.00 75% QuickBooks Online subscription.
Payroll service $135.00 25.0% $441.00 81.7% Gusto payroll service.
Transaction fees $24.27 6.1% $59.04 14.8% PayPal fees.
Total finance costs $309.27 20.1% $950.04 61.7%
Insurance ($219.51) ($219.51) Refund of insurance premium overpayment.
Legal
Filing fees $179.00 27.5% $196.45 30.2%
Total legal costs $179.00 27.5% $196.45 30.2%
Mailing
Mail service $180.00 25.0% $540.00 75.0% Mail delivery service at Cove.
Postage $0.00 0.0% $102.45 41.8%
PO box $136.00 85.0% $136.00 85.0%
Total mailing costs $316.00 28.1% $778.45 69.2%
Meetings
Annual meeting $0.00 0.0% $610.00 110.9%
Board meetings ($50.00) $150.00 33.3% Refund of conference room rental overpayment.
Other meetings $0.00 0.0% $0.00 0.0%
Total meeting costs ($50.00) $760.00 66.1%
Printing and publishing
Marketing materials $0.00 0.0% $98.98 24.7%
Business cards $50.01 14.3% $85.44 24.4%
Total printing and publishing costs $50.01 6.7% $184.42 24.6%
Technology $141.60 11.3% $689.24 55.1%
Travel
Long-distance travel $95.43 $1,913.01
Total travel costs $95.43 $1,913.01
Volunteer development $0.00 0.0% $0.00 0.0%
Total administrative costs $821.80 5.5% $5,252.10 35.1%  
Total expenses $24,023.22 9.6% $79,654.52 31.7%  
Net surplus
Fiscal Quarter Net Surplus Fiscal Year-to-Date Net Surplus
Net operating surplus $1,878.05 $23,669.04  
Other income and expenses
Depreciation $0.00 ($385.31)
Total other income and expenses $0.00 ($385.31)
Net surplus $1,878.05 $23,283.73  

Balance Sheet

The following statement reflects Wikimedia District of Columbia's assets and liabilities as of the end of the fiscal quarter on June 30, 2018.

Assets
Current assets
Unrestricted cash $49,180.39
Restricted cash $58,378.43 Restricted funds associated with the WikiConference North America, Women in Red, and Art+Feminism 2016–17 programs; includes grant funds subject to fiscal sponsorship agreements.
Non-current assets
Fixed assets $1,923.94
Accumulated depreciation ($1,923.94)
Net fixed assets $0.00  
Total assets $107,558.82  
Liabilities and net assets
Net assets
Net accumulated surplus $107,558.82  
Total liabilities and net assets $107,558.82