Report Types & Cloudbeds Data Fields

Mariia Korostashevych

Updated December 18, 2025 22:51

In our Reporting section Reporting icon.png , you will find several report types, such as: Financial, Guests, Reservations, Occupancy, Payment, Invoices, Housekeeping, and Bed Occupancy.

The report type controls the scope of data available in the report. For example, the Financial report type has Cloudbeds Data Fields* and filters available related to financial data, whereas the Guests report type has everything related to guest data.

*Cloudbeds Data Field (CDF) is a data field provided and defined by Cloudbeds. This article lists all CDFs available in each report type.

Use this guide to explore and understand the definitions of all Cloudbeds Data Fields (CDFs) available for each report type below.

Financial

Financial transactions that are made, including debits and credit and their attributes.

Booking

Cloudbeds Data Field	Description
Booking Date Time - Property	When the reservation was originally made, per the property's time zone.
Booking Date Time - UTC	When the reservation was originally made, in UTC time.
Card Type	The credit card type on file for the reservation (e.g., Visa, Discover).
Check-In Date	Date the reservation starts, when the guest arrives, the first room night.
Check-Out Date	Date the reservation ends, and the guest departs.
Group Profile ID	The unique identifier assigned to each group profile. This is generated and used by the system.
Group Profile Code	The unique code assigned to each group profile. This is generated and used by the system.
Group Profile Name	Master profile under which a group of reservations is created or added (e.g., company, wedding party).
Group Profile Type	The type of group (e.g., Group, Company, Travel Agent, Wholesaler).
Hotel Collect Booking Flag	Indicates whether the booking is channel pay or hotel pay.
House Account ID	The unique identifier assigned to each house account. This is generated and used by the system.
House Account Name	Name of the house account associated with the transaction, used for registering transactions not connected to any specific room, guest, or reservation.
Market Group	Group that represents the type of business a hotel is receiving (Transient, Group, Contract).
Market Segment	A specific classification of the type of business a hotel is receiving within a Market Group (e.g., retail, government).
Market Segment Code	Abbreviation of the Market Segment.
Rate Plan - Channel Name	The rate plan name received from the channel.
Rate Plan - Private Name	Internal rate plan name unique to the rate plan.
Rate Plan - Public Name	Rate plan name visible to the customer.
Reservation Number	Confirmation number assigned to a reservation, uniquely identifying it.
Reservation Source	How the reservation was booked: Phone, Booking Engine, Expedia, etc.
Reservation Source Category	Groups of reservation sources: Direct, Group, Wholesaler, OTA, or Travel Agent.
Reservation Status	Status of the reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, No Show, or Inquiry.
Room Number	The number or name that identifies the room(s) associated with the transaction.
Room Reservation Number	ID or confirmation number assigned to a room within the reservation, uniquely identifying it.
Room Type	The type of room, as categorized in Cloudbeds PMS.
Room Type Category	Shows if the room booked was either a private room or a shared room.
Segment Active Flag	Flag indicating if the segment is active or inactive.

Actionable reports

The Reservation Number field contains hyperlinked information that opens the reservation drawer on the same screen. You can make changes to the reservation and close the drawer. The saved changes will be reflected in the report when the data is updated.

Cloudbeds Insights customers can enable and disable these links in the Configuration section. More information here.

Finance

Cloudbeds Data Field	Description
Add-on Charge Type	How the guest is charged for the add-on item. Examples: by quantity, per reservation, per room, per night, per room per night, per guest per night, per guest. The field will be empty for non-English speakers Cloudbeds PMS users.
Add-on Item	The add-on item purchased with the reservation. The field will be empty for non-English speakers Cloudbeds PMS users.
Adjustment Flag	Indicates if the transaction is an adjustment.
Benchmarking Transaction Type	The benchmarking bucket of the transaction per USALI. This corresponds to the revenue categories in the Occupancy revenue data.
Card Last 4 Digits	Last 4 digits of the card, needed when verifying what card has been used.
Cloudbeds Transaction Code	Unique code assigned to an internal transaction type for tracking and categorizing different transaction types.
Cloudbeds Transaction Code Description	Description of the internal transaction type to help users identify its purpose.
Code	Information entered by the customer in the Code field in Taxes and Fees or Items and Services section.
Credits	The amount of payment credited to the folio or bill.
Custom General Ledger Code	Code assigned to a specific general ledger account for tracking and categorizing financial transactions. Note: The use of this field requires proper configuration in the PMS.
Custom General Ledger Name	Name of the general ledger account to help users identify it. Note: The use of this field requires proper configuration in the PMS.
Custom Transaction Code	Customized code by the property to categorize transactions and help identify their purpose. Note: The use of this field requires proper configuration in the PMS.
Debits	Amount owed for an item, the amount charged.
Deletion Flag	Indicates if the transaction is a deletion.
Fee Type	The type of the fee charged, set up in the Taxes and Fees section of property configuration.
Invoice Create Date Time - Property	Date the invoice was created, per the property's time zone.
Invoice Create Date Time - UTC	Date the invoice was created, in UTC time.
Invoice Guest Name	Who the invoice was issued to.
Item Type	Shows if the transaction is coming from a product, service or meal plan.
Item and Service Category	The category for the item, set up in Cloudbeds PMS, in the Items and Services section.
Item and Service Name	The type of the item purchased, not including room revenue or taxes and fees.
Latest Invoice Number	The unique ID associated with the invoice.
Meal Plan	A comma separated list of meal plans included in the financial transaction.
Original Currency	The type of money used to complete the transaction at the time it was made represented by a currency code (e.g., EUR for Euro).
Payment ID	Unique identifier assigned to each payment transaction, used to associate records between financial and payment datasets.
Payment Method	Type of payment provided (e.g., credit card, bank transfer, check, cash, or voucher).
POS Charge Category	The category of the POS item purchased (e.g., coffee, alcohol).
POS Charge Description	Item purchased via a POS system integrated into Cloudbeds (e.g., items from a cafe or restaurant).
Quantity	Number of items purchased.
Refund Flag	Indicates if the transaction is a refund.
Room Revenue Type	Type of charge associated with the room revenue: Room Rate, Cancellation Fee, No Show, or Manual charge.
Service Date	The date when a product or service is delivered. With proper permission, service date can be backdated to recognize revenue and expenses in the correct period.
Tax Type	The type of tax charged; set up in the Taxes and Fees section of property configuration.
Transaction Amount	The amount of an individual transaction; charges are positive while payments and credits are negative.
Transaction Date Time - Property	The date/time when a transaction occurs, per the property’s time zone. This cannot be backdated.
Transaction Date Time - UTC	The date/time when a transaction occurs, per UTC time zone. This cannot be backdated.
Transaction Description	The description of the transaction as shown in the PMS folio.
Transaction ID	Unique identifier per row of records within this dataset. This is generated and used by the system.
Transaction Notes	Notes associated with the transaction; most transactions don't have notes, but this option is available for those that do.
Transaction Status	Status of the transaction in terms of system posting.
Transaction Type	Type of transaction that occurred, such as Room Revenue, Add-on, or Tax.
Transaction Source	Indicates the source of the transaction: Reservation, Group Folio, House Account, or Accounts Receivable Ledger.
Trial Balance ID	A unique identifier that links every transaction to the nightly audit in which it was posted. Use Night Audit ID as a filter to retrieve all transactions recorded between two consecutive night-audit runs (this reproduces the property’s Trial Balance for any given audit period).
Void Flag	Indicates if the transaction is void.

Primary Guest

Cloudbeds Data Field	Description
Primary Guest First Name	First name of the primary guest.
Primary Guest Full Name	First name and surname of the primary guest associated with the booking.
Primary Guest Status Level	Status level of the primary guest of the reservation.
Primary Guest Surname	Surname of the primary guest (last name).

Actionable reports

The Guest Full Name field contains hyperlinked information that opens the reservation drawer on the same screen. You can make changes to the reservation and close the drawer. The saved changes will be reflected in the report when the data is updated.

Cloudbeds Insights customers can enable and disable these links in the Configuration section. More information here.

Property

Cloudbeds Data Field	Description
Organization ID	Cloudbeds ID associated with the property's organization.
Property ID	The Cloudbeds ID associated with the property.
Property Name	The name of the property.
User	Name of the property’s Cloudbeds PMS 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.

Booking

Cloudbeds Data Field	Description
Booking Date Time - Property	When the reservation was originally made, per the property's time zone.
Booking Date Time - UTC	When the reservation was originally made, in UTC time.
Cancellation Date Time - Property	Date and time the reservation was cancelled, per the property's time zone.
Cancellation Date Time - UTC	Date and time the reservation was cancelled, in UTC time.
Check-In Date	Date the reservation starts, when the guest arrives, the first room night.
Check-Out Date	Date the reservation ends and the guest departs.
Duration of Stay	The number of days for the guest's reservation.
Group Profile Name	Name of the group profile associated with the guest’s reservation.
Guest ID	Unique identifier per row of records within this dataset, generated and used by the system.
Reservation Number	Confirmation number assigned to a reservation, uniquely identifying it.
Reservation Room Number	The room number associated with the guest.
Reservation Source	How the reservation was booked: Phone, Booking Engine, Expedia, etc.
Reservation Source Category	The means by which the booking was made, e.g., Direct, Group, Wholesaler, OTA, Travel Agent.
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.

Guest

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 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, e.g., passport expiration date.
Guest Document Issue Date	Issue date of the ID provided by the guest, e.g., passport or driver's license issue date.
Guest Document Issuing Country	The issuing country of the ID provided by the guest, e.g., Canada for a Canadian passport.
Guest Document Issuing Country Code	The issuing country code of the ID provided by the guest, e.g., CA for Canada.
Guest Document Number	ID number of the ID provided by the guest, e.g., passport number.
Guest Document Type	The type of ID provided by the guest, e.g., driver's license, passport, etc.
Guest Email	Email address of the guest.
Guest First Name	Guest's first name.
Guest Full Name	The names of guests associated with the reservation, combining first name and surname.
Guest Gender	Guest's gender.
Guest Mobile Phone Number	The mobile phone number of the guest.
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 Status Level	Identification of whether the primary guest is a VIP, Gold Member, Blacklisted, etc.
Guest Surname	The last name of a guest.
Opt-In for Marketing Emails	Flag indicating if the guest has opted into marketing emails.
Primary Guest Flag	Flag indicating if the guest is the primary guest associated with the reservation.
Property Check-In Time	Time guests arrive, per property policy.
Property Check-Out Time	Time guests depart, per property policy.
Repeat Guest Flag	Flag indicating if the guest is a repeat guest.

Property

Cloudbeds Data Field	Description
Organization ID	The Cloudbeds ID associated with the property's organization.
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.

Booking

Cloudbeds Data Field	Description
Active Group Profile Notes	Any active group profile notes associated with this booking.
Active Guest Notes	Active notes regarding the guest, visible on the reservation page under Guest Notes.
Active Reservation Notes	Information on the guest and the reservation in the original language.
Adults	Number of adults in the reservation.
Booking Date Time - Property	When the reservation was originally made, per the property's timezone.
Booking Date Time - UTC	When the reservation was originally made, in UTC time.
Booking Window	Number of days between the booking date and check-in date.
Cancellation Date Time - Property	Date and time the reservation was cancelled, per the property's timezone.
Cancellation Date Time - UTC	Date and time the reservation was cancelled, in UTC time.
Check-In Date	Date the reservation starts; when the guest arrives.
Check-Out Date	Date the reservation ends and the guest departs.
Children	Number of children in the reservation.
Estimated Arrival Time	Estimated arrival time to help plan for late or early arrivals.
Group Allotment Block Notes	Messages associated with the group allotment block.
Group Allotment Code	Auto-generated code that uniquely identifies an allotment (e.g., b283824).
Group Allotment Name	Name associated with the reservation's group block.
Group Profile Code	Auto-generated code that uniquely identifies transactions associated with the group profile (e.g., g572444).
Group Profile Name	The master profile for a group of reservations, which may be associated with a group block.
Group Profile Type	The type of group: Group (one-time event), Company, Travel Agent, Wholesaler.
Guest Count	Total number of guests associated with the reservation, including adults and children.
Hotel Collect Booking Flag	Indicates whether the booking is Channel Pay or Hotel Pay.
Market Group	Group that represents the type of business a hotel is receiving (Transient, Group, Contract).
Market Segment	A specific classification of the type of business a hotel is receiving within a Market Group (e.g., retail, government).
Market Segment Code	Abbreviation of the Market Segment.
Meal Plan Included	Flag indicating if the meal plan is included in the reservation.
Origin	Specific third party used to make the reservation.
Rate Plans - Channel Names	The rate plan name received from the channel.
Rate Plans - Private Names	Internal rate plan name unique to the rate plan, separated by commas for multiple rooms.
Rate Plans - Public Names	Rate plan name visible to the customer, separated by commas for multiple rooms.
Reservation ID	Unique identifier per row of records within this dataset, generated and used by the system.
Reservation Number	Confirmation number assigned to a reservation that uniquely identifies it.
Reservation Source	How the reservation was booked (e.g., Phone, Booking Engine, Expedia).
Reservation Source Category	Means by which the booking was made (e.g., Direct, Group, OTA).
Reservation Special Requests	Special requests from OTAs at the time of booking, in the original language.
Reservation Status	Status of the reservation (e.g., Confirmed, Cancelled, No Show).
Room Count	Number of rooms associated with the booking.
Room Nights	Number of room nights associated with the reservation based on check-in and check-out dates.
Room Numbers	Room numbers associated with the booking, concatenated if multiple rooms exist.
Room Reservation Number	Confirmation number assigned to a room within the reservation.
Room Types	Types of rooms associated with the booking, concatenated if multiple exist.
Room Type Categories	Shows if the room booked was either a private room or a shared room.
Third Party Confirmation Number	Confirmation number from the OTA or travel agency.
Segment Active Flag	Flag indicating if the segment is active or inactive.

Actionable reports

Cloudbeds Insights customers can enable and disable these links in the Configuration section. More information here.

Finance

Cloudbeds Data Field	Description
Card Last 4 Digits	Last 4 digits of the card, needed for verification.
Commission	The commission amount for the reservation.
Credit Card Type	The credit card type on file for the reservation (e.g., Visa, Discover).
Grand Total	Total room revenue associated with a reservation, including taxes and fees for the entire stay.
Reservation Balance Due	Amount left to be paid for the reservation, calculated as grand total minus amount paid.
Reservation Paid Amount	Amount paid toward the reservation.
Room Revenue Total	Total room rates for the length of stay (does not include taxes and fees).
Suggested Deposit	Recommended deposit amount for guests when making the reservation.
Total Reservation Taxes	Total taxes for the reservation.

Primary Guest

Cloudbeds Data Field	Description
Opt-In for Marketing Emails	Opt-In for Marketing Emails Indicates if the customer has opted in to receive marketing emails.
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 City	The city of the primary guest's address.
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 (e.g., passport expiration date).
Primary Guest Document Issue Date	Issue date of the ID provided by the guest (e.g., passport or driver's license).
Primary Guest Document Issuing Country	The country of the primary guest's identification information.
Primary Guest Document Issuing Country Code	The issuing country code of the ID provided by the guest (e.g., CA for a Canadian passport).
Primary Guest Document Number	ID number of the ID provided by the guest (e.g., passport number).
Primary Guest Document Type	The type of ID provided by the guest (e.g., driver's license, passport).
Primary Guest Email	Email address of the primary guest.
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 Gender	Primary guest's gender.
Primary Guest ID	The ID associated with the guest, automatically generated by the database for tracking.
Primary Guest Mobile Phone Number	The mobile phone number of the primary guest.
Primary Guest Phone Number	The phone number of the primary guest.
Primary Guest Postal / ZIP Code	The postal code 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 State	The state of the primary guest's address.
Primary Guest Status Level	Identification of the primary guest's status (e.g., VIP, Gold Member, Blacklisted).
Primary Guest Surname	The primary guest's surname (last name).
Repeat Guest Flag	Identifies if the guest is a repeat guest.

Actionable reports

Cloudbeds Insights customers can enable and disable these links in the Configuration section. More information here.

Reservation

Cloudbeds Data Field	Description
Unassigned Accommodations	The count of unassigned accommodations for the reservation. The difference between how many room types were reserved and how many room numbers were assigned.

Property

Cloudbeds Data Field	Description
Organization ID	The Cloudbeds ID associated with the property's organization.
Property ID	The Cloudbeds property ID associated with the property.
Property Name	The name of the property.

Room Nights

Cloudbeds Data Field	Description
Room Night Extra Adult Charges	The charges per night for an extra adult in the room.
Room Night Extra Kids Charges	The charges per night for an extra child in the room.
Room Rate	The rate of the room for the particular stay date.
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 Reservations

Cloudbeds Data Field	Description
Adults per Room Reservation	The number of adults staying in the room.
Children per Room Reservation	Number of children staying in the room.
Meal Plans	A list of meal plans included in this room reservation, separated by commas if multiple.
Room Check-in Date	The day that the reservation for the room begins.
Room Check-out Date	The day that the reservation for the room ends.
Room Guest Count	Number of guests in the room, equals Room Adult Count + Room Children Count.
Room Identifier	Room number(s) assigned to the reservation, with each room listed separately.
Room Length of Stay	The number of room nights associated with the reservation.
Room Number	The room number associated with the reservation, with each room listed separately.
Room Primary Guest First Name	The first name of the primary guest for this room.
Room Primary Guest Full Name	The full name of the primary guest for this room.
Room Primary Guest Surname	The surname of the primary guest for this room.
Room Rate Plans - Channel Name	The rate plan name received from the channel.
Room Rate Plans - Private Names	The rate plan names related to the reservation rooms that are visible to the customer.
Room Rate Plans - Public Names	The internal rate plan name unique to the rate plan.
Room Reservation Revenue	The room revenue for a particular room.
Room Reservation Status	Status of the room reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, or No Show.
Room Total Price	The total price for the room reservation including taxes and fees.
Room Type	The room type(s) associated with the reservation, with each listed separately.
Room Type Category	Shows if the room booked was either a private room or a shared room.

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.

Booking

Cloudbeds Data Field	Description
ADR	Average Daily Rate of rooms sold calculated as Total Room Revenue divided as Total Room Revenue divided by Total Rooms Sold. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory Total Rooms Sold includes physical rooms only. *Complies with USALI standards.
Adults	Total number of adults associated with the room for a specific stay date.
Assumed Assignment Flag	Flag indicating if the room was booked without being assigned a room and was given an assumed assignment for reporting purposes. (Yes/No)
Booking Room ID	The ID of the room associated with the reservation.
Children	Total number of children associated with the room for a specific stay date.
Reservation ID	Unique identifier for each record in the dataset.
Reservation Number	The confirmation number that uniquely identifies a reservation.
RevPAR	Revenue per available room calculated as Total Room Revenue divided by Total Rooms Available. This includes room rate, manual room revenue, no-show fees, and manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory, Total Rooms Available includes physical rooms only. *Complies with USALI standards.
Room Guest Count	Total number of guests associated with the room for a specific stay date, including adults and children.
Stay Date	The calendar date being observed for analysis.

Converted Currency

Cloudbeds Data Field	Description
ADR (Converted)	Average Daily Rate of rooms sold calculated as Total Room Revenue divided by Total Rooms Sold converted using exchange rate. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory Total Rooms Sold includes physical rooms only. *Complies with USALI standards.
Miscellaneous Income (Converted)	Total of miscellaneous income including cancelation fees and their adjustments converted using exchange rate.
Other Revenue (Converted)	The total of revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees converted using exchange rate.
Other Revenue Adjustments (Converted)	The total of adjustments for revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees converted using exchange rate.
Other Room Revenue (Converted)	Total of all other revenue associate with the room posted by the user converted using exchanged rate. This value includes no show fees and is part of Total Room Revenue. Excludes inclusive and exclusive taxes and fees.
RevPAR (Converted)	Revenue per available room calculated as Total Room Revenue divided by Total Rooms Available converted using exchange rate. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory, Total Rooms Available includes physical rooms only. *Complies with USALI standards.
Room Rate (Converted)	Total of all Room Rate transactions posted automatically for reservations per stay date converted using exchange rate. Excludes inclusive and exclusive taxes and fees, manual room adjustments and add-ons included in rate plan packages as long as add-ons are setup properly in the PMS.
Total Fees (Converted)	Total of all fees, inclusive and exclusive, and any fee adjustments converted using exchange rate. This value does not include cancellation or no show fees.
Total Other Revenue (Converted)	Total of other revenue not categorized as room revenue excluding inclusive and exclusive taxes and fees converted using exchange rate. This includes items and services, add-ons, cancellation fees, adjustments.
Total Revenue (Converted)	Sum of total room revenue and total other revenue converted using exchange rate. This includes items and services, add-ons, cancellation fees, adjustments. Excludes inclusive or exclusive taxes and fees.
Total Room Revenue (Converted)	Calculated as Total Room Rate plus Other Room Revenue plus Room Revenue Adjustments convereted using exchange rate. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. *Follows USALI standards
Total Room Revenue Adjustments (Converted)	Total of room revenue adjustments including manual room revenue adjustments converted using exchange rate. Excludes inclusive and exclusive taxes and fees adjustments.
Total Taxes (Converted)	Total of all taxes, inclusive and exclusive, and any tax adjustments converted using exchange rate.

Finance

Cloudbeds Data Field	Description
Conversion Rate	The conversion rate that was used in the Converted Currency CDFs based on the currency specified in the report settings.
Original Currency	The type of money used to complete the transaction at the time it was made represented by a currency code (e.g., EUR for Euro).
Other Revenue	The total of revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees.
Other Revenue Adjustments	The total of adjustments for revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees.
Other Room Revenue	Total of all other revenue associate with the room posted by the user. This value includes no show fees and is part of Total Room Revenue. Excludes inclusive and exclusive taxes and fees.
Room Rate	Total of all Room Rate transactions posted automatically for reservations per stay date. Excludes inclusive and exclusive taxes and fees, manual room adjustments and add-ons included in rate plan packages as long as add-ons are setup properly in the PMS.
Total Fees	Total of all fees, inclusive and exclusive, and any fee adjustments. This value does not include cancellation or no show fees.
Total Miscellaneous Income	Total of miscellaneous income including cancelation fees and their adjustments.
Total Other Revenue	Total of other revenue not categorized as room revenue excluding inclusive and exclusive taxes and fees. This includes items and services, add-ons, cancellation fees, adjustments.
Total Revenue	Sum of total room revenue and total other revenue. This includes items and services, add-ons, cancellation fees, adjustments. Excludes inclusive or exclusive taxes and fees.
Total Room Revenue	Calculated as Total Room Rate plus Other Room Revenue plus Room Revenue Adjustments. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. *Follows USALI standards.
Total Room Revenue Adjustments	Total of room revenue adjustments including manual room revenue adjustments. Excludes inclusive and exclusive taxes and fees adjustments.
Total Taxes	Total of all taxes, inclusive and exclusive, and any tax adjustments.

Occupancy

Cloudbeds Data Field	Description
Adjusted Occupancy	Percentage of rooms sold divided by total rooms available. For properties with split inventory, Total Rooms Available includes physical rooms only. Blocked rooms and out of service rooms are removed from Total Rooms Available.
Allotment Blocked Rooms	Total number of rooms marked as Allotment Blocked. For properties with split inventory this will count physical rooms only by using the virtual to physical linked relationships defined in the PMS.
Blocked Rooms	Total number of rooms marked as Blocked. For properties with split inventory this will count physical rooms only by using the virtual to physical linked relationships defined in the PMS.
Capacity	Total number of rooms ("keys") that are available for sale at the property. No rooms are removed from this number unless they no longer physically exist at the property. For properties with split inventory this will count physical rooms only.
Occupancy	Percentage of rooms sold divided by total rooms available. For properties with split inventory, Total Rooms Available and Rooms sold includes physical rooms only. Blocked rooms and out of service rooms are included in Total Rooms Available. *Complies with USALI standards.
Out of Service Rooms	Total number of rooms marked as Out of Service. For properties with split inventory this will count physical rooms only by using the virtual to physical linked relationships defined in the PMS.
Rooms Available	Total number of rooms that are available for sale for a specific stay date. Sold, Blocked and out of service rooms are included in Rooms Available. For properties with split inventory this will count physical rooms only by using the virtual to physical linked relationships specified in the PMS.
Rooms Sold	Total number of rooms sold or booked from transient, groups or contract for a specific stay date. "No Shows" are not included in this number. For properties with split inventory this will count physical rooms only by using the virtual to physical linked relationships specified in the PMS.

Property

Cloudbeds Data Field	Description
Accommodation Kind	Indicates if the room is 'Physical' or 'Virtual' for properties using split inventory.
Organization ID	A unique identifier assigned to the organization for tracking.
Property ID	A unique identifier assigned to the property for tracking.
Property Name	The name of the property.
Room ID	Unique identifier for the room.
Room Number	The number or name that identifies the room(s) associated with the reservation.
Room Type	Name given to a group of rooms that share common physical characteristics and pricing.
Room Type Category	Shows if the room booked was either a private room or a shared room type.
Room Type ID	The database ID associated with a room type. Useful for merging data from other systems.

The Cloudbeds Data Fields described in the tables above appear in the Occupancy Reports. Click here to learn more about these reports.

Payment

Payment processing information, including charges, fees, chargebacks, reversals, etc.

Booking

Cloudbeds Data Field	Description
Card Type	The card type on file for the reservation (e.g., Visa, Discover).
Check-In Date	Date the reservation starts; when the guest arrives.
Check-Out Date	Date the reservation ends and the guest departs.
Group Profile Name	The master profile for a group of reservations, which may be associated with a group block.
House Account Name	Name of the house account associated with the transaction, used for registering transactions not connected to any specific room, guest, or reservation.
Inventory Object ID	A unique identifier assigned to each item or unit within the Account Receivable Ledger.
Inventory Object Type	A classification that defines the kind or category of the inventory item e.g Group Profile, House Account, Reservation, AR Ledger, etc.
Reservation Number	The ID automatically generated by Cloudbeds to uniquely identify reservations.

Primary Guest

Cloudbeds Data Field	Description
Primary Guest Full Name	Full name associated with the booking (first name and surname).

Finance

Cloudbeds Data Field	Description
Captured Amount	The amount that has been captured for a particular transaction.
Card Last 4 Digits	Last 4 digits of the card, needed for verification.
Payment Method	The method of payment used for transactions (e.g., Credit Card, Bank Transfer, PayPal).
Payment Type	The state of a payment transaction (e.g., authorized, refunded, voided).
Refunded Amount	The amount that has been refunded for a particular transaction.

Payment

Cloudbeds Data Field	Description
Card Created Date Time - UTC	The date the card was created, in UTC.
Card Issue Country Code	The country associated with the issuing bank.
Cloudbeds Payment Flag	Flag indicating if the processed transaction was a Cloudbeds Payment.
Payment Fee	The processing fee charged for the transaction.
Payment Fee Adjustment	An adjustment to the transaction fee, which includes interchange fees and may include other processing-related charges.
Payment Gateway Error Reason	Describes the reason for a failed transaction.
Payment Gateway Status	The status of the gateway processing.
Payment Gateway Transaction ID	The ID associated with the gateway request and response.
Payment ID	Unique identifier per row of records within this dataset, generated and used by the system.
Payment Net	The amount paid to the merchant, equals amount submitted minus fees.
Payment Entry Type	Flag indicating whether a transaction was processed or recorded.
Payment Schedule Date Time - Property	The date payment is scheduled to be processed, per the property's timezone.
Payment Schedule Date Time - UTC	The date a payment is scheduled to be processed, in UTC.
POS Entry Mode	The means by which the card information was captured.
Terminal Label	The merchant's name of the terminal.
Total Payment Fee	The sum of the processing fee and any adjustments.

Property

Cloudbeds Data Field	Description
Organization ID	The Cloudbeds ID associated with the property's organization.
Property ID	The Cloudbeds ID associated with the property, useful for integration with other systems.
Property Name	The name of the property.

Payout

Cloudbeds Data Field	Description
Payment Amount Submitted	The amount requested to be paid by the cardholder.
Payment Gateway	Name of the gateway processor.
Payout Amount	The total amount paid out to the beneficiary after deductions.
Payout Date	The date and time when a payout was created.
Payout ID	Unique identifier assigned to each payout.
Payout Status	The current status of a payout.

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 of the 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.

Bill From

Cloudbeds Data Field	Description
Bill From Address Line 1	Street address of invoice issuer.
Bill From Address Line 2	Second line of invoice issuer's address.
Bill From City	City of the invoice issuer.
Bill From Country Code	Country of the invoice issuer.
Bill From Email	Email of the invoice issuer.
Bill From Legal Name	Legal name of invoicer.
Bill From Name	Name of the business issuing the invoice, usually the property.
Bill From Phone Number	Phone number of the invoice issuer.
Bill From Postcode	Postal or zip code of the invoice issuer.
Bill From State	State of the invoice issuer.
Bill From Tax ID 1	Tax ID of invoicer.
Bill From Tax ID 2	Second tax ID of invoicer, used where applicable.
Property CNPJ	Brazilian ID of invoicer.

Bill to

Cloudbeds Data Field	Description
Bill To Address Line 1	Street address of entity receiving the invoice.
Bill To Address Line 2	Second address line of the entity receiving the invoice.
Bill To City	City of entity receiving the invoice.
Bill To Country Code	Country code of the entity receiving the invoice.
Bill To ID	Cloudbeds ID of invoicee (a guest ID or Group ID).
Bill To Party	Guest Name / Company Name.
Bill To Postcode	Postal or Zip Code of entity receiving the invoice.
Bill To State	State of the receiving entity.
Bill To Tax ID	The Tax ID of the Invoice, may be a guest tax ID or a company tax ID.

Invoice

Cloudbeds Data Field	Description
Credit Reason	Reason for the credit note.
Invoice Age - Invoice Date	The length of time the invoice has past the invoice creation date, in days.
Invoice Age - Payment Due Date	The length of time the invoice has past the invoice payment due date, in days.
Invoice Date Time - Property Time	Date the invoice or credit note was issued, based upon the property's time zone.
Invoice ID	Unique identifier per row of records within this dataset. This is generated and used by the system.
Invoice Number	ID associated with invoice or credit note.
Invoice Status	Status of the invoice, which can be Open, Paid, or Voided. Credit notes do not have a status.
Invoice Type	Invoice or credit note.
Original Invoice Date	Populated only for Credit Notes, Date the invoice was first issued.
Original Invoice Number	Populated only for Credit Notes.
Payment Due Date	Date the invoice must be paid by.

Invoice Items

The following are Multi-level Cloudbeds Data Fields (CDFs). To learn more about them, check out this article.

Cloudbeds Data Field	Description
Date Posted	Transaction date.
Description	Description of the transaction.
Invoice Item Amount	This field represents the transaction amount of each item within an invoice.
Invoice Item ID	The ID associated with the invoice item.
Invoice Item Quantity	This field represents the numerical quantity or count associated with each item or product within an invoice. It indicates the number of units or items being invoiced.
Invoice Item Tax Amount	This field indicates the tax amount linked to each individual transaction or item within the invoice, providing a detailed breakdown of the tax component for better analysis and tracking.
Invoice Item Tax Percentage	This field represents the percentage tax rate applied to each individual item within an invoice.
Invoice Item Tax Type	This field describes the type or category of tax applied to each individual item within an invoice.
Parent ID Link	ID linking Transaction with associated fees or taxes.

Invoice Totals

Cloudbeds Data Field	Description
Invoice Balance Due	This field refers to the remaining amount that needs to be paid by the customer for a particular invoice.
Invoice Currency Code	Currency used in the invoice.
Invoice Grand Total	The invoice grand total is the total amount of the invoice, including all charges and fees associated with the goods or services provided.
Invoice Total Tax Amount	This field represents the sum of all tax amounts associated with the invoice.

Property

Cloudbeds Data Field	Description
Organization ID	The Cloudbeds ID associated with the property's organization.
Property ID	Cloudbeds ID of the property.
Property Name	Name of property issuing the invoice.

Reservation

Cloudbeds Data Field	Description
Group Profile Name	Name of the group profile associated to the invoice.
Language Code	Code identifying the language of the invoice, for example, EN for English.
Reservation Booking Date Time - UTC	Booking date of reservation associated.
Reservation Check-In Date	Check-in date associated with invoice.
Reservation Check-Out Date	Check-out date associated with invoice.
Reservation Number	ID of reservation or group associated with invoice.
Reservation Room Nights	Length of stay associated with invoice.

Housekeeping

Room-level housekeeping information that includes front desk status, accommodation comments, and more.

Housekeeping

Cloudbeds Data Field	Description
Accommodation Comments	Notes for maintenance or other issues to be aware of for this specific room.
Do Not Disturb	The Do Not Disturb status of the room.
Estimated Arrival Time	The estimated arrival time of the guest.
Frontdesk Status	The Frontdesk Status of the room.
Housekeeper Assigned	The housekeeping staff currently assigned to clean or inspect the room.
Housekeeping ID	Unique identifier per row of records within this dataset. This is generated and used by the system.
Room Condition	Shows the current condition of the rooms, either dirty or clean.
Room Condition Last Updated Date Time - Property	When the Room Condition of the room was last updated, per the property's timezone.
Room Condition Last Updated Date Time - UTC	When the Room Condition of the room was last updated, in UTC time.
Room Count	The number of rooms.
Room Status	Shows whether the room is currently occupied by a guest or vacant.
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.

Property

Cloudbeds Data Field	Description
Organization ID	The Cloudbeds ID associated with the property's organization.
Property ID	The Cloudbeds ID associated with the property.
Property Name	The name of the property.
Room ID	A unique identifier assigned to each room in a property.
Room Name	The display name of a room.
Room Type	Room type, also known as Accommodation Type, is the name given to a group of rooms that have something in common, such as physical characteristics and are sold under the same price.
Room Type Abbreviation	A shortened name for the Accommodation Type.
Room Type Category	Shows if the room booked was either a private room or a shared room.
Room Type ID	The database ID associated with a room type, useful for merging Cloudbeds data with data from other systems.

Bed Occupancy

Contains bed-based occupancy and revenue metrics for properties that use shared or private room configurations with defined bed space values.

This feature is not enabled by default. If you’d like to use Bed Occupancy and Average Bed Rate (ABR) metrics in Insights reports, please contact our Support Team to request activation.

This setting is only available for physical accommodations. It is not supported for virtual room types. To learn more, see the Split Inventory article.

Booking

Cloudbeds Data Field	Description
Average Bed Rate	Average rate per occupied bed, calculated as Total Room Revenue divided by Total Guest Count.
Booking Date	The date when the reservation was originally made.
Booking Room ID	The ID of the room associated with the reservation.
Reservation ID	Unique identifier for each record in the dataset.
Reservation Number	The confirmation number that uniquely identifies a reservation.
Room Adult Count	Total number of adults associated with the room for a specific stay date.
Room Child Count	Total number of children associated with the room for a specific stay date.
Room Guest Count	Total number of guests associated with the room for a specific stay date, including adults and children.
Stay Date	The calendar date being observed for analysis.

Finance

Cloudbeds Data Field	Description
Conversion Rate	The conversion rate that was used in the Converted Currency CDFs based on the currency specified in the report settings.
Original Currency	The type of money used to complete the transaction at the time it was made represented by a currency code (e.g., EUR for Euro).
Other Revenue	The total of revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees.
Total Miscellaneous Income	Total of miscellaneous income including cancelation fees and their adjustments.
Total Other Revenue	Total of other revenue not categorized as room revenue excluding inclusive and exclusive taxes and fees. This includes items and services, add-ons, cancellation fees, adjustments.
Total Other Revenue Adjustments	The total of adjustments for revenue from items and services, custom items (POS), add-ons and adjustments for each excluding inclusive and exclusive taxes and fees.
Total Revenue	Sum of total room revenue and total other revenue. This includes items and services, add-ons, cancellation fees, adjustments. Excludes inclusive or exclusive taxes and fees.
Total Room Revenue	Calculated as Total Room Rate plus Other Room Revenue plus Room Revenue Adjustments. This includes room rate, manual room revenue, no-show fees, manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees.
Total Room Revenue Adjustments	Total of room revenue adjustments including manual room revenue adjustments. Excludes inclusive and exclusive taxes and fees adjustments.
Total Taxes	Total of all taxes, inclusive and exclusive, and any tax adjustments.
Total Fees	Total of all fees, inclusive and exclusive, and any fee adjustments. This value does not include cancellation or no show fees.
Room Rate	Total of all Room Rate transactions posted automatically for reservations per stay date. Excludes inclusive and exclusive taxes and fees, manual room adjustments and add-ons included in rate plan packages as long as add-ons are setup properly in the PMS.
Room Revenue	Calculated as Total Room Rate plus Other Room Revenue plus Room Revenue Adjustments.
Additional Room Revenue	Total of all other revenue associate with the room posted by the user. This value includes no show fees and is part of Total Room Revenue. Excludes inclusive and exclusive taxes and fees.

Occupancy

Cloudbeds Data Field	Description
Adjusted Bed Occupancy	Percentage of guests divided by total physical bed space capacity. Blocked rooms and out of service beds are removed from capacity.
Bed Capacity	Total number of physical bed spaces that are available for sale at the property. No bed spaces are removed from this number unless they no longer physically exist at the property.
Bed Occupancy	Percentage of guests divided by total physical bed space capacity. Blocked rooms and out of service beds are not removed from capacity.
Blocked Bed Spaces	Total number of bed spaces marked as Blocked due to the room marked as Blocked.
Out of Service Bed Spaces	Total number of bed spaces marked as Out of Service due to the room marked as Out of Service.

Property

Cloudbeds Data Field	Description
Organization ID	A unique identifier assigned to the organization for tracking.
Property ID	A unique identifier assigned to the property for tracking.
Property Name	The name of the property.
Room Type	Name given to a group of rooms that share common physical characteristics and pricing.
Room Type Category	Shows if the room booked was either a private room or a shared room type.

Reservation

Cloudbeds Data Field	Description
Market Group	Group that represents the type of business a hotel is receiving (Transient, Group, Contract)
Market Segment	A specific classification of the type of business a hotel is receiving within a Market Group (e.g., retail, government)
Rate Plan - Private Name	The internal rate plan name that is unique to the rate plan. If the reservation contains multiple rooms, the values are separated by commas.
Rate Plan - Public Name	The rate plan name that is visible to the customer. If the reservation contains multiple rooms, the values are separated by commas.
Reservation Origin	The specific third party that the guest chose to use to make their reservation, based on agreements between the hotel and that third party.
Reservation Source	The method used to make the reservation, such as phone, booking engine, or an online travel agency (OTA).
Reservation Source Category	The type of reservation source used, such as direct, group, wholesaler, or travel agent.

Not sure which report to use?

Use Cloudbeds Intelligence Explore to search or create the right report for your analysis—just ask the AI tool directly in natural language.
You can also review the Cloudbeds Stock Reports article to find predefined, ready-to-use reports available in your PMS for operational, financial, revenue, and occupancy analysis.

Find Cloudbeds Data Field Definitions in Report Builder (Glossary)

When creating or customizing reports in Cloudbeds Insights, you can easily check the definition of any Cloudbeds Data Field (CDF) using the built-in Glossary tool.

Create a new report or click Save As on an existing Stock Report — your custom versions will appear under Saved Reports.
In the Table Outline, click + Add to open a pop-up window where you can add CDFs directly.
In that pop-up, click Glossary (top right) to open the Glossary pop-up window.
In the Glossary pop-up, use the search bar to find any Cloudbeds Data Field and click the + icon to view its description (and add it, if needed).

💡 The definitions displayed in the Glossary are the same as those listed in this article.