House Account Folio Balance
Report Description: The House Account Folio Balances report provides a list of house account folio balances as of a defined date.
Date Range: One day (historical dates (365-days) up to yesterday’s date)
House Account Folio Balance section: provides a detailed view of the closed folio details by individual reservation.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Account Number |
Indicates the House Account “Account Number” if indicated |
Not Applicable |
Not Applicable |
|
Name |
House Account Name |
Not Applicable |
Not Applicable |
|
Type |
House Account Type (Temporary or Permanent) |
Not Applicable |
Not Applicable |
|
Open Date |
Opening date of the house account |
Not Applicable |
Not Applicable |
|
Closed Date |
Closure date of the house account (if temporary) |
Not Applicable |
Not Applicable |
|
Status |
Status of the house account (Open or Closed) |
Not Applicable |
Not Applicable |
|
Today’s Charges |
Shows any charges posted today on the house account |
YES |
=sum(today’s charges) |
|
Today’s Payments |
Shows payments made today on the house account |
Not Applicable |
=sum(today’s payments) |
|
Today’s Opening Balance |
Shows opening balance on today’s house account folio
*Positive number indicates there is a positive balance due
*Negative number indicates there is a negative balance due |
YES |
Not Applicable |
|
Today’s Net Change |
Indicates changes made on the house account (payments or charges posted)
*If payments posted, net change will be negative
*If charges posted, net change will be posted |
YES |
=sum(today’s charges) - (today’s payments) |
|
Today’s Ending Balance |
Shows ending balance on today’s house account
*Positive number indicates there is a positive balance due
*Negative number indicates there is a negative balance due |
YES |
=sum(today’s opening balance) - (today’s net change) |
Balances section: provides opening balance, net change and closing balance totals for today.
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
-
-