ComparisonRecord keeping
Four ways to track your travel days
Four methods, four failure modes. Passport stamps are official and incomplete, and the EU is replacing them with the Entry/Exit System. A spreadsheet is exact and free, and only as good as your discipline. Calendar reconstruction is the cheapest and the weakest, because it is written after the fact. Automatic tracking is the most complete, and it records nothing while the phone is off or permission is denied.
How do passport stamps hold up as a record?
They prove a crossing and nothing else, and in Europe they are on the way out. A stamp records that an officer saw you at an external border on a date. It says nothing about the days in between, and there are no stamps at all between Schengen countries, which have abolished controls at their shared borders. Ink also fails: stamps get skipped at busy desks, land on top of each other, or become unreadable.
The gap inside Europe is structural. The Schengen area abolishes controls at the borders between its members, so only external crossings are recorded. Fly into Lisbon, drive through Spain and France, fly home from Paris, and the record holds two events for a trip that touched three countries.
Since 10 April 2026 the Entry/Exit System has been fully operational, after a rollout that began in October 2025, and passport stamps are being replaced by digital records of entries and exits for non-EU nationals on short stays. That is a real upgrade in record quality: the EES keeps entry, exit and refusal records for three years, and it does not smudge.
Its limits matter as much. The EES sees external Schengen borders only, so a drive from Spain to Portugal leaves no trace in it. It holds nothing from before it started. And you do not get a copy automatically: you have to request access to the data about you, or check the remaining-days figure through the official online tool. You also have the right to have inaccurate or incomplete records corrected, which is worth using the moment a missing exit scan makes you look like an overstayer.
Is a spreadsheet good enough?
For the arithmetic, yes. For the record, only if you keep it honestly and keep it up. A spreadsheet handles a rolling 180-day window and a per-country annual total without complaint, and it costs nothing. Its weakness is that it contains exactly what you remembered to type, and a day you never entered is a day the formula cannot count.
The rows that go missing are predictable: arrival and departure days logged as travel rather than presence, a weekend trip booked outside the usual pattern, a delayed flight that pushed a departure past midnight. Each is worth one day, and single days decide thresholds. There is also a rule problem. A spreadsheet built for Spain's calendar year gives the wrong answer for Portugal's rolling 12 months, and neither handles the UK midnight rule, which counts a day only if you are in the country at the end of it.
A spreadsheet is also weak as evidence on its own. Nothing about it is dated except the dates you typed. It carries weight when it is corroborated, which is why the useful version is a running log kept alongside boarding passes and card statements rather than a tab you open in March.
What is wrong with reconstructing from a calendar?
It records where you meant to be, not where you were. A calendar block usually starts at the first meeting and ends at the last one, which quietly drops the travel days at each end. It also drops anything that was never scheduled, and it inherits every plan that changed. Reconstruction is the method most people fall back on, and it is the one that most often produces a total five or six days below the truth.
Auditors know this, and they weigh records by when they were made. The New York nonresident audit guidelines put the burden squarely on the taxpayer: state regulation 20 NYCRR 105.20(c) requires anyone domiciled outside New York who keeps a permanent place of abode there and claims to be a nonresident to keep adequate records available for examination showing they did not spend more than 183 days in the state. The same guidelines note that taxpayers have met that burden through contemporaneously maintained diaries or calendars supported by credible testimony. The word doing the work is contemporaneously.
Where does automatic tracking fail?
Wherever the device stops observing. Automatic tracking writes a day down as it happens, which fixes the reconstruction problem, but it depends on a phone that is switched on, carrying location permission, and with you. Deny the permission and it records nothing. Leave the phone in a hotel safe, run the battery flat, fly with it in airplane mode across a land border, and the log keeps you in the last country it saw.
That last failure is the one to watch, because it is silent. A tracker that holds your last known country is right almost always and badly wrong on exactly the days that matter: a car crossing from Spain into France, a ferry, a train through a border with no checks. Nothing alerts you. The day count simply attributes three days to the wrong country, and it looks as confident as every other day in the log.
Two other honest caveats. It is a phone record, not a border record, so a tax authority reads it as supporting evidence rather than proof. And it starts the day you install it, which is no help for the year already behind you.
| Method | What it establishes | Where it fails | Effort |
|---|---|---|---|
| Passport stamps | A dated crossing at an external border, signed off by an officer | No internal Schengen borders, skipped or unreadable ink, nothing about the days between | None |
| EES record | Every external-border entry, exit and refusal for your passport, kept 3 years | External borders only, nothing from before it started, and you have to request access | One request |
| Spreadsheet | Whatever you typed, with arithmetic you control | The rows you forgot, and one rule hard-coded where you need several | Ongoing, manual |
| Calendar reconstruction | Where you intended to be | Travel days at both ends, unscheduled trips, plans that changed | One afternoon, once a year |
| Automatic app | Where the device was, day by day, written as it happened | Permission denied, phone off or elsewhere, and borders crossed while offline | Setup, then review |
Check the arithmetic against your own dates
The free Schengen calculator applies the rolling 180-day window to whatever trips you enter and shows the earliest date you could return.
How far apart do the methods land?
Far enough to change a tax year. Here is one traveller's 2026 Spanish day count produced three ways, with the same underlying travel.
178, 187, or 184
In February 2027 she needs her 2026 Spanish total. She starts from her work calendar and reaches 178 days, comfortably under the Spanish threshold of more than 183 days in the calendar year. Then she checks boarding passes and card statements.
| What the calendar missed | Days |
|---|---|
| Calendar reconstruction | 178 |
| Landed in Madrid on the evening of 14 March; the block started 15 March | +1 |
| Flew out on 30 June at 14:00; the block ended 29 June | +1 |
| The 11 October flight was cancelled and she left on the 12th | +1 |
| A weekend in Seville from 22 to 24 August, never in the calendar | +3 |
| Corrected total | 184 of 183 |
The reconstruction was five days short of safe and six days short of true. On 184 days Spain can treat her as tax resident for the whole of 2026.
Her phone had been tracking all year, and it said 187. The extra three came from a drive to Biarritz on 3 to 5 May with the phone in airplane mode, which left the tracker holding her in Spain across a border it never saw. Two automated records, neither correct on its own, and the true figure only appeared when the log and the tickets were read together.
Which combination should you actually use?
One contemporaneous day log as the spine, and documents as the cross-check. Record the country you were in each day while the day is happening, by app or by hand, and keep the boarding passes, leases and card statements that corroborate it. Then review the log against those documents once a quarter, which is when a missed border crossing or a forgotten weekend is still easy to reconstruct honestly.
Add the official records where they exist. In Europe that means requesting your EES entry and exit record; elsewhere it means the stamps you still get. And if you are relying on being tax resident somewhere else, get the certificate: Spain counts sporadic absences toward your 183 days unless residence in another country is proven, so the certificate is what stops the arithmetic from being reopened.
A day log written as the day happens
Staydays records the country you are in each day using low-power background location, keeps it on your iPhone and in private iCloud, and exports a dated report you can hand to an accountant.
This comparison is general information, not legal or tax advice. Rules change and individual circumstances differ. Confirm details with official sources or a qualified advisor.
Last updated: 2026-08-05