Fairmas Exports

There are three custom exports that can be configured for Fairmas and emailed to Fairmas daily to include the data they require. These reports can be configured from Reports > Schedule a Report/Export > Custom Exports > +NEW EXPORT > Stays. The following reports should be scheduled:

FAIRMAS_Actual
FAIRMAS_Forecast
FAIRMAS_All_Financial_Transactions (Trial Balance)

No show and cancellation data is supported through Fairmas's report mappings: the FAIRMAS_Actual report supplies reservation-level data, while FAIRMAS_All_Financial_Transactions supplies the revenue totals.

To activate a Fairmas integration for your property, please contact Customer Support.

You can contact Fairmas Support at support@fairmas.com.

FAIRMAS ACTUAL

Select Fields: The following fields must be selected:
- DATE
- HOTEL CODE
- RESERVATION STATUS
- ROOM TYPE
- BLOCK COUNT
- SOLD
- ROOM REVENUE
- ADDON REVENUE
- FNB REVENUE
- OTHER REVENUE
- TAX REVENUE
- FEE REVENUE
- TOTAL REVENUE
- ARRIVAL ROOM COUNT
- DEPARTURE ROOM COUNT
- RATE CODE
- ADULTS
- CHILDREN
- HOTEL NAME
- MARKET CODE
- TRAVEL AGENT
Set Filters: The following filters must be selected:
- FIELD NAME: Date
- DURATION: Last 30 days
Frequency: The export should be configured for the following frequency:
- REPEATS: Daily
- REPEATS EVERY: 1 Day
- STARTS ON: Select the current date.
- STARTS AT: Select the desired time.
- ENDS ON: NEVER
Delivery:
- DELIVERY METHOD: Email Export Delivery Type
- ADD RECIPIENT: Should be delivered to Fairmas.
EXPORT NAME: FAIRMAS_ACTUAL
OUTPUT FORMAT: CSV
Choose INCLUDE CSV HEADER.
SAVE EXPORT

FAIRMAS FORECAST

Select Fields: The following fields must be selected:
- DATE
- HOTEL CODE
- RESERVATION STATUS
- ROOM TYPE
- BLOCK COUNT
- SOLD
- ROOM REVENUE
- ADDON REVENUE
- FNB REVENUE
- OTHER REVENUE
- TAX REVENUE
- FEE REVENUE
- TOTAL REVENUE
- ARRIVAL ROOM COUNT
- DEPARTURE ROOM COUNT
- RATE CODE
- ADULTS
- CHILDREN
- HOTEL NAME
- MARKET CODE
- TRAVEL AGENT
Set Filters: The following filters must be selected:
- FIELD NAME: Date
- DURATION: Current + 12 Months
Frequency: The export should be configured for the following frequency:
- REPEATS: Daily
- REPEATS EVERY: 1 Day
- STARTS ON: Select the current date.
- STARTS AT: Select the desired time.
- ENDS ON: NEVER
Delivery:
- DELIVERY METHOD: Email Export Delivery Type
- ADD RECIPIENT: Should be delivered to Fairmas.
EXPORT NAME: FAIRMAS_FORECAST
OUTPUT FORMAT: CSV
Choose INCLUDE CSV HEADER.
SAVE EXPORT

FAIRMAS ALL FINANCIAL TRANSACTIONS (TRIAL BALANCE)

Select Fields: The following fields must be selected:
- FINANCIAL TRANSACTION ID
- HOTEL CODE
- TRANSACTION DATE
- TRANSACTION TIME
- CHARGE CODE
- CHARGE CODE DESC
- REFERENCE
- CURRENCY
- AMOUNT
- ROOM TYPE
- RATE CODE
- SOURCE
- ORIGIN
- MARKET
- SEGMENT
- RESERVATION NUMBER
- EXTERNAL REFERENCE NUMBER
- GUEST NAME
- GUEST CARD ID
- COMPANY CARD ID
- COMPANY NAME
- TA CARD ID
- TRAVEL AGENT
- GROUP ID
- GROUP NAME
- ACCOUNT NUMBER
- BILL NUMBER
- INVOICE NUMBER
- FOLIO NUMBER
- PRE STAY
- POST STAY
- USER NAME
- CHARGE GROUP
- CHARGE TYPE
- AR INVOICE NUMBER
- CC PAYMENT REFERENCE
- TRANSACTION DETAILS
- ROOM NUMBER
- AR NUMBER
Set Filters: The following filters must be selected:
- FIELD NAME: Transaction date
- DURATION: Yesterday
- FIELD NAME: Charge code
- OPTIONS: Select necessary charge codes
Frequency: The export should be configured for the following frequency:
- REPEATS: Daily
- REPEATS EVERY: 1 Day
- STARTS ON: Select the current date.
- STARTS AT: Select the desired time.
- ENDS ON: NEVER
Delivery:
- DELIVERY METHOD: Email Export Delivery Type
- ADD RECIPIENT: Should be delivered to Fairmas.
EXPORT NAME: FAIRMAS_All_Financial_Transactions
OUTPUT FORMAT: CSV
Choose INCLUDE CSV HEADER.
SAVE EXPORT