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