This report is under the Financial Reports section. Some transactions refer to Revenue for the property such as food and beverage charges, and Room and Tax charges (debits). Other transactions refer to payments made by the guest, such as credit card or cash payments (credits).
This article will assist you in generating a variety of financial reports for your property from the transaction report section.
How to Access
Navigate to Reports > Financial Reports > Transactions
Filters
When opening up the report you can filter by:
- Reservation #, Room # or Guest Name
- From Date - To Date- Use this section to select the START and END dates in which you want the report to begin / stop
- User - It can be modified to only show 1 or all users. The system selects ALL users by default.
- Description: This is the main section that will allow you to generate a variety of reports depending on which description is chosen.
Please review how to set the description to generate specific report types:
- * Income Report - Uncheck "Select all Debits" section - this will leave only Credits (Payments) selected
- * Room & Tax Report - Uncheck "Select all Debits" & "Select all Credits". Once that is done and everything is unchecked, go to Debits and select "Room Rate"as well as "Taxes and Fees".
- * Items & Services Reports - Uncheck "Select all Credits" and Uncheck all debits not associated with Items & Services.
- Group By and Sub-Group By - Depending on the type of report, you will want to either and sub-group by User, Date, Room, Guest Name or Reservation Number
- Adjustments - All adjustments are defaulted to show in reports, you can modify at your discretion depending on your specific report needs.
- Status - Select the reservation status you want to generate the report. All statuses are selected by default.
-
Type - This field allows you to sort by transaction type. You can filter by:
- Reservations - Transactions within a reservation
- House Accounts - Transactions within a house account
- Cash Drawers - Cash added directly to the cash drawer. It does not filter cash payments in a folio.
- Group Profiles - Transactions in a group profile (only available if Groups feature is enabled)
Report Generated
The report generated will show the necessary fields regarding :
- User
- Date/Time
- Room
- Name/Surname
- Reservation Number
- Transaction Code (TRN Code) - It appears when a charge or payment was added to a folio manually
- Description
- Check-in / Check-out
- Reservation Status
- Notes
- Quantity (of items)
- Debit / Credit
You may also email or export report to PDF/Excel
Once the filters are applied, the system will save them in the URL so that it's easier for you to navigate forward and backward on your browser without losing the previously applied filters.
This will allow you to bookmark the report page and copy and paste the URL to share it with other users who have access to the report.
- Navigating on your browser: The system will remember the previously used filters on the report, therefore, it's possible for you to go on another page and keep the same filter setting when using the 'page back' function in your browser.
- Bookmarking the report: If you need to generate the same report with certain filters, you can choose to bookmark the page and open the report when needed.
- Sharing the URL: Copy and paste the URL of the page after the filters have been applied to share it with other users who have access to the report.
- Clearing the Filters: Click "Clear" to clear the selected filters if you would like to generate a different report using a new set of filters.
