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

Ledger transactions (folio_transactions)

Reset
460317 rows (page 1507/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
286697 2026-06-01 payment 9006 American Express CARD -62.49 guest #303 14668 opera:ft:17431986
286696 2026-06-01 credit 8105 Shopify Commission ALW -8.73 guest #303 17867 opera:ft:17431985
286695 2026-06-01 credit 8105 Shopify Commission ALW -0.30 guest #303 17867 opera:ft:17431984
286694 2026-06-01 charge 7033 Spa Package SPA -4.53 guest #303 17867 opera:ft:17431983
286693 2026-06-01 charge 9996 Spa Package Profit 55.82 guest #9420 15124 opera:ft:17431980
286692 2026-06-01 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9420 17858 opera:ft:17431978
286691 2026-06-01 charge 9996 Spa Package Profit 86.83 guest #10108 17127 opera:ft:17431977
286690 2026-06-01 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #10108 17866 opera:ft:17431975
286689 2026-06-01 payment 9008 Visa CARD -64.07 guest #10108 17127 opera:ft:17431972
286688 2026-06-01 charge 9996 Spa Package Profit 43.41 guest #10230 17483 opera:ft:17431971
286687 2026-06-01 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #10230 17879 opera:ft:17431969
286686 2026-06-01 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9051 17862 opera:ft:17431968
286685 2026-06-01 payment 9007 Master Card CARD -27.69 guest #9051 13995 opera:ft:17431967
286684 2026-06-01 charge 2018 Alcohol Sales Tax 2.79 reservation #4630 12089 opera:ft:17431966
286683 2026-06-01 charge 3205 Terras Dinner Sales Tax 2.79 reservation #4630 12089 opera:ft:17431965
286682 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 13.00 reservation #4630 12089 opera:ft:17431964
286681 2026-06-01 charge 2086 Terras Dinner Wine ALC 30.00 reservation #4630 12089 opera:ft:17431963
286680 2026-06-01 charge 2084 Terras Dinner DNR 30.00 reservation #4630 12089 opera:ft:17431962
286679 2026-06-01 charge 7800 Programs Sales Tax 1.28 reservation #4524 18153 opera:ft:17431961
286678 2026-06-01 charge 8096 No Show Class CLS 15.00 reservation #4524 18153 opera:ft:17431960 Laura
286677 2026-06-01 charge 7800 Programs Sales Tax 2.55 reservation #5207 17936 opera:ft:17431959
286676 2026-06-01 charge 8096 No Show Class CLS 30.00 reservation #5207 17936 opera:ft:17431958
286675 2026-06-01 charge 2018 Alcohol Sales Tax 3.53 reservation #4822 13132 opera:ft:17431957
286674 2026-06-01 charge 3205 Terras Dinner Sales Tax 6.51 reservation #4822 13132 opera:ft:17431956
286673 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 23.00 reservation #4822 13132 opera:ft:17431955
286672 2026-06-01 charge 2087 Terras Dinner Liquor ALC 38.00 reservation #4822 13132 opera:ft:17431954
286671 2026-06-01 charge 2084 Terras Dinner DNR 70.00 reservation #4822 13132 opera:ft:17431953
286670 2026-06-01 charge 2018 Alcohol Sales Tax 2.79 reservation #4795 13000 opera:ft:17431952
286669 2026-06-01 charge 3205 Terras Dinner Sales Tax 10.60 reservation #4795 13000 opera:ft:17431951
286668 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 20.00 reservation #4795 13000 opera:ft:17431950
286667 2026-06-01 charge 2086 Terras Dinner Wine ALC 12.00 reservation #4795 13000 opera:ft:17431949
286666 2026-06-01 charge 2087 Terras Dinner Liquor ALC 18.00 reservation #4795 13000 opera:ft:17431948
286665 2026-06-01 charge 2084 Terras Dinner DNR 114.00 reservation #4795 13000 opera:ft:17431947
286664 2026-06-01 charge 2018 Alcohol Sales Tax 2.60 reservation #569 1308 opera:ft:17431946
286663 2026-06-01 charge 3205 Terras Dinner Sales Tax 6.23 reservation #569 1308 opera:ft:17431945
286662 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 25.00 reservation #569 1308 opera:ft:17431944
286661 2026-06-01 charge 2087 Terras Dinner Liquor ALC 28.00 reservation #569 1308 opera:ft:17431943
286660 2026-06-01 charge 2084 Terras Dinner DNR 67.00 reservation #569 1308 opera:ft:17431942
286659 2026-06-01 charge 7014 Spa Sales Tax 11.96 reservation #5504 16731 opera:ft:17431941 SALAVERRIA
286658 2026-06-01 charge 7012 Spa Service Charge SPA 128.70 reservation #5504 16731 opera:ft:17431940 SALAVERRIA
286657 2026-06-01 charge 7000 Spa Skin Care SPA 225.00 reservation #5504 16731 opera:ft:17431939 SALAVERRIA
286656 2026-06-01 charge 7002 Spa Massage SPA 360.00 reservation #5504 16731 opera:ft:17431938 SALAVERRIA
286655 2026-06-01 charge 2018 Alcohol Sales Tax 2.88 reservation #564 1303 opera:ft:17431937
286654 2026-06-01 charge 3205 Terras Dinner Sales Tax 9.67 reservation #564 1303 opera:ft:17431936
286653 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 23.00 reservation #564 1303 opera:ft:17431935
286652 2026-06-01 charge 2086 Terras Dinner Wine ALC 15.00 reservation #564 1303 opera:ft:17431934
286651 2026-06-01 charge 2087 Terras Dinner Liquor ALC 16.00 reservation #564 1303 opera:ft:17431933
286650 2026-06-01 charge 2084 Terras Dinner DNR 104.00 reservation #564 1303 opera:ft:17431932
286649 2026-06-01 charge 2018 Alcohol Sales Tax 2.60 reservation #4703 12441 opera:ft:17431931
286648 2026-06-01 charge 3205 Terras Dinner Sales Tax 10.04 reservation #4703 12441 opera:ft:17431930
286647 2026-06-01 charge 2094 Terras Dinner Gratuity NRV 28.00 reservation #4703 12441 opera:ft:17431929
286646 2026-06-01 charge 2087 Terras Dinner Liquor ALC 28.00 reservation #4703 12441 opera:ft:17431928
286645 2026-06-01 charge 2084 Terras Dinner DNR 108.00 reservation #4703 12441 opera:ft:17431927
286644 2026-06-01 payment 9008 Visa CARD -55.00 guest #7981 11246 opera:ft:17431924
286643 2026-06-01 charge 7800 Programs Sales Tax -2.55 guest #7981 11246 opera:ft:17431923
286642 2026-06-01 charge 8096 No Show Class CLS -30.00 guest #7981 11246 opera:ft:17431922 guest stated they attended
286641 2026-06-01 charge 2018 Alcohol Sales Tax 1.58 reservation #5176 15009 opera:ft:17431921
286640 2026-06-01 charge 2138 Terras Bar Sales Tax 6.79 reservation #5176 15009 opera:ft:17431920
286639 2026-06-01 charge 2137 Terras Bar Gratuity NRV 20.00 reservation #5176 15009 opera:ft:17431919
286638 2026-06-01 charge 2128 Terras Bar Wine ALC 17.00 reservation #5176 15009 opera:ft:17431918
286637 2026-06-01 charge 2125 Terras Bar RST 73.00 reservation #5176 15009 opera:ft:17431917
286636 2026-06-01 charge 7002 Spa Massage SPA 285.00 houseAccount #13 17837 opera:ft:17431916
286635 2026-06-01 charge 7014 Spa Sales Tax 4.60 reservation #4999 13945 opera:ft:17431915 ADAMS
286634 2026-06-01 charge 7012 Spa Service Charge SPA 45.02 reservation #4999 13945 opera:ft:17431914 ADAMS
286633 2026-06-01 charge 7012 Spa Service Charge SPA 4.48 reservation #4999 13945 opera:ft:17431913 ADAMS
286632 2026-06-01 charge 7002 Spa Massage SPA 225.00 reservation #4999 13945 opera:ft:17431912 ADAMS
286631 2026-06-01 charge 7014 Spa Sales Tax 5.42 reservation #4999 13945 opera:ft:17431911 ADAMS
286630 2026-06-01 charge 7012 Spa Service Charge SPA 58.30 reservation #4999 13945 opera:ft:17431910 ADAMS
286629 2026-06-01 charge 7002 Spa Massage SPA 265.00 reservation #4999 13945 opera:ft:17431909 ADAMS
286628 2026-06-01 charge 7014 Spa Sales Tax 4.40 reservation #4754 12808 opera:ft:17431908 JOHNSON
286627 2026-06-01 charge 7012 Spa Service Charge SPA 8.01 reservation #4754 12808 opera:ft:17431907 JOHNSON
286626 2026-06-01 charge 7012 Spa Service Charge SPA 39.29 reservation #4754 12808 opera:ft:17431906 JOHNSON
286625 2026-06-01 charge 7000 Spa Skin Care SPA 215.00 reservation #4754 12808 opera:ft:17431905 JOHNSON
286624 2026-06-01 charge 7014 Spa Sales Tax 5.01 reservation #4754 12808 opera:ft:17431904 JOHNSON
286623 2026-06-01 charge 7012 Spa Service Charge SPA 53.90 reservation #4754 12808 opera:ft:17431903 JOHNSON
286622 2026-06-01 charge 7002 Spa Massage SPA 245.00 reservation #4754 12808 opera:ft:17431902 JOHNSON
286621 2026-06-01 charge 7800 Programs Sales Tax 1.28 reservation #3453 7508 opera:ft:17431901
286620 2026-06-01 charge 8096 No Show Class CLS 15.00 reservation #3453 7508 opera:ft:17431900 Ari
286619 2026-06-01 charge 7800 Programs Sales Tax 13.61 guest #10230 17483 opera:ft:17431899
286618 2026-06-01 charge 8096 No Show Class CLS 160.00 guest #10230 17483 opera:ft:17431898
286617 2026-06-01 charge 7800 Programs Sales Tax 3.40 reservation #5504 16731 opera:ft:17431897
286616 2026-06-01 charge 8096 No Show Class CLS 40.00 reservation #5504 16731 opera:ft:17431896 Alejandrina
286615 2026-06-01 charge 7510 Paid Class - Yoga CLS 80.00 reservation #5693 17639 opera:ft:17431895
286614 2026-06-01 charge 7510 Paid Class - Yoga CLS 40.00 guest #10230 17483 opera:ft:17431894
286613 2026-06-01 credit 8105 Shopify Commission ALW -8.73 guest #10230 17879 opera:ft:17431893
286612 2026-06-01 credit 8105 Shopify Commission ALW -0.30 guest #10230 17879 opera:ft:17431892
286611 2026-06-01 charge 7033 Spa Package SPA -4.53 guest #10230 17879 opera:ft:17431891
286610 2026-06-01 charge 7510 Paid Class - Yoga CLS 80.00 reservation #4999 13945 opera:ft:17431888
286609 2026-06-01 charge 7510 Paid Class - Yoga CLS 40.00 reservation #4616 12065 opera:ft:17431887
286608 2026-06-01 charge 2058 Food Retail Sales Tax 1.12 houseAccount #24 17842 opera:ft:17431886
286607 2026-06-01 charge 3511 IRD Dinner Sales Tax 3.53 houseAccount #24 17842 opera:ft:17431885
286606 2026-06-01 charge 2008 In Room Dining Gratuity NRV 5.00 houseAccount #24 17842 opera:ft:17431884
286605 2026-06-01 charge 2184 In Room Dining Food Retail RST 12.00 houseAccount #24 17842 opera:ft:17431883
286604 2026-06-01 charge 2003 In-Room Dining Dinner DNR 38.00 houseAccount #24 17842 opera:ft:17431882
286603 2026-06-01 charge 7013 Spa Gratuity NRV 45.00 houseAccount #12 17836 opera:ft:17431881
286602 2026-06-01 charge 7000 Spa Skin Care SPA 225.00 houseAccount #12 17836 opera:ft:17431880
286601 2026-06-01 charge 8026 Retail sales tax 0.34 reservation #4616 12065 opera:ft:17431879
286600 2026-06-01 charge 7100 Sundries 9.3% Tax Inclusive MSC 4.00 reservation #4616 12065 opera:ft:17431878 TYLENOL
286599 2026-06-01 credit 8105 Shopify Commission ALW -8.73 guest #9420 17858 opera:ft:17431877
286598 2026-06-01 credit 8105 Shopify Commission ALW -0.30 guest #9420 17858 opera:ft:17431876
Sum (balance): 3,980.83