In our Reporting section , you will find seven report types: Financial, Guests, Reservations, Occupancy, Payment, Invoices, and Housekeeping.
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.
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 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 Name | Name of the house account associated with the transaction, used for registering transactions not connected to any specific room, guest, or reservation. |
| 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. |
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. |
| 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. |
| Custom General Ledger Name | Name of the general ledger account to help users identify it. |
| Custom Transaction Code | Customized code by the property to categorize transactions and help identify their purpose. |
| 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 | Name of the person to whom the invoice was issued. |
| 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. |
| 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. |
| 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 | When the transaction occurred, per the property's time zone. |
| Transaction Date Time - UTC | When the transaction occurred, in UTC time. |
| 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. |
| 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). |
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. |
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. |
| 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. |
| Third Party Confirmation Number | Confirmation number from the OTA or travel agency. |
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 |
| 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
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 | 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. |
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.
Learn more about these reports here: Occupancy Reports.
Booking
| Cloudbeds Data Field | Description |
| ADR | The average daily rate for all rooms sold. |
| Adults | Total number of adults associated with the room for a specific stay date. |
| Children | Total number of children associated with the room for a specific stay date. |
| Other Room Revenue | Total of all manual and no-show transactions posted by a user, part of Total Room Revenue. |
| Reservation ID | Unique identifier for each record in the dataset. |
| Reservation Number | The confirmation number that uniquely identifies a reservation. |
| RevPAR | Total room revenue earned per available room during the reporting period. |
| Room Guest Count | Total number of guests associated with the room for a specific stay date. |
| Room Rate | Total of all Room Rate transactions posted automatically for reservations per stay date, part of Total Room Revenue. |
| Stay Date | The calendar date being observed for analysis. |
| Total Room Revenue | Room Rate plus Other Room Revenue. |
Occupancy
| Cloudbeds Data Field | Description |
| Blocked Room Count | Number of rooms marked as Blocked. |
| Capacity | Total number of rooms available for booking. |
| Courtesy Hold Count | Number of courtesy holds that have not yet been converted into reservations. |
| Occupancy | Percentage of Rooms Sold divided by Capacity, excluding Blocked and Out of Service rooms. |
| Out of Service Room Count | Number of rooms marked as Out of Service. |
| PMS Occupancy | Occupancy percentage displayed in the Cloudbeds PMS user interface. |
| Rooms Sold | Number of rooms sold or booked for a specific stay date. |
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. |
| Room Type | Name given to a group of rooms that share common physical characteristics and pricing. |
| Room Type ID | The database ID associated with a room type. Useful for merging data from other systems. |
Reservation
The following are Multi-level Cloudbeds Data Fields (CDFs). To learn more about them, check out this article.
| Cloudbeds Data Field | Description |
| Booking Date | The date when the reservation was originally made. |
| 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. |
| Reservation Status | Status of the reservation: Confirmed, Confirmed Pending, Cancelled, In-House, Checked Out, No Show, or Inquiry. |
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. |
| 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 Issue Country Code | The country associated with the issuing bank. |
| Payment Fee | A fee deducted from the payout for card processing and risk. |
| 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 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. |
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 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 ID | The database ID associated with a room type, useful for merging Cloudbeds data with data from other systems. |
Comments
Please sign in to leave a comment.