Payments Summary
Report Description: The Payments Summary report provides a list of all payment types (cash, check, comp, direct bill, master card, visa, etc.) taken for a defined date.
Date Range: 365 dates in the past to current business date
Available Report Columns for Following Sections.
NOTE: the columns on this report are dependent on the payment types accepted at the property. For this article, we have listed the most commonly accepted payment types.
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
The date for which the forecast is provided |
Not Applicable |
Not Applicable |
|
Day of Week |
The day of the week corresponding to the date |
Not Applicable |
Not Applicable |
|
Balance Forward |
Total payments brought forward from legacy PMS system during migration to HotelKey |
Not Applicable |
=sum(balance forward) |
|
Bill to Company |
Total of direct bill payments (LDB) received |
Not Applicable |
=sum(LDB payments) - (LDB refunds) |
|
Cash |
Total of cash payments received |
Not Applicable |
=sum(cash payments) - (cash refunds) |
|
Check |
Total of check payments received |
Not Applicable |
=sum(check payments) - (check refunds) |
|
Amex |
Total of American Express payments received |
Not Applicable |
=sum(amex payments) - (amex refunds) |
|
Discover |
Total of Discover payments received |
Not Applicable |
=sum(discover payments) - (discover refunds) |
|
Mastercard |
Total of Mastercard payments received |
Not Applicable |
=sum(mastercard payments) - (mastercard refunds) |
|
Visa |
Total of Visa payments received |
Not Applicable |
=sum(visa payments) - (visa refunds) |
|
Other |
Total of all other types of payments received |
Not Applicable |
=sum(other payments) - (other refunds) |
|
Total |
Grand total of all payments received |
Not Applicable |
=sum(all payments) - (all 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.
-
Bar Graph: ability to view each individual payment type data in a bar chart.
-
Grouping: ability to view the data grouped by: All, Day of Week
-
Pie Chart: ability to view grouped data in a Pie Chart view.
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
-
-