M3 Back Office Export Setup

M3 Back Office Export mapping does not take place in Stayntouch PMS. The only item set in Stayntouch PMS configuration is selecting the data categories you wish to be included in the export files from Settings > Integrations > Back Office > M3 Back Office Export > Data Type.

Stayntouch PMS will then generate an export with a line item for each of the transactions that relate to the selected data sets. All the mapping configuration for the individual line items needs to be done on the M3 side.

Please note, the following items are needed to set up the interface:

Property ID: Provided by M3; this is their system code needed for the interface
Email Address:Company or property-specific email address to be sent to M3; this can include other email addresses by including a semicolon (;) between each email address
- An XML file will be generated based on the selection of report data below as part of the End of Day process and will be sent to the email address(es) listed

Any change of configuration in Stayntouch PMS that relates to the data sets included in the export needs to be reflected in M3. Examples of these report data include the following:

Ledger Balance Information
- Guest Opening Balance
- Guest Closing Balance
- Deposit Opening Balance
- Deposit Closing Balance
- A/R Opening Balance
- A/R Closing Balance
No Tax Items
- Financial Journal Charge Codes No Tax: Net postings for each charge code
- Financial Journal Rates No Tax: Net postings for charge codes that are of type ROOM
- Financial Journal Room Types No Tax: Net postings for charge codes that are of type ROOM
- Financial Journal Market Segments Tax: Net postings for charge codes that are of type ROOM
Standard Items
- Financial Journal Charge Codes: Postings for each charge code
- Financial Journal Rates: Postings for charge codes that are of type ROOM
- Financial Journal Room Types: Postings for charge codes that are of type ROOM
- Financial Journal Market Segments: Postings for charge codes that are of type ROOM
Reservation Count Rates
Reservation Count Room Types
Rooms Comp: Based on rate amount of 0.00; this is NOT based on rate code
Reservation Count Market Segments
Rooms Occupied
Rooms Arrival
Rooms Departure
Rooms OOO
Rooms OOS
Rooms Occupancy

M3 EXTRACTS/EXPORTS

Occasionally, M3 clients or an M3 representative may require "extracts" by date or need to view M3 exports. To provide these exports in the M3 format for historical dates, follow the steps below:

Go to Settings > Integrations > Back Office > M3 Back Office Export.

Confirm that you or M3 representative that needs the extract can receive emails that are sent to the email(s) listed in the Email Recipient for EOD Exports section. If they can, move onto the next step. If not, add them to the list and click SAVE CHANGES.

Toggle to SYNC tab from the right hand corner of the screen.

Select the date range that you require extracts for and click the blue SYNC button.

You can learn more about the M3 Back Office integration in the below articles: