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

Ledger transactions (folio_transactions)

Reset
447462 rows (page 2401/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
188500 2026-04-26 charge 7000 Spa Skin Care SPA 265.00 guest #6211 12488 opera:ft:17315408 JOHNSON
188499 2026-04-26 charge 7002 Spa Massage SPA 225.00 guest #6211 12488 opera:ft:17315407 JOHNSON
188498 2026-04-26 charge 2116 Seed Lunch Sales Tax 1.67 reservation #3273 6778 opera:ft:17315406
188497 2026-04-26 charge 2115 Seed Lunch Gratuity NRV 2.00 reservation #3273 6778 opera:ft:17315405
188496 2026-04-26 charge 2103 Seed Lunch LUN 18.00 reservation #3273 6778 opera:ft:17315404
188495 2026-04-26 charge 7014 Spa Sales Tax 9.82 guest #6211 12488 opera:ft:17315403 JOHNSON
188494 2026-04-26 charge 7012 Spa Service Charge SPA 105.60 guest #6211 12488 opera:ft:17315402 JOHNSON
188493 2026-04-26 charge 7000 Spa Skin Care SPA 265.00 guest #6211 12488 opera:ft:17315401 JOHNSON
188492 2026-04-26 charge 7002 Spa Massage SPA 215.00 guest #6211 12488 opera:ft:17315400 JOHNSON
188491 2026-04-26 credit 7116 Apparel Discount DSC -26.40 houseAccount #13 12368 opera:ft:17315399
188490 2026-04-26 charge 7102 Apparel SPA 88.00 houseAccount #13 12368 opera:ft:17315398
188489 2026-04-26 charge 8026 Retail sales tax 5.73 houseAccount #13 12368 opera:ft:17315397
188488 2026-04-26 charge 7013 Spa Gratuity NRV 50.00 houseAccount #13 12368 opera:ft:17315396
188487 2026-04-26 charge 7002 Spa Massage SPA 450.00 houseAccount #13 12368 opera:ft:17315395
188486 2026-04-26 charge 1069 Loyalty Credits MSC -50.00 reservation #725 1562 opera:ft:17315392 resort
188485 2026-04-26 charge 2018 Alcohol Sales Tax 2.60 reservation #459 1212 opera:ft:17315391
188484 2026-04-26 charge 2114 Pool Bar Service Charge ALC 5.60 reservation #459 1212 opera:ft:17315390
188483 2026-04-26 charge 2112 Pool Bar Gratuity NRV 3.80 reservation #459 1212 opera:ft:17315389
188482 2026-04-26 charge 2108 Pool Bar Liquor ALC 28.00 reservation #459 1212 opera:ft:17315388
188481 2026-04-26 charge 2018 Alcohol Sales Tax 2.60 reservation #930 1841 opera:ft:17315387
188480 2026-04-26 charge 2142 Terras Sales Tax Discount -0.21 reservation #930 1841 opera:ft:17315386
188479 2026-04-26 charge 2140 Terras Lunch Sales Tax 5.58 reservation #930 1841 opera:ft:17315385
188478 2026-04-26 charge 2141 Terras Lunch Gratuity NRV 20.00 reservation #930 1841 opera:ft:17315384
188477 2026-04-26 charge 3516 Terras Lunch Liquor ALC 28.00 reservation #930 1841 opera:ft:17315383
188476 2026-04-26 charge 2142 Terras Sales Tax Discount -2.23 reservation #930 1841 opera:ft:17315382
188475 2026-04-26 credit 2016 Terras Lunch Food Discount DSC -24.00 reservation #930 1841 opera:ft:17315381
188474 2026-04-26 charge 2083 Terras Lunch LUN 60.00 reservation #930 1841 opera:ft:17315380
188473 2026-04-26 charge 7127 Fitness Boutique - Books CLS 17.00 houseAccount #13 12368 opera:ft:17315379
188472 2026-04-26 charge 7124 Fitness Boutique - Apparel CLS 58.00 houseAccount #13 12368 opera:ft:17315378
188471 2026-04-26 charge 8026 Retail sales tax 6.97 houseAccount #13 12368 opera:ft:17315377
188470 2026-04-26 charge 1069 Loyalty Credits MSC -50.00 reservation #724 1561 opera:ft:17315376 return guest
188469 2026-04-26 charge 2018 Alcohol Sales Tax 1.77 reservation #930 1841 opera:ft:17315375
188468 2026-04-26 charge 2137 Terras Bar Gratuity NRV 5.00 reservation #930 1841 opera:ft:17315374
188467 2026-04-26 charge 2129 Terras Bar Liquor ALC 19.00 reservation #930 1841 opera:ft:17315373
188466 2026-04-26 charge 2140 Terras Lunch Sales Tax 8.56 reservation #2366 3778 opera:ft:17315372
188465 2026-04-26 charge 1699 Terras Lunch Service Charge LUN 16.56 reservation #2366 3778 opera:ft:17315371
188464 2026-04-26 charge 2083 Terras Lunch LUN 92.00 reservation #2366 3778 opera:ft:17315370
188463 2026-04-26 payment 9028 F&B Visa CARD -4.65 houseAccount #19 12350 opera:ft:17315369
188462 2026-04-26 charge 3105 Spa F&B Tax 0.33 houseAccount #19 12350 opera:ft:17315368
188461 2026-04-26 charge 2136 Spa Pool Service Charge RST 0.72 houseAccount #19 12350 opera:ft:17315367
188460 2026-04-26 credit 3106 Spa Food Discount DSC -2.40 houseAccount #19 12350 opera:ft:17315366
188459 2026-04-26 charge 3100 Spa Food RST 6.00 houseAccount #19 12350 opera:ft:17315365
188458 2026-04-26 charge 7014 Spa Sales Tax 6.13 guest #7215 9573 opera:ft:17315364 CARLTON
188457 2026-04-26 charge 7012 Spa Service Charge SPA 66.00 guest #7215 9573 opera:ft:17315363 CARLTON
188456 2026-04-26 charge 7002 Spa Massage SPA 300.00 guest #7215 9573 opera:ft:17315362 CARLTON
188455 2026-04-26 charge 2018 Alcohol Sales Tax 4.19 reservation #4146 10255 opera:ft:17315361
188454 2026-04-26 charge 2140 Terras Lunch Sales Tax 14.14 reservation #4146 10255 opera:ft:17315360
188453 2026-04-26 charge 2141 Terras Lunch Gratuity NRV 40.00 reservation #4146 10255 opera:ft:17315359
188452 2026-04-26 charge 3522 Terras Lunch Beer ALC 14.00 reservation #4146 10255 opera:ft:17315358
188451 2026-04-26 charge 3516 Terras Lunch Liquor ALC 31.00 reservation #4146 10255 opera:ft:17315357
188450 2026-04-26 charge 2083 Terras Lunch LUN 152.00 reservation #4146 10255 opera:ft:17315356
188449 2026-04-26 charge 7014 Spa Sales Tax 4.40 guest #7434 12455 opera:ft:17315353 HIDALGO
188448 2026-04-26 charge 7012 Spa Service Charge SPA 47.30 guest #7434 12455 opera:ft:17315352 HIDALGO
188447 2026-04-26 charge 7002 Spa Massage SPA 215.00 guest #7434 12455 opera:ft:17315351 HIDALGO
188446 2026-04-26 charge 7014 Spa Sales Tax 4.60 houseAccount #12 12367 opera:ft:17315350
188445 2026-04-26 charge 7012 Spa Service Charge SPA 49.50 houseAccount #12 12367 opera:ft:17315349
188444 2026-04-26 charge 7002 Spa Massage SPA 225.00 houseAccount #12 12367 opera:ft:17315348
188443 2026-04-26 charge 7014 Spa Sales Tax 5.01 reservation #849 1725 opera:ft:17315347 SHATEK
188442 2026-04-26 charge 7012 Spa Service Charge SPA 53.90 reservation #849 1725 opera:ft:17315346 SHATEK
188441 2026-04-26 charge 7002 Spa Massage SPA 245.00 reservation #849 1725 opera:ft:17315345 SHATEK
188440 2026-04-26 payment 9027 F&B Mastercard CARD -41.38 houseAccount #23 12351 opera:ft:17315344
188439 2026-04-26 charge 3105 Spa F&B Tax 2.98 houseAccount #23 12351 opera:ft:17315343
188438 2026-04-26 charge 2136 Spa Pool Service Charge RST 6.40 houseAccount #23 12351 opera:ft:17315342
188437 2026-04-26 charge 3100 Spa Food RST 32.00 houseAccount #23 12351 opera:ft:17315341
188436 2026-04-26 charge 7014 Spa Sales Tax 5.83 reservation #430 1181 opera:ft:17315340 KANTHA
188435 2026-04-26 charge 7012 Spa Service Charge SPA 62.70 reservation #430 1181 opera:ft:17315339 KANTHA
188434 2026-04-26 charge 7002 Spa Massage SPA 285.00 reservation #430 1181 opera:ft:17315338 KANTHA
188433 2026-04-26 charge 2018 Alcohol Sales Tax 2.88 guest #4632 4018 opera:ft:17315337
188432 2026-04-26 charge 3105 Spa F&B Tax 5.77 guest #4632 4018 opera:ft:17315336
188431 2026-04-26 charge 2136 Spa Pool Service Charge RST 18.60 guest #4632 4018 opera:ft:17315335
188430 2026-04-26 charge 3104 Spa F&B Gratuity NRV 24.00 guest #4632 4018 opera:ft:17315334
188429 2026-04-26 charge 3103 Spa Liquor ALC 31.00 guest #4632 4018 opera:ft:17315333
188428 2026-04-26 charge 3100 Spa Food RST 62.00 guest #4632 4018 opera:ft:17315332
188427 2026-04-26 charge 7014 Spa Sales Tax 4.40 guest #4885 4347 opera:ft:17315331 BOTHWELL
188426 2026-04-26 charge 7012 Spa Service Charge SPA 47.30 guest #4885 4347 opera:ft:17315330 BOTHWELL
188425 2026-04-26 charge 7002 Spa Massage SPA 215.00 guest #4885 4347 opera:ft:17315329 BOTHWELL
188424 2026-04-26 payment 9028 F&B Visa CARD -17.40 houseAccount #19 12350 opera:ft:17315328
188423 2026-04-26 charge 2138 Terras Bar Sales Tax 1.40 houseAccount #19 12350 opera:ft:17315327
188422 2026-04-26 charge 2137 Terras Bar Gratuity NRV 1.00 houseAccount #19 12350 opera:ft:17315326
188421 2026-04-26 credit 2139 Terras Bar Food Discount DSC -10.00 houseAccount #19 12350 opera:ft:17315325
188420 2026-04-26 charge 2125 Terras Bar ALC 25.00 houseAccount #19 12350 opera:ft:17315324
188419 2026-04-26 charge 7014 Spa Sales Tax 4.40 guest #7215 9573 opera:ft:17315323 CARLTON
188418 2026-04-26 charge 7012 Spa Service Charge SPA 47.30 guest #7215 9573 opera:ft:17315322 CARLTON
188417 2026-04-26 charge 7002 Spa Massage SPA 215.00 guest #7215 9573 opera:ft:17315321 CARLTON
188416 2026-04-26 charge 2018 Alcohol Sales Tax 1.30 guest #4633 4019 opera:ft:17315320
188415 2026-04-26 charge 3105 Spa F&B Tax 2.42 guest #4633 4019 opera:ft:17315319
188414 2026-04-26 charge 2136 Spa Pool Service Charge RST 8.00 guest #4633 4019 opera:ft:17315318
188413 2026-04-26 charge 3104 Spa F&B Gratuity NRV 8.28 guest #4633 4019 opera:ft:17315317
188412 2026-04-26 charge 3103 Spa Liquor ALC 14.00 guest #4633 4019 opera:ft:17315316
188411 2026-04-26 charge 3100 Spa Food RST 26.00 guest #4633 4019 opera:ft:17315315
188410 2026-04-26 credit 8105 Shopify Commission ALW -8.73 guest #6810 12419 opera:ft:17315314
188409 2026-04-26 credit 8105 Shopify Commission ALW -0.30 guest #6810 12419 opera:ft:17315313
188408 2026-04-26 charge 7033 Spa Package SPA 349.00 guest #6810 12419 opera:ft:17315312
188407 2026-04-26 charge 2018 Alcohol Sales Tax -2.60 reservation #2230 3602 opera:ft:17315309
188406 2026-04-26 charge 2140 Terras Lunch Sales Tax -5.58 reservation #2230 3602 opera:ft:17315308
188405 2026-04-26 charge 1699 Terras Lunch Service Charge LUN -10.80 reservation #2230 3602 opera:ft:17315307
188404 2026-04-26 charge 3516 Terras Lunch Liquor ALC -28.00 reservation #2230 3602 opera:ft:17315306
188403 2026-04-26 charge 2083 Terras Lunch LUN -60.00 reservation #2230 3602 opera:ft:17315305
188402 2026-04-26 charge 7014 Spa Sales Tax 4.40 guest #7215 9573 opera:ft:17315304 CARLTON
188401 2026-04-26 charge 7012 Spa Service Charge SPA 47.30 guest #7215 9573 opera:ft:17315303 CARLTON
Sum (balance): 4,782.06