Financial Data Reporting   -  Daily Report   pg. 1 of 2
Summary of Revenue, Charges
& Accounts Receivable
Today
M-T-D
L-M-T-D
B-M-T-D
Credit Card Billings Today
 Room Revenue
4,420.87
50,791.08
25,576.54
119,225.81
  Issuer Rooms F&B
 Allowance - Rm Rev.
102.83
1,350.83
428.30
  
 AMEX
332.87 
188.37 
 Rollaways
133.90
1,689.51
850.35
2,322.58
 DC / CB
115.58 
93.67 
 No Show Revenue
125.50
1,427.71
833.48
1,896.77
 MC
557.68 
694.23 
 Phone - Long Dist.
82.49
806.90
365.90
619.35
 Visa
723.88 
489.32 
 Phones - Local
51.30
366.49
188.58
425.81
 JCB
28.45 
16.35 
 In Room Movies
238.50
2,810.98
1,498.78
7,432.26
 Discover
364.28 
0.00 
 SubTotal - Rooms division
4,949.73
56,541.84
28,885.33
131,922.58
 Credit Total
2,122.74 
1,481.94 
 State Occupancy Tax
93.41
1,066.10
  
   Accounts Receivable  
 County Occupancy Tax
27.30
277.41
 
 City Ledger
12,731.71 
 City Occupancy Tax
3.88
59.22
 
 Guest Ledger
3,995.23 
 State Sales Tax
1.98
34.78
 
 Adv. Deposits
3,953.55 
 City Sales Tax
0.00
5.24
 
 Total
20,680.49 
 SubTotal - Taxes
126.57
1,442.75
Maid Minute
 Commissions - Vending
88.90
779.43
  
Today
M-T-D
B-M-T-D
 Commissions - Phone
50.22
507.58
Rooms Sold
112
1,271
1,463
 High Speed Internet
104.50
1,570.45
Minute Maids
3,450
39,339
44,903
 Copies
62.80
465.76
M M / Rm Sold
31
31
31
 Fax
31.40
290.86
Comp Rooms
Name
Description
Room #
 Guest Laundry
56.70
643.56
 Mtg Room
95.00
1,065.70
 
 
 
 In Room Safe
40.50
376.65
   
 
 Miscellaneous
28.77
401.35
   
 
 Breakfast Charge
56.70
545.18
   
 
 Pet Fee
40.00
369.50
   
 
 Subtotal - Other Income
655.49
7,040.37
 
 
 
 Total Rooms & Misc.
5,731.79
65,014.96
 
 Restaurant Breakfast
330.20
3,006.81
1,340.60
610.06
 
 Restaurant Lunch
455.22
4,439.30
2,174.61
687.48
 
 Restaurant Dinner
58.32
5,450.86
2,976.26
447.48
 
 Banquet Food Breakfast
141.95
1,898.87
1,269.07
688.26
Todays Paid Reading
 Banquet Food Lunch
368.29
5,011.76
2,554.66
4,309.16
Rooms
2,354.25
 Banquet Food Dinner
521.88
7,581.79
3,876.56
430.45
F&B
2,182.75
 Room Service - Breakfast
0.00
0.00
0.00
696.00
Credit Cards
3,604.68
 Room Service - Dinner
0.00
0.00
0.00
438.97
   
 Employee Meals    ( not tallied )
34.40
364.98
184.04
695.23
   
 Subtotal - Food
1,875.86
27,389.39
14,191.76
445.16
Total
8,141.68
 Banquet Misc. Rev.
44.58
560.41
268.62
0.00
 
 Banquet Room Rental
115.00
1,197.75
527.75
0.00
 
 Banquet Service Charge
45.00
470.70
185.70
0.00
 
 Food Sales - Other
27.44
448.66
209.47
0.00
(Over) Short Recap
 Banquet Equip. Rental
25.50
437.65
256.10
0.00
Department
Today
M-T-D
 Subtotal - Food Other
257.52
3,115.17
1,447.64
0.00
Rooms 
-0.07
0.25
 Lounge - Liqr Rev
188.20
2,230.45
1,055.08
0.00
F&B 
0.00
-5.06
 Lounge - Beer Rev
273.45
2,659.41
1,167.24
0.00
Cash Dep
-0.07
-4.81
 Lounge - Wine Rev
93.45
1,187.16
531.24
0.00
     
 Restaurant - Bev
195.32
2,718.64
1,234.30
0.00
 
 Banquet Sales - Liquor
170.90
2,665.71
1,418.58
0.00
 
 Banquet Sales - Beer
248.00
3,446.24
1,807.63
0.00
Deposit Reconciliation
 Banquet Sales - Wine
105.33
1,854.14
1,119.04
0.00
Department
Today
M-T-D
 Subtotal - Beverage
1,274.65
16,761.75
8,333.11
0.00
Rooms 
2,354.25
26,898.80
 Lounge - Cover Charge
55.50
852.73
441.10
0.00
F&B 
2,182.75
19,413.23
 Lounge Sales - Other
24.67
496.76
204.50
0.00
Cash Dep
4,537.07
46,316.84
 Subtotal - Beverage Other
80.17
1,349.49
645.60
0.00
Credit Cards
3,604.68
47,205.78
 Promo - Mktg Dept
35.50
465.40
 
 
(Over) Short
-0.07
-4.81
 Promo - Admin & Genrl
41.78
303.17
 
 
     
 Entmnt Coupons / Seniors
20.50
272.00
 
 
Total
8,141.68
93,517.81
 Subtotal - Promo
97.78
1,040.57
 
 
     
 Total F & B Rev.
3,390.42
47,575.23
 
 
     
 Grand Total Rev.
9,122.21
112,590.19
 
 
     
 Less: Paid Readings
8,141.68
93,517.81
 
 
     
 Plus: Yesterday's Balance
19,699.96
0.00
 
 
     
 Today's Reconciliation Balance
20,680.49
19,072.38
         
Elapsed days this month: 24  Total days this month: 31
MTD: 08/01/04 - 08/24/04   LMTD: 08/01/03 - 08/24/03
- 1 -
  Go to page: <1> <2>

 

 

Full Serve Hotel - Denver, CO

 
Financial Data Reporting    -    Daily Report    pg. 2 of 2 < pg 1 >
08/24/04
Henry Ford
Rooms
Today
M-T-D
L-M-T-D
B-M-T-D

City Ledger

 
Today
M-T-D
 Single
 77
 911
 561
1,115
 Balance Forward
12,044.11
0.00
 Multiple
  35
 360
 211
348
 Add: Today's Charges
822.10
13,766.00
Subtotal 
 112
 1271
 772
1,463
 Less: Today's Credits
134.50
1,627.40
    
 Balance Today
12,731.71
12,138.60
 Comp.
 1
 15
 9
   
 0-0-0
 1
 15
 10
   
 Vacant
 7
 274
 179
 

Tax Exempt Sales

 Account Name
Today
M-T-D
Total 
 120
 1560
 960
1,858
 Rooms
92.45
959.17
   
 F&B
88.32
768.81
 # of No-Shows
 3
 48
 28
 
 
  
 
 # of Guests
 145
 1669
 987
   Total
180.77
1,727.98
 # of walk-ins 
 7
 76
 44
   
 

Paid Outs

Description
Payee
Amount
 Avg. Rate
39.47
39.96
33.13
90.16 
 Bal In:
 1,992.34
 Occupancy%
93.33
81.47
80.42
78.75 
 furniture rental   
 Rental Warehouse
 73.25
 REVPAR
36.84
32.56
26.64
64.17 
         
 
 
Restaurants
 Revenue
      
 
 
 Breakfast
330.20
3,006.81
1,340.60
610.06 
   
 
 
 Lunch
455.22
4,439.30
2,174.61
687.48 
   
 
 
 Dinner
58.32
5,450.86
2,976.26
447.48 
   
 
 
 Banquet
1,032.12
14,492.42
7,700.29
5,427.87 
 Bal Out:
 2,065.59
Total 
1,875.86
27,389.39
14,191.76
7,172.90 
  
 Number of Covers

Daily Report Log

Category
Auditor
 Breakfast
36
393
227
60
 Revenue   C. Davis
 Lunch
48
516
304
68
 Credit Cards  C. Davis
 Dinner
61
669
396
77
 Cash Deposits  C. Davis
 Banquet
89
1,101
669
430
 Occupancy Stats  C. Davis
Total
234
2,679
1,596
634
 Maid Minutes  C. Davis

 Average per Cover

 Tax Exempt  C. Davis
 Breakfast
0.00
0.00
0.00
10.00
 Cover Counts  C. Davis
 Lunch
0.00
0.00
0.00
10.00
 Ledger Balance  C. Davis
 Dinner
0.00
0.00
0.00
6.00
 Comp Rooms  
 Banquet
0.00
0.00
0.00
13.00
 Paid Outs  C. Davis
Total 
0.00
0.00
0.00
11.00
 Balance Verification
 C. Davis
Elapsed days this month: 24  Total days this month: 31
MTD: 08/01/04 - 08/24/04   LMTD: 08/01/03 - 08/24/03
- 2 -
  Go to page: <1> <2>