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.

By Daniel Andrade, Zebra Labs Reviewed Informational only
Informational only. Not legal, tax, or immigration advice. · Last reviewed

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:

CountryEntryExitDaysPurposeNotes
PT2026-04-122026-05-0827tourismLisbon + Algarve
ES2026-05-082026-05-1912tourismMadrid + 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:

  1. Country code (ISO 3166 two-letter).
  2. Entry date (the calendar date the day-count regime cares about).
  3. Exit date (same).
  4. 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.

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.

Track from now

The next day still counts.

DaysAbroad tracks days per country in the background, with multi-year history, Schengen-aware math, and export. Free for two countries.