Travel guide
How to track travel days: methods, pitfalls, and the case for automation
The realistic options for tracking how many days you've spent in each country — spreadsheets, calendars, passport stamps, GPS apps — and the failure modes of each.
There are exactly five ways people track their travel days: passport stamps, memory, calendars, spreadsheets, and automatic apps. The first three break quickly. The last two work — but only one of them is genuinely low-effort. This guide walks through each method’s strengths and failure modes so you can pick the one that fits your travel volume.
Method 1 — Passport stamps
How it works: Look back through your passport at entry and exit stamps.
Strengths: Free. Official-looking. No technology required.
Failure modes:
- Schengen doesn’t stamp consistently for internal travel. Once you’re inside Schengen, you cross borders without new stamps. Stamps only mark entry into and exit from the Schengen Area as a whole.
- E-gates don’t always stamp. Many EU and UK airports now use e-gates that skip the physical stamp entirely. Your passport may look like you never traveled.
- EES (Entry/Exit System) is replacing stamps. From late 2025/2026 the EU is rolling out a biometric border system that records entries digitally and will eventually replace stamps for short-stay travelers.
- Stamps are illegible. Smudged, faded, in a script you can’t read. Try reconstructing your year from 14 stamps from 8 countries.
- You can’t track days you spent at a destination — only days of entry and exit. Calculating duration means matching stamp pairs, which fails the moment one stamp is missing.
Verdict: Useful as backup evidence; useless as a primary tracking system.
Method 2 — Memory
How it works: You remember roughly when you were where.
Failure modes: Memory of dates and trip durations decays measurably within months. By the time you need it (typically tax season or a border encounter), the resolution is “I think I was in Portugal in spring? Maybe two weeks?”
Verdict: Don’t.
Method 3 — Calendar lookback
How it works: Open your phone calendar, scroll back through the year, count travel events.
Strengths: Free if you already use a digital calendar that records your trips. Slightly better than memory.
Failure modes:
- Calendars track events, not presence. A “Lisbon meeting” on 12 May tells you nothing about whether you flew in on the 11th or the 12th, or when you left.
- You probably didn’t put every trip on your calendar. Especially weekends, family visits, layovers.
- Time zones make this worse. A flight event “Sat 22:00” can be in three different time zones; calendar dates can mislead.
- Counting requires manual aggregation across however many trips. Easy to miss a few.
Verdict: Works for “did I roughly travel a lot this year?” Doesn’t work for “did I exceed 90 days in Schengen on 14 August?”
Method 4 — Spreadsheet
How it works: Maintain a spreadsheet with columns for country, entry date, exit date, purpose. Calculate days per country and rolling windows with formulas.
Strengths: Free, precise, fully under your control, exportable. Works fine for low-volume travelers — 5 to 15 trips a year.
Failure modes:
- You stop updating it. This is the actual primary failure mode. Spreadsheets require ongoing discipline that decays exactly when life gets busy — which is exactly when you’re traveling the most.
- You enter the wrong date. Off-by-one errors in entry/exit days compound across a year.
- Schengen rolling-window math is nontrivial in a spreadsheet. You can do it (date columns, conditional sums on a moving 180-day window), but the formulas get gnarly.
- No multi-rule support. Each new tracking question (Schengen vs UK SRT vs Portugal vs US SPT) needs its own logic and its own column. Spreadsheets become unwieldy fast.
- Reconstruction is painful. If you fall behind for a quarter, catching up by digging through emails, photos, and bank statements is a real chore.
Verdict: The right answer for low-volume travelers with discipline. Becomes a liability at 25+ trips a year or once you’re tracking multiple regimes.
A practical template:
| Country | Entry | Exit | Days | Purpose | Notes |
|---|---|---|---|---|---|
| PT | 2026-04-12 | 2026-05-08 | 27 | tourism | Lisbon + Algarve |
| ES | 2026-05-08 | 2026-05-19 | 12 | tourism | Madrid + Granada |
Add a formula for cumulative Schengen days in the prior 180 days. Update on the day of every border crossing — not retroactively from boarding passes.
Method 5 — Automatic tracking
How it works: An app on your phone uses GPS to detect which country you’re in each day and stores the result. Schengen and tax-residency calculations run on the resulting record.
Strengths:
- Zero ongoing effort. No spreadsheet updates, no missed entries.
- Precise. GPS resolves the country accurately when you cross a border.
- Multi-rule. The same underlying day count answers Schengen 90/180, UK SRT, Portugal 12-month rolling, US SPT, and tax-year totals — without separate spreadsheets.
- Reconstructible. Multi-year history is preserved; if a tax authority asks for three-year-old day counts, you have them.
- Exportable. CSV for your accountant.
Failure modes:
- Battery use. Modern significant-location monitoring is low-impact (typically single-digit percent of daily battery), but it’s not zero.
- Privacy considerations. Done right (on-device storage, no servers) the privacy concern is minimal. Done wrong (cloud tracking with sale of data) it’s a problem.
- GPS edge cases. Border-zone GPS jitter can briefly misattribute, especially in small countries. Manual editing should always be available.
- Cost. Most automatic-tracking apps charge a subscription. The most-used iOS option is DaysAbroad ($2.99/mo or $69.99 lifetime).
Verdict: The right answer for anyone with 15+ trips a year, anyone tracking multiple regimes, or anyone for whom an incorrect day count would carry real financial consequences.
A decision tree
- 5 or fewer trips a year, all to the same country? Spreadsheet, or no tool at all.
- Visa-exempt traveler with 10–20 Schengen trips a year? Spreadsheet + the EU’s official Schengen calculator for periodic sanity checks. Or an automatic tool — the marginal gain is real.
- Digital nomad bouncing across Europe, 30+ trips a year? Automatic. Spreadsheets break at this volume.
- Anyone near a tax-residency threshold in any country? Automatic. The cost of a wrong count is far higher than any tool.
- Anyone running an active digital nomad visa across multiple countries? Automatic. The combined Schengen-plus-host-country math is non-trivial.
What to track, exactly
Whichever method you use, the minimum useful record per trip:
- Country code (ISO 3166 two-letter).
- Entry date (the calendar date the day-count regime cares about).
- Exit date (same).
- Purpose (tourism, business, transit, medical, personal) — matters for some immigration and tax questions.
Optional but useful: 5. Cities / regions visited (for ancillary tax questions in federations like Spain or the US). 6. Notes (purpose of trip, accommodation, anything you’d want a tax advisor to see later).
The pitfall that catches everyone
The thing every tracking method fails at — except automation — is the moment travel intensity increases. The shift from 5 trips a year to 20 is usually slow and gradual; by the time you realize you needed a system, you’ve lost a year of data and you’re reconstructing from receipts.
The right time to switch from manual to automatic is before you need it, not after.
Related reading
- What counts as a day for visa and tax purposes?
- Schengen 90/180 rule explained
- Schengen Calculator — free quick check
- 183-day rule by country
The single feature that makes automatic tracking work where everything else fails: it keeps running when you stop paying attention. DaysAbroad does exactly that — quietly, on your phone, every day.