Booking.com reconciliation report and credit card reservation information
R
Robert Hacopian
started a topic
over 2 years ago
1 person likes this idea
Good afternoon,
I hope all is well. During the transition, Julia was kind to create a check-out report that listed all reservations under travel agents for checked-out guests(attached excel sheet #1). I took it a step further and added cancellations and no-shows, and eliminated all except Booking.com and created extra tabs for each category(checked-out, cancellation , and no-shows; excel sheet #2). Now I need your help. I am sure it is possible to add a field in Stay card(call it booking.com#, and if the 4th field in external references has a data, it can be copied in that field, and it can be inserted in this report as a Booking.com #). Also, is it possible to add a field in the Rate details window(from Rates and add-ons) for “Total Room Revenue” and insert in the report. These two items will reduce the reconciliation time for Booking.com immensely.
Also, As I stated before, Shift 4 was able to provide a reservation number that Opera implemented in their system, this helped to locate the charge in the Opera PMS with the appropriate guest. The new set up of Shift 4 has no guest information, no reservation number. Only the last 4 numbers of the card and the transaction date. Is it possible to insert SNT PMS confirmation number in Shift 4, so It will reduce the time to locate the charge, especially for disputes and chargebacks for a heavy volume of credit cards transactions that we process on daily basis. (Attached images 3 and 4)
Your cooperation and assistance in these two areas will help us reduce labor time, process financial transactions efficiently, and save valuable funds.
1 person likes this idea
Good afternoon,
I hope all is well. During the transition, Julia was kind to create a check-out report that listed all reservations under travel agents for checked-out guests(attached excel sheet #1). I took it a step further and added cancellations and no-shows, and eliminated all except Booking.com and created extra tabs for each category(checked-out, cancellation , and no-shows; excel sheet #2). Now I need your help. I am sure it is possible to add a field in Stay card(call it booking.com#, and if the 4th field in external references has a data, it can be copied in that field, and it can be inserted in this report as a Booking.com #). Also, is it possible to add a field in the Rate details window(from Rates and add-ons) for “Total Room Revenue” and insert in the report. These two items will reduce the reconciliation time for Booking.com immensely.
Also, As I stated before, Shift 4 was able to provide a reservation number that Opera implemented in their system, this helped to locate the charge in the Opera PMS with the appropriate guest. The new set up of Shift 4 has no guest information, no reservation number. Only the last 4 numbers of the card and the transaction date. Is it possible to insert SNT PMS confirmation number in Shift 4, so It will reduce the time to locate the charge, especially for disputes and chargebacks for a heavy volume of credit cards transactions that we process on daily basis. (Attached images 3 and 4)
Your cooperation and assistance in these two areas will help us reduce labor time, process financial transactions efficiently, and save valuable funds.
Thank you and warm regards,
Robert Hacopian
Accounting Department
Pod Times Square