URA Integrated Budget

	A	B	C
1	Financial and Budget Template Instructions
2	The Google Spreadsheet is accessible online by anyone, and will include the following 8 tabs and spreadsheets:
3
4	Tab	Worksheet Name	Worksheet Description
5	1	READ ME	Outline of financial and budget template instructions.
6	2	Budget (Annual / Program Budget)	Typically, a Program Budget will be created as a separate document, but should be copied and pasted into the primary Finances Spreadsheets when completed and approved.
7	3	Personnel (Paid Contractors and Employees)	This is an on-going tally of people who have received funds from your program. Yearly columns should be broken down. If you don't pay individuals, then you can ignore this and leave it blank.
8	4	Assets	This is an on-going list of existing assets within the organization and the estimated value if sold. The value should be at least $50-$100 before we would go to the effort to sell it. If there are no sellable assets, then you can leave this blank and not worry about it.
9	5	2014 Transactions / Balance Sheet: Income & Expenditures	This is a on-going tabulation of income, expenditures, and transfers, including donations, revenue, anytime that you have money coming in, we have to keep it recorded. Income does not include transfers between accounts, and goes in a different column. Expenditures are any output of funds for any purpose. Many times we make multiple different transaction and balance spreadsheets for different accounts, or different sub programs. This doesn't have to be your primary balance sheet, but it will be the primary reporting and publicly accountable spreadsheet for your program by accounting for all transaction, in multiple accounts including cash, checks, and debit cards.
10	6	Current Assets & Bank Holdings	This is a snap shot of all your programs current assets and cash on hand. This includes bank holdings, as well as cash on hand, or cash at your house. This should be kept updated quarterly, monthly, weekly, even daily, but just do your best to keep it up to date.
11	7	Temporal Budget	The temporal budget, although it is a little extra work, is a great system to keep track of your finances in a more realistic model than a general program/annual budget. The system is very simple, you start with the total money you currently have in the bank, and then budget out the existing and expected expenses into the future.
12	8	Categories	This is a list of accounting categories to be used in tab 2 (Budget), tab 5 (transactions), and tab 7 (temporal budget).
13
14	Financial Tracking Policy
15
16	a.	Summary:
17		Financial tracking is essential for the CLN to integrate finances across a variety of FSP, for legal reporting, public transparency and accountability. Currently, detailed financial accounting is not legally required because we spent less than $75,000 over a three-year period. As we will soon surpass that amount, we need all FSP to get into the process of detailed financial tracking rather than just providing bank statements. Bank statements do not provide a sufficient understanding of financial activities because bank statements are confusing and usually have un-defined labels and unknown/un-traceable expenses.
18	b.	Legal Requirements:
19		Each FSP is required to maintain their Finances & Budget Spreadsheets and responsible for financial accounting, through paid help or a volunteer. Most importantly, FSP must adhere to legal requirements including submitting a program budget, obtaining CLN Board approval before spending money, and keeping the Board informed of any budget changes. Also, the Annual Report must include basic financial reporting including income and expenditures and is essential for the legal reporting of the Umbrella non-profit.
20	c.	Accounting Support:
21		If your FSP knows that it will be difficult to get their finances started, updated spreadsheets, or keep up with on-going financial tracking, you should plan on creating a line item in your budget for financial support. The CLN can assist with internal project finances, but will request compensation beyond the percentage that has already been allocated.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99