SunPMSby SunTatva Technologies
Menu
FeaturesSolutionsIntegrationsReportsHelp CenterVideosFAQSign inRequest a demo

Monthly Reports - tax, charges, sales and channels, statistics

Reports · Updated

On this page
  1. Monthly Other Charge
  2. Monthly Other Charge Columnar
  3. Monthly Tax Exempt
  4. Monthly Tax Exempt Claim
  5. Monthly Tax Detail
  6. Monthly Commission
  7. Monthly Sales & Channels
  8. Sales & Channel Summary
  9. Monthly Undo
  10. Monthly Room Sold
  11. Monthly Statistics
  12. Hotel Statistics
  13. Messages you may see
  14. Tips and FAQ
  15. Dedicated pages (one page and one video per report)

Twelve more monthly reports. Defaults: From Date = 1st of the PMS month, To Date = PMS date (Hotel Statistics has one date). Formulas for occupancy, ADR and RevPAR are in 03-daily-reports-summaries.

Monthly Other Charge

Filters: From Date, To Date, Other Charge Category, Select Other Charge, Exclude No-Show/Cancel. Columns: Charge Name, Room Name, Guest Name, User Name, Amount, tax, Total. Grouped by header (charge). Lists each posting.

Monthly Other Charge Columnar

Same filters, but one row per date with a column per other charge, plus Total Tax and Total. Use it for a month grid of extra income. It is protected by its own Monthly Other Charges Columnar Report privilege, also when opened by direct address.

Monthly Tax Exempt

Filters: From Date, To Date, Include No-Show/Cancel. Columns: Room Name, Guest Name, Rate, Total. Stays whose occupancy tax was exempted.

Monthly Tax Exempt Claim

Filters: same. Columns: Room Name, Folio #, Guest Name, Date In, Claim Period From, Claim Period To, Rent, tax, Occupancy Tax/Day, Occupancy Tax/Stay, Payment. Use it when you must claim back exempted tax.

Monthly Tax Detail

Filters: From Date, To Date. One row per Day: Room Sold, Rent, one column per tax, Total; then Charge Amount with each tax and Total for other charges; then Rent (No-Show/Cancel) with its taxes. Use for tax return preparation.

Monthly Commission

Filters: From Date, To Date, Sales & Channel Category, Include Reservation. Columns: Guest Name, Folio No., CRS FolioNo #, Date In, Date Out, Total Charges, Commission Amount. Based on commission postings of folios whose Date Out falls in the range.

Monthly Sales & Channels

Filters: From Date, To Date. Grouped by source. Columns: GuestName, Room, Date In, Date Out, Rent, Tax, Other Charge, Sales Tax, Paid By Guest, PTD, Total Payment. Hidden helper column "Payment By Account".

Sales & Channel Summary

Filters: From Date, To Date. Columns: Sales & Channel, Balance B/F, Room Charges, Payments, Commission B/F, Commission, Commission Payment, Balance Due. One line per source: the account statement summary for direct-bill agents and companies.

Monthly Undo

Filters: From Date, To Date. Columns: Desk User, Undo Date, Room, Guest Name, Folio #, UndoOperation, Reason. Audit of undo actions (undo check-in, check-out, etc.).

Monthly Room Sold

Filters: From Date, To Date. Columns: Sold Date, Room Sold, Available Room. One row per date.

Monthly Statistics

Filters: From Date, To Date. One row per date and a Total row. Columns: Date, Arrival, Reservation, Room Sold (Occu. %) (written like "12 (60.00)"), ADR, Rev PAR, Occupancy Charges, tax, Total Other Charges, tax, Discount, Total, Total Payment, Total Deposit. Calculation: Occupancy % = rooms sold ÷ available rooms × 100 (rooms in V/Maint status or not counted for occupancy excluded). ADR = rent ÷ rooms sold. Rev PAR = rent ÷ available rooms. Occupancy Charges and tax include no-show/cancel revenue; Total = occupancy charge + tax + other charges + tax - discount. Total Payment = cash, bank and card payments by payment date. Total row: Occu. % is the average of the daily percentages; ADR and Rev PAR are totals over totals. So the Total row percentage can differ slightly from rooms sold ÷ total room-nights. Mismatch: ADR here excludes no-show revenue; Occupancy Charges includes it.

Hotel Statistics

Filter: From Date (the "as of" date). Layout: a special table with Current Year and Last Year blocks, each with Today, Month To Date, Year To Date. Sections: Revenue (taxable and exempt rent per tax, Room Revenue, Other Charge Revenue, Miscellaneous Income, Total Revenue, Miscellaneous Expense), Room Statistics (Total Room, V/Maint, Total Available To Sell, Checked-In, Hourly Checked-In, Reserved, Stay Over, Total Occupied, Complimentary, House Use, Total Occupied Less Complimentary & House), Occupancy Statistics (% of Total Rooms, % of Total Available Rooms, and variants), ADR, ADR w/o Complimentary & House, RevPAR, arrivals (Reservation, Walk-in, Total, persons), departures, no shows, reservations made/cancelled today and room nights, adults, children, in-house guests, pets, averages per room and per adult, and forward-looking lines: tomorrow's arrivals and departures, % occupied tomorrow, next 7 days and next 31 days. No column chooser and no sorting.

Messages you may see

No record found!

Tips and FAQ

  • Q: Why do two occupancy figures differ? A: Statistics excludes V/Maint rooms from the divisor; Hotel Statistics shows both "% of Total Rooms" and "% of Total Available Rooms".
  • Q: Commission report misses a stay. A: It is filtered by check-out date and requires a commission posting.
  • Q: Where do I see tax by tax per day? A: Monthly Tax Detail.

Dedicated pages (one page and one video per report)

Every report has its own page with filters, every column, a worked example, troubleshooting and a short narrated video: