Date:
21/08/2017
Quorn Grange Hotel
Page:
2
Time:
10:20:02
Profit and Loss (Monthly Breakdown)
From:
Month 1, January 2017
To:
Month 7, July 2017
Chart of Accounts:
Detailed Layout of Accounts
Jan
Feb
Mar
Apr
May
Jun
Jul
Totals
Direct Expenses
Operating Gross
Wages
35,898.31
40,693.40
39,062.11
37,872.22 41,526.52 37,224.06 40,394.51 272,671.13
Operating Employer
Pension
503.65
591.50
558.45
540.55
629.69
582.00
551.28 3,957.12
Admin Gross Wages
17,034.70
16,959.63
16,042.26
17,029.58 16,994.25 17,084.44 17,084.44 118,229.30
Admin Employers
Pension
268.06
268.06
307.67
267.34
271.11
269.29
269.29 1,920.82
55,970.49 58,512.59 53,704.72 55,709.69 59,421.57 55,159.79 58,299.52 396,778.37
Gross
Profit/(Loss)
(3,966.94) 13,705.85 15,734.44 49,115.17 43,224.61 51,494.89 64,211.55 233,519.57
Overheads
Bar & Restaurant
Consumables
190.85
93.10
202.10
573.92
169.74
781.95
367.44 2,379.10
Cleaning & Laundry
4,414.60
4,300.82
4,199.42
4,805.30 4,865.65 6,276.47 5,453.88 34,316.14
Events
0.00
0.00
0.00
487.33
0.00
780.00 7,640.29 8,907.62
Marketing
3,435.40
2,257.50
2,116.00
1,074.00 1,877.00 3,183.41 2,534.00 16,477.31
Recruitment
Advertising
0.00
0.00
0.00
0.00
0.00
0.00
132.00
132.00
IT Expenses
747.46
1,259.95
984.94
931.96
924.46 5,284.53 5,285.49 15,418.79
Printing & Stationery
1,032.52
391.50
378.72
286.52
223.90
511.06 2,130.29 4,954.51
Postage
103.87
24.82
10.95
57.43
66.92
42.72
87.98
394.69
Garden Expenditure
3,545.71
226.80
553.76
2,534.19 2,402.49 2,680.83
175.97 12,119.75
Gym Expenditure
62.56
63.79
86.86
188.49
12.52
123.83
135.87
673.92
Repairs &
Maintenance
2,329.82
1,302.82
902.87
2,264.71 1,928.26 1,731.55 2,877.66 13,337.69




