OSE Financial Transparency: Difference between revisions

From Open Source Ecology
Jump to navigation Jump to search
Line 11: Line 11:
*Taxes - $25
*Taxes - $25


=Introduction=
The Annual Budget Report is a summary of the actual spending and revenue of OSE, verified with bank account statements.
Use the template below as an example.
=2014=
Annual Report Infographic Base:
<html><iframe width="600" height="371" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/pubchart?oid=1270640998&amp;format=image"></iframe>
<iframe width="595" height="341" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/pubchart?oid=888971&amp;format=image"></iframe></html>
<html><iframe src="https://docs.google.com/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/pubhtml?widget=true&amp;headers=false" width="1200" height="450"></iframe></html>
[https://docs.google.com/a/opensourceecology.org/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/edit#gid=0 edit]
=Protocol for 2014=
It took 2 hr 40 min to set up spreadsheet template and fill it out from bank statements, minus the infographic below.
#Download all statements from Bank of America.
#Fill out Column I and P in above spreadsheet for the Monthly Revenue and Spending using the cover page of monthly BofA statement
#Look through revenue - should have a quick breakdown of donations, speaker fees, workshop revenues, etc. Use other for refunds or unfamiliar entries.
#Look through details of spending to detect overhead costs (quick scan for utilities, phone, internet, water electricity, insurance, web hosting, domain registrations, etc).
#To balance revenue, use a formula in column H to subtract total revenue from known revenues
#To balance costs, use a formula in column J to make Prototyping + Infrastructure any spending that is not salary, travel, fuel, or overhead.
#Look at Eventbrite and total the workshops revenue + spring break revenue
#Look at PayPal to determine the total money received in first and last month, and average that to derive an annual revenue


=2013 - Income & Expenditures=
=2013 - Income & Expenditures=

Revision as of 23:42, 4 September 2015

2015 Overhead Expenses

Monthly: $1070

  • Electricity - $180 per month
  • Fuel - $200
  • Water - $80
  • Internet - $220
  • Phone - $120
  • Web hosting + acceleration - $120
  • Insurance - $58
  • Auto insurance - $67
  • Taxes - $25

Introduction

The Annual Budget Report is a summary of the actual spending and revenue of OSE, verified with bank account statements.

Use the template below as an example.

2014

Annual Report Infographic Base:

edit

Protocol for 2014

It took 2 hr 40 min to set up spreadsheet template and fill it out from bank statements, minus the infographic below.

  1. Download all statements from Bank of America.
  2. Fill out Column I and P in above spreadsheet for the Monthly Revenue and Spending using the cover page of monthly BofA statement
  3. Look through revenue - should have a quick breakdown of donations, speaker fees, workshop revenues, etc. Use other for refunds or unfamiliar entries.
  4. Look through details of spending to detect overhead costs (quick scan for utilities, phone, internet, water electricity, insurance, web hosting, domain registrations, etc).
  5. To balance revenue, use a formula in column H to subtract total revenue from known revenues
  6. To balance costs, use a formula in column J to make Prototyping + Infrastructure any spending that is not salary, travel, fuel, or overhead.
  7. Look at Eventbrite and total the workshops revenue + spring break revenue
  8. Look at PayPal to determine the total money received in first and last month, and average that to derive an annual revenue

2013 - Income & Expenditures

See Form 990 for 2013 - [1] From Form 990:

  • Total Revenue: $354k
  • Total Expenses: $402k
  • Total Assets at beginning of year: $262k
  • Total Assets at end of year: $214k

Note: OSE has received its of Tax Exempt status from the IRS on September 27, 2013. We are also exempt from state sales tax.

Download OSE's 2013 Profit and Loss Statement - OSEPL2013.pdf

2012 - Income & Expenditures

See Form 990 Filing - [2]

EDIT

2012 - Global Village Construction Set Budget

2012 Financial Statements

See Financial Statements

2011 - Expenditures Graph

  • GVCS Machines - includes only materials
  • GVCS Machines - outsourced design work
  • GVCS Machines - outsourced labor
  • Construction - materials
  • Construction - labor
  • Infrastructure - energy, water, utilities, internet, phone
  • Admin

2011 - Income & Expenditures

EDIT

Receipts & Checks

Fiscal Sponsor in 2011-2012

Terra Foundation 501(c)(3)

Retrieved from "https://wiki.opensourceecology.org/index.php?title=OSE_Financial_Transparency&oldid=130890"