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 1313/4604)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
305310 2026-06-09 payment 9006 American Express CARD -620.83 reservation #4305 10994 opera:ft:17453566
305309 2026-06-09 payment 9008 Visa CARD -51.67 reservation #5480 16577 opera:ft:17453565
305308 2026-06-09 payment 9007 Master Card CARD -946.72 reservation #3029 18845 opera:ft:17453561
305307 2026-06-09 charge 1010 Room Tax -45.26 reservation #3491 18974 opera:ft:17453560
305306 2026-06-09 charge 1000 Room Charge RTX -341.10 reservation #3491 18974 opera:ft:17453559 wrong room rate
305305 2026-06-09 charge 1010 Room Tax 50.04 reservation #3491 18933 opera:ft:17453558
305304 2026-06-09 charge 1000 Room Charge RTX 377.10 reservation #3491 18933 opera:ft:17453557
305303 2026-06-09 charge 1010 Room Tax -139.06 reservation #4634 12092 opera:ft:17453556
305302 2026-06-09 credit 1015 Allowance No Show ALW -1,047.90 reservation #4634 12092 opera:ft:17453555 cc declined
9860 2026-06-09 transfer 9003 Direct Bill -9.03 cityLedgerAccount #420 dayPass #1338 18993 opera:9003:17455249 Direct Bill
9859 2026-06-09 transfer 9003 Direct Bill -26.49 cityLedgerAccount #420 dayPass #1375 19053 opera:9003:17455238 Direct Bill
9858 2026-06-09 transfer 9003 Direct Bill -26.49 cityLedgerAccount #420 dayPass #1084 18989 opera:9003:17455237 Direct Bill
9857 2026-06-09 transfer 9003 Direct Bill -9.03 cityLedgerAccount #420 dayPass #1320 18986 opera:9003:17455233 Direct Bill
9856 2026-06-09 transfer 9003 Direct Bill -14.03 cityLedgerAccount #420 dayPass #1334 18988 opera:9003:17455222 Direct Bill
459912 2026-06-08 transfer 9991 Cash Drop Trans. Code (Inter... 15,346.53 opera:ft:17453033 cash_drop
459911 2026-06-08 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:17453032 cash_drop
459910 2026-06-08 transfer 9991 Cash Drop Trans. Code (Inter... 2,094.00 opera:ft:17453031 cash_drop
459909 2026-06-08 payment 9011 Electronic Check / Wire Tran... WIRE -4,333.96 cityLedgerAccount #420 opera:ft:17452397
459902 2026-06-08 payment 9011 Electronic Check / Wire Tran... WIRE -45.69 cityLedgerAccount #420 opera:ft:17452296 shopify 6/1/26
459901 2026-06-08 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:17452051 cash_drop
442594 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -3,369.20 reservation #5177 19937 opera:deposit-application:9989:17452961,17452962:4708:17452962:credit Advance Deposit Applied
442593 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 3,369.20 advanceDeposit #4708 15025 opera:deposit-application:9989:17452961,17452962:4708:17452962:release Advance Deposit Applied
442592 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,811.49 reservation #5814 18923 opera:deposit-application:9989:17452297,17452298:4981:17452298:credit Advance Deposit Applied
442591 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,811.49 advanceDeposit #4981 18923 opera:deposit-application:9989:17452297,17452298:4981:17452298:release Advance Deposit Applied
442590 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,452.00 reservation #4623 19263 opera:deposit-application:9989:17452094,17452095:1659:17452095:credit Advance Deposit Applied
442589 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,452.00 advanceDeposit #1659 12074 opera:deposit-application:9989:17452094,17452095:1659:17452095:release Advance Deposit Applied
442588 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,870.30 reservation #5037 19536 opera:deposit-application:9989:17451984,17451985:1894:17451985:credit Advance Deposit Applied
442587 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,870.30 advanceDeposit #1894 14171 opera:deposit-application:9989:17451984,17451985:1894:17451985:release Advance Deposit Applied
442586 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -3,277.36 reservation #5029 19936 opera:deposit-application:9989:17451976,17451977:4755:17451977:credit Advance Deposit Applied
442585 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 3,277.36 advanceDeposit #4755 14067 opera:deposit-application:9989:17451976,17451977:4755:17451977:release Advance Deposit Applied
442584 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,390.83 reservation #4600 19129 opera:deposit-application:9989:17451971,17451972:1643:17451972:credit Advance Deposit Applied
442583 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,390.83 advanceDeposit #1643 12034 opera:deposit-application:9989:17451971,17451972:1643:17451972:release Advance Deposit Applied
442582 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,200.54 reservation #4644 19261 opera:deposit-application:9989:17451941,17451942:1679:17451942:credit Advance Deposit Applied
442581 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,200.54 advanceDeposit #1679 12102 opera:deposit-application:9989:17451941,17451942:1679:17451942:release Advance Deposit Applied
442580 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -832.08 reservation #4620 19103 opera:deposit-application:9989:17451831,17451832:1657:17451832:credit Advance Deposit Applied
442579 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 832.08 advanceDeposit #1657 12069 opera:deposit-application:9989:17451831,17451832:1657:17451832:release Advance Deposit Applied
442578 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -872.86 reservation #5944 19110 opera:deposit-application:9989:17451799,17451800:4970:17451800:credit Advance Deposit Applied
442577 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 872.86 advanceDeposit #4970 18653 opera:deposit-application:9989:17451799,17451800:4970:17451800:release Advance Deposit Applied
442576 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -936.28 reservation #4433 19112 opera:deposit-application:9989:17451724,17451725:4314:17451725:credit Advance Deposit Applied
442575 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 936.28 advanceDeposit #4314 11376 opera:deposit-application:9989:17451724,17451725:4314:17451725:release Advance Deposit Applied
442574 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,248.12 reservation #4450 19260 opera:deposit-application:9989:17451709,17451710:1567:17451710:credit Advance Deposit Applied
442573 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,248.12 advanceDeposit #1567 11400 opera:deposit-application:9989:17451709,17451710:1567:17451710:release Advance Deposit Applied
442572 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,390.83 reservation #4376 19259 opera:deposit-application:9989:17451698,17451699:1515:17451699:credit Advance Deposit Applied
442571 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,390.83 advanceDeposit #1515 11179 opera:deposit-application:9989:17451698,17451699:1515:17451699:release Advance Deposit Applied
442570 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,404.42 reservation #5073 18992 opera:deposit-application:9989:17451632,17451633:1913:17451633:credit Advance Deposit Applied
442569 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,404.42 advanceDeposit #1913 14305 opera:deposit-application:9989:17451632,17451633:1913:17451633:release Advance Deposit Applied
442568 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -800.36 reservation #5095 19104 opera:deposit-application:9989:17451594,17451595:1932:17451595:credit Advance Deposit Applied
442567 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 800.36 advanceDeposit #1932 14390 opera:deposit-application:9989:17451594,17451595:1932:17451595:release Advance Deposit Applied
442566 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,248.12 reservation #4839 19264 opera:deposit-application:9989:17451584,17451585:1778:17451585:credit Advance Deposit Applied
442565 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,248.12 advanceDeposit #1778 13182 opera:deposit-application:9989:17451584,17451585:1778:17451585:release Advance Deposit Applied
442564 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #10038 18886 opera:deposit-application:9989:17451572,17451573:4810:17451573:credit Advance Deposit Applied
442563 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4810 18886 opera:deposit-application:9989:17451572,17451573:4810:17451573:release Advance Deposit Applied
442562 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #9729 18884 opera:deposit-application:9989:17451532,17451533:4727:17451533:credit Advance Deposit Applied
442561 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4727 18884 opera:deposit-application:9989:17451532,17451533:4727:17451533:release Advance Deposit Applied
442560 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #236 18931 opera:deposit-application:9989:17451452,17451453:4811:17451453:credit Advance Deposit Applied
442559 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4811 16963 opera:deposit-application:9989:17451452,17451453:4811:17451453:release Advance Deposit Applied
442558 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -1,761.51 reservation #5852 18220 opera:deposit-application:9989:17451408,17451409:4934:17451409:credit Advance Deposit Applied
442557 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 1,761.51 advanceDeposit #4934 18220 opera:deposit-application:9989:17451408,17451409:4934:17451409:release Advance Deposit Applied
442556 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... -349.00 guest #10713 18875 opera:deposit-application:9989:17451381,17451382:4977:17451382:credit Advance Deposit Applied
442555 2026-06-08 transfer 9989 Deposit Transfered at C/I (I... 349.00 advanceDeposit #4977 18875 opera:deposit-application:9989:17451381,17451382:4977:17451382:release Advance Deposit Applied
435445 2026-06-08 payment 9007 Master Card CARD -1,232.31 advanceDeposit #1293 7699 opera:deposit-receipt:17453029 Advance Deposit Receipt
435444 2026-06-08 payment 9011 Electronic Check / Wire Tran... WIRE -9,529.19 advanceDeposit #390 1414 opera:deposit-receipt:17452285 Advance Deposit Receipt
435443 2026-06-08 payment 9007 Master Card CARD -1,188.44 advanceDeposit #2244 18809 opera:deposit-receipt:17452242 Advance Deposit Receipt
435442 2026-06-08 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #4985 18914 opera:deposit-receipt:17452053 Advance Deposit Receipt
435441 2026-06-08 payment 9008 Visa CARD -800.36 advanceDeposit #2248 18868 opera:deposit-receipt:17451959 Advance Deposit Receipt
435440 2026-06-08 payment 9008 Visa CARD -800.36 advanceDeposit #2249 18869 opera:deposit-receipt:17451946 Advance Deposit Receipt
435439 2026-06-08 payment 9010 Discover CARD -970.60 advanceDeposit #2238 18785 opera:deposit-receipt:17451944 Advance Deposit Receipt
435438 2026-06-08 payment 9006 American Express CARD -1,142.76 advanceDeposit #2237 18783 opera:deposit-receipt:17451943 Advance Deposit Receipt
435437 2026-06-08 payment 9006 American Express CARD -1,190.34 advanceDeposit #2256 18900 opera:deposit-receipt:17451901 Advance Deposit Receipt
435436 2026-06-08 payment 9006 American Express CARD -938.88 advanceDeposit #2231 18674 opera:deposit-receipt:17451895 Advance Deposit Receipt
435435 2026-06-08 payment 9006 American Express CARD -2,285.88 advanceDeposit #2240 18794 opera:deposit-receipt:17451850 Advance Deposit Receipt
435434 2026-06-08 payment 9008 Visa CARD -1,404.42 advanceDeposit #2233 18680 opera:deposit-receipt:17451838 Advance Deposit Receipt
435433 2026-06-08 payment 9008 Visa CARD -1,584.86 advanceDeposit #2228 18667 opera:deposit-receipt:17451763 Advance Deposit Receipt
435432 2026-06-08 payment 9007 Master Card CARD -800.36 advanceDeposit #2239 18790 opera:deposit-receipt:17451761 Advance Deposit Receipt
435431 2026-06-08 payment 9031 Shopify Reservation CARD -698.00 advanceDeposit #4984 18892 opera:deposit-receipt:17451715 Advance Deposit Receipt
435430 2026-06-08 payment 9031 Shopify Reservation CARD -698.00 advanceDeposit #4983 18890 opera:deposit-receipt:17451713 Advance Deposit Receipt
435429 2026-06-08 payment 9008 Visa CARD -1,251.86 advanceDeposit #2250 18878 opera:deposit-receipt:17451704 Advance Deposit Receipt
435428 2026-06-08 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #4982 18888 opera:deposit-receipt:17451691 Advance Deposit Receipt
435427 2026-06-08 payment 9006 American Express CARD -1,811.49 advanceDeposit #4981 18102 opera:deposit-receipt:17451297 Advance Deposit Receipt
305301 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #7 18939 opera:ft:17453554
305300 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #15 18938 opera:ft:17453553
305299 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #17 18937 opera:ft:17453552
305298 2026-06-08 charge 1010 Room Tax 0.00 reservationGroup #81 6759 opera:ft:17453551
305297 2026-06-08 charge 1001 Room Charge RTX 0.00 reservationGroup #81 6759 opera:ft:17453550
305296 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #33 18951 opera:ft:17453549
305295 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #23 18950 opera:ft:17453548
305294 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #22 18936 opera:ft:17453547
305293 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #21 18949 opera:ft:17453546
305292 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #20 18953 opera:ft:17453545
305291 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #19 18945 opera:ft:17453544
305290 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #6 18970 opera:ft:17453543
305289 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #5 18969 opera:ft:17453542
305288 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #4 18968 opera:ft:17453541
305287 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #3 18967 opera:ft:17453540
305286 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #9 18966 opera:ft:17453539
305285 2026-06-08 charge 1003 Room Charge - No Tax No Reso... RTX 0.00 houseAccount #29 18942 opera:ft:17453538
305284 2026-06-08 charge 1010 Room Tax 0.00 reservationGroup #42 16581 opera:ft:17453537
305283 2026-06-08 charge 1001 Room Charge RTX 0.00 reservationGroup #42 16581 opera:ft:17453536
305282 2026-06-08 charge 1010 Room Tax 0.00 reservationGroup #42 16580 opera:ft:17453535
305281 2026-06-08 charge 1001 Room Charge RTX 0.00 reservationGroup #42 16580 opera:ft:17453534
Sum (balance): -18,815.70