Payment Summary Accounting Key Report .ng
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