ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
2
3
A. You have 3 main sheets to fill: Uptodate_Expenses&Revenues, Next3Months_Expenses&Revenues and LongTerm_Expenses&Revenues
4
B. Statement of Activities and Statement of Financial Position will be automatically filled, except for information regarding the previous year of activities.
5
C. If this is NOT your first year of operation, please fill the Yellow Cells in the Statement of Financial Position, which refer to the previous year of activities. Don't fill those cells if this is your first year of operation.
6
D. Uptodate_Expenses&Revenues is the only mandatory sheet to fill. It refers to your activities in the past year up until the closing date of accounting, normally the latest 06/30 or 12/31.
7
E. Next3Months_Expenses&Revenues and LongTerm_Expenses&Revenues are optional. Only fill them if you have an estimate of your upcoming activities.
8
9
1. Fill the Uptodate_Expenses&Revenues sheet.
10
1.a Debits (Expenses) should be negative and Credits (Revenues) should be positive
11
1.b Please indicate the category of each Expense/Revenue
12
1.c Categories are defined in the Statement_of_Activities sheet.
13
1.d If you want to add new categories, feel free to rename the New Categories 1-8 to any new category relevant for your activities.
14
1.d.i After changing the Category Name, the new category should be available on all Expense and Revenues: Uptodate, Next3Months and LongTerm
15
1.e. You can see an example on the sheet EXAMPLE_Uptodate_Expenses&Reven
16
17
2. Fill the Next3Months_Expenses&Revenues and LongTerm_Expenses&Revenues sheets. (OPTIONAL: only fill these parts if you have estimates for future expenses or revenues)
18
2.a. This process is identical to filling the Uptodate_Expenses&Revenues sheet, but with estimated revenues and expenses that will come in the future.
19
2.a. Next3Months represents activites happening in the next 3 months after the closing date of accounting.
20
2.b. LongTerm represents activites happening beyond the next 3 months after the closing date of accounting.
21
2.c if the result of Next3Months_Expenses&Revenues is positive, it will show up as Contributions Receivable - Next 3 months (Short Term), under Current Assets
22
2.d if the result of Next3Months_Expenses&Revenues is negative, it will show up as Short term Accounts payable (Next 3 months), under Current Liabilities
23
2.e if the result of LongTerm_Expenses&Revenues is positive, it will show up as Contributions Receivable - Long term (4 months and beyond), under Non-Current Assets
24
2.f if the result of LongTerm_Expenses&Revenues is negative, it will show up as Long term Notes Payable (4 months and beyond), under Non-Current Liabilities
25
26
3. Fill the Statement of Financial Position with the results of your previous year, if this is NOT your first year of operation.
27
3.1 Copy information from the Statement of Financial Position of the previoues year.
28
3.2 Leave blank all cells for which you don't have information.
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