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 1523/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
285017 2026-05-31 credit 8105 Shopify Commission ALW -8.73 guest #9954 17767 opera:ft:17430087
285016 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #9954 17767 opera:ft:17430086
285015 2026-05-31 charge 7033 Spa Package SPA -4.53 guest #9954 17767 opera:ft:17430085
285014 2026-05-31 charge 9996 Spa Package Profit 86.83 guest #9952 16714 opera:ft:17430082
285013 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9952 17800 opera:ft:17430080
285012 2026-05-31 payment 9000 Cash CASH -15.00 guest #9952 16714 opera:ft:17430077
285011 2026-05-31 charge 9996 Spa Package Profit 62.02 guest #9951 16712 opera:ft:17430076
285010 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9951 17766 opera:ft:17430074
285009 2026-05-31 payment 9007 Master Card CARD -141.37 guest #9951 16712 opera:ft:17430071
285008 2026-05-31 charge 9996 Spa Package Profit 74.43 guest #9886 16505 opera:ft:17430070
285007 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9886 17756 opera:ft:17430068
285006 2026-05-31 payment 9008 Visa CARD -117.25 guest #9886 16505 opera:ft:17430065
285005 2026-05-31 credit 8105 Shopify Commission ALW -8.73 guest #9886 17756 opera:ft:17430064
285004 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #9886 17756 opera:ft:17430063
285003 2026-05-31 charge 7033 Spa Package SPA -4.53 guest #9886 17756 opera:ft:17430062
285002 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9839 17768 opera:ft:17430059
285001 2026-05-31 payment 9008 Visa CARD -21.20 guest #9839 16388 opera:ft:17430058
285000 2026-05-31 charge 9996 Spa Package Profit 148.86 guest #9229 14537 opera:ft:17430057
284999 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 17.76 guest #9229 17771 opera:ft:17430055
284998 2026-05-31 payment 9008 Visa CARD -93.10 guest #9229 14537 opera:ft:17430052
284997 2026-05-31 credit 8105 Shopify Commission ALW -17.46 guest #9229 17771 opera:ft:17430051
284996 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #9229 17771 opera:ft:17430050
284995 2026-05-31 charge 7033 Spa Package SPA -9.06 guest #9229 17771 opera:ft:17430049
284994 2026-05-31 charge 9996 Spa Package Profit 86.83 guest #9123 14286 opera:ft:17430046
284993 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #9123 17753 opera:ft:17430044
284992 2026-05-31 credit 8105 Shopify Commission ALW -8.73 guest #9123 17753 opera:ft:17430043
284991 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #9123 17753 opera:ft:17430042
284990 2026-05-31 charge 7033 Spa Package SPA -4.53 guest #9123 17753 opera:ft:17430041
284989 2026-05-31 charge 9996 Spa Package Profit 74.43 guest #671 13740 opera:ft:17430038
284988 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #671 17808 opera:ft:17430036
284987 2026-05-31 credit 8105 Shopify Commission ALW -8.73 guest #671 17808 opera:ft:17430035
284986 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #671 17808 opera:ft:17430034
284985 2026-05-31 charge 7033 Spa Package SPA -4.53 guest #671 17808 opera:ft:17430033
284984 2026-05-31 charge 9996 Spa Package Profit 86.83 guest #8958 13724 opera:ft:17430030
284983 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8958 17757 opera:ft:17430028
284982 2026-05-31 payment 9010 Discover CARD -151.79 guest #8958 13724 opera:ft:17430025
284981 2026-05-31 credit 8105 Shopify Commission ALW -8.73 guest #8958 17757 opera:ft:17430024
284980 2026-05-31 credit 8105 Shopify Commission ALW -0.30 guest #8958 17757 opera:ft:17430023
284979 2026-05-31 charge 7033 Spa Package SPA -4.53 guest #8958 17757 opera:ft:17430022
284978 2026-05-31 transfer 9003 Direct Bill DIRECT_BILL 9.03 guest #8504 17770 opera:ft:17430019
284977 2026-05-31 payment 9006 American Express CARD -30.00 reservation #5249 15386 opera:ft:17430018
284976 2026-05-31 payment 9008 Visa CARD -643.36 reservation #3409 7327 opera:ft:17430017
284975 2026-05-31 payment 9010 Discover CARD -311.70 reservation #4440 11386 opera:ft:17430016
284974 2026-05-31 payment 9007 Master Card CARD -80.00 reservation #2999 5731 opera:ft:17430011
284973 2026-05-31 payment 9008 Visa CARD -185.00 reservation #1929 3197 opera:ft:17430010
284972 2026-05-31 payment 9008 Visa CARD -45.00 reservation #2779 4928 opera:ft:17430009
284971 2026-05-31 payment 9008 Visa CARD -160.00 reservation #4577 11950 opera:ft:17430008
284970 2026-05-31 charge 3511 IRD Dinner Sales Tax 2.88 reservation #5176 15009 opera:ft:17430007
284969 2026-05-31 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5176 15009 opera:ft:17430006
284968 2026-05-31 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5176 15009 opera:ft:17430005
284967 2026-05-31 charge 2007 In-Room Dining Service Charg... RST 5.20 reservation #5176 15009 opera:ft:17430004
284966 2026-05-31 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5176 15009 opera:ft:17430003
284965 2026-05-31 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5176 15009 opera:ft:17430002
284964 2026-05-31 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #5176 15009 opera:ft:17430001
284963 2026-05-31 charge 2008 In Room Dining Gratuity NRV 4.00 reservation #5176 15009 opera:ft:17430000
284962 2026-05-31 charge 2003 In-Room Dining Dinner DNR 26.00 reservation #5176 15009 opera:ft:17429999
284961 2026-05-31 charge 2018 Alcohol Sales Tax 4.37 reservation #569 1308 opera:ft:17429998
284960 2026-05-31 charge 3205 Terras Dinner Sales Tax 4.84 reservation #569 1308 opera:ft:17429997
284959 2026-05-31 charge 2094 Terras Dinner Gratuity NRV 25.00 reservation #569 1308 opera:ft:17429996
284958 2026-05-31 charge 2086 Terras Dinner Wine ALC 47.00 reservation #569 1308 opera:ft:17429995
284957 2026-05-31 charge 2084 Terras Dinner DNR 52.00 reservation #569 1308 opera:ft:17429994
284956 2026-05-31 charge 2058 Food Retail Sales Tax 0.84 reservation #5739 17793 opera:ft:17429993
284955 2026-05-31 charge 3511 IRD Dinner Sales Tax 5.49 reservation #5739 17793 opera:ft:17429992
284954 2026-05-31 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5739 17793 opera:ft:17429991
284953 2026-05-31 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5739 17793 opera:ft:17429990
284952 2026-05-31 charge 2007 In-Room Dining Service Charg... RST 12.60 reservation #5739 17793 opera:ft:17429989
284951 2026-05-31 charge 2201 In-Room Dining Service Charg... RST -2.50 reservation #5739 17793 opera:ft:17429988
284950 2026-05-31 charge 2000 In-Room Dining Delivery Fee RST 2.50 reservation #5739 17793 opera:ft:17429987
284949 2026-05-31 charge 2007 In-Room Dining Service Charg... RST 5.00 reservation #5739 17793 opera:ft:17429986
284948 2026-05-31 charge 2184 In Room Dining Food Retail RST 9.00 reservation #5739 17793 opera:ft:17429985
284947 2026-05-31 charge 2003 In-Room Dining Dinner DNR 54.00 reservation #5739 17793 opera:ft:17429984
284946 2026-05-31 payment 9008 Visa CARD -104.55 reservation #5602 17251 opera:ft:17429983
284945 2026-05-31 charge 8503 Marketing Comp MSC -15.74 reservation #5602 17456 opera:ft:17429982 20% of ancillary
284944 2026-05-31 charge 7014 Spa Sales Tax 13.60 reservation #5504 16731 opera:ft:17429981 SALAVERRIA
284943 2026-05-31 charge 7012 Spa Service Charge SPA 146.30 reservation #5504 16731 opera:ft:17429980 SALAVERRIA
284942 2026-05-31 charge 7002 Spa Massage SPA 665.00 reservation #5504 16731 opera:ft:17429979 SALAVERRIA
284941 2026-05-31 charge 2226 Seed Retail Books RST -10.40 reservation #5602 17251 opera:ft:17429978 20% ancillary not applied
284940 2026-05-31 payment 9007 Master Card CARD -42.27 guest #10114 17137 opera:ft:17429977
284939 2026-05-31 charge 7014 Spa Sales Tax 4.40 reservation #5236 15352 opera:ft:17429976 RAMASWAMI
284938 2026-05-31 charge 7012 Spa Service Charge SPA 47.30 reservation #5236 15352 opera:ft:17429975 RAMASWAMI
284937 2026-05-31 charge 7002 Spa Massage SPA 215.00 reservation #5236 15352 opera:ft:17429974 RAMASWAMI
284936 2026-05-31 charge 8026 Retail sales tax 8.37 houseAccount #24 17732 opera:ft:17429973 IN HOUSE COMPS
284935 2026-05-31 charge 7127 Fitness Boutique - Books CLS 90.00 houseAccount #24 17732 opera:ft:17429972 IN HOUSE COMPS
284934 2026-05-31 charge 7014 Spa Sales Tax 6.54 reservation #5176 15009 opera:ft:17429971 SANDERS
284933 2026-05-31 charge 7012 Spa Service Charge SPA 70.40 reservation #5176 15009 opera:ft:17429970 SANDERS
284932 2026-05-31 charge 7002 Spa Massage SPA 320.00 reservation #5176 15009 opera:ft:17429969 SANDERS
284931 2026-05-31 charge 7014 Spa Sales Tax 5.01 houseAccount #13 17710 opera:ft:17429968
284930 2026-05-31 charge 7012 Spa Service Charge SPA 53.90 houseAccount #13 17710 opera:ft:17429967
284929 2026-05-31 charge 7002 Spa Massage SPA 245.00 houseAccount #13 17710 opera:ft:17429966
284928 2026-05-31 charge 7014 Spa Sales Tax 13.61 houseAccount #12 17707 opera:ft:17429965
284927 2026-05-31 charge 7012 Spa Service Charge SPA 146.30 houseAccount #12 17707 opera:ft:17429964
284926 2026-05-31 charge 7000 Spa Skin Care SPA 235.00 houseAccount #12 17707 opera:ft:17429963
284925 2026-05-31 charge 7002 Spa Massage SPA 430.00 houseAccount #12 17707 opera:ft:17429962
284924 2026-05-31 charge 7014 Spa Sales Tax 9.52 houseAccount #14 17708 opera:ft:17429961
284923 2026-05-31 charge 7012 Spa Service Charge SPA 102.30 houseAccount #14 17708 opera:ft:17429960
284922 2026-05-31 charge 7002 Spa Massage SPA 465.00 houseAccount #14 17708 opera:ft:17429959
284921 2026-05-31 charge 7013 Spa Gratuity NRV 0.27 houseAccount #12 17707 opera:ft:17429958
284920 2026-05-31 charge 7014 Spa Sales Tax 5.93 houseAccount #12 17707 opera:ft:17429957
284919 2026-05-31 charge 7012 Spa Service Charge SPA 63.80 houseAccount #12 17707 opera:ft:17429956
284918 2026-05-31 charge 7002 Spa Massage SPA 290.00 houseAccount #12 17707 opera:ft:17429955
Sum (balance): 2,363.65