Knowledgebase
Reports: Accounting Reports in MyPMS
Posted by - NA - on 10 Jan 2008 03:02 PM

To start , use these two reports to get a picture of the current day, week, month, etc. transactions,

Transaction Summary: Summary of all transactions for the day, Month to date and Year to date.If you need to see details of these transactions, then go to the summary Report.

Transactions: Detailed report of every transaction made during a specific date range. 

To reconcile any differences between transactions charged and payments received, use these two reports:

Advance Deposits: Running total of all deposits taken before the check in date.

Advance Charges: Running total of all charges posted before the check in date.

If you take Direct Bill Payments:

Accounts Receivable Aging: shows money owed by clients with credit and how overdue it may be 30, 60, 90,120 days.

If you have Travel Agents:

Travel Agent Commissions: This report makes is easy to keep track of agents and commissions based on the amount set for each individual Travel Agent.

If you use MyCard Payment Processing:

Batch Settlements: These reports are only available for clients who use the MyCard integrated credit card processing feature.( under Daily Reports)


The basic principles of the Reports are common to all Property Management Systems, but the use of some terms, such as the dates, are important enough to provide further details.

DEFINITIONS of Reports and the use of the <time> choices to be made when desiring to get report data out of the system.

  • System date = date hotel considers it to be prior to night audit
  • GMT = Greenwich mean date time on server
  • Local time = hotel's local date time

Generally the system date (what is called the hotel date, which is what date the property THINKS the date is) is used to do the queries. The exception is the two reports where the user has the option of entering a time as well as a date (those are User Activity and Transactions). For those two reports, if the user enters a date only the system date is used. If the user enters BOTH a date and a time, the hotel's local time is used.

Below are a list of commonly referred to Abbreviations in MyPMS Reports.

  • ARD - Advanced Room Deposit, commonly referred to as an Advanced Deposit.
  • ARC - Advanced Room Charge, commonly referred to as an Advanced Charge.
  • ADR - Average Daily Rate. This is the Average Daily Rate of a booking, or bookings over a period of time. For example you have a three day booking with Friday arrival. The first night rate is $250, the second night rate is $250 and the third night rate is $175 the ADR is $215 (675 / 3).
  • RevPar - Revenue Per Available Room is an important metric relevant to the hotel industry. Often it is utilized as a primary statistic indicating the overall financial performance of a property. RevPar is calculated based on a formula of Occupancy % * ADR.