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

Ledger transactions (folio_transactions)

Reset
447466 rows (page 3534/4475)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
78848 2026-03-22 charge 2018 Alcohol Sales Tax -3.16 houseAccount #18 7488 opera:ft:17163717 service recovery
78847 2026-03-22 charge 3105 Spa F&B Tax -1.86 houseAccount #18 7488 opera:ft:17163716 service recovery
78846 2026-03-22 credit 2119 Allowance Spa Beverage ALW -34.00 houseAccount #18 7488 opera:ft:17163715 service recovery
78845 2026-03-22 credit 3503 Allowance Spa Food ALW -20.00 houseAccount #18 7488 opera:ft:17163714 service recovery
78844 2026-03-22 charge 2018 Alcohol Sales Tax -5.21 houseAccount #18 7488 opera:ft:17163713 service recovery
78843 2026-03-22 credit 2092 Allowance Terras Bar Beverag... ALW -56.00 houseAccount #18 7488 opera:ft:17163712 service recovery
78842 2026-03-22 payment 9008 Visa CARD -6.56 reservation #2668 4506 opera:ft:17163710
78841 2026-03-22 payment 9008 Visa CARD -80.00 reservation #2568 4228 opera:ft:17163709
78840 2026-03-22 payment 9008 Visa CARD -264.00 reservation #2803 5015 opera:ft:17163708
78839 2026-03-22 payment 9007 Master Card CARD -34.98 reservation #2995 5697 opera:ft:17163707
78838 2026-03-22 payment 9007 Master Card CARD 17.49 reservation #1505 2611 opera:ft:17163706
78837 2026-03-22 payment 9008 Visa CARD -40.00 reservation #2201 3563 opera:ft:17163705
78836 2026-03-22 charge 1010 Room Tax 0.00 reservation #1748 2951 opera:ft:17163704
78835 2026-03-22 charge 1028 Cancellation/Forfeited Depos... MSC 0.01 reservation #1748 2951 opera:ft:17163703
78834 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 26.49 guest #2985 7540 opera:ft:17163702
78833 2026-03-22 payment 9006 American Express CARD -100.00 reservation #707 7422 opera:ft:17163701
78832 2026-03-22 charge 7161 Shopify - Day Pass Inclusion MSC -570.61 guest #6161 7580 opera:ft:17163700 not absorbed
78831 2026-03-22 payment 9008 Visa CARD -118.67 reservation #790 1664 opera:ft:17163699
78830 2026-03-22 payment 9008 Visa CARD -81.04 reservation #3282 6787 opera:ft:17163698
78829 2026-03-22 charge 2170 Signature Meal Plan Inclusio... -50.64 reservation #551 7506 opera:ft:17163697 signature meal plan
78828 2026-03-22 payment 9008 Visa CARD -15.30 reservation #551 1306 opera:ft:17163696
78827 2026-03-22 payment 9008 Visa CARD -64.65 reservation #2466 4025 opera:ft:17163695
78826 2026-03-22 payment 9006 American Express CARD -61.21 reservation #2126 3461 opera:ft:17163694
78825 2026-03-22 charge 2174 INCLU Rate Inclusion -44.56 reservation #1315 7452 opera:ft:17163692 not absorbed
78824 2026-03-22 payment 9008 Visa CARD -40.88 reservation #1542 2649 opera:ft:17163691
78823 2026-03-22 payment 9007 Master Card CARD -40.08 guest #4987 4480 opera:ft:17163690
78822 2026-03-22 payment 9008 Visa CARD -17.49 reservation #2452 3999 opera:ft:17163689
78821 2026-03-22 payment 9008 Visa CARD 5.74 reservation #3254 6682 opera:ft:17163687
78820 2026-03-22 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #37 7512 opera:ft:17163686
78819 2026-03-22 payment 9126 Spa American Express CARD -2,734.98 houseAccount #11 7465 opera:ft:17163685 9126
78818 2026-03-22 payment 9128 Spa Visa CARD -12,352.64 houseAccount #13 7462 opera:ft:17163684 9128
78817 2026-03-22 payment 9127 Spa Mastercard CARD -6,086.77 houseAccount #12 7461 opera:ft:17163683 9127
78816 2026-03-22 payment 9125 Spa Cash CASH -233.16 houseAccount #10 7460 opera:ft:17163682
78815 2026-03-22 charge 9996 Spa Package Profit 124.06 guest #4789 4177 opera:ft:17163681
78814 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #4789 7534 opera:ft:17163678
78813 2026-03-22 payment 9008 Visa CARD -21.10 guest #4789 4177 opera:ft:17163677
78812 2026-03-22 credit 8105 Shopify Commission ALW -17.46 guest #4789 7534 opera:ft:17163676
78811 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #4789 7534 opera:ft:17163675
78810 2026-03-22 charge 7033 Spa Package SPA 15.74 guest #4789 7534 opera:ft:17163674
78809 2026-03-22 charge 9996 Spa Package Profit 806.32 guest #4121 3174 opera:ft:17163671
78808 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 14.03 guest #4121 7508 opera:ft:17163669
78807 2026-03-22 credit 8105 Shopify Commission ALW -13.73 guest #4121 7508 opera:ft:17163668
78806 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #4121 7508 opera:ft:17163667
78805 2026-03-22 charge 3007 Amusement Tax -48.33 guest #4121 7508 opera:ft:17163666
78804 2026-03-22 charge 8086 Resort Day Passes MSC -815.52 guest #4121 7508 opera:ft:17163665
78803 2026-03-22 charge 9996 Spa Package Profit 62.03 guest #3470 2877 opera:ft:17163662
78802 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #3470 7550 opera:ft:17163660
78801 2026-03-22 credit 8105 Shopify Commission ALW -17.46 guest #3470 7550 opera:ft:17163659
78800 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #3470 7550 opera:ft:17163658
78799 2026-03-22 charge 7033 Spa Package SPA 15.74 guest #3470 7550 opera:ft:17163657
78798 2026-03-22 charge 9996 Spa Package Profit 37.22 guest #3442 2848 opera:ft:17163654
78797 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #3442 7521 opera:ft:17163651
78796 2026-03-22 payment 9006 American Express CARD -128.11 guest #3442 2848 opera:ft:17163650
78795 2026-03-22 charge 9988 Spa Package Loss -84.26 guest #1770 1278 opera:ft:17163649
78794 2026-03-22 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #1770 7502 opera:ft:17163647
78793 2026-03-22 credit 8105 Shopify Commission ALW -17.46 guest #1770 7502 opera:ft:17163646
78792 2026-03-22 credit 8105 Shopify Commission ALW -0.30 guest #1770 7502 opera:ft:17163645
78791 2026-03-22 charge 7161 Shopify - Day Pass Inclusion MSC 50.00 guest #1770 7502 opera:ft:17163644
78790 2026-03-22 charge 8530 S&M - Promotion (Accounting... MSC -50.00 guest #1770 7502 opera:ft:17163643
78789 2026-03-22 charge 7033 Spa Package SPA 0.00 guest #1770 1278 opera:ft:17163642
78788 2026-03-22 charge 2018 Alcohol Sales Tax 5.21 houseAccount #18 7488 opera:ft:17163639
78787 2026-03-22 charge 2129 Terras Bar Liquor ALC 56.00 houseAccount #18 7488 opera:ft:17163638
78786 2026-03-22 charge 2018 Alcohol Sales Tax 4.09 reservation #3247 6600 opera:ft:17163637
78785 2026-03-22 charge 2138 Terras Bar Sales Tax 12.65 reservation #3247 6600 opera:ft:17163636
78784 2026-03-22 charge 1901 Terras Lounge Service Charge RST 24.48 reservation #3247 6600 opera:ft:17163635
78783 2026-03-22 charge 2128 Terras Bar Wine ALC 32.00 reservation #3247 6600 opera:ft:17163634
78782 2026-03-22 charge 2129 Terras Bar Liquor ALC 12.00 reservation #3247 6600 opera:ft:17163633
78781 2026-03-22 charge 2125 Terras Bar ALC 136.00 reservation #3247 6600 opera:ft:17163632
78780 2026-03-22 charge 2018 Alcohol Sales Tax 1.12 reservation #1052 2062 opera:ft:17163631
78779 2026-03-22 charge 2129 Terras Bar Liquor ALC 12.00 reservation #1052 2062 opera:ft:17163630
78778 2026-03-22 payment 9028 F&B Visa CARD -124.93 houseAccount #19 7485 opera:ft:17163629
78777 2026-03-22 charge 2018 Alcohol Sales Tax 2.79 houseAccount #19 7485 opera:ft:17163628
78776 2026-03-22 charge 2138 Terras Bar Sales Tax 6.14 houseAccount #19 7485 opera:ft:17163627
78775 2026-03-22 charge 2137 Terras Bar Gratuity NRV 20.00 houseAccount #19 7485 opera:ft:17163626
78774 2026-03-22 charge 2129 Terras Bar Liquor ALC 30.00 houseAccount #19 7485 opera:ft:17163625
78773 2026-03-22 charge 2125 Terras Bar ALC 66.00 houseAccount #19 7485 opera:ft:17163624
78772 2026-03-22 payment 9028 F&B Visa CARD -327.63 houseAccount #19 7485 opera:ft:17163623
78771 2026-03-22 charge 2018 Alcohol Sales Tax 2.70 houseAccount #19 7485 opera:ft:17163622
78770 2026-03-22 charge 3205 Terras Dinner Sales Tax 20.93 houseAccount #19 7485 opera:ft:17163621
78769 2026-03-22 charge 2094 Terras Dinner Gratuity NRV 50.00 houseAccount #19 7485 opera:ft:17163620
78768 2026-03-22 charge 2087 Terras Dinner Liquor ALC 29.00 houseAccount #19 7485 opera:ft:17163619
78767 2026-03-22 charge 2084 Terras Dinner DNR 225.00 houseAccount #19 7485 opera:ft:17163618
78766 2026-03-22 charge 3511 IRD Dinner Sales Tax 3.44 reservation #2655 4443 opera:ft:17163617
78765 2026-03-22 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2655 4443 opera:ft:17163616
78764 2026-03-22 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2655 4443 opera:ft:17163615
78763 2026-03-22 charge 2007 In-Room Dining Service Charg... RST 6.40 reservation #2655 4443 opera:ft:17163614
78762 2026-03-22 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2655 4443 opera:ft:17163613
78761 2026-03-22 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2655 4443 opera:ft:17163612
78760 2026-03-22 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #2655 4443 opera:ft:17163611
78759 2026-03-22 charge 2003 In-Room Dining Dinner DNR 32.00 reservation #2655 4443 opera:ft:17163610
78758 2026-03-22 charge 3511 IRD Dinner Sales Tax 2.88 reservation #2975 5627 opera:ft:17163609
78757 2026-03-22 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2975 5627 opera:ft:17163608
78756 2026-03-22 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2975 5627 opera:ft:17163607
78755 2026-03-22 charge 2007 In-Room Dining Service Charg... RST 5.20 reservation #2975 5627 opera:ft:17163606
78754 2026-03-22 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #2975 5627 opera:ft:17163605
78753 2026-03-22 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #2975 5627 opera:ft:17163604
78752 2026-03-22 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #2975 5627 opera:ft:17163603
78751 2026-03-22 charge 2008 In Room Dining Gratuity NRV 8.00 reservation #2975 5627 opera:ft:17163602
78750 2026-03-22 charge 2003 In-Room Dining Dinner DNR 26.00 reservation #2975 5627 opera:ft:17163601
78749 2026-03-22 payment 9027 F&B Mastercard CARD -62.37 houseAccount #23 7480 opera:ft:17163600
Sum (balance): -22,808.80