Daily Test

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Daily Test as PDF for free.

More details

  • Words: 2,847
  • Pages: 65
511301 100-Room revenue

3566.4

20080809

C

511302 106-Room Service Charges

153.11

20080809

C

333101 107-Room VAT

321.2

20080809

C

511301 108Room revenue-(M)

25.97

20080809

C

511302 111Room Service Charges (M)

1.29

20080809

C

333101 112Room VAT (M)

2.74

20080809

C

12.12

20080809

C

511304 205-Spice restaurant BF SVC

0.61

20080809

C

333101 206-Spice restaurant BF VAT

1.27

20080809

C

378.87

20080809

C

511304 208Spice Pkg BF SC

18.98

20080809

C

333101 209Spice Pkg BF Tax

40.15

20080809

C

511303 230-Spice Rest LCH Food

101.8

20080809

C

511305 231-Spice Rest LCH Bev

19.04

20080809

C

511307 232-Spice Rest LCH Misc

1.73

20080809

C

511303 234-Spice Rest LCH Disc

9.62

20080809

D

511304 235-Spice Rest LCH SVC

5.64

20080809

C

333101 236-Spice Rest LCH VAT

11.86

20080809

C

511303 260-Spice Rest DNR Food

887.18

20080809

C

511305 261-Spice Rest DNR Bev

397.35

20080809

C

511304 265-Spice Rest DNR SVC

64.23

20080809

C

333101 266-Spice Rest DNR VAT

134.89

20080809

C

511303 290-Cuu Long Bar Food

166.32

20080809

C

511305 291-Cuu Long Bar Bev

325.26

20080809

C

511304 295-Cuu Long Bar SVC Food

24.57

20080809

C

333101 296-Cuu Long Bar VAT

51.66

20080809

C

180.07

20080809

C

9

20080809

C

333801 364An Nam Spa VAT

18.91

20080809

C

511307 400Mini Bar

33.33

20080809

C

511308 401Mini Bar SVC Charges

1.66

20080809

C

333101 402Mini Bar VAT

3.51

20080809

C

511332 500Lady Hau Food

98.7

20080809

C

511333 505Lady Hau SVC

4.94

20080809

C

511303 200-Spice Restaurant BF Food

511303 207-Spice Rest Pkg BF-Split

511314 358An Nam Spa 511315 363An Nam Spa SVC Chrg

10.37

20080809

C

511330 551-Gift Shop Goods Others

20.9

20080809

C

333101 553-Gift Shop VAT

2.09

20080809

C

511316 646Transport rebate

127

20080809

D

511317 647Transport SVC Rebate

6.35

20080809

D

333101 648Transport VAT Rebate

13.34

20080809

D

511318 660Excursion

45.02

20080809

C

511319 661Excursion SVC Charges

2.25

20080809

C

333101 662Excursion VAT

4.73

20080809

C

333101 506Lady Hau VAT

43

57

3586.5 27.26 0 3415.72 170.79 4071.55 485.05 3586.5 3415.72 170.79 358.65 48.51 407.16 461.95

Room Revenue Restaurant Revenue Cuu long Bar Revenue Massage Revenue Minibar revenue Hau Revenue Shop Revenue Laundry Revenue Car Revenue Sight Seeing revenue Telephone revenue BCenter revenue Banquet revenue Other income

Total Revenue :

3613.76 0 0 145.44 34.99 103.64 20.9 0 -133.35 47.27 0 0 0 0

3832.65 3613.76 1548.74 416.39 190.89 325.26

G:\FIDELIO\FO_DATA\sun\REV080809 08 09

11

#REF!

#REF!

09

08

402 a

b

0 45 0 90 0 100 0 110 0 115 0 132.83 0 146.7 0 155 0 181.34 0 184.8 0 205

0

X X X X X X X X X X X

67 c

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

45 Total 45 90 Total 1260 100 Total 400 110 Total 1210 115 Total 230 132.83 Total 132.83 146.7 Total 293.4 155 Total 155 181.34 Total 362.68 184.8 Total 184.8 205 Total 205

0 0 0 0 0 0 0 0 0 0 0

40

Grand Total 4478.71

0

06

LEFT(EE14,(LEN(EE14)-5)) 4 1

486

81

10,489.93 9,082.19

161 557.06 8525.13 426.26 8951.39 9,130.79

1

179.4

G:\FIDELIO\FO_DATA\sun\REV070809 08 09

Revenue

ROOM SALES 100 106 EXTRA CHARGES (ROOM OTHER)102 0 Adjust : + / TOTAL ROOM REVENUE F & B REVENUE 260 262 SPICE RESTAURANT REVENUE 410 412 -FOOD SALES 200 202 -BEVERAGE SALES 201 211 CUU LONG BAR REVENUE 411 421 -FOOD SALES 290 0 -BEVERAGE SALES 291 297 BANQUET - CONFERENCE ROOM -FOOD 440 442 -BEVERAGE 441 451 BAKERY TOTAL FOOD REVENUE TOTAL BEVERAGE REVENUE F & B OTHER ( Inc. Minibar ) 400 401 Adjust : + / TOTAL F & B REVENUE OTHERS REVENUE TELEPHONE 610 611 LAUNDRY 622 623 SHOP 550 551 MASSAGE & SAUNA 358 361 BUSINESS CENTER - CONFERENCE 630RM 631

108 111 0 0

415 205 231 0 295 301

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

254 414 204 221 431 294 311

420 422 425 0 0 0 0 0 0 0 0 0 0 0 0 0 0 207 210 212 215 230 232 234 235 237 240 242 245 265 267 270 272 275 241 271 261 0 0 0 0 0 0 0 0 0 0 0 0 0 0 298 300 302 305 0 0 0 0

Rebate 110 0 0

445 450 452 455 0 0 0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

444 461

403 404 292

0

0

0

0

0

0

0

0

0

0

0

0

0

0

406

615 616 617 0 0 0 556 557 562 366 368 369 635 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

619 625 554 359 637

612 0 552 363 632

613 0 555 365 633

0

SIGHTSEEING TOUR 660 661 666 0 0 0 0 0 0 SWIMMING POOL SPORT FACILITIES 600 601 602 0 0 0 0 0 0 CAR RENTAL 640 641 642 643 0 0 0 0 0 LADY HAU 500 501 502 505 510 511 512 514 522 OTHERS INCOMES 650 651 0 0 0 0 0 0 0 Adjust : + / TOTAL OTHERS REVENUE GRAND TOTAL HOTEL REVENUE Adjust : + / NET TOTAL REVENUE ROOM STATISTICS ROOM OF HOTEL ROOM SOLD ROOM COMPLIMENTARY ROOM HOUSE USE - Hotel staff ROOM HOUSE USE - Others ROOM OUT OF ORDER ROOM AVAILABLE ROOM VACANT NUMBER OF GUESTS % OF OCCUPANCY Without Co. room % OF OCCUPANCY W / Co. Room AVERAGE ROOM RATE Without Co. room AVERAGE ROOM RATE Inclu / Co. room

0

0

0

0

0

0

0

0

0

0

0

663

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

606 646 504 655

Rebate 116 0

255 424 214 251 0 304 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

430 432 434 435 0 0 0 0 0 0 0 0 0 220 222 224 225 244 250 252 264 274 280 282 284 285 281 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 310 312 314 315 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

454 460 462 464 465 0 0 0 0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

407

0

0

0

0

0

0

0

0

0

0

0

0

0

0 0 0 0 626 0 0 0 559 560 0 0 371 372 374 376 638 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

0 0 0 0 0

664

0

0

0

0

0

0

0

0

0

0

0

0

0

607 608 0 0 647 0 0 0 516 517 518 520 656 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

0 0 0 0

G:\FIDELIO\FO_DATA\sun\REV080216 Room Others Room Service Charges Room VAT Room revenue-(M) Room revenue rebate Room Service Charges (M) Room VAT (M) Room SVC rebate Room VAT rebate Spice Restaurant BF Food Spice Restaurant BF Bev Spice restaurant BF Misc Spice restaurant BF Tips Spice restauran BBF Disc Spice restaurant BF SVC Spice restaurant BF VAT Spice Rest Pkg BF-Split Spice Rest BF Food (M) Spice Rest BF Bev (M) Spice Rest BF Misc (M) Spice Rest BF Tips (M) Spice Rest BF Disc (M) Spice Rest BF SVC (M) Spice Rest BF VAT (M) Spice Rest BF Food Rebate Spice Rest BF Bev Rebate Spice Rest BF Misc Rebate Spice Rest BF Tips Rebate Spice Rest BF Disc Rebate Spice BF Svc Rebate Spice Rest BF Vat Rebate Spice Rest LCH Food Spice Rest LCH Bev Spice Rest LCH Misc Spice Rest LCH Tips Spice Rest LCH Disc Spice Rest LCH SVC Spice Rest LCH VAT Spice Rest LCH Split Spice Rest LCH Food (M) Spice Rest LCH Bev (M) Spice Rest LCH Misc (M) Spice Rest LCH Tips (M) Spice Rest LCH Disc (M) Spice Rest LCH SVC (M) Spice Rest LCH VAT (M) Spice Res LCH Food Rebate Spice Rest LCH Bev Rebate Spice Res LCH Misc Rebate Spice Res LCH Tips Rebate Spice Res LCH Disc Rebate

02

16 102 106 107 108 110 111 112 116 117 200 201 202 203 204 205 206 207 210 211 212 213 214 215 216 220 221 222 223 224 225 226 230 231 232 233 234 235 236 237 240 241 242 243 244 245 246 250 251 252 253 254

Spice Rest LCH Svc Rebate Spice Rest LCH Tax Rebate Spice Rest DNR Food Spice Rest DNR Bev Spice Rest DNR Misc Spice Rest DNR Tips Spice Rest DNR Disc Spice Rest DNR SVC Spice Rest DNR VAT Spice Rest DNR Split Spice Rest DNR Food (M) Spice Rest DNR Bev (M) Spice Rest DNR Misc (M) Spice Rest DNR Tips (M) Spice Rest DNR Disc (M) Spice Rest DNR SVC (M) Spice Rest DNR VAT (M) Spice Res DNR Food Rebate Spice Rest DNR Bev Rebate Spice Res DNR Misc Rebate Spice Res DNR Tips Rebate Spice Res DNR Disc Rebate Spice Rest DNR Svc Rebate Spice Rest DNR Tax Rebate Cuu Long Bar Food Cuu Long Bar Bev Cuu Long Bar Misc Cuu Long Bar Tips Cuu Long Bar Disc Cuu Long Bar SVC Food Cuu Long Bar VAT Cuu Long Bar SVC Bev Cuu Long Bar SVC Misc Cuu Long Bar Food (M) Cuu Long Bar Bev (M) Cuu Long Bar Misc (M) Cuu Long Bar Tips (M) Cuu Long Bar Disc (M) Cuu Long Bar SVC (M) Cuu Long Bar VAT (M) Cuu Long Bar Food Rebate Cuu Long Bar Bev Rebate Cuu Long Bar Misc Reb Cuu Long Bar Tips Rebate Cuu Long Bar Disc Rebate Cuu Long Bar Svc Reb Cuu Long Bar Tax Reb An Nam Spa An Nam Spa Disc An Nam Spa 30% S.TAX An Nam Spa Misc An Nam Spa Tips

255 256 260 261 262 263 265 266 267 270 271 272 273 274 275 276 280 281 282 283 284 285 286 290 291 292 293 294 295 296 297 298 300 301 302 303 304 305 306 310 311 312 313 314 315 316 358 359 360 361 362 363

An Nam Spa SVC Chrg An Nam Spa VAT An Nam Massage PKG Spli An Nam Spa Massage (M) An Nam Spa Tips (M) An Nam Spa Misc (M) An Nam Spa Svc Chrge (M) An Nam Spa VAT (M) An Nam Spa Massgae Rebat An Nam Spa Misc Rebate An Nam Spa Tips Rebate An Nam Spa Svc Rebate An Nam Spa Tax Rebate An Nam Disc Rebate Mini Bar Mini Bar SVC Charges Mini Bar VAT Mini Bar (M) Mini Bar SVC (M) Mini Bar Tax (M) Mini Bar Tax (M) Mini Bar-Rebate Mini Bar SVC Rebate Room Service Food Room Service Beverage Room Service Misc Room Service Tip Room Service Disc Room Service Disc Room Service SVC Room Service Tax Room Service Food (M) Room Service Beverage (M) Room Service Misc (M) Room Service Tip (M) Room Service Disc (M) Room Service Disc (M) Room Service SVC (M) Room Service Tax (M) Room Service Food Rebate Room Service Beve Rebate Room Service Beve Rebate Room Service Misc Rebate Room Service Tip Rebate Room Service Disc -Rebate Room Service Disc -Rebate Room Service SVC Rebate Room Service Tax Rebate Banquet Food Banquet Beverage Banquet Misc Banquet Tip

364 365 366 367 368 369 370 371 372 373 374 375 376 400 401 402 403 404 405 405 406 407 410 411 412 413 414 414 415 416 420 421 422 423 424 424 425 426 430 431 431 432 433 434 434 435 436 440 441 442 443 444

Banquet Disc Banquet Disc Banquet SVC Banquet Tax Banquet Food (M) Banquet Beverage (M) Banquet Misc(M) Banquet Tip(M) Banquet Disc (M) Banquet Disc (M) Banquet SVC(M) Banquet Tax (M) Banquet Food-Rebate Banquet Beverage-Rebate Banquet Misc-Rebate Banquet Tip -Rebate Banquet Disc -Rebate Banquet Disc -Rebate Banquet SVC-Rebate Banquet Tax - Rebate Lady Hau Food Lady Hau Beverage Lady Hau Misc Lady Hau Tip Lady Hau Disc Lady Hau Disc Lady Hau SVC Lady Hau VAT Lady Hau Food (M) Lady Hau Bev (M) Lady Hau Misc (M) Lady Hau Tips (M) Lady Hau SVC Charge (M) Lady Hau VAT (M) Lady Hau Food Rebate Lady Hau Bev Rebate Lady Hau Misc Rebate Lady Hau Tips Rebate Lady Hau SVC Rebate Lady Hau TAX Rebate Lady Hau Pack-Split Gift Shop Goods Gift Shop Goods Others Gift Shop SVC Gift Shop VAT Gift Shop Disc Gift Shop Goods (M) Gift Shop Other Goods (M) Gift Shop SVC (M) Gift Shop VAT (M) Gift Shop Rebate Gift Shop SVC Rebate

444 445 446 450 451 452 453 454 454 455 456 460 461 462 463 464 464 465 466 500 501 502 503 504 504 505 506 510 511 512 513 514 515 516 517 518 519 520 521 522 550 551 552 553 554 555 556 557 558 559 560 561

Gift Shop VAT Rebate Gift Shop Pack-Split Sports & Recreation Food Sports & Recreation Bev Sports & Recreation Misc Sports & Recreation Tips Sports & Rec Food Rebate Sports & Rec Bev Rebate Sports & Rec Misc Rebate Sports & Rec Tips Rebate Telephone-Local Telephone-NDD Telephone-IDD Fax Cable/Telex Telephone Taxes Telephone local (M) Telephone-NDD (M) Telephone-IDD (M) Telephone VAT (M) Telephone-Rebate Telephone VAT Rebate Laundry Laundry SVC Charge Laundry VAT Laundry-Rebate Lanudry SVC Charge Rebate Laundry VAT Rebate Business Centre Services Office/Meeting Room Conference & B.Centre Office/MR-Others B.C/Off/Conf SVC Chrg B.C/Off/Conf VAT B/CTR Off/Conf Rebate B.C/Off/Conf SVC Rebate B.C/Off/Conf VAT Rebate Transport Hotel Car Transport Taxi Transport Boat Transport SVC Charges Transport VAT Transport rebate Transport SVC Rebate Transport VAT Rebate Misc Charge Misc SVC Charges Misc VAT Misc.rebate Misc SVC Rebate Misc VAT Rebate Excursion Excursion SVC Charges

562 600 601 602 603 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 622 623 624 625 626 627 630 631 632 633 635 636 637 638 639 640 641 642 643 644 646 647 648 650 651 652 655 656 657 660 661 662

Excursion VAT Excursion rebate Excursion SVC Rebate Excursion VAT Rebate Excursion PKG Split Deposit Retain Package Profit Package Lost Balance Forward Debit Balance Forward Credit Paid Out Refund Deposit Refund deposit Transfer Balance Exchange Rate Difference Cash (USD) Cheque City Ledger Deposit TransferforI/C American Express Visa Card Master Card Diners Club JCB Card F&B-Cash USD$ F&B-Amex F&B-Visa F&B-Master F&B-Diners F&B-JCB F/B City Ledger F/B VND Cash (USD) A/R Bank Transfer(USD) A/R Bank Charge(USD) FOC or House use A/R-Bank Transfer(VND) A/R Cheque A/R:Bank Charge(VND) A/R VND (USD) CASH A/R:Credit Card Comm VND-US Cash EURO DOLLAR Japanese Yen VND-US Cash On Folio T/C - US Dollars Cash Short & Over Hotel Cashier Deposit Payments

663 664 665 666 684 747 757 798 799 800 830 878 880 900 901 903 904 906 907 908 909 910 920 921 922 923 924 925 926 927 928 929 930 940 941 942 943 945 950 951 956 959 962 990 209 264 208

Ngay : Ca Sang : Ca Chieu : Nghi phep: 8,15,17,18/07/2008

1

2

3

4

S4h

S4h

S4h

S4h

C4h

C4h

C4h

C4h

5

733180 6 S4h C4h

7 S4h

8 S4h

9 S4h

10

11

11.5

14.5

S4h

C4h

12

13

14

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

S4h

S4h

S4h

S4h

C4h

C4h

C4h

C4h

Related Documents

Daily Test
November 2019 8
Daily Test
November 2019 15
Daily Test 301007
November 2019 8
Daily Test 1
November 2019 11
Daily Test Iii
May 2020 4
Daily Test Biology
May 2020 7