Hi all,
I thought you guys might find this data informative. I recently got
access to our CLI Ledger data, and sorted out how to generate reports to
get a sense of our project's funding and expenses.
== CURRENT BALANCE ==
$-17,538.31 Expenses:Inkscape
$47,887.65 Income:Inkscape
--------------------
$30,349.34
This first table provides a high level view of our total money received
and paid since we joined the conservancy. We've spent a little over a
third of the money we've collected.
== ASSETS ==
$31,595.96 Assets
$344.62 FR Checking
$3,600.00 FR Visa Check Card
$-12.00 Gandi Prepaid Account
$4,704.51 Google Checkout
$15,667.38 Inkscape:FR Money Market
$7,291.45 PayPal
$-368.15 Liabilities:Credit Card:AMEX
--------------------
$31,227.81
This shows where all of our current money "lives". I don't know why the
total here differs from the current balance.
== TOTALS ==
Year Income Expenses
2006 $3,126.00 $3126.00
2007 $6,955.81 $-4,718.00 $2237.81
2008 $3,861.14 $-460.98 $3400.16
2009 $2,798.57 $-500.00 $2298.57
2010 $3,915.37 $-1,821.20 $2094.17
2011 $8,489.61 $-1,060.80 $7428.81
2012 $6,919.27 $-3,130.18 $3789.09
2013 $7,664.94 $-1,955.27 $5709.67
2014 $3,674.37 $-3,889.74 $-215.37
This shows our yearly income and expenses, and the year to year delta.
It looks like we could sustain an annual budget of about $7k.
Income 2006 2007 2008 2009
2010
Donations 3126.00 6955.81 3854.00 2746.48
3898.20
Google 0.00 6000.00 0.00 0.00
0.00
Packt 0.00 0.00 0.00 0.00
0.00
Interest 0.00 0.00 7.14 52.09
17.17
Royalties 0.00 0.00 0.00 0.00
0.00
Currency Conversion 0.00 0.00 0.00 0.00
0.00
Other Income 0.00 0.00 0.00 0.00
0.00
Expenses
Hosting 0.00 0.00 0.00 0.00
0.00
OSU 0.00 -200.00 0.00 0.00
0.00
Banking Fees 0.00 -18.00 0.00 0.00
-75.00
Postage 0.00 0.00 0.00 0.00
0.00
Travel 0.00 -500.00 -460.98 0.00
-316.20
Per Diem 0.00 0.00 0.00 0.00
0.00
Mentor Stipend 0.00 -4000.00 0.00 -500.00
-1430.00
Development 0.00 0.00 0.00 0.00
0.00
Currency Conversion 0.00 0.00 0.00 0.00
0.00
Other Expenses 0.00 0.00 0.00 0.00
0.00
Income 2011 2012 2013 2014
Donations 7361.50 6404.88 7326.41 3673.70
Google 0.00 0.00 0.00 0.00
Packt 497.00 500.00 0.00 0.00
Interest 10.14 2.48 3.95 0.67
Royalties 1117.97 491.15 334.34 0.00
Currency Conversion 0.00 20.74 -111.24 0.00
Other Income 0.00 0.00 0.00 0.00
Expenses
Hosting -12.00 0.00 0.00 0.00
OSU 0.00 0.00 0.00 0.00
Banking Fees -48.80 -111.81 210.34 -151.38
Postage 0.00 0.00 0.00 -67.48
Travel 0.00 518.35 1556.88 3370.21
Per Diem 0.00 0.00 -38.28 274.71
Mentor Stipend -1000.00 -2500.00 0.00 0.00
Development 0.00 0.00 0.00 -299.22
Currency Conversion 0.00 20.74 -111.24 0.00
Other Expenses 0.00 0.00 0.00 -1.45
This table shows a more detailed breakdown of where our income came from
and where it went to, on a year by year basis. I'm not sure why the
travel expenses show as positive in 2012-2015; I'll enquire. Meanwhile
if you have any other questions let me know and I'll pass them along.
Bryce
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Inkscape-board mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/inkscape-board
