Guest Ledger Details Accounting Key Report .ng
Guest Ledger Details
Report Description: The Guest Ledger Details report details information for in-house guests, advance deposits and closed folio for a defined date.
Date Range: Report can be retrieved up to 365 days in the past.
In-House section: Provides charges, taxes and payments to the guest in-house for the period, and the net change.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Confirmation Number | Confirmation number of the reservation | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Charges | Shows charges posted today on this reservation (ex - $100) | NO | =sum(charges) |
Taxes | Shows taxes posted today on this reservation | YES | =sum(taxes) |
Tax Exemption Applied | Shows the amount of tax exemption posted today on this reservation | YES | =sum(tax exemption applied) |
Tax Exemption Removed | Shows the amount of tax exemption removed today on this reservation | YES | =sum(tax exemption removed) |
Payments | Shows payments posted today on this reservation (ex - if paid $100, column will show $100) | Not Applicable | =sum(payments) |
Refunds | Shows refunds posted today on this reservation | Not Applicable | =sum(refunds) |
Net Change | Shows the net change based on payments, refunds and charges posted on the reservation | YES | =sum(charges + taxes) - (payments + refunds) |
Advance Deposit section: provides a list of reservations where advance deposit was collected and posted today.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Confirmation Number | Confirmation number of the reservation | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Advance Deposit Collected Till Date | Shows advance deposit amounts posted today on this reservation | YES | =sum(advance deposit collected till date) |
Advance Deposit Refunds | Shows advance deposit amounts refunded today on this reservation | YES | =sum(advance deposit refunds) |
Advance Deposit Converted Payments | Shows advance deposit amounts converted to payment on this reservation. | YES | =sum(advance deposit converted payment) |
Advance Deposit Converted Refunds | Shows the advance deposit amounts converted to payment then refunded on this reservation. | YES | =sum(advance deposit converted refunds) |
Net Change | Shows the net change based on payments and refunds. | YES | =sum(advance deposit refunds) - (advance deposit collected till date) |
Closed Folio section: provides a list of reservations where the folio was closed with no balance due.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Confirmation Number | Confirmation number of the reservation | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Charges | Shows charges posted today on this reservation (ex - $100) | NO | =sum(charges) |
Taxes | Shows taxes posted today on this reservation | YES | =sum(taxes) |
Tax Exemption Applied | Shows the amount of tax exemption posted today on this reservation | YES | =sum(tax exemption applied) |
Tax Exemption Removed | Shows the amount of tax exemption removed today on this reservation | YES | =sum(tax exemption removed) |
Payments | Shows payments posted today on this reservation (ex - if paid $100, column will show $100) | Not Applicable | =sum(payments) |
Refunds | Shows refunds posted today on this reservation | Not Applicable | =sum(refunds) |
Net Change | Shows the net change based on payments, refunds and charges posted on the reservation | YES | =sum(charges + taxes) - (payments + refunds) |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Not Applicable