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 3543/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
77944 2026-03-22 charge 2083 Terras Lunch LUN 52.00 reservation #2257 3643 opera:ft:17162740
77943 2026-03-22 credit 7111 Professional Products Discou... DSC 36.00 houseAccount #12 7461 opera:ft:17162739
77942 2026-03-22 charge 7115 Professional Products SPA -360.00 houseAccount #12 7461 opera:ft:17162738
77941 2026-03-22 charge 8026 Retail sales tax -30.14 houseAccount #12 7461 opera:ft:17162737
77940 2026-03-22 charge 7014 Spa Sales Tax 9.00 reservation #3425 7408 opera:ft:17162736 SHEARER
77939 2026-03-22 charge 7012 Spa Service Charge SPA 96.80 reservation #3425 7408 opera:ft:17162735 SHEARER
77938 2026-03-22 charge 7002 Spa Massage SPA 440.00 reservation #3425 7408 opera:ft:17162734 SHEARER
77937 2026-03-22 charge 7014 Spa Sales Tax 5.01 reservation #1422 2508 opera:ft:17162733 DENNIS
77936 2026-03-22 charge 7012 Spa Service Charge SPA 53.90 reservation #1422 2508 opera:ft:17162732 DENNIS
77935 2026-03-22 charge 7002 Spa Massage SPA 245.00 reservation #1422 2508 opera:ft:17162731 DENNIS
77934 2026-03-22 credit 7111 Professional Products Discou... DSC -36.00 houseAccount #12 7461 opera:ft:17162730
77933 2026-03-22 charge 7115 Professional Products SPA 360.00 houseAccount #12 7461 opera:ft:17162729
77932 2026-03-22 charge 8026 Retail sales tax 30.14 houseAccount #12 7461 opera:ft:17162728
77931 2026-03-22 charge 7014 Spa Sales Tax 15.44 houseAccount #12 7461 opera:ft:17162727
77930 2026-03-22 charge 7012 Spa Service Charge SPA 166.10 houseAccount #12 7461 opera:ft:17162726
77929 2026-03-22 charge 7000 Spa Skin Care SPA 305.00 houseAccount #12 7461 opera:ft:17162725
77928 2026-03-22 charge 7002 Spa Massage SPA 450.00 houseAccount #12 7461 opera:ft:17162724
77927 2026-03-22 payment 9028 F&B Visa CARD -19.40 houseAccount #19 7485 opera:ft:17162723
77926 2026-03-22 charge 3105 Spa F&B Tax 1.40 houseAccount #19 7485 opera:ft:17162722
77925 2026-03-22 charge 2136 Spa Pool Service Charge RST 3.00 houseAccount #19 7485 opera:ft:17162721
77924 2026-03-22 credit 3106 Spa Food Discount DSC -10.00 houseAccount #19 7485 opera:ft:17162720
77923 2026-03-22 charge 3100 Spa Food RST 25.00 houseAccount #19 7485 opera:ft:17162719
77922 2026-03-22 charge 7013 Spa Gratuity NRV 5.30 houseAccount #13 7462 opera:ft:17162718
77921 2026-03-22 charge 7014 Spa Sales Tax 5.42 houseAccount #13 7462 opera:ft:17162717
77920 2026-03-22 charge 7012 Spa Service Charge SPA 58.30 houseAccount #13 7462 opera:ft:17162716
77919 2026-03-22 charge 7000 Spa Skin Care SPA 265.00 houseAccount #13 7462 opera:ft:17162715
77918 2026-03-22 charge 2018 Alcohol Sales Tax 6.32 reservation #1418 2504 opera:ft:17162714
77917 2026-03-22 charge 2136 Spa Pool Service Charge RST 13.60 reservation #1418 2504 opera:ft:17162713
77916 2026-03-22 charge 3103 Spa Liquor ALC 68.00 reservation #1418 2504 opera:ft:17162712
77915 2026-03-22 charge 2118 Pool Bar Sale Tax 4.09 reservation #2029 3345 opera:ft:17162711
77914 2026-03-22 charge 2114 Pool Bar Service Charge ALC 8.80 reservation #2029 3345 opera:ft:17162710
77913 2026-03-22 charge 2112 Pool Bar Gratuity NRV 8.11 reservation #2029 3345 opera:ft:17162709
77912 2026-03-22 charge 2105 Pool Bar Food ALC 44.00 reservation #2029 3345 opera:ft:17162708
77911 2026-03-22 charge 2018 Alcohol Sales Tax 1.67 reservation #2974 5624 opera:ft:17162707
77910 2026-03-22 charge 3104 Spa F&B Gratuity NRV 5.00 reservation #2974 5624 opera:ft:17162706
77909 2026-03-22 charge 3103 Spa Liquor ALC 18.00 reservation #2974 5624 opera:ft:17162705
77908 2026-03-22 payment 9028 F&B Visa CARD -204.39 houseAccount #19 7485 opera:ft:17162704
77907 2026-03-22 charge 2018 Alcohol Sales Tax 6.98 houseAccount #19 7485 opera:ft:17162703
77906 2026-03-22 charge 2118 Pool Bar Sale Tax 5.21 houseAccount #19 7485 opera:ft:17162702
77905 2026-03-22 charge 2114 Pool Bar Service Charge ALC 26.20 houseAccount #19 7485 opera:ft:17162701
77904 2026-03-22 charge 2112 Pool Bar Gratuity NRV 35.00 houseAccount #19 7485 opera:ft:17162700
77903 2026-03-22 charge 2108 Pool Bar Liquor ALC 75.00 houseAccount #19 7485 opera:ft:17162699
77902 2026-03-22 charge 2105 Pool Bar Food ALC 56.00 houseAccount #19 7485 opera:ft:17162698
77901 2026-03-22 charge 2018 Alcohol Sales Tax 1.30 guest #4789 4177 opera:ft:17162697
77900 2026-03-22 charge 2136 Spa Pool Service Charge RST 2.80 guest #4789 4177 opera:ft:17162696
77899 2026-03-22 charge 3104 Spa F&B Gratuity NRV 3.00 guest #4789 4177 opera:ft:17162695
77898 2026-03-22 charge 3103 Spa Liquor ALC 14.00 guest #4789 4177 opera:ft:17162694
77897 2026-03-22 charge 7014 Spa Sales Tax 9.20 reservation #1364 8330 opera:ft:17162693 MINNER
77896 2026-03-22 charge 7012 Spa Service Charge SPA 99.00 reservation #1364 8330 opera:ft:17162692 MINNER
77895 2026-03-22 charge 7002 Spa Massage SPA 450.00 reservation #1364 8330 opera:ft:17162691 MINNER
77894 2026-03-22 charge 7106 Jewelry SPA 68.00 houseAccount #12 7461 opera:ft:17162690
77893 2026-03-22 charge 8026 Retail sales tax 6.32 houseAccount #12 7461 opera:ft:17162689
77892 2026-03-22 charge 7013 Spa Gratuity NRV 88.00 houseAccount #13 7462 opera:ft:17162688
77891 2026-03-22 charge 7002 Spa Massage SPA 440.00 houseAccount #13 7462 opera:ft:17162687
77890 2026-03-22 payment 9027 F&B Mastercard CARD -19.40 houseAccount #23 7480 opera:ft:17162686
77889 2026-03-22 charge 2116 Seed Lunch Sales Tax 1.40 houseAccount #23 7480 opera:ft:17162685
77888 2026-03-22 charge 2115 Seed Lunch Gratuity NRV 3.00 houseAccount #23 7480 opera:ft:17162684
77887 2026-03-22 charge 2103 Seed Lunch LUN 15.00 houseAccount #23 7480 opera:ft:17162683
77886 2026-03-22 payment 9028 F&B Visa CARD -17.49 houseAccount #19 7485 opera:ft:17162682
77885 2026-03-22 charge 2116 Seed Lunch Sales Tax 1.49 houseAccount #19 7485 opera:ft:17162681
77884 2026-03-22 charge 2103 Seed Lunch LUN 16.00 houseAccount #19 7485 opera:ft:17162680
77883 2026-03-22 charge 9996 Spa Package Profit 186.09 guest #2985 2426 opera:ft:17162679
77882 2026-03-22 charge 2116 Seed Lunch Sales Tax 0.74 reservation #1421 2507 opera:ft:17162678
77881 2026-03-22 charge 1900 Seed Service Charge RST 1.44 reservation #1421 2507 opera:ft:17162677
77880 2026-03-22 charge 2103 Seed Lunch LUN 8.00 reservation #1421 2507 opera:ft:17162676
77879 2026-03-22 payment 9008 Visa CARD -181.07 guest #2985 2426 opera:ft:17162675
77878 2026-03-22 credit 8105 Shopify Commission ALW -26.19 guest #2985 7540 opera:ft:17162674
77877 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #2985 7540 opera:ft:17162673
77876 2026-03-22 charge 7033 Spa Package SPA 23.61 guest #2985 7540 opera:ft:17162672
77875 2026-03-22 charge 2116 Seed Lunch Sales Tax 1.40 reservation #1347 2427 opera:ft:17162669
77874 2026-03-22 charge 1900 Seed Service Charge RST 2.70 reservation #1347 2427 opera:ft:17162668
77873 2026-03-22 charge 2103 Seed Lunch LUN 15.00 reservation #1347 2427 opera:ft:17162667
77872 2026-03-22 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #3214 6455 opera:ft:17162666 cancelled 03.22 09:26am
77871 2026-03-22 payment 9027 F&B Mastercard CARD -6.47 houseAccount #23 7480 opera:ft:17162665
77870 2026-03-22 charge 2138 Terras Bar Sales Tax 0.47 houseAccount #23 7480 opera:ft:17162664
77869 2026-03-22 charge 2137 Terras Bar Gratuity NRV 1.00 houseAccount #23 7480 opera:ft:17162663
77868 2026-03-22 charge 2125 Terras Bar ALC 5.00 houseAccount #23 7480 opera:ft:17162662
77867 2026-03-22 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #2803 5015 opera:ft:17162661 cancelled 03.22 06:41am
77866 2026-03-22 charge 2058 Food Retail Sales Tax 2.60 reservation #915 1826 opera:ft:17162660
77865 2026-03-22 charge 2116 Seed Lunch Sales Tax 1.40 reservation #915 1826 opera:ft:17162659
77864 2026-03-22 charge 2115 Seed Lunch Gratuity NRV 3.00 reservation #915 1826 opera:ft:17162658
77863 2026-03-22 charge 2225 Seed Retail - Novelty RST 28.00 reservation #915 1826 opera:ft:17162657
77862 2026-03-22 charge 2103 Seed Lunch LUN 15.00 reservation #915 1826 opera:ft:17162656
77861 2026-03-22 charge 7014 Spa Sales Tax 4.71 houseAccount #13 7462 opera:ft:17162653
77860 2026-03-22 charge 7012 Spa Service Charge SPA 50.60 houseAccount #13 7462 opera:ft:17162652
77859 2026-03-22 charge 7002 Spa Massage SPA 230.00 houseAccount #13 7462 opera:ft:17162651
77858 2026-03-22 charge 7014 Spa Sales Tax 5.01 reservation #561 1318 opera:ft:17162650 GROFF
77857 2026-03-22 charge 7012 Spa Service Charge SPA 53.90 reservation #561 1318 opera:ft:17162649 GROFF
77856 2026-03-22 charge 7001 Spa Body Treatment SPA 9.32 reservation #561 1318 opera:ft:17162648 GROFF
77855 2026-03-22 charge 7001 Spa Body Treatment SPA 235.68 reservation #561 1318 opera:ft:17162647 GROFF
77854 2026-03-22 charge 7014 Spa Sales Tax 5.52 reservation #561 1318 opera:ft:17162646 GROFF
77853 2026-03-22 charge 7012 Spa Service Charge SPA 59.40 reservation #561 1318 opera:ft:17162645 GROFF
77852 2026-03-22 charge 7000 Spa Skin Care SPA 270.00 reservation #561 1318 opera:ft:17162644 GROFF
77851 2026-03-22 charge 7800 Programs Sales Tax 1.28 guest #3442 2848 opera:ft:17162643
77850 2026-03-22 charge 8096 No Show Class CLS 15.00 guest #3442 2848 opera:ft:17162642
77849 2026-03-22 charge 7014 Spa Sales Tax 5.83 houseAccount #12 7461 opera:ft:17162641
77848 2026-03-22 charge 7012 Spa Service Charge SPA 62.70 houseAccount #12 7461 opera:ft:17162640
77847 2026-03-22 charge 7002 Spa Massage SPA 285.00 houseAccount #12 7461 opera:ft:17162639
77846 2026-03-22 credit 8105 Shopify Commission ALW -8.73 guest #3442 7521 opera:ft:17162638
77845 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #3442 7521 opera:ft:17162637
Sum (balance): 4,927.82