Videos
83 videos.
SunPMS video manual, chapter "Reports". Every SunPMS report: room, guest, daily, collection, monthly, tax, yearly, ledger, reservation and housekeeping reports, charts and the report dashboard.
SunPMS has about 75 reports grouped in categories: Room, Guest, Daily, Monthly, Yearly, Ledger, Reservation, Housekeeping and Charts. You find them in a report library (search box, category list, one card per report) and almost all of them open in one common report page: a header with the period…
Eight reports about rooms, room types and rates. Open them from Reports Room Reports. For common behaviour (filters, columns, export) see 00-overview.
Nine reports about who is arriving, staying and leaving. Open them from Reports Guest Reports. Common behaviour is in 00-overview.
Nine reports for one business day: what happened, what it earned and what is owed. Payment-focused daily reports are in 04-daily-collection-reports. Report date = the From Date picker (single date, starts on the PMS date).
Ledger reports show money owed or held at the end of a date, not activity. Each report has one date filter (From Date, the "as of" date). ".
Three line charts that compare one month, day by day, with the same month of the previous year. Under each chart is the table of values. Open from Reports Charts (Report Dashboard pill Chart; Occupancy Chart appears only in the report library).
The Report Dashboard is a page of report cards grouped by category pills, with a Favorite Reports strip on top for the reports you use every day. Use it when you know the report category but not the exact report name, or when you want one-click access to your favourites.
Find the report that answers your question. Report names are as in the report library (Reports in the left menu). Typing a word in its search box also searches what each report shows.
The ADR Chart shows, for every day of one month, the average daily rate (room rent divided by rooms sold) as a table and a line graph. A second line shows the same month of the previous year when it has data.
The RevPAR Chart shows, for every day of one month, the revenue per available room (room rent divided by all available rooms, sold or not) as a table and a line graph. A second line shows the same month of the previous year when it has data.
Daily Guest Payment is a customized report. For one day it lists every guest folio that received a payment on that day, with the cash and card amount of that day and the amount still due on the folio. Cashiers and accountants use it to see who paid what today and who still owes money.
com or a travel agent, grouped by channel category, with the share of rent and other charges and a grand total.
The Sales & Channel Aging Report shows, for each sales and channel that is billed directly (a company or travel agent account), what it still owes and how old the charges are. The age buckets are 30 days, 60 days, 90 days and more than 90 days, each with the charges and the payments of the bucket.
The Cashiers Report is for counting the till. It does not take a date: it shows what one desk user has taken in the shift that is open right now, by payment type, with refunds and deleted payments, and the grand total that the cash drawer must match.
The Credit Card Activity Report lists every card transaction of a date range, including deleted payments, declines and business-source card payments, with the gateway date and ticket data, so that the accountant can reconcile with the payment gateway statement.
The Daily Balance Report lists the in-house guests of one day and how much each of them owes at the end of that day: the balance brought forward, the charges of the day, the payments, the discount and the new balance.
), with the desk user, payment time, folio number, room, guest, dates, card number, deposit amount, payment amount and gateway ticket. A legend at the end explains the symbols.
The Daily Collection Report lists every payment received on one day, line by line, with the guest, room, desk user, payment date and time, payment type and amount, and totals it by payment type. It is the accountant's list for matching the day's receipts with the cash and the bank.
The Daily Credit Card Collection Report lists the card payments of one day with the card type, the masked card number and the authorization code, grouped by card type with a summary, so the accountant can match the day to the card machine or gateway settlement.
The Daily Deposit Report lists the deposits (advance payments) taken on one day, grouped by deposit type, with the folio number, guest, room and the desk user.
The Daily Other Charge Report lists the other charges (laundry, mini bar, miscellaneous and so on) posted on one day, with quantity, rate, amount, tax and total, and a summary per charge at the end.
The Daily Rate Change Report lists the stays where the rate charged to the guest differs from the rate on your rate card for that room type and date. It exposes discounts and manual overrides made at the front desk.
The Daily Sheet Report is the Daily Report with the payments split by type and every tax of your property in its own column. It is the sheet an accountant wants when the day has to be booked tax by tax and cash against card.
The Desk User Shift Report (card Daily Shift, shown with the screen title Desk User Shift Report) lists the payments of every shift of every desk user in a date range, one block per shift, with the status of each line and a total for each shift.
The Daily Summary Report (card Summary) is the one page that owners read: rent and taxes, other charges, payments by type, discounts, miscellaneous income and expense, room status counts and the statistics Room Sold, Occupancy Rate, ADR and RevPAR.
The Daily Report lists every folio that moved on one business day (reservations, arrivals, stay-overs and departures) with that day's rent, tax, other charges, discount and payments.
The Desk User Activity Report counts, day by day, what front desk users did: reservations made and cancelled, check-ins, check-outs, and the money they received, with the ADR of the rooms they checked in.
The Hourly CheckIn Report (screen title Hourly CheckIn Report) lists the hourly (short-stay) check-ins of one day with the duration in hours, charges, payments and balance. It is for hotels that rent rooms by the hour.
The Tax Detail Report shows, for each guest staying on one day, the rent and the tax charged on it, one column for each tax of the property, and the total tax. It is used to prepare the tax return and to check that the right tax was applied.
The Adult Child Detail Report counts, for each day of a month, how many adults, children and pets stay in the hotel and how many rooms are occupied. It is a headcount by day.
The Guest Arrival Report lists every stay whose arrival date falls in the dates you choose: guests who are still only reserved and guests who have already checked in. For each one it shows the room, folio number, arrival time, departure date, guest, number of guests, rate, total charges, payments…
The Guest Departure Report lists the stays whose departure date is the date you choose. It splits them into Guests To Check Out (still to leave) and Guests Checked Out (already left), with the balance each one owes. It is the day's check-out list.
The Guest Classification Report groups stays by where the guest came from: the sales and channel category (for example Walk-In, Travel Agent, OTA, Corporate) and the sales and channel (the agent or company).
The Guest List Report lists the guests of all stays that touch the dates you choose: who is In house and who has Checked Out, with room, room type, address, phone, e-mail, birth date, nationality, identity document and credit card reference. It is the standard "who is in the hotel" list.
The Guest Stay Summary Report shows, guest by guest, the stays that start in a date range: room, arrival date, the rent, tax and other charges of the stay and how the guest paid (cash, check, card, deposit, other, Sales & Channel). Choose one guest to get his or her stay history.
The Guest Vehicle Detail Report lists the vehicles of the guests who are in the hotel on a chosen date: guest, room, arrival and departure, make, model, year, colour, licence plate, state and remark. Security and the parking attendant use it to know whose car is in the car park.
The Most Stayed Guest report ranks your guests by the number of stays that arrived in a date range. For every guest it shows the contact data, the number of stays, the nights, the first and last arrival and the amount of money of those stays.
The Remaining Guest Checkout Report lists the guests who are due to leave on a chosen date and are still in their room (not checked out yet), with building, floor, room and the balance they still owe. It is the chase list for late check-outs.
The House Keeping Summary Report counts, for each day of a date range, how many housekeeping tasks of each kind are scheduled: for example how many rooms need Towels, Bed Sheets, Vacuum or a Minibar Check. It is the workload forecast of the housekeeping department.
The Special Request Report lists the special requests typed on reservations and folios (for example "high floor, quiet room away from the lift") for the guests of a chosen day, with floor and room, so that housekeeping and the front desk can prepare the room before the guest arrives.
The Account Receivable Ledger lists the amounts that companies, travel agents and other Sales & Channels owe the hotel as of a date: opening balance, amount billed to them (guest bills transferred to direct billing), payments received from them and the balance. It is the "city ledger" of the hotel.
The Advance Deposit Ledger lists the advance payments the hotel holds for guests who have not arrived yet (reservations), as of a date. Each line is a payment, a refund or a cancellation movement of a reservation, and the balance column shows the money that is still held.
The Group Ledger Report lists the payments taken for a group that have not yet been allocated to the folios of the group members, as of a date. When a group (a wedding party, a tour) pays a lump sum on the group folio, the money sits in the group ledger until the desk moves it to the rooms.
The Guest Ledger Report lists the guest folios that have an unpaid balance as of a date: guests who are in the house and guests who have checked out but still owe (or are owed) money.
The Inhouse Deposit Ledger lists the deposits the hotel holds on guest folios as of a date: payments that were taken with a Deposit Type (for example a refundable security deposit) and have not been refunded or applied to a charge. It covers reservations, guests in the house and checked-out folios.
The Ledger Summary Report puts all the ledgers of the hotel on one page: the closing balance of the guest ledger, the account receivable ledger, the advance deposit ledger, the deposit ledger and the group ledger as of a date.
The Monthly Bad Debts Report lists payments whose payment type belongs to the Bad Debts category: bills that the hotel gave up collecting. Lines are grouped as Reservation, Checkin(s), Sales & Channel, Group and Miscellaneous Income and end with a Grand Total.
The Monthly Balance Due Report lists checked-out folios of the period that are not fully paid. Each line is one guest with the rent, tax, other charges, discount, payments and the Balance Due; the last line Total: adds the columns. Folios with no balance are not shown.
The Monthly Balance Report shows, for every day of the period, the Previous Balance carried from the day before, the day's Today's Rent, tax and other charges, the payments, discount, direct billing and Advance Deposit, and the resulting Total Balance.
The Monthly Sales & Channel Summary Report (card Sales & Channel Summary) has one line per Sales & Channel: Sales & Channel (the name), Balance B/F, Room Charges, Payments, Commission B/F, Commission, Commission Payment and Balance Due. A Total line adds all sources.
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…
). The last column is the day total and the last row the period total.
)., CRS FolioNo #, Date In, Date Out, Total Charges and the Commission Amount. Lines are grouped by Sales & Channel name.
The Monthly Credit Card Report lists card payments only: one row per day and one column for each card type that has payments in the period (Visa, Master Card, American Express, Discover, JCB, Diners Club, Union Pay, Debit Card, Check, Other), then a Total column.
The Hotel Statistics Report is a one-page management summary for the date you choose. It has a column Description and two blocks, Current Year and Last Year, each with Today, Month To Date and Year To Date.
The Monthly Other Charge (Columnar) Report shows other charges as a grid: one row per Date, one column per other charge that has a posting in the period (for example Miscellaneous, Laundry per piece, Mini bar water), then Total Tax and Total, and a Total row at the bottom.
The Monthly Other Charge Report lists every other charge posted to folios in the period: Charge Name, Room Name, Guest Name, the desk User Name, the Amount, the Other Charges Tax and the Total. Lines are grouped by posting date and each date ends with a Total; a last Total adds the whole period.
The Monthly Refund Report lists every refund payment of the period: the date, room, guest, payment type, the Bill Amount of the folio and the Refund amount. Lines are grouped under the desk user who recorded the refund and the report ends with a Total line.
The Monthly Room Sold Report has one row per date with the number of Room Sold and the number of Available Room, plus a Total row. It is the room-night count behind occupancy figures.
The Monthly Sales Report is a room by day grid for one calendar month: one row per room, one column per day with the rate sold that night, then totals per room and per day (room sales, nights sold, paid and complimentary nights, ADR and occupancy).
The Monthly Sheet Report repeats the Monthly Report in an accounting layout: for every date it shows rent, one column per tax of the property (and one column for each tax exemption), other charges with sales tax, discount, and the payments split into Cash, Check, Card and Other Payment.
The Monthly Statistics Report has one row per date with Arrival, Reservation, Room Sold (Occu. 92)), ADR, Rev PAR, Occupancy Charges, tax, Total Other Charges, tax, Discount, Total, Total Payment and Total Deposit, and a Total row.
The Monthly Tax Detail Report has one row per Day. It shows the number of rooms sold, the rent and the tax of each configured tax (City Tax, State Tax, GST 12% on the demo hotel) with their Total, then the other charges (Charge Amount, Sales Tax, Total), and finally the Rent (No-Show/Cancel) with…
The Monthly Tax Exempt Claim Report has one line per tax-exempt stay: Room Name, Folio #, Guest Name, Date In, the Claim Period From and To, the Rent, the Occupancy Tax exempted, split into Occupancy Tax/Day and Occupancy Tax/Stay, and the Payment received on the folio.
The Monthly Tax Exempt Report lists every night in the period on which tax was exempted: date heading, Room Name, Guest Name, the Rate of the night, one column per exempted tax (for example City Tax Exempt) and the Total exempted tax. The last lines Total: and Grand Total add the columns.
The Monthly Undo Report lists the operations undone through Utility Undo Transaction in the period: Desk User, Undo Date, Room, Guest Name, Folio #, UndoOperation (what was undone, written as from status - to status) and the Reason that the user typed.
The Monthly Report is the day by day financial summary of the hotel for any period you choose (usually a month). For every date it shows the rent, tax, other charges and discount posted that day and the payments received, in one line for Rental Guest and extra lines for Direct Billing…
The Monthly Multi Currency Report lists the folio payments received in a currency other than the property (base) currency. Payments are grouped under a heading Currency Name:- currency;
The CRS Rate Plan Report lists the reservations made in a date range together with the rate plan name and the CRS engine (online channel) they came through. ). When the hotel has no channel connection, the plan and engine columns stay empty, but the report still works as a list of all reservations…
The No-Show/Cancel Revenue Report lists the revenue the hotel kept from reservations that did not arrive (No-Show) or were cancelled, after it was posted with Noshow/Cancel Revenue Posting (menu Audit): the advance deposit that was held, the rental revenue and the tax that were recognised from it.
The Reservation Detail Report is meant to list every reservation (folios that have not been checked in yet, plus cancelled and no-show ones) for a date range, with guest, phone, e-mail, room or room type, dates, payment, status, source, ADR and total charges.
The Block Room Report lists the rooms that are blocked out of sale (for repair, maintenance, owner use) for a range of dates, with the reason and the user who blocked them. A blocked room cannot be sold and does not count as available in the occupancy figures.
The Change Room Report is the log of guests who were moved from one room to another during their stay or reservation. For every move you see the guest, the folio, the time spent in each room, who made the move and the reason typed at the time.
) sold in a period: how many rooms, what share of the hotel, the room charges, the total charges and the average daily rate (ADR).
The Revenue By Room Type Report shows, for each room type and for a range of dates, how many room-nights were sold, the rent, the occupancy tax, the other charges and their tax, the average daily rate (ADR) and the revenue per available room (RevPAR).
The Room History Report shows, room by room and night by night, which guest occupied the room, what rent and tax the night produced, what other charges were posted on that date and how much was paid on that date by cash, bank, card or direct billing. It is the "statement of a room".
The Room Type Rate Change Report is the audit trail of the Rate Manager. Every time someone saves a rate for a room type and rate plan, the old and the new value are recorded together with the user and the time.
The Room Type Rate Report is the printed rate card of the hotel. It lists, for every room type and every rate plan (rate type), the price that is loaded in the system for the current PMS date. It has no filters: it opens already run.
The Room Type Restrictions Change Report is the audit trail of the booking restrictions in the Rate Manager: Close To Arrival, Close To Departure, Sold Out, Minimum Nights and Maximum Nights.
The MTD/YTD Comparision report ("Month-to-date vs. Year-to-date", screen title MTD/YTD Comparison Report) puts the figures of a period (normally the month to date) and of the year to date next to the same figures of last year, and shows the variance.
The Yearly Room Sold Report is a grid with one row per day number (Sold Date 1 to 31), one column per month (Jan to Dec) and a Total column. Each cell shows rooms sold | rooms available for that calendar date, and the last row Total adds the months.
The Yearly Sheet Report shows, for each month from From Month to To Month of the Year, the lines Rental Guest, Direct Billing and Miscellaneous Income in the columns of the Monthly Sheet: Rent, one column for each tax and one for each Exempt amount, Other Charges, Sales Tax, Discount, Cash, Check…
The Yearly Report has one block per month for the From Month to To Month of the chosen Year. ), the lines Rental Guest, Direct Billing, Miscellaneous Income and Miscellaneous Expense. A final Total block adds the months.
