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

Ledger transactions (folio_transactions)

Reset
413122 rows (page 3941/4132)
ID Date Type Code Tx type Amount Holder Billable Folio Item Hash Reason / Description
406243 2026-01-11 payment 9028 F&B Visa CARD -41.98 guest #9 opera:ft:16891521
406242 2026-01-11 charge 2095 Terras Sales Tax 3.57 guest #9 opera:ft:16891520
406241 2026-01-11 charge 2082 Terras Breakfast BRK 38.41 guest #9 opera:ft:16891519
406240 2026-01-11 payment 9027 F&B Mastercard CARD -61.20 guest #1 opera:ft:16891499
406239 2026-01-11 charge 2095 Terras Sales Tax 5.21 guest #1 opera:ft:16891498
406238 2026-01-11 charge 2082 Terras Breakfast BRK 55.99 guest #1 opera:ft:16891497
406229 2026-01-11 transfer 9991 Cash Drop Trans. Code (Inter... 8,725.00 opera:ft:16890755 cash_drop
406228 2026-01-11 transfer 9991 Cash Drop Trans. Code (Inter... 976.87 opera:ft:16890754 cash_drop
406227 2026-01-11 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16890753 cash_drop
406226 2026-01-11 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16890752 cash_drop
406225 2026-01-11 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16889931 cash_drop
384418 2026-01-11 payment 9006 American Express CARD -2,341.62 advanceDeposit #513 2008 opera:deposit-receipt:16890750 Advance Deposit Receipt
384417 2026-01-11 payment 9008 Visa CARD -1,409.19 advanceDeposit #509 2002 opera:deposit-receipt:16890749 Advance Deposit Receipt
384416 2026-01-11 payment 9008 Visa CARD -2,475.16 advanceDeposit #511 2006 opera:deposit-receipt:16890748 Advance Deposit Receipt
384415 2026-01-11 payment 9006 American Express CARD -2,538.60 advanceDeposit #510 2005 opera:deposit-receipt:16890747 Advance Deposit Receipt
384414 2026-01-11 payment 9008 Visa CARD -2,884.97 advanceDeposit #514 2009 opera:deposit-receipt:16890745 Advance Deposit Receipt
384413 2026-01-11 payment 9008 Visa CARD -1,329.22 advanceDeposit #507 1994 opera:deposit-receipt:16890744 Advance Deposit Receipt
384412 2026-01-11 payment 9008 Visa CARD -2,728.88 advanceDeposit #506 1990 opera:deposit-receipt:16890743 Advance Deposit Receipt
384411 2026-01-11 payment 9031 Shopify Reservation CARD -698.00 advanceDeposit #2963 2011 opera:deposit-receipt:16890142 Advance Deposit Receipt
384410 2026-01-11 payment 9031 Shopify Reservation CARD -1,396.00 advanceDeposit #2962 2010 opera:deposit-receipt:16890114 Advance Deposit Receipt
384409 2026-01-11 payment 9008 Visa CARD -3,443.94 advanceDeposit #2961 1988 opera:deposit-receipt:16889910 Advance Deposit Receipt
10029 2026-01-11 payment 9007 Master Card CARD -1,926.02 reservation #1016 2007 opera:ft:16890751
10028 2026-01-11 payment 9007 Master Card CARD -2,998.25 reservation #1025 2018 opera:ft:16890746
10027 2026-01-11 payment 9008 Visa CARD 1,501.16 reservation #994 1985 opera:ft:16889441
7633 2026-01-11 transfer 9003 Direct Bill 14,810.00 cityLedgerAccount #396 opera:9003:16890717 Direct Bill 9003
7632 2026-01-11 transfer 9003 Direct Bill 339.97 cityLedgerAccount #396 opera:9003:16890708 Direct Bill 9003
7631 2026-01-11 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16890336 Direct Bill
7630 2026-01-11 transfer 9003 Direct Bill -17.76 cityLedgerAccount #396 opera:9003:16890282 Direct Bill
7629 2026-01-11 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16890248 Direct Bill
7628 2026-01-11 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16890243 Direct Bill
7627 2026-01-11 transfer 9003 Direct Bill -26.49 cityLedgerAccount #396 opera:9003:16889733 Direct Bill
7626 2026-01-11 transfer 9003 Direct Bill -1,047.00 cityLedgerAccount #396 opera:9003:16889732 Direct Bill
406237 2026-01-10 payment 9030 F&B Discover Card CARD -169.59 guest #2 opera:ft:16891493
406236 2026-01-10 charge 2118 Pool Bar Sale Tax 10.05 guest #2 opera:ft:16891492
406235 2026-01-10 charge 2114 Pool Bar Service Charge ALC 21.60 guest #2 opera:ft:16891490
406234 2026-01-10 charge 2112 Pool Bar Gratuity NRV 29.94 guest #2 opera:ft:16891489
406233 2026-01-10 charge 2105 Pool Bar Food ALC 108.00 guest #2 opera:ft:16891488
406224 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 349.00 opera:ft:16888183 cash_drop
406223 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16888182 cash_drop
406222 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16888181 cash_drop
406221 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16888180 cash_drop
406220 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16888179 cash_drop
406219 2026-01-10 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16886951 cash_drop
387616 2026-01-10 payment 9031 Shopify Reservation CARD 1,098.00 advanceDeposit #4917 1969 opera:deposit-refund:16886110:4917 Advance Deposit Refund
387615 2026-01-10 deposit_opening_balance DEPOSIT_OPENING Advance Deposit Migration Op... -1,098.00 advanceDeposit #4917 1969 opera:deposit-opening:d0a85f5162254761e76244aee90e785e134806f772cb59259e8f0e4aaee0b409 Declared Migration Accounting Policy Advance deposit migration opening balanc...
384408 2026-01-10 payment 9007 Master Card CARD -1,503.31 advanceDeposit #498 1977 opera:deposit-receipt:16888178 Advance Deposit Receipt
384407 2026-01-10 payment 9006 American Express CARD -3,586.11 advanceDeposit #495 1967 opera:deposit-receipt:16888177 Advance Deposit Receipt
384406 2026-01-10 payment 9008 Visa CARD -2,606.67 advanceDeposit #497 1973 opera:deposit-receipt:16888176 Advance Deposit Receipt
384405 2026-01-10 payment 9008 Visa CARD -2,783.03 advanceDeposit #500 1980 opera:deposit-receipt:16888175 Advance Deposit Receipt
384404 2026-01-10 payment 9008 Visa CARD -2,119.95 advanceDeposit #494 1966 opera:deposit-receipt:16888174 Advance Deposit Receipt
384403 2026-01-10 payment 9006 American Express CARD -2,522.51 advanceDeposit #502 1982 opera:deposit-receipt:16888173 Advance Deposit Receipt
384402 2026-01-10 payment 9006 American Express CARD -2,726.41 advanceDeposit #503 1983 opera:deposit-receipt:16888172 Advance Deposit Receipt
384401 2026-01-10 payment 9008 Visa CARD -2,850.98 advanceDeposit #499 1979 opera:deposit-receipt:16888171 Advance Deposit Receipt
384400 2026-01-10 payment 9008 Visa CARD -1,616.69 advanceDeposit #504 1984 opera:deposit-receipt:16888169 Advance Deposit Receipt
384399 2026-01-10 payment 9008 Visa CARD -90.60 advanceDeposit #2960 1688 opera:deposit-receipt:16888168 Advance Deposit Receipt
384398 2026-01-10 payment 9008 Visa CARD -1,856.37 advanceDeposit #501 1981 opera:deposit-receipt:16888167 Advance Deposit Receipt
10026 2026-01-10 payment 9008 Visa CARD -1,501.16 reservation #994 1985 opera:ft:16888170
7625 2026-01-10 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16888152 Direct Bill 9003
7624 2026-01-10 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16888143 Direct Bill 9003
7623 2026-01-10 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16888135 Direct Bill 9003
7622 2026-01-10 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16888130 Direct Bill 9003
7621 2026-01-10 transfer 9003 Direct Bill 331.24 cityLedgerAccount #396 opera:9003:16888124 Direct Bill 9003
7620 2026-01-10 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16888114 Direct Bill 9003
7619 2026-01-10 transfer 9003 Direct Bill -26.49 cityLedgerAccount #396 opera:9003:16887775 Direct Bill
7618 2026-01-10 transfer 9003 Direct Bill -8.76 cityLedgerAccount #396 opera:9003:16887543 Direct Bill
406232 2026-01-09 payment 9028 F&B Visa CARD -7.00 guest #9 opera:ft:16891461
406231 2026-01-09 charge 2095 Terras Sales Tax 0.60 guest #9 opera:ft:16891460
406230 2026-01-09 charge 2084 Terras Dinner DNR 6.40 guest #9 opera:ft:16891454
406218 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16884954 cash_drop
406217 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16884953 cash_drop
406216 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16884952 cash_drop
406215 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16884951 cash_drop
406214 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 7,580.00 opera:ft:16884950 cash_drop
406213 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16884949 cash_drop
406212 2026-01-09 transfer 9991 Cash Drop Trans. Code (Inter... 0.00 opera:ft:16883509 cash_drop
406211 2026-01-09 charge 1010 Room Tax -254.31 cityLedgerAccount #444 opera:ft:16883294
406210 2026-01-09 charge 1022 Group Rooms Attrition MSC -1,916.42 cityLedgerAccount #444 opera:ft:16883293 uncollected
406209 2026-01-09 payment 9031 Shopify Reservation CARD -16,550.12 cityLedgerAccount #396 opera:ft:16882493
406206 2026-01-09 payment 9031 Shopify Reservation CARD 16,550.12 cityLedgerAccount #396 opera:ft:16882463
406205 2026-01-09 charge 7163 Shopify Audit (Accounting Us... MSC 1,546.88 cityLedgerAccount #396 opera:ft:16882454
387802 2026-01-09 transfer 9989 Deposit Transfered at C/I (I... -4,072.03 reservation #951 1854 opera:deposit-application:9989:16882271,16882272:485:16882272:credit Advance Deposit Applied
387801 2026-01-09 transfer 9989 Deposit Transfered at C/I (I... 4,072.03 advanceDeposit #485 1854 opera:deposit-application:9989:16882271,16882272:485:16882272:release Advance Deposit Applied
387614 2026-01-09 payment 9008 Visa CARD 4,072.03 advanceDeposit #4916 1854 opera:deposit-refund:16882273:4916 Advance Deposit Refund
387613 2026-01-09 deposit_opening_balance DEPOSIT_OPENING Advance Deposit Migration Op... -4,072.03 advanceDeposit #4916 1854 opera:deposit-opening:b615c8f69acb08796d504c2c2ef6de0eba38f02922efe90a21c72f03240163f9 Declared Migration Accounting Policy Advance deposit migration opening balanc...
384397 2026-01-09 payment 9008 Visa CARD -1,133.38 advanceDeposit #490 1894 opera:deposit-receipt:16884946 Advance Deposit Receipt
384396 2026-01-09 payment 9008 Visa CARD -1,237.58 advanceDeposit #489 1893 opera:deposit-receipt:16884945 Advance Deposit Receipt
384395 2026-01-09 payment 9006 American Express CARD -2,937.32 advanceDeposit #488 1889 opera:deposit-receipt:16884944 Advance Deposit Receipt
384394 2026-01-09 payment 9006 American Express CARD -2,264.16 advanceDeposit #2959 1961 opera:deposit-receipt:16884943 Advance Deposit Receipt
384393 2026-01-09 payment 9008 Visa CARD -1,700.07 advanceDeposit #491 1895 opera:deposit-receipt:16884942 Advance Deposit Receipt
384392 2026-01-09 payment 9031 Shopify Reservation CARD -549.00 advanceDeposit #2958 1962 opera:deposit-receipt:16883510 Advance Deposit Receipt
384391 2026-01-09 payment 9008 Visa CARD -2,511.17 advanceDeposit #2957 1857 opera:deposit-receipt:16882594 Advance Deposit Receipt
384390 2026-01-09 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #2956 1896 opera:deposit-receipt:16882511 Advance Deposit Receipt
384389 2026-01-09 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #2955 1892 opera:deposit-receipt:16882157 Advance Deposit Receipt
384388 2026-01-09 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #2954 1891 opera:deposit-receipt:16882138 Advance Deposit Receipt
384387 2026-01-09 payment 9031 Shopify Reservation CARD -349.00 advanceDeposit #2953 1890 opera:deposit-receipt:16882103 Advance Deposit Receipt
7617 2026-01-09 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16884525 Direct Bill
7616 2026-01-09 transfer 9003 Direct Bill -17.76 cityLedgerAccount #396 opera:9003:16884514 Direct Bill
7615 2026-01-09 transfer 9003 Direct Bill -17.76 cityLedgerAccount #396 opera:9003:16884504 Direct Bill
7614 2026-01-09 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16884499 Direct Bill
7613 2026-01-09 transfer 9003 Direct Bill -9.03 cityLedgerAccount #396 opera:9003:16884489 Direct Bill
Sum (balance): -32,934.28