MSC-SMC Financial Report Template.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	MSC-SMC STUDENT CHAPTER BUDGET TEMPLATE FORM - CHAPTER NAME: ______________										TREASURER NAME: _________________
2		YEAR: 20YY-20YX	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	Total
3	Total Income		1,000	0	0	500	0	0	200	0	0	0	0	0	1,700
4	Total Expenses		0	0	200	70	100	0	0	100	0	0	0	0	470
5	NET (Income - Expenses)		1,000	0	-200	430	-100	0	200	-100	0	0	0	0	1,230
6
7			JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	Total
8		INCOME
9	I1	ex: MSC-SMC: Startup Fund	1,000												1,000
10	I2	ex: Sponsorship: Chapter Event Sponsorship				500									500
11	I3	ex: Event: Fundraising							200						200
12	I4														0
13	I5														0
14	I6														0
15	I7														0
16	I8														0
17		Total INCOME	1,000	0	0	500	0	0	200	0	0	0	0	0	1,700
18			JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	Total
19		EXPENSES
20	E1	ex: Communication: Student chapter logo stickers			200										200
21	E2	ex: Event: Catering at event					100								100
22	E3	ex: Communications: Flyers				50									50
23	E4	ex: Communications: Social media advertising				20									20
24	E5	ex: Event: Lodging for guest speaker								100					100
25	E6														0
26	E7														0
27	E8														0
28		Total EXPENSES	0	0	200	70	100	0	0	100	0	0	0	0	470
29
30		Notes:
31	Please be descriptive and use this space to describe income and line expenses in greater detail. For line items, group items into categories as exemplified and re-iterate categories in the summary table. Add more line items to this template as needed. For larger events, use supplementary tab templates to describe the proposed budget in detail.
32
33
34
35
36
37		SUMMARY TABLE
38		Balance reported on SUBMISSION DATE, 20YY
39		EXPENSES FOR YEAR 20YY		INCOME FOR YEAR 20YY
40		ex:Communication		ex: Event registration fees
41		ex: Events		ex: MSC-SMC Financial Support
42		ex: Food/Drinks		ex: Sponsorships
43		ex: Student Contest		ex: Partnerships
44		ex: Other		ex: Other
45		CREATE CATEGORIES AS NEEDED		CREATE CATEGORIES AS NEEDED
46
47		TOTAL EXPENSES	$ -	TOTAL INCOME		$ -
48		Projected balance at year end on DATE, 20YX				$ -
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