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
The development expenses in 2014, $299, is that the book campaign?
regards, Johan
On 17-7-2014 8:09, Bryce Harrington wrote:
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.34This 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.81This 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 Inkscape-board@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-board
On Sat, Jul 19, 2014 at 04:45:16PM +0200, Johan Engelen wrote:
The development expenses in 2014, $299, is that the book campaign?
Yes, here is the breakdown:
14-Feb-18 Martin Owens - Amaz.. Ex:Inkscap:Development $23.20 $23.20 14-Feb-21 Kris De Gussem - Am.. Ex:Inkscap:Development $33.70 $56.90 14-Feb-18 Nicolas Dufour - Am.. Ex:Inkscap:Development $33.70 $90.60 14-Feb-19 Alvin Penner - Amaz.. Ex:Inkscap:Development $42.84 $133.44 14-Feb-20 Krzysztof Kosinski .. Ex:Inkscap:Development $33.70 $167.14 14-Feb-19 Alexander Valavanis.. Ex:Inkscap:Development $42.84 $209.98 14-Feb-19 Matthew Petroff - A.. Ex:Inkscap:Development $23.20 $233.18 14-Feb-19 Markus Engel - Amaz.. Ex:Inkscap:Development $23.20 $256.38 14-Feb-19 Tavmjong Bah - Amaz.. Ex:Inkscap:Development $42.84 $299.22
regards, Johan
On 17-7-2014 8:09, Bryce Harrington wrote:
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.34This 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.81This 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 Inkscape-board@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-board
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 Inkscape-board@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/inkscape-board
On Sat, 2014-07-19 at 13:44 -0700, Bryce Harrington wrote:
On Sat, Jul 19, 2014 at 04:45:16PM +0200, Johan Engelen wrote:
The development expenses in 2014, $299, is that the book campaign?
Yes, here is the breakdown:
14-Feb-18 Martin Owens - Amaz.. Ex:Inkscap:Development $23.20 $23.20 14-Feb-21 Kris De Gussem - Am.. Ex:Inkscap:Development $33.70 $56.90 14-Feb-18 Nicolas Dufour - Am.. Ex:Inkscap:Development $33.70 $90.60 14-Feb-19 Alvin Penner - Amaz.. Ex:Inkscap:Development $42.84 $133.44 14-Feb-20 Krzysztof Kosinski .. Ex:Inkscap:Development $33.70 $167.14 14-Feb-19 Alexander Valavanis.. Ex:Inkscap:Development $42.84 $209.98 14-Feb-19 Matthew Petroff - A.. Ex:Inkscap:Development $23.20 $233.18 14-Feb-19 Markus Engel - Amaz.. Ex:Inkscap:Development $23.20 $256.38 14-Feb-19 Tavmjong Bah - Amaz.. Ex:Inkscap:Development $42.84 $299.22
regards, Johan
I assume the $67.48 in postage for 2014 was mostly for the books.
Thanks, Bryce, for putting the report together.
Tav
On Wed, Jul 23, 2014 at 01:56:36PM +0200, Tavmjong Bah wrote:
On Sat, 2014-07-19 at 13:44 -0700, Bryce Harrington wrote:
On Sat, Jul 19, 2014 at 04:45:16PM +0200, Johan Engelen wrote:
The development expenses in 2014, $299, is that the book campaign?
Yes, here is the breakdown:
14-Feb-18 Martin Owens - Amaz.. Ex:Inkscap:Development $23.20 $23.20 14-Feb-21 Kris De Gussem - Am.. Ex:Inkscap:Development $33.70 $56.90 14-Feb-18 Nicolas Dufour - Am.. Ex:Inkscap:Development $33.70 $90.60 14-Feb-19 Alvin Penner - Amaz.. Ex:Inkscap:Development $42.84 $133.44 14-Feb-20 Krzysztof Kosinski .. Ex:Inkscap:Development $33.70 $167.14 14-Feb-19 Alexander Valavanis.. Ex:Inkscap:Development $42.84 $209.98 14-Feb-19 Matthew Petroff - A.. Ex:Inkscap:Development $23.20 $233.18 14-Feb-19 Markus Engel - Amaz.. Ex:Inkscap:Development $23.20 $256.38 14-Feb-19 Tavmjong Bah - Amaz.. Ex:Inkscap:Development $42.84 $299.22
regards, Johan
I assume the $67.48 in postage for 2014 was mostly for the books.
I'm sure it was entirely for the books. :-)
Bryce
participants (4)
-
Bryce Harrington -
Johan Engelen -
Martin Owens -
Tavmjong Bah