House Account Folio Balance .ng
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