Annual Budget Report: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 10: | Line 10: | ||
=Protocol= | =Protocol= | ||
It took 2 hr 40 min to set up spreadsheet template and fill it out from bank statements. | 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. | #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 | #Fill out Column I and P in above spreadsheet for the Monthly Revenue and Spending using the cover page of monthly BofA statement | ||
| Line 19: | Line 20: | ||
#Look at Eventbrite and total the workshops revenue + spring break revenue | #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 | #Look at PayPal to determine the total money received in first and last month, and average that to derive an annual revenue | ||
Annual Report Infographic Base: | |||
<html></html> | |||
Revision as of 21:21, 19 January 2015
Introduction
The Annual Budget Report is a summary of the actual spending and revenue of OSE, verified with bank account statements.
Use this template as an example:
Protocol
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
Annual Report Infographic Base: