Copy of IC-Business-Budget-Template_Google-sheet

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC
1	BUSINESS BUDGET TEMPLATE																	https://www.smartsheet.com/try-it?trp=11332&utm_source=integrated+content&utm_campaign=/content/monthly-budget-template-google-sheets&utm_medium=Business+Budget+google+sheets+11332&lpa=Business+Budget+google+sheets+11332&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w							https://goo.gl/FKCFQ0
2		JANUARY		FEBRUARY		MARCH		APRIL		MAY		JUNE		JULY		AUGUST		SEPTEMBER		OCTOBER		NOVEMBER		DECEMBER		YEAR END
3	SUMMARY	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	UNDER / OVER
4	Total Income	$50,000	$77,000	$0	$0	$0	$0	$58,000	$63,000	$0	$0	$235,000	$300,000	$82,000	$100,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$425,000	$540,000	$115,000
5	Total Expenses	$2,500	$5,500	$0	$0	$346,000	$321,000	$0	$0	$12,500	$12,500	$0	$0	$0	$0	$4,600	$3,800	$0	$0	$0	$0	$0	$0	$0	$0	$365,600	$342,800	$22,800
6		$47,500	$71,500	$0	$0	-$346,000	-$321,000	$58,000	$63,000	-$12,500	-$12,500	$235,000	$300,000	$82,000	$100,000	-$4,600	-$3,800	$0	$0	$0	$0	$0	$0	$0	$0	$59,400	$197,200	$92,200
7
8		JANUARY		FEBRUARY		MARCH		APRIL		MAY		JUNE		JULY		AUGUST		SEPTEMBER		OCTOBER		NOVEMBER		DECEMBER		YEAR END
9	INCOME	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	UNDER / OVER
10	OPERATING INCOME
11	Category 1	$50,000	$77,000																							$50,000	$77,000	$27,000
12	Category 2							$58,000	$63,000																	$58,000	$63,000	$5,000
13	Category 3													$82,000	$100,000											$82,000	$100,000	$18,000
14	Category 4																									$0	$0	$0
15	Category 5											$235,000	$300,000													$235,000	$300,000	$65,000
16	Category 6																									$0	$0	$0
17	Category 7																									$0	$0	$0
18	TOTAL	$50,000	$77,000	$0	$0	$0	$0	$58,000	$63,000	$0	$0	$235,000	$300,000	$82,000	$100,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$425,000	$540,000	$115,000
19
20		JANUARY		FEBRUARY		MARCH		APRIL		MAY		JUNE		JULY		AUGUST		SEPTEMBER		OCTOBER		NOVEMBER		DECEMBER		YEAR END
21	EXPENSES	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	BUDGET	ACTUAL	UNDER / OVER
22	OPERATING EXPENSE
23	Accounting & Legal	$2,500	$5,500																							$2,500	$5,500	-$3,000
24	Advertising																									$0	$0	$0
25	Depreciation																									$0	$0	$0
26	Dues & Subscriptions																									$0	$0	$0
27	Insurance																									$0	$0	$0
28	Interest Expense																									$0	$0	$0
29	Maintenance/ Improvements																									$0	$0	$0
30	Taxes & Licenses																									$0	$0	$0
31	Telephone																									$0	$0	$0
32	Travel																									$0	$0	$0
33	Web																									$0	$0	$0
34		$2,500	$5,500	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$2,500	$5,500	-$3,000
35	PAYROLL
36	Payroll Expenses					$346,000	$321,000																			$346,000	$321,000	$25,000
37	Salaries & Wages																									$0	$0	$0
38	Contractor Wages																									$0	$0	$0
39		$0	$0	$0	$0	$346,000	$321,000	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$346,000	$321,000	$25,000
40	OFFICE
41	Overhead									$12,500	$12,500															$12,500	$12,500	$0
42	Utilities															$4,600	$3,800									$4,600	$3,800	$800
43	Office Supplies																									$0	$0	$0
44		$0	$0	$0	$0	$0	$0	$0	$0	$12,500	$12,500	$0	$0	$0	$0	$4,600	$3,800	$0	$0	$0	$0	$0	$0	$0	$0	$17,100	$16,300	$800
45	TOTAL	$2,500	$5,500	$0	$0	$346,000	$321,000	$0	$0	$12,500	$12,500	$0	$0	$0	$0	$4,600	$3,800	$0	$0	$0	$0	$0	$0	$0	$0	$365,600	$342,800	$22,800
46
47	CLICK HERE TO CREATE IN SMARTSHEET
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