ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to use this template
2
3
• Fill in ONLY the yellow cells on the Budget Template sheet. Blue rows contain formulas and will update automatically.
4
5
• Columns:
- Current Org. Budget: Your board-approved/current working budget for this fiscal year.
- Current YTD Actuals: Actual results to date for this fiscal year.
- Previous FY Budget: Your approved budget from the last completed fiscal year.
- Previous FY Actuals: Actual results from the last completed fiscal year.
6
7
8
9
10
• Cash vs. In-Kind: Enter in-kind revenue/expenses separately from cash. Totals will combine cash and in-kind automatically.
11
12
13
• Production & Event Costs subtotal will auto-sum its sub-lines (Equipment, Stage, Sound, Security, T-shirts). Leave any sub-lines you don't use as blank.
14
15
16
• Surplus/(Deficit) is calculated as TOTAL Operating Revenue minus TOTAL Operating Expenses.
17
18
19
• Tip for reviewers: You can quickly scan totals and year-over-year trends across the four main columns. Header row is frozen; formulas are locked to prevent edits.
20
21
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
100