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 1881/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
250846 2026-05-17 charge 3520 In Room Dining Lunch Wine ALC 15.00 houseAccount #28 15652 opera:ft:17390702
250845 2026-05-17 charge 8531 Use Tax 5.6% 0.24 houseAccount #28 15652 opera:ft:17390701
250844 2026-05-17 charge 1977 Cost of Sales - Food Outlet... RST 4.20 houseAccount #28 15652 opera:ft:17390700
250843 2026-05-17 charge 8601 Rooms-COMP - Food MSC -4.44 houseAccount #28 15652 opera:ft:17390699
250842 2026-05-17 credit 2020 IRD Lunch Food Discount DSC -14.00 houseAccount #28 15652 opera:ft:17390698
250841 2026-05-17 charge 2002 In-Room Dining Lunch LUN 14.00 houseAccount #28 15652 opera:ft:17390697
250840 2026-05-17 charge 7014 Spa Sales Tax 5.12 reservation #2946 5477 opera:ft:17390696 BONINA
250839 2026-05-17 charge 7012 Spa Service Charge SPA 33.72 reservation #2946 5477 opera:ft:17390695 BONINA
250838 2026-05-17 charge 7012 Spa Service Charge SPA 21.28 reservation #2946 5477 opera:ft:17390694 BONINA
250837 2026-05-17 charge 7002 Spa Massage SPA 250.00 reservation #2946 5477 opera:ft:17390692 BONINA
250836 2026-05-17 charge 7014 Spa Sales Tax -5.12 houseAccount #13 15647 opera:ft:17390691
250835 2026-05-17 charge 7012 Spa Service Charge SPA -55.00 houseAccount #13 15647 opera:ft:17390690
250834 2026-05-17 charge 7002 Spa Massage SPA -250.00 houseAccount #13 15647 opera:ft:17390689
250833 2026-05-17 charge 1011 Sales Tax -8.51 reservation #4736 12666 opera:ft:17390682
250832 2026-05-17 credit 1085 Allowance F&B ALW -100.00 reservation #4736 12666 opera:ft:17390681 guest is gluten free and was given egg b...
250831 2026-05-17 charge 7014 Spa Sales Tax 4.60 guest #9278 14672 opera:ft:17390680 ECKSTADT
250830 2026-05-17 charge 7012 Spa Service Charge SPA 49.50 guest #9278 14672 opera:ft:17390679 ECKSTADT
250829 2026-05-17 charge 7002 Spa Massage SPA 225.00 guest #9278 14672 opera:ft:17390678 ECKSTADT
250828 2026-05-17 payment 9008 Visa CARD -77.45 reservation #2946 5477 opera:ft:17390676
250827 2026-05-17 charge 7014 Spa Sales Tax 4.40 guest #7837 10981 opera:ft:17390675 RICHARD
250826 2026-05-17 charge 7012 Spa Service Charge SPA 47.30 guest #7837 10981 opera:ft:17390674 RICHARD
250825 2026-05-17 charge 7002 Spa Massage SPA 215.00 guest #7837 10981 opera:ft:17390673 RICHARD
250824 2026-05-17 charge 2174 INCLU Rate Inclusion -328.72 reservation #2946 5477 opera:ft:17390672 honoring 2freespa promo
250823 2026-05-17 charge 7127 Fitness Boutique - Books CLS 18.00 houseAccount #13 15647 opera:ft:17390671
250822 2026-05-17 charge 8026 Retail sales tax 1.00 houseAccount #13 15647 opera:ft:17390670
250821 2026-05-17 charge 7002 Spa Massage SPA -7.20 houseAccount #13 15647 opera:ft:17390669
250820 2026-05-17 payment 9008 Visa CARD -149.31 reservation #4530 11790 opera:ft:17390667
250819 2026-05-17 charge 7014 Spa Sales Tax 4.40 guest #5668 5968 opera:ft:17390666 OWENS
250818 2026-05-17 charge 7012 Spa Service Charge SPA 47.30 guest #5668 5968 opera:ft:17390665 OWENS
250817 2026-05-17 charge 7002 Spa Massage SPA 215.00 guest #5668 5968 opera:ft:17390664 OWENS
250816 2026-05-17 charge 7014 Spa Sales Tax 4.81 guest #5600 5754 opera:ft:17390663 MAXIME
250815 2026-05-17 charge 7012 Spa Service Charge SPA 51.70 guest #5600 5754 opera:ft:17390662 MAXIME
250814 2026-05-17 charge 7002 Spa Massage SPA 235.00 guest #5600 5754 opera:ft:17390661 MAXIME
250813 2026-05-17 charge 7014 Spa Sales Tax 5.12 guest #8433 12189 opera:ft:17390660 WILSON
250812 2026-05-17 charge 7012 Spa Service Charge SPA 55.00 guest #8433 12189 opera:ft:17390659 WILSON
250811 2026-05-17 charge 7002 Spa Massage SPA 250.00 guest #8433 12189 opera:ft:17390658 WILSON
250810 2026-05-17 charge 3007 Amusement Tax 4.44 reservation #2384 3820 opera:ft:17390657
250809 2026-05-17 charge 7024 Spa Access Tax inclusive SPA 75.00 reservation #2384 3820 opera:ft:17390656 SANFORD
250808 2026-05-17 payment 9008 Visa CARD -458.32 reservation #5092 14341 opera:ft:17390655
250807 2026-05-17 payment 9010 Discover CARD -276.88 reservation #4241 10732 opera:ft:17390651
250806 2026-05-17 payment 9007 Master Card CARD -652.32 reservation #5206 15140 opera:ft:17390650
250805 2026-05-17 charge 7014 Spa Sales Tax 4.81 guest #9135 14307 opera:ft:17390649 BAGGETT
250804 2026-05-17 charge 7012 Spa Service Charge SPA 51.70 guest #9135 14307 opera:ft:17390648 BAGGETT
250803 2026-05-17 charge 7002 Spa Massage SPA 235.00 guest #9135 14307 opera:ft:17390647 BAGGETT
250802 2026-05-17 payment 9008 Visa CARD -2,640.69 reservation #2839 5167 opera:ft:17390644
250801 2026-05-17 payment 9008 Visa CARD -667.01 reservation #345 1075 opera:ft:17390643
250800 2026-05-17 charge 7014 Spa Sales Tax 6.13 guest #9278 14672 opera:ft:17390642 ECKSTADT
250799 2026-05-17 charge 7012 Spa Service Charge SPA 66.00 guest #9278 14672 opera:ft:17390641 ECKSTADT
250798 2026-05-17 charge 7002 Spa Massage SPA 300.00 guest #9278 14672 opera:ft:17390640 ECKSTADT
250797 2026-05-17 payment 9006 American Express CARD -313.50 reservation #2372 3768 opera:ft:17390635
250796 2026-05-17 payment 9008 Visa CARD -1,077.06 reservation #4416 11306 opera:ft:17390634
250795 2026-05-17 payment 9007 Master Card CARD -1,077.06 reservation #4416 11306 opera:ft:17390633
250794 2026-05-17 charge 3007 Amusement Tax 4.44 reservation #4500 11648 opera:ft:17390632
250793 2026-05-17 charge 7024 Spa Access Tax inclusive SPA 75.00 reservation #4500 11648 opera:ft:17390631 OCONNOR
250792 2026-05-17 credit 7116 Apparel Discount DSC -43.20 houseAccount #13 15647 opera:ft:17390629
250791 2026-05-17 charge 7102 Apparel SPA 72.00 houseAccount #13 15647 opera:ft:17390628
250790 2026-05-17 charge 8026 Retail sales tax 2.68 houseAccount #13 15647 opera:ft:17390627
250789 2026-05-17 charge 8026 Retail sales tax 3.35 reservation #3261 6694 opera:ft:17390626 MUSTO
250788 2026-05-17 charge 7127 Fitness Boutique - Books CLS 36.00 reservation #3261 6694 opera:ft:17390625 MUSTO
250787 2026-05-17 charge 7515 Class Late Cancellation Fee CLS -80.00 reservation #4416 11306 opera:ft:17390624 Guest didnt want to join this class
250786 2026-05-17 charge 7800 Programs Sales Tax -8.51 reservation #1056 15729 opera:ft:17390623
250785 2026-05-17 charge 8096 No Show Class CLS -100.00 reservation #1056 15729 opera:ft:17390622 issues with IS they weren't able to canc...
250784 2026-05-17 charge 1010 Room Tax -4.48 reservation #1056 15729 opera:ft:17390621
250783 2026-05-17 credit 1021 Room Allowance ALW -38.25 reservation #1056 15729 opera:ft:17390620 she was told she could use the $60 break...
250782 2026-05-17 charge 8026 Retail sales tax 3.35 reservation #3120 6136 opera:ft:17390619 MCFADDEN
250781 2026-05-17 charge 7127 Fitness Boutique - Books CLS 36.00 reservation #3120 6136 opera:ft:17390618 MCFADDEN
250780 2026-05-17 payment 9006 American Express CARD 45.00 reservation #1060 2052 opera:ft:17390617
250779 2026-05-17 charge 8026 Retail sales tax 1.67 reservation #1841 3055 opera:ft:17390616 MCGILL
250778 2026-05-17 charge 7127 Fitness Boutique - Books CLS 18.00 reservation #1841 3055 opera:ft:17390615 MCGILL
250777 2026-05-17 charge 7515 Class Late Cancellation Fee CLS -45.00 reservation #1060 15743 opera:ft:17390614 had issues with IS and wasn't able to ch...
250776 2026-05-17 charge 7014 Spa Sales Tax 5.01 reservation #3384 7084 opera:ft:17390613 TAN
250775 2026-05-17 charge 7012 Spa Service Charge SPA 53.90 reservation #3384 7084 opera:ft:17390612 TAN
250774 2026-05-17 charge 7000 Spa Skin Care SPA 245.00 reservation #3384 7084 opera:ft:17390611 TAN
250773 2026-05-17 charge 8026 Retail sales tax 1.67 reservation #441 1176 opera:ft:17390610 PARRIS WATTS
250772 2026-05-17 charge 7127 Fitness Boutique - Books CLS 18.00 reservation #441 1176 opera:ft:17390609 PARRIS WATTS
250771 2026-05-17 payment 9006 American Express CARD 75.00 reservation #1059 2051 opera:ft:17390608
250770 2026-05-17 charge 8026 Retail sales tax 3.35 reservation #4736 12666 opera:ft:17390607 REA
250769 2026-05-17 charge 7127 Fitness Boutique - Books CLS 36.00 reservation #4736 12666 opera:ft:17390606 REA
250768 2026-05-17 charge 7800 Programs Sales Tax -6.38 reservation #1059 15739 opera:ft:17390605
250767 2026-05-17 charge 8096 No Show Class CLS -75.00 reservation #1059 15739 opera:ft:17390604 issue with IS and they were charged for...
250766 2026-05-17 charge 8023 Transportation Tax -0.83 reservation #334 1064 opera:ft:17390603
250765 2026-05-17 charge 8023 Transportation Tax -5.89 reservation #334 1064 opera:ft:17390602
250764 2026-05-17 charge 8021 Transportation Service Charg... MSC -8.88 reservation #334 1064 opera:ft:17390601
250763 2026-05-17 charge 8039 Transportation - Ride Share... MSC -60.00 reservation #334 1064 opera:ft:17390600 guest did not need rideshare
250762 2026-05-17 charge 7515 Class Late Cancellation Fee CLS -15.00 reservation #334 1064 opera:ft:17390599 guest said didnt sign up for this class
250761 2026-05-17 charge 8026 Retail sales tax 1.67 reservation #345 1075 opera:ft:17390598 GULATI
250760 2026-05-17 charge 7127 Fitness Boutique - Books CLS 18.00 reservation #345 1075 opera:ft:17390597 GULATI
250759 2026-05-17 charge 2098 Terras Breakfast Sales Tax 0.65 reservation #345 1075 opera:ft:17390596
250758 2026-05-17 charge 2082 Terras Breakfast BRK 7.00 reservation #345 1075 opera:ft:17390595
250757 2026-05-17 payment 9028 F&B Visa CARD -43.07 houseAccount #19 15656 opera:ft:17390594
250756 2026-05-17 charge 2098 Terras Breakfast Sales Tax 3.07 houseAccount #19 15656 opera:ft:17390593
250755 2026-05-17 charge 2221 Terras Breakfast Gratuity NRV 7.00 houseAccount #19 15656 opera:ft:17390592
250754 2026-05-17 charge 2082 Terras Breakfast BRK 33.00 houseAccount #19 15656 opera:ft:17390591
250753 2026-05-17 charge 2018 Alcohol Sales Tax 1.49 reservation #2372 3768 opera:ft:17390590
250752 2026-05-17 charge 2098 Terras Breakfast Sales Tax 3.81 reservation #2372 3768 opera:ft:17390589
250751 2026-05-17 charge 2221 Terras Breakfast Gratuity NRV 10.00 reservation #2372 3768 opera:ft:17390588
250750 2026-05-17 charge 2208 Terras Breakfast Liquor ALC 16.00 reservation #2372 3768 opera:ft:17390587
250749 2026-05-17 charge 2082 Terras Breakfast BRK 41.00 reservation #2372 3768 opera:ft:17390586
250748 2026-05-17 charge 7123 Fitness Boutique - Accesorie... CLS 70.00 reservation #3120 6136 opera:ft:17390585 MCFADDEN
250747 2026-05-17 charge 8026 Retail sales tax 6.51 reservation #3120 6136 opera:ft:17390584 MCFADDEN
Sum (balance): -5,222.69