Reconcile Multi-Channel Car Rental Bookings
Learn how to export payment and reservation data from Causeway Malaysia HQ and reconcile orders across booking channels like Klook and Trip.com.
By Sameeha Rizan
This guide walks through exporting payment and reservation reports from Causeway Malaysia HQ and cross-referencing customer bookings across external distribution channels (Q2Q, Klook, and Trip.com) into a consolidated Excel sheet.
This procedure is intended for operations, fleet managers, and reservation dispatch staff performing daily manifest checks and booking reconciliations.
Sign In to Causeway Malaysia
1
Click the Username or Email field.
2
Select your saved credential rizansameeha@gmail.com from the autofill list.
3
Click Sign In.
Export Payment Data
4
Click the Bookings tab.
5
Click the date range selector 27-07-2026-27-08-2026 ▼.
6
Select start date 26 in the calendar grid.
7
Select end date 26.
8
Click Apply.
9
Click the Amount Paid summary card.
10
Click the table options menu III next to Payment Requests.
11
Click the Columns tab.
12
Toggle on Authorization Or Payment.
13
Toggle on Payment Type.
14
Click the Actions tab.
15
Click Export to download the payments spreadsheet.
Export Initial Reservations Report
16
Click Filter ▼ next to the search bar.
17
Open the Fields dropdown.
18
Select Last Payment Request Sent at.
19
Click the Value date range field.
20
Double-click 27 to set the target date filter.
21
Click Apply in the date picker.
22
Click Apply Filter.
23
Click the options menu next to New Reservation.
24
Click Export.
Organize Master Excel Workbook
25
Open File Explorer from the taskbar.
26
Navigate to Downloads.
27
Double-click the downloaded reservations file to open it in Microsoft Excel.
28
Click Enable Editing on the Protected View banner.
29
Click the top-left intersection corner to select all cells.
30
Press
Ctrl + C to copy the data.31
Click + to add a new worksheet.
32
Press
Ctrl + V to paste the reservation records.33
Double-click the sheet tab named Worksheet.
34
Rename the worksheet to Reservations.
35
Click the header for Column C to select it.
36
Click Insert in the ribbon to insert a blank column.
37
Open Sticky Notes from the taskbar search.
38
Copy the required formula or reference notes using
Ctrl + C.39
Click cell C2 in the spreadsheet.
40
Press
Ctrl + V to paste.41
Double-click the fill handle on cell C2 to autofill down the column.
42
Right-click Column C header.
43
Click Values under Paste Options to convert formulas to static values.
Cross-Reference External Booking Channels
QQ / Q2Q Bookings
44
Switch back to Google Chrome.
45
Click + to open a new browser tab.
46
Click the QQ Booking bookmark.
47
Expand the Booking menu in the sidebar.
48
Click Booking List.
49
Click Advanced Search.
50
Click Start Time under the Pickup Date filter.
51
Select date 26.
52
Click End Time under Pickup Date.
53
Select date 26.
54
Click Q Search.
Klook Merchant Portal
55
Click + to open a new tab.
56
Click the Klook Travel bookmark.
57
Clear the Booked date field.
58
Click Start date under Pick-up date.
59
Select 26 for both start and end dates.
60
Click the Status filter menu.
61
Select All.
62
Click Search.
Trip.com (cBooking)
63
Click + to open a new tab.
64
Click the Trip Booking bookmark.
65
Click Advanced Search V.
66
Click the Pick-up date start range field.
67
Select date 26.
68
Set the hour to 00.
69
Set the minute to 00.
70
Click OK.
71
Select end date 26.
72
Set the hour to 23.
73
Set the minute to 59.
74
Click OK.
75
Click Search.
Search and Match Customer Records in Causeway HQ
76
Right-click the renter name in Trip cBooking (e.g., JASPREET SINGH KOROTANA).
77
Click Copy.
78
Switch to the HQ Causeway Malaysia browser tab.
79
Remove the existing Last Payment At filter tag.
80
Right-click inside the search field Start typing a name....
81
Click Paste.
82
Click the row selection checkbox to verify the booking.
83
Return to the Order management | cBooking tab.
84
Right-click the next customer name (e.g., JINN LAU).
85
Click Copy.
86
Switch back to HQ Causeway Malaysia.
87
Right-click the search input field.
88
Click Paste.
89
Click the row selection checkbox for the matched record.
90
Switch to Order management | cBooking.
91
Right-click the renter name AFREENA ALIA.
92
Click Copy.
93
Switch back to HQ Causeway Malaysia.
94
Right-click the search input field.
95
Click Paste.
96
Click the row selection checkbox.
Export Final Pickup Date Manifest
97
Click Filter ▼ on the Reservations page.
98
Select Pickup Date under Fields.
99
Click the Value date field.
100
Double-click 26 to target the pickup date.
101
Click Apply.
102
Click Apply Filter.
103
Click the table options menu =.
104
Click Export to generate the final verified reservation report.
Q: Why should the Booked Date filter be cleared in Klook Merchant?
A: Clearing the Booked Date filter ensures you retrieve all bookings scheduled for the specific Pick-up Date regardless of when the customer originally placed the order.
Q: Why are formulas converted to values in Excel after filling Column C?
A: Pasting as Values removes dynamic formula references, locking in the data and preventing lookup errors when rows are sorted or filtered.
Term | Definition |
|---|---|
Manifest | A daily operating list detailing vehicle reservations, customer assignments, and pickup schedules. |
cBooking | The Trip.com supplier portal interface used by car rental operators to view and process incoming customer reservations. |
Payment Request | A payment tracking record generated in Causeway HQ indicating payment links, authorization status, and settlement method. |