IC-Hotel-Profit-and-Loss-Statement-Template_Google-Sheets

	B	C	D	E	F	G	I
1

2	HOTEL PROFIT AND LOSS STATEMENT TEMPLATE						https://www.smartsheet.com/try-it?trp=11286&utm_source=integrated+content&utm_campaign=/content/small-business-profit-loss-templates&utm_medium=Hotel+Profit+and+Loss+Statement+google+sheets+11286&lpa=Hotel+Profit+and+Loss+Statement+google+sheets+11286&lx=PFpZZjisDNTS-Ddigi3MyABAgeTPLDIL8TQRu558b7w
3	PROFIT & LOSS STATEMENT
4					––––– TIME PERIOD REPRESENTED –––––
5	HOTEL NAME				START DATE	END DATE
6					00/00/0000	00/00/0000
7
8	PREPARED BY		DATE	VERIFIED BY		DATE
9			00/00/0000			00/00/0000
10	Complete non-shaded fields, only.
11	INCOME
12	REFERENCE ID.	DESCRIPTION				AMOUNT
13	A1111-4267	Guest Reservations				$ 650,000
14	A1111-4268	Food Purchases				$ 95,000
15	A1111-4269	Events				$ 151,000
16	A1111-4270	Other				$ 48,750
17	INCOME TOTAL					$ 944,750
18	LESS SALES RETURNS / ALLOWANCES ( enter "-" negative amount )					$ (7,562)
19	TOTAL REVENUE					$ 937,188
20
21	EXPENSES
22	REFERENCE ID.	DESCRIPTION				AMOUNT
23	R4444-5345	Utilities				$ 21,500
24	R4444-5346	Maintenance				$ 17,640
25	R4444-5347	Depreciation				$ 29,500
26	R4444-5348	Staff Wages				$ 250,400
27	R4444-5349	Insurance				$ 16,500
28	R4444-5350	Legal Fees				$ 7,800
29	R4444-5351	Advertising				$ 18,500
30	R4444-5352	Supplies				$ 4,750
31	R4444-5353	Other				$ 8,500
32	EXPENSE TOTAL					$ 375,090
33
34	NET INCOME BEFORE TAXES					$ 569,660
35	TAX RATE ( enter % )					9.53%
36	INCOME TAX EXPENSE					$ 54,289
37
38	NET INCOME					$ 515,371
39
40	CLICK HERE TO CREATE IN SMARTSHEET
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