Sample Budget -- CCER
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
SAMPLE ORGANIZATION BUDGET
3
2018-2019 Fiscal Year
4
5
Acct. #Operating revenues2018201820182018
6
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal
7
100Source of revenue #1 (grants)$12,560.00$3,139.20$18,600.00$2,000.00$6,000.00$5,000.00$3,000.00$1,000.00$10,000.00$100.00$20,000.00$500.00$81,899.20
8
101Source of revenue #2 (donations)$3,000.00$3,000.00$3,000.00$3,000.00$3,100.00$3,200.00$3,200.00$3,200.00$3,200.00$3,200.00$3,200.00$3,200.00$37,500.00
9
102Source of revenue #3 (services)$800.00$800.00$800.00$800.00$800.00$800.00$800.00$800.00$900.00$900.00$900.00$900.00$10,000.00
10
11
Total Operating Revenue$16,360.00$6,939.20$22,400.00$5,800.00$9,900.00$9,000.00$7,000.00$5,000.00$14,100.00$4,200.00$24,100.00$4,600.00$129,399.20
12
13
Acct. #Operating expenses2018201820182018
14
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal
15
200Source of expenses #1 (payroll)$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$8,025.05$96,300.60
16
201Source of expenses #2 (rent)$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$2,000.00$24,000.00
17
203Source of expenses #3 (tools)$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$300.00$3,600.00
18
19
Total Operating Expenses$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$10,325.05$123,900.60
20
21
22
Net Revenue (Revenue - Expense)$6,034.95-$3,385.85$12,074.95-$4,525.05-$425.05-$1,325.05-$3,325.05-$5,325.05$3,774.95-$6,125.05$13,774.95-$5,725.05$5,498.60
23
24
25
Quarterly SummaryWinterSpringSummerFallTotal
26
Total Operating Revenue$45,699.20$24,700.00$26,100.00$32,900.00$129,399.20
27
Total Expenses$30,975.15$30,975.15$30,975.15$30,975.15$123,900.60
28
Net Revenue (Cash on Hand)$14,724.05-$6,275.15-$4,875.15$1,924.85$5,498.60
29
30
31
32
HOW TO USE (delete me!)
33
- Make a copy by going to File > Make a copy
- Input your information in the yellow cells
- Grey cells auto calculate
- Add revenue/expense categories as needed. Be sure to update the formulas in the grey cells
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
Loading...