At home 03/07/26 is 3 July, but the hotel receipt from the American leg of your trip meant March 7. The fix is a three-pass sort: take the receipts you can date for certain, use your itinerary to anchor the rest, and settle what is left against your card statement before you enter anything.
Why did my spreadsheet put a date in the future?
Many spreadsheets read typed dates using your device's regional settings. A date typed in a format that does not suit your settings can be turned into a different day, or left as plain text that will not sort. The safest habit is to type dates as year, month, day, such as 2026-07-03, so the sheet has nothing to interpret.
Pass one: the receipts you can date for certain
Go through the pile and put aside every receipt where one of the first two numbers is above 12, or where a month name is printed. These are settled. In a typical pile that is enough to fix the first and last days of the trip, which helps with the next pass.
Pass two: anchor the rest with events you know
- Your flight dates and hotel check-in and check-out dates.
- A museum or event ticket that has its date printed in words.
- A pre-booked train ticket: it will be on your booking email with a plain date.
- Photos taken that day, because they carry a date stamp you did not have to type.
If a taxi receipt reads 04/06 and you were in the city only from 3 to 5 June, 4 June fits and 6 April does not.
Pass three: settle what is left against the statement
Say you have three coffee-shop slips for £4.20, £6.80 and £3.50, all with dates that could go either way. Total £14.50. Find the three card entries on your statement; a statement is written in the order your bank uses, so the charges will line up by amount and by sequence. Where a posting lags the purchase, the receipt date can still be a day or two earlier than the statement date. That is normal, so treat the statement as a range.
| Receipt | Printed date | Statement shows | Entered as |
|---|---|---|---|
| Coffee shop | 03/06/26 | £4.20 on 4 June | 2026-06-03 |
| Pharmacy | 11/06/26 | £6.80 on 12 June | 2026-06-11 (could also be 6 November, but the trip ended in June) |
| Bakery | 06/03/26 | £3.50 on 7 June | 2026-06-06 only if the trip fits; otherwise flag |
What if two receipts disagree with my itinerary?
Do not force them to fit. Record the date you believe, add a note such as printed 06/03, assumed 6 June, and flag the line. A flagged line is more honest and easier to fix later than a confident wrong date.
Should you record the receipt date or the statement date?
Keep two columns if you can: the purchase date, which is what you settled after reading the receipt, and the statement date, which is when your bank posted the charge. Use the purchase date when you total spending by month, and the statement date when you reconcile against your bank balance. A £212.00 hotel bill paid on 30 June and posted on 2 July sits in June for your budget and in July for your reconciliation, and having both columns shows why instead of leaving a puzzling gap.
A tidy way to finish
Once every receipt has a settled date, keep the foreign amount and its currency next to the pound amount charged to your card. SpendixAI can hold a different currency on each expense with totals in a base currency, but it is built around India and INR, so UK readers will mostly want a sheet using the same year-first habit.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


