Settlement by Payment Type .ng
📆 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.