M3 is a cloud-based financial platform used by over 1,000 management groups and owner-operator businesses. With an interface connected to RoomKeyPMS, daily revenue and occupancy metrics can be exported and then imported into the M3 platform to be used with the following M3 products:
Once you purchase M3 to interface with RoomKeyPMS, the connection process is initialized.
Click below to see what information can be sent to M3:
We can send room revenue categorized by room charge code to M3
If you prefer to categorize this revenue by room number instead, please see Room Revenue by Room Number below.
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes), room charge codes will appear in the Codes tab. These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = Tran ID
- AccountDescription = Code
| AccountingId = 1 | AccountDescription = RCH |
| AccountingId = 12 | AccountDescription = RMCH-NT |
| AccountingId = 46 | AccountDescription = RM-WK |
| AccountingId = 47 | AccountDescription = RM-MTH |
We can send other revenue (non-room charge revenue, like sundry sales, call-accounting charges, cancellation/no show fees, etc.), categorized by charge code to M3.
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes) other charge codes will appear in the Codes tab, when you use the drop-down field on the right-side, select Other Charge.
These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = Tran ID
- AccountDescription = Code
| AccountingId = 10 | AccountDescription = PHONE |
| AccountingId = 11 | AccountDescription = CANCEL |
| AccountingId = 15 | AccountDescription = COTTAGE |
| AccountingId = 16 | AccountDescription = LKSIDE |
We can send payment revenue categorized by payment code (i.e. Visa, Mastercard, Cash, etc.) to M3.
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes) other charge codes will appear in the Codes tab, when you use the drop-down field on the right-side, select Payments.
These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = Tran ID
- AccountDescription = Code
| AccountingId = 2 | AccountDescription = VISA |
| AccountingId = 3 | AccountDescription = MC |
| AccountingId = 4 | AccountDescription = DISC |
| AccountingId = 5 | AccountDescription = AMEX |
We can send the net change for three receivable GL Accounts (Ledgers) to M3. The standard receivable accounts are listed below, but note that they may have a custom name or account ID in your database.
- A/R Guest this account is used to track revenue while guests are in-house
- A/R City this account is used to track non-guest revenue, and any invoices owed after guest check-out
- Deposit Holdings this account is used to track revenue before guest arrival
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes) receivable accounts appear in the GL Accounts tab.
These ledgers are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = Account identifier
- AccountDescription = Account name
| AccountingId = 1100-100-1010 | AccountDescription = A/R Guest |
| AccountingId = 1200-100-1020 | AccountDescription = A/R City |
| AccountingId = 6700-120-1030 | AccountDescription = Deposit Holdings |
We can send daily occupied room counts categorized by room charge code to M3.
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes), room charge codes will appear in the Codes tab. These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = rooms_Tran ID
- AccountDescription = Code
| AccountingId = rooms_1 | AccountDescription = RCH |
| AccountingId = rooms_12 | AccountDescription = RMCH-NT |
| AccountingId = rooms_46 | AccountDescription = RM-WK |
| AccountingId = rooms_47 | AccountDescription = RM-MTH |
We can send daily guest counts for Adults and Children categorized by room charge code to M3.
Where is this information in RoomKeyPMS?
In the Transaction Codes module (System Configuration > Transaction Codes), room charge codes will appear in the Codes tab. These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
Adult Occupancy
- AccountingId = adults_Tran ID
- AccountDescription = Code
Child Occupancy
AccountingId = children_Tran ID
AccountDescription = Code
| AccountingId = adults_1 | AccountDescription = RCH |
| AccountingId = adults_12 | AccountDescription = RMCH-NT |
| AccountingId = adults_46 | AccountDescription = RM-WK |
| AccountingId = adults_47 | AccountDescription = RM-MTH |
| AccountingId = children_1 | AccountDescription = RCH |
| AccountingId = children_12 | AccountDescription = RMCH-NT |
| AccountingId = children_46 | AccountDescription = RM-WK |
| AccountingId = children_47 | AccountDescription = RM-MTH |
We can send room revenue categorized by room number to M3.
If you prefer to categorize this revenue by room charge code, please see Room Revenue by Room Charge Code above.
Where is this information in RoomKeyPMS?
In the Reports menu, select Audits and then select the OA Reconciliation report.
These codes are "mapped" to the AccountingId and AccountDescription in M3 as follows:
- AccountingId = r_Room Number
- AccountDescription = RoomRevenue
| AccountingId = r_109 | AccountDescription = RoomRevenue |
| AccountingId = r_111 | AccountDescription = RoomRevenue |
| AccountingId = r_112 | AccountDescription = RoomRevenue |
| AccountingId = r_113 | AccountDescription = RoomRevenue |
STEP #1 M3 Clerk Setup in RoomKeyPMS
A RoomKeyPMS Trainer will setup the following ClerkID in your database:
- Login Name: [Hotel Name]M3
- First Name: M3 Export
- Last Name: DO NOT REMOVE
- User Role: Clerk
All permissions will be removed from the Clerk ID and it will only be used as an access point for M3. Please do not change or remove this Clerk ID; any changes or removal can effect the M3 Export functionality.
The RoomKeyPMS Trainer will let you know when this is completed and advise that a representative from M3 will reach out to you for Step #2.
STEP #2 Account Review and Interface Finalization
A representative from M3 will contact you to review the details of your M3 account and finalize the interface with RoomKeyPMS.
If you have questions about your M3 Platform, Click Here to access the M3 Help Desk.