ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS:
2
NOTE: If you have more than one bank account, you MUST complete two separate
3
Year End Receipts and Expenditure reports; one for each bank account.
4
Complete the tab that says "Yr End Receipts Expenditures." Enter your beginning balance per your reconciled check book balance. You should have reconciled your check book balances every month with your bank statements to ensure your ending balance at June 30, 202X is accurate. Then enter all your receipts collected during the entire fiscal year for the line items listed on the spreadsheet. Then enter all the expenses paid during the entire fiscal year for the line items listed on the spreadsheet. NOTE: The spreadsheet has formulas. There is a sample report (tab highlighted in maroon) that you can reference to help you complete the Year End Receipts and Expenditures report. Please email the completed spreadsheet to treasurer@nccualumni.org.
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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