Export the card's transactions, keep only the rows between your two dates, and add up the amounts. That gives a total for one card and one period, which is all you need to judge a holiday, a month or a project. The sections below walk through it with a holiday as the example.
What are we trying to answer?
A couple who spent two weeks in Croatia, 12 to 26 July, used one shared card for almost everything. When they get home they ask a plain question: what did that fortnight really cost? Their other card paid for the rent and the usual bills, and those should be left out. One card, fourteen days.
Step by step
- Export the card's transactions as a CSV file from your account, covering the whole of July and a few days either side.
- Open it in Excel or Google Sheets and check that the date column holds real dates.
- Enter 12 July 2026 in G1 and 26 July 2026 in G2.
- Apply the formula below to list only the rows in range.
- Add a small total beneath, and compare it with the card statement.
With dates in A, merchant in B and amount in C, a list of rows between the two dates in Excel 365, Excel 2021 or Google Sheets is =FILTER($A$2:$C$400, ($A$2:$A$400>=$G$1)*($A$2:$A$400<=$G$2), "Nothing in range"). The total is =SUMIFS($C$2:$C$400, $A$2:$A$400, ">="&$G$1, $A$2:$A$400, "<="&$G$2).
Why do the dates sometimes look wrong?
Exports from different systems write dates in different orders, day first or month first, and a sheet set to another region can misread them. A date like 03/07 may become 7 March instead of 3 July. If the filter returns nothing or a strange set of rows, test one cell with =ISNUMBER(A2). A TRUE result means the sheet treats it as a real date; FALSE means it is text and needs converting, for example by splitting it with Data, Text to Columns.
What does the fortnight look like in numbers?
| Group | Examples | Total |
|---|---|---|
| Getting there | Flights, airport transfer | €486.00 |
| Where we stayed | Apartment deposit and balance | €640.00 |
| Food and drink | Restaurants, groceries, cafes | €392.50 |
| Day trips | Boat tour, park entry | €154.00 |
| Refund | Cancelled excursion | -€40.00 |
The total is 486.00 + 640.00 + 392.50 + 154.00 - 40.00 = €1,632.50, or about €116.61 a day over 14 days, since 1,632.50 / 14 = 116.607. Every figure here is invented; use your own.
What about spending that was in another currency?
A card used abroad shows a charge in euros on your statement, even though the shop priced it in another currency, so the statement is the figure to use. If the card also has the original amount, note it in a separate column in case you want to compare what you were charged with what the menu said. Keep this out of the totals so you do not count anything twice.
Could an app help?
If you already track expenses in SpendixAI, you can filter reports by account and date, and add cash spending by hand next to the card rows. It is built around India and INR and we do not claim it for euro cards, but the idea of one account plus one date range as a filter is worth looking for in any tool.
Splitting costs with a travelling companion
If one person paid and the other owes half, keep the report on the card first and settle up afterwards. Take the card total, here €1,632.50, and agree what is shared and what is personal. A column marked Shared, Mine or Theirs lets you total each with SUMIFS. Do the sharing arithmetic only once the card report is final, otherwise a late-posting charge forces you to redo both calculations. SpendixAI is not a bill-splitting tool, so a sheet is the right place for this step.
Quick check before you trust the number
- Does the total match the statement lines for the same dates?
- Did any pre-trip purchases, such as flights booked in May, fall outside the window? Decide whether they belong in the holiday total.
- Are there rows for a person you travelled with that should be shared out separately?
Useful ideas start with a clearer picture of your own spending.
Explore your reports

