Open Forum

Expand all | Collapse all

Report on Room Rates with Check in/out Dates

Jump to Best Answer
  • 1.  Report on Room Rates with Check in/out Dates

    Posted 08-11-2020 17:33
    We don't show any badge or hotel prices to any of our registrants, nor do we bill or collect any payment information from them in Cvent (we bill their companies separately later on based on the billing code each registrant give us), but we do enter the Hotel Room Rates when setting up the room blocks. To them, they're just indicating to us that they want to attend an event and that they need a badge (or not) and a hotel room (or not) and for what nights. No money is discussed via Cvent.

    But for when we're reconciling the 60+ page room block invoices we receive from hotels, how can we create a comparison report of all registrants, showing their name, Reg Type, Hotel Name, Room Type, Check in, check out, plus that person's Room Rate? If I have to do the actual calculation to find that person's total cost for their stay after it's exported to Excel, that's fine. 

    For example, I want this report in Cvent: 
    Full Name -------Reg Type ---------Hotel Name--------Room Type--------Room Rate----------Check in Date--------Check Out Date
    John Smith -------Full Conf-------Hilton Wash DC--------King Deluxe--------$467,59----------7/20/2020----------7/25/2020

    And while I'm asking, how could we assign fees to badge types but again keep them hidden from the registrant, but be able to export the badge choice & corresponding rate in a financial report.

    I searched the Cvent Community for an hour but didn't see this question addressed. Thanks!
    #ReportingandInsights

    ------------------------------
    Carrie Wetherby
    Delegate Manager
    touch Associates
    ------------------------------


  • 2.  RE: Report on Room Rates with Check in/out Dates
    Best Answer

    Posted 08-12-2020 09:54
    For the hotel report - I think the Hotel Request Details report would work for you,

    ------------------------------
    Jayne Ferro
    Support Staff Specialist
    NYSUT
    ------------------------------



  • 3.  RE: Report on Room Rates with Check in/out Dates

    Posted 08-12-2020 10:59
    YES YES YES YES. Oh my goodness thank you so much for calling my attention to that report. Thank you! That's where I can export more than I asked for, but exactly everything I need for reconciling hotel invoices. Amazing!

    ------------------------------
    Carrie Wetherby
    Delegate Manager
    touch Associates
    ------------------------------



  • 4.  RE: Report on Room Rates with Check in/out Dates

    Posted 08-12-2020 11:05

    I'm so happy I could help! So, I also use Admission Items for fees similar to your badge fees but I don't know if they can be completely hidden.

     

    Please note my new email address is Jayne.Ferro@nysut.org

    Jayne Ferro,

    Support Staff Specialist

    NYSUT Meetings and Facilities    

    800 Troy-Schenectady Road

    Latham, NY 12110

    518-617-0270

    CWA 1141 - Standing Together - Union Strong