• RE: USALI 11th Edition - where are you all coding Guest Satisfaction fees from Franchise

    I found the answer to the quest relations on the AHLEI (one of the groups involved in writing the 11th editions) FAQ web page.  The website address is https://www.ahlei.org/Resources/USALI/Uniform-System-of-Accounts-for-the-Lodging-Industry-FAQ/


    I have copied their answer regarding guest relations below


     I cannot find anywhere to code expense related to guest relations and service recovery (something provided to an unhappy guest). We code loyalty program point purchases on behalf of guests to a service recovery account and anything else to guest relations, both accounts in rooms department. I'm not sure what to do with these accounts. I've reviewed all departments.

    A:Recovery Costs related to customer service deficiencies should be captured as a Miscellaneous Expense item in the relevant department, or Entertainment-In House if the recovery involves purchasing Food & Beverage for the customer.


    I hope this information helps you.


  • RE: Multiple Budget Versions

    I do not think there is an option for more than one budget.  When we have needed more than one budget, we have used the forecast module.   However we also had to have a separate financial statement that pulls forecast instead of budget. 

  • RE: Closing a year with closing entry to retained earnings

    Did you post the offset to retained earnings to the individual Income and Expense accounts?  If so that could be causing the issue.   We created a specific expense account that we use to post the offset to the retained earnings.   Our account is called retained earnings offset.  We use the account number 9999999 and  do not include this account in our financial statements.

  • RE: three years of financial data for comparison in a financial report

    I have never run a report with 3 years of data.  However, it might be possible using  variable data columns.   You would need to submit the report using the date range option and enter a date range that covers all 3 years.   Then you would have to select the applicable date range for each column.    The variable column option is located under column editing-special tab.

  • USALI 11th Edition - where are you all coding Guest Satisfaction fees from Franchise

    We are starting to evaluate making our accounting system compliant with the USALI 11th Edition.  One item that I have not had any luck determining where it should be coded are the fees the franchise charges for guest satisfaction issues.  For example, a guest writes a letter to the Franchise indicting that they had an issue with a recent stay at our hotel.  The franchise responds by saying have a free meal on your next stay, fee room, etc.  Then turns around and bills us.  Currently we are using an account in rooms labeled guest satisfaction which is neither 10th or 11th edition compliant.  


    Any help or guidance that you can provide would be appreciated..

  • RE: Daily Report Mapping - Hilton

    I may be going down the wrong trail here, but my understanding of how the data flows to M3 is as follows

    • During the day, transactions are posted to ONQ using posting codes
    • When the revenue extract is created and sent to M3, the posting codes are not used to create the revenue extract. The revenue extract is created using People Soft general ledger accounts There should be attached to every posting code a people soft General Ledger code.  When the report is generated to be sent to M3, these people soft general ledger codes are used to create the report.  Normally this process works very well for the Rooms Department.  Based on my experiences, the F&B departments are problematic.  It depends on who set up your ONQ posting codes for F&B.   In most cases, I have seen multiple posting codes set up with the same people soft general ledger account which results in the revenue extract that is sent to M3 combining all the posting codes that have the same people soft general ledger into one amount.  Unless you are using the Revenue Extract report to populate a 3rd party accounting software or are using Hilton's People Soft  software, these codes do not get used as far as I know.  So the person setting up the codes, probably just uses a people soft account that they are familiar with  to assign to every posting code.

    If you have access to ONQ Operations Audit thourh the Hilton Lobby, you can look at the PMS mapping for the hotel which can be sorted by the People Soft general ledger account field.  If you see multiple posting codes going to the same People Soft general ledger account, it could be a sign of a problem.  Sometimes it is okay to have multiple items going to one people soft account if you want the amount to come over as one number to M3.

    To correct this issue, the posting codes will have to mapped to a different people soft general ledger accounts.   This mapping will have to be changed by someone physically at the hotel.    As far as I know this mapping cannot be changed remotely.  When looking at the People Soft general ledger codes, pay attention to the suffix of the account.  This suffix could be USD (us dollars), RM(room nights), COV(covers),etc..   For example, account 12345USD could be Dinner Revenue and 12345COV could be Dinner Covers.

    If you are having to make numerous changes to the mapping, you may want to call Hilton ONQ support and request that they suspend the one use authorization  code (this may not be the correct terminology) that is required to change the mapping for a period of time( the max amount of time maybe 2 hours)  If you do not suspend this one use code, every time you change the mapping on a PMS code, you will have to create a new one use code using ONQ's one use code generator which is a pain.

    Hope this information helps you.