📆 Revision Date:
Report Description: The Settlement by Payment Type report provides a detailed and summarised view of all payment transactions grouped by payment type for a selected date range. It helps finance and operations teams reconcile settlements, validate cashier activity, track payment distributions, and support audit and end-of-day close processes.
Date Range: Single date up to 365 days in the past
Available Report Columns for Following Sections:
Details Section
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Account Category |
Classification of the account against which the transaction is posted |
Not Applicable |
Not Applicable |
|
Date |
Business or posting date of the transaction. |
Not Applicable |
Not Applicable |
|
Time |
Time at which the transaction was recorded. |
Not Applicable |
Not Applicable |
|
Transaction Number |
Unique system-generated identifier for the transaction. |
Not Applicable |
Not Applicable |
|
Folio Number |
Folio reference number associated with the transaction. |
Not Applicable |
Not Applicable |
|
Guest Name |
Name of the guest linked to the transaction. |
Not Applicable |
Not Applicable |
|
Account Name |
Name of the account to which the payment is applied. |
Not Applicable |
Not Applicable |
|
Room Number |
Room number associated with the reservation, if applicable. |
Not Applicable |
Not Applicable |
|
Payment Type |
Mode of payment used (e.g., Cash, Credit Card, UPI, Bank Transfer). |
Not Applicable |
Not Applicable |
|
Payment Description |
Additional description or reference for the payment. |
Not Applicable |
Not Applicable |
|
Amount |
Transaction amount settled using the specified payment type. |
Yes |
Not Applicable |
|
Username |
System username of the staff member who processed the transaction. |
Not Applicable |
Not Applicable |
|
Remarks |
Any comments or notes recorded at the time of transaction posting. |
Not Applicable |
Not Applicable |
Summary Section
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Payment Type |
Mode of payment aggregated in the summary. |
Not Applicable |
Not Applicable |
|
Amount |
Total amount settled for the payment type within the selected date range. |
Yes |
=sum(total) |
|
Count |
Number of transactions processed for the payment type. |
Not Applicable |
Not Applicable |
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 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.