Test Page - This page is for testing purposes only. It is not intended for production use. All Tests

Ledger transactions (folio_transactions)

Reset
460315 rows (page 3056/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
137398 2026-04-10 charge 3104 Spa F&B Gratuity NRV 2.33 reservation #2441 3959 opera:ft:17246062
137397 2026-04-10 charge 3103 Spa Liquor ALC 14.00 reservation #2441 3959 opera:ft:17246061
137396 2026-04-10 charge 3100 Spa Food RST 19.00 reservation #2441 3959 opera:ft:17246060
137395 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #3319 10481 opera:ft:17246059 joan canceled 4.10 2:10pm
137394 2026-04-10 charge 3105 Spa F&B Tax 3.07 reservation #420 1152 opera:ft:17246058
137393 2026-04-10 charge 2136 Spa Pool Service Charge RST 6.60 reservation #420 1152 opera:ft:17246057
137392 2026-04-10 charge 3104 Spa F&B Gratuity NRV 8.00 reservation #420 1152 opera:ft:17246056
137391 2026-04-10 charge 3100 Spa Food RST 33.00 reservation #420 1152 opera:ft:17246055
137390 2026-04-10 payment 9028 F&B Visa CARD -53.02 houseAccount #19 10264 opera:ft:17246054
137389 2026-04-10 charge 2018 Alcohol Sales Tax 1.49 houseAccount #19 10264 opera:ft:17246053
137388 2026-04-10 charge 3105 Spa F&B Tax 2.33 houseAccount #19 10264 opera:ft:17246052
137387 2026-04-10 charge 2136 Spa Pool Service Charge RST 8.20 houseAccount #19 10264 opera:ft:17246051
137386 2026-04-10 charge 3103 Spa Liquor ALC 16.00 houseAccount #19 10264 opera:ft:17246050
137385 2026-04-10 charge 3100 Spa Food RST 25.00 houseAccount #19 10264 opera:ft:17246049
137384 2026-04-10 charge 2018 Alcohol Sales Tax 1.58 reservation #300 998 opera:ft:17246048
137383 2026-04-10 charge 3105 Spa F&B Tax 1.40 reservation #300 998 opera:ft:17246047
137382 2026-04-10 charge 2136 Spa Pool Service Charge RST 6.40 reservation #300 998 opera:ft:17246046
137381 2026-04-10 charge 3103 Spa Liquor ALC 17.00 reservation #300 998 opera:ft:17246045
137380 2026-04-10 charge 3100 Spa Food RST 15.00 reservation #300 998 opera:ft:17246044
137379 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #392 10488 opera:ft:17246043 canceled 4.9 6:02pm
137378 2026-04-10 charge 3105 Spa F&B Tax 3.16 reservation #3735 8810 opera:ft:17246042
137377 2026-04-10 charge 2136 Spa Pool Service Charge RST 6.80 reservation #3735 8810 opera:ft:17246041
137376 2026-04-10 charge 3100 Spa Food RST 34.00 reservation #3735 8810 opera:ft:17246040
137375 2026-04-10 charge 7800 Programs Sales Tax 2.55 reservation #2563 10639 opera:ft:17246039
137374 2026-04-10 charge 8096 No Show Class CLS 30.00 reservation #2563 10639 opera:ft:17246038
137373 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 60.00 reservation #1598 10333 opera:ft:17246037
137372 2026-04-10 charge 2184 In Room Dining Food Retail RST -24.00 houseAccount #28 10128 opera:ft:17246036 asdasd
137371 2026-04-10 charge 2058 Food Retail Sales Tax -1.12 houseAccount #28 10249 opera:ft:17246035 sdf
137370 2026-04-10 charge 2058 Food Retail Sales Tax -1.12 houseAccount #28 10249 opera:ft:17246034 sdf
137369 2026-04-10 charge 7800 Programs Sales Tax 1.28 guest #5594 10428 opera:ft:17246033
137368 2026-04-10 charge 8096 No Show Class CLS 15.00 guest #5594 10428 opera:ft:17246032
137367 2026-04-10 charge 7800 Programs Sales Tax 1.28 guest #5593 10304 opera:ft:17246031
137366 2026-04-10 charge 8096 No Show Class CLS 15.00 guest #5593 10304 opera:ft:17246030
137365 2026-04-10 charge 7800 Programs Sales Tax 1.28 guest #5595 10305 opera:ft:17246029
137364 2026-04-10 charge 8096 No Show Class CLS 15.00 guest #5595 10305 opera:ft:17246028
137361 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #3319 10481 opera:ft:17246025 kate canceled 4.10 7:50am
137360 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 30.00 reservation #2563 10639 opera:ft:17246024 canceled 4.10 11:23am
137355 2026-04-10 charge 7014 Spa Sales Tax 1.74 houseAccount #11 10278 opera:ft:17246018
137354 2026-04-10 charge 7012 Spa Service Charge SPA 18.70 houseAccount #11 10278 opera:ft:17246017
137353 2026-04-10 charge 7003 Spa Nail Care SPA 85.00 houseAccount #11 10278 opera:ft:17246016
137352 2026-04-10 charge 7106 Jewelry SPA 68.00 houseAccount #13 10280 opera:ft:17246015
137351 2026-04-10 charge 7108 Bath and Body SPA 38.00 houseAccount #13 10280 opera:ft:17246014
137350 2026-04-10 charge 8026 Retail sales tax 9.85 houseAccount #13 10280 opera:ft:17246013
137349 2026-04-10 charge 7800 Programs Sales Tax 2.55 guest #6202 7047 opera:ft:17246012
137348 2026-04-10 charge 8096 No Show Class CLS 30.00 guest #6202 7047 opera:ft:17246011
137347 2026-04-10 credit 8105 Shopify Commission ALW -17.46 guest #6202 10434 opera:ft:17246010
137346 2026-04-10 credit 8105 Shopify Commission ALW -0.30 guest #6202 10434 opera:ft:17246009
137345 2026-04-10 charge 7033 Spa Package SPA 15.74 guest #6202 10434 opera:ft:17246008
137344 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #2674 4495 opera:ft:17246005 madeleine canceled 4.9 5pm
137343 2026-04-10 charge 7014 Spa Sales Tax 4.60 guest #6202 7047 opera:ft:17246004 BELL
137342 2026-04-10 charge 7012 Spa Service Charge SPA 49.50 guest #6202 7047 opera:ft:17246003 BELL
137341 2026-04-10 charge 7002 Spa Massage SPA 225.00 guest #6202 7047 opera:ft:17246002 BELL
137340 2026-04-10 payment 9028 F&B Visa CARD -25.85 houseAccount #19 10264 opera:ft:17246001
137339 2026-04-10 charge 2018 Alcohol Sales Tax 1.86 houseAccount #19 10264 opera:ft:17246000
137338 2026-04-10 charge 2137 Terras Bar Gratuity NRV 3.99 houseAccount #19 10264 opera:ft:17245999
137337 2026-04-10 charge 2129 Terras Bar Liquor ALC 20.00 houseAccount #19 10264 opera:ft:17245998
137336 2026-04-10 charge 2018 Alcohol Sales Tax 1.58 reservation #2099 3404 opera:ft:17245997
137335 2026-04-10 charge 3105 Spa F&B Tax 1.77 reservation #2099 3404 opera:ft:17245996
137334 2026-04-10 charge 2136 Spa Pool Service Charge RST 7.20 reservation #2099 3404 opera:ft:17245995
137333 2026-04-10 charge 3104 Spa F&B Gratuity NRV 15.45 reservation #2099 3404 opera:ft:17245994
137332 2026-04-10 charge 3103 Spa Liquor ALC 17.00 reservation #2099 3404 opera:ft:17245993
137331 2026-04-10 charge 3100 Spa Food RST 19.00 reservation #2099 3404 opera:ft:17245992
137330 2026-04-10 charge 2018 Alcohol Sales Tax 1.12 guest #5206 4880 opera:ft:17245991
137329 2026-04-10 charge 2129 Terras Bar Liquor ALC 12.00 guest #5206 4880 opera:ft:17245990
137328 2026-04-10 payment 9028 F&B Visa CARD -170.68 houseAccount #19 10264 opera:ft:17245988
137327 2026-04-10 charge 2018 Alcohol Sales Tax 6.23 houseAccount #19 10264 opera:ft:17245987
137326 2026-04-10 charge 3105 Spa F&B Tax 6.05 houseAccount #19 10264 opera:ft:17245986
137325 2026-04-10 charge 2136 Spa Pool Service Charge RST 26.40 houseAccount #19 10264 opera:ft:17245985
137324 2026-04-10 charge 3103 Spa Liquor ALC 67.00 houseAccount #19 10264 opera:ft:17245984
137323 2026-04-10 charge 3100 Spa Food RST 65.00 houseAccount #19 10264 opera:ft:17245983
137322 2026-04-10 charge 2018 Alcohol Sales Tax 4.56 guest #6832 8659 opera:ft:17245982
137321 2026-04-10 charge 3105 Spa F&B Tax 1.67 guest #6832 8659 opera:ft:17245981
137320 2026-04-10 charge 2136 Spa Pool Service Charge RST 13.40 guest #6832 8659 opera:ft:17245980
137319 2026-04-10 charge 3104 Spa F&B Gratuity NRV 6.00 guest #6832 8659 opera:ft:17245979
137318 2026-04-10 charge 3103 Spa Liquor ALC 49.00 guest #6832 8659 opera:ft:17245978
137317 2026-04-10 charge 3100 Spa Food RST 18.00 guest #6832 8659 opera:ft:17245977
137316 2026-04-10 charge 3105 Spa F&B Tax 1.86 guest #5960 6534 opera:ft:17245976
137315 2026-04-10 charge 2136 Spa Pool Service Charge RST 4.00 guest #5960 6534 opera:ft:17245975
137314 2026-04-10 charge 3100 Spa Food RST 20.00 guest #5960 6534 opera:ft:17245974
137313 2026-04-10 payment 9026 F&B American Express CARD -167.75 houseAccount #20 10265 opera:ft:17245973
137312 2026-04-10 charge 2018 Alcohol Sales Tax 2.79 houseAccount #20 10265 opera:ft:17245972
137311 2026-04-10 charge 3105 Spa F&B Tax 8.56 houseAccount #20 10265 opera:ft:17245971
137310 2026-04-10 charge 2136 Spa Pool Service Charge RST 24.40 houseAccount #20 10265 opera:ft:17245970
137309 2026-04-10 charge 3104 Spa F&B Gratuity NRV 10.00 houseAccount #20 10265 opera:ft:17245969
137308 2026-04-10 charge 3103 Spa Liquor ALC 30.00 houseAccount #20 10265 opera:ft:17245968
137307 2026-04-10 charge 3100 Spa Food RST 92.00 houseAccount #20 10265 opera:ft:17245967
137306 2026-04-10 charge 7800 Programs Sales Tax 1.28 guest #5960 6534 opera:ft:17245966
137305 2026-04-10 charge 8096 No Show Class CLS 15.00 guest #5960 6534 opera:ft:17245965
137304 2026-04-10 payment 9028 F&B Visa CARD -51.72 houseAccount #19 10264 opera:ft:17245964
137303 2026-04-10 charge 2018 Alcohol Sales Tax 3.72 houseAccount #19 10264 opera:ft:17245963
137302 2026-04-10 charge 2136 Spa Pool Service Charge RST 8.00 houseAccount #19 10264 opera:ft:17245962
137301 2026-04-10 charge 3103 Spa Liquor ALC 40.00 houseAccount #19 10264 opera:ft:17245961
137300 2026-04-10 credit 8105 Shopify Commission ALW -8.73 guest #5960 10325 opera:ft:17245960
137299 2026-04-10 credit 8105 Shopify Commission ALW -0.30 guest #5960 10325 opera:ft:17245959
137298 2026-04-10 charge 7033 Spa Package SPA 7.87 guest #5960 10325 opera:ft:17245958
137297 2026-04-10 charge 7515 Class Late Cancellation Fee CLS 45.00 reservation #1245 2268 opera:ft:17245952 canceled 4.10 11:59am
137296 2026-04-10 charge 7511 Paid Class - Outdoor CLS 45.00 reservation #347 1077 opera:ft:17245951
137295 2026-04-10 charge 1010 Room Tax 270.18 reservationGroup #25 10412 opera:ft:17245950
137294 2026-04-10 charge 1022 Group Rooms Attrition MSC 2,036.00 reservationGroup #25 10412 opera:ft:17245949
137293 2026-04-10 charge 2018 Alcohol Sales Tax 3.16 reservation #3340 6969 opera:ft:17245948
Sum (balance): 3,515.48