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
-
-