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

Ledger transactions (folio_transactions)

Reset
460315 rows (page 1899/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
249156 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #6014 15593 opera:ft:17388768
249155 2026-05-16 credit 8105 Shopify Commission ALW -17.46 guest #6014 15593 opera:ft:17388767
249154 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #6014 15593 opera:ft:17388766
249153 2026-05-16 charge 7033 Spa Package SPA 15.74 guest #6014 15593 opera:ft:17388765
249152 2026-05-16 charge 3205 Terras Dinner Sales Tax 16.18 reservation #4723 12537 opera:ft:17388762
249151 2026-05-16 charge 1698 Terras Dinner Service Charge DNR 31.32 reservation #4723 12537 opera:ft:17388761
249150 2026-05-16 charge 2084 Terras Dinner DNR 174.00 reservation #4723 12537 opera:ft:17388760
249149 2026-05-16 charge 7510 Paid Class - Yoga CLS 40.00 guest #8223 11787 opera:ft:17388759
249148 2026-05-16 charge 9996 Spa Package Profit 341.13 guest #3176 2538 opera:ft:17388758
249147 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #3176 15627 opera:ft:17388756
249146 2026-05-16 charge 7510 Paid Class - Yoga CLS 40.00 reservation #5170 14991 opera:ft:17388755
249145 2026-05-16 credit 8105 Shopify Commission ALW -8.73 guest #3176 15627 opera:ft:17388754
249144 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #3176 15627 opera:ft:17388753
249143 2026-05-16 charge 7033 Spa Package SPA 7.87 guest #3176 15627 opera:ft:17388752
249142 2026-05-16 charge 7510 Paid Class - Yoga CLS 80.00 reservation #3940 9290 opera:ft:17388749
249141 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 26.49 guest #889 15587 opera:ft:17388748
249140 2026-05-16 charge 7800 Programs Sales Tax 3.40 reservation #4784 12983 opera:ft:17388747
249139 2026-05-16 charge 8096 No Show Class CLS 40.00 reservation #4784 12983 opera:ft:17388746
249138 2026-05-16 charge 7510 Paid Class - Yoga CLS 40.00 reservation #4965 13776 opera:ft:17388745
249137 2026-05-16 charge 7510 Paid Class - Yoga CLS 40.00 reservation #4913 13442 opera:ft:17388744
249136 2026-05-16 charge 3205 Terras Dinner Sales Tax 11.35 reservation #3261 6694 opera:ft:17388743
249135 2026-05-16 charge 1698 Terras Dinner Service Charge DNR 21.96 reservation #3261 6694 opera:ft:17388742
249134 2026-05-16 charge 2084 Terras Dinner DNR 122.00 reservation #3261 6694 opera:ft:17388741
249133 2026-05-16 payment 9028 F&B Visa CARD -70.71 houseAccount #19 15557 opera:ft:17388740
249132 2026-05-16 charge 2018 Alcohol Sales Tax 1.30 houseAccount #19 15557 opera:ft:17388739
249131 2026-05-16 charge 3205 Terras Dinner Sales Tax 3.61 houseAccount #19 15557 opera:ft:17388738
249130 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 13.00 houseAccount #19 15557 opera:ft:17388737
249129 2026-05-16 charge 2087 Terras Dinner Liquor ALC 14.00 houseAccount #19 15557 opera:ft:17388736
249128 2026-05-16 charge 2084 Terras Dinner DNR 38.80 houseAccount #19 15557 opera:ft:17388735
249127 2026-05-16 charge 7800 Programs Sales Tax 2.55 guest #8619 12822 opera:ft:17388734
249126 2026-05-16 charge 8096 No Show Class CLS 30.00 guest #8619 12822 opera:ft:17388733
249125 2026-05-16 payment 9028 F&B Visa CARD -75.17 houseAccount #19 15557 opera:ft:17388732
249124 2026-05-16 charge 2018 Alcohol Sales Tax 1.30 houseAccount #19 15557 opera:ft:17388731
249123 2026-05-16 charge 3205 Terras Dinner Sales Tax 4.07 houseAccount #19 15557 opera:ft:17388730
249122 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 12.00 houseAccount #19 15557 opera:ft:17388729
249121 2026-05-16 charge 2087 Terras Dinner Liquor ALC 14.00 houseAccount #19 15557 opera:ft:17388728
249120 2026-05-16 charge 2084 Terras Dinner DNR 43.80 houseAccount #19 15557 opera:ft:17388727
249119 2026-05-16 payment 9028 F&B Visa CARD -70.81 houseAccount #19 15557 opera:ft:17388726
249118 2026-05-16 charge 2018 Alcohol Sales Tax 1.40 houseAccount #19 15557 opera:ft:17388725
249117 2026-05-16 charge 3205 Terras Dinner Sales Tax 3.61 houseAccount #19 15557 opera:ft:17388724
249116 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 12.00 houseAccount #19 15557 opera:ft:17388723
249115 2026-05-16 charge 2086 Terras Dinner Wine ALC 15.00 houseAccount #19 15557 opera:ft:17388722
249114 2026-05-16 charge 2084 Terras Dinner DNR 38.80 houseAccount #19 15557 opera:ft:17388721
249113 2026-05-16 payment 9008 Visa CARD -134.61 guest #889 11502 opera:ft:17388720
249112 2026-05-16 payment 9026 F&B American Express CARD -54.59 houseAccount #20 15558 opera:ft:17388719
249111 2026-05-16 charge 3205 Terras Dinner Sales Tax 3.79 houseAccount #20 15558 opera:ft:17388718
249110 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 10.00 houseAccount #20 15558 opera:ft:17388717
249109 2026-05-16 charge 2084 Terras Dinner DNR 40.80 houseAccount #20 15558 opera:ft:17388716
249108 2026-05-16 charge 9996 Spa Package Profit 74.43 guest #8218 11778 opera:ft:17388715
249107 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #8218 15610 opera:ft:17388713
249106 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8223 15595 opera:ft:17388711
249105 2026-05-16 charge 7800 Programs Sales Tax 20.31 reservationGroup #19 3206 opera:ft:17388710
249104 2026-05-16 charge 7509 Programs Service Charge CLS 218.40 reservationGroup #19 3206 opera:ft:17388709
249103 2026-05-16 charge 7021 Group Wellness Programs CLS 910.00 reservationGroup #19 3206 opera:ft:17388708
249102 2026-05-16 charge 9996 Spa Package Profit 124.04 guest #117 10666 opera:ft:17388707
249101 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #117 15594 opera:ft:17388705
249100 2026-05-16 payment 9007 Master Card CARD -91.73 guest #117 10666 opera:ft:17388702
249099 2026-05-16 credit 8105 Shopify Commission ALW -17.46 guest #117 15594 opera:ft:17388701
249098 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #117 15594 opera:ft:17388700
249097 2026-05-16 charge 7033 Spa Package SPA -9.06 guest #117 15594 opera:ft:17388699
249096 2026-05-16 charge 3205 Terras Dinner Sales Tax 7.81 reservation #4757 12813 opera:ft:17388696
249095 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 19.00 reservation #4757 12813 opera:ft:17388695
249094 2026-05-16 charge 2084 Terras Dinner DNR 84.00 reservation #4757 12813 opera:ft:17388694
249093 2026-05-16 charge 9996 Spa Package Profit 62.02 guest #261 13168 opera:ft:17388693
249092 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #261 15632 opera:ft:17388691
249091 2026-05-16 credit 8105 Shopify Commission ALW -8.73 guest #261 15632 opera:ft:17388690
249090 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #261 15632 opera:ft:17388689
249089 2026-05-16 charge 7033 Spa Package SPA -4.53 guest #261 15632 opera:ft:17388688
249088 2026-05-16 charge 9996 Spa Package Profit 99.24 guest #6643 8228 opera:ft:17388685
249087 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #6643 15592 opera:ft:17388683
249086 2026-05-16 payment 9008 Visa CARD -51.72 guest #6643 8228 opera:ft:17388680
249085 2026-05-16 credit 8105 Shopify Commission ALW -17.46 guest #6643 15592 opera:ft:17388679
249084 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #6643 15592 opera:ft:17388678
249083 2026-05-16 charge 7033 Spa Package SPA -9.06 guest #6643 15592 opera:ft:17388677
249082 2026-05-16 charge 9996 Spa Package Profit 86.83 guest #9001 13887 opera:ft:17388674
249081 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9001 15590 opera:ft:17388672
249080 2026-05-16 payment 9008 Visa CARD -98.27 guest #9001 13887 opera:ft:17388669
249079 2026-05-16 payment 9026 F&B American Express CARD -209.88 houseAccount #20 15558 opera:ft:17388668
249078 2026-05-16 charge 2018 Alcohol Sales Tax 1.30 houseAccount #20 15558 opera:ft:17388667
249077 2026-05-16 charge 3205 Terras Dinner Sales Tax 13.58 houseAccount #20 15558 opera:ft:17388666
249076 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 35.00 houseAccount #20 15558 opera:ft:17388665
249075 2026-05-16 charge 2087 Terras Dinner Liquor ALC 14.00 houseAccount #20 15558 opera:ft:17388664
249074 2026-05-16 charge 2084 Terras Dinner DNR 146.00 houseAccount #20 15558 opera:ft:17388663
249073 2026-05-16 charge 7800 Programs Sales Tax 7.37 reservationGroup #19 3206 opera:ft:17388662
249072 2026-05-16 charge 7509 Programs Service Charge CLS 79.20 reservationGroup #19 3206 opera:ft:17388661
249071 2026-05-16 charge 7021 Group Wellness Programs CLS 330.00 reservationGroup #19 3206 opera:ft:17388660
249070 2026-05-16 charge 3205 Terras Dinner Sales Tax 6.70 reservation #2178 3510 opera:ft:17388659
249069 2026-05-16 charge 1698 Terras Dinner Service Charge DNR 12.96 reservation #2178 3510 opera:ft:17388658
249068 2026-05-16 charge 2084 Terras Dinner DNR 72.00 reservation #2178 3510 opera:ft:17388657
249067 2026-05-16 credit 8105 Shopify Commission ALW -8.73 guest #9001 15590 opera:ft:17388656
249066 2026-05-16 credit 8105 Shopify Commission ALW -0.30 guest #9001 15590 opera:ft:17388655
249065 2026-05-16 charge 7033 Spa Package SPA -4.53 guest #9001 15590 opera:ft:17388654
249064 2026-05-16 charge 2018 Alcohol Sales Tax 1.40 reservation #2178 3510 opera:ft:17388651
249063 2026-05-16 charge 2094 Terras Dinner Gratuity NRV 10.00 reservation #2178 3510 opera:ft:17388650
249062 2026-05-16 charge 2086 Terras Dinner Wine ALC 15.00 reservation #2178 3510 opera:ft:17388649
249061 2026-05-16 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #3753 15824 opera:ft:17388648 canceled 05.16 06:20am
249060 2026-05-16 charge 7515 Class Late Cancellation Fee CLS 45.00 reservation #2700 16064 opera:ft:17388647 Amie, April, Rohini canceled 05.16 02:24...
249059 2026-05-16 charge 9996 Spa Package Profit 86.83 guest #8962 13721 opera:ft:17388646
249058 2026-05-16 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8962 15596 opera:ft:17388644
249057 2026-05-16 payment 9008 Visa CARD -99.31 guest #8962 13721 opera:ft:17388641
Sum (balance): 3,004.53