Stop the stress of hand entering M3 Daily Reports

Here are a few quick overview videos and steps of what is needed to get your M3 Daily Reports manually entered. 
They cover:

Typing on a Keyboard
  • What PMS reports are needed so you aren't scratching your head about what to enter

  • What activity to review, enter, and ignore on those reports

  • Quick tips and items to consider when entering to keep things simple and easy to follow

Please note, these videos do not go over how to enter an activity into M3 but instead the key points and ideas to work through so that the activity can be manually entered
without stress or overwhelm.

Overview of what these quick, simple training videos cover along with key considerations to make entering activity into your M3 Daily Report fast, accurate, and simple. 

Opera Reports Needed:

 

  • Trial Balance: provides all activity for the hotel including ledger activity

  • Day/MTD/YTD Stats: provides total room revenue and market segments

  • Managers Report: gives Room stats for Rooms Sold, OOO, etc.

Opera PMS

  1. Day/MTD/YTD Stats: Enter total rooms sold into the first market segment in the statistics section of M3 (found at bottom of M3 daily Report). Enter the Grand Total Room Revenue into the first Market Segment in M3 (at top of M3 daily report).  A reclass from your hotel accountant will be needed at end of the month to move this activity to each market segment if applicable.  You can enter the room revenue and statistics from this report if you would prefer to not have to reclass the room revenue activity at end of month.

  2. Managers Report: enter any OOO, Comp, or Vacant Rooms your hotel tracks from this report into M3

  3. Trial Balance Report: Enter NET Ledger Activity for each ledger by taking the Ending Ledger Balances – Beginning Ledger Balances.  This activity will then be entered into each ledger typically called (Guest Ledger Net Change, AR Ledger Net Change, or Deposit Ledger Net Change in M3).  

  4. Hit Calculate in M3 to make sure ledgers match PMS reports. You will receive an M3 error Message

  5. Enter activity from Trial Balance to record all revenue, non-revenue, taxes, and settlements. Do not enter activity highlighted orange on the Opera cheat sheet as this has already been recorded from another report.  For any Adjustments, you will need to subtract that amount from the original account and enter that adjusted amount into M3.

  6. Calculate in M3

  7. Rollover activity

7 Simple Steps to Entering Activity Into M3 Daily Report Module

Opera Entering Video

Marble Surface

ONQ Reports Needed:

 

  • Trial Balance – provides revenue, taxes, non-revenue, and receipt activity. It does provide an activity that is not entered into M3 but is easier to read than the RVYACCTG Report when hand entering activity into M3

  • Detailed Receivables Recap - Ledger Activity

  • PTD-YTD Management or DAYSTATS Reports-  both provide statistics and OOO room counts

OnQ PMS

  1. PTD-YTD Management or DAYSTATS Reports: with either report enter statistics into M3- this is at the bottom of your M3 daily report

  2. Detailed Receivables Recap: Enter NET Ledger Activity for each ledger by taking the Balance –  Yesterday’s Balance to get the Net Activity for the day and enter into the Accounts Receivable section in M3 (typically the lines are called Guest Ledger Net, City Ledger Net, Advance Deposit Ledger Net)

  3. Hit Calculate in M3 to make sure ledgers match PMS reports. You will receive an M3 error Message

  4. Enter activity from the Trial Balance (make sure to not enter an activity in the attached guide for lines highlighted orange.  This activity is already being recorded)

  5. All Room Revenue will be entered by using the GST RM names and any Transient-Group Allowances into the Rack/BAR line in M3 as a lump sum.  A reclass will be set up at end of the month to move this activity to each market segment if needed.

  6. Calculate in M3

  7. Rollover activity

7 Simple Steps to Entering Activity Into M3 Daily Report Module

OnQ Entering Video

Galaxy Reports Needed:

 

  • Daily Revenue Report – provides revenue, taxes, non-revenue, and receipt activity. Also provides Guest Ledger Net Activity for the Day (Balance Today)

  • AR Summary Report – City Ledger Activity (Pro Tip: make sure that the Net activity on this report matches any activity listed as Direct Bill on the Daily Revenue Report)

  • Advance Deposit Balance Sheet – Advance Deposit Ledger Activity

  • Managers Statistics Report – provide statistics, comps, and OOO room counts

  • Market Segment Analysis – provides market segment details of room revenue and room counts

Galaxy PMS

  1. Managers Statistics Report: enter general room statistics into M3- this is typically at the bottom of your M3 daily report

  2. Market Segment Analysis: All room revenue will be entered into the first room revenue and statistics lines in your M3 daily report to save time.  A reclass will need to be completed by your hotel accountant to move this activity out of those accounts to each market segment for your hotel financial statements to be accurate.

  3. Advance Deposit Balance Sheet and AR Summary Report- Enter NET Ledger Activity for each ledger by taking the New Balance – Balance Prev Day to get the Net Activity for the day and enter into the Accounts Receivable section in M3 (typically the lines are called Guest Ledger Net, City Ledger Net, Advance Deposit Ledger Net)

  4. Daily Revenue Report: Enter activity (make sure to not enter the activity in the attached guide for lines highlighted orange.  This activity is already being recorded)

  5. Hit Calculate in M3 to make sure all activity has been entered: Revenue, non-revenue (taxes) and settlements

  6. Calculate in M3

  7. Rollover activity

7 Simple Steps to Entering Activity Into M3 Daily Report Module

Galaxy PMS Entering Video