To make a spend report for hotel bookings made through Booking dot com, gather your card and bank statements for the period, list every charge that matches the brand, and add a trip name to each line. Group the lines by trip and total them. For confirmations, invoices and changes to a booking, use the company's own account page or help page; we do not describe its menus, policies or prices.
Why do hotel bookings need their own report?
Travel spending arrives in lumps and at odd times. A stay can be paid months before you travel, or at the property when you check out, and a single trip often involves more than one charge. If you only look at monthly totals, a holiday spread over two months looks like two ordinary months. A report by trip shows the true cost.
How do you gather the lines?
- Start from the confirmations in your email and note the trip name, hotel, dates and the amount you expected to pay.
- Open the statements for every card or account you might have used and search for the brand name, then for the hotel's name, since some payments show the property.
- Copy each matching line with its date, amount and any currency shown.
- Match each line to a trip. Leave unmatched lines in a separate pile and check them against your inbox.
- Check the seller's own account page to confirm anything you cannot match.
What changes when the charge is in another currency?
Card statements for overseas or foreign-currency bookings often show the amount in rupees after conversion, and the original amount may appear on a separate line or in the description. Record both if you can: the foreign amount tells you the price, the rupee amount tells you what you paid. Your own statement is the source of truth for the rupee figure.
SpendixAI lets each expense carry its own currency, with totals in a base currency using the rate saved with each transaction. Choose the base currency before importing, because it cannot be changed once transactions exist. It also has a Foreign-currency spend report.
Worked example: a three-night family trip
| Line | Amount (₹) | Note |
|---|---|---|
| Advance payment for hotel | 9,600 | Paid two months before travel |
| Balance at the property | 5,400 | Paid on checkout day |
| Late-evening cab from station | 850 | Separate card line |
| Airport transfer back | 1,200 | Cash, added by hand |
The four lines total ₹17,050. Hotel lines alone are ₹15,000, which is 88 percent of the trip (15,000 divided by 17,050 is 0.8798). Seeing that split makes it easier to plan the next trip's budget.
Where can SpendixAI help with the report?
You can upload each statement as PDF, CSV or Excel, review the rows before saving, then categorise hotel lines as Travel or a sub-category of your own. Receipts can be kept with their transactions. The Report builder lets you filter and group, and you can download a CSV. We cannot promise every layout reads perfectly, so check the imported rows against the statement.
How do you compare trips fairly?
Divide each trip's total by the number of nights and the number of people. A trip costing ₹17,050 over three nights for four people comes to about ₹5,683 per night and about ₹1,421 per person per night (17,050 divided by 3 is 5,683; divided by 4 again is 1,421). Those two figures let you compare a weekend away with a longer holiday without being fooled by the totals.
Keep the unit consistent every time: the same split, the same inclusions. If one trip includes food and another does not, note it in a column so the comparison stays honest.
Closing checklist
- One folder per trip with confirmations, invoices and receipts.
- One list per trip with every payment, including cash.
- Foreign amounts noted next to rupee amounts.
- A repeat check a week after the trip for late or balance charges.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

