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

Ledger transactions (folio_transactions)

Reset
447467 rows (page 2028/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
224515 2026-05-08 charge 3104 Spa F&B Gratuity NRV 5.00 reservation #1996 3307 opera:ft:17361227
224514 2026-05-08 charge 3102 Spa Wine ALC 14.00 reservation #1996 3307 opera:ft:17361226
224513 2026-05-08 charge 3103 Spa Liquor ALC 17.00 reservation #1996 3307 opera:ft:17361225
224512 2026-05-08 charge 2018 Alcohol Sales Tax 5.95 guest #650 11634 opera:ft:17361224
224511 2026-05-08 charge 3105 Spa F&B Tax 4.93 guest #650 11634 opera:ft:17361223
224510 2026-05-08 charge 2136 Spa Pool Service Charge RST 23.40 guest #650 11634 opera:ft:17361222
224509 2026-05-08 charge 3104 Spa F&B Gratuity NRV 20.00 guest #650 11634 opera:ft:17361221
224508 2026-05-08 charge 3102 Spa Wine ALC 30.00 guest #650 11634 opera:ft:17361220
224507 2026-05-08 charge 3103 Spa Liquor ALC 34.00 guest #650 11634 opera:ft:17361219
224506 2026-05-08 charge 3100 Spa Food RST 53.00 guest #650 11634 opera:ft:17361218
224505 2026-05-08 charge 2018 Alcohol Sales Tax 3.16 guest #8616 12945 opera:ft:17361217
224504 2026-05-08 charge 3105 Spa F&B Tax 1.67 guest #8616 12945 opera:ft:17361216
224503 2026-05-08 charge 2136 Spa Pool Service Charge RST 10.40 guest #8616 12945 opera:ft:17361215
224502 2026-05-08 charge 3103 Spa Liquor ALC 34.00 guest #8616 12945 opera:ft:17361214
224501 2026-05-08 charge 3100 Spa Food RST 18.00 guest #8616 12945 opera:ft:17361213
224500 2026-05-08 charge 2018 Alcohol Sales Tax 8.93 guest #7919 11179 opera:ft:17361212
224499 2026-05-08 charge 3105 Spa F&B Tax 2.42 guest #7919 11179 opera:ft:17361211
224498 2026-05-08 charge 2136 Spa Pool Service Charge RST 24.40 guest #7919 11179 opera:ft:17361210
224497 2026-05-08 charge 3103 Spa Liquor ALC 96.00 guest #7919 11179 opera:ft:17361209
224496 2026-05-08 charge 3100 Spa Food RST 26.00 guest #7919 11179 opera:ft:17361208
224495 2026-05-08 charge 2058 Food Retail Sales Tax 0.84 reservation #1217 2253 opera:ft:17361207
224494 2026-05-08 charge 3105 Spa F&B Tax 1.67 reservation #1217 2253 opera:ft:17361206
224493 2026-05-08 charge 2136 Spa Pool Service Charge RST 5.40 reservation #1217 2253 opera:ft:17361205
224492 2026-05-08 charge 2104 Food Retail RST 9.00 reservation #1217 2253 opera:ft:17361204
224491 2026-05-08 charge 3100 Spa Food RST 18.00 reservation #1217 2253 opera:ft:17361203
224490 2026-05-08 charge 2018 Alcohol Sales Tax 8.93 reservation #4890 13367 opera:ft:17361202
224489 2026-05-08 charge 2138 Terras Bar Sales Tax 1.12 reservation #4890 13367 opera:ft:17361201
224488 2026-05-08 charge 2137 Terras Bar Gratuity NRV 21.94 reservation #4890 13367 opera:ft:17361200
224487 2026-05-08 charge 2129 Terras Bar Liquor ALC 96.00 reservation #4890 13367 opera:ft:17361199
224486 2026-05-08 charge 2125 Terras Bar ALC 12.00 reservation #4890 13367 opera:ft:17361198
224485 2026-05-08 charge 3105 Spa F&B Tax 2.42 reservation #1113 2128 opera:ft:17361197
224484 2026-05-08 charge 2136 Spa Pool Service Charge RST 5.20 reservation #1113 2128 opera:ft:17361196
224483 2026-05-08 charge 3100 Spa Food RST 26.00 reservation #1113 2128 opera:ft:17361195
224482 2026-05-08 charge 2018 Alcohol Sales Tax 1.49 reservation #4472 11548 opera:ft:17361194
224481 2026-05-08 charge 3105 Spa F&B Tax 4.09 reservation #4472 11548 opera:ft:17361193
224480 2026-05-08 charge 2136 Spa Pool Service Charge RST 12.00 reservation #4472 11548 opera:ft:17361192
224479 2026-05-08 charge 3103 Spa Liquor ALC 16.00 reservation #4472 11548 opera:ft:17361191
224478 2026-05-08 charge 3100 Spa Food RST 44.00 reservation #4472 11548 opera:ft:17361190
224477 2026-05-08 charge 7013 Spa Gratuity NRV 26.00 houseAccount #13 14378 opera:ft:17361189
224476 2026-05-08 charge 7014 Spa Sales Tax 6.65 houseAccount #13 14378 opera:ft:17361188
224475 2026-05-08 charge 7012 Spa Service Charge SPA 71.50 houseAccount #13 14378 opera:ft:17361187
224474 2026-05-08 charge 7002 Spa Massage SPA 325.00 houseAccount #13 14378 opera:ft:17361186
224473 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #8678 13102 opera:ft:17361185
224472 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #8678 13102 opera:ft:17361184
224471 2026-05-08 credit 8105 Shopify Commission ALW -17.46 guest #8678 14464 opera:ft:17361183
224470 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8678 14464 opera:ft:17361182
224469 2026-05-08 charge 7033 Spa Package SPA -9.06 guest #8678 14464 opera:ft:17361181
224468 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #4458 11431 opera:ft:17361177 Kyle and Paige
224467 2026-05-08 charge 7512 Paid Class - Fitness CLS 40.00 reservation #2284 3676 opera:ft:17361176 Christy
224466 2026-05-08 payment 9028 F&B Visa CARD -17.05 houseAccount #19 14374 opera:ft:17361175
224465 2026-05-08 charge 3105 Spa F&B Tax 1.45 houseAccount #19 14374 opera:ft:17361174
224464 2026-05-08 credit 3106 Spa Food Discount DSC -10.40 houseAccount #19 14374 opera:ft:17361173
224463 2026-05-08 charge 3100 Spa Food RST 26.00 houseAccount #19 14374 opera:ft:17361172
224462 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #2106 3432 opera:ft:17361171
224461 2026-05-08 charge 7013 Spa Gratuity NRV 111.00 reservation #4764 12847 opera:ft:17361170 YURAN
224460 2026-05-08 charge 7002 Spa Massage SPA 555.00 reservation #4764 12847 opera:ft:17361169 YURAN
224459 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #4044 9859 opera:ft:17361168
224458 2026-05-08 charge 7512 Paid Class - Fitness CLS 40.00 reservation #2284 3676 opera:ft:17361167 Helen
224457 2026-05-08 payment 9005 Gift Card Payment GIFT_CARD -800.00 guest #7919 11179 opera:ft:17361166
224456 2026-05-08 charge 7512 Paid Class - Fitness CLS 40.00 reservation #1997 14535 opera:ft:17361165 Aisha
224455 2026-05-08 charge 2018 Alcohol Sales Tax 5.39 reservation #4665 12191 opera:ft:17361164
224454 2026-05-08 charge 2141 Terras Lunch Gratuity NRV 6.61 reservation #4665 12191 opera:ft:17361163
224453 2026-05-08 charge 3523 Terras Lunch Wine ALC 34.00 reservation #4665 12191 opera:ft:17361162
224452 2026-05-08 charge 3516 Terras Lunch Liquor ALC 24.00 reservation #4665 12191 opera:ft:17361161
224451 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #4764 12847 opera:ft:17361160
224450 2026-05-08 charge 7000 Spa Skin Care SPA -270.00 houseAccount #13 14378 opera:ft:17361159
224449 2026-05-08 charge 7002 Spa Massage SPA -225.00 houseAccount #13 14378 opera:ft:17361158
224448 2026-05-08 credit 8105 Shopify Commission ALW -17.46 guest #7919 11179 opera:ft:17361157
224447 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #7919 11179 opera:ft:17361156
224446 2026-05-08 charge 7033 Spa Package SPA -9.06 guest #7919 11179 opera:ft:17361155
224445 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #1997 3308 opera:ft:17361152
224444 2026-05-08 charge 7512 Paid Class - Fitness CLS 80.00 reservation #1331 2408 opera:ft:17361151
224443 2026-05-08 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #1996 3307 opera:ft:17361150 Kim
224442 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #6904 8961 opera:ft:17361149
224441 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #6904 8961 opera:ft:17361148 Rhonda
224440 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #6904 8961 opera:ft:17361147
224439 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #6904 8961 opera:ft:17361146 Corrie
224438 2026-05-08 credit 8105 Shopify Commission ALW -17.46 guest #6904 14417 opera:ft:17361145
224437 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #6904 14417 opera:ft:17361144
224436 2026-05-08 charge 7033 Spa Package SPA -9.06 guest #6904 14417 opera:ft:17361143
224435 2026-05-08 charge 7523 Paid Class - Experience CLS 125.00 reservation #4455 11426 opera:ft:17361140
224434 2026-05-08 charge 7000 Spa Skin Care SPA 270.00 houseAccount #13 14378 opera:ft:17361139
224433 2026-05-08 charge 7002 Spa Massage SPA 225.00 houseAccount #13 14378 opera:ft:17361138
224432 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #8616 14471 opera:ft:17361137
224431 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #8616 14471 opera:ft:17361136
224430 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8616 14435 opera:ft:17361135
224429 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8616 14435 opera:ft:17361134
224428 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8616 14435 opera:ft:17361133
224427 2026-05-08 charge 7800 Programs Sales Tax 2.55 guest #8568 14473 opera:ft:17361130
224426 2026-05-08 charge 8096 No Show Class CLS 30.00 guest #8568 14473 opera:ft:17361129
224425 2026-05-08 charge 7800 Programs Sales Tax 1.28 reservation #4089 14795 opera:ft:17361128
224424 2026-05-08 charge 8096 No Show Class CLS 15.00 reservation #4089 14795 opera:ft:17361127 Renata
224423 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #8470 12432 opera:ft:17361126
224422 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #8470 12432 opera:ft:17361125
224421 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8470 14439 opera:ft:17361124
224420 2026-05-08 credit 8105 Shopify Commission ALW -0.30 guest #8470 14439 opera:ft:17361123
224419 2026-05-08 charge 7033 Spa Package SPA -4.53 guest #8470 14439 opera:ft:17361122
224418 2026-05-08 charge 7800 Programs Sales Tax 1.28 guest #8681 13107 opera:ft:17361117
224417 2026-05-08 charge 8096 No Show Class CLS 15.00 guest #8681 13107 opera:ft:17361116
224416 2026-05-08 credit 8105 Shopify Commission ALW -8.73 guest #8681 14421 opera:ft:17361115
Sum (balance): 1,853.71