OSE Financial Transparency

From Open Source Ecology
(Redirected from Budget)
Jump to navigation Jump to search


HintLightbulb.png Hint: The most current filings can be found at OSE Form 990


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.

2015 Filing

2015 Overhead Expenses

Monthly Estimate for planning purposes: $1100, or about $13k/year

  • Electricity - $180 per month (during peak workshop season)
  • Fuel - $200
  • Water - $80
  • Internet - $220
  • Phone - $120
  • Web hosting + acceleration - $120
  • Insurance - $58
  • Auto insurance - $67
  • Admin (tax filing) - $23
  • Taxes - $25

2014

Form 990

(filed mid-2015, forthcoming)

Annual Report

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&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&format=image"></iframe></html>

<html><iframe src="https://docs.google.com/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/pubhtml?widget=true&headers=false" width="1200" height="450"></iframe></html>

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]

<html> <iframe width='3000' height='500' frameborder='0' src='https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Aj7WbjRT9mlmdE80MDR3S0gzV1ZEdUI0OHI0OVkxSEE&output=html&widget=true'></iframe> </html> 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

<html> <iframe width='100%' height='500' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Aj7WbjRT9mlmdGRQU3lCZXpLRG11ZDJ1VmQwUGhqNGc&single=true&gid=2&output=html&widget=true'></iframe> </html>

2011 - Income & Expenditures

EDIT <html>

<iframe width='2000' height='2300' frameborder='0' src='https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Aj7WbjRT9mlmdGRQU3lCZXpLRG11ZDJ1VmQwUGhqNGc&single=true&gid=1&output=html&widget=true'></iframe>

</html>

Receipts & Checks

Fiscal Sponsor in 2011-2012

Terra Foundation 501(c)(3)

Links

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