ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook contains formulas so please follow the directions.
2
First you will have to "Make a copy" of this file - to accomplish this click File and then Make a Copy - name your file Budget Template the name of your project
3
4
For your initial grant application
5
1) Complete the Summary tab
6
Only use pink highlighted fields in the summary tab
7
Under Expenses put in your anticipated expenses - note you can change the expense name just by typing over a name provided
8
Under Income list all of your income sources - note you can change the income name just by typing over a name provided
9
2) Your total expenses and total Income should equal the same - you will see the auto calculated total above your input under planned Expenses/Income
10
3) Save your Project Budget with the name of your project and upload to the application
11
4) Keep this template - you will use the same template for your final budget report
12
13
For your Final Report Budget
14
1) Complete Transactions tab
15
Follow the headings and list by date each expense and description
16
Follow the headings and list by date each source of income and description
17
2) Scan your receipts as image files (.jpeg) and "insert" a copy of your receipts/image to the Receipts tab
18
3) Review the sumary page - the spreadsheet will auto populate the Actual Expense and Income
19
4) Submit spreadsheet with your final report - Please rename your spreadsheet Final Budget (and your project name)
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