House Accounts
Report Description: Provides detailed information on all house accounts at the property within a specific date range. This report enables property staff to allocate resources more efficiently, identify trends, better manage house accounts, and improve their account management process. By including transaction-level remarks directly in the report, staff can quickly understand account context and open balances without drilling into individual records, ultimately leading to better financial management and a streamlined guest experience.
Date Range: This report can render the data for up to 365 days in the past.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Type |
Indicates the type or category of the house account |
Not Applicable |
Not Applicable |
|
House Account Name |
Specifies the name or title of the house account |
Not Applicable |
Not Applicable |
|
House Account Code |
Represents a unique identifier or code assigned to the house account |
Not Applicable |
Not Applicable |
|
Company Name |
Displays the name of the company associated with the house account |
Not Applicable |
Not Applicable |
|
Company Code |
Provides a unique code or identifier for the company associated with the house account |
Not Applicable |
Not Applicable |
|
Open Date |
Indicates the date when the house account was opened or established |
Not Applicable |
Not Applicable |
|
Close Date |
Specifies the date if the house account has been closed or deactivated |
Not Applicable |
Not Applicable |
|
Status |
Shows the current status of the house account, whether it is active or inactive |
Not Applicable |
Not Applicable |
|
Username |
Displays the username or identifier of the user responsible for managing the house account |
Not Applicable |
Not Applicable |
|
Total Charges |
Represents the cumulative amount charged to the house account over a specified period. |
YES |
=sum(total charges) |
|
Total Payments |
Indicates the total payments made towards the house account to date |
Not Applicable |
=sum(total payments) |
|
Balance |
Displays the remaining balance or outstanding amount on the house account after considering charges and payments |
YES |
=sum(charges) - (payments) |
|
Last Transaction Posted |
Displays the date of the most recent financial activity on the account |
Not Applicable |
Not Applicable |
|
Remarks |
Displays the existing house account notes or justifications directly within the report output |
Not Applicable |
Not Applicable |
Misc Report Information:
Available Features:
-
Export: Ability to download and save the file into an alternate format (e.g., Excel, PDF).
-
Filter: Filter a range of data based on criteria defined by the user.
-
Highlight: Also known as conditional formatting; the ability to highlight certain values making them easier to identify.
-
Grouping: Ability to view the data grouped by: All, Type, Open Date, Close Date, Status.
-
Pie Chart: Ability to view grouped data in a Pie Chart view.
Available Configuration:
-
User Preferences: Allows the user to customise their report view by repositioning or removing columns.
-
Property Preferences: Allows the property to customise 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
-
-