Adjustments and Refunds Activity
Report Description: The Adjustments and Refunds Activity report offers a comprehensive list of rate adjustments and refunds transactions made within a specified period, showcasing transaction details such as date, time, type, number, reason code, amount, and user information, facilitating financial tracking and transaction reconciliation.
Date Range: This report can render the data for up to 94 days
Adjustments section: The adjustments section provides a detailed list of rate adjustments by transaction number and user.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Reservation, House Account, etc.) |
Not Applicable |
Not Applicable |
|
Charge Type |
Used to sort transactions involving income, different types of expenses, equipment purchases, etc. |
Not Applicable |
Not Applicable |
|
Transaction Number |
Unique identifier for the adjustment transaction |
Not Applicable |
Not Applicable |
|
Adjustment Reason Code |
Code representing the reason for the adjustment |
Not Applicable |
Not Applicable |
|
Adjusted Amount |
Amount adjusted in the transaction |
NO |
Not Applicable |
|
Adjusted Tax |
Tax amount adjusted in the transaction |
YES |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Additional remarks regarding the adjustment |
Not Applicable |
Not Applicable |
Refunds section: The Refunds section provides a detailed list of payment refunds by transaction number and user.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Date of the transaction (ex - March 25, 2024) |
Not Applicable |
Not Applicable |
|
Time |
Time of the transaction (ex - 05:39:49 AM) |
Not Applicable |
Not Applicable |
|
Transaction Type |
Type of transaction (ex - Reservation, House Account, etc.) |
Not Applicable |
Not Applicable |
|
Transaction Number |
Unique identifier for the adjustment transaction |
Not Applicable |
Not Applicable |
|
Refund Code |
Code representing the reason for the refund |
Not Applicable |
Not Applicable |
|
Payment Type Refunded |
Payment type used for the refund |
Not Applicable |
Not Applicable |
|
Amount |
Amount refunded in the transaction |
YES |
Not Applicable |
|
Username |
Username that processed that transaction |
Not Applicable |
Not Applicable |
|
Remarks |
Additional remarks regarding the adjustment |
Not Applicable |
Not Applicable |
Refund Summary section: The Refund Summary section provides a total refund amount for the defined period by type.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Type |
Type of refund (example: Payment Type, Reason Code, etc. |
Not Applicable |
Not Applicable |
|
Name |
The name of the type |
Not Applicable |
Not Applicable |
|
Refund Amount |
Total amount refunded for the defined period by type |
Not Applicable |
=sum(Refund Amount) |
Adjustment Summary section: The Adjustment Summary section provides a total adjusted amount for the defined period by type.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Type |
Type of adjustment (example: charge type, reason code, etc.) |
Not Applicable |
Not Applicable |
|
Name |
The name of the type |
Not Applicable |
Not Applicable |
|
User |
The user ID who made the adjustment |
Not Applicable |
Not Applicable |
|
Adjusted Amount |
Total amount adjusted for the defined period by type |
NO |
=sum(Adjusted Amount) |
|
Adjusted Tax |
Total tax amount adjusted in the transaction |
YES |
=sum(Adjusted Tax) |
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 Chart: ability to display data in a bar chart view.
-
Group By: ability to group data All, Transaction Code, Transaction Description or Transaction Type
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:
-
None
-
-