In House Guest Folio Balances Front Office Key Report .ng
In House Guest Folio Balances
Report Description: The In House Guest Folio Balances report provides a list of in-house guest folio balances. Report provides guest confirmation number, room number, name, check-in date, check-out date, today's charges, today's payments and net change and today's ending balance.
Date Range: In House reservations as of today’s date
Reservations Section: The Reservation section provides a list of in-house reservations guest folio balances.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Confirmation Number | Confirmation number on the reservation | Not Applicable | Not Applicable |
Group Code | Group master code (if applicable) | Not Applicable | Not Applicable |
Room Number | Room number on the reservation (if applicable) | Not Applicable | Not Applicable |
Guest Name | Primary guest on the reservation | Not Applicable | Not Applicable |
Additional Guests | Indicates if any additional guests on the reservation (ex - Yes if additional guests, No if no additional guests) | Not Applicable | Not Applicable |
Company Name | Lists the corporate negotiated name on the reservation, if applicable | Not Applicable | Not Applicable |
Check In Date | Check in date of the reservation (ex - Mar 04, 2024) | Not Applicable | Not Applicable |
Check Out Date | Checkout date of the reservation (ex - Mar 10, 2024) | Not Applicable | Not Applicable |
Rate Plan | Rate plan code of the reservation (ex - GCG01) | Not Applicable | Not Applicable |
Payment Method | Payment method of the reservation (ex - Cash, Bill to Company, Credit Card) | Not Applicable | Not Applicable |
Status | Status of the Reservation; this report shows all In House with a balance | Not Applicable | Not Applicable |
Today’s Charges | Shows charges posted today on this reservation (ex - $100) | YES | =sum(today’s charges) |
Today’s Payments | Shows payments posted today on this reservation (ex - if paid $100, column will show $100) | Not Applicable | =sum(payments collected today) |
Today’s Opening Balance | Shows today’s balance on the reservation at the beginning of the business date | YES | Not Applicable |
Today’s Net Change | Shows the net change based on both payments and charges posted on the reservation | YES | =sum(today’s charges) - (today’s payments) |
Today’s Ending Balance | Shows today’s balance on the reservation at the end of the business date | YES | =sum(opening balance) + (today’s net change) |
Groups Section: The Groups section provides a list of in-house group masters folio balances.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Group Number | Indicates the confirmation number on the group (if any in house) | Not Applicable | Not Applicable |
Group Contact Name | Indicates the primary group contact name | Not Applicable | Not Applicable |
Company Name | Lists the corporate negotiated name on the reservation, if applicable | Not Applicable | Not Applicable |
Start Date | Start date of the group master (ex - Mar 04, 2024) | Not Applicable | Not Applicable |
End Date | End date of the group master (ex - Mar 10, 2024) | Not Applicable | Not Applicable |
Rate Plan | Rate plan code of the reservation (ex - GCG01) | Not Applicable | Not Applicable |
Payment Method | Payment method of the reservation (ex - Cash, Bill to Company, Credit Card) | Not Applicable | Not Applicable |
Today’s Charges | Shows charges posted today on this reservation (ex - $100) | YES | =sum(today’s charges) |
Today’s Payments | Shows payments posted today on this reservation (ex - if paid $100, column will show $100) | Not Applicable | =sum(today’s payments) |
Today’s Opening Balance | Shows today’s balance on the reservation at the beginning of the business date | YES | Not Applicable |
Today’s Net Change | Shows the net change based on both payments and charges posted on the reservation | YES | =sum(today’s charges) - (today’s payments) |
Today’s Ending Balance | Shows today’s balance on the reservation at the end of the business date | YES | =sum(opening balance) + (today’s net change) |
Net Totals Section: The Net Totals section lists today’s net changes for Charges, Payments, Opening Balance, Net Change and Ending Balance broken out by Reservation totals and Group Master totals.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Today’s Charges | Shows charges posted today on this reservation (ex - $100) | YES | =sum(today’s charges) |
Today’s Payments | Shows payments posted today on this reservation (ex - if paid $100, column will show $100) | Not Applicable | =sum(today’s payments) |
Today’s Opening Balance | Shows today’s balance on the reservation at the beginning of the business date | YES | Not Applicable |
Today’s Net Change | Shows the net change based on both payments and charges posted on the reservation | YES | =sum(today’s charges) - (today’s payments) |
Today’s Ending Balance | Shows today’s balance on the reservation at the end of the business date | YES | =sum(opening balance) + (today’s net change) |
Balance Section: The Balance section provides a summary recap of the details provided on this report.
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:
None