SunPMSby SunTatva Technologies
Menu
FeaturesSolutionsIntegrationsReportsHelp CenterVideosFAQSign inRequest a demo

Monthly Sales & Channel 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 Sales & Channel Report (card Monthly Sales & Channels, report key monthly-business-source) lists, per Sales & Channel, the checked-in folios that have a payment assigned to that Sales & Channel account: GuestName, Room, Date In, Date Out, Rent, Tax, Other Charge, Sales Tax, Paid By Guest, PTD and Total Payment. The screen title includes the dates, for example Monthly Sales & Channel Report for 01-Oct-2026 To 17-Oct-2026.

Monthly Sales & Channel Report on the demo hotel (SunTatva Demo Hotel)

Purpose

Show how much of each folio is billed to the agent or company account and how much the guest paid directly, so that accounts receivable of each Sales & Channel can be followed.

Who uses it

Accountants and the credit controller; sales managers who deal with agents and companies.

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: Revenue and payments per sales & channel in a period.
  • What this report shows: Per sales & channel: each stay with room, dates, rent, other charges, tax, what the guest paid and what was paid by the channel's account.
  • How to read it:
  • Paid By Guest = paid at the desk. Payment By Account = paid by the channel / company account.
  • Good to know:
  • 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
Rent Room rent (without other charges).
Other Charge Charges other than room rent (food, laundry, extra bed...).
Paid By Guest Paid by the guest at the desk.
PTD Period to date: from the start of the period to the chosen date.
Total Payment All payments received.

Before you start

  • Only checked-in folios that have at least one payment with a Sales & Channel (direct billing) are listed.
  • A folio is included when its Date In or Date Out is in the range, or when it stays across the whole range.
  • You need the privilege Monthly_Report_MonthlyBusinessSourceReport (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 Sales & Channels ("Revenue by Sales & Channel"). You can also open #/report/monthly-sales-channels 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 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. 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.
  6. 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

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

All columns of the Monthly Sales & Channel Report (wide screen)

Column Meaning and how it is calculated
(group heading) Sales & Channel name (hidden column used for grouping); a Total line closes each group and a Grand Total ends the report.
GuestName Primary guest of the folio.
Room Room of the folio.
Date In Check-in date.
Date Out Check-out date.
Rent Total occupancy charges of the folio.
Tax Total occupancy tax of the folio.
Other Charge Total other charges of the folio.
Sales Tax Tax on the other charges.
Paid By Guest Payments made by the guest himself (payments without a Sales & Channel), not deleted.
PTD Payments made by this Sales & Channel account on the folio, dated inside the From/To range ("payment to date" of the period), not deleted.
Total Payment All payments made by this Sales & Channel account on the folio (any date), not deleted.
Payment By Account (hidden) Hidden helper column, not shown.

Totals and grouping

One Total line per Sales & Channel (sum of its folios) and a Grand Total over all sources. Because a folio can have payments from more than one source, the same folio can appear in more than one group.

How to read an example

On the demo hotel, run for 16-Oct-2026 to 17-Oct-2026: the title reads Monthly Sales & Channel Report for 16-Oct-2026 To 17-Oct-2026 and the screen answers No record found! because no checked-in folio has a Sales & Channel payment.

Illustration with made-up numbers: group Sample Travel Agent, line Guest A | 201 | 14-Oct-2026 | 17-Oct-2026 | Rent 12,000.00 | Tax 1,440.00 | Other Charge 0.00 | Sales Tax 0.00 | Paid By Guest 0.00 | PTD 13,440.00 | Total Payment 13,440.00, then Total and Grand Total.

Common questions it answers

  • Which folios are billed to which agent or company?
  • How much did each Sales & Channel pay in the period?
  • How much did guests pay themselves?

Troubleshooting

Problem Cause and what to do
No record found! There is no checked-in folio with a Sales & Channel payment in the range. Payments by direct billing are posted on the folio payment screen with a Sales & Channel.
PTD differs from Total Payment PTD counts only payments dated inside the range; Total Payment counts all payments of that account on the folio.
The screen title shows dates This report puts the chosen dates in its title (it is the only report that does so).

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 Sales & Channel 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 Sales & Channel Report: monthly business source filters
Monthly Sales & Channel Report: monthly business source filters