There are 6 report types in Cloudbeds Insights: Financial, Guests, Reservations, Occupancy, Payment and Invoices.
The report type controls the scope of data available in the report, for example, Financial report type has Cloudbeds Data Fields and filters available related to financial data — whereas Guests report type has everything related to guest's data.
Cloudbeds Data Field (CDF) is a data field provided and defined by Cloudbeds. This article list all CDFs available in each report type.
Financial
Financial transactions that are made, including debits and credit and their attributes.
Only reservations with posted transactions in the Folio will be displayed in the report. If a reservation has only future transactions (pending) or the reservation status is Cancelled/No Show without any transactions in the Folio, the reservation will not be displayed in the report.
Cloudbeds Data Field | Description |
Booking Date Time - UTC | When the reservation was originally made, in UTC time. |
Booking Date Time - Property | When the reservation was originally made, per the property's time zone. |
Check-In Date | Date the reservation starts, when the guests arrives, the first room night. |
Check-Out Date | Date the reservation ends and the guest departs. |
Rate Plan - Channel Name | Displays the rate plan name as received from the channel. |
Rate Plan - Private Name | The rate plan name that is unique to the rate plan and that is only visible internally. |
Rate Plan - Public Name | The Rate plan name that is visible to the customer. Different Rate Plans may have the same name. |
Reservation Number | The confirmation number that the Cloudbeds System automatically assigns to a reservation and that uniquely identifies a reservation. Sometimes refered to as Reservation ID. |
Reservation Source | How reservation was booked: Phone, Booking Engine, Expedia, etc Sometimes referred to as the Channel. |
Reservation Status | Status of the Reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, or No Show. Could be another custom status (hardcode). |
Room Number | The number or name that identifies the room(s) associated with the transaction. |
Room Type | The type of room, as categorized in MFD. |
Hotel Collect Booking Flag | Channel Pay or Hotel Pay. |
Card Type | The credit card type on file for the reservation, for example Visa, Discover, etc. |
Reservation Source Category | The groups of reservation sources: Direct, Group, Wholesaler, OTA, or Travel Agent. |
Group Profile Type | The type of group: Group (one time event), Company, Travel Agent, Wholesaler. |
Group Profile Name | Group Profile is the master profile under which a certain group of reservations is created or added. This could be a company, wedding party, travel agent, etc. It may or may not be associated with a group block allotment. |
Cloudbeds Data Field | Description |
Add-on Charge Type | The Add-on item that was purchased along with the reservation. An Add-on is a item or service that is purchased via mybooking along with the reservation. |
Add-on Item | The Add-on item that was purchased along with the reservation. An Add-on is a item or service that is purchased via Cloudbeds Booking Engine along with the reservation. |
Credits | The amount of payment. The amount being credited to the folio or bill. |
Debits | Amount that is owed for an item, the amount charged. |
Fee Type | The type of the Fee charged. These are set up in the Taxes and Fees section of the property configuration in Cloudbeds PMS. |
POS Charge Category | The category of the POS (Point of Sale) item purchased. For example drip "coffee" and "espresso" might be in the "coffee and tea" category ; "beer" might be in a "Alcohol" category. |
POS Charge Description | The item purchased via a POS (point of sale) system that has been integrated into Cloudbeds. Often this will include items purchased via a cafe, restaurant, gift shop, etc. |
Quantity | Number of items purchased. |
Refund Flag | Indicates if the transaction is a refund. |
Room Revenue Type | The type of Charge associated with the Room Revenue: Room Rate, Cancellation Fee, No Show, or Manual charge. |
Tax Type | The type of the tax charged. These are set up in the Taxes and Fees section of the property configuration on Cloudbeds PMS. |
Transaction Code | The code or ID associated the transaction. |
Transaction Date Time - UTC | When the transaction occurred, in UTC time. |
Transaction Date Time - Property | When the transaction occurred, per the property's time zone. |
Transaction Type | Whether it is a guest reservation, house account, cash drawer, or group profile. |
Void Flag | Indicates if the transaction is a void. |
Item and Service Category | The category for the item, as it was set up on Cloudbeds PMS in the Items and Services section in the Property Configuration. |
Item and Service Type | The type of the item purchased. These are set up in the Items and Service section of the property configuration on Cloudbeds PMS. Does not include room revenue or taxes or fees. |
Card last 4 digits | Last 4 digits of card, needed when verifying what card has been used. |
Adjustment Flag | Indicates the transaction is an adjustment. |
Balance Due | What the Guest owes. Equals Debits minus Credits. Positive amounts indicate money is owned on the account. Negative amounts indicated a credit for the guest. |
Payment Method | The type of payment that was provided. For example credit card, bank transfer, check, cash, voucher. |
Transaction Notes | The note associated with the transaction. Most transactions don’t have notes, but we provide the option of showing notes for those that do. |
Latest Invoice Number | The unique ID associated with the invoice. |
Invoice Created Date Time - UTC | Date the invoice was created, in UTC time. |
Invoice Guest Name | Who the invoices was issued to. |
Invoice Create Date Time - Property | Date the invoice was created, per the property's time zone. |
Transaction Status | Status of the transaction either Posted or Pending. |
Cloudbeds Data Field | Description |
Primary Guest First Name | Primary guest's first name. |
Primary Guest Full Name | First Name and Surname (Last) Name associated with the booking. |
Primary Guest Status Level | Shows the status level of the primary guest associated with the reservation. |
Primary Guest Surname | The primary guest surname, also referred to as the last name. |
Cloudbeds Data Field | Description |
Property Name | The name of the property. |
Property ID | The Cloudbeds ID associated with the property. Having a unique ID per property is useful when integrating with other systems |
User | Name of the Cloudbeds user that made the change / update. |
Guests
The details on each guest at the hotel, including their stay's history, contact information, document information, etc.
Cloudbeds Data Field | Description |
Booking Date Time - UTC |
When the reservation was originally made, in UTC time.
|
Booking Date Time - Property |
When the reservation was originally made, per the property's time zone.
|
Cancellation Date Time - UTC |
Date and time the reservation was cancelled, in UTC time.
|
Cancellation Date Time - Property |
Date and time the reservation was cancelled, per the property's time zone.
|
Check-In Date |
Date the reservation starts, when the guests arrives, the first room night.
|
Check-Out Date | Date the reservation ends and the guest departs. |
Reservation Status |
Status of the Reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, or No Show.
|
Third Party Confirmation Number | Confirmation number from the OTA or travel agency. |
Reservation Number |
The confirmation number that the Cloudbeds System automatically assigns to a reservation and that uniquely identifies a reservation. Sometimes refered to as Reservation ID.
|
Duration of Stay | Duration of stay. |
Cloudbeds Data Field | Description |
Guest Address | First line of the guest's street address. |
Guest Address line 2 | Second line of the guest's street address. |
Guest Mobile Phone Number | The mobile phone number of the guest. |
Guest City | The city of the guest's address. |
Guest Date of Birth | Date of birth of the guest. |
Guest Document Expiration Date |
Expiration date of the ID provided by the guest. For example the passport expiration date.
|
Guest Document Issue Date |
Issue date of the ID provided by the guest. For example the passport issue date or the driver's license issue date.
|
Guest Document Issuing Country |
The issuing country of the ID provided by the guest. For a Canadian Passport it would be Canada.
|
Guest Document Issuing Country Code |
The issuing country code of the ID provided by the guest. For a Canadian Passport it would be CA.
|
Guest Document Number |
ID number of the ID provided by the guest. For example a passport number.
|
Guest Document Type |
The type of ID provided by the guest, for example drivers license, passport, etc.
|
Guest Email | Email address of the guest. |
Guest First Name | Guest first name. |
Guest Surname | The last name a guest. |
Guest Full Name |
The names of guests associated with the reservation. Guest Full Name = First Name + Surname.
|
Guest Phone Number | The phone number of the guest. |
Guest Postal / ZIP Code | The postal code of the guest's address. |
Guest Residence Country | The country of the guest’s address. |
Guest Residence Country Code | The country code of the guest’s address. |
Guest State | The state of the guest's address. |
Guest Gender | Guest's Gender. |
Primary Guest Flag |
Flag that identifies if the guest is the primary guest associated with the reservation.
|
Guest Status Level |
Identification on if the Primary Guest is a VIP, Gold Member, Blacklisted, etc. Statuse are set up in the Guest Status section under Property Configuration on Cloudbeds PMS.
|
Opt-In for Marketing Emails |
List of customers that have opted into marketing emails.
|
Repeat Guest Flag |
Yes No Flag that identifies if the guest is a repeat guest.
|
Property Check-In Time | Time Guests arrive, per property policy. |
Property Check-Out Time | Time Guest depart, per property policy. |
Cloudbeds Data Field | Description |
Property ID | The Cloudbeds property ID associated with the property. |
Property Name | The name of the property. |
Reservations
Booking or Reservation information includes who booked, where the booking came from, when it occurred, the price, the rate plans, room types, etc.
Cloudbeds Data Field | Description |
Adults | Number of adults in the reservation. |
Booking Date Time - UTC | When the reservation was originally made, in UTC time. |
Booking Date Time - Property | When the reservation was originally made, per the property's time zone. |
Cancellation Date Time - UTC | Date and time the reservation was cancelled, in UTC time. |
Cancellation Date Time - Property | Date and time the reservation was cancelled, per the property's time zone. |
Check-In Date | Date the reservation starts, when the guests arrives, the first room night. |
Check-Out Date | Date the reservation ends and the guest departs. |
Children | Number of children in the reservation. |
Guest Count | Total number of guests associated with the reservation, including Adults and Children. |
Room Count | The number of rooms associated with the booking, Most bookings only have 1 room, but larger groups may have many rooms under one booking. |
Reservation Number | The confirmation number that the Cloudbeds System automatically assigns to a reservation and that uniquely identifies a reservation. Sometimes refered to as Reservation ID. |
Reservation Status | Status of the Reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, or No Show. Could be another custom status. |
Room Nights | The number of room nights associated with the reservation. For example if a reservation has two room that both check in on Sunday and Check out on Tuesday, that would include 2 Room Nights. |
Room Reservation Number | The ID or confirmation number that the Cloudbeds System automatically assigns to a room within the reservation and that uniquely identifies a that room and reservation. |
Third Party Confirmation Number | Confirmation number from the OTA or travel agency. |
Hotel Collect Booking Flag | Channel Pay or Hotel Pay. |
Estimated Arrival Time | Estimated arrival time. Can help to plan for late or early arrivals. |
Active Reservation Notes | Information on the Guest and the reservation in the original language. |
Active Group Profile Notes | Any Active Group Profile Notes that are associated with this Booking. |
Active Guest Notes | Active notes regarding the guest. Can also be seen on the reservation page under Guest Notes. |
Group Allotment Code | The auto generated code that uniquely identifies an Allotment. For example b283824. |
Group Allotment Name | The Group Block Name is associated with the reservation. Is null if it is not associated with a group block. |
Group Profile Code | The auto generated code that uniquely identifies transactions associated with the Group Profile, for example g572444. |
Group Profile Name | Group Profile is the master profile under which a certain group of reservations is created or added. This could be a company, wedding party, travel agent, etc. It may or may not be associated with a group block allotment. |
Group Profile Type | The type of groupe: Group (one time event), Company, Travel Agent, Wholesaler. |
Rate Plan-Channel Name | Displays the rate plan name as received from the channel. This field is available in both the Reservations and Financial datasets. |
Rate Plan - Public Name | TThe Rate plan name that is visible to the customer. Different Rate Plans may have the same name. |
Rate Plan - Private Name | The rate plan name that is unique to the rate plan and that is only visible internally. |
Reservation Source Category | The means by which the booking was made, for example Direct, Group, Wholesaler, OTA, Travel Agent. These are categories of Sources. |
Reservation Source | How reservation was booked: Phone, Booking Engine, Expedia, etc Sometimes referred to as the Channel.. |
Room Types | The type of rooms. If there are more than one associated with the booking they will be concatenated into 1 field. |
Room Numbers | The rooms numbers. If there are more than one associated with the booking they will be concatenated into 1 field. |
Reservation Special Requests | Special requests from OTAs provided at the time the booking, in the original language. |
Group Allotment Block Notes | Messages associated with the group allotment block. |
Cloudbeds Data Field | Description |
Deposit | Amount of the deposit for the reservation. It may or may not be refundable. |
Grand Total | Total Room Revenue Associated with a reservation. Includes Taxes and Fees. Covers the entire length of stay. |
Card last 4 digits | Last 4 digits of card, needed when verifying what card has been used. |
Commission | The commission amount for the reservation. |
Credit Card Type | The credit card type on file for the reservation, or example Visa, Discover, etc. |
Reservation Balance Due | What is what is left to be paid for the reservation. Equals the Reservation Grand Total minus the Reservation Amount Paid. |
Total Reservation Taxes | The total taxes for the reservation. |
Reservation Paid Amount | The amount that has been paid toward the reservation. |
Room Revenue Total | Total of the Room Rates for the Length of Stay. Does NOT include taxes and fees |
Cloudbeds Data Field | Description |
Primary Guest Postal / ZIP Code | The postal code of the primary guest’s address. |
Primary Guest Address | First line of the Primary Guest's street address. |
Primary Guest Address Line 2 | Second line of the Primary Guest's street address. |
Primary Guest Mobile Phone Number | The mobile phone number of the Primary Guest. |
Primary Guest City | The city of the Primary Guest's address. |
Primary Guest Residence Country Code | The country code of the Primary Guest's address. |
Primary Guest Residence Country Name | The country of the Primary Guest's address. |
Primary Guest ID | The ID associated with the Guest. Automatically generated by the database for tracking. |
Primary Guest Date of Birth | Primary Guest's date of birth. |
Primary Guest Document Expiration Date | Expiration date of the ID provided by the guest. For example the passport expiration date. |
Primary Guest Document Issue Date | Issue date of the ID provided by the guest. For example the passport issue date or the driver's license issue date. |
Primary Guest Document Issuing Country Code | The Issuing Country of the ID provided by the guest. For example for a Canadian Passport it would be CA. |
Primary Guest Document Issuing Country | The country of Primary Guest’s identification information. |
Primary Guest Document Number | ID number of the ID provided by the guest. For example a passport number. |
Primary Guest Document Type | The type of ID provided by the guest, for example drivers license, passport, etc. |
Primary Guest Email | Email address of the Primary Guest. |
Primary Guest Full Name | First Name and Surname (Last) Name associated with the booking. |
Primary Guest First Name | Primary guest first name. |
Primary Guest Surname | The primary guest surname, also referred to as the last name. |
Primary Guest Gender | Primary Guest's Gender. |
Primary Guest Phone Number | The phone number of the Primary Guest. |
Primary Guest State | The state of the Primary Guest's address. |
Primary Guest Status Level | Identification on if the Primary Guest is a VIP, Gold Member, Blacklisted, etc. Statuse are set up in the Guest Status section under Property Configuration on Cloudbeds PMS. |
Opt-In for Marketing Emails | List of customers that have opted into marketing emails. |
Repeat Guest Flag | Yes No Flag that identifies if the guest is a repeat guest. |
Cloudbeds Data Field | Description |
Property Name | The name of the property. |
Property ID | The Cloudbeds ID associated with the property. Having a unique ID per property is useful when integrating with other systems |
Cloudbeds Data Field | Description |
Stay Date | The dates that the customer stays in the hotel. For example if a guest checks in on July 1st and checks out on July 3rd, their stay dates are July 1st and July 2nd |
Room Rate | The room rate associated with the reservation. |
Room Night Extra Adult Charges | The rate for extra adult per room night. |
Room Night Extra Kids Charges | The rate for extra child per room night. |
Occupancy
The productivity information for the hotel, including metrics such as occupancy, room nights, Revpar, ADR, etc. Used by revenue managers to set prices and distribution strategies.
Cloudbeds Data Field | Description |
ADR |
The average daily rate of all rooms sold |
Adults |
The total number of adults associated with the room for a specific stay date. |
Booking Date | When the reservation was made initially. |
Children | The total number of children associated with the room for a specific stay date. |
Guest Count | Total number of guests associated with the reservation, including Adults and Children. |
Other Room Revenue |
Other Room Revenue = (manual Room Revenue transactions + No-Show transactions) — (Revenue Adjustments + No-Show Adjustments) This field includes pending and posted transactions but excludes cancellation fees & adjustments. In addition, the Transaction Date Time will be used to attribute the amount to a specific Stay Date, even if the transaction occurred outside the reservation stay date range. |
Reservation Source | How reservation was booked: Phone, Booking Engine, Expedia, etc. Sometimes referred to as the Channel. |
Reservation Source Category | The means by which the booking was made, such as Direct, Group, Wholesaler, OTA, or Travel Agent, are categories of Sources. |
Room Guest Count | The total number of guests associated with the room for a specific stay date. This field uses reservations with the statuses Confirmation Pending, Confirmed, In-House, and Checked Out. It should be zero for the reservations with the following statuses: No-show and Canceled. |
Room Rate | The total of all Room Rate transactions is posted automatically to both transient and group reservations on a nightly basis, per stay date, per booked room. This is a part of the Total Room Revenue. |
Room Revenue | The room revenue associated with the booking. Covers the entire lenght of stay. Includes the room rates. It does not include taxes, cancelation fees, or other fees. |
Stay Date | The dates that the guest stays in the hotel. For example, if a guest checks in on July 1st and checks out on July 3rd, their stay dates are July 1st and July 2nd. |
Total Room Revenue | The sum of Room Rate and Other Room Revenue. |
Cloudbeds Data Field | Description |
Available Room Count | The unsold rooms that are available to be booked. Equals capacity minus occupied rooms minus out of service rooms. |
Block Room Count | Count the number of rooms that are marked as Blocked. Number of rooms marked as using Block Dates on the calendar for a specific Stay Date. |
Capacity | The total number of rooms available for booking, including the total number available in all Room Types for a specific Stay Date. |
Courtesy Hold Count | The total number of rooms with courtesy holds that have not yet been converted into reservations. The number of rooms marked as Courtesy Hold for a specific Stay Date. |
Occupancy | The percentage of available accommodations that are sold equals the number of room nights divided by capacity, excluding the out-of-service rooms. This calculation does not include the Blocked Room Count or Out of Service Room Count. |
Out of Service Room Count | The number of rooms marked as Out of Service for a specific Stay Date. |
PMS Occupancy |
The occupancy percentage displayed in Cloudbeds PMS user interface. PMS Occupancy = Rooms Sold / (Capacity — Total Blocked Room Count — Total Out of Service Room Count] ) * 100 This field doesn’t support share/split inventory settings. |
RevPAR | The total room revenue earned per available room during the reporting period. RevPAR = Total Room Revenue / Capacity |
Room Nights | The number of room nights associated with the reservation. For example, if the reservation has two rooms that both check in on Sunday and check out on Tuesday, that would include 4 room nights. |
Room Sold | The number of rooms sold or booked for a specific stay date. This field uses reservations with the statuses Confirmation Pending, Confirmed, In-House, and Checked Out. It should be zero for the reservations with the following statuses: No-show and Canceled. |
Cloudbeds Data Field | Description |
ADR | Average Daily Rate = Room Revenue / Room Nights |
Bed Based Capacity | The number of guests that a property can accommodate. For example, a hotel with 20 rooms, each with one king bed can accommodate 40 people, 2 per king bed. |
Bed Places per Accommodation | The capacity of the room type. |
Cloudbeds Data Field | Description |
Property ID | The Cloudbeds ID associated with the property. Having a unique ID per property is useful when integrating with other systems. |
Property Name | The name of the property. |
Reservation Number | The confirmation number that the Cloudbeds system automatically assigns to a reservation and that uniquely identifies a reservation. Sometimes referred to as Reservation ID. |
Room Type | Room type, also known as Accommodation Type, is the name given to a group of rooms with something in common, such as physical characteristics, and sold at the same price. Examples are standard and Deluxe rooms. |
Payment
Payment processing information, including charges, fees, chargebacks, reversals, etc.
Cloudbeds Data Field | Description |
Check-In Date | Date the reservation starts, when the guests arrives, the first room night. |
Check-Out Date | Date the reservation ends and the guest departs. |
Card Type | The card type on file for the reservation, or example Visa, Discover, etc. |
Reservation Number | The confirmation number that the Cloudbeds System automatically assigns to a reservation and that uniquely identifies a reservation. Sometimes referred to as Reservation ID. |
Primary Guest Full Name | First Name and Surname (Last) Name associated with the booking. |
Cloudbeds Data Field | Description |
Primary Guest Full Name | First Name and Surname (Last) Name associated with the booking. |
Cloudbeds Data Field | Description |
Card Last 4 Digits | Last 4 digits of card, needed when verifying what card has been used. |
Payment Method | The type request being made. Possible values are: Authorize, Purchase, Refund, Capture, Void, Authorization, Reversals, Chargebacks. |
Cloudbeds Data Field | Description |
Card Issue Country | The country associated with the issuing bank. |
Payment Gateway Error Reason | Messaging regarding the reason for the status. Includes error details if payment processing fails. Is empty for successful payments. |
Payment Gateway Status | The status of the gateway processing. |
POS Entry Mode | The means by which the card information was captured. |
Terminal Label | The merchant's name of the terminal. |
Payment Schedule Date Time | The date the payment is scheduled to be processed. |
Payment Gateway Transaction ID | The ID associated with the Gateway Request and Response. |
Payment Fee | A fee deducted from payout for card processing and risk. |
Payment Net | The amount paid to the merchant. Equals amount submitted minus fee. |
Cloudbeds Data Field | Description |
Property Name | The name of the property. |
Property ID | The Cloudbeds ID associated with the property. Having a unique ID per property is useful when integrating with other systems |
Cloudbeds Data Field | Description |
Payment Amount Submitted | The amount that is requested to be paid by the card holder. |
Payment Gateway | Name of the gateway processor. |
Invoices
The invoice and credit note information. Each document is a snapshot in time. The contents do not change but they can be voided and superseded.
The information provided in this report is subject to the picture in time when the invoice was created.
Example: If you changed the total revenue of the reservation because you added a product after the invoice was created, this will not be reflected in the report, as the information taken to build the report comes from the invoice created.
Cloudbeds Data Field | Description |
Property Name | The name of the property. |
Property ID | The Cloudbeds ID associated with the property. Having a unique ID per property is useful when integrating with other systems |
Cloudbeds Data Field | Description |
Bill From Name | Name of business issuing the invoice, usually the property. |
Bill From Address Line 1 | Street address of the invoicer. |
Bill From Address Line 2 | Second line of the invoicer's address. |
Bill From City | City of the invoicer. |
Bill From State | State of the invoicer. |
Bill From Country Code | Country of the invoicer. |
Bill From Postcode | Postal or the zip code of the invoicer. |
Bill From Phone Number | Phone number of the invoicer. |
Bill From Email | Email of the invoicer. |
Cloudbeds Data Field | Description |
Bill to Name | Guest Name / Company Name |
Bill to Address Line 1 | Street address of entity receiving invoice. |
Bill to Address Line 2 | Second line of entity receiving invoice. |
Bill to City | City of entity receiving invoice. |
Bill to State | State of entity receiving invoice. |
Bill to Country Code | Country of entity receiving invoice. |
Bill to Postcode | Postal or the zip code of entity receiving invoice. |
Cloudbeds Data Field | Description |
Reservation Check-in Date | Check-in date associated with the invoice. |
Reservation Check-out Date | Check-out date associated with the invoice. |
Reservation Room Nights | Length of stay associated with the invoice. |
Reservation Date Time | Booking date of reservation associated with the invoice. |
Language Code | Code identifying the language of the invoice, for example EN for English. |
Reservation ID | ID of reservation or group associated with the invoice. |
Cloudbeds Data Field | Description |
Invoice Age - Invoice Date | The number of days since the invoice creation date |
Invoice Age - Payment Due Date | The number of days past the invoice payment due date. For invoices that are not due yet, the field will show a negative value, e.g. -14, indicating that the invoice has that number of days before it is due. |
Invoice Status | Open or Paid or Voided or Credit Note. Learn more: Invoicing - Overview |
Invoice Type | Invoice or Credit Note. |
PDF URL | Accessible when logged in to Cloudbeds PMS with proper access. |
Invoice Date | The invoice or credit note is issued. |
Invoice Number | ID associated with the invoice or credit note. |
Cloudbeds Data Field | Description |
Invoice Currency Code | Currency used in the invoice. |
Total Tax Amount | Taxes associated with the invoice. |
Total Gross Amount | Total charges. |
Balance Due | Total balance due, charges minus payments. |
Comments
Please sign in to leave a comment.