Administration

Sales Breakdown Report

🎯 Purpose

This report helps monitor both expected and earned revenue from service sales and registered orders. It is also useful for:

✅ Checking the total number of services sold

✅ Getting a VAT % breakdown of sold services

📌 Data Sources

🔹 Folio items (from the Folio Table in reservations)

🔹 Orders created in the Quick Order menu

📂 Included Reservation & Room Type Statuses

🏨 Reservations: Confirmed, Option

🛏️ Room Types: Room, Technical, Conference, Garage


⚙️ Filtering Options

📅 Date Picker

📌 Choose from predefined options or set a custom date range.

💱 Currency

💰 Select from your defined custom currencies.

🔄 If you choose a currency other than the default, the system recalculates amounts using the daily exchange rate (or a custom rate if set).

📝 Include Orders (Checkbox – Off by Default)

🔲 Unchecked: Orders are not listed in the report.

✅ Checked: The report includes all relevant orders in the selected timeframe.

🚨 Important:

  • Only "Locked" status orders are included.
    • 🧾 Invoiced orders = "Billed"
    • ❌ Closed without invoice = "Not Billed"
  • 📌 Orders saved in the PMS but not locked are NOT included.

📌 Reservation Status

✅ Default: All four statuses (Confirmed, Option, Cancelled, No-show) are selected.

❗ If filtering by Cancelled or No-show for the Accommodation category, the report will list cancellation & no-show fees.

🛏️ Room Type Selection

📌 Default: All room types are included.

🔘 Use checkboxes to generate the report for specific room types.

📂 Category

📌 This filter only shows relevant categories based on the selected date range.

💡 Example: If you select "Today", but no reservations for today include Minibar items (e.g., Coca-Cola), the Minibar category will not be available as a filter option.

🛎️ Services

🔗 Depends on the selected Categories.

📌 After selecting a category, only the services related to that category will be available as filter options.

📄 Item Status

🔘 Billed

🔘 Not Billed

📌 Note: "Routed" folio items are classified under "Not Billed".

💰 VAT %

📌 Displays all VAT % options available for the selected period.

💡 Example: If you need a report of services under the 5% VAT category, use this filter.


🌍 Optimized Multi-Language Handling for Service Names

🔹 If a service is not translated into the selected language (in the software or in the exported/printed report), the system will display the original service name in brackets [ ].

🔹 If a service has multiple translations but is not available in the selected language, the system will use the primary language of the account.

📌 Example:

1️⃣ The "Breakfast" service is only available in English (EN). If you log in using Turkish (TR), the system will display: [Breakfast].

2️⃣ The "Breakfast" service is available in both English (EN) and Turkish (TR), but you log in using Hungarian (HUN). The system will use the account's primary language (English) and display: [Breakfast].


🔍 Search Field Limitation

🔹 The search field only works for data that cannot be filtered using the available filters. This includes:

  • 👤 Guest name
  • 🏷️ Reservation code
  • 🛏️ Room name

❓ What does this mean?

🔹 If you want to search for something that has a dedicated filter (e.g., date, payment type, status, etc.), you should use the filters instead of the search field.

🔹 The search field is only useful for finding specific details that filters cannot narrow down.


📊 Report Widgets

This report includes four key summary widgets:

1️⃣ 💳 Total NET – Sum of NET amounts from the main table

2️⃣ 💵 Total GROSS – Sum of GROSS amounts from the main table

3️⃣ 📊 Total GROSS (Service Quantities Table) – Sum of GROSS amounts in the Service Quantities Table

4️⃣ 📦 Total Quantity – Total quantity of items in the Service Quantities Table

⚠️ Important Notes:

📌 The Service Quantities Table only includes "Service" type folio items.

❌ Accommodation, City Tax, and Coupon items are NOT included in this table.

📤 Report Export:

  • 📑 The Sales Breakdown and Service Quantities Table are exported on separate tabs.