Report Category | Type | TODAY | MTD | YTD |
| Credit Card | | American Express | $-105.00 | $-105.00 | $-205.77 | | Mastercard | $-100.44 | $-100.44 | $-150.78 | | Visa | $-15.00 | $-15.00 | $-115.00 |
|
| | TOTAL Credit Card: | $-220.44 | $-220.44 | $-471.55 |
| Gift Certificates | | Gift Certificate | $100.00 | $100.00 | $100.00 |
|
| |
| Transaction Summary June 6, 2023 | Transaction Summary Ledger GL file
System Date: June 6, 2023
JSON Array Sample
JSON Array Sample
continuedReport Category | Type | TODAY | MTD | YTD | Credit Card | American Express | $-105.00 | $-105.00 | $-205.77 | Mastercard | $-100.44 | $-100.44 | $-150.78 | Visa | $-15.00 | $-15.00 | $-115.00 | TOTAL Credit Card: | $-220.44 | $-220.44 | $-471.55 | Gift Certificates | Gift Certificate | $100.00 | $100.00 | $100.00 | TOTAL Gift Certificates: | $100.00 | $100.00 | $100.00 |
| Non Credit Card | | Cash | $-135.15 | $-135.15 | $-260.15 | | Check | $0.00 | $0.00 | $0.00 | | Gift Certificate Redeemed | $0.00 | $0.00 | $0.00 |
|
| | TOTAL Non Credit Card: | $-135.15 | $-135.15$-260.15 | Room Rent | Room Rent | $100.00 | $100.00 | $451.50 | TOTAL Room Rent: | $100.00 | $100.00 | $451.50 | Tax | Sales tax | $9.00 | $9.00 | $16.03 | TOT | $5.00 | $5.00 | $22.58 | TOTAL Taxes: | $14.00 | $14.00 | $38.61 | GRAND TOTAL: | $-141.59 | $-141.59 | $-141.59 |
Advance Deposit : $1,235.90 Accounts Receivables: $9,465.23 | $-260.15 |
| Room Rent | | Room Rent | $100.00 | $100.00 | $451.50 |
|
| | TOTAL Room Rent: | $100.00 | $100.00 | $451.50 |
| Tax | | Sales tax | $9.00 | $9.00 | $16.03 | | TOT | $5.00 | $5.00 | $22.58 |
|
| | TOTAL Taxes: | $14.00 | $14.00 | $38.61 |
| | GRAND TOTAL: | $-141.59 | $-141.59 | $-141.59 |
Advance Deposit : $1,235.90 Accounts Receivables: $9,465.23 | American Express detail: { "success": true, "data": [ { American Express detail: { "success": true, "data": [ { "propertyID": "TEST", "propertyName": "Test hotel", "transactionDate": "2023-06-06", "ItemID": "AX", "Item description": "American Express", "GLCode": "AX", "GL description": "American Express", "amountpropertyID": 105.00"TEST", "GLTypepropertyName": "debitTest hotel", "GLOffsetIDtransactionDate": "AXCreditRc2023-06-06", "GLOffsetDescItemID": "AX Credit Card Receivables", "amountItem description": 105.00"American Express", "GLOffsetTypeGLCode": "credit" }, Visa detail: {AX", "propertyIDGL description": "TESTAmerican Express", "propertyNameamount": "Test hotel"105.00, "transactionDateGLType": "2023-06-06debit", "ItemIDGLOffsetID": "VIAXCreditRc", "Item descriptionGLOffsetDesc": "VisaAX Credit Card Receivables", "GLCodeamount": "VI"105.00, "GL descriptionGLOffsetType": "Visa",credit" }, Visa detail: { "amountpropertyID": 15.00"TEST", "GLTypepropertyName": "debitTest hotel", "GLOffsetIDtransactionDate": "VICreditRc2023-06-06", "GLOffsetDescItemID": "Visa Credit Card ReceivablesVI", "amountItem description": 15.00"Visa", "GLOffsetTypeGLCode": "credit" }, TOTAL Credit Card summary: {VI", "propertyIDGL description": "TESTVisa", "propertyNameamount": "Test hotel"15.00, "transactionDateGLType": "2023-06-06debit", "ItemIDGLOffsetID": "Total Credit CardVICreditRc", "Item descriptionGLOffsetDesc": "Total Visa Credit Card Receivables", "GLCodeamount": "Total_Credit_Card"15.00, "GL descriptionGLOffsetType": "Total Credit Cardcredit", "amount": 135.15,}, TOTAL Credit Card summary: { "GLTypepropertyID": "debitTEST", "GLOffsetIDpropertyName": "CreditCardRcTest hotel", "GLOffsetDesctransactionDate": "Credit Card Receivables"2023-06-06", "amountItemID": 135.15"Total Credit Card", "GLOffsetTypeItem description": "credit" }, Cash detail: {Total Credit Card", "propertyIDGLCode": "TESTTotal_Credit_Card", "propertyNameGL description": "Test hotelTotal Credit Card", "transactionDateamount": "2023-06-06"135.15, "ItemIDGLType": "Cashdebit", "Item descriptionGLOffsetID": "CashCreditCardRc", "GLCodeGLOffsetDesc": "CASHCredit Card Receivables", "GL descriptionamount": "CASH"135.15, "amount": 135.15,GLOffsetType": "credit" }, Cash detail: "GLType": "debit"{ "GLOffsetIDpropertyID": "CASHRcTEST", "GLOffsetDescpropertyName": "CASH ReceivablesTest hotel", "amounttransactionDate": 135.15"2023-06-06", "GLOffsetTypeItemID": "credit" }, RENT detail: {Cash", "propertyIDItem description": "TESTCash", "propertyNameGLCode": "Test hotelCASH", "transactionDateGL description": "2023-06-06CASH", "ItemIDamount": "RENT"135.15, "Item descriptionGLType": "Room Rentdebit", "GLCodeGLOffsetID": "RENTCASHRc", "GL descriptionGLOffsetDesc": "Room RentCASH Receivables", "amount": 135.15.00, "GLOffsetType": "GLType": "credit"credit" }, | RENT detail: { "GLOffsetIDpropertyID": "ADTEST", "GLOffsetDescpropertyName": "Advance DepositTest hotel", "amounttransactionDate": 15.00"2023-06-06", "GLOffsetTypeItemID": "debit" }, TOT Tax: {RENT", "propertyIDItem description": "TESTRoom Rent", "propertyNameGLCode": "Test hotelRENT", "transactionDateGL description": "2023-06-06Room Rent", "ItemIDamount": "TOT"15.00, "Item descriptionGLType": "TOTcredit", "GLCodeGLOffsetID": "TOTAD", "GL descriptionGLOffsetDesc": "Transient Occupancy TaxtAdvance Deposit", "amount": 515.00, "GLTypeGLOffsetType": "credit"debit" }, TOT Tax: { "GLOffsetIDpropertyID": "TOTRecdTEST", "GLOffsetDescpropertyName": "TOTRecdTest hotel", "amounttransactionDate": 5.00"2023-06-06", "GLOffsetTypeItemID": "debit" }, Advanced Deposit: {TOT", "propertyIDItem description": "TESTTOT", "propertyNameGLCode": "Test hotelTOT", "transactionDateGL description": "2023-06-06Transient Occupancy Taxt", "ItemID": "AD"amount": 5.00, "Item descriptionGLType": "Advance Depositcredit", "GLCodeGLOffsetID": "ADTOTRecd", "GL descriptionGLOffsetDesc": "Advance DepositTOTRecd", "amount": 12355.9000, "GLTypeGLOffsetType": "creditdebit" }, Advanced Deposit: "GLOffsetID": "TOTAL_BANK"{ "GLOffsetDescpropertyID": "Total BANKTEST", "amountpropertyName": 100.00"Test hotel", "GLOffsetTypetransactionDate": "debit2023-06-06", }, Accounts Receivable: {"ItemID": "AD", "propertyIDItem description": "TESTAdvance Deposit", "propertyNameGLCode": "Test hotelAD", "transactionDateGL description": "2023-06-06Advance Deposit", "ItemIDamount": "AR"1235.90, "Item descriptionGLType": "Accounts Receivablescredit", "GLCodeGLOffsetID": "ARTOTAL_BANK", "GL descriptionGLOffsetDesc": "Accounts ReceivablesTotal BANK", "amount": 9465100.2300, "GLTypeGLOffsetType": "credit"debit" }, Accounts Receivable: { "GLOffsetIDpropertyID": "TOTAL_BANKTEST", "GLOffsetDescpropertyName": "Total BANKTest hotel", "amount": 9465.23"transactionDate": "2023-06-06", "GLOffsetTypeItemID": "debitAR", },} | Example of JSON output: |