These are the available options in grouping tab of Custom report:


All Unit Statuses: All room statuses of the reservation. Can be Booked, CheckedIn, CheckedOut, NoShow, Overbooking, Cancelled

Arrival: Arrival date of a unit

Company contact email: The e-mail of the company contact

Company invoice contact email: The e-mail of the company invoice contact 

Company name: Company name

Contact address: Adress of the reservation contact

Contact cityCity of the reservation contact

Contact country: Country of the reservation contact

Contact country code: Country code of the reservation contact (depends on Country of the reservation contact)

Contact email:  E-mail of the reservation contact

Contact mobile: Mobile of the reservation contact

Contact name:  Name and Surname of the reservation contact

Contact phone: Phone of the reservation contact

Departure: Departure date of a unit

Employee: Name of the employee that created the reservation

Event participant count: For reservations marked as events the number of participants of the event

Event responsible:  The event responsible, for reservations marked as events.

First guest country: Country of the first guest of the room

First guest country code: Country code of the first guest of the room (depends on Country of the guest)

First guest email: E-mail of the first guest of the room

First guest first name: First name of the first guest of the room

First guest last name: Last name of the first guest of the room 

First guest mobile: Mobile of the first guest of the room

Guest countries: Countries of all guests of the room 

Guest country codes: Country codes of the all guests of the room (depends on Country of the guest) 

Guest emails: E-mails of the all guests of the room 

Guest mobiles: Mobiles of the all guests of the room 

Guest names: First names and Last names of the all guests of the room 

Invoice company name: Invoice Company name

Invoice contact address: Adress of the reservation invoice contact

Invoice contact city: City of the reservation invoice  contact 

Invoice contact country: Country of the reservation invoice  contact 

Invoice contact country code: Country code of the reservation invoice  contact (depends on Country of the reservation invoice  contact)

Invoice contact email:  E-mail of the reservation invoice  contact 

Invoice contact mobile: Mobile of the reservation invoice  contact 

Invoice contact name:  Name and Surname of the reservation invoice  contact 

Invoice contact phone: Phone of the reservation invoice  contact 

Max Departure: The last departure date of the reservation

Min Arrival: The first arrival date of the reservation

Number of adults: Number of adult guests in the reservation

Number of children: Number of child guests in the reservation

Number of guest: Number of guests (both adults and children) in the reservation 

Number of infants:  Number of infants in the reservation

Offer code: offer code added to the reservation or item in the report

Offer title: Title of the offer code added to the reservation or item in the report 

Position: Extra or Service title, e.g. Housing, Breakfast, Coffee or similar. Each item is listed separately. So if you have a room booked for three days you will get three rows corresponding to this room

Position comment: Comment added to service or extra

Position cost excl. VAT: The price excl. VAT of the unit, service or extra. It will be price per item so if you want total price  you need to multiply by Position quantity

Position cost incl. VAT: The price incl. VAT of the unit, service or extra. It will be price per item so if you want total price  you need to multiply by Position quantity

Position date: The date of the service or extra. For extras and services added to the reservation it will be the date they have in the reservation, for units there will be one row per date the unit is booked. For hourly rooms there will be one row per hour

Position date & time: The date and time of the service or extra. For extras and services added to the reservation it will be the date and time they have in the reservation, for units there will be one row per date the unit is booked and time will be default check-in time. For hourly rooms there will be one row per hour, and the time will correspond to each hour.

Position month: The month of the service or extra. For units, extras and services it will one row for time they been added to the reservation. For units there will be one row per day the unit is booked

Position quantity: The number of items added

Rate optionrate option the unit is booked with

Reservation #: Reservation number

Reservation cancellation date: The date of cancellation

Reservation cancellation date & time: The date and time of cancellation 

Reservation change date: The last date the reservation was changed

Reservation change date & timeThe last date and time the reservation was changed

Reservation channel: Channel the reservation was booked with

Reservation date: The date the reservation was created

Reservation date & time: The date and time the reservation was created 

Reservation external reference: The external booking no. of the reservation

Reservation status: Status of the reservation, it can be Confirmed, Preliminary, Cancelled

Seller: the user that sold the reservation this field needs to be added in configuration

Travel Agency: Travel agency name

Unit: The booked unit (usually room number)

Unit category: The booked unit category

Unit employee: The employee that added the unit

Unit offer code: The offercode the unit was booked with

Unit offer title: The title of the offer that the unit was booked with

Unit rate option: The rate option the unit was booked with

Unit status:  The status of the specific unit. Can be Booked, CheckedIn, CheckedOut NoShow, Overbooking, Cancelled

Units: All the booked units of the reservation (usually room numbers)

Workflow phase: The workflow phase of the reservation