PS: Managing the STR Export File

The Hook:

• Use this workflow to define which GL accounts and data points are included in the STR Export File.
• The STR Export List (identified by the STAR type) acts as a filter, determining exactly what data is shared with STR. Administrators can modify this list to ensure the correct revenue and statistical accounts are being reported.

 

Prerequisites:

• Permissions: Requires Company Admin access to the Report Designer.
• Knowledge: You must know which specific export list you need to modify (e.g., Daily Rooms, Monthly F&B). 

 

Common types include:

• STARRMDAY (Rooms - Day)
• STARRMMONTH (Rooms - Month)
• STARFBDAY (F&B - Day)
• STARFBMONTH (F&B - Month)

 

The Steps:

Phase 1: Adding Accounts to the List

1. Navigate to the Admin menu and select Report Designer.
2. Locate the row where the Types column matches your target STR Export (e.g., STARRMDAY).
3. Click the List icon in the Actions column.
4. Click the Switch to Items View link at the top of the screen.
5. Locate the specific GL account to add:
   1. The screen defaults to the Rooms department.
   2. Use the Options icon or the Arrows next to the Department Name to navigate to other departments.
6. Check the box in the Select column (far right) for the line item you wish to add.
7. Click Save.

 

Phase 2: Configuring Sort Order and Value Types:

1. Click Switch to List View to return to the main list.
2. Locate the newly added items.
3. Enter a number in the Sort column to determine the display rank.
4. Assign a ValType (Value Type) to the line item using the table below.
5. Click Save.

 

Configuration Guide: Supported Value Types:

When assigning a ValType in Phase 2, use only the following options.

ValType	Definition
AMT	Displays the Amount of the Account (Revenue).
STAT	Displays the Statistic of the Account (Rooms Sold, Covers).
LAB	Displays the Site #, Date, Property, and Currency. (Do not use this for GL accounts).

The Result:

• Success: The new line item is saved and will be included in the next generated STR Export file.

 

Troubleshooting:

• Critical Warning: DO NOT change, edit, or delete the Label, Types, or ValType for the Site #, Date, or Property Name rows. These are required system fields; altering them will break the export file.
• Data Mismatch: Ensure you used AMT for revenue lines and STAT for statistical lines. Mixing these up will cause data rejection or incorrect reporting.
• Verify: Confirm there is a STR ID under the Property ID column within the Accounting > Import Monitor> Interface Type is Weekly STR or Monthly STR. If no STR ID exists, please reach out to Support to add the STR ID.