Financial reports: Difference between revisions

From Wikimedia Foundation Governance Wiki
Content deleted Content added
Daniel Mayer (talk | contribs)
mNo edit summary
{{MovedToCorpSite|about/financial-reports/}}
Tag: Replaced
 
(249 intermediate revisions by 37 users not shown)
Line 1: Line 1:
{{MovedToCorpSite|about/financial-reports/}}
{| align="right"
|-
|{{CurrentAccountBalances}}
|}

__NOEDITSECTION__

==Mid year report==
<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. --[[User:Daniel Mayer|Daniel Mayer]] 03:03, 16 December 2005 (UTC)

==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.

&nbsp;<br />

===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.

&nbsp;<br />

==Useful links==

See
* [[Budget/2005]] for our latest budget, which details where the money will go
* [[meta:Wikimedia servers/hardware orders]] for details of the hardware we ordered after our last fundraising drive.

==Archives==
*[[/Archives 2005]]
*[[/Archives 2004]]

{{Category:Finance report}}

Latest revision as of 17:23, 19 September 2018