Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
 

MyPMS offers powerful reporting capabilities from Booking and Housekeeping management to back end management and accounting. To see detailed instructions on how to find and use reports, see Reports in the Online Manual.

Reports  used for Accounting Purposes

Properties typically use some or all of these Reports for daily, weekly, monthly and annual reporting. To see detailed instructions on how to find and use these reports, see Reports in the Online Manual.

  • Transactions: give complete details for each category of items that you sell.
  • Transaction Summary: provides a total value for each category of items sold.
  • Advance Deposits: Shows all deposits received for bookings that have not yet arrived.
  • Advance Charges: Shows all charges on guest folios for bookings that have not yet arrived
    Column

    Accounting Reports provide a daily summary and a running month and year to date total of  all transactions: revenue, charges, and payments, etc.  

    The Reports can be run for a specific date or date range and sorted by various data such as source, agent and room type.

    The most comprehensive summary or "day-at-a-glance" of actual transactions is the Transaction Summary Report. This report is often run daily to see daily transactions (payments received and charges) The report provides a summary of daily, month-to-date and year-to-date totals of charges, payments, and AR payments. .

    The Reports are designed to be used in combination to give a summary view and detailed information when needed. For example, run the Transaction Summary Report to see a summary of transactions, then to see the details of Room Rent charges use the Transactions Report.

    The transactions displayed in the Transaction Summary Report can also be seen in the Manager's Report.  This report provides a summary of daily, month-to-date and year-to-date totals of revenue, charges, payments, AR Accounts, ARC, ARD and Forecasted Occupancy.

    To get a report of all of your taxable transactions and taxes paid by date range, use Tax Transactions Report The Tax Transactions Report displays every taxable transaction posted during the time period selected with the transaction amount and the tax amount charged to that transaction.

    To see the details of in-house (active) guest folio balances, deposits paid and balance due, use the In-House Guest Ledger (Daily Reports).

    Column
    width35%
    Info
    iconfalse
    titleAccounting Reports

    Children Display
    pageAccounting Reports

    Info
    iconfalse
    titleReports

    Children Display
    pageReports Tab

    As a manager, we know that you need to find information quickly and easily. Use this guide to help identify the reports most relevant to you. 

    To start with, 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 three 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.

    In-House Guest Ledger (Daily Reports) Report of all in-house (active) guest folio balances, deposits paid and balance due

    To get a report of all of your taxable transactions and taxes paid by date range, use this report:

    Tax Transactions Report The Tax Transactions Report displays every taxable transaction posted during the time period selected with the transaction amount and the tax amount charged to that transaction.

    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:

    ...

     

    ...

    (Daily Reports). Only available for clients who use the MyCard integrated credit card processing feature.

    ...

    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.
    Column
    width35%
    Info
    iconfalse
    titleAccounting Reports

    Children Display
    pageAccounting Reports

    This report displays all settled credit card transactions by batch.