Financial reports: Difference between revisions

From Wikimedia Foundation Governance Wiki
Content deleted Content added
Anthere (talk | contribs)
No edit summary
Akl (talk | contribs)
moving to archive
Line 6: Line 6:
==Budget==
==Budget==
*[[What we need the money for]] (update dec 2006)
*[[What we need the money for]] (update dec 2006)

==2005 Q3 report==
<small>''By [[User:Daniel Mayer|Daniel Mayer]]'' - September 2005</small><br>
The [[Fund drives/2005/Q3|third quarter 2005 fund drive]] was held from Friday 19 August to Friday 9 September 2005 (2005.08.19 – 2005.09.09). The primary goal was to raise US$200,000 ([http://finance.yahoo.com/currency?u Yahoo! Currency Converter]) to meet income requirements in the [[budget/2005|third quarter 2005 budget]]. The drive was a success with over $240,000 USD raised.

==Mid year report==
<small>''By [[User:Daniel Mayer|Daniel Mayer]]'' - July 2005</small>
<table x:str border=1 cellpadding=2 cellspacing=0>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt;width:48pt' colspan=6>'''Budget vs Actual analysis for Q1 and Q2'''</td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=2 style='height:13.2pt;mso-ignore:colspan'></td>
<td class=xl25>'''Budget'''</td>
<td class=xl25>'''Actual'''</td>
<td class=xl25>'''Difference'''</td>
<td class=xl25>'''Breakdown'''</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>fixed asset</td>
<td class=xl24>Hardware</td>
<td class=xl30 align=right x:num="150000" x:fmla="=SUM('Q1'!C4+'Q2'!C3)">$150,000.00
</td>
<td class=xl30 align=right x:num="92482.71" x:fmla="=SUM('Q1'!D4+'Q2'!D3)">$92,482.71
</td>
<td class=xl28 align=right x:num="-57517.29" x:fmla="=SUM(C3-D3)*(-1)">-$57,517.29</td>
<td width=400px>Colo ($92,143.37) and Office
($339.34)</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Hosting</td>
<td class=xl30 align=right x:num="32000" x:fmla="=SUM('Q1'!C5+'Q2'!C4)">$32,000.00
</td>
<td class=xl30 align=right x:num="32246.99" x:fmla="=SUM('Q1'!D5+'Q2'!D4)">$32,246.99
</td>
<td class=xl28 align=right x:num="246.9900000000016" x:fmla="=SUM(C4-D4)*(-1)">$246.99</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24 x:str="Travel ">Travel<span style='mso-spacerun:yes'> </span></td>
<td class=xl30 align=right x:num="10000" x:fmla="=SUM('Q1'!C6+'Q2'!C5)">$10,000.00
</td>
<td class=xl30 align=right x:num="16536.81" x:fmla="=SUM('Q1'!D6+'Q2'!D5)">$16,536.81
</td>
<td class=xl28 align=right x:num="6536.81" x:fmla="=SUM(C5-D5)*(-1)">$6,536.81</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Domain names</td>
<td class=xl30 align=right x:num="1000" x:fmla="=SUM('Q1'!C7+'Q2'!C6)">$1,000.00
</td>
<td class=xl30 align=right x:num="1899.99" x:fmla="=SUM('Q1'!D7+'Q2'!D6)">$1,899.99
</td>
<td class=xl28 align=right x:num="899.99" x:fmla="=SUM(C6-D6)*(-1)">$899.99</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Office expenses</td>
<td class=xl30 align=right x:num="5000" x:fmla="=SUM('Q1'!C8+'Q2'!C7)">$5,000.00
</td>
<td class=xl30 align=right x:num="3902.94" x:fmla="=SUM('Q1'!D8+'Q2'!D7)">$3,902.94
</td>
<td class=xl28 align=right x:num="-1097.06" x:fmla="=SUM(C7-D7)*(-1)">-$1,097.06</td>
<td colspan=6 style='mso-ignore:colspan'>shipping ($285.41), supplies
($985.58), rent ($2631.95)</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Miscellaneous</td>
<td class=xl30 align=right x:num="2000" x:fmla="=SUM('Q1'!C9+'Q2'!C8)">$2,000.00
</td>
<td class=xl30 align=right x:num="1692.2" x:fmla="=SUM('Q1'!D9+'Q2'!D8)">$1,692.20
</td>
<td class=xl28 align=right x:num="-307.8" x:fmla="=SUM(C8-D8)*(-1)">-$307.80</td>
<td colspan=6 style='mso-ignore:colspan'>bank fees ($83.71), Corp/Legal
($598), CC fees ($1010.49)</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Developer contract</td>
<td class=xl30 align=right x:num="16000" x:fmla="=SUM('Q1'!C10+'Q2'!C9)">$16,000.00
</td>
<td class=xl30 align=right x:num="15000" x:fmla="=SUM('Q1'!D10+'Q2'!D9)">$15,000.00
</td>
<td class=xl28 align=right x:num="-1000" x:fmla="=SUM(C9-D9)*(-1)">-$1,000.00</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Hardware assistant</td>
<td class=xl30 align=right x:num="3000" x:fmla="=SUM('Q1'!C12+'Q2'!C10)">$3,000.00
</td>
<td class=xl30 align=right x:num="1930" x:fmla="=SUM('Q1'!D12+'Q2'!D10)">$1,930.00
</td>
<td class=xl28 align=right x:num="-1070" x:fmla="=SUM(C10-D10)*(-1)">-$1,070.00</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24>Promo/Fundraising</td>
<td class=xl30 align=right x:num="1000" x:fmla="=SUM('Q1'!C11+'Q2'!C11)">$1,000.00
</td>
<td class=xl30 align=right x:num="10254.43" x:fmla="=SUM('Q1'!D11+'Q2'!D11)">$10,254.43
</td>
<td class=xl28 align=right x:num="9254.43" x:fmla="=SUM(C11-D11)*(-1)">$9,254.43</td>
<td colspan=6 style='mso-ignore:colspan'>Promo/WikiReaders ($4019.07) and
PayPal fees ($6235.36)</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'></td>
<td class=xl29>TOTAL</td>
<td class=xl34 align=right x:num="220000" x:fmla="=SUM(C3:C11)">$220,000.00 </td>
<td class=xl34 align=right x:num="175946.07" x:fmla="=SUM(D3:D11)">$175,946.07
</td>
<td class=xl28 align=right x:num="-44053.93" x:fmla="=SUM(C12-D12)*(-1)">-$44,053.93</td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'></td>
<td class=xl29></td>
<td colspan=2 class=xl34 style='mso-ignore:colspan'></td>
<td class=xl28></td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'>expense</td>
<td class=xl24 colspan=2 style='mso-ignore:colspan'>Depreciation (non-cash
item)</td>
<td class=xl30 align=right x:num="48068.28">$48,068.28 </td>
<td class=xl28></td>
<td colspan=6 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=11 style='height:13.2pt;mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=2 style='height:13.2pt;mso-ignore:colspan'></td>
<td class=xl25>'''Total Expense'''<span style='display:none'>:</span></td>
<td class=xl35 align=right x:num="131531.64" x:fmla="=SUM(D4:D11,D14)">'''$131,531.64'''
</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=2 style='height:13.2pt;mso-ignore:colspan'></td>
<td class=xl25></td>
<td class=xl35></td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'></td>
<td class=xl29>'''Income'''</td>
<td colspan=9 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'></td>
<td class=xl24>Wikimania tickets</td>
<td></td>
<td class=xl37 align=right x:num="6320.95" x:fmla="=SUM('Q2'!D18)">6,320.95</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td colspan=2 style='mso-ignore:colspan'>CafePress Commissions</td>
<td class=xl37 align=right x:num="1717.8" x:fmla="=SUM('Q1'!D16+'Q2'!D19)">1,717.80</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td>Credit Card Service</td>
<td></td>
<td class=xl37 align=right x:num x:fmla="=SUM('Q2'!D20)">1.00</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td colspan=2 style='mso-ignore:colspan'>MoneyBookers Donations</td>
<td class=xl37 align=right x:num="1115.75" x:fmla="=SUM('Q1'!D18+'Q2'!D21)">1,115.75</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td>Other Donations</td>
<td></td>
<td class=xl37 align=right x:num="122378.66" x:fmla="=SUM('Q1'!D19+'Q2'!D22)">122,378.66</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td>PayPal Donations</td>
<td></td>
<td class=xl37 align=right x:num="120695.96" x:fmla="=SUM('Q1'!D20+'Q2'!D23)">120,695.96</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td colspan=2 style='mso-ignore:colspan'>Foreign Exchange Gain</td>
<td class=xl37 align=right x:num="-2582.76" x:fmla="=SUM('Q1'!D21+'Q2'!D24)">-2,582.76</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 style='height:13.2pt'></td>
<td>Interest Income</td>
<td></td>
<td class=xl37 align=right x:num x:fmla="=SUM('Q1'!D22+'Q2'!D25)">115.04</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'></td>
<td class=xl29>TOTAL</td>
<td class=xl32></td>
<td class=xl38 align=right x:num="249762.4" x:fmla="=SUM(D19:D26)">249,762.40</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=11 style='height:13.2pt;mso-ignore:colspan'></td>
</tr>
<tr height=18 style='height:13.2pt'>
<td height=18 colspan=2 style='height:13.2pt;mso-ignore:colspan'></td>
<td class=xl25>'''Net Income:'''</td>
<td class=xl36 align=right x:num="118230.76" x:fmla="=SUM(D27-D16)">'''$118,230.76'''</td>
<td colspan=7 style='mso-ignore:colspan'></td>
</tr>
<tr height=0 style='display:none'>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>

;Notes
*PayPal fees are in fact a fundraising expense and have therefore been added to that area. They were not considered as such when the Q1 and Q2 budgets were drafted (see [[Budget/2005]]). The travel item was larger than expected mostly due to [http://wikimania.wikimedia.org Wikimania 2005]. We simply should have budgeted more for travel that quarter. Our accountant calculated depreciation costs on our fixed assets (mostly computer equipment) and foreign exchange gain. Depreciation expenses do not affect cash flow and are thus not budgeted for. Their only purpose is to show a decrease in the value of our fixed assets.

== 2005 Q2 report ==

=== Announcements ===
'''[[Fundraising]] drive begins'''<br />
The Wikimedia Foundation and all its [[our projects|projects]] are growing at a rate faster than we ever dreamed. To meet our [[Budget/2005|needs for this quarter]] alone, the [[Wikimedia needs your help|Wikimedia Foundation needs your help]] to raise $200,000 in our first fundraising drive in six months. See [[Fund drives/2005/Q3]] for feedback. <small>([[User:Angela|Angela Beesley]])</small>

'''[[Budget/2005|Budget]] for the third quarter of 2005 released for public scrutiny'''<br>
Daniel Mayer published the last approved budget on 14th of august. The total amount of the budget is $198,000.00, 63% of this amount being dedicated to [[m:server|hardware]]. The next main expenditures are planned for hosting costs (8%), and a financial reserve (10%). The Chief Technical Officer will now be employed full time, and the board is looking for a Hardware assistant as well as an Executive assistant. <small>([[user:Anthere|Anthere]])</small>

== 2005 Q1 report ==

=== General report ===

<small>''By [[User:Daniel Mayer|Daniel Mayer]]'' - April 2005</small>
[[Image:Credit-cards.jpg|150px|right|Credit cards]]
The first fund drive of 2005 was held from Friday, February 18, 2005, to Tuesday, March 1, 2005.<br />
Our goal was to raise 75,000 USD to meet the immediate expenses in our 2005 budget. Originally, the fund drive was planned to run for three full weeks; however, we soon exceeded the original goal, and cut the fund drive short by 9 days. When all sources of donations were counted, we had surpassed the goal by 26%, raising the equivalent of 94,648.70 USD. A full breakdown of contributions by source is available; a quick overview:
*76.44% (72,352.01 USD) from PayPal
*21.18% (15,254.66 Euros | 20,046.15 USD) from Wikimedia Deutschland.
*1.22% (1,155.00 USD) from snail mail/post
*1.16% (1,095.54 USD) from MoneyBookers

Last December, the Lounsbery Foundation granted the Foundation 40,000 USD for hardware expenses in the first quarter of 2005. This grant, added to the money generated in the drive, allowed the foundation to purchase up to 75,000 USD worth of hardware.

20,000 USD were set aside for additional hardware and/or to pay for development projects. This is also the first quarter where the full cost of hosting is being charged to the foundation; 16,000 USD was allocated for this. The extra 20,000 USD over the fundraiser goal was put into a reserve fund.

The foundation now has two employees: a part-time hardware assistant and one full-time developer under contract. The 8,000 USD for the developer is being provided by official mirror contracts. The 1,500 USD for the hardware assistant has been allocated from the budget.

Other budgeted items: 5,000 USD for travel, 500 USD for domain names, 2,500 USD for office expenses, 500 USD for fundraising and promotion, and 1,000 USD for miscellaneous expenses.

Wikimedia Deutschland was the only chapter with its own financial report to issue; for details, see Chapters, page 5.

=== 501(c)(3) status granted to Wikimedia Foundation ===

{| align="right" cellspacing="5px" div style="float:right; width:120px; border:1px; border-style:solid; padding:2px; margin-left:5px; text-align:center; font-size:smaller"
| [[Image:501(c)3 Letter.png|120 px|center|501(c)3 form of Wikimedia Foundation Inc]]
|}

After many months of waiting, the Wikimedia Foundation has been officially classified as a public charity and granted 501(c)(3) (tax exempt) status by the [[w:U.S. Internal Revenue Service|IRS]]. [[Fundraising|Donations]] to the Foundation are now tax deductible in the United States. The Foundation is now qualified to receive tax deductible bequests, devises, transfers, or gifts. The effective date of the exemption is June 20, 2003 (the date on which the Foundation was created), and the status is fully retroactive. If you have donated to the Foundation in the past, those donations may be claimed as tax deductions.


== Useful links ==
== Useful links ==

Revision as of 13:48, 20 February 2007

Audited financial statements

Audited financial statements of the Wikimedia Foundation, Inc. for fiscal years ending June 30, 2004, 2005 and 2006 inclusive are available. The firm Gregory Sharer & Stuart (http://www.gsscpa.com) worked on those documents.

Budget

Useful links

Archives