Revision as of 07:50, 19 January 2015

Introduction

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

Use this template as an example:

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.

@@ Line 5: / Line 5: @@
 <html><iframe src="https://docs.google.com/spreadsheets/d/1lVvq36LiF8SSIzGh3hFwOHIv3IVxA7KKhwBgrN-xAec/pubhtml?widget=true&amp;headers=false" width="960" height="569"></iframe></html>
+=Protocol=
+#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.