Overview
This article explains the Dashboard > Reports > Financial Reports > Transaction Report.
The Transaction Report provides a comprehensive view of all transactions, including both revenue and payments.
Some transactions are related to property revenue, such as:
Room charges
Food & beverage charges
Other property-related charges
Other transactions represent guest payments, including:
OTA Collect payments
Credit card payments
Cash payments
Other payment methods
Note: The Transaction Report is available with the AirHost HMS (Channel Manager + PMS) Pro plan or above.
Detail
Accessing the Transaction Report
Go to Reports > Financial Reports > Transaction Report.
On the Dashboard, you can filter the report by property by selecting a property from the property selector in the upper-left corner.
Filters & Search Options
Search | Search by Transaction ID (Reservation Number) |
Recognition Date | Filter by Recognition Date. |
Incurred Date | Filter based on the date the transaction was finalized (i.e., the reservation date). |
Transaction Type | Filter by transaction type: OTA Order, POS Order, Payment, Refund, Taxes, Charges, or Adjustment. |
Transaction State | Filter by transaction status. |
Arrival | Filtering by check-in date |
Currency | Filtering by currency |
Properties Tags | Admin Console >> Property List >> Select the relevant property>> Edit >> Property Tags 
|
Features Available in the Transaction Report
Click Email, enter the recipient's email address in the pop-up window, and click Send.
A CSV file containing the report will be sent as an email attachment.
You will receive an email with a CSV file attached.
Export To
Clicking Export To > CSV will download a CSV file to your device.
Sort
Columns marked with up/down arrows can be sorted.
Click the column header to toggle between ascending and descending order.
 |  |
Understanding the Report
Field | Description |
Incurred At | The date and time when the transaction was billed or received (i.e., the reservation date). |
Recognition date | The date when the transaction is finally recognized.
|
The handling of the recognition date varies depending on the type of transaction. Please refer to the following.
Taxes | Date the tax was created |
Refund | Date the refund was created |
Payment (cash, credit card, etc.) | The "date of occurrence" varies depending on the "explanation". The date the guest entered their payment information, or the date the staff entered it. |
Payment (OTA Collect) | Checkout date |
OTA Order | Checkout date |
POS Order | POS/Date the product was ordered |
Charges | Date the fee was created
Items configured under Admin Console > Hotel Products > Charge Adjustments are reflected. 
|
Adjustment | The date the adjustment was created. 
|
Invoice No | Invoice number |
Transaction type | OTA order → Booking via OTA POS order → Order of POS products When you select a payment method and make a payment: When a refund is issued: Taxes → Manually entered taxes (accommodation tax, hot spring tax, etc.) Rates → Hotel Products/Rates Price adjustment → Hotel product/adjustment amount |
Transaction state | Transaction unconfirmed / Transaction in progress / Payment failed / Refund failed / Cancelled |
Description | Details of the transaction (product name, etc.) |
UID | The number displayed in the reservation number and payment details. 
|
Customer | Guest Name |
Arrival | Check-in date |
Departure | Check-out date |
Debit (currency) | Debit |
Credit(currency) | Credit |
Why the recognition date for "Payment (OTA Collect)" is the "Checkout Date"
The recognition date is the date on which the service provided is confirmed (the date on which revenue should be recognized). For accommodation fees, the most common date of reference is the check-out date .
■ Why the check-out date is the recognition date
Since the provision of accommodation services is completed at check-out, it is appropriate to recognize revenue at this point.
Since the accommodation record is finalized on the check-out date, and no-shows, shortened stays, extended stays, and cancellations can occur, the amount and number of days are not finalized at the time of check-in.
Accounting standards also generally recognize accommodation revenue on the "completion date". Under both International Financial Reporting Standards (IFRS) and Japanese accounting standards, it is standard practice for hotel accommodation revenue to be recognized on the date the stay is completed .