--- title: Automated Reservation Processing description: Single File Export Setup --- [Skip to content](https://hotelhelp.theguestbook.com/en/automated-reservation-processing#main-content) English Show submenu for translations [![GBLogoBlack](https://hotelhelp.theguestbook.com/hs-fs/hubfs/GBLogoBlack.png?width=50&height=48&name=GBLogoBlack.png)](https://theguestbook.com) Open main navigation Close main navigation - English Show submenu for translations - Go to RewardsDash Go to RewardsDash How can we help? - There are no suggestions because the search field is empty. 1. [Hotel Help Center](https://hotelhelp.theguestbook.com/en?hsLang=en) 2. [Cash Reward Suite Enhancements](https://hotelhelp.theguestbook.com/en/cash-reward-suite-enhancements?hsLang=en) # Automated Reservation Processing ## Single File Export Setup *This configuration consists of a single report created by an individual property.*  The purpose of the request report is to automate the rewards approval process on behalf of your hotel. By providing The Guestbook with a daily report export of reservation activity and final guest folio amounts, we can properly maintain the accuracy of reward eligible reservation records in our database and process rewards for your guests with minimal manual effort from your team. ### File Requirements: Mandatory fields:  | **Field** | **Field Description** | | --- | --- | | E-mail Address | Guest Email Address | | Last Name | Guest Last Name | | First Name | Guest First Name | | Confirmation Number (PMS) | Internal Confirmation Number from the PMS | | Status | Reservation Status (i.e. Reserved, Canceled, No Show, etc) | | Arrival Date | MM/DD/YYYY | | Departure Date | MM/DD/YYYY | | Rate Code | Ie. BAR, AAA, ADV | | Rate Plan Name | Ie. Best Available Rate, Flexible Rate, Advance Purchase Rate | | Source of Business | i.e. Web, Direct, Group, GDS | | NET Total | Room Charges, excluding taxes and fees | | Booking Engine Confirmation | External Confirmation from the Booking Engine | | Property Code | A unique non-digit code that is created by abbreviating and capitalizing the property name ( e.g., LCR for Le Chalet Resort). |   - Files need to be configured to include all reservations on the books that are scheduled to **depart within the last 2 days and everything 365 days in the future**. - Filters: If possible, you may filter out reservations on the books that have non-direct Source or Origin codes. For example, you do not need to send us reservation details for booking made through an Online Travel Agency (OTA) such as booking.com, expedia, priceline, etc. - As part of the setup, Hotels are required to provide us with a complete list of PMS codes, both for exclusions and calculation of eligible charges - Reservation status codes & definitions. i.e. x = canceled - Source codes & definitions. i.e. EI = Email Blast - Rate codes & definitions i.e. GBLV10 = 10pct off BAR - Files need to be in a Comma Delimited file (CSV) format, should have a unique file name and contain the headers (fields)  listed above. - Filename format (PROPERTYCODE\_RESV\_YYYY\_MM\_DD\_VERSION.CSV) - TGB\_RESV\_2021\_11\_16\_01.CSV - These files will need to be scheduled to be delivered to The Guestbook daily, via email,  to integrations@theguestbook.com - Sample File: \[insert link\] ### To get started: 1. Please review the file requirements above. If you are unable to create a custom report in your PMS to meet the above requirements, you may need to reach out to your Account Manager or customer support team of your PMS provider for assistance. 2. Please generate a sample reservations file based on the above requirements and send it to your Guestbook Partner Success Manager. The Guestbook will validate that the sample meets the requirements. If requirements have been met, your Guestbook Partner Success Manager will have you proceed with scheduling the report for daily delivery. 3. Audit - An audit process will last approximately 1-2 weeks to ensure proper reservation and reward processing.   - [General](https://hotelhelp.theguestbook.com/en/general?hsLang=en) - [Analytics and Reporting](https://hotelhelp.theguestbook.com/en/analytics-and-reporting?hsLang=en) - [Best Practices](https://hotelhelp.theguestbook.com/en/best-practices?hsLang=en) - [Cash Reward Suite Enhancements](https://hotelhelp.theguestbook.com/en/cash-reward-suite-enhancements?hsLang=en) - [Front Desk and Reservations](https://hotelhelp.theguestbook.com/en/front-desk-and-reservations?hsLang=en) - [Invoicing](https://hotelhelp.theguestbook.com/en/invoicing?hsLang=en) - [RewardsDash](https://hotelhelp.theguestbook.com/en/rewardsdash?hsLang=en) - [Booking Engines](https://hotelhelp.theguestbook.com/en/booking-engines?hsLang=en) - [FAQ's and User Guides & Training Videos](https://hotelhelp.theguestbook.com/en/faqs-and-user-guides-training-videos?hsLang=en#main-content) - [FAQ's](https://hotelhelp.theguestbook.com/en/faqs-and-user-guides-training-videos?hsLang=en#faqs) - [Training Videos](https://hotelhelp.theguestbook.com/en/faqs-and-user-guides-training-videos?hsLang=en#training-videos) - [Product Updates](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#main-content) - [2026](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2026) - [2025](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2025) - [2024](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2024) - [2023](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2023) - [2022](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2022) - [2021](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2021) - [2020](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2020) - [2019 and older](https://hotelhelp.theguestbook.com/en/product-updates?hsLang=en#2019-and-older) - [Integrations](https://hotelhelp.theguestbook.com/en/integrations?hsLang=en#main-content) - [Property Management System (PMS)](https://hotelhelp.theguestbook.com/en/integrations?hsLang=en#property-management-system-pms) [![Chill listening crop-3](https://hotelhelp.theguestbook.com/hs-fs/hubfs/GB-Logo-Black-lp.png?width=34&height=33&name=GB-Logo-Black-lp.png "Chill listening crop-3")](https://www.rewardsdash.com) Help Center Copyright © 2026, The Guestbook