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

Ledger transactions (folio_transactions)

Reset
412342 rows (page 47/4124)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
407742 2026-07-07 charge 1000 Room Charge RTX 278.10 reservation #1252 reservation #1252 2322 3820 charge:folioItem:3820 Room Rate
407741 2026-07-07 charge 3505 Spa Treatment SPA 279.10 reservation #924 reservation #924 1848 180743 packageWash:revenue:folioItem:180743:2026-07-07 INC SPA — package allowance
407740 2026-07-07 charge 1011 Sales Tax 29.78 reservation #924 reservation #924 1848 180742 packageWash:tax:folioItem:180742:2026-07-07 F&B Inclusive (Corporate) — package allo...
407739 2026-07-07 charge 2079 F&B Charges DNR 320.22 reservation #924 reservation #924 1848 180742 packageWash:revenue:folioItem:180742:2026-07-07 F&B Inclusive (Corporate) — package allo...
407738 2026-07-07 charge 1011 Sales Tax 21.27 reservation #924 reservation #924 1848 180741 packageWash:tax:folioItem:180741:2026-07-07 INC F&B — package allowance tax
407737 2026-07-07 charge 2079 F&B Charges DNR 228.73 reservation #924 reservation #924 1848 180741 packageWash:revenue:folioItem:180741:2026-07-07 INC F&B — package allowance
407736 2026-07-07 charge 1000 Room Charge RTX 1,241.45 reservation #924 reservation #924 1848 2837 charge:folioItem:2837 Room Rate
407735 2026-07-07 charge 3505 Spa Treatment SPA 279.10 reservation #895 reservation #895 1818 180732 packageWash:revenue:folioItem:180732:2026-07-07 INC SPA — package allowance
407734 2026-07-07 charge 1011 Sales Tax 29.78 reservation #895 reservation #895 1818 180731 packageWash:tax:folioItem:180731:2026-07-07 F&B Inclusive (Corporate) — package allo...
407733 2026-07-07 charge 2079 F&B Charges DNR 320.22 reservation #895 reservation #895 1818 180731 packageWash:revenue:folioItem:180731:2026-07-07 F&B Inclusive (Corporate) — package allo...
407732 2026-07-07 charge 1011 Sales Tax 21.27 reservation #895 reservation #895 1818 180730 packageWash:tax:folioItem:180730:2026-07-07 INC F&B — package allowance tax
407731 2026-07-07 charge 2079 F&B Charges DNR 228.73 reservation #895 reservation #895 1818 180730 packageWash:revenue:folioItem:180730:2026-07-07 INC F&B — package allowance
407730 2026-07-07 charge 1000 Room Charge RTX -115.85 reservation #895 reservation #895 1818 2739 charge:folioItem:2739 Room Rate
407729 2026-07-07 charge 1000 Room Charge RTX 278.10 reservation #748 reservation #748 1627 2305 charge:folioItem:2305 Room Rate
407728 2026-07-07 charge 1000 Room Charge RTX 314.30 reservation #343 reservation #343 1104 1052 charge:folioItem:1052 Room Rate
407727 2026-07-07 charge 1000 Room Charge RTX 216.75 reservation #127 reservation #127 695 384 charge:folioItem:384 Room Rate
407726 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -7,905.38 reservationGroup #168 reservationGroup #168 23856 payment:25888 elavon Group deposit - FAKE commodi expedita
407725 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -9,400.99 reservationGroup #168 reservationGroup #168 23856 payment:25887 elavon Group deposit - FAKE commodi expedita
407724 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -8,332.70 reservationGroup #168 reservationGroup #168 23856 payment:25886 elavon Group deposit - FAKE commodi expedita
407723 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -13,380.08 reservationGroup #167 reservationGroup #167 23855 payment:25885 elavon Group deposit - FAKE recusandae corporis
407722 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -17,036.42 reservationGroup #166 reservationGroup #166 23854 payment:25884 elavon Group deposit - FAKE tenetur quasi
407721 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -10,647.76 reservationGroup #166 reservationGroup #166 23854 payment:25883 elavon Group deposit - FAKE tenetur quasi
407720 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -6,222.62 reservationGroup #165 reservationGroup #165 23853 payment:25882 elavon Group deposit - FAKE aut ex
407719 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -8,202.54 reservationGroup #165 reservationGroup #165 23853 payment:25881 elavon Group deposit - FAKE aut ex
407718 2026-07-07 payment UNMAPPED Unmapped — needs finance cod... -7,495.42 reservationGroup #165 reservationGroup #165 23853 payment:25880 elavon Group deposit - FAKE aut ex
407717 2026-07-07 transfer 9989 Deposit Transfered at C/I (I... -575.97 reservation #7289 reservation #7289 23859 deposit:transfer:folio:2671 Deposit Transferred
407716 2026-07-07 transfer 9989 Deposit Transfered at C/I (I... 575.97 reservationDeposit #2671 reservation #7289 23859 deposit:transfer:release:2671 Deposit Transferred
407715 2026-07-07 payment 9100 Advance Deposits -575.97 reservationDeposit #2671 reservation #7289 23859 payment:25890 Advance Deposit Advance deposit
407714 2026-07-07 transfer 9989 Deposit Transfered at C/I (I... -1,069.28 reservation #7287 reservation #7287 23857 deposit:transfer:folio:2670 Deposit Transferred
407713 2026-07-07 transfer 9989 Deposit Transfered at C/I (I... 1,069.28 reservationDeposit #2670 reservation #7287 23857 deposit:transfer:release:2670 Deposit Transferred
407712 2026-07-07 payment 9100 Advance Deposits -1,069.28 reservationDeposit #2670 reservation #7287 23857 payment:25889 Advance Deposit Advance deposit
407711 2026-07-06 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:17527080 cash_drop
395292 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -761.84 reservation #4118 10187 opera:deposit-application:9989:17526952,17526953:1432:17526953:credit Advance Deposit Applied
395291 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 761.84 advanceDeposit #1432 10187 opera:deposit-application:9989:17526952,17526953:1432:17526953:release Advance Deposit Applied
395290 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -1,095.31 reservation #5978 18848 opera:deposit-application:9989:17526871,17526872:4600:17526872:credit Advance Deposit Applied
395289 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 1,095.31 advanceDeposit #4600 18848 opera:deposit-application:9989:17526871,17526872:4600:17526872:release Advance Deposit Applied
395288 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -1,087.74 reservation #4275 10852 opera:deposit-application:9989:17526797,17526798:1466:17526798:credit Advance Deposit Applied
395287 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 1,087.74 advanceDeposit #1466 10852 opera:deposit-application:9989:17526797,17526798:1466:17526798:release Advance Deposit Applied
395286 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -1,291.62 reservation #5692 17674 opera:deposit-application:9989:17526795,17526796:2132:17526796:credit Advance Deposit Applied
395285 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 1,291.62 advanceDeposit #2132 17674 opera:deposit-application:9989:17526795,17526796:2132:17526796:release Advance Deposit Applied
395284 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 362.58 reservation #117 679 opera:deposit-application-reversal:9989:17526782,17526783:4820:17526783:credit-reversal Advance Deposit Application Reversed
395283 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -362.58 advanceDeposit #4820 679 opera:deposit-application-reversal:9989:17526782,17526783:4820:17526783:funding Advance Deposit Application Reversed
395282 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -362.58 reservation #117 679 opera:deposit-application:9989:17526780,17526781:4916:17526781:credit Advance Deposit Applied
395281 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 362.58 advanceDeposit #4916 679 opera:deposit-application:9989:17526780,17526781:4916:17526781:release Advance Deposit Applied
395280 2026-07-06 deposit_opening_balance DEPOSIT_OPENING Advance Deposit Migration Op... -362.58 advanceDeposit #4916 679 opera:deposit-opening:606b5d67a9c71f569f7a6f86096604cdd8698ba52691d47c7d4f64eb54632ee2 Declared Migration Accounting Policy Advance deposit migration opening balanc...
395279 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -362.58 reservation #117 679 opera:deposit-application:9989:17526778,17526779:2856:17526779:credit Advance Deposit Applied
395278 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 362.58 advanceDeposit #2856 679 opera:deposit-application:9989:17526778,17526779:2856:17526779:release Advance Deposit Applied
395277 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -833.88 reservation #6412 20478 opera:deposit-application:9989:17526681,17526682:2369:17526682:credit Advance Deposit Applied
395276 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 833.88 advanceDeposit #2369 20478 opera:deposit-application:9989:17526681,17526682:2369:17526682:release Advance Deposit Applied
395275 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -549.00 guest #12438 23699 opera:deposit-application:9989:17526464,17526465:4783:17526465:credit Advance Deposit Applied
395274 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 549.00 advanceDeposit #4783 23699 opera:deposit-application:9989:17526464,17526465:4783:17526465:release Advance Deposit Applied
395273 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -1,087.71 reservation #6031 23677 opera:deposit-application:9989:17526351,17526352:4781:17526352:credit Advance Deposit Applied
395272 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 1,087.71 advanceDeposit #4781 23677 opera:deposit-application:9989:17526351,17526352:4781:17526352:release Advance Deposit Applied
395271 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -982.89 reservation #5806 18093 opera:deposit-application:9989:17526295,17526296:2154:17526296:credit Advance Deposit Applied
395270 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 982.89 advanceDeposit #2154 18093 opera:deposit-application:9989:17526295,17526296:2154:17526296:release Advance Deposit Applied
395269 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #12013 23670 opera:deposit-application:9989:17526200,17526201:4749:17526201:credit Advance Deposit Applied
395268 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4749 23670 opera:deposit-application:9989:17526200,17526201:4749:17526201:release Advance Deposit Applied
395267 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #12008 23669 opera:deposit-application:9989:17526197,17526198:4746:17526198:credit Advance Deposit Applied
395266 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4746 23669 opera:deposit-application:9989:17526197,17526198:4746:17526198:release Advance Deposit Applied
395265 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #12014 23668 opera:deposit-application:9989:17526194,17526195:4750:17526195:credit Advance Deposit Applied
395264 2026-07-06 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4750 23668 opera:deposit-application:9989:17526194,17526195:4750:17526195:release Advance Deposit Applied
387607 2026-07-06 payment 9031 Shopify Reservation CARD -549.00 advanceDeposit #4783 23686 opera:deposit-receipt:17526397 Advance Deposit Receipt
387606 2026-07-06 payment 9008 Visa CARD -6,000.00 advanceDeposit #4782 23658 opera:deposit-receipt:17526392 Advance Deposit Receipt
387605 2026-07-06 payment 9006 American Express CARD -1,087.71 advanceDeposit #4781 19081 opera:deposit-receipt:17526042 Advance Deposit Receipt
384003 2026-07-06 charge 2058 Food Retail Sales Tax 0.47 reservation #5834 18221 opera:ft:17527191
384002 2026-07-06 charge 2116 Seed Lunch Sales Tax 0.74 reservation #5834 18221 opera:ft:17527190
384001 2026-07-06 charge 2104 Food Retail RST 13.00 reservation #5834 18221 opera:ft:17527189
384000 2026-07-06 charge 7014 Spa Sales Tax 4.81 reservation #5117 14586 opera:ft:17527188 O'BRIEN
383999 2026-07-06 charge 7012 Spa Service Charge SPA 51.70 reservation #5117 14586 opera:ft:17527187 O'BRIEN
383998 2026-07-06 charge 7000 Spa Skin Care SPA 235.00 reservation #5117 14586 opera:ft:17527186 O'BRIEN
383997 2026-07-06 charge 7515 Class Late Cancellation Fee CLS 15.00 reservation #5850 18268 opera:ft:17527185
383996 2026-07-06 charge 7014 Spa Sales Tax 4.40 reservation #4601 12066 opera:ft:17527184 MILANI
383995 2026-07-06 charge 7012 Spa Service Charge SPA 47.30 reservation #4601 12066 opera:ft:17527183 MILANI
383994 2026-07-06 charge 7002 Spa Massage SPA 215.00 reservation #4601 12066 opera:ft:17527182 MILANI
383993 2026-07-06 charge 7014 Spa Sales Tax 5.12 reservation #5118 14587 opera:ft:17527181 O'BRIEN
383992 2026-07-06 charge 7012 Spa Service Charge SPA 55.00 reservation #5118 14587 opera:ft:17527180 O'BRIEN
383991 2026-07-06 charge 7002 Spa Massage SPA 250.00 reservation #5118 14587 opera:ft:17527179 O'BRIEN
383990 2026-07-06 charge 2140 Terras Lunch Sales Tax 5.02 reservation #5054 14290 opera:ft:17527178
383989 2026-07-06 charge 2083 Terras Lunch LUN 54.00 reservation #5054 14290 opera:ft:17527177
383988 2026-07-06 charge 2140 Terras Lunch Sales Tax 3.91 reservation #5614 17328 opera:ft:17527176
383987 2026-07-06 charge 2141 Terras Lunch Gratuity NRV 10.00 reservation #5614 17328 opera:ft:17527175
383986 2026-07-06 charge 2083 Terras Lunch LUN 42.00 reservation #5614 17328 opera:ft:17527174
383985 2026-07-06 charge 2140 Terras Lunch Sales Tax 2.42 reservation #5300 15646 opera:ft:17527173
383984 2026-07-06 charge 2141 Terras Lunch Gratuity NRV 4.00 reservation #5300 15646 opera:ft:17527172
383983 2026-07-06 charge 2083 Terras Lunch LUN 26.00 reservation #5300 15646 opera:ft:17527171
383982 2026-07-06 charge 2140 Terras Lunch Sales Tax 2.33 reservation #6150 19532 opera:ft:17527170
383981 2026-07-06 charge 2141 Terras Lunch Gratuity NRV 5.00 reservation #6150 19532 opera:ft:17527169
383980 2026-07-06 charge 2083 Terras Lunch LUN 25.00 reservation #6150 19532 opera:ft:17527168
383979 2026-07-06 charge 2018 Alcohol Sales Tax 2.42 reservation #4218 10689 opera:ft:17527167
383978 2026-07-06 charge 2140 Terras Lunch Sales Tax 4.09 reservation #4218 10689 opera:ft:17527166
383977 2026-07-06 charge 2141 Terras Lunch Gratuity NRV 16.00 reservation #4218 10689 opera:ft:17527165
383976 2026-07-06 charge 3522 Terras Lunch Beer ALC 7.00 reservation #4218 10689 opera:ft:17527164
383975 2026-07-06 charge 3516 Terras Lunch Liquor ALC 19.00 reservation #4218 10689 opera:ft:17527163
383974 2026-07-06 charge 2083 Terras Lunch LUN 44.00 reservation #4218 10689 opera:ft:17527162
383973 2026-07-06 charge 7124 Fitness Boutique - Apparel CLS 64.00 houseAccount #13 23628 opera:ft:17527161
383972 2026-07-06 charge 8026 Retail sales tax 5.95 houseAccount #13 23628 opera:ft:17527160
383971 2026-07-06 payment 9031 Shopify Reservation CARD -698.00 guest #2933 23747 opera:ft:17527159
383970 2026-07-06 charge 7014 Spa Sales Tax 5.42 houseAccount #13 23628 opera:ft:17527158
383969 2026-07-06 charge 7012 Spa Service Charge SPA 58.30 houseAccount #13 23628 opera:ft:17527157
383968 2026-07-06 charge 7002 Spa Massage SPA 265.00 houseAccount #13 23628 opera:ft:17527156
Sum (balance): -93,427.00