SunPMSby SunTatva Technologies
Menu
FeaturesSolutionsIntegrationsReportsHelp CenterVideosFAQSign inRequest a demo

Monthly Commission Report

Updated

On this page
  1. Purpose
  2. Who uses it
  3. About this report on screen
  4. Before you start
  5. Step by step
  6. Filters
  7. Columns
  8. Totals and grouping
  9. How to read an example
  10. Common questions it answers
  11. Troubleshooting
  12. Messages you may see
  13. Export, print and e-mail
  14. Related reports
  15. Screenshots

The Monthly Commission Report lists folios that have a commission posting for a Sales & Channel (travel agent, company, OTA...). Each line shows the Guest Name, Folio No., CRS FolioNo #, Date In, Date Out, Total Charges and the Commission Amount. Lines are grouped by Sales & Channel name.

Monthly Commission Report on the demo hotel (SunTatva Demo Hotel)

Purpose

Know the commission due to each Sales & Channel for stays that checked out in the period, so it can be paid or accrued.

Who uses it

Accountants, revenue managers and the sales manager (agent settlements).

About this report on screen

Every report page has an About this report bar under its header (button Explain / Hide). It explains the report in plain words:

  • Summary: Commission owed to agents and channels for stays in a period.
  • What this report shows: Each stay between From Date and To Date with folio, CRS booking number, total charges and the commission amount, grouped by sales & channel.
  • How to read it:
  • Commission is what the hotel owes the channel or agent for the booking, from the channel's commission set-up.
  • Good to know:
  • Pick a Sales & Channel Category to see only that category.
  • Include Reservation also counts reservations that have not checked in yet.
  • From Date starts on the 1st of the current business month; change it for any other period.

Columns explained (the same text shows on the help icon next to a column title):

Column Meaning
CRS FolioNo # Booking number from the central reservation system / channel.
Total Charges Everything charged to the folio.
Commission Amount What the hotel owes the channel, agent or owner for this line, from the commission set-up.

Before you start

  • The Sales & Channel must have commission configured (Property Setup > Sales & Channels, commission on) and the commission must have been posted (at check-out, or by night audit for no-shows and cancellations).
  • The report selects folios by Date Out inside the range.
  • You need the privilege Monthly_Report_MonthlyCommissionReport (Property Setup > User & Access > Assign Report Privileges). Without it the card is not shown on the Reports screen and a direct address signs you out.

Step by step

  1. Click Reports in the left menu (or press Ctrl+K and type the report name). The report library opens at #/reports.
  2. Choose the category Monthly Reports (or type in the search box) and click the card Monthly Commission ("Commission summary for month"). You can also open #/report/monthly-commission directly.
  3. The report opens and runs once with its default criteria, so you already see data. Under Report criteria set From Date, To Date, Sales & Channel Category, Include Reservation as you need (in a date calendar, Working Date jumps to the current business date).
  4. Click Show to run it again with the new criteria. The line under Results tells how many rows are shown.
  5. Set From Date and To Date, optionally a Sales & Channel Category (N/A = all) and tick Include Reservation to include folios that began as reservations.
  6. Read the result as a Table or as Cards (switch at the top right). Columns shows or hides columns and lets you drag them into another order; click a column title to sort. Hide criteria / Show criteria folds the criteria away; on a tablet or phone it folds by itself after Show and leaves a one-line summary.
  7. Click Export and choose PDF, Excel or Email (PDF). The button is always in the header but stays disabled until the report has rows.

Filters

Filter What it does Default
From Date First day of the period. The calendar greys out days before the property start date (16-Oct-2026 on the demo hotel); the Working Date button sets the PMS date. First day of the PMS month
To Date Last day of the period; it cannot be before From Date. A date after the PMS date is accepted (stays booked for those days then show their rent, nothing is paid yet). PMS date
Sales & Channel Category Only Sales & Channels of this category. N/A lists all categories. N/A (all)
Include Reservation Unticked: only folios checked in directly (walk-ins). Ticked: also folios that came from a reservation (the normal case for agents). Not ticked

The Columns button in the header opens a panel: untick a column to hide it, drag the grip icon to reorder. Hidden columns are also left out of PDF and Excel. If you hide every column, Export is disabled.

Columns

Column Meaning and how it is calculated
(group heading) Name of the Sales & Channel (hidden column used for grouping).
Guest Name Primary guest of the folio. The total line of each group reads Total For Sales & Channel.
Folio No. Folio number.
CRS FolioNo # Reservation number from the channel manager / CRS, if any.
Date In Check-in date.
Date Out Check-out date (the date used for the range).
Total Charges Occupancy charges + occupancy tax of the folio (other charges are not included).
Commission Amount Commission posted for the folio.

Totals and grouping

Grouped by Sales & Channel. Under each group a line Total For Sales & Channel adds Total Charges and Commission Amount of the lines of that group.

How to read an example

On the demo hotel, run for 16-Oct-2026 to 17-Oct-2026 with category N/A and Include Reservation unticked: the screen shows No record found! (1 row). No folio with a commission posting checked out in this range.

Illustration with made-up numbers: group Sample Travel Agent, line Guest A | 161020090257234 | CRS-1001 | 14-Oct-2026 | 17-Oct-2026 | Total Charges 12,000.00 | Commission Amount 1,200.00, then Total For Sales & Channel 12,000.00 / 1,200.00 under the group.

Common questions it answers

  • How much commission do we owe each travel agent?
  • Which folios did an agent bring and what did they pay?
  • What is the total commission of the month?

Troubleshooting

Problem Cause and what to do
No record found! although an agent booked a stay The stay may not have checked out in the range, the Sales & Channel has no commission set, or Include Reservation is not ticked (reservation-based folios are skipped).
Total Charges is lower than the folio bill Only rent and occupancy tax are counted, not other charges.
The Total line There is one Total For Sales & Channel line under each Sales & Channel. Total Charges counts rent and occupancy tax only, not other charges (by design of the report).

Messages you may see

Message Why it appears What to do
No record found! The service returned no rows for the filters. Change the dates or filters and click Show.
Email sent successfully. You chose Email (PDF). Check the property mailbox. The message appears even if the mail server refuses the mail.

Export, print and e-mail

  • PDF is built in the browser and opens in a new tab (allow pop-ups). If the property has no uploaded logo the PDF is simply drawn without it.
  • Excel downloads Monthly Commission Report.xlsx: property name, print date, report name and date range, then the visible columns and the same rows.
  • Email (PDF) has the server mail the PDF to the property e-mail address and shows "Email sent successfully." at once, even if delivery fails.
  • The Export button is always in the report header; it is disabled (grey) until the result has at least one row.

Screenshots

Monthly commission filters
Monthly commission filters