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 DateJohn 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
------------------------------