26-27 / 99
Date:
21/08/2017
Quorn Grange Hotel
Page:
1
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
Sales
Food & Beverages
24,294.95
18,779.84
19,738.87
32,537.80 38,018.57 31,014.25 31,924.46 196,308.74
Miscellaneous Sales
432.51
504.39
252.62
584.03
525.73 1,001.49
431.05 3,731.82
Accomodation
48,868.89
51,358.77
40,579.07
52,478.92 57,778.40 59,065.38 57,313.27 367,442.70
Conferences
3,785.87
6,284.03
4,510.12
3,793.46 3,173.99 3,519.76 4,913.12 29,980.35
Weddings
2,957.08
6,444.71
0.00
35,320.27 21,291.82 28,572.49 49,876.59 144,462.96
Hotel Events
91.67
116.66
0.00
0.00
0.00
0.00
0.00
208.33
Breakfast Sales
3,025.84
2,703.75
2,530.67
3,565.41 3,926.25 5,462.92 5,306.04 26,520.88
Nursery Fees
0.00
0.00
0.00
0.00
0.00
0.00
617.53
617.53
Nursery Meals
2,356.07
1,630.00
1,548.75
2,092.59 3,187.52 1,711.00 1,764.83 14,290.76
Gym Membership
519.96
399.30
515.76
320.35
528.29
332.79
411.88 3,028.33
Bank Interest
1.16
4.24
4.60
3.07
3.09
3.13
3.64
22.93
Kurdish Event
0.00
0.00
0.00
0.00
0.00
0.00 3,200.10 3,200.10
69,680.46 88,225.69 86,334.00 130,695.90 128,433.66 130,683.21 155,762.51 789,815.43
Purchases
Food & Beverages
Purchases
14,082.47
14,297.21
13,763.23
21,773.77 23,188.89 26,044.77 28,705.11 141,855.45
Miscellaneous
Purchases
167.10
0.00
180.40
0.00
868.50
20.83
275.30 1,512.13
Function Purchases
1,245.00
295.30
3,215.33
2,002.58 2,111.00 1,278.00 3,248.00 13,395.21
Hotel Room
Consumables
704.66
603.28
179.51
715.28
473.98
892.06
920.72 4,489.49
Movement in Stock
695.61
811.46
338.44
1,379.41 (854.89) (4,207.13)
102.31 (1,734.79)
17,676.91 16
,007.25 16,894.84
25,871.04 25,787.48 24,028.53 33,251.44 159,517.49