OSE Financial Transparency: Difference between revisions

From Open Source Ecology
Jump to navigation Jump to search
No edit summary
No edit summary
 
(43 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Hint|The most current filings can be found at [[OSE Form 990]]}}
=Introduction=
=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=
*990 Extension Form - [[Form 8868]]
==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&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=
See Form 990 for 2013 - [http://990s.foundationcenter.org/990_pdf_archive/454/454997514/454997514_201312_990.pdf]
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 - [http://990s.foundationcenter.org/990_pdf_archive/454/454997514/454997514_201212_990EZ.pdf]
<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>
[https://docs.google.com/spreadsheet/ccc?key=0Aj7WbjRT9mlmdE80MDR3S0gzV1ZEdUI0OHI0OVkxSEE#gid=5 EDIT]


This page documents all charitable contributions received through the nonprofit side of Open Source Ecology, as well as any donations where the donor has explicitly requested that allocation should be reported.  
==2012 - Global Village Construction Set Budget==
*[http://opensourceecology.org/w/images/f/f6/Open_Source_Ecology_-_Global_Village_Construction_Set_Budget_-_2012.pdf Global Village Construction Set - Budget Estimate ''(2012)'']
*[https://docs.google.com/spreadsheet/ccc?key=0Aj7WbjRT9mlmdG5RQ3BIYmxrWnpqX0VSNkl2Z0JBZ1E#gid=2 Global Village Construction Set - Budget Estimate ''(2012)'' - Rationale]
==2012 Financial Statements ==
See [[Financial Statements]]


[[Terra Foundation]], a 501(c)(3) corporation organized in San Luis Obispo, California, USA, is acting as the fiscal sponsor for Open Source Ecology (OSE). OSE is thus able to process tax-deductible contributions from USA donors.
=2011 - Expenditures Graph=


See also [[Terra Foundation Income and Balance Sheet]]
*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


=Log=
<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>


*Viveik Saigal - August 9, 2011 - $8k. Allocated to materials for 4 [[Power Cube]]s and one [[CEB Press]], all to be used in the construction of [[OSE Shop 2011]] and [[Hybrid_CEB-Straw_Superinsulated_Housing_Plans]].
==2011 - Income & Expenditures==
*Anonymous, Turkey - September 12, 2011 - Allocated to Sweiger Shop for steel and build of the first [[Dimensional Sawmill]] prototype, two [[Soil Pulverizer]]s with buckets, and steel for outstanding components of LifeTracs and CEB presses -  part of emergency crowd funding recovery plan - $10k
[https://docs.google.com/spreadsheet/ccc?key=0Aj7WbjRT9mlmdGRQU3lCZXpLRG11ZDJ1VmQwUGhqNGc#gid=1 EDIT]
*Seattle Foundation - Wittmann Cardinal Fund - October 5, 2011 - $1k
<html>
**Nov. 11 - $20 Terra Foundation fee taken out


==September Balance Sheet==
<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>


*''Anonymous - Sep. 28, 1011 - $60k''
</html>
**Sep. 29, 2011 -Excavation and bulldozing, Workshop and HabLab, Duffy Reynolds Construction - $4k


==October Balance Sheet==
==Receipts & Checks==
**Oct. 3, 2011 - Construction rebar, Sweiger - $3968.60
:*[http://opensourceecology.org/wiki/File:Receipts2011.tar.gz September - December 27, 2011]
**Oct. 3, 2011 - LifeTrac bucket prototype 1, Sweiger - $828
**Oct. 3, 2011 - LifeTrac tracks chain for 3 tractors - $1046.97
**Oct. 3, 2011 - metal, hydraulic coolers, welding supplies, 2 generators - $2786.39
**Oct. 4, 2011 - foundation pads concrete, Payless Concrete - $821.28
**Oct. 6, 2011 - HabLab step edge excavation correction - $437.50
**Oct. 8, 2011 - 2 soil pulverizer Prototype 3s complete minus motors, bearings, and chain - $4006.18
**Oct. 10, 2011 - mowing (280), raking (140), baling (220), 20 acres, for insulation - $640.00
**Oct. 13, 2011 - 30" and 13"sawblades for Dimensional Sawmill prototype I, teeth, wrench - $1062.95
**Oct. 14, 2011 - additional gravel for HabLab, 17 tons, Apac - $254.79
**Oct. 14, 2011 - 9 + 6 cu yds concrete pour for HabLab walls, kitchen, bathroom, Payless Concrete - $1910.43
**Oct. 14, 2011 - lumber for HabLab roof and framing - $2742.03
**Oct. 14, 2011 - foundation form lumber, HabLab - $218.03
**Oct. 14, 2011 - roof tiedown threaded rod and nuts, MoKan Fastener - $67.22
**Oct. 14, 2011 - 5 hard hats - $52.18
**Oct. 14, 2011 - PowerCube muffler studs and nuts - $57.54
**'''Total Anonymous spending as of OCt 14 - ''$24,900.09'''''
**Oct. 17 - water pump fittings - $11.85
**Oct. 24 - Bobcat conversion plate, Sweiger - $684.15
**Oct. 17 - LifeTrac fuel - $64.50
**Oct. 23 - Bobcat rental, month - $1690.00
**Oct. 24 - Brick rollers, 60', Sweiger - $2296.90
**Oct. 24 - Concrete supplies - $319.98
**Oct. 24 - Torching and welding gas - $327.75
**Oct. 24 - Bobcat fittings, thicker LifeTrac couplers, rebar tiedowns - $905.07
**Oct. 25 - cement, lime, table saw, Tyvek from Menards - $1045.63
**'''Total spending to Oct. 25 - $32,245.32'''
**Oct. 27 - Jerry Hackett, brick laying - $140
**Oct. 27 - Gene Hood, brick laying - $105
**Oct. 28 - Regal plastic, glazing for HabLab and workshop - $4945.88
**Oct. 31 - Skid Steer rental, RSC, John Deere 80 hp - $2400.58
**Oct. 31 - Scaffolding, month rental - $457.95


==November Balance Sheet==
==Fiscal Sponsor in 2011-2012 ==
**Nov. 2 - Jim Roberts workshop slab preparation - $1142.00
**Nov. 2 - Harbor Freight, CEB construction and masonry supply - $184.91
**Nov. 3 - Penney's Conrete - $1988.32
**Nov. 3 - Jim Roberts, workshop slab, 2700 sf - $600
**Nov. 4 - John Robinson, 100 pallets - $250
**Nov. 4 - Penney's Concrete - $3976.64
**Nov. 4 - Jim Roberts, workshop slab completion, 4032 square feet, with fracture cuts - $992
**'''Total spending to Nov. 4 - $49,428.60'''
*Nov. 15 - Vanguard Charitable Endowment, Miles and G Elizabeth Lasater Fund - $5000
**Nov. 11 - $100 Terra Foundation fee taken out
**Nov. 11 - $1200 Terra Foundation fee taken out
**Nov.  11 - reject lime - $178.87, donor-advised account name:
**Nov. 11 - cement mixer prototype I, Bobcat conversion plate for LifeTrac, Forks - $4342.78
**Nov. 15 - brick pressing labor, 8 hours - $80
**Nov. 15 - 1" gravel and reject lime - $461.47
**Nov. 15 - CEB pressing - Floyd Hagerman with his machine, 2000 bricks produced - $550
**Nov. 16 - 4.5 hours brick pressing labor - $45
**Nov. 17 - 8 hours brick pressing labor - $80
**Nov. 18 - 5 hours brick pressing labor - $50
**Nov. 18 - 100 pallets - check# 7550 - $250
**Nov. 20 - carpentry and brick pressing crew, Floyd Hagerman - check 7551 - $1691
**Nov. 21 - reject lime - $186.41
**Nov. 21 - 5.5 hours brick pressing labor - $57
*'''Running balance, Nov. 24, 2011 - $7476.54'''
**Nov. 25 - 6.5 hours brick pressing - Ronny check #7554 - $65
**Nov. 26 - Menards - Plywood - 20 sheets of 1/2" - $362.20
**Nov. 26 - Floyd Hagerman construction management, carpentry plus brick pressing crew - ck 7556 - $2045.50
**Nov. 28 - Prairie Metal Sales - HabLab roofing metal down payment - $925


==December Balance Sheet==
[http://terrafoundation.org/ Terra Foundation] 501(c)(3)
**Dec. 2 - 5 hours roof work on workshop - ck 7558 - $50
:*[http://opensourceecology.org/w/images/6/6a/Open_Source_Ecology_-_Terra_Foundation_-_IRS_Determination_Letter.pdf IRS Determination Letter]
**Dec. 2 - Floyd Hagerman week of construction management - carpentry, workshop - $1696.18
:*[http://opensourceecology.org/w/images/7/71/Open_Source_Ecology_-_Terra_Foundation_-_Financials_-_2011.pdf Form 990-N (2011)]
**Dec. 4 - Menards - Shop heater - ck 7560 - $309.10
:*EIN #: 77-0298872
**Dec. 13 - Ronny- 8 hours brick laying - $80
:*Fiscal Sponsorship Fee: 2%
**Dec. 27 - Scaffolding rental - $255.83


[[Category:Transparency]]
=Links=
[[Category:Logs]]
*[[Ops]] Infographic
*[[Admin Assistant]]
*[[Taxes]]
*[[Financial_Management]]

Latest revision as of 23:04, 13 May 2022


Error creating thumbnail: File missing
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:

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)

Links

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