Feature guide
Importing data
Imports are how your data gets into Tripwise. You upload CSV exports from your existing systems, and Tripwise takes care of processing, matching, and exception detection from there.
What you need to upload
Tripwise works by comparing three sources of truth against each other. For the best results, you should upload data from all three for the same time period:
Bookings
A record of every customer reservation — what was booked, the booking status, the supplier name, and the total value. This typically comes from your booking engine or reservation system.
Payments
A record of every captured payment transaction, linked to a booking. This typically comes from your payment provider — such as a Stripe, Adyen, or WorldPay export.
Supplier confirmations
Confirmations received from your suppliers — hotels, airlines, transfer operators, or any service provider — confirming that they hold a reservation for your customer. This may come from a supplier portal, a GDS export, or a parsed inbox feed.
You don't need all three at once
How to upload a file
- Click Upload in the top navigation bar, or click New import from the Imports page.
- Select the type of data you are uploading — bookings, payments, or supplier confirmations. Choosing the correct type is important: it tells Tripwise how to interpret the file.
- Choose your CSV file using the file picker and click Upload and process.
- Tripwise queues the file for processing. You are taken to the import detail page where you can track progress.
What happens during processing
Once you submit a file, Tripwise processes it in the background. You do not need to wait on the page — you can navigate away and come back. Each import moves through the following stages:
The file has been received and is waiting to be picked up for processing.
Tripwise is reading through your file, extracting each record, and running checks. Depending on file size, this usually takes between a few seconds and a couple of minutes.
Processing finished successfully. All records have been stored and any exceptions have been generated. The import detail page now shows the full breakdown.
Something prevented the file from being processed — for example, a column the system did not recognise, or rows with missing required information. The detail page will show an explanation. Re-check your export settings and try again.
Reviewing an import
Clicking any import from the Imports list opens its detail page. This is useful for checking exactly what Tripwise found in a specific file and whether it matched your expectations.
The detail page shows:
- Record counts — How many rows were in the file, how many were processed successfully, and how many bookings, payments, or confirmations were created from it.
- Exceptions from this import — All issues that were detected involving records from this specific file. This is a quick way to see whether a particular upload introduced new problems.
- The records themselves — A full list of the individual records extracted from your file, which you can browse to verify the data was read correctly.
Uploading the same file twice
A practical example
Your team runs a weekly reconciliation. On Monday morning, you:
- Export last week's bookings from your reservation system — around 400 rows.
- Export last week's payment settlements from Stripe — around 390 transactions.
- Export supplier confirmations received last week from your hotel portal — around 350 confirmation records.
- Upload all three to Tripwise, one after the other.
- Two minutes later, Tripwise has processed all three files and raised 18 exceptions. You navigate to the Overview page to see where to start.